SUMMARY

• 8 years of IT experience in the Design, Modeling, Development and Testing of Data warehouse housing and other applications using Object Oriented Analysis, Design and Methodologies.
• Excellent understanding of Application Development Life Cycle and expertise inData modelingandData Warehousing usingAgile Methodology
• Expertise in setting up Data Stores and configuring using Web Admin to create User Profiles and User credentials
• Well versed in using Data Services Designer toETLfrom multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third - party tools through Data Store setup and custom transfer program
• Well versed in usingPerformance Tuningtechniques to improve Throughput of data
• Extensively worked on SAP BODS Designer Components using BODS 3.1/3.2/4.0/4.1/4.2 and OLAP Data Warehousing. Well versed wif latest technologies including HANA, BOBJ Reporting and Business Intelligence.
• Experience in Developing, Testing and Deploying BODS Applications as part of Data Migration and Data Integration.
• Creating Jobs, Scripts, Workflows, Data Flows and Executing jobs wif BODS Data Integrator Designer. Loading Data into Target using flat files and Data Warehouse from various data sources.
• Involved in Hadoop connectivity configuration for BODS 4.1.
• Has expertise knowledge in Upgrading Data Services from 3.2 to 4.1 adding required patches and handling errors after the up gradation.
• Experience in loading data from Legacy systems and Hadoop to HANA Database using BODS.
• Proficient in implementing the data integrator transforms like Hierarchy Flattening, Pivot, History Preservation, Table Comparison and Map Operation.
• Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment and CDC (Change Data Capture) and Strong knowledge of Data modeling.
• Expertise in implementing Data Quality Transforms like Match Consolidation and Address Cleansing.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers at database level in Oracle and SQL Server.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/De Normalization techniques on database tables.
• Worked on different optimization techniques like push down operations, parallel execution, Partitioning and indexing for improving the performance of the job.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Worked extensively wif Data migration, Data marts, Data cleansing, Data profiling, ETL processes, Data mining, Data audits and Web reporting features for data warehouses.
• Experience wif logical and physical data modeling, developing database schemas like Star and Snowflake schemas use in relational and multi dimensional modeling of Fact and Dimensional Tables.
• Experience in designing and developing the Universe and updating the existing Universes to CMC, Scheduling the processes and administering the BO activities. Scheduled the reports in info view, publishing and scheduling reports using CMC.
• Developed complex reports that contained filters, prompts, multiple breaks levels, multiple data providers, cross tabs, levels of hierarchies for drill down and drill across reports, charts, sub reports.
• Experience in creating users and user groups, restricted access to the users, as needed using BO Central Management Console (CMC).
• Generated reports in Sales force for the verification of proper data upload in Sales force.
• Created ABAP Reports, Smart forms, SAP Scripts and BDC programming.
• Experience in SAP R/3 Sales & Distribution (SD), Material Management (MM), Warehouse Management (WM), Customer Relationship Management (CRM) and Financial Accounting and Controlling (FICO) areas.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart and Power Center and Data Integrator.
• Worked wif End-To-End implementation wif Data warehousing team and Strong understanding ofData warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts usingAccentual Data stage (Manager, Designer and Director
• Expertise in fixing production support issues related to mapping, data inconsistency and job failures.
• Good communication and interpersonal skills wif the ability to interact wif end-users, managers and technical personnel.

TECHNICAL SKILLS

BI Tools: Business Objects XI 3.1, R1/R2/R3/, Web-Intelligence,CrystalReports

ETL Tools: Informatica 8.6Power Center,BODI Data Integrator (ETL),BODS Xi3.2,4.0

Platforms: Windows, UNIX, LINUX, Web Sphere, Apache/Tomcat.

Databases: Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5 , Access, DB2.

Languages: C, SQL, PL/SQL, MS.NET Project Management ToolsMicrosoft Power Pivot, Scrum wise, SAS, Zen desk, Amulet, Remedy

Modeling & Report: ER Studio, Visio, Business Objects 6.5, Excel Power Pivot, Crystal Reports

Reporting: Xcelsius Enterprise 2008, 4.5, Crystal Reports 2008, XI R/2, XI, 10, 9, Business Objects WebI, Universe Designer, Business Objects XI REL2, Crystal Enterprise 9,10, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Erlanger KY

Sr. SAP BODS Developer

Responsibilities:

• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Analyzed business needs and meet wif users regarding business requirements to implement solution for their needs.
• Created Detailed Technical Document of the business requirements and Up gradation steps and mapping rules from source to target.
• Worked in theBODS4.0Environment, the entire project implementation was on 4.0
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Involved in the security model by setting up security at user level in central management console.
• Used Performance tuning techniques for faster execution of jobs and handle the jobs better. Wrote scripts, custom functions and used Try- Catch blocks to handle errors.
• Extensively used Data integration and Data Quality transforms like SQL transform, Key Generator, Case, Validation, Merge, Date generation, Row Generation, Pivot, Look up etc.,
• Used Management Console to run Batch jobs, schedule them and to view error log.
• Implemented SCD2 logic for the source data before loading it into Data Warehouse
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance & knowledge transfer of TEMPeffectively using BODS4.0

Environment: Business ObjectsData services 4.0,SAP,Web Intelligence, Info view, SybaseIq, SQL, PL/SQL, MS Office 2010, Microsoft Excel, Microsoft Power Pivot, TFS, Windows Server 2007.

Confidential, Mason, Ohio

SAP BODS Consultant

Responsibilities:

• Worked on Source to Target-Mapping for legacy systems (Target SAP RETAIL)
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc in Data Service to extract, cleanse and load into target Data Base.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs
• Gatheird requirements from the Business and applied the look-up functions to meet their requirements, used if tan else function.
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Involved in Knowledge transfer to certain users, like explaining the functionality of different transforms (merge, validation, key-generation, query) etc.
• Worked wif ETL team for the Extraction, Transformation & Loading of data from multiple source systems like SAP R3, SAP BW/BI and Non-SAP (TURBO, OMS order, CSI, NXT, SFDC, BVD, and Great Plains) and export final data to SFDC or REPO, Sales data mart and HANA using Business Object Data Services.
• Configured Adapter Connections for Sales force and HDBODBC connections for HANA.
• Developed number of Complexdata integrator Mappings and Reusable Transformationsto facilitate Daily, Weekly & Monthly Loading of Data.
• Used look-up function extensively for source to target mapping scenarios.
• Worked onData-qualityfor Global-address cleansing.
• Worked onData-Qualityfor Address cleansing, Data-cleanse, Matching, And User defined transforms.
• Prepares charts (for DI job), programs and getting instructions needed to illustrate andexplain the implementation of programs and procedures
• Developed number of Complexdata integrator Mappings and Reusable Transformationsto facilitate Daily, Weekly & Monthly Loading of Data.
• Worked on data-cleansing to standardize the operational data.

Environment: SAP Business Object Data Services 4.1, SAP Business Objects BI 4.1, SAP HANA 1.0, SAP ECC 6.0, Oracle 10g, SAS, SQL server 2008, MS Office 2010, Microsoft Excel, Microsoft Power Pivot, Windows Server 2007, Zendesk tool.

Confidential

SAP BODS - HANA Developer

Responsibilities:

• Participated in Joint Application Development Sessions (JAD) to identify business rules and requirements and tan documented them for both business and technical personnel.
• Installed Business Object Data Services 4.0, Created Local, Central and Profiler Repositories and configured them wif Job Server and management console.
• Involved in Installation of SAP HANA 1.0 and SAP BO BI 4.0 SP6.
• Worked wif SAP Team to implement Customers project on SAP HANA.
• Loaded Customer Master data in XML files into SAP HANA using Data Services.
• Developed Schemas, tables, Procedures and Views on HANA database using SAP HANA Studio.
• Imposed several Joins, Filters and alerter to restrict unwanted data and highlighted the required data.
• Created Attribute, Analytical and Calculated Views as per the requirements in SAP HANA Studio.
• Developed Analytical views for Transactional data, Attribute view for the Master data and Calculation Views as final model in SAP HANA Studio.
• For the Unit Test purpose developed testing Scripts.
• Scheduled the jobs to run on Daily basis.
• Migrated HANA contents from Development and Quality environments to Production using Delivery Units.
• Solution Environment: SAP Business Object Data Services 4.0, SAP HANA 1.0, SAP Business Objects BI 4.0, SAP ECC 6.0,
• SQL Server 2012, Ms Excel 2010, Ms Office 2010, Amulet.

Environment: SAP Business Object Data Services 4.0, SAP HANA 1.0, SAP Business Objects BI 4.0, SAP ECC 6.0,SQL Server 2012, Ms Excel 2010, Ms Office 2010, Amulet.

Confidential

SAP BODS Consultant

Responsibilities:

• This Project involves building ETL objects, which will extract data from source systems (excel sheets precisely), transform the data according to the given technical documents and generate a final load file which is used by ABAP team for loading in ECC.
• Upgraded Data Services from 3.2 to 4.1 added required patches and handled error after the up gradation.
• Major areas of focus: Appended Customer Master Address wif missing attributes at the critical moment to make data available for business on Quality (QE1) and testing environments (TE1).
• Reviewed the Mapping Documents to has concurrent discussions wif functional owners to understand the requirements.
• Prepared the Reconciliation report.
• Worked on the complex object Customer Master and Material Master data.
• Developed various Jobs, Workflows, Data Flows and used various Transformations for migration of data from Excel and XML using BODS Designer.
• Used different transformations before loading the data into oracle database e.g. Merge, SQL, Query, Validation, Row Generation and Lookup transformations.
• Worked wif Match transform, Address cleanse and Data cleanse transforms for US data cleansing in Data quality.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Delivered proof creating Dataflow to load data from legacy system to SAP using SAP BODS.
• Delivered Proof of concept of creating RFC connections for SAP and ODBC connections for SQL database; modeled reporting tables in SAP.
• Moved the complete project from Development to Quality, did unit testing their tan moved it to Production.
• Scheduled the jobs in Production and monitored them using Data Integrator Management Console.
• Reconciliation of the data loaded in target ECC systems by comparing it wif the load file generated.
• Involved in bug fixing and resolving the issues based on defect logs.

Environment: Business Object data services 4.X, Business Objects BI platform 7.0/4.0, SQL server 2008, SAP ECC R/3, Oracle 11g, Windows Server 2007, HPOV, Ms Excel, Ms Access 2007, Ms Word.

Confidential, Newbery, NJ

ETL Developer

Responsibilities:

• Involved in the development and implementation of the Enterprise f (EDW) process and Data Warehouse.
• Building of the BODS Jobs, Workflows, and Data Flows as per the Mapping Specification.
• Worked extensively on different types of transformations like Query transformation, Merge, Case, Validations, Map-operation, History Preserving and Table Comparison transformations etc.,
• Extensively Created SAP BW connection to interact wif SAP BODS using RFC connection.
• Extensively used ETL to load data from flat file and also from the relation database.
• Extracted data from different sources such as Flat files, Oracleto load into Data Warehouse.
• Ensuring proper Dependencies and Proper running of loads (Incremental and Complete loads).
• Maintained warehouse metadata, naming and warehouse standards for future application development.
• Involved in preparation and execution of the unit, integration and end-to-end test cases.
• Constructed Tables, Normalization/ De normalization Techniques on database Tables in SQL server using T-SQL.
• Worked on different optimization techniques like push down operations, parallel execution, Partitioning and indexing for improving the performance of the job.
• Created and updated Clustered and Non-Clustered Indexes to keep SQL Performance.

Environment: BO Data Services 3.1, Oracle 10g, SAPR/3, Oracle 11g, SQL Server 2005, MS Office 2000, Windows Server 2003, 2008.

Confidential, Wayne, PA

SAP BOBI Consultant

Responsibilities:

• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Installed relevant SAP business content objects, BEX report and Involved in transporting the objects through the landscape.
• Expert in Universe Designing using Universe Designer and Information Design Tool (IDT) and built relational universes using IDT.
• Created many complex and customized reports for specific business requirements and Hierarchies are implemented to support drill down reports.
• Created complex reports like Crystal reports using sub reports, Drill down and drill across reports using multiple data providers and various report level calculations.
• Used Query builder to query BOE Repository and retrieve various information.
• Developed Web Intelligence reports making use of several queries like Union, Intersection, minus.
• Worked wif WebI for creating complicated reports including sub-reporting, graphical reports, drilling reports along wif data reports.
• Extensively worked in designing and managing universes.
• Applied most advanced Business Objects functionalities like conditional hiding, ranking, hyper linking, conditional sorts, alerter etc.
• Created many universes, which involve more than one fact tables.
• Worked wif logical and physical data modeling, developing database schemas like Star and Snowflake schemas use in relational and multi dimensional modeling of Fact and Dimensional Tables.
• Created Contexts, alias to resolve loops and traps.
• Used Metadata Manager to retrieve metadata reports.
• Tuned and enhanced report queries to improve report performance.
• Conducted end user for basic and advanced reporting skills
• Trouble shooting and Performance tuning of the reports and Universe.
• Published the report to CMC and schedule it according to the requirement.
• Created various KPI dashboards using Xcelsius.

Environment: SAP Business Objects 4.0,Crystal Reports 2011, Xcelsius 2008, SAP BI4.0 / BW, Data Modeling, BEx Analyzer, Windows Server 2007, Remedy, Ms Excel, Ms Access 2007, Ms word

Confidential, Boca Raton, FL

Sap HR/HCR Functional Consultant.

Responsibilities:

• Defined the Enterprise Structure, Personnel Structure and Pay Scale Structure for the enterprise and linked the Pay Scale and Enterprise Structures.
• Configured user parameters and the number range intervals for personnel numbers.
• Configured personal data.
• Customized the basic settings for Personnel Administration.
• Customized personnel actions and customized the reason for change in personnel actions.
• Hiring and Termination
• Created organizational units, jobs, task and positions assigned the tasks to positions and integrated all of these into the enterprises organizational plan.
• Configured the matrix type for the organization and the working time to generate the work schedules for positions.
• Maintained the number ranges for organizational units.
• Assigned the various organizational units and positions to cost centers in FI.
• Reporting structure, Matrix structure for positions.
• Performed baseline and final configuration for the Personnel Development module.
• Provided technical and functional input to complete functional specifications.
• Created a Qualification catalogue to operate wif the Organizational Structure.
• Assigned Qualifications to Positions and structured Qualifications to form career paths.
• Designed Qualifications Catalog, Performance Appraisals, Career and Succession Planning.
• Worked wif tech team to review transports.
• Created Adhoc queries for own use and for customer requests.
• Configured and maintained the Contribution plans for the employees
• Defined Evidence of Insurability conditions for health and Insurance plans.
• Lay down the Functional Specifications and Mappings for Interfaces to Providers. Tested and transported these interfaces to Production environment.
• Maintained the benefit administration process: enrollment, maintenance, and termination of participation using featuresBENGR,BSTAT,ELIGR, andTRMTY.

Confidential

ABAP/HR ABAP Associate Consultant - Support

Responsibilities:

• Identifying the components necessary to address the development and prepare technical specifications for the same.
• Engage in actual development (coding/creation of custom objects).
• Executing unit tests on all objects prior to formal delivery.
• Maintain and update changes in smart forms.
• Maintained documents in APSE.
• Completion of Project involving a Live Business Cycle along wif the team requirement.
• Developed Reports involving classical, interactive and ALV methods for displaying data.
• Created Function Modules and Data dictionary objects.
• Developed and modified Smart forms and SAP scripts and configuration of NACE for output types.
• Presentations on Process flow of SD, MM and PP functional areas.
• Worked on outbound interface and inbound interface (file upload) as per the client requirement.
• Performed ABAP Programs testing and debugging in implementation of SAP modules.
• Attended on RICEF objects wifin SAP.
• Completion of all the assignments on the RICEF objects.
• Completion of Project involving a Live Business Cycle along wif the team requirement.
• Developed Reports involving classical, Interactive and ALV methods for displaying data.
• Created Function Modules and Data dictionary Objects.
• Developed and modified Smart forms and SAP scripts and configuration of NACE for output types.
• Presentations on Process flow of SD, MM and PP functional areas.
• Learnt creation and enhancement of Info types.
• Worked on LDB’s PNP and PNPCE.

Environment: SAP R/3 ECC 6.0, Oracle 10g, SQL Server 2005, MS Office 2000, Windows Server