SUMMARY:

• 15 plus years’ experience in IT and 10 years of SAP ECC/FI - CO/CRM/HANA, Hadoop, HR, HCM, Tera data, Testing, SSIS, MDS, DQS, SSAS, SSRS, DAX, MDX, Power BI, SAP ECC, Success factors, Data Conversion, HL7, SAP Data Services/Data Migration and SAP Business Objects.
• Implemented 4 complete Lifecycle Data Services projects including requirement gathering,data modeling, EIM, extractions, Teradata Bteq and utilities (TPT,MLOAD,FLOAD and FASTEXPORT),Server Installation, UNIX, Tera Data, CRM Campaign, Marketing, Sales force, Information Steward, Unix, SQL Server, TOAD, Configuration, Upgrade, data staging, Master data management, Web Services, Data Quality, data cleansing, Python Code, Address Verification, data quality and transformations and reporting.
• Expert knowledge of Help Desk tools and trouble ticket tracking processes.
• Good Experience inMDM extended star schema including Info Cube design,ABAP,DSO design, Info Objects, Info Sources, LSMW, MDM, Transformations, DTP’s.
• Worked with following MDM core functionalities likeIdentity resolution, Data Services, Data Governance Utilities, Data integration, Data profiling.
• Experience in creatingviews,Perform column profiling,Source System Configuration, address profiling,dependency profiling,redundancy profiling,uniqueness profiling, creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing taskswithInformation steward 4.0.
• Designed the jobs using the mapping rules in Legacy Mapping Templates and SAP Mapping Templates and loading of the data from Source database to Stage Database in SQL Server 2008.
• Responsible forcreating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0.
• Created views,Performed different kind of profiling like column profiling,address profiling,dependency profiling,redundancy profiling,uniqueness profilingon IS 4.0.
• Generated data remediation reports and Daily reconciliation reportsfor data validation for source to target and target to source.
• Loaded source data for different countries one by one using Conditional Flows, Scripts and Global Variables.
• Performed Mapping, Validations (Lookup, Mandatory, Format), Enrichments in AIO Jobs for Customer Master, Vendor Master, Material Master, PIR.

TECHNICAL SKILLS:

Tools: Business Objects 4, XI r3, r2, r1, 6.5, ; WebIntelligence 4, XI, 6.5, ; UDT/IDT; Data Integrator 6; Data Services 4.2, XI 3.2, 4; SSIS; SSAS; Ab Initio; BEx Query Designer; Sagent; BrioQuery; Cognos; Genio; Erwin; Crystal Reports 2011, XI, 8.5; Xcelsius 2008 / Dashboard Designer; IIS; SQL Loader; Visio; PVCS.

Languages: Visual Basic 6; PL/SQL; SQL; Transact-SQL; Active Server Pages (ASP); JavaScript; VBScript; HTML; DHTML; CSS; XML; API; SAS; Cobol.

Databases: SQL Server 2008, 2005, 2000, 7.0, 6.5; Oracle 11I, 10I, 9I, 8I, 7; Teradata; Hyperion Essbase; Netezza; MySQL; MS Access; DB2; Sybase;

Business Applications: SAP (ECC 4.7, 6.0 --Logistics, SCM, SAP Data Marts,SD, SAP MM, Material Master, Vendor Master, iDocs, LSMW, ++); Oracle Financials.

OS: Windows Server 2008/2003/7/Vista/XP/2000/NT/98/95/NT.

Other: OLTP; OLAP; ODBC, ADO; OLE DB;Kimball; Forecasting; Trend Analysis; Full Life-Cycle Development; Star and Snowflake Schemas; Executive Dashboards; 3-Tier Programming.

Industries: Retail, Consumer Products, Investments, Pharmaceuticals, Finance, Insurance, Telecommunications, Energy and Manufacturing.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose CA

ETL Lead

Responsibilities:

• Involved in Implementation of SAP Planning data migrated to Anaplan, Hadoop, UNIX,Tera data, SAP MM, HR, HCM, SD, HL7, ECC, Success factors, FI-CO, SQL Server, Teradata Bteq and utilities(TPT,MLOAD,FLOAD and FASTEXPORT),CRM Campaign, Help Desk tools and trouble ticket tracking processes, SSIS, MDS, DQS, SSAS, SSRS, DAX, MDX, Power BI, Marketing, Sales force, SQL, PL/SQL, Tera Data, Pre-Load Validation, Unix, Data Loading, EIM, Legacy systems, ECC systems. involved in BOBJ Queries from ECC, BOBJ 4.2, SAP BPS, SAP BW, TOAD, Native HANA, MDM, MDG, Data Migration, Web Intelligence Reports, HR, LSMW, ABAP
• Worked on Cost center data validation with business rules, Web Services, Data Reconciliation. Worked on Business Analyst, validating the Material Master data derivation rules.
• Worked on analyzing the BW Data model, Business Objects Queries.
• Experienced working on data integration projects with SAP and knowledge of database tables and relationships in SAP.
• Involved in data validation, migration rules and supporting to the Business users.

Confidential

ETL Lead

Responsibilities:

• Involved in Implementation and Constructed reusable templates to speed ETL development in BODS and provide auditing functionality. SAP ECC Master Data validation, HR, HCM, Success factors, HL7, Teradata and utilities (TPT,MLOAD,FLOAD and FASTEXPORT), UNIX, Hadoop,, FI-CO, Tera data, CRM Campaign, Marketing, SSIS, MDS, DQS, SSAS, SSRS, DAX, MDX, Power BI, Sales force, Business Analyst, SQL, PL/SQL, SQL Server, ETL Scripts, Testing, Enterprise Information Management, Unix, Tera Data, Data Services Version upgrade 4.2, TWS, Hadoop Integration, Master data management, Server Installation, Configuration, XML, MDM, MDG, Upgrade, Master data governance, TOAD, IDOC’s, Data Quality Transformations, Led sessions explaining usage of templates and gathering ideas for improvement.
• Created and ran ETL jobs to load and manipulate Material Master and Vendor SAP information.
• Administration and configuration of multiple data stores and servers and Information Steward.
• Upgrade of First Logic / Data Quality to Data Services, LSMW, EDI/ BAPI Development, Python code, Help Desk tools and trouble ticket tracking processes, Data Quality transformations Match, Associate with data and multiple country address cleansing.
• Developed, published, and scheduled batch and real-time jobs.
• Produced contact duplicate checking ETL project, ETL Developer including match transforms and adjustable parameters.
• Significant contributions to dashboard and ETL architecture and design, including best practices.
• Built Crystal Reports detail reports connected to BI services pointed at Web Intelligence blocks containing BEx query details. Reports launched by and received prompts from Xcelsius dashboard.
• Acted as go-to for the team for technical concerns and idea development.
• Involved Data loading in to SAP and data validation with final Mapping rules from the business.
• Built hierarchies, Info Sets for Core Reporting Queries.
• Implemented Data Services functions like Lookup ext, Decode, Handling the Null values from the source files, trim the data fetched from a third party systems like KBM, Mapics etc..

Environment: Data Services (BODS) 4.2, HANA, Business Objects (WebI, UDT, IDT).

Confidential

ETL Lead

Responsibilities:

• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked in the BO Data Services 4.2,SQL Server, SAP HR, HCM, Testing, Business Analyst, FI-CO, UNIX, SQL, PL/SQL, EIM, Master Data Governance, HL7,SSIS, MDS, Hadoop, Tera data, DQS, SSAS, SSRS, DAX, MDX, Help Desk tools and trouble ticket tracking processes, Power BI,CRM Campaign, Marketing, Sales force, SAP Data Marts, IDOC Data validation, Unix, Testing, Tera Data, Server Installation, Implementation, LSMW, MDM, MDG, Tableau, Configuration, Version Upgrade, Data Quality Transforms, MDM, EDI/BAPI, Environment, ETL Developer 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,ETL Scripts Lookup ext, Decode functions, Data Quality Transformations, Python Code, Ifthenelse scripts to load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Extracted Data from all the Relational Databases including oracle, Unix, Data Services Version upgrade 3.x to 4.2, Information Steward, Microsoft Sql server and loaded in different environments which include BW,Web services, ORACLE,TWS, XML,SQL SERVER, and .txt & .CSV files.
• 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.
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0
• 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
• Implemented use of SAP ABAP data flows to extract data from SAP Applications ECC, BW etc.
• Developed integration between different systems ( SAP BW, SAP ECC, SQL Server )
• 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 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 and implemented numerous accounting systems including applications such as G/L, A/P, A/R, F/A, and Financial Reporting.
• Worked on Cut-over activities and data validations and post. Go-live support.

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

Confidential

ETL Lead

Responsibilities:

• Involved in Implementation in SAP BODS 4.2,ETL scripts, Unix, Testing, SQL, PL/SQL, FI-CO, SAP Data Marts, Microsoft SQL Server, SAP HR, HCM, SSIS, MDS, Hadoop, Tera data, DQS, SSAS, SSRS, DAX, MDX, Power BI, EIM, Configuration,XML, CRM Campaign, Marketing, Sales force, Python Code, Master Data management, Tera Data, ETL Developer, Server Installation, FI-CO, Tableau, Upgrade version, Hadoop data Integration, LSMW, Information Steward, BODS Version upgrade 4.2, SAP PLM Implementation and Custom Function modules for the Specification and Recipe management data.
• Involved in Setting up the BEx properties, Query Designer, Analyzer, Workbooks and Structures. Restricted the characteristic values and Key figures.
• Worked on Hierarchy Data, Data Quality Transformations, LSMW Configuration, Function module Extract structures, HANA Attribute views, Calculation Views, XML Data, Data cleansing, Information Steward, Replication for the BODS trouble shooting jobs, Address verification, maintaining data sources.
• Worked on BEx Queries, Variables,TWS, IDOC, BAPI Data validation, SQL, PL/SQL, Unix, Attribute values, Authorizations, default values.
• Worked with Functional area of EHS and QM modules. Involved with Specification types, Specification categories, HANA Database sizing, Classes and Property tree data validation with NWBC transaction.
• Worked on BODS Source Database and Target Database validations,checking the Central repository and Local repository Data store connections and transformations, sending the Files to respective destinations.
• Built Info Cubes, DSO, Master Data Governance, Info Sets and Core Reporting Queries, Business Objects 4.0 development, Reporting Scenarios.
• Involved in BW extraction, Custom Function modules, Data validation with Background user.

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

Confidential

ETL Lead

Responsibilities:

• Extensively worked Implementation, Server Installation, Unix, Configuration, FI-CO, SAP BODS Designer Components- Projects, Jobs, Information Steward, Performance Testing, Workflows, Data Flows, Data Store and Formats.
• Worked on Information Steward, LSMW, Hadoop, Tera data, Tera Data, SQL, PL/SQL, BAPI and IDOC Data validation, XML, Version upgrade, Master Data Data manipulation ETL Scripts, Data Profiling and Data Quality toolsGood Knowledge in Data Warehouse Table analysis and Implementation.
• Validated the BODS data with new versions of data changes from Development to Production.
• Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.
• Created mappings using Merge Query, Master Data Governance, Case, Date Generation, Xml pipeline, Table comparison and Lookup..
• Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology etc.
• Developed highly complex WEBI reports using various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking, Controlling lov’s incorporating sound business logic.
• Good knowledge in deployment, Tomcat, Web services, Java, Web sphere, unit testing and user acceptance testing thereby ensuring quality assurance
• Having excellent communication skills and good team player with the ability to work in association with team members for successful implementation of projects.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.

Environment: SAP BO Data Services 3.x

Confidential, ATLANTA, GA

ETL Lead

Responsibilities:

• Worked as BODS Developer, Business Objects 4.0, FI-CO, EIM Implementation Data Services, Data Integrator Functions, Server Installation, Configuration Technical and Functional Specifications, Performance Testing, ETL Scripts, Finance data validation, Unix,Tera Data, SQL, PL/SQL, Sales territories, BEx Query Designer, Master Data Governance, Version upgrade, BEx Analyzer, Conditions, Exceptions, HANA Modeling,Tomcat, MDM, Web Application Designer, Global Structures and Formulas.
• Extensively worked on SAP BODS Designer Components- Projects, Jobs, Performance Testing, Workflows, Data Flows, Information Steward, XML,LSMW, IDOC method to load, SQL, PL/SQL, Data Profiling, Address verification, Web services, Java, Data Quality, Data Stores.
• Good Knowledge in Data Warehouse Implementation.
• Involved in initial & incremental Extraction and Loading of data into Data Warehouse using SAP BODI.
• Created complex mappings using Merge, Query, Case, Date Generation, Xml pipeline, Table comparison and Lookup..
• Good knowledge on DBMS concepts like conceptual, Relational schema, Normalization, Demoralizations, Indexing methodology e.t.c
• Good in writing complex SQL query on various RDBMS system.
• Worked on SCM, ABAP Custom development, Informatica, APO Demand Planning,Function modules, BAPI, Vistex Bill backs, Agreements, Global Claim Requests Master data and Transaction data Data loads using Process Chains.
• Designed & developed Sales Commission Reporting using the Vistex sales incentive module (/IRM/LIS RM IPSIHDR,/IRM/LIS RM IPSIITM,/IRM/LIS RM IPSIKON)that is integrated with SD module.
• Involved in SAP BW Development area and Front end reports Bex Reports, HANA, Building the BICS Connection ( Business Intelligence Consumer Services ) to BEx queries, Business Objects Explorer 4.0, IDT 4.0, Universe Designer Tool, Business Objects Analysis 4.0, Crystal Reports 4.0, Business Objects Dash board 4.0,Business Objects Mobile User 4.0 with respect to the business requirements.
• Involved in Business Objects Information Design tool, Web Intelligence 4.0, Business Objects enterprise 4.0 developments.

Environment: ECC, COPA, SD, SCM, Vistex, Business Objects 4.0, ABAP.

Confidential

ETL Lead

Responsibilities:

• Understanding the Implementation and requirements,feasibility.
• Extracted data from SAP ECC SYSTEM and loaded into target ORACLE database system.
• Design, develop, test and implement Extraction, Tera Data, Unix, Server Installation, FI-CO, SQL, PL/SQL, Configuration, Informatica, Teradata, FI-CO Transformation and Loading (ETL) for SPECS data warehouse using Business Objects Data Services (BODS).
• Create Projects, Batch Jobs and Real time Jobs, Workflows and Data flows using object library.
• Configured Version upgrade, Business Objects Data services 3.2 with some source system as R/3(ECC 4.5) and NON-SAP Data as source system.
• Configured the Job Server and Access Server with Server Manager.
• Extracted sample data from SAP ERP ECC 6.0 source system from Master Material Data tested by running the sample reports.
• Configured the IDOC to Extract the Real Time Data By configured the Real Time client in SAP ECC side.
• Created Distribution Model to send IDOC to Data Services.
• Created a Real Time Job to extract the Data where Real Client provided from the source system.
• After receiving the source data through online from SAP, I applied different SAP BAPI transforms.
• Data Integrator (Hierarchy Flattening, History Preserving, Pivot, Table Comparison) Data Quality (Data Cleanse, USA Regulatory Address cleanse).
• Involved in SAP BODS installations and integration with sap systems.
• Create complex transformations in dataflow.
• Deciphered business rules to implement, test, debug and document Data Services batch jobs and real time jobs to extract data from a variety of data sources using Data Integrator Administrator.
• Applied the recovery mechanism in job level and workflow level.
• Applied pushdown operations to minimize the time taken by the Job
• Using BODI/BODS, created the project to extract the data from different systems and loaded into SAP BW/BI.
• Applied performance tuning techniques in BODS level by enabling caches, join, rank, execute dataflow parallel, execute workflows parallel, enabled DOP in the Dataflow level and enabled run as a separate Process.
• Resolve the productions issues on time.
• Involved in Performance tuning.

Environment: ECC, COPA, SD, SCM, Vistex, Business Objects 4.0, ABAP.

Confidential

ETL Lead

Responsibilities:

• Understand the customer business and their needs scenarios and suggest them to go with the best solutions which are possible with sap bods.
• Explain the benefits of rapid mart packages and suggest them to implement in their project and involved in installation of rapid mart.
• Involved in documentation.
• Involved in Tera Data, Unix, SAP BOBJ DATA SERVICES objects and functions like (creating project, Teradata, SQL, PL/SQL, Dataflow, Workflow, queries, transformations, repositories and repository manager, SCD’s, time dimension implementation, functions like date function, pivot and reverse pivot, CDC’s, integration with sap systems, data assessment, try catch, multi user access in BODS hierarchy data handling and look up functions… ).
• Involved in Rapid mart package XI3.x, rapid mart implementation and configuration, variables creation, file maintenance, creation of rfc connections and documentation.
• Involved in Rapid Mart Custom field enable and enhancements, central repository customization, SCD’s customization.
• Involved in Rapid mart performance tuning partition, data transfer, indexes and hierarchy expansion.
• Involved in rapid mart recovery mechanism.

Confidential

SAP BO/BODS Consultant

Responsibilities:

• Created Simple/complex Transformations in Dataflow using Data Integrator Designer.
• Design and develop Data Integrator scripts for data transformation.
• Extracted the data from Oracle 9i and Sybase, SQL, PL/SQL, applied different transformations, cleansed and then the data into Oracle 9i. created Projects, JOBs, Workflows and complex Dataflow
• Extracted the data from the client system through the FTP then using these flat file data source, created ETL to load into target system.
• Created Projects, JOBs, Workflows and complex Data flows.
• Co-coordinating with client to gather the new requirements and working with existing issues.
• Understanding Various Universes.
• Created monthly and daily basis reports using universe.
• Design and Create the Universe with required classes and objects, modifications and maintenance of Universes on Oracle Database.
• Created Dashboards for Top management using Xcelsius 2008 using Live Office and QAAWS by using various components.
• Developed Xcelsius Dashboard on top of Webi report.
• Developed what-if analysis dashboard to analyze how different decision effect.

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

Confidential

SAP BO/BODS Analyst

Responsibilities:

• Involved as SAP BOBJ ETL Developer from Realization phase in End-to-End Data Warehouse implementation project.
• Extracted data from SAP SYSTEM and loaded into ORACLE database system.
• Configured Business Objects Data services 3.2 with source system as SAP ECC 6.5.
• Configured the Job Server and Access Server with Tool called Server Manager.
• Create complex transformations in dataflow.
• Extensively used recovery mechanism.
• Created a Real Time Job to extract the Data where Real Client provided from the source system.
• After receiving the source data from SAP, SQL, PL/SQL, applied different transforms in Data Integrator (Hierarchy Flattening, History Preserving, Pivot, Table Comparison).
• After receiving source data I added some columns to target database table by using look up function(LOOKUP EXT).
• Enabled the MAP CDC transform operator to capture the changes at source side.
• Implemented different SCD TYPE 1 and SCD TYPE2 to load the current and historic data.
• Created different variables i.e. global variables, local variables, parameter and substitution parameter those are created at different levels i.e. repository, job, workflow, dataflow etc.
• Implemented the conditional operator to load either full load or delta load.
• To increase the performance at project level we created embedded data flow (To reuse the objects and to debug the objects)and we enabled degree of parallelism at job level.

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

Confidential, Plano, TX

SAP BODS 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, Unix, Tera Data, 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, Santa Clara, CA

SAP BODS Consultant

Responsibilities:

• Involved in SAP BI integration with FI Asset management, HCM, FICO, PP, PM, SRM, BCS, BPS, BPC, Supply chain management, Business Objects XI R3, Xcelsius, Data Integrator, PM, PP (BOMs, Workcenters, Routings), Service Analysis, Service Contracts, SD, ECC CO-PA, BODS, FI, SD, HR, Security design, CRM, Install Base, QM,, Tera data, SRM and PS modules, Analyzed the Data model and Data flow.
• Consolidated data from both Booking and Revenue planning area for Opportunities into one Cube to create several reports as required by the client.
• Worked on Customer Master Data BI Integration on CRM, Data Services, APO (SNC, EM) and ECC SD (OTC, QTC, ITC) modules.
• Involved in preparing the Business Blue print for the solar business Operations.
• Worked on SAP BI Integration with the Legacy data Base DB2.
• Involved in FI Booking/ Billing/ Backlog, Cash flow Report, Milestone Payment Report.

Environment: SAP BI, Business Objects.

Confidential

SAP BW/BO Consultant Manufacturing Industry

Responsibilities:

• Worked on SAP BI integration CO-PA, FI, Business Objects XI R2, FI Asset management, Supply Chain Management, CRM, SRM modules, Analyzed the Data model and query performance.
• Involved in Shopping cart Data issues for end users using Uni center Remote control tool.
• Worked on configuration testing using Mercury tool to track the defects and maintained the status.
• Worked extensively with the major functionality of FI and SD (OTC, QTC, ITC), Data Services, Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
• Maintenance of master models such as various sales forecast models
• Supported configuration and enhancement activities for supply chain activities especially in the areas of MRP, Master Data, Forecasting, Planned order and production order processing
• Involved in SAP BI integration with SAS, DB2, SRM and ECC PS module.
• Worked on WBS element for PS module.

Environment: SAP BI, Business Objects, CS, Install Base, PS.

Confidential

SAP BI CONSULTANT

Responsibilities:

• Worked on BI integrated planning, BW/BPS Integration.Design, develop and implement Info Sources for BW and aggregation of BPS plan data.
• Design BPS Planning Environment architecture with area, level, package and Fox functions.
• Minimize BPS configuration expenses for Business planning, balance sheets, profits and sales.
• Analyze BPS Budget Formulation with Top Down and Bottom up planning.
• Analyzed the business requirements for the planning profile and the planning profile group.

Environment: BW, BPS, PS

Confidential

SAP BI CONSULTANT Manufacturing Industry

Responsibilities:

• Worked on BPS scenarios for Trade Promotion and Consumer Campaign business processes.Provided SAP Security design, SAP Sales and distribution module configuration, support for SAP Net Weaver systems running BI 7.0 (Net Weaver 2004s) and Supply Chain Management, FI and ECC CO-PA.
• Performed day-to-day administration, performance analysis, Universe, Web Intelligence, Crystal reports and problem determination and resolution, database reorganizations.
• Provided SAP Basis planning, implementation, testing, support for upgrade of BW landscape from 3.5 to 7.0.
• Assisted primary Basis consultant with many technical aspects of upgrade.
• Tailored Transformations and Routines to optimize performance.

Environment: R/3, BI, SEM/BPS.

Confidential

SAP BW/ABAP DEVELOPER FINANCIAL INDUSTRY

Responsibilities:

• Worked with BEx Analyzer to generate Queries and embedding them into Workbooks.
• Monitoring the Process chains for daily and monthly loads for different applications.
• Monitor daily load, rectify the problems for data load and provide solutions for repetitive problem.
• Involved in Delta issues, process chain failures and table space issues.
• Provide solutions for Production Trouble Reports.
• Configured BEx Queries for Free Characteristics, Calculated and Restricted Key figures, Filters, Variables and Exceptions.
• Extensive use of Process Chains (RSPC) to automate loading of all master and transaction data.
• Excellent working knowledge in debugging ABAP Code in Start routine, Update routine & User exits.
• Involved in Production support and resolved the errors during the transition period.

Environment: SAP BW/BI, FI, CO, Logistics.

Confidential

SAP BW/ABAP DEVELOPER AUTOMOBILE INDUSTRY

Responsibilities:

• Involved in development, testing, final preparation & Go live phases.Created generic extractors, Data Source enhancements, user exits and customized delta built up for the data Sources.
• Developing various RRI/Jump Targets using RSBBS. Developing Local specific Process Chains.
• BEx reporting with the use of RRI interfaces, filtering, conditions, variables, currency conversions, drilling, Jump queries and navigational attributes. Exception handling using Reporting Agent through SAP Mail, Batch printing and alert monitor.
• Designed and developed queries to report Balance sheet and profit &loss data and separate interface in the form query as data provider.
• Handled postproduction support, and preparing how to documents for end users.

Environment: SAP BW, SD, MM, FI

Confidential

Programmer Analyst Automobile Industry

Responsibilities:

• Involved in active interaction with the functional consultants, tailoring and developing the applications as required by the end users.Interacted with team members of Data Warehousing team to understand their data requirements as per End-user Query needs from Inventory perspective.
• Developed different business solutions for problems arising from unique client requirements
• Involved in the development and modification of specific reports as required in the areas of FI/CO, MM And SD modules.
• Involved in the development and modification of SAP programs using ABAP/4.
• Worked with LSMW considerably to handle the interfaces Development of Layouts with sap scripts and Smart forms like MM: changes made to sap standard PO layout to customize as per clients requirements.
• Using Runtime Analysis, debugging and dump analysis, analyzed the performance of Programs Created in ABAP/4 Workbench.

Environment: SAP R/3, SAP ABAP