SUMMARY:

• Around 10 years of experience in Data warehousing - SAP Data services, Data Marts, Data Integrator, Data Cleansing (Address Cleansing), Data Profiling (Data Insight), Debugging, Performance Tuning, Business Objects installation experience.
• Experience in Installing, Configuring SAP Data Services and Information Steward 3.2/4.0/4.1/4.2.
• Experienced in requirement gathering, gap analysis and developed functional specifications, technical specifications and blueprint. Interacted with business users for the requirements of management reports & dashboards.
• Expertise in Design, Development and Deployment of Business Objects solutions for Corporate reporting requirements and involved in a full life cycle implementation of SAP BW/BOBJ/HANA
• End-to-end Business Intelligence optimization including Extract-Transfer-Load job design, HANA data modeling, Semantic Layer design, Web Intelligence report design.
• Expertise in SAP HANA Data provisioning using SLT Replication server & Sybase Replication server.
• Heavy ETL (Extract, Transform, and Load) and Data Profiling experience from source systems including Flat Files, Legacy systems and SAP using SAP Data Services (BODI/BODS 3.x/BODS 4.0/4.1/4.2).
• Used Data Services as an external system for ETL between ECC and CRM for cleansing the data using Data Quality transforms like Match, Associate, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Expert in designing and building high performance, complex HANA data models including Attribute, Analytic Views, Scripted/Graphical Calculation Views.
• Built Smart Data Access to get data from S/4 HANA to build complex models in Plan Vs Actual, Scrap Dashboard.
• Migrated data from disparate sources (Oracle, SAP ECC, SAP BW, HANA, JDE, SALESFORCE, Custom Extractors, Standard Extractors, XML, XSD, SQL Server 2008/2011, SAP HCM, etc) to SAP BW/SAP ECC/SAP HANA/Oracle.
• Expertise in developing calculated attributes, calculated measures, restricted measures, calculated columns, filters, variables, input parameters to satisfy reporting requirements using SAPHANAstudio.
• Ability to Design and Develop complex ETL solutions by translating design requirements into feasible, reusable and scalable technical implementations. Experienced in performing Audit and Error Management processes.
• Actively maintains and ready to gain new skills and experiences in the appropriate architect solutions.
• Well versed with importing metadata, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA IMCE (In Memory Calculation Engine) studio.
• Utilized Data Quality Blueprints and Data Integrator best practices templates to achieve Rapid Deployment Solutions.
• Expertise in SAP BOBJ Reporting functionalities such as Aliases, Context, Slice and Dice, Filters, Sorts, Ranking, Sections, Graphs, Query Prompts and Breaks.

TECHNICAL SKILLS:

Data Modeling & ETL: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling, SAP Business Objects Data Integrator XI 3.1/R2, SAP BODS 4.2, Business Objects Information Steward 4.2, 4.1, 4.0

Business Reporting: Business Objects XI, 4.1/4.0/.1/3.0/ XIR2/6.x, Tableau10.1/9.0, Microsoft Power BI, Central Management Console, Central Configuration Manager, Info view, Web/Desktop/OLAP Intelligence, Designer, Administrator, Dashboard Manager, Crystal Reports 2008/XI, Xcelsius 2008/4.5, Live Office, QAAWS, Import Wizard, Report Conversion Tool and Services, Scheduler.

Database Management Systems and Tools: Oracle 11i/10g/9i, DB2 8.2/8.0, MS SQL Server 2008/2005, MS Access 2000, Open SQL, SQL * Plus, PL/SQL and Oracle DBMS Packages, SQL Developer

Quality Assurance & Automated Testing: HP-Mercury LoadRunner, Quality Center, MS Project, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio TX

Senior SAP BODS/HANA Consultant

Responsibilities:

• Worked with business process owners, stakeholders to understand and document the requirements for CBS source system integration.
• Integrated SAP and Non-SAP Data through SLT and Data Services into HANA DB
• Built the data model for Delinquency reports and fed the data using SAP Data Services as the ETL solution
• Upgraded Data Services from 4.0 to 4.2 and Information Steward from 4.0 to 4.1.
• Integrated UC4 scheduler with BODS through Web Services.
• Presently supporting the production support for SAP Finance after going go-live
• Converted BW transformation logic to BODS.
• Used Data Services to get data from multiple Non-SAP Source systems to load it into SAP Hana.
• Worked on complex Data Services jobs to handle Sales force merging records.
• Worked with Business Object administrator to set up the architecture and standards for both Data Services and HANA.
• Measured performance of jobs and improved the execution times by using different techniques like Push-Down operation, Caching Data, Parallel Executions, Distributed Data Flow, Bulk Loading and Reading etc.
• Involved in hypercare activities for Conversion and Validation project.

Environment: SAP Business Objects Data Services XI 4.2/4.0, SAP Business Objects Information Steward XI 4.1/4.0, SAP BIP 4.1/4.0, SAP BW/BI 7.3/7.0, SAP ECC 6.0, SAP NetWeaver, Oracle 11g, SQL server, Windows 2008 server/XP.

Confidential, Detroit, MI

Sr. SAP Data Services/Hana Consultant

Responsibilities:

• Built HANA models for SAP SD, GL, FI-AR, FI-AP, Inventory and built reconciliation queries between SD, FI-GL and Inventory
• Worked with business process owners, stakeholders to understand and document the requirements for GTS source system integration.
• Integrated Account Receivables, Profit & Loss and Balance Sheet data for 13 different sources as part of GTS.
• Oversaw the BODS work done by offshore and peer reviewed the code before submitting it to the client.
• Trained the team members for Data Services.

Environment: SAP Business Objects Data Services XI 4.2/4.0, SAP Business Objects Information Steward XI 4.1/4.0, SAP BIP 4.1/4.0

Confidential, San Diego, CA

SAP BI/BODS Consultant

Responsibilities:

• Based on the Requirement, Extracted the data from different sources (Sybase, SQL Server, Flat files) and loaded into Oracle 9i.
• Created the Repositories using the repository manager and configured them with Job server.
• Modified the existing Universes according to the Specifications, which were from different data sources like Oracle/SQL Server.
• Created some POC Dashboards and discussed with client to finalize wat kind of Xcelsius components, functionality, filtering and color codes they need.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc. to develop the reports.
• Created Crystal Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Used the built in transforms (Data Quality, Platform). After loading data into Oracle 9i,used that data to develop reports and dashboards.
• Validating and Verifying Universes and Reports created by the Off Shore team and making the Necessary Changes if needed.
• Measured performance of jobs and improved the execution times by using different techniques like Push-Down operation, Caching Data, Parallel Executions, Distributed Data Flow, Bulk Loading and Reading etc.

Environment: SAP Business Objects Data Services XI 4.0, Business Objects XI R2/4.0, Crystal Reports 2008, Oracle 9i,, HP Mercury Quality Center

Confidential, Hershey, PA

SAP Business Objects/ETL Consultant

Responsibilities:

• Used Data Integrator client tool for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Business Objects Web Administrator to schedule and monitor ETL Jobs.
• Used Debugger to troubleshoot the mappings
• Designed Universes, incorporating all the business requirements.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Created Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created queries to extract data from Oracle database for multidimensional analysis using Slice & Dice and Drill up/down functionality.
• Created Universes, reports on Business Objects, Web Intelligence and deployed to the different users through Broadcast Agent server.
• Used Data Integrator client tool for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Part of the team in End-to-End Implementation of the Supply Chain Dashboard project, coordinating the offshore team on Teradata build during development phase of the project
• Preparing the Dashboard Architecture, relevant documentation and training materials, training the users in the post go live phase
• Involved in development and maintenance of Plant Management Dashboard used for monitoring plant performance metrics on a day-to-day basis for all business units.
• Drill down the Analytics to the detail level data by using the Web Intelligence Reports in Plant Management Dashboard
• Creating the objects, which include the dimensions and measures involving complex calculations.

Environment: Business Objects XI R3.1 SP2, Business Objects 4.0, Teradata, SAP BW, and Mercury Quality Center

Confidential, San Antonio, TX

ETL/BO Developer

Responsibilities:

• Gatheird the functional Requirements from the Business users, Supply Chain Analysts, Business Process Owners to build the Functional specifications, ensure the accuracy of the reporting specifications.
• Coordinated with the DBA to identify the data needs, extracting the data to the database.
• Implemented SCD - Type I & II using normal transformations (Other than Table comparison and History Preserving) in Data Integrator to increase performance.
• Created new mappings and updated old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
• Migrated all ETL Jobs and Data Base (Data Mart and Staging) into Production from Development Server.
• Designed generic data extractors to extract and transform the data to suit the Business Warehouse data model.
• Drill down the Analytics to the detail level data by using the Web Intelligence Reports in Plant Management Dashboard
• Creating the objects, which include the dimensions and measures involving complex calculations.
• Worked on implementing the Hierarchy’s, Pre-Defined Conditions, Resolving Data Base Connections and adding new objects to the Universes.
• Maintenance and enhancement of pre-built Universes and reports for the existing applications.
• Formulated project plan outlining scope, requirements and steps required to develop Crystal reports within specific timelines.

Environment: Business Objects XI R3.1 SP2, Business Objects 4.0, Teradata, SAP BW, and Mercury Quality Center

Confidential

Business Objects Developer

Responsibilities:

• Created basic and complex reports using Business objects 6.5. Analyzed the user needs and performed the duties of reporting according to their demands.
• Created reports using various data providers, including excel and text files, and made it available to users over Web Intelligence.
• Exhaustive report analysis using Slice and dice/ drill methods and by creating Master detail reports.
• Worked on Query Panel, Prompts, Report Layout and re-formatting.
• Involved in creating an E-mail Report Communication System where reports could be sent via E-mail to all or individual users.
• Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports to different environment within the organization.

Environment: Business Objects 6.5, Desktop Intelligence, Oracle, SQL, PL/SQL, ERwin and Windows NT