SUMMARY

• Over 10 years of experience in IT industry with over seven years’ experience in ETL with Data Services and over 2+ years of experience in Dell Boomi. Proficient with planning, design implementation, troubleshooting and performance tuning support and administration of SAP Business Intelligence suite of products.
• Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Certified in SAP HANA application Associate.
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI, SAP BODS and Dell Boomi
• Excellent understanding of ASAP methodology and involved in two full life cycle implementations using Dell Boomi.
• Full cycle integration between SFDC, ERP, including case management, order creation, item receipt, inventory updates and shipping of replacement items using Dell Boomi. Real time integration supported reduced case management times, increased customer satisfaction, and increased customer service productivity by having a single system of record for CRM
• Configured Atoms both stand - alone - on premise and cloud based to the integration environment.
• Configured Dell Boomi with Sales Force CRM, SAP CRM, SAP S/4 Hana, SAP HCM, Flat Files and Success Factors.
• Experience in Installation, upgradation and migration of SAP BO and SAP BODS from 3X to 4X
• Sound knowledge of various data design models- Entity Relationship(ER), Multi-Dimensional/ Star Schema and Extended Star Schema models.
• Experience in Data Migration using SAP BODS to SAP ECC using Rapid Marts through IDOCs and Function Modules
• Experience in data integration from source systems SAS, SAP ECC, SAP Success Factors, Oracle, SQL Server, Nextor, Postgress, MySQL, Teradata, Hadoop, Flat files, Salesforce, Oracle Right Now, etc.
• Experience in data quality, data profiling using Trillium, SAP BODS and SAP Information Steward
• Experience in security setup on SAP BO, SAP BODS and SAP HANA
• Experience in Integrating SAP BO with SAP BW and SAP ECC
• Experience in integrating SAP BODS with SAP and non-SAP systems
• Experienced in Integration of BO Reporting Structure on SAP BW, SAP ECC, SAP HANA and non-SAP OLAP and OLTP sources.

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

SAP HANA & Senior ETL Consultant

Environment: SAP BODS 4.2, SAP BI 4.0 SP5, SQL Server 2008, SAP ECC6, SAP HANA, Action Data Connect, Dell-Boomi, Oracle 10g

Responsibilities:

• Design, development, deployment and management of multiple integration processes created on Dell Boomi.
• Integrated Dell Boomi Atmosphere with Oracle Service Cloud, Salesforce and SAP Success factors.
• Closely worked with ABAP and functional teams to modify the function modules for data migration.
• Created SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view
• Involved in Information Design Tool - Created Relation connection and OLAP connections, creation of data foundation, Business Layer for Hana reporting.
• Created Explorer reports for BW HANA views.
• Created Web Intelligence reports for HANA views.
• Experience in SAP HANA security including user management, roles and privileges
• Creating OSS Messages (SAP tickets) for Product errors, bug fixes and product fixes on BI 4.0 and SAP BODS 4.2 Landscape.
• Cloud Integration consulting on Dell Boomi for integrating Oracle service cloud, Salesforce CRM and with SAP HANA.
• Worked with Functional SAP/ERP teams closely to understand the gaps, coordinated with business on specific business rules.
• Configured Connectors to interface with multiple data sources like Oracle, SQL Server, Sales Force, SAP ECC, SAP CRM and SAP S/4 HANA to integrate with Dell Boomi.
• Extensively used logic shapes like Route, Branch and Exception in our processes
• Extensively worked with Flat files such as .CSV, .TXT, .TSV, .XLSX by configuring FTP creations in Dell Boomi.
• Integrated SAP endpoint using BAPIs and RFCs and reused them after migrating them with Dell Boomi.
• Worked as an ETL architect involved in Provisioning of Data from BODS into HANA, SLT replication
• Worked in requirement gathering to analyze Data for making decision for Initial ETL design layouts.
• Worked in development of ETL flows using Work flows, Data flows using Integrator, Platform and Data Quality Transforms in BODS
• Implemented scripts to extract and manage data
• Worked in data migration using standard Rapid Marts
• Worked in SAP HANA Live data provisioning using SAP LT Replication Server (SLT) and data services Modified standard rapid marts as per the requirement and loaded to SAP
• Used Function modules for data migration.
• Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
• Designed templates to transform Legacy Master and Transactional data compatible to target SAP ERP system
• Developed and modified changes in data flows according to the business logic.
• Interacting with SAP Global Escalation Team (Manager(s), Partner & Technical associates) to get resolutions in an effective manner as required by the client.
• Participate in UAT with Business users and getting sign-off on metrics, KPI’s and Numbers.

Confidential, New York, NY

Senior SAP BODS & HANA Consultant

Environment: SAP BI 4.0, SAP BO Data Services 4.2, SQL Server 2008, SAP ECC6, Oracle 10g, Dell-Boomi, Nextor

Responsibilities:

• Worked on POC for SAP HANA with ETL replication method using SAP BO Data Services 4.0
• Worked on consolidation of data from several source systems like Oracle, SQL Server, SAS, Nextor and Flat Files
• Interacted with users for customized and standard reports, gap analysis and associated solutions.
• Involved in translating business process into business and technical requirements.
• Well versed with supporting various Middleware Tools, like Dell Boomi, SAP HCI- PI and HCI-DS, SAP HANNA, SAP PI.
• Understand technical issues and identify architecture and code modifications needed to support changing user requirements for multiple Data Services jobs and application
• Integrated Right now with Oracle EBS using Dell Boomi.
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.
• End to End HANA POC technical activities including loading data into HANA tables from Flat Files using Data Services, Modeling in HANA (Analytic and Calculated Views).
• Troubleshooting the integration issues related to middleware’s BOOMI, HCI-PI and HCI-DS.
• Worked on Business Objects 4.0 tools suite including Information Design Tool (IDT), Web Intelligence, Explorer, and Dashboard Designer on BI Platform.
• Created OLAP and Relational Universes.
• Used scripts to manage exception handling functionality
• Created the Local Repositories, Central Repositories and Profiler Repositories and configured the Local, Profiler repositories with Job server and Management console.
• Worked in security setup for users in BODS, BO and SAP HANA
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Involved in performance issues while doing Full load and delta load using data services and also identified bottlenecks in total architecture.

Confidential

SAP BODS & BW Developer

Environment: BO 4.0 SP1, SQL Server 2008, SAP BO DS 4.0, SAP ECC 6.0

Responsibilities:

• Interacted with Business Users and data owner in gathering business requirements for Fixed Assets, Customer Master and AR load
• Involved in data migration from various corporate systems and interacted with end users and functional Consultants
• Reviewed the functional specifications and technical specifications and reviewed the existing mappings and redesigned the mappings to meet the perfect requirements.
• Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator.
• Prepared data Extract from legacy system and populating SQL Database on which data store for BODS has been created.
• Designed Customer Master Jobs in DS from Legacy to create IDOC Load Files
• Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
• Designed templates to transform Legacy Master and Transactional data compatible to target SAP ERP system
• Developed and modified changes in data flows according to the business logic.
• Created Variables, substitution Parameters
• Created Workflows, Data flows using Designer.
• Used SAP BPDM templates for generating IDOCS and applied SAP best practices in development.
• Worked extensively with IDOCS and LSMW for loading data into SAP ECC 6.0
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Analyze the types of business tools and transforms to be applied.
• Used Scripts for exception handling and loading of data
• Tuned performance for large data files by increasing block size, cache size and target based commit interval.
• Implemented performance tuning logic on sources, workflows, data flows and targets in order to provide maximum efficiency and performance.
• Involved in data profiling and used validation and address cleansing transformations by using data quality
• Developed custom functions per business requirements for loading the data into SAP.
• Identified errors in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs and redesign the existing mappings for improving the performance.
• Analyzed data cleansing, validation process using Information Steward to understand where the data changed that affects the cleansing/validation process on output.
• Involved in writing the Unit Test Cases.
• Involved in migrating the jobs from Dev., QA and to Production.
• Dealt with Unit Testing of all the mappings end to end and also with UAT.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Confidential, Auckland, NZ

SAP BODS/BO Developer

Environment: SAP ECC 6.0, SAP BW, BOE XI R3.1 SP3, DB2, SQL Server.

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business and IT teams.
• Assists in data mapping and GAP analysis between source and target data in BODS as per the blueprint.
• Worked with Functional SAP/ERP teams closely to understand the gaps, coordinated with business on specific business rules.
• Prepared technical specification documents.
• Worked on the technical details for transforming existing data onto SAP using SAP Data Services 4.1.
• Coordinated with business on specifying rules required to cleanse, standardize existing legacy Master data to meet universal standards using industry proven unique Cleansing Methodology.
• Created projects, batch jobs, Real time jobs, work flows and data flows.
• Worked with business process owners, stakeholders to understand and document the requirements.
• Interacted with the manager to understand the business requirements and implemented the business rules to redesign and enhance the existing data flows.
• Managed the central and local repositories using the Management console and Repository Manager.
• Made changes to the structure of the database tables in SQL Server for adding and modifying the column values and data types in order to accommodate the changes made to the ETL.
• Used various Transforms like Map Operation, Table Comparisons, Row-Generation, Query History
• Generation, Key Generation, Pivot, Reverse Pivot and functions like lookup, index search for transforming data.
• Developing and modifying changes in data flows according to the business logic.
• Understand technical issues and identify architecture and code modifications needed to support changing user requirements for multiple Data Services jobs and application
• Involved in performance issues while doing Full load and delta load using data services.