SUMMARY

• 10+ years of total IT experience in the Design, Modeling, Development and Testing of Data warehouse housing and other applications using Object Oriented Analysis, Design and Methodologies.
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Strong experience in the integration of BODS with SAP modules and Non - SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI and CRM As well.
• Created 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.
• Exposure to SQL, PL/SQL, RDBMS and Worked on building score cards
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Strong experience in cleansing the data using Data Quality transforms.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Extensively worked on Data modelling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modelling, fact and dimension tables.
• Knowledge on Unix Scripting,
• Worked with Oracle servers 11G /10G and SQL Server to extract the data.
• Worked on Information Steward to cleanse the Master data .
• Worked on business requirements gathering, developing functional and technical specs, and data modeling using Multidimensional Modeling and extended star schema.
• Extensively worked on Migrating the data from SAP through IDOC.
• Directly worked with end users and clients at various client locations.
• Extensive experience in Modeling, Data Extraction/Loading (ETL), Reporting, Information Broadcasting
• Proficient in Business Objects BI(4.x) Reporting using BI Launchpad, Web Intelligence.
• Experienced in building OLAP universes and Connections
• Used Information Steward for Profiling data and running validation rules against different sources of data
• Created connection in Information Steward to the Data base Microsft SQL server and ECC as well.
• Highly experienced in developing query objects including restricted key figures, calculated key figures, Structures, RRI, Jump Queries, user entry variables, replacement path variables, customer exit variables, SAP exit variables, and authorization variables.
• Highly experienced in upgrade of SAP BW Application from 3.5 to BI 7.0 and from BI7.0 to BI7.03
• Worked on End-to-End life cycle projects starting from Requirement gathering from the business users and delivering the Reports.
• Thorough understanding of installation, configuration and customization of BW objects including InfoCubes, ODS Objects, MultiCubes, InfoObjects, InfoSources, InfoPackages, Transfer Rules, Update Rules, Process Chains
• Worked on Authorizations. (PFCG), Analysis Authorization (RSECADMIN).
• Participated in user meetings to resolve ongoing implementation issues, performance and code reviewing.
• Scheduling and Monitoring the Process Chains and rectifying the issues to ensure the regular data update to BI from R3 System.
• Good experience in analysis, design, development, testing, support, maintenance of applications and Team management process, coordination and monitoring deliverables from team.
• Created Function Module based data sources to get the data from ECC to BW.
• Developed Transfer /Update Rules and ABAP user exits for transaction and master data
• Worked on BADIS for the data source enhancements.
• Having good Communications skills, being a smooth team player with excellent interpersonal Skills and ability to work independently.
• Good Knowledge on SAP HANA Architecture and BW on HANA.
• Strong knowledge in the integration of BODS with SAP modules and Non-SAP data sources.
• Good Knowledge on replicate the ECC content in HANA using data provisioning methods, SLT, and DXC.
• Having Good Knowledge on Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Extensively worked in SAP HANA security including User Management, Roles and Privileges.
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting..
• Proficient in Business Objects BI(4.x) Reporting using BI Launchpad, Web Intelligence.
• Knowledge on Business Objects Design Studio, Analysis for OLAP, SAP LUMIRA and Crystal Reports
• Worked on the Most Of the components in the design studio like Filter pane, Dimension Filter, Chart, Cross Tabs,CSS style sheets, Cascading Filters, Combo Box, radio Button ..
• Trained the users on SAP Lumira on the Lumira Functionalities, getting the Data and doing slice on dice on the data .

TECHNICAL SKILLS

Data Warehousing: BODS 4.0, BODS 4.1, BI 7.0, BI 7.3

ERP Packages: SAP ECC 6.0 & R/3 4.7 E

SAP Modules: SD, MM, FI/CO, PP, PM, QMOperating System Windows 98, 2007, XP, VISTA, 7

Languages: ABAP/4, C, C++ and SQL

Reporting Tools: BEx Reporting, Web Application Designer, Business Objects, WAD, 4.1, Business Objects Design Studio, Analysis for OLAP, SAP LUMIRA

PROFESSIONAL EXPERIENCE

Confidential

SAP BODS HANA Consultant

Responsibilities:

• Extensively worked on data migrationfrom various corporate systems and interacted with end users and functional consultants.
• Extensively worked on extracting the data from SAP SD, MM,PP,FI,FL modules
• Created custom templates and custom lookups and shell jobs and used them in various business needs.
• Extracted the Data from SAP Using IDOC method
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
• Created Local, Central andProfiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3 and BI.
• Used Open Hub Services to push data out of SAP BI using BODS.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Used Data Integrator and Platform Transforms extensively.
• Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS.
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the jobs, managed users and repositories in Management Console.
• Drill down the Analytics to the detail level data.
• Run WINSHUTTLE Transaction completely within Excel by enabling users to move data from Excel to SAP, or extract data from SAP to Excel.
• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, and Transformation and Generation of Load ready data files in LSMW format.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Created cleansing package in Information Steward to standardize the company data so that all the data will be in the same format.
• Performed the Redundancy Profiling, Table Profiling, in Information Steward for to show the overlap of customer numbers intwo data sources.
• Performed uniqueness profiling functionality in Information Steward to see how many records in the Master Data Management customer information have same country/name combination.
• Cleansing the data by importing the Cleansing packages from information steward.
• Worked on Unix Scripting to run the job,
• Understanding the Business requirement, preparing the Functional specifications.
• Involved in the BW HANA Migration from BW 7.0
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/ for BW Reporting and applications.
• Prepared project related documentation (functional design, technical design, test scripts) during the different stages of a project.
• Worked on Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model based on the requirement in HANA Studio.
• Extracted sales and FI real time data using SAP Data provisioning method.
• Migrated HANA content from development, testing environment to Production environment using imports and exports method.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Preserving the Historical data/Slow changing data by using change data capture technique.

Confidential, Modesto, CA

SAP BODS / BI Lead Consultant

Responsibilities:

• Involved indata migrationfrom various corporate systems and interacted with end users and functional consultants.
• Extensively usedLSMWin order to obtain the data from various non-legacy systems.
• Transforming the dataas per the business requirements from the source systems to the target systems.
• Involved indata profilinglikesource column data profiling, detail data profiling and used validationandaddress cleansing transformations by using data quality in SAP BODS 3.2, 4.0.
• Involved in administrative tasks likeRepository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• InvolvedinMigration of Jobs and workflows from Development to Test and to Production Server stopper form the integration and system testing.
• Have good knowledge on all kinds oflookups(Lookup Seq, Lookup Ext, and Lookup).
• CreatedWorkflowsusingobject libraryand tool paletteto execute data flows.
• InvolvedinSAP BOBJ to BW integration.
• Involved in BWBackend Development, Design and Development ofSAP BWfront end queries.
• Worked with CRM to get the data buying BODS ETL Tool.
• Designed and developedsimple and complex transformations in Data Flows.
• Cleaned data in SAPDIusing proper data types and mappings.
• Experience in implementation ofRecovery Mechanism for unsuccessful batch jobs execution.
• Extensively worked withlocal Repositories, Central Repositories, Job ServerandWeb Admin client tolls.
• CreatedCustom functionsto make the code the reusable.
• Created reusable components likeWorkflow, Data flows, batch and real time Jobs.
• Worked withDatabase functions in Scripts.
• Extensively worked withSQLServerapplications like Stored Procedure.
• Extensively worked onPerformance and tuningof the jobs.
• Extensively usedTry/Catchto handle exceptions and writingScriptingtoautomatetheJob Process.
• Have good knowledge aboutWeb Admin/Management Console (i.e. Scheduling, monitoring jobs).
• Extensively worked onPerformance and tuningof the jobs.
• Identified bugs in existing mappings by analyzingthe data flow, evaluating transformations and fixing the bugs and redesign the existing mappings for improving the performance.
• Involved in Analysis ofdata formats and availability.
• Involved in Design ofExtract, TransformandLoadfunctionality.
• Involved in Design ofdata models and data mart constructs.
• Design of a dashboard capable of displaying reconciliation exceptions and sending alerts.
• Involved in High Level design,Low level Design document, Unit Test Caseand Integration Test case Preparation, Performance, and improvement of ETL.

Confidential

SAP BODS Consultant

Responsibilities:

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic.
• Installed & configured Data Services XI 3.0 in Development & Production Server.
• Developed jobs to load the data from SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform(to cleanse the Firm data) and Associate transform to generate Customer Master basic data.
• Used the case, validation, merge transforms and lookup function to validate the Customer Master basic data.
• Applied row level and object level securities for different groups and restricted data to the end users.
• Mentored end users in working with the Business Objects user module and provided technical expertise.
• Configured repositories for profiler and job servers.
• Worked on client specific business requirements to enrich and validate data and load them into the SAP system.
• Development and maintenance of Bex queries, SAP universes and WebI reports. Designed, developed, modified and maintained Business Objects universe using Designer XI R3 for ad hoc reporting.
• Involved in the design of Universe based on SAP as source
• Extensively worked on designing WEBI reports using Webi Rich Client and Info View.
• Created Combined Queries, Query level Filters and Report level Filters.
• Created and scheduling of Web intelligence reports from Central management Console.
• Worked on Simple dash boards with Design Studio for the sales and distribution KPIs to show the sales trends analysis.
• Created the Dash board for production planning based on the forecast with the Charts and planning data . So that business can take the critical decisions.
• Prepared the dash boards for risk reports to analyze the risk of the business by combing the sales, purchase, finance, inventory and production data with the Design studio dash board tools .

Confidential

Responsibilities:

• Analyzed and corrected production problems as they occur in the SAP BW system
• Provided high level of customer service to end users, business units and groups
• Handled the tickets of priority 2 and 3 tickets also.
• Understanding the procedures followed in support.
• To communicate with the customer who post the ticket
• Monitored Daily Chains, weekly Chains, and Monthly Chains.
• Handled the tickets of priority 3 and 4 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Scheduled data loads to BW from SAP R/3, Informatics, and flat files and Monitored data loads which are running daily, weekly & monthly basis and solving errors when errors occurred.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to ODS.
• Maintaining Work History for all the tickets until it is closed down.
• Checking the data in the POSDM and process the error data manually from POSDM to BW.