SUMMARY

• 10+ years of Experience in BI technologies as a Business Objects Consultant with a skill set of SAP BOXIR3.1/XIR3/XIR2/6.5/5.1.7, BO Designer, DeskI, WebI, InfoView, Dashboard, Scorecards, CMC, Xcelsius 2008/Crystal Xcelsius 4.5, Crystal Reports 2008/XI/10/9, DataServices 4.1/4.0/3.1/Data Integrator XI, Information Steward 4.0, Oracle 11g/10g/9i, Teradata 6.0, SQL Server 2016/2012/ 2008/2005/2000 , Microsoft Access 2000
• Over 9 years of experience in SAP BO Data Services.
• 3 years of experience in SAP Information Steward.
• 1.5 year of experience in SAP HANA Modelling.
• 4 years of Experience in Agile Methodology.
• Good understanding on SAP BO Data Services concepts which involves creation of complex Jobs, Workflows, Data Flows, Writing Scripts and using different Transformations to successfully load data from multiple sources into a desired target
• Proficiency in DataWarehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture
• Extensively used DataServices Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
• Experience in DataWarehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading using SAP Data Integrator/SAP Data Services with Oracle, SQL Server
• Experienced in ETL Methodologies using Business Objects Data Integrator Services XI 3.1 with IDocs, Data Quality, Data Profiling & RapidMarts and worked on Metadata Integration (BOMM - Business Objects Metadata Manager)
• Experience in gathering business requirements and building Universes, Reports and Dashboards
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness, applied row level and object level securities on different groups and users using Business Objects Designer
• Created ad hoc, canned reports and tested the reports in full-client and Webi environment for migration purposes, scheduled and published the reports using Broadcast Agent
• Hands on experience in Migration from 6.5 to BO XIR2 and BO XIR3
• Expertise experience in using CMC to Maintain Objects, Universes, Connections, Resources, Users, User Groups, User Restrictions and Categories in BO XI R3
• Worked with Crystal Reports 2008/XI/10/9 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports
• Experienced in creating InfoCubes using SAP BW 3.1/3.0B
• Excellent understanding of DataWarehouse architecture, Star Schema, Snowflake Schemas, Fact and Dimensions Tables
• Knowledge on Microsoft SSRS reports and Hyperion EssBase

TECHNICAL SKILLS

BI: SAP BO XIR3.1/XIR3/XIR2/6.5/5.1.7, Universe Designer, DeskI, WebI, InfoView, CMC, Crystal Reports, Xcelsius, Import Wizard, Broadcast Agent, Tableau 10.1, SQL Server Reporting Services(SSRS)

ETL: BODI (Data Integrator XI), SAP Business Objects DataServices XI 4.1/4.0/3.1, Pentaho BI Suite, Pentaho Kettle, Schema Workbench, Pentaho Analyzer, Pentaho Enterprise Console, Pentaho User Console, Pentaho Data Integration Designer / Kettle, SQL Server Integration Services(SSIS), Microsoft Visual Studio

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000 , Teradata 6.0, IBM DB2, MS Access 2000

Modeling: Erwin, Toad 9.7.2/8.2/8.0

Languages: C,C++, HTML, XML, CSS, TSQL,PL/SQL

OS: Windows NT, Windows XP Pro/2000 Server, UNIX

ERP: SAP ECC 6.0 (MM, SD, SCM, FICO, HR), SAP BW 7/4.5/3.1/3.0 B, Oracle Applications, Workday HCM

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. SAP BODS/Data Warehouse Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Worked on IBM InfoSphere Data Replication Management Console to replicate the data from Source System Informix to EDW Staging tables using Informix to Oracle subscriptions. Oracle to JMS subscriptions are developed to generate the XML’s from the EDW staging tables which in-turn were processed by the real time jobs.
• Worked on the Bankruptcy and District, real time ETL jobs to populate the CMECF Data Warehouse on ORACLE using the XML’s generated by the Oracle to JMS subscription in the IBM Infosphere Data Replication Management Console.
• Worked on the Source to target mapping documentation.

Environment: SAP BO Data Services 12.1.2.0/14.1.1.0 , Oracle 11g, SQL Server 2016, Oracle PL/SQL, TFS, MS Office Suite and Linux server.

Confidential, Alexandria, VA

Sr. SAP BODS Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Worked on the Momentum upgrade. Analyzing the ETL impact based on the upgrade and modifying the ETL.
• Implemented SCD type1 and type2 using SAP BODS.

Environment: SAP BO Data Services 14.1.1.0, Oracle PL/SQL, Tableau 10 MS Office Suite and Linux server

Confidential, Washington, DC

Sr. SAP BODS/Data Warehouse Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Modified the existing JIFMS ETL subject area. Worked on the ETL enhancements for the JIFMS.
• Worked on the Source to target mapping documentation.

Environment: SAP BO Data Services 12.1.2.0/14.1.1.0 , Oracle PL/SQL, MS Office Suite and Linux server.

Confidential, Alexandria, VA

Sr. SAP BODS/Pentaho/Tableau Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Created Metadata model, which was deployed over the database layer, Pentaho metadata editor was used to achieve this and to create user roles/ project mapping.
• Used Kettle to build the ETL process from data sources to data mart, as well as scheduled the transformations and jobs.
• Worked on the Patents subject area.
• Worked on the MLogs to capture the CDC of the source systems.
• Modified the existing legacy code of patents in PL/SQL to pull in the new data as per the requirements.
• Optimized the patents PL/SQL existing code.
• Developed ETL jobs for the FEDMT subject area using SAP BODS.

Environment: SAP BO Data Services 14.1.1.0, Oracle PL/SQL, MS Office Suite and Linux server.

Confidential, St. Paul, MN

Sr. SAP HANA/SAP Data Migration Lead Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Profiled the source systems data using Information Steward.
• Worked with Data Stewards on implementing the rules on Source tables and published the rules.
• Created cleansing packages using the Information Steward.
• Extracted Data from legacy systems using SAP BODS.
• Record to Report, Marketing to Order, Order to Cash and CRM business process data has been loaded in to the SAP from the legacy systems.
• Loaded data from SAP tables into SAP HANA using the SAP BO Data Services.
• Worked on the Data Provisioning Feature of SAP HANA to replicate the data real time onto SAP HANA using SAP HANA SLT.
• Creating Control Flow, Data Flow Tasks, Workflow and Event Handlers at required intervals using SQL Server Agent.
• Generated Periodic reports, Optimized reports, Drill through reports, Dill down reports, linked reports and Parameterized reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created the Attribute, Analytic and Calculation information views to capture the required data for the reporting needs.

Environment: SAP BO Data Services 14.1.0.0, SAP Information Steward 4.1, SAP HANA SP 8, SQL Server 2008, PeopleSoft, Datacom DB, MS Office Suite and Windows Server 2008/2003, Microsoft SQL Server Suite of Products(SSIS, SSAS, SSRS), TFS

Confidential, Rochester, MN

Sr. SAP BO Data Services Lead Consultant

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Extracted data from different source systems like IDM, Gateway, Nexus, MayoEDH, and Expert RN.
• Built a Data warehouse to support the reporting requirements needs using the SAP BO Data Services. Created T-SQL procedures, views and triggers as a part of data extraction in addition to SAP BODS to handle complex ETL.
• Worked with SQL Server CDC.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (Packages, attribute views, analytic views, and calculation views graphical).
• Created, tested and executed entity relationship schemas, table creation, Indexing, Primary Key, Unique Key, Foreign Key, Default, Check constraints, Sequences, Views, and Queries.
• Worked with Information Steward on profiling the source systems.
• Implemented the rules on the source tables and the quality of the data is represented on the dashboard.
• Worked with Data Stewards on cleansing the source systems based on the failed data in the Information Steward.

Environment: SAP BO Data Services 14.0.0.0, SAP HANA SP 6 SQL Server 2008, MS Office Suite, TFS and Windows Server 2008/2003

Confidential, Knoxville, TN

Sr. SAP BO Data Services Consultant/Admin

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Extracted Vendor and Customer master data from SAP R/3.
• Implemented the rules against the data by using inbuilt Data Services transformations.
• External Web Service has been invoked using the Data Services to validate the vendor VAT numbers in SAP.
• Newly created Data Flows for each rule have been added to the existing ETL job.
• Documented the ETL specification and migration document.
• Created connections in CMC for the information Steward
• Performed column profiling and Address profiling using the Information Steward on SAP Master Data like vendor and customer for the business to understand the quality of source data.
• Evaluated SAP HANA product on an In-Memory appliance can boost the Business Reporting needs by doing a POC. Extracted SAP CO-PA data from SAP ECC into SAP HANA as part of the evaluation.

Environment: SAP BO Data Services XI 14.1.0.0/14.0.0.0 , Information Steward 4.0, SAP ECC R/3 (MM, SCM), SAP BW 7, SQL Server 2008, MS Office Suite and Windows Server 2008/2003

Confidential, Miami, FL

Sr. SAP BO Data Services Developer/Admin

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Coded the SQL queries of the Master and Encounter tables of the EPSI.
• Designed the ETL jobs based on the coded queries using SAP Business Objects Data Services.
• Used various transformations like Query, Case, and Merge transform.
• Worked on a script which perform both First load and Delta load
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.
• Analyzed the existing ETL project EDW
• Worked with business users on getting additional information from source systems to the Oracle EDW based on their reporting requirements.
• Used various transformations like Query, Case, and Merge transform.
• Worked on updating mapping document of the fields from the Source to the target.
• Automated the manual process using scripts in Data Services.
• Scheduling the EDW ETL jobs in the management console.
• Monitoring and Documenting the Load Stats of the EDW ETL jobs daily.
• Analyzed the existing ETL code for the EPSI Daily feeds.
• Worked with business users on the new enhancements for the EPSI daily feeds
• Designed the ETL code using the Data Services designer
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query and SQL transformation.
• Monitoring and Documenting the Load Stats of the EPSI Daily Feeds jobs daily.

Environment: SAP BO DataServices XI 14.0.0.0, Information Steward 4.0, Oracle 11g, Sybase ASE 15.x, Microsoft SQL Server 2005, DB2 UDB 9.x Toad for Data Analysts, MS Office Suite and Windows Server 2008/2003.

Confidential, Knoxville, TN

Sr. SAP BO DataServices Developer/Admin

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Extracted data from Excel files into SQL Server database using business objects data services.
• Designed Jobs, Workflows and Dataflow.
• Calling the Stored Procedures in the ETL job which deletes the data from SQL Server database before loading respective country data.
• Prepared a script which will check for the existence of flat file before loading data into the Database.
• Prepared T-SQL queries for the data cleansing in the SQL Server 2008.
• Worked with data quality transformations like global address cleanse, data cleanse and match transforms to cleanse the data of the different regions.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.
• Worked with the Excel worksheets of the different countries and setting up different conditional formatting rules based on the business logic.
• Made use of excel functions like vlookup and string functions to populate data dynamically based on the values enter by the users.

Environment: SAP Business Objects Data Services XI 12.2.3.2, SQL Server 2005/2008, SAP ECC R/3 (SAP HR), Workday SAAS system (ERP), Microsoft Office Suite and Windows Server 2008/2003.

Confidential, Lexington, KY

Sr. BO/ETL Tech Lead

Responsibilities:

• Analyzed the Business Requirements (functional & technical) with the Business users.
• Analyzed on how the current SSIS package works.
• Mapped all the tables from Oracle 11i to Oracle Rapid marts.
• Coded SQL queries for accounts like Gross Sales, Returns, Freight Costs, Cost of goods sold, Cost of returns, Sales Units, Sales Return Units, Other Discounts, Floor Model Discounts, Sales Allowances, AR trade Discounts, Exchange, Free Product Rebates, Rebates, Freight Costs, and Freight Charges.
• Implemented the Queries designed in Toad for all the accounts in Business Objects Data Services.
• Worked on a Rapid Mart dependency script as well as the script which performs First Load and Delta Load.
• Worked on a script which runs the Batch file at the End of the ETL jobs to load data from SQL Server Database into Hyperion Essbase cubes.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.
• Analyzed the Business Requirements (functional & technical) with the Business users.
• Analyzed the existing Planning ETL jobs in the BO Data Services.
• Coded SQL queries on extracting Purchase orders with status as open, Demand history and inventory history.
• Implemented the queries in the SAP BO Data Services that will fetch data from Accpac ERP system.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Documented ETL specification and migration document.
• Analyzed the Business Requirements (functional & technical) with the Business users.
• Added new ETL code to the existing Rapid marts ETL code to fetch the “OrdersonHold” Historical information from Oracle Applications.
• Calculated how long an order has been on hold.
• Documented ETL specification and migration document.
• Analyzed both business and functional requirements with the users.
• Worked with data quality transformations like Global address cleanse, data cleanse and match transforms to cleanse the customer data while migrating to the new Microsoft dynamics CRM.
• Unit testing of the ETL code as per the business test cases to validate the code.
• Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.
• Documented the ETL specification and migration document.

Environment: SAP BOXI 3.1, SAP BO DataServices XI 3.1, Crystal Reports 10, Oracle9i/10g/11i, SQL Server 2005, Oracle Applications (CRM), Hyperion Essbase, SQL Server Reporting Services, VisualStudio 2008, Visual SourceSafe, and Windows Server 2008/2003