PROFESSIONAL SUMMARY:

• Senior SAP BODS developer with over 8years of Information Technology experience in entire life cycle of analysis, design, implementation and testing of Data Warehouse applications under different environments with 4 years experience in Big 4.
• Experienced in ETL and data integration in developing Data warehouse solutions usingSAP Business objectsData Services 3.1, 3.2,4.0, 4.1,4.2.
• Full stack BI developer with good knowledge in data modelling, SAP Business Objects Data services and SAP HANA.
• Extensive modelling experience in SAP HANA and ETL. Worked on Information Views, analytic privileges and Stored Procedures. Worked on SDA (Smart Data Access)/SDI (Smart Data Integration) in SAP HANA.
• Strong in Data warehousing, Dimensional Data Modeling concepts - Star Schema, Snowflake Schema methodologies, Delta load, full load, Slowly Changing Dimensions.
• Worked in multiple responsibilities includingETL architecture,ETL design,analysis, development, migration and writing technical specifications for migration projects and development projects.
• Worked on BODS admin tasks like Job Server Configuration, Repository creations local/central, CMC,Management console and scheduling.
• Worked on data profiling using SAP Information Steward(IS).Involved in Multi source analysis,dashboard creation and BO reports creation based on profiled data. Fixed data issues using BODS data quality transforms.
• Worked on advanced concepts like SCD, CDC, Auto correct load, manual/auto recovery mechanisms, full load, delta load, series/parallel data flow, Degree of Parallelism, data quality, migration strategies etc in designer.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Expertise in creating Dataflows, Workflows, Jobs, Projects using Data Services Designer and scheduling and monitoring jobs using Management console to move data from multiple sources into targets.
• Extensively utilizedBusiness Intelligence Reporting Tools such as Business Objects 4.1,4.0,BOXI 3.1 and Tableau 10.
• Proficient in BODS jobs and HANA models Performance Tuning. Worked on advanced concepts like DOP,Job server group creation,Indexes,multiple loaders series and parallel executions.
• Excellentcommunication, interpersonal,, analytical and technical skills.

TECHNICAL SKILLS:

ETL: SAP Business Objects Data Services 4.2,4.1, 4.0, 3.2 and 3.1.( Designer, Job Server, Repository Manager, Management Console and CMC)

Reporting Tools: SAP Business Object Business Intelligence 4.0(BOBI), 3.1(BOXI), Info view, Webi, Deski, IDT, UDT,LCM, Central Management Console(CMC), Central Management Server(CMS), Query as a Web Service and Import/Export Wizard.Tableau 10.0

Database: SAP HANA 1.0, Oracle 9i/10g/11g and SQL Server 2000/2005/2008

Data Profiling: SAP Information Steward(IS) 4.2/4.0 and Data Quality (DQ)

Data Modeling: SAP HANA 1.0

Industries: Manufacturing, Pharmaceuticals, Energy, FMCG and Telecommunications.

WORK EXPERIENCE:

Confidential, Philadelphia, PA

Lead BODS Consultant

Responsibilities:

• Conduct analysis, design, and development activities related to the creation and maintenance of conversion programs by understanding the client environment and how the data getting loaded into the legacy systems.
• Coordinating with functional team related to functional specification, Data Construction & Cleansed data requirements.
• Gathering the business rules that need to be placed before loading the data into staging tables. Build and maintain mapping tables.
• Identified various load methodology for loading data BODS, SQL scripts, manual load, LSMW, IDOC etc.
• Prepared various documents such as Technical specs, Code Review Documents, Detail source to Target Mapping Document for the different module.
• Sources are analyzed and mapped using SAP Information Steward. Data quality reports, dashboards are generated to fix source issues.
• Develop and maintain functional and technical documentation/specifications.
• Created Users,Job server, Central/local repositories for users and for code migration.
• Created Datastores for different systems like SAP ECC,SAP BW,Oracle, MongoDB and SQL server etc.
• Develop and maintain utility jobs/scripts to automate legacy data conversion.
• Run conversion programs, Ensure that all data is migrated accurately.
• Design and develop ETL Jobs to extract and merge the data using different transforms like Query, Validation, CASE, Map operation, merge, Table compare, Match, Data Cleanse available in Designer.
• Work on advanced concepts like CDC, Auto correct load, manual/auto recovery mechanisms, full load and delta load for loading data, series/parallel data flow, Degree of Parallelism etc for performance tuning in designer.
• Design and execute data verification strategy, test cases and scripts for data verification.
• Participate in Downtime Planning, and Go-Live Planning activities.

Environment: SAP Data Services 4.1/4.2,SAP Information Steward 4.2, Microsoft SQL Server 2013, Oracle, flat files, SAP sources and SAP HANA.

Confidential, Philadelphia, PA

Lead BODS Consultant

Responsibilities:

• Actively interacted and scheduled meetings with the business users to map data from different sources and understand requirements and develop design documents.
• Develop and maintain functional and technical documentation/specifications.
• Design table structures, dimension tables and fact tables required for the project.
• Design and develop ETL jobs to extract and merge the data using Designer.
• Design and develop ETL jobs to extract and merge the data using different transforms like Validation transform, Query, CASE, Map operation, merge, Table compare,, History preserve available in Designer.
• Work on advanced concepts like SCD, CDC, Auto correct load, manual/auto recovery mechanisms, full load and delta load for loading data, series/parallel data flow, Degree of Parallelism etc for performance tuning in designer.
• Scheduling the jobs as per Business requirement and data dependencies.
• Co-ordinate with other teams in case of issues with ETL loads.
• Developed SAP HANA Information views.Used ECC accelarated HANA views.
• Created schemas, packages and information views such as attribute views, analytic views and calculation views.
• Created calculated columns, Restricted Columns, Calculated attributes, input parameters and variables.
• Experience in importing data from Flat files to HANA data base tables.
• Performance tuning on newly created views.
• Created complex BO reports on views for daily reporting . Created BO universe in IDT for reporting.
• Involved in preparation and execution of the unit, integration and end to end test cases.

Environment: SAP HANA 1.0 (HANA STUDIO),SAP BOBI 4.1 and SAP BODS 4.0(Designer)

Confidential, Bellevue, WA

Senior Data warehouse Developer

Responsibilities:

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements and develop design documents.
• Designed Summary and Aggregation tables according to the functional requirement specifications and loaded data to support reporting.
• Designed Work flow and Data flow in such a way they can be used in multiple jobs.
• Analyze all tables and created various indexes to enhance query performance.
• TunedMappings and Transformations for the better performance of jobs.
• BODS jobs are created using Designer to extract data from different systems.
• Developed SAP HANA Information views.
• Worked on SAP Information Steward.
• Created schemas, packages and information views such as attribute views, analytic views and calculation views.
• Created calculated columns, Restricted Columns, Calculated attributes, input parameters and variables.
• Performance tuning of reports and HANA Views.

Environment: SAP Business Objects Data Services 3.2, SAP HANA, SAP Information Steward

Confidential, New York, NY

Senior BI Developer

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Worked on Migration of WEBI from version XIR3.
• Worked on converting UDT universe to IDT.
• Unit tested the reports for compatability and fixed the issues that occurred during migration.
• Worked with migration project team (Project Manager, Business Objects Administrator and Testers) to identify and fix migration issues.
• Designed and maintained Universes and exported them to the repository.
• Create complex reports as per user requirement.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Widely used Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Enhancements to existing reports.
• Performance tuning of existing and new reports.
• Testing the reports by using SQL scripts

Environment: SAP Business Objects 4.0, BOXI and Oracle.

Confidential, Rock Hill, SC

Senior Data warehouse Developer

Responsibilities:

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements and develop design documents.
• Interpreted logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Developed ETL Jobs to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL jobs using different transforms like Query, CASE, Map operation, merge, Table compare, History preserve.
• Extensively used BODS Designer to design jobs and Management console to schedule jobs.
• Ensuring dependencies and proper running of loads (Incremental and Complete loads).
• Designed security model of reporting system by creating users, groups, folders, and users in Business Objects.
• Responsible for creation of several WEBI Reports, DESKI reports based on requirement.
• Responsible for creation of publications which burst reports to various regional managers.
• Worked extensively on SQL Server and Oracle databases.
• Involved in performance tuning and optimization of ETL jobs and Business Objects Reports and Universe. Worked on Aggregate tables and using Aggregate Aware function in Universe.
• Actively participated in the discussions with Architect to arrive at data model that works both ETL and Reporting.
• Trained users on Business Objects XI 3.1 capabilities through the WebEx Sessions. Trainees involved various planners & business heads located in various field offices.
• Involved in preparation and execution of the unit, integration and end to end test cases.

Environment: SAP Business Objects Data Services 3.1(Designer and CMC), SAP Business Objects XI 3.1 (Designer, Desktop Intelligence, Web Intelligence, Publishing Wizard, Import Export Wizard), Xcelsius 2008, Microsoft SQL server2008, MS Excel 2007, Windows XP, Windows Server 2003.