SUMMARY:

• Over 6+ years of IT experience in Data Warehousing, SAP Data Migration, Data Cleansing using and Business Objects Data Services(BODS), Informatica, BO Reporting Tools, WEBI, Crystal.
• Extensively worked on integration of Business Objects Data Services with SAP MODULES (Finance, HR & CRM) and Non - SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2008/2005/2000 , DB2, JD Edwards Mainframes, Flat Files and Legacy System files.
• BODS/Data Quality in design of work flows, data flows, scripts and complex transforms using different data integrator, platform and data quality transforms.
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs, Manage repositories and perform metadata reporting.
• Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimensions (SCD) phenomenon, surrogate key assignment and Change Data Capture (CDC).
• Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS.
• Experience in working with ABAP dataflows to extract the data from SAP Applications.
• Hands on knowledge on Data Quality concepts and familiarity with setting up Data Cleanse, Address Cleanse, Match and Associate transform.
• Expertise in analyzing, designing, creating and maintaining InfoCubes, DSO objects, Remote Cubes, Multi Providers, infosets, Infoobjects, InfoSources, and Extract Structures
• Expertise in Flat file, Generic DataSource, LO Cockpit, and COPA extraction.
• Experience in BW components like Data Sources, Full/Delta upload, Scheduling, Process Chains, Data Mart, Legacy Systems, XML and DB Connect
• Created Info spokes for exporting data to external systems.
• Proficient with Business Objects (BOBJ) WebI, BO-Web I rich, Universe Designer, Live Office, Query as a Web Service, and Xcelsius 2008
• Experience in development of SAP Universes in Designer against SAP BI Cubes and BEx Queries.
• Experience in BOBJ 4.0 integration with BW for reporting WEBI etc.
• Expert in managing System Management Tools like CCM, CMC, Import Wizard and Publishing Wizard.
• Familiarity with Business View Manager and Crystal Reports 2008 and Crystal Report Enterprise.
• Experience in Data migration and BI using Oracle, SQL Server, Actuate and BIRT.
• Ability to understand the business environment and translate business requirements into technical solutions.
• Excellent communication with exceptional problem solving, including technical writing, presentation and strong interpersonal skills with the ability to interact with end-users, managers.

TECHNICAL SKILLS:

SAP Application: SAP BI 7.0, ECC 6, SAP BW 3.5, BO 4.0, XI 3.1.

ETL Tools: SAP BO Data Services 3.2.4.0, 4.1, Informatica.

Languages: BI- ABAP.

Source Systems: R/3 4.7, ECC 6.0, Legacy System, Flat file.

Reporting Tools: Bex, BO Webi.

Operating Systems: Windows95/98/XP/Vista/7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

SAP BO Data Services Consultant

Responsibilities:

• BODS Consultant responsible for Development of extraction of data and provision to downstream enterprise BI systems EDW.
• Installation, Administration, Code Migration, and performance tuning of BODS code.
• Work on SAP specific data marts in EDW based on start and snowflake schema.
• Worked with the basis team to Install and configure BODS with ECC 6.0 and SAP BI/BO 4.0.
• Performed gap analysis from technical perspective and provide best practices recommendation.
• Worked on the POC to extract data from SAP Open Hub tables.
• Worked on the POC to extract data by using standard ECC extractors and load to staging.
• Build solutions to extract data for various data objects FI-GL, FI-AP, FI-AR data from SAP ECC and SAP BW to load the Staging for downstream reporting.
• Extracted the GL data from open hub tables in BW to provide to downstream BI.
• Worked extensively with ABAP dataflows, ECC Extractors and ABAP developers to work through the development and issue resolutions.
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Established Data Governance around SAP Master Data objects like Customers, Materials, Vendors etc. using SAP BODS/BO Information Steward/DQM.
• Worked extensively on Address Cleanse (USA Regulatory certified address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in Customer Master, Material Master and Vendor Master tables.
• Extensively worked on the Data Quality features using Geo-Coder and Global Address Cleanse
• Performed Source data assessment and identified the quality and consistency of the source data by using Information Steward.
• Extensively worked on Data Insight and Metapedia modules in Information Steward.
• Administered the SAP BODS/IS/BOBJ systems.
• Used Central Management Console for Creating users and user groups, restricted access of the users.

Environment: BO Data Services 4.0, SAP ECC, SAP BW 7.3, CMC, SQL, PL/SQL,Oracle,SQL Server 2008,

Confidential, Melbourne, FL

SAP BODS / BI Consultant

Responsibilities:

• Sr. BO Data Services Developer/ Technical lead for Development on Data Migration and EDW projects.
• Requirements gathering from business users to support the Solution Architecture ETL for EDW.
• Supported the Solution Architect for BODS Technical features to integrate with SAP systems and provide solution to establish the ETL Framework around SAP BODS.
• Defined Data Stores to allow BO Data Services to connect to the source or target database.
• Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse
• Installed & configured BO Data Services 4.0 in Development & Production Server.
• Developed ETL jobs to SAP R/3 tables and loaded into staging area and build transformations that apply the business rules provided by the client requirement and loaded the data target SQL Server
• Worked with tables involving Hierarchies and using Hierarchy flattening
• Implemented use of SAP ABAP dataflows to extract data from SAP Applications ECC, BW etc.
• Developed integration between different systems ( SAP BW, SAP ECC, SQL Server )
• Build Delta load logic and worked on Change Data Capture (CDC) on both Source and Target level for Slowly Changing Dimension (SCD) Type 1, Type 2 and Type 3.
• Implemented Delta recovery solution for failed objects like auto-recovery etc.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow’s and target tables using bulk loads etc.
• Responsible for Business Blueprint, configuration and implementation of Enterprise structures, Organizational Management, Personnel Administration, and Payroll. It's a full cycle SAP BI implementation as a Techno functional team member.
• Designed data model and led team in developing new reports.
• Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. Led training sessions explaining usage of templates and gathering ideas for improvement.
• Helped ABAP to Optimize the extractor code for Purchase order history and Contract Management
• Developed the required configuration in SAP R/3, SRM, BI and Business Objects according to the Functional specification provided by Functional team and prepare the Technical design document.
• Developed numerous custom datasources using database views and custom function modules.
• Designed and implemented numerous accounting systems including applications such as G/L, A/P, A/R, F/A, and Financial Reporting.
• Building SD order ODS (SD), order items ODS (SCOR-Supply Chain), shipment cost ODS update Transformation, and update routines as an input to the same consolidated ODS to view the overall Waterfall” structure of financial figures at a granular level
• Worked on payroll data info cube (0PY C02), where loaded the data from payroll data (0HR PY 1), which contains all payroll result wage types and organizational assignment for the employee grouping. Implemented a wage type hierarchy. Compared previous year with respect to current year.
• Worked on Cut-over activities and data validations and post. Go-live support.

Environment: SAP BO Data Services 4.0, BW 7.0/7.3,SRM,BI 4.0, BEx, ECC 6.0

Confidential, Lakewood, CO

SAP BODS and BI Consultant

Responsibilities:

• Sr. BO Data Services Consultant for SAP Data Migration project.
• Mentoring and co-coordinating with offshore team on business queries, reviewing and guiding on the technical implementation of team at off-shore.
• Troubleshooting BODS connectivity issues with source systems and SAP BAPI integration.
• Extensively worked on AIO (All In One) methodology, SAP preferred Data Migration methodology
• Developed a code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Guide the client team in establishing the dependencies on the data load objects, and preparing project plan with dependencies and cut-over strategy
• Creating a load structure which can feed to SAP- LSMW loads.
• Closely interacted with SAP load team to fix the load errors at ETL end.
• Creating dynamic error report on error data and analysis to provide inputs to business.
• Created reusable BODS code components to load data from legacy source to SAP ECC.
• Created temples for loading data to SAP-LSMW and held tight integration for AIO BAPI objects
• Managing development team to adhere to project schedule and optimize the resources for quick turnaround on bugs and testing.
• Analyzed the session, event and error logs for trouble shooting mapping sessions.
• Created test cases for carrying out unit testing and part of functional testing.
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Responsible for documentation, version controlling of schema and version releasing.
• Prepared Data Migration cut-over plans, mock data loads, performance improvement initiatives
• Actively participated in the blueprint phase of project regarding the architecture phase.
• Implemented BO Data Quality Solution Customer address cleansing on SAP CRM and SAP ECC
• Developed, published, and scheduled batch and real-time jobs.
• Responsible for the development of strategic documents including the technical specs.
• Installation and configuration of Business Objects Enterprise and Data Services 3.2, including Data Quality.
• Creation, improvement, and documentation of HCM reports and related universe, including standardization and applying best practices.
• Designed the mapping templates for data extraction and loading and supported ETL developers
• Designed and implemented Plant maintenance Cubes (0PM C03 Maintenance Orders), DSO, Data Sources (2LIS 17 ORDER) in SAP BI data flow.

Environment: SAP R/3 4.6c, SAP ECC 6.0, SAP BI 7.0/7.3, SAP CRM SAP BODS 3.2

Confidential

DevOps Engineer

Responsibilities:

• Provided support in environment management for E-commerce site and mobile apps.
• E-commerce application and mobile application code deployments on various application servers through Jenkins tool. Data-Power Deployments and Configuration changes.
• Trouble shooting of various issues on commerce and mobile applications and closing the issues within SLA’s
• Involved in automating various manual jobs (like Test stores set up, pushing builds to virtual preproduction server, clearing server cache and few other manual jobs) that are used on regular basis and thus reducing the effort.
• Prepared SOP’s and Technical Documentation Analysis for E-commerce Team. Daily based reports sending to various respective team members.
• Worked with various network migration and testing implementation plans; pre and post migrations.
• Maintained multiple Linux servers, and handled builds/deployments through Jenkins to the test servers
• Developed several utilities in java and Unix for the team to automate manual tasks, thereby saving multiple hours of time.
• Implemented the login module and design of GUI for the tool developed for Lowe's test data management team.
• Implemented application deployments on WAS and WCS.
• Worked on User access and registry refresh issues experience.
• Implemented application configuration files changes and analysis.
• Worked on Akamai Luna center experience for data center failovers.
• Implemented java classes to fetch data from DB2 of multiple environments for the online portal developed for Lowe's service platform team.
• Proactively fixed environment issues, experience with JIRA and sharepoint.