PROFESSIONAL SUMMARY:

• SAP BODS (BODI)/BI Consultant with around 4+ Years of IT experience in SAP BI Technologies with SAP Business Object Data Services, SAP HANA.
• Expertise in SAP Data Services 4.x, SAP Business Objects 4.x reporting applications along with SAP BW 7.x, and SAP HANA 1.0.
• Involved in BODI/BODS (Business Object Data Services) Projects End to End implementation, Data migration and Upgradation.
• Worked on Full Life Cycle Implementations in SAP including conducting Blueprint/Design workshops, requirements gathering, gap analysis, custom object development, data loading, unit testing, integration testing and go - live strategies.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Strong ETL experience includes extraction of source data using Business Objects Data Services and also Troubleshooting data issues, Develop Mappings and transformations, Performance Tuning, Building Data Integrator and calling web services, support operations during testing.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Proficiency in developing test plans, test cases, test scripts, documentation and performing manual testing, web testing and worked on BODS/BODI Extraction, load and transformation processes.
• Expertise in Design, Development, and Deployment of Business Objects solutions for Corporate reporting requirements and involved in a full life cycle implementation of SAP BI/BO.
• Work with project leads, users, and business systems analysts to define technical specifications and develop database views, cubes, data modeling requirements, and functional and technical documentation.
• Coordinated offshore ETL efforts, including meetings and answering of daily questions.
• The building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Provide specialist support including problem-solving, hands-on resolution, training, testing, and monitoring activities as well as call logging & follow-up on a local & global level.
• Good acumen to reach the goal using the least number of transformations while maintaining the business rules.
• Good Communication and Interpersonal skills. Technically depth, Result-Oriented with strong problem-solving skills, Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.

TECHNICAL SKILLS:

MS: DOS, Windows 2000/NT/XP/2008/ 7.0, UNIX

Databases: MS SQL Server 2008, SAP HANA 1.0, Oracle, MongoDB

BI Tools: SAP BODS/DS 4.1/4.2, SAP HANA Studio, SAP Business Objects 4.2, SAP ECC 6.0

Reporting Tools: Tableau, Design Studio, Dashboards, WEBI, Xcelsius 2008

Other Tools: Sublime Text, Microsoft VISIO, Dreamweaver, Notepad++, Microsoft Visual Studio, Microsoft Visual Studio Code, Brackets, GitHub, Bitbucket, TortoiseSVN, Sourcetree

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, Delaware

SAP BODS / BODI ETL Consultant

Responsibilities:

• SAP BODS Consultant working in multiple projects as ETL developer.
• Strong Experience on Full Life Cycle Implementations in SAP including conducting Blueprint / Design workshops, requirements gathering, gap analysis, custom object development, data loading, unit testing, integration testing and go-live strategies.
• Strong experience in documenting business requirements, functional, technical specifications and test cases.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Strong experience in using BODS as an external system for ETL between SAP ECC and BW.
• Experience in creation of complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality, and Platform) to successfully load data from multiple sources into a desired target which is HANA.
• Well versed in using Data Services Designer to ETL from multiple sources including Flat Files, Excel workbooks, XML and SAP ECC and third-party tools through DataStore setup and custom transfer program.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Data Migration technical experience utilizing SAP Data Services (BODS) with strong SQL skills, and working knowledge of SAP Enterprise HANA.
• Created Datastores & importing metadata, creating a Batch job, Data Flow, Query transform, executing the job, Validation, Tracing and debugging Batch job, built in Transformation, Built-in Functions, Data services Scripting language and variables.
• Scheduling the jobs according to the client requirement by using windows batch script and Business objects data services Management Console.
• Designed and Developed Webi, Design Studio dashboards using Lookups and various formulae to analyze the Data like PDF, Line, column and combination charts. Unit testing, integration testing, and automated testing.
• Created BEx queries, Lumira Dashboards, and Webi report on BW and views from HANA.
• End-to-end BO experience in Requirement gathering, Analysis, Design, Development, Testing, and Implementation.
• Build continuous improvement process around customer master data by build exception reports and providing dashboard reporting on data health.

Technical Environment: SAP BODS 4.2, HANA Studio, SAP NETWEAVER PORTAL, Data Services Management Console, SAP Business Objects Enterprise 4.0, SAP ETL, Business Explorer (BEx), Interactive Analysis, Dashboard Designer.

Confidential, Maryville, MO

ETL Developer

Responsibilities:

• Strong time management skills with the ability to participate in multiple projects/work streams simultaneously as well as strong analytical/ problem-solving skills.
• Solid technical proficiency with SQL Server with advanced knowledge of performance tuning and refactoring.
• Hands-on Database Performance and Scalability experience with design knowledge of physical and logical database schemas and tables.
• Good presentation, interpersonal, and written skills with the ability to influence decision-makers at all levels of the organization.
• Demonstrated ability and willingness to learn and quickly comprehend new concepts.
• Demonstrated strong judgment and decision-making ability.
• Basic level proficiency with Microsoft Word, Excel, and Outlook.
• Designed and implemented stored procedures views and other application database code objects.
• Maintained SQL scripts indexes and complex queries for analysis and extraction.
• Performed quality testing and assurance for SQL servers.
• Worked with stakeholder’s developers and production teams across units to identify business needs and solution options.
• Ensured best practice application to maintain security and integrity of data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Technical Environment: Tableau, Git-hub, Bootstrap, SQL Server, Mongo DB, Notepad++, Microsoft Visual Studio, Sourcetree

Confidential

SAP BODS/BODS Admin

Responsibilities:

• Worked as the ETL developer using BODS.
• Build ETL framework for Audit, Balance, and Control of EDW, Recovery Framework and logging.
• Created the Local Repositories, Central Repositories, and Profiler Repositories in SQL Server 2008 and configured the Local, Profiler repositories with Job server and Management console.
• Involved in the migration of code from one environment to another.
• Implementing the RFC for existing jobs for user’s request
• Took care of the permissions like the read-only access or read/write access as for production we give read-only access.
• Assigned people with different roles to developers and perform Auditing.
• Environment set up and providing the file path and who should be given the access.
• Co-coordinating with admins like Unix or Linux and resolving issues if there are any.

Technical Environment: SAP Data Services 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manage), SQL Server 2008, Task Scheduler, ChaRM.

Confidential

SAP BODS Developer

Responsibilities:

• Worked as the ETL developer using BODS and BI Developer using BOBJ reporting tools.
• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Good experience with data conversion, data cleansing, loading and data validation processes.
• Using BODS ETL to build complex data flows, push down operations, scripting, validation, Tracing and debugging Batch job.
• Experience in developing the Batch jobs using workflows and data flows.
• Capturing changes in data (Initial/Delta load) using Table Comparison, History Preserving, Key Generation Transforms.
• Configured the Data services to connect to the SAP ECC, BI, CRM.
• Scheduling jobs by client requirement by using Business Objects Data Services Management Console.
• Good knowledge of SAP Basis and BODS Upgrade. Enhancement of existing Data sources
• Created Web intelligence reports on different views.
• Development of Dashboards using Design Studio.
• Convert BEx workbooks to Analysis Office workbook.

Technical Environment: SAP NETWEAVER PORTAL, SAP Data Services 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manage), SAP BI 7.3, SAP CRM, SAP Business Objects 4.0 Suite, Life Cycle Manager SQL Server 2008, Windows 2000.

Confidential

Junior ETL Developer

Responsibilities:

• Developed and tested extraction, transformation, and load (ETL) processes.
• Maintained SQL scripts and complex queries for analysis and extraction.
• Designed jobs that automated the ftp process of loading flat files posted on the ftp server.
• Managed team SharePoint site.
• Prioritized and handled multiple tasks in high-pressure environment.