SUMMARY:

• 13 years of experience in IT industry in the areas of Analysis, Design, implementation, Development, and testing of Client/Server, Business Intelligence, Data Warehouse Applications (ETL/OLAP) and Business Objects Data Services.
• 10+ years of experience in using SAP Business Objects Data Services/Data integrator/Data quality, HANA, Information Steward, HANA, Reporting, ETL for Enterprise Data Warehouse / Data Marts, Rapid Marts for SAP and Oracle Applications.
• Business acumen around Finance, Insurance, Order Management, Manufacturing, Sales and Distribution.
• Worked in Data Warehouse development life cycle, requirement analysis, dimensional modeling, repository management, CRM projects and implementation of Star/Snow Flake Schema.
• Implemented Rapid Marts Manufacturing, SD and Inventory modules.
• Working knowledge of Information Steward, SAP HANA.
• Experience working with SAP HANA Studioand HANA Database.
• Experience in profiling and metadata management using information steward.
• Executing / Scheduling the SAP function modules/reports in background/foreground (to accommodate Job execution in the assigned time frame window) and monitoring the function modules’ execution to guarantee the successful population of Rapid Mart tables.
• Experience in using Information steward Data Insight and Match Review Module.
• Experience with SAP HANA data modeling using Attribute View, Analytical View and Calculation Views as per the requirement.
• Worked with flat files from SAP, efficiently using FTP to get/put the files from/to SAP R3 Application Server for the target table population and for other transformations and custom built ABAP Transforms.
• Worked on Sales Universe, developing reports for the users and mentoring the users in using the universe and developing adhoc reports.
• Proficient in Data Mart, ROLAP, Star Schema, Extract, Transform and Load of Data, Requirement Analysis, Design, Development, Testing. Documentation and Implementation of Business Applications.
• Used Information steward Match Review module to review the suspected records.
• Involved in Migration, day - to-day maintenance of BOBJ landscape.
• Involved in Administration tasks like Installation / Configuration / Up-gradation of versions of BO and Data Services components, User / User Groups, Data Profiling and Data Cleansing, Code Promotion / Version Management using Central Repository and usage of Metadata Reports to Document current data flows, design mappings for various sources/destinations of the data including data distribution and replication.
• Worked on Data services Objects / Transformations such as Data Flows, R/3 Data Flows, Query, SQL, Hierarchy Flattening, Validation, Flat File Format, Validation, Table Comparison, Map Operation., / Scheduling and Supporting Data Integrator Web Admin and Third Party Schedulers like Tidal / Error Handling and problem fixing in Data Integrator / Migration of code between environments Data Integrator Central Repository

TECHNICAL SKILLS

ETL: Business objects Data Services 4.1, 4.2, XI R 3.2 (12.2.0) BO Data Integrator 6.5, XI R1/R2

OLAP: Business Objects XI R4/R3, R2

Data Governance: Information Steward, Data Quality

Databases: SAP HANA, Oracle11g/10g/9i/8i, Sybase IQ 15.x, DB2 8.2.2, MYSQL, MSSQL Server2000/7.0/6.5&MS Access, Teradata. Netezza.

Tools & Utilities: LSMW, TOAD, PL/SQL Developer

Version Control: Rational Clear Quest, Rational Clear Case.

Languages: C, C++, SQL

Operating Systems: Win 95/98, Win NT, Win 2000, Win XP, SUN SOLARIS, UNIX AIX.

Packages: MS Office(2010) (MS Access, MS Excel, MS PowerPoint, MS Word and MS-Visio)

PROFESSIONAL SUMMARY:

Confidential, NC

Sr.SAP BODS/IS Architect / Admin / Lead

Responsibilities:

• Designed and developed Inbound Interface JOBs for Open Purchase Orders, Open Sales Orders, Inventory and Sales History by using XML as source and Idocs as Target.
• Performed address, dependency, redundancy and uniqueness profiling using information steward for data profiling.
• Designed and developed Out bound Interface JOBs for Purchase Orders, Purchase Requisitions and Product Planning with Forecast ECC table as source and XML as Target.
• Experienced in creating the rules using Information Steward scripting language in the Advanced Editor tab.
• Performed Code migration between the Environments by using ATL files and Cross Repository migrations.
• Performed user management activities like user roles assigning and setting security levels.
• Scheduled jobs in Quality and Production environments thru management console.
• Developed various scripts for automate the Delta process.
• Prepared job log monitoring document and error handling document.

Environment: Business Objects Data Services 4.2.x / 4.1.x, Information Steward, SAP ECC, Oracle 11g, SQL Server 2008/2012.

Confidential

Sr.SAP BODS/HANA/IS Architect / Admin / Lead

Responsibilities:

• Involved in Configuration and Design phases.
• Prepared Best practice Documents for landscape.
• Worked on repository management and user securities.
• Worked on metapedia category and on creating custom cleansing package using information steward.
• Implementing Match review configurations and tasks in Information steward to allow the data stewards to review the suspected records.
• Worked on Identifying and analyzing bad and monitoring data quality through SCORECARDS.
• Worked on Discovering data characteristics and data relationships, Creation and run the validation rules.
• Worked on the Information Governance initiatives.
• Worked on Cleansing Package Builder in processing data cleansing and data standardization.
• Gathered Business requirements for various Sources(Oracle, SQL Server, People Soft), Staging (Sybase IQ), Target(SAP HANA), reports and dashboards.
• Involved in SAP HANA data modeling using Attribute View, Analytical View, Calculation view, Decision tables, Virtual Tables, Procedures.
• Used Hana Smart Data Access to consume the cold data that has been archived in Sybase IQ.
• Created models that combine virtual tables and the physical tables to access both Hot and Cold Data.
• Experience with SAP HANA programming including SQL, SQL Script, and CE Script.
• Worked on SAP HANA administration including managing schemas, data model objects, import/export content.
• Worked on both Row storage and Column Storage tables.
• Experienced in Pre-Loading the tables into memory.
• Worked on SAP HANA Security including User Management, roles and Privileges.
• Worked on Visualize Plan and Explain plan to determine the Query Cost, CPU and Memory usage.
• Extensively worked on SAP HANA Analytical Privileges, granting access and restrictions to users on various views within the data modeling.
• Designed BODS jobs to Extract data from source systems to Staging database(Sybase IQ).
• Implemented various Transformation logics to transform the data in IQ.
• Developed BODS jobs to load the into HANA views.

Environment: SAP Business Objects Data Services 4.x, SAP HANA studio 1.0, Information Steward, Oracle 11g, Sybase IQ 15.x, SQL Server 2008/2012, Windows 2008 Server Enterprise and SharePoint.

Confidential, Stamford, CT

Sr. SAP BODS/IS Architect / Lead Developer

Responsibilities:

• Involved Landscape Design, Installations and Configurations.
• Repository Creation and Management in all the environments such as SANDBOX, DEV, QA, STAGING and PROD.
• Users and Groups creation and Management in all the environments such as SANDBOX, DEV, QA, STAGING and PROD.
• Configuring Information steward projects and connections in CMC to work with the Data Insight module.
• Participated in meetings and interviewing Business and Power users, to determine the sources, data Layout, Business needs, and naming conventions of the column and table names.
• Scheduling and Monitoring of SAP BODS job by using RedWood Scheduler (CPS).
• Worked in all phases of ETL development
• Identified and developed mapping logic for handling slowly changing dimensions.
• Worked on user defined functions and stored procedures, multiple transformations like SQL, Case, Query, Map Operation, Table Comparison, and Validation etc.
• Written scripts within the jobs to automate the process, parameter setting / initialization.
• Worked with Information Steward to pre-assess the source system data and to develop data cleansing profiles, execute profiles.
• Designed Logical, Physical models using SAP Sybase Power Designer.
• Designed views on top of the database for reporting needs.
• Evaluated the BODS Job execution status to guarantee the consistent performance and job dependency
• Involved in Administration Tasks like Up-gradation of versions of BO and Data Services components, User / User Groups, Code Promotion / Version Management using Central Repository and usage of Metadata Reports to Document current data flows, design mappings for various sources/destinations of the data including data distribution and replication.
• Worked on information steward, to define the data quality rules to bring the zero tolerance for duplicate records and developed dashboards, create and maintain cleansing packages.
• Create the Data Stores, Data Flows, Work Flows, Jobs and Projects following the Client Specific Naming Convention.
• Worked in implementing/customizing the SAP BODS Baseline Jobs.
• Worked on Identifying and analyzing bad and Monitoring data quality through SCORECARDS.
• Worked on Discovering data characteristics and data relationships, Creation and run the validation rules.
• Worked on the Information Governance initiatives.
• Worked on Cleansing Package Builder in processing data cleansing and data standardization.

Environment: Business Objects Data Services 4.1.x, Information Steward, Oracle 11g, SQL Server 2008/2012, Windows 2008 Server Enterprise and SharePoint, Redwood Scheduler (CPS).

Confidential, Savannah, GA

Sr. BODS/IS Consultant

Responsibilities:

• Involved in gathering of User Requirement and System Specification with Business analysts.
• Create the Data Stores, Data Flows, Work Flows, Jobs and Projects following the Client Specific Naming Convention.
• Worked in all phases of ETL development and Identified and developed mapping logic for handling slowly changing dimensions.
• Worked on user defined functions and stored procedures, multiple transformations like SQL, Case,
• Query, Map Operation, Table Comparison, and Validation etc.
• Written scripts within the jobs to automate the process, parameter setting / initialization.
• Worked with Information Steward to pre-assess the source system data and to develop data cleansing profiles, execute profiles
• Evaluated the BODS Job execution status to guarantee the consistent performance and job dependency
• Involved in Administration Tasks like Up-gradation of versions of BO and Data Services components, User / User Groups, Code Promotion / Version Management using Central Repository and usage of Metadata Reports to Document current data flows, design mappings for various sources/destinations of the data including data distribution and replication.
• Worked on Identifying and analyzing bad and Monitoring data quality through SCORECARDS.
• Worked on Discovering data characteristics and data relationships, Creation and run the validation rules.
• Worked on the Information Governance initiatives.
• Worked on Cleansing Package Builder in processing data cleansing and data standardization.
• Worked on information steward, to define the data quality rules to bring the zero tolerance for duplicate records and developed dashboards, create and maintain cleansing packages
• Worked in implementing/customizing the SAP BODS Baseline Jobs for tables like Customer, Material, BOM, Work Center/Resources, Recipes, Scheduling Agreements, Sales Orders, etc.,

Environment: Business Objects Data Services 3.2.x/4.1.x, Information Steward, Oracle 11g, SQL Server 2005/2008, Windows 2008 Server Enterprise and SharePoint.

Confidential, Saginaw, MI

SAP BODS/IS Consultant

Responsibilities:

• Designed the ETL Process for populating the physical data model.
• Designed and implemented the error table logic for all the fact tables thru ETL.
• Coded around 250 data validation checks as per the business logic.
• Prepared test cases to check data output from ETL.
• Data Validation implemented thru SQL code as well as thru ETL tool.
• Worked in defining process to integrate data from various SAP Sources for different countries.
• Define process to configure Lookup Tables and Cross Reference tables from SAP ECC System and Flat Files.
• Worked in defining process to export the integrated data from various systems into files for the Business-users’ modifications (Import/Export Process) and getting the modifications to the integrated data (Load Difference).
• Worked in customizing / defining process for De-Duplication, Filter, Validation, Data Cleansing and Enrichment stages to handle data from various source systems, apply validation rules and apply the enrichment rules.
• Developed Real-Time Job to receive IDOCs for BOMM changes on demand.
• Data validation of source files’ data.
• Did root-cause analysis for the data validation failed records.
• Reported data validation failed cases to the responsible team.
• Fixed bugs in the ETL code without any impact on delivery.
• Involved in Configuration / Installation / Up-gradation of BODS landscape and maintaining User / User Groups, Data Profiling and Data Cleansing, Code Promotion / Version Management using Central Repository.
• Reviewed performance, provided feedback and recommended appropriate actions for the development work assigned to the team.

Environment: Business Objects Data Services 3.2.x/4.1.x, Oracle 11G, SQL Server 2005/2008, Windows 2008 Server Enterprise and SharePoint

Confidential, CO

SAP BODS consultant

Responsibilities:

• Involved in interacting with business users in gathering the requirements.
• Analyzed the feasibility of the project, based on the business requirements
• Specifications to write, test, debug, document, and implement complex Batch jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Services.
• Defined database Data Stores and File Formats to allow Data Services to connect to the source or target database and files. Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g (SQL, PL/SQL).
• Involved in Data Modeling, Deployment of SAP Data Services, Data Quality and ETL Development using BODS
• Built complex ETL solutions using BODS to extract source data from Oracle, SQL Server, flat files and load it into Oracle based EDW (Enterprise Data Warehouse).
• Experience in cleansing data using proper data types and mappings.
• Tuned ETL Mappings and Transformations for the better performance
• Worked on Change Data Capture on both Source and Target level to implement SCD2 (Slowly changing Dimension)
• Migrated and executed ETL code in multi-level environment using migration and testing
• Used Data Quality transformationslike Global Address Cleanse, Data Cleanse tocleanthe incoming Clients addresses/data as per the inbuilt address dictionary.
• Involved in Installation and configuration of BODS Designer, different repositories (Local, Central, and Profiler), Job server, and Data Quality Address directories.
• Created reports using different data sources likeUniverse

Environment: Business Objects 3.x, Business Objects Data Services 3.x (12.2.2.x), Oracle 10g/11g, SQL Server 2005/2008, SQL, PL/SQL, TOAD, Flat Files, and Windows XP, Linux, Erwin, Redwood Scheduler.

Confidential, AR

SAP BODS / DW Consultant

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Translate the Functional/Business requirements into Detailed Design documents and then to ETL mapping documents.
• Designed the ETL Process for populating the data model.
• Designed and implemented the error table logic for all the fact tables
• Design and building of the data mart to handle KPI.
• Responsible for data profiling by using data services and data cleansing by using data quality.
• Conducted basic profiling and detailed profiling by using column analysis.
• Conducted relationship analysis to identify data mismatches between the columns.
• Worked on Data Consistency Issues, Data Cleaning using Profiling and View Data DI features.
• Analyzing data in source systems to assess data cleanliness and make recommendations for addressing within the source systems
• Used Data Quality to Address Cleansing, Data Cleansing and de-duplication based on the business rules.
• Worked in Installing and configuring data quality address directories to cleanse address related data.
• Implemented address cleanses transformation to correct and standardize the address.
• Implemented data cleanse transform to parses the names, data, phone numbers, SSN and e-mail address.
• Implemented match transformation to identify multiple occurrences and reduce duplicate data records.

Environment: Business Objects Data Services 3.x (12.2.x), Data Quality, SAP BW, Oracle 10g Toad / SQL Developer / PL SQL for Oracle, BO Xcelsius, Microsoft Office Visio

Confidential, CA

ETL BODS / BODI Consultant

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Translate the Functional/Business requirements into Detailed Design documents and then to ETL mapping documents.
• Creation of ETL Processes for the added newly Subject areas and developed ETL
• Extracting data from SAP application, SAP BW and stage them to data marts.
• Used Data Integrator to load data from different sources (Oracle, Text files) to the target database.
• Involved in creation of recoverable workflows during re-loading the data from source system.
• Involved in creation of local repository and associating job server to it.
• Involved in Performance tuning at source, transformation, and target levels.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Used Core FTP to transfer files to integration server.
• Responsible for Unit Testing and Fix the Issues.

Environment: Business Objects XI R2, Business Objects Data Integrator XIR2 11.5.x, Oracle 10g/9i, Toad / SQL Developer / PL SQL for Oracle, Clear Case, Clear Quest and Microsoft Office Visio.

Confidential, WA

ETL BODS Consultant

Responsibilities:

• Verification of functional specifications and review of deliverables
• Designed and developed mapping, transformation logic and processes for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Maintained the tracking versions of the code, documentation and recording all aspects of the application development life cycle.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data warehouse.
• Interpret the information from various operational sources and external system to create a road map for the Data warehouse designing.
• Extensively involved in creating database procedures, functions and triggers using PL/SQL.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Worked on writing Stored Procedures and packages. .
• Migrated large volumes of ETL data from legacy systems to Oracle database.
• Created Nested Batches and scheduled them for Daily Loads.
• Consolidation, Cleansing, Integration, ETL, and customization of data.
• Optimized Query Performance, Session Performance and Reliability.
• Complex SQL queries are used for data retrieval.
• Used Business Objects, BO Query Designer and Report Designer.

Environment: Business Objects Data Integrator 6.5.x, Business Objects 6.5.x, Erwin Data Modeling, Unix, PL/SQL, SQL plus, Oracle 9.x/8.x, TOAD and Sun Solaris 2.7.

Confidential

SQL Developer

Responsibilities:

• Involved in design, development and implementation of the module.
• Developed Stored Procedure to support front-end application.
• Tuned stored procedures and triggers identified for better performance.
• Created Tables, constraints and indexes to improve database performance.
• Involved tuning and applying the SQL statements and PL/SQL processes.
• Involved in Production Support.
• Created different kinds of reports on Tables, Views, and Synonyms from the Oracle Database.

Environment: Oracle 7, MS Access, MS Excel, PL/SQL, HTML, CGI, C, C++, Sun Solaris, Windows 98.