Name : Mr. ABC
Email : BC.ITLM@gmail.com
Ph: xxxxxxxxxx
Current Job: SAP HANA Developer in ITLM,IND
PROFESSIONAL
PROFILE
• Total 7.9 years of experience in
IT Projects & Operation Management
• Holds excellent interpersonal, communication and analytical skills with demonstrated abilities in
customer relationship management
• Strong problem solving & Technical Skills coupled with confident decision making for enabling effective
solutions leading to high customer satisfaction as well as low operational costs.
• Currently working with Angel Broking as Sr. Manager
• Holds excellent interpersonal, communication and analytical skills with demonstrated abilities in
customer relationship management
• Strong problem solving & Technical Skills coupled with confident decision making for enabling effective
solutions leading to high customer satisfaction as well as low operational costs.
• Currently working with Angel Broking as Sr. Manager
AREA
OF EXPERTISE
• Well verse with SAP HANA
Administration, Performance Optimization, Modeling using Different types of
views, SQL, SQL Script topics
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAP HANA Architecture.
• Worked on BO 4.0 like Information Design Tool, Interactive Analysis Desktop and Launch Pad.
• Expert in data modelling and provision & Well verse with semantic layer
• Expertise in SAP BW (Business Warehousing, BW Administration, BW Extractors, ODS, InfoCubes, InfoSources, InfoObjects,and BEx Reporting), SAP Applications Integration with non SAP systems.
• Expertise in Back end Business Warehouse Components Extractors (LO Cockpit, Generic Extraction with in BW System, LIS and non R/3 extraction), Performance (Aggregates, BW Stats, Partitioning), Production Support (Process Chains,info package groups) Front end Business Warehouse Components Queries, Calculated keyFigures, restricted keyFigures, Structures, Variables, RRI (Report to Report Interface), BEx Analyzer, BEx browser.
• BW configuration, ETL background and InfoCubes design, Performance and tuning, strong on End to End BW Configurations and Customizations from Extraction, Staging, Loading, Transport, and Reporting through BEx Analyzer, and Performance.
• Extensively worked in Business Information Warehouse Info cube, ODS Objects, Infosources, Info objects, Transfer rules, update rules, Extractors, Infosources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains Technical
• SAP HANA Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAP HANA Architecture.
• Worked on BO 4.0 like Information Design Tool, Interactive Analysis Desktop and Launch Pad.
• Expert in data modelling and provision & Well verse with semantic layer
• Expertise in SAP BW (Business Warehousing, BW Administration, BW Extractors, ODS, InfoCubes, InfoSources, InfoObjects,and BEx Reporting), SAP Applications Integration with non SAP systems.
• Expertise in Back end Business Warehouse Components Extractors (LO Cockpit, Generic Extraction with in BW System, LIS and non R/3 extraction), Performance (Aggregates, BW Stats, Partitioning), Production Support (Process Chains,info package groups) Front end Business Warehouse Components Queries, Calculated keyFigures, restricted keyFigures, Structures, Variables, RRI (Report to Report Interface), BEx Analyzer, BEx browser.
• BW configuration, ETL background and InfoCubes design, Performance and tuning, strong on End to End BW Configurations and Customizations from Extraction, Staging, Loading, Transport, and Reporting through BEx Analyzer, and Performance.
• Extensively worked in Business Information Warehouse Info cube, ODS Objects, Infosources, Info objects, Transfer rules, update rules, Extractors, Infosources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Characteristics and Key figures, Business Content, Data Marts, Process Chains Technical
KEY
COMPETENCIES & SKILLS
SAP HANA SP04, SAP BI 7.0, SAP
BO 4.0, SAP BODS
Software Products : SAP HANA
Studio, SAP HANA Information Composer
Admin Tools : SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploader
Data Provision: Excel, SAP BO Analysis for Office, SAP BO office, SAP BO Analysis for OLAP, Business
Reporting Object Explore, Information Design tool : HANA SQL scripting, Javascript
Language Tools : SAP HANA Database, SQL 2005 and 2008
Admin Tools : SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploader
Data Provision: Excel, SAP BO Analysis for Office, SAP BO office, SAP BO Analysis for OLAP, Business
Reporting Object Explore, Information Design tool : HANA SQL scripting, Javascript
Language Tools : SAP HANA Database, SQL 2005 and 2008
Database Tools
Employer : ANGEL BROKING (POC HANA
Project)
Period : From Oct 2012 to Till Date
Period : From Oct 2012 to Till Date
Angel Broking want to implement SAP
HANA for Risk Management application to get instant overview of Stock Market
condition. It will help to risk management analysis to square off the
client position as well as the portfolio Manager to instant decision
Environment: SAP HANA 1.0, SAP BO
4.0, MS SQL 2008, Asp.net
Responsibilities
• Involved in information gather
phase
• Migrated MS SQL Database into SAP HANA
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to
reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications
• Migrated MS SQL Database into SAP HANA
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to
reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Developed Web Services for SAP HANA database and deliver to ASP.NET developers to consume data in .net based applications
Employer : ANGEL BROKING
Period : From April 2008 to Sep 2012
Period : From April 2008 to Sep 2012
Environment: SAP BI 7.0, SAP ABAP/4,
SAP R3 ECC 6.0, CRM, SD,, PL/SQL, Net Weaver, Oracle 10g
Responsibilities
• Understood and converted Technical
Specifications from Functional Specifications
• Modeled and built Infocubes, DSO, Infosets, and Multiprovider according to reporting requirements
• Loading of master/transactional data from flat file as well as from R/3 system
• Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions
• Prepared Technical Specifications from Functional Specifications
• Wrote test conditions from the functional specification
• Prepared and uploaded Allegro and PNC Lockbox files using FTP and validation through SAP Background Batch jobs
• Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction
to BI enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD
• Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability
• Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP
• Created Virtual Provider (Remote SAP Cube) using Direct Access DTP and developed quick reports from Datasource directly
• Used BEx Query Designer as a Front End Tool to build Queries and Reports
• Loading of master and transactional data from R/3 system worked extensively on the transaction data and master data user exits on R/3 by using RSAP0001
• Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads
• Extensive usage of administration workbench (RSA1)
• Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.
• Scheduled SAP background Batch Jobs using REDWOOD. REDWOOD is a batch job scheduling tool from SAP
• Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37)
Angel Broking ltd, Mumbai (Jun’05 – March ’08) as Asst. Manager Ecommerce Worked on .net technology from classic asp to .net 4.0. Developed lots of asp.net related projects which were web based and desktop based applications. If require then produce separately.
• Modeled and built Infocubes, DSO, Infosets, and Multiprovider according to reporting requirements
• Loading of master/transactional data from flat file as well as from R/3 system
• Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions
• Prepared Technical Specifications from Functional Specifications
• Wrote test conditions from the functional specification
• Prepared and uploaded Allegro and PNC Lockbox files using FTP and validation through SAP Background Batch jobs
• Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction
to BI enhanced the extract structures by adding new fields and populating them with the user/function exits in CMOD
• Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability
• Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP
• Created Virtual Provider (Remote SAP Cube) using Direct Access DTP and developed quick reports from Datasource directly
• Used BEx Query Designer as a Front End Tool to build Queries and Reports
• Loading of master and transactional data from R/3 system worked extensively on the transaction data and master data user exits on R/3 by using RSAP0001
• Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads
• Extensive usage of administration workbench (RSA1)
• Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.
• Scheduled SAP background Batch Jobs using REDWOOD. REDWOOD is a batch job scheduling tool from SAP
• Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37)
Angel Broking ltd, Mumbai (Jun’05 – March ’08) as Asst. Manager Ecommerce Worked on .net technology from classic asp to .net 4.0. Developed lots of asp.net related projects which were web based and desktop based applications. If require then produce separately.
0 comments:
Post a Comment