SUMMARY

• 11 year of experience in the areas of Enterprise Data Warehouse, SAP Data Migration,
• Business Intelligence using SAP Business Objects Data Services, Information Steward, Data Quality, Informatica Power Center interface with various data sources.
• Involved in all phases of Data Migration and Software Development Life Cycle (SDLC) from various sources into Data Warehouses and Data Integrator /
• Data services with Business Objects EIM Suite.
• 6 years of experience on integration of Business Objects Data Services with SAP ECC MODULES (Finance, HR & CRM), SAP MDM, SAP Hana and Non - SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2008/2005/2000 , DB2, Mainframes, Flat Files and Legacy System files.
• Experience in Tuning ETL Jobs, Recovery Mechanism, and Error Handling and also set up validation rules, programming custom functions and pre-post load scripts to achieve complex business requirements and data validation.
• Experience in Data Migration with transformations, receiving and sending Idoc’s, /
• LSMW / BDC/ BAPI / RFC, data quality management using information steward and did extensive data profiling tasks in data insight.
• Experience in preparing functional requirements to technical / mapping documentation for best practice methodologies to Code review carrying Functional, Integration, Performance testing, the process for review and delivery documents.
• Experience in post-implementation, maintenance and enhancement support to the product / software application, Performed Pre Migration
• Assessment, Migration & Post Migration.
• Experience Data Management that includes providing architecture recommendations help define and manage data models, metadata management, and data integrations and ensuring availability, usability, integrity and security of the data.
• Good understanding Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling, ETL Design and Development, Reporting.
• Good understanding Data Governance, Data Quality Transformations like Match Transform, Data Cleanse Transform, Address Cleanse Transformations, Parsing and Standardizing.
• 3 years of experience with BI Reporting using Tableau, WebFocus, SAP BO (Web Intelligence, Crystal reports, Xcelsius) and SAP Integrated Planning, Creating Reports and Dashboards using RDBMS / OLAP Universe.
• Experience in installation, configuration and administrating the Data Services in load balancing cluster environment, repository in a multi user environment to Business Objects Admin part, CMS, CCM, Import wizard, User level access, security and restriction scenarios.
• Experience capacity sizing PAM and Data Service architecture, Recommendation on Hardware Sizing and Architecture.
• Creating Semantic layers using OLAP Cubes from scratch and integrating SAP BW & SAP Applications with BO and knowledge of working with Data modeling tools like ERWIN. Used DB tools like SQL Developer and TOAD.
• Working under the Agile methodology to meet aggressive deadlines.
• An enthusiastic and project-oriented team player with solid Communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Good understand of SAP Data Volume manager, SAP Solution Manager.

TECHNICAL SKILLS

ETL Tools: SAP BO Data services (BODS), Informatica PowerCenter.

Reporting Tools: SAP Business Objects, BEx designer (Web Application Designer), Web Intelligence, Xcelsius Dashboards, Live office, Crystal Reports.

Data Bases: Oracle, Sql ServerLanguages SQL/PLSQL. UNIX Shell Scripting

Workflow tools: MS-Excel, MS-VISIO, MS-PowerPoint, MS-Word

Operating Systems: Windows NT, Windows 2000 /XP, UNIX, Linux

IDE: TOAD

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Data Integration Consultant

Responsibilities:

• Responsible for implementing solutions to support organizations’ Information Management and Delivery needs of Business/Data Analysts, Data model and
• ETL development with hands on contribution as the situations demand.
• Worked with business users, reporting team in gathering and understanding data requirements.
• Define and utilize standards and best practices and documentation templates for BI DW development efforts.
• Developed end to end DW solution ‘Financial Reporting’ to support B/S & P/L management reporting along with decision support capabilities which allows timely access to financial data in SAP/ECC and Tidemark systems and facilitates use of division specific dynamic B/S P/L structures and help manage various businesses efficiently.
• Perform data profiling, data analysis, load data and develop customized data migration programs.
• Developed Data Services mappings to load the data warehouse, the mappings involved complex transformations rules in Data flows.
• Applied relevancy rules for each object to flag the eligible records for the load and generated Active and Inactive reports.
• Generated automatic pre-load and post load Invalid report and counts, Designed reusable scripts to handle data profiling at staging level.
• Creating dynamic error report on error data and analysis to provide inputs to business.
• Designed SAP Data services job to load from various sources, manually prepare Hierarchy files, SAP ECC / Coups into Financial Dataware house and Reusable BODS code components to load data from legacy source to SAP ECC.

Environment: SAP Business Objects Data services BODS, Oracle 12c, SQL Server 2008, SAP ECC, SAP BW, Web Focus 8.015, Tableau, Salesforce and Tidemark.

Confidential, Chicago, IL

Lead SAP BODS Consultant

Responsibilities:

• Requirements analysis and preparing Conceptual data models, gap analysis and associated solutions.
• Designed and developed functional specifications, technical specifications and Code review, Designed Logical, Physical models.
• Simultaneously worked in multiple projects for production support as onsite coordinator and also working with the Deployment team to design new interfaces.
• Experience in Data services administration and responsible for Installation and set-up of the data services as cluster environment for load balancing and data migration technical infrastructure, best practice migration content, strategy and standards.
• Experience capacity planning with product availability matrix and architecture, Recommendation on Hardware Sizing and Architecture.
• Coordination of offshore resources and objects, Post go-live support and optimizations. Worked on the existing interface performance tune.
• Provided BODS application development, support and maintenance for existing BODS interfaces.
• Analyze and Review, functional requirements captured into Data Migration Functional Specifications and Define the process for review and delivery of data migration documents.
• Developed complex interfaces jobs for various systems SQL Server, Oracle, Flat file, JDE, SFDC, SAP BW, SAP ECC and
• Salesfoce.com, Prepared mapping documents and designed jobs accordingly.
• Developed, published, and scheduled batch and real-time jobs using SOAP / Rest API, Web Service Call.
• Worked on the IDOC’S, Batch time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects using the
• Data Services Best Practices AIO methods by using IDOC methods.
• Implemented full life cycle implementations on SAP Migration projects, starting from Blue printing stage to Production.
• Experience in migrating all the Master Data Objects (Customer, Material, Vendor) along with transactional data by referencing the AIO Methodologies using IDOCS and LSMW When needed.
• Worked on the BW open Hub tables to extract the data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS using BODS.
• Used BW extractors as source, Used ABAP Data flows and Data Transport transform.
• Used LSMW to load the data fields that are not a part of standard IDoc, SAP R/3 4.6 Data Migration to build flat files that support the LSMW and BAPI and BDC programs.
• Extracted Data from all the Relational Databases including oracle, Microsoft SQL Server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Automated the BODS Tool to Audit, Validation, Tracing and debugging Batch job; Capturing changes in data (Initial/Delta load) using Table Comparison, History Preserving, Key Generation Transforms.
• Expertise in implementing Data Quality (Data Enrichment, De-Duplication etc.) using various components present in SAP Data Services and information steward.
• Extensively worked with Different Transformations like Table comparisons, Date generation, Key generation, Query, Merge, Map operations, Validations, Pivot etc.
• Experience in developing data migration interfaces to Salesforce.com
• Monitor and worked on fixing issues with daily autosys scheduled DW process jobs, performance tuning existing BODS jobs.
• Coding custom functions and scripts used in Data Services project along with standard data migration based on business/functional specifications.

Environment: SAP BODS 4.1/4.2, SAP HANA, MS SQL Server 2008, Oracle 11g, SAP BW, SAP ECC, Sales force, Windows

Confidential, Waltham, MA

SAP BODS Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed Source to Target Mapping as per the requirements.
• ETL Design (converting business functional specifications into mappings/workflows), testing and code migration to difference environment.
• Performance tuning using Recovery mechanisms for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows and data flows.
• Involved in writing DS scripts and also used some built-in functions and Custom Functions.
• Involved in System integration testing along with other team members using various source data scenarios.
• SAP Info Steward Data Insight to analyze data quality, data profiling and to define validation rules for data migration in
• Data services ongoing project to understand the quality of data before loading into the SAP.
• Experienced in scheduling and monitoring of jobs using DS management console during pre-production phases.
• Worked on Creating Repository and associating the Job server to it.
• Created Batch jobs using BODS ETL Tool to extract SAP and Non SAP Data and Build the EDW.
• Used Debugger to troubleshoot the mappings between source and target tables.
• Designed Business objects semantic layers (Universe) with SAP Warehouse and Non SAP warehouse.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis
• Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Created different reports containing charts showing revenue, booking, and backlog and operating income by different verticals and Company codes.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Environment: SAP BODS 4.0, Information steward, SAP ECC, SAP BO XIR4, MS SQL Server 2008, Oracle 10g, Sharepoint.

Confidential - Stamford, CT

SAP BODS Consultant

Responsibilities:

• This project is to create an ultimate repository of the accounting representation of all financial transactions.
• Working closely with Business Leaders to understand the requirement, Analysis on the requirements and Setting up Dev, UAT and Production Environment.
• Timely response to customer requests, No customer complaints on delivery or quality of deliverables.
• The development of feeds with ease according to the functional specification document.
• Involved in performance tuning and Unit testing and UAT Testing on every major release.
• Deploying into production and upgrading the production environment.
• Setting up the new security rules and regulations for User and Developers
• Creating complex workflows, promoting the code from one environment to another environment and Estimation planning, production support and bud fixed in release issues.
• Configuration of BODS, Repository creation and server management administration.
• Central Repository configuration and best practices for version control
• Scheduling the jobs and User Management in Management Console
• ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).
• Liaise with Business users and Business Analysts regarding requirements.
• Developed Source to Target Mapping as per the requirements and Data Integrator jobs to different repositories and code migration purposes.
• Migration the data from different GSAP servers to 1SAP Server to maintain all their operation from one system.
• Worked on Major Modules like Vendor Master and Designed the Data Migration Plan and implemented it in 1SAP Server.
• Involved in Migrating Legacy data from non-SAP systems to the SAP systems (SAP ECC\BW\CRM\FI).
• Developed code with standard IDOC’s for transformation of SAP extracted data and loading it to SQL Server Tables.
• Worked on the configuration part setup for IDOC generation from BODS to SAP.
• Created a load structure which can feed to SAP- LSMW loads.
• Worked on different versions to generate Flat file structure for LSMW and IDOC output files for SAP.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookup ext and Custom Functions whenever an exception is raised.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.
• Wrote shell scripts and control files to load data into staging tables and then into Oracle base tables.
• Developed Data Integrator jobs as per requirement.
• Worked on Creating Repository and associating the Job server to it.
• Involved in code enhancement, testing based on change request (CR) from end users.

Environment: SAP Business Objects Data Integrator / Data Services (BODI / BODS), SAP ECC, SAP BW, Business Objects XI Suite, MS SQL Server 2008, Oracle 10g, ER Studio, MS Access 2000.

Confidential, Foster City, CA

ETL Developer

Responsibilities:

• Analyzing the requirement specifications.
• Developed SQL queries to ensure loading of data, performed unit testing at various levels of ETL, developed and implemented the coding of Informatica Jobs.
• Debugged the Data flows by using debuggers and break points.
• Prepared Technical Specification and Resolution Document.
• Developed Source to Target Mapping as per the requirements and Data Integrator jobs to different repositories.
• Technical Unit Testing, Regression volume testing.
• Daily Monitoring of Active batch jobs which triggers BOBJ schedules.
• Developed encrypted scripts to automate nightly billing processes. These scripts were responsible for invoking programs that synchronized SAP parties.
• Coordinated with DBA Universe/ Reporting teams for day to day work.
• Followed client coding standards and SDLC.
• Working with the Internal ticketing system and keeping the delivery of tasks on time.
• Developed project documents which will be used in future by new or existing users to understand the scope of ETL designs/load processes.
• Handled ETL related issues and was quick enough to propose solutions.

Environment: Informatica PowerCenter 8.1.1, BOBJ reporting WEBI, SQL Server, Oracle 9i, Windows XP, UNIX, Tivoli and TOAD.

Confidential, Charlotte, NC

Informatica Developer

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, Windows XP, UNIX, MS Access, TOAD.

Responsibilities:

• Worked with heterogeneous sources from various channels like Oracle and flat files.
• Used Informatica PowerCenter Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, and Mapplet Designer).
• Used transformations Source Qualifier, Router, Expression, Aggregator, Lookup, Update Strategy, and Sequence Generator.
• Wrote SQL-Overrides in Source Qualifier.
• Implemented Slowly Changing Dimensions (SCD) Type II for maintaining history.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Created reusable transformations and used in different mappings.
• Developed incremental loading through Informatica mappings.
• Created simple cognos report studio reports as part of Console free solution.
• Created Cognos Framework Manager Model using stored procedures.
• Involved in fixing invalid mappings, testing of sessions and the target data.
• Used TOAD to evaluate SQL execution.

Confidential, Rockford, IL

Informatica Developer

Environment: Oracle9i, Informatica PowerCenter 7.1.1, SQL, PL/SQL, Toad.

Responsibilities:

• Extensively involved in System Study & Business Requirements Analysis, Translated business requirements into data mart design.
• Worked on Informatica PowerCenter tool Source Analyzer, Warehouse designer, Mapping and Mapplet Designer,
• Transformations, Informatica Repository Manager and Informatica Workflow Manager. The objective is to extract data stored in Oracle.
• The project involved extracting data from different data providers, transforming the data from these files before loading the data into target (warehouse) Oracle tables.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures.
• Designed and Developed complex aggregate, joins, look up transformation rules (business rules) to generate consolidated (data identified by dimensions using Informatica PowerCenter tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Experienced in source code promotion and version control generated with Rational ClearCase.
• Setting up Batches and sessions to schedule the loads at required frequency using PowerCenter Server manager.
• Generated completion messages and status reports using Server manager.
• Developed script, PL/SQL stored procedures, Triggers for automation of certain task outside Informatica box.
• Configured the sessions using workflow manager to have multiple partitions on Source data.
• Extensively Using the Debugger.