SUMMARY:

• Certified Atomsphere Boomi Integration Cloud Developer I and II.
• Eight years of experience in EAI solutions using Dell Boomi, SAP Data Services and SAP HANA which includes nearly three years of experience in Dell Boomi Atomsphere.
• Proficient with planning, design implementation, troubleshooting and performance tuning support and administration of SAP Business Intelligence suite of products.
• Experience in integrating multiple systems which includes Cloud based solutions such as Success Factors, Ariba, Sales Force, C4C, Oracle RightNow and on - premise enterprise applications SAP, SAS, JDE, Nextor, Oracle, MSSQL, Origami
• Experience in integrating using WSDLs and using SOAP and REST APIs for integrations.
• Experience in sizing and installation of Boomi Atom and molecule both in cloud and on premise.
• Configured Dell Boomi with Sales Force CRM, SAP CRM, SAP S/4 Hana, SAP HCM, Flat Files and Success Factors.
• Experience in working with Banking integrations for sending payroll related information to bank and collecting the reports from bank using Boomi.
• Experience in developing Boomi WSDLs for external systems consumption.
• Experience in handling huge amount of data and fine tuned Boomi based interfaces for better performance.
• Good knowledge in Boomi’s licensing for connectors and built interfaces based on that.
• Effectively implemented Boomi with Service Now for post-production support.
• 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

PROFESSIONAL EXPERIENCE:

Dell Boomi Principal Consultant

Confidential, Houston, TX

Environment: Dell Boomi, JDE, Oracle, Sage, Origami, CornerStone, EcoSys, Benefit Solver

Responsibilities:

• Worked on the Banking Interfaces to send the Accounts Payable and Payroll Instruction files to the Banks.
• Multilevel encryption using Boomi for data security and used protocols such as SFTP, FTP and AS2 connectors for the file transfer.
• Developed Integration packs in the Boomi Master account and pushed and installed the Integration packs in the sub accounts.
• Worked with the Dell team to setup the production environment by setting up the multi node molecule.
• Developed interfaces to create users and assign roles in the sub accounts using Boomis partner API and Atomsphere API.
• Worked on Employee data consolidation project where extracted data from multiple source systems which includes databases and webservices.
• Used SOAP and REST APIs to communicate to the webservices.
• Exposed Boomis WSDL to communicate to the external system to transfer the data.
• Effectively implemented CDC based extraction on the databased with large volumes of data using Boomi and implemented Boomis Find changes shape to capture the changed records.
• Effectively used Add to cache, load from cache, Business rules for performance optimization while dealing with large datasets and used Groovy scripts for encryption, implementing hash algorithms and collecting atom and process ID related information.

Sr. Dell Boomi Consultant

Confidential, West Lake, TX

Environment: Dell Boomi, Success Factors, Ariba, Sales Force, SAP S/4 HANA

Responsibilities:

• Worked with Success Factors, Ariba, Sales Force teams to understand the functional requirements and project estimates to understand the gaps and coordinated further for business rules.
• Worked with Dell Boomi Enterprise Architects from Dell to design the Architecture for the current implementation.
• Worked with Network and security teams to install and configure Atom and Molecule to handle fault tolerance and load balancing.
• Worked with SF EC team to build multiple interfaces to load data into SAP S/4 HANA based on OData and SFAPIs.
• Worked on Ariba P2P integrations and used Web Services to communicate to Ariba and forth and loaded data using BAPIs to SAP S/4 HANA.
• Built multiple Boomi Interfaces from low to High complexity depending upon the requirement.
• Configured Boomi Interfaces with error handling mechanism depending upon the requirement.
• Configured Application based and Web services based connectors in Boomi to handle the requirement.
• Handled connectors based on the organizations Boomi’s licenses.
• Fine tuned Boomi interfaces to handle huge load for large transactions.
• Successfully handled real time and batch jobs in the post production.

SAP HANA/ ETL Senior Consultant

Confidential, St. Louis, Missouri

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

Responsibilities:

• 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 and Flat files.
• 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.
• 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.
• 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.

SAP BODS/HANA Senior Consultant

Confidential, Pittsburgh, Pennsylvania

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.

SAP BODS/BW Consultant

Confidential, St. Louis, Missouri

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.

SAP BO/BODS/HANA Senior Consultant

Confidential, New York City, New York

Environment: SAP ECC 6.0, SAP BW, SAP AFS, BI 4.0, SAP BODS 4.2, SAP HANA and Nextor.

Responsibilities:

• Worked in end to end implementation of SAP HANA POC with existing SAP AFS and SAP ECC setup
• Worked in designing upgradation plan for Data Services from BODS 4.0 to BODS 4.2
• Created in setting up of Central and Local repositories.
• Worked in setting up security setup for SAP BI 4.0 and SAP BODS 4.2
• Worked in creation of technical specs and involved with functional team for data mapping
• Extracted data from multiple source systems to HANA using BODS
• Developed Information models in SAP HANA
• Created universes on top of SAP HANA using IDT
• Used complex SQL queries to extract data
• Developed WebI reports and Lumira reports.
• Migration of data to AFS system using LSMW
• Involved in redesign of the existing BOE Architecture for the delivery of EMEA reports.

SAP BI/BO Consultant

Confidential, Purchase, New York

Environment: SAP ECC 6.0, SAP BW 7.0, BOE XI R3.1 SAP BI 4.0

Responsibilities:

• Responsible for BO Capabilities team of Global Centre of Excellence (GCOE)
• Worked as a Business Objects report developer using Webi and Dashboard designer and as a SAP BOBJ Administrator.
• Installing, Configuring and Administering the Business Objects enterprise servers. Manage servers using CCM.
• Created and managed users and groups, including their Rights to folders, categories, objects and applications using CMC (Central Management Console).
• Created and Managed Folders, Objects, Subfolders, Categories and Profiles using CMC.
• Gather report migration requirements. Prepare report migration strategy.
• Scheduling WebI and Desktop intelligence documents/objects (FTP, Email (SMTP) and Format).
• Moving universe, reports, and dashboards from development to production using Import Wizard, LCM and PMT.
• Creating and maintaining repository and users with Administrator, Creating Universes with BO Designer, and creating reports with Business Objects Reporter (Desktop Intelligence).
• Create very advanced and most challenging reports that involve multiple data providers. Setting up scope of analysis/drill down hierarchies in the universe for drill down report analysis.
• Create universes in BO Designer (setting universe parameters, classes, objects, joins, hierarchies, etc.)
• Check Integrity/Cardinality, loops (using aliases, context), resolving chasm traps and fan traps using
• Aggregate Awareness, Contexts, and Aliases in designer for a universe. Documenting, distributing universes and maintaining universes.
• Publishing and broadcasting/scheduling business intelligence documents/reports to large number of end users via business objects repository using Central Management Console.
• Setting up profiles in Central Management Console under profiles to users and groups to apply filters during single pass report bursting.
• Expert in Advanced reporting, crosstabs and Trending graphs. Monitor user activities, system activities using Administrative console.
• Project lifecycle development, methodology documentation and quality control.
• Interfacing with the technical staff for translating the business requirements into a functional data model.
• Develop, maintain, and document data standards, guidelines and procedures.
• Conducting interviews with the business users for business requirements analysis and supporting documentation.
• Worked as a coordinator for whole team for taking support issues with SAP.

SAP BO/BODS Consultant

Confidential, Novi, Michigan

Environment: SAP ECC 6.0, SAP BW, SAP Modules (FI-CO, AP, AR, GL, Procurement, etc), BOE XI R3.1 SP3, Crystal Xcelsius, Crystal 2008.

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Stage (Extract) the source data from files, SQL server, DB2 sources into STAGE tables.
• Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.
• Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
• Built Lookup (LKP) tables (Code Set and Code Value) to identify correlation between facilities defined by different administrative units/departments.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Used Query, SQL, LKP, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
• Worked with Date/time manipulations/arithmetic in DB2 using DB2 built in functionalities as well as Data Integrator Date functions
• Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.
• As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows
• Created the necessary indexes (for fields in WHERE clause)
• Run stats on all tables
• Right choice of transformations & right design in data flows
• Implemented incremental load process
• As a part of QA testing, worked with the ECS team, Dash board developer and the Data modeler to test the ETL process to populate the dashboard uccessfully.
• Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.
• Batch jobs configuration and set repository schedules using Data Integrator Management console

SAP BODS Consultant

Confidential

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 dataflows.
• 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.

SAP BO Consultant

Confidential

Environment: SAP Solution Manager, SAP BW, Xcelsius, SAP BOE

Responsibilities:

• Involved in understanding the Current Implementation and Business Requirements
• Involved in collection of data from various sources which includes EWA reports(SolMan) and BEx reports
• Involved in design and development of the Dashboard using Xcelsius
• Gathered requirements from the management for functionality, display and effectiveness of the reports, Created initial Classes & Objects, qualification for the Universes in both on/off line modes
• Maintained user security on the BO Universes
• Defined Aliases and Contexts to resolve the join issues in the Universe, Solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps
• Exported the universes to the Repository for making resources available to the users, Created custom LOVs and Hierarchies, which helps the report users to select the list of values and also to drill down to lower levels
• Created the new Views and Aggregate tables for report performance, used @functions to create predefined conditions and prompts to filter the data and dynamic user selection.
• Generated BO reports for several levels and used drill analysis in Business Objects 6.5.1, which allowed users to view data at a more detail level than current level
• Developed Drill down, Link Report reports, sub reports, used various Charts and Graphs like Bar Chart (Side By Side, Stacked), Line graphs, Pie Charts etc
• Organized data in the reports by using Filters, Sorting, Ranking, Created Alerts based on business criteria, Created reports on web using InfoView Portal, distributed the reports to different users