SUMMARY:

• Overall 9 Years of experience in Information technology field with strong emphasis on Data Warehousing and Business Intelligence, which includes 9 Years of Development, Administration and Support solutions for Business Objects Data Services.
• ETL:
• Over 8 years of experience with SAP Data Services and data integrator as an ETL tool and also more than 6 years of SAP Data Conversion Experience.
• Installed and configured the Business Objects Data Services V.4.2/V.4.1/V4.0, Data Services XI 3.2 with SAP BI, ECC, SCM and CRM.
• Experience in installing and working with the Information steward 4.0.
• Expert in Data Services Data Quality (DQM) like address cleansing and data cleansing process
• Created the Repositories on Oracle 10g/11g, SQL Server 2012, and Linux and configured the Local, Profiler repositories with Job server and Management console.
• Strong understanding of RDBMS and Data warehousing concepts and Knowledge in Data mart development, ER Modeling and Data - Flow Modeling.
• Worked with Data Integrator, Quality and Platform Transforms.
• Extensively worked on development of mappings and worked with BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc
• Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Worked extensively on integration of Business Objects Data Services with SAP modules and non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2008/2012, DB2.
• Knowledge in SAP modules SD, MM, FI, and CO.
• Extracted SAP ECC Extractors data (SD, MM, FICO, CO PA) and loaded it into Enterprise Data warehouse. Developed various SAP BODS Jobs based on the delta extraction type of ECC extractors to setup the subscription for delta extraction process.
• Experience in Data Warehouse/Data Mart Multi-dimension logical/physical model design) for many industries such as Finance, Insurance, automobile, Utility Service and Manufacture. Extensively used Kimball dimension modeling.
• On HANA Database expertise on Data provisioning and transformation techniques, Modeling techniques, Security and authorization techniques
• Experienced in loading data from multiple sources to tables into HANA Database .
• Worked with ABAP dataflow and Data transports to extract the data from R3 tables.
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Expert in using LSMW, BDC's & IDOC's in loading data into SAP ECC 6.0
• Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO jobs.
• Used Data services XI 4.2 as an external system as ETL to extract data from ECC and BI for cleansing the data using Data Quality transforms.
• Worked with Open Hub Services to push data out of SAP BI using Data Services. Also
• Worked with Match and Associate Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Worked extensively with AIO (All in One) Templates and SAP ABAP.
• Worked on Profiling and Auditing in migration.
• Installed and have development work on the Information Steward and done some profiling tasks in data insight.
• Database: Worked with End-To-End implementation with Data warehousing team. Strong understanding of OLAP and OLTP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Rapid marts Implementation: Experience in Integration SAP suite of BI products with Business Objects including Business Objects Data Services (Rapid marts). Implemented Cost Accounting, Fixed Asset, Purchasing, Sales Analysis Rapid marts
• Implementation: Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Blueprinting, System Configuration, Data modeling, Unit testing, Integration testing, Cut-Over activities, Go-live strategies and Post Go-Live Stabilization Maintenance Activities.
• BW Development: Configured and Implemented BW reporting using BEx Analyzer and WAD (Web Application Designer). Development of Queries, Reports and Workbooks. Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters. Experienced in Development & Testing of Info Cubes, DSO’s, Aggregates, Hierarchies, Info Sources, Data Sources, Extract Structures, Enhancements, Info Set. Loading data from R/3 system from application specific data sources, generic data sources for master data, transaction data and flat file from third party systems to Info cubes and DSO in BI 7.0. Proficient and sound knowledge with Planning, Multidimensional data modeling using extended star schema, Design Implementation, and User Training of SAP Business Information Warehouse.
• BO Administration: Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Security design features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges
• Testing: Experienced in creating Test Scripts - Unit/Functional Integration using Mercury QA tools, creating Test Plans and End User Documentation and Training Materials. Prepared test scripts and test cases to validate data and maintaining the data quality.
• Good Communication and Interpersonal skills with the ability to interact with end-users, managers and technical personnel. Technically sound, Result-Oriented with strong Problem solving skills.
• Capable of working as a Team Member or Individually with minimum supervision. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies

TECHNICAL SKILLS:

BIETL Tools: SAP BI 7.0/3.5SAP BO Data Services 4.2/4.1,4.0, XI 3.2 SP1(Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2., SIA, Central Management Console, Central Configuration Manager, Designer, Tomcat, Apache

Data Modeling/Oracle Utilities: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader.

Databases: ORACLE 11.2/10g/9i/8i, DB2, Informix, MS Access, MSSQL Server 2005, 2008, 2012, Syspro, David database.

Languages: SQL, PL/SQL, ABAP, Java, C#, .Net, VB.net, C, C++

Web Technologies & Web Tools: Servlets 2.0, JSP 2.0, XML (XSDL, XSLT, SAX, DOM) HTML 3.2/4.0, IIS 4.0/5.0.

Operating Systems: UNIX, Linux version 3.0.13-0.27, MS-Dos, Windows NT 4.0/2000/ 2003/2008 r2, xp

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

SAP BODS Lead Consultant

Responsibilities Involved:

• Involved in the business requirement meetings to understand the Enterprise reporting requirements for designing new reports and dashboards.
• Assisted Business analyst in identifying KPI's and metrics for business processes and data improvement.
• Based on identified KPI’s developed/modified new and existing ETL jobs towards project completion.
• Profiled various information systems databases/applications and identified source/target mappings and transformations based on project requirements.
• Worked on Dimensional Modeling design using Kimball methodology.
• Worked independently, conducted assessments and meetings with client on SAP DS/IS capabilities. Worked on new initiatives and available features.
• Used all DI transforms such as Query, Validation, Case transforms as well as DQ transforms such as Match, Associate, Data Cleanse & Address Cleans.
• Extensively used SAP Business Objects Data Quality for addresses profiling, parsing, standardization, cleansing, matching for customer, product and material data.
• Worked on staging reference data from legacy systems as well as SAP ECC and used the reference data to lookup information required for SAP CRM loads, for Ex. Country description for country codes.
• Developed complex SAP Data Services job flows to extract from/load to SAP systems such as SAP ECC, CRM, SCM, BW, HANA as well as non-SAP systems such as Oracle, MS SQL Server.
• Loaded data into Customer master, Material master, and Vendor master using Vendor master -- DEBMAS, Product/Material Master -- MATMAS, and Customer Master - CREMAS IDOCS using SAP AIO business content and jobs.
• Extensively used IDOCS in loading the prerequisites objects, master data objects and transaction data objects.
• Extensively utilized BAPI to create and modify LSMW to load object using custom jobs.
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs.
• Implemented optimized techniques and tuned jobs for high volume and complex transformation scenarios.
• Configured additional DS components including job server and repositories.
• Created and configured DS data stores to connect to variety of data sources such as SAP HANA, SAP R/3, SAP BW, Oracle, MS SQL Server.
• Developed Map CDC jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, also loaded data to BW PSA
• Automated DS/IS jobs using in-built and third-party schedulers.
• Developed and executed advanced data profiling, data validation scenarios

SAP BODS Lead Consultant .

Responsibilities Involved:

• Integrated SAP suite of BI products with Business Objects including Business Objects Data Services (Rapid marts).
• Installed and configured SAP Data services 4.2 SP7 Client on SQL server environment in non-production and production environment. Created Local, Central and Profiler Repository with SQL Server 2012 and configured it with job server and management console.
• Installed the SQL Server 2012 R2 and created the Databases for Data Services and Repositories.
• Implemented Cost Center, Fixed Asset, Purchasing, Sales Analysis, Account payable, Account receivables, Production planning, General Ledger and Inventory Rapid marts for deploying rapid reporting solutions. All prebuilt rapid marts are customized based on business requirements.
• Prepared Dimension analysis, Kimball Bus Matrx and Data model as per requirements from FRD.
• Architected Chromaflo-CPS integration project and designed ETL process and guided a team of developers to meet demanding deadlines.
• Standardized the customer master and Material master data during the data integration of merger company.
• Initiated interaction with business and SAP functional resources to find the data integration requirements and modifications. Based on Business requirements and existing database structures developed ETL data mapping document.
• Developed the High-level and Detail-level documentation of the project.
• Worked with ETL programmers on implementing the Design of the project with Data mapping blue prints and also met project standards using proven data load tools and methodology.
• As a part of Chromaflo new acquisitions extracted data from multiple ERP systems (Microsiga of Brazil region, Syspro of china region, SAP ECC 6.0 of NFTA region, SAP ECC 4.6 of EMEA region, David database of south Africa region) and various CSV/Excel spreadsheets to Enterprise data ware house (SQL Server 2012) using several ETL tools.
• Developed SQL Server Cubes to extract the data as CSV files for loading data in the non-integrated server environment.
• Created Real Time Jobs and Nested Structures Using BODS.
• Created data store connection for several applications in BODS including the web services applications.
• Used Data Integrator to call external Web Services from within its jobs using a built-in web services adapter
• Strong SQL Server scripting skills. Capable of developing the complex SQL server structures and lookup tables which are used during the rapid mart process.
• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs to extract data as files.
• Developed Stored procedures and SQL Jobs to defrag and compress the SQL Server tables for performance optimization of database. In the process created/altered the indexes and partitioning of the database tables.
• Implemented Data services optimization techniques to improve the jobs performance. It includes the cache adjustments, bulk loading, commit row sizes, increasing the parallel processing, push down SQL, adjusting Look up techniques.
• Worked extensively on the COPA based timestamp type extractors for extracting the profitability business related information. Capable of maintaining and enabling of various delta type of SAP ECC extractors.
• Developed an Error handling technique to address the internal SAP BODS application bugs to enhance the stability of the SAP Business objects enterprise.
• Designed, developed, deployed and maintained universes using Business Objects designer, tableau. Installed and configured Business enterprise in a multi-tier environment.
• Created customized Web Intelligence reports from various sources of data. It includes major managements reports for sales by region, sales by market segment, sales by sales manager, sales by product hierarchy, sales by customer hierarchy.
• Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Security design features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges.

SAP BODS Consultant .

Responsibilities Involved:

• Installed and configured SAP Data services 4.1 Client on Linux environment in non-production and production environment. Created Local, Central and Profiler Repository with oracle 11g database and configured it with job server and management console.
• Installed the SQL Server 2012 R2 and SQL developer and created the Databases for Data Services and Repositories.
• Installed the All in One (AIO) Best Practices Projects, Data flows, Work flows and transformations and Data Quality (DQM) like address cleansing and data cleansing process.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform (to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
• Used the case, validation, merge transforms and lookup function to validate the customer master basic data (to find whether that record already exist in SAP or not).
• Implemented MATMAS IDOCS for loading new or updated custom ZASY and ZSRT materials from Legacy systems.
• Data cleansing by filtering the incorrect records and send the good data into the custom build warehouse by creating the Fact and Dimensional tables in Data Services.
• Created the Repositories, SAP data stores, read and modified the custom ABAP transformations, calling RFC’s BAPI’s, reading the SAP functions to Data Services.
• Migrated the Data Services code from DEV to Quality and Production systems using both Central repository and Atl files.
• Experience with Data Services Standard Rapid Marts for Cost Accounting, Fixed Asset, Purchasing, Sales Analysis extraction from ECC 6.0 to SQL Server 2012 database for building Enterprise DW project Reports.
• Resolved issues prevailing with the Standard Rapid Marts and applied the best practices to overcome the failures occurred during First and Delta Load.
• Created the SAP data stores and configured to have shared directory method to use ABAP transformations and SAP functions in the Data Services to extract Data out of SAP ECC 6.0.
• Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
• Used SCD type II for loading data in the Enterprise DW.
• Extensively worked on the new add-on on SAP BODS Extractors to load data to SQL server Database. In the process extracted SAP ECC Extractors data (SD, MM, FICO, CO PA) and loaded it into Enterprise Data warehouse.
• Worked extensively on standard and custom defined LIS and LO extractors (mainly on Sales and Billing Extractors)
• Developed an advanced strategy to capture the job execution, load statistics (Audit Statistics and check sum) values for enhancing and optimizing the quality of Load. As a part created the Global and Local Variable and customs SQL queries and implementing the Data Services based on client’s requirements.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects. Analyze and import the Source definitions and created target definitions, logical and physical designing of target tables.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Participate in developing best practices data warehouse standards for building Data warehouse and data modeling.
• Utilized several transformations in ETL jobs developed using Data Integrator including Date Generation, Effective Date, Table Comparison, History Preservation, SQL, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
• Extensively used lookup and lookup functions (lookup and lookup ext) to perform database lookups.
• Batch jobs configuration and set repository schedules using Data Services Management console.
• Involved in using Job Server in creation of real time jobs. As well as publishing batch reports and real-time jobs via web services.
• Strong understanding of XML, DTD, Web Services configurations in SAP Business objects data services.
• Stage the source data from flat files, SQL server, DB2 sources into stage tables.
• Migrated the Legacy data to SAP ECC 6.0 by using the Data Services Best Practices AIO methods by using IDOC methods.
• Expert in Installation and configuration of Information Steward 4.0, Data Insight, and AIO Templates.
• Worked with Information Steward to pre-assess the source system data and to develop data cleansing profiles, execute profile.

SAP BODS Lead Consultant

Responsibilities Involved:

• Interacted with project managers, business analysts and Business users to analyze business requirements and outline the proposed solution.
• Initiated DBA interactions for resource requirements and modifications.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Worked closely with the data modeler and given suggestions for the model feasibility.
• Participated in Data Mapping workshops and follow up meetings with the client business and IT teams. Assisted in the data mapping and Gap analysis between source and target data in BODS as per the blueprint.
• Installed and worked on the SQL server 2008 for the extraction of the source files.
• Extracted source files in the CSV file format from the SAP BW by creating cubes.
• Extracted source data from SAP BW 7.0 using the Data services as external tool.
• Loaded data from multiple source systems into the SAP BW 7.0 by creating RFC connection.
• Staged all data in the PSA Level based on the data mapping analysis.
• Installed SAP Business objects data services 4.0 and created Local repositories.
• Proposed Architecture and solution approach and developed the ETL design document.
• Participated in Design discussions and developed low level design specification.
• Worked on BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc
• Implemented SCD type 2 in the Data warehouse for the Dimension data.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations
• Developed Validation using validation transform, case transform jobs to validate source system to identify data errors in staging.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and Data profiling process.
• Developed test cases and implemented unit test and system integrated test. Jobs have run through test load Data and performed Data Validation and Data Reconciliation.
• Also, worked on the requirement gathering for the reporting and developed the mapping from the DW to report layout.
• In Developing a micro strategy report we used existing Microsoft Excel Live reports and templates as a reference to identified the metrics and later met with business user to identify calculation of them.
• Worked on the Micro strategy tool to design the Live reports, Dashboards.

SAP BODS Lead Consultant.

Responsibilities:

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings per changes in Business logic.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
• Participated in Data Mapping workshops and follow up meetings with the client business and IT teams. Assisted in the data mapping and Gap analysis between source and target data in BODS as per the blueprint.
• Designed and Developed High-level and Detail-level documentation of the project.
• Worked with functional teams closely to understand the gaps, coordinate with business on specific business rules, work with data conversion programmers on transformation rules and met project standards using proven data load tools and methodology.
• Worked on the technical details for transforming existing data onto Oracle DB using tools such as BODS & Microsoft SQL server 2008. Modified and created new data services jobs within the existing target system to meet the project requirements.
• Implemented SCD - Type I & II using normal transformations (Other than Table comparison and History Preserving) in Data Integrator to increase performance. As a part of optimization used MAP operations to route update and insert records in the DW by creating the necessary indexes and Implemented incremental load process.
• Designed and developed and done the unit test for all ETL routines in BODS.
• Created new mappings and updated old mappings per changes in Business logic. Performed major role in understanding the business requirements, designing and loading the data into data warehouse
• Used Business Objects Data Integrator to load data from source system to multiple target systems based on requirement (ODS, DART and Downstream)
• Initiated DBA interactions for resource requirements and modifications
• Used Business Objects Web Administrator to schedule and monitor Batch jobs
• Defined Target Load Order Plan for loading data into Target Tables
• Prepared Unit Test Cases.
• Migrated all ETL Jobs and Data Base (Microsoft SQL server 2008 and Staging) into Production from Development Environment.
• Handled several issues which came under production support.

SAP Data Migration Developer

Responsibilities:

• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
• Created the Local Repositories, Secured Central Repositories, Profiler Repositories using Sql server 2008 database and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3, CRM and BI by using transport codes.
• Move the projects from DEV to ST, ST to UAT and UAT to Production using ATL files.
• Scheduled the Jobs in Management Console.
• Participated in meeting with SAP functional team to prepare functional mapping and to give suggestion that, what we can achieve by using data services.
• Prepared the functional mapping to CREMAS, DEBMAS, MATMAS IDOCS and prepared GAP analysis.
• Created the data stores for SAP and Legacy (by using ODBC connection to underlying legacy data base which is DB2).
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Used the platform and data integrator transforms as a part of mapping.
• Worked extensively with Address cleanse (USA Regulatory certified address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in customer master, material master, vendor master.
• Used the case, validation, merge transforms in validation process.
• Worked on Enrichment process to give more detail level data to SAP.
• Prepared Excel sheets (reference tables for Legacy fields to SAP fields) and worked on the Excel sheets by building logical connection in File formats.
• Exposure to Data Services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
• Used the local repository metadata to build a universe (purpose is to generate reports on IDOC status and messages)

SAP Data Migration developer

Responsibilities Involved:

• Created the Local Repositories, Central Repositories, and Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3.
• Installed & configured Data Services XI 3.1 SP1 in Development & Production Server.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Extracted the data from IBM Main frames by creating data stores using ODBC connection based on the requirements.
• Gathered information’s for getting the mapping to load the data into Customer Master IDOC(DEBMAS06) in meeting with SAP functional team and Legacy team.
• Using AIO CUSTOMER MASTER JOB, created the job to load into customer master segments.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform (to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
• Used the case, validation, merge transforms and lookup function to validate the customer master basic data (to find whether that record already exist in SAP or not).
• Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
• Implemented the Data Enrichment step as per the AIO schema.
• Used WE05 transport code to check the IDOC status.
• Created the WEBI reports to generate the status of IDOCs using SQL Server database (repository tables).