PERSONAL PROFILE

Worked on various projects involving foods, financials, supply chain, ecommerce, data and technology migration and gained more than 12+ years of IT experience. Highly motivated and self-starting team player, who thrives on the challenge of exceeding expectations with excellent presentation and communication skills, ability to prioritize, assign, execute and troubleshoot multiple tasks on cost and time based multiple projects.

• Having 6+ years of Strong Experience in SAP - Business Information Warehouse (BIW).
• Experienced in deploying BI application reports as an iView on to the portal.
• Experienced in working with various versions of SAP and BW, SEM-BPS. The various business areas include SD, MM, OTC-COPA, PP, FI-AP/AR, FI-SL, FI-GL, CO, Enterprise Controlling, CCA and PCA.
• Experienced in full lifecycles of BI/BW implementations and involved in all levels of BI/BW implementation such as Data Modeling, Extraction, Loading and Reporting.
• Complete understanding of ASAP implementation methodology and good understanding of the full lifecycle of the implementation, right from the feasibility study to go-live to support activity & post go live maintenance.
• Strong background and experienced in dimensional and relational data modeling: star schemas, extended star schemas, normalization, de-normalization, physical database design, relational models, key performance indicators and other OLAP considerations.
• Worked extensively with SAP BI/BW Modeling (RSA1) components like Infocubes, DSO, InfoObjects, Multiproviders, Infosets, PSA, Datasource, Infosource, Transformations rules. Developed Extract Structures and Communication Structures to transport OLTP information to BW.
• Expertise in ABAP programming, dictionary and performance tuning. Worked extensively on report programs, function modules, remote function modules, infoset queries, user-exits, transfer/update rule, start routines.
• Comprehensive knowledge of Data Warehousing Workbench (RSA1). Expertise in BI Content services consisting of Business rules, Metadata, Reference data, Extractor programs for SAP systems, Process chains, Roles and other data objects.
• Expertise in SAP and Non-SAP data extractions including BI/BW Content extraction, Data source enhancements for generic data extractions, logistics cockpit configuration and customization, CO-PA and LIS extraction, FI-SL extraction, user exits, customized delta built up for the data sources and master data extraction from SAP and flat files.
• Expertise on Hierarchies, BI Security and Authorizations, BI Statistics, Archiving, Process chains, Event chains and Open hub.
• Worked extensively in BEx Analyzer in building Queries and saving in Workbooks and created custom Queries using Conditions, Exceptions, Filters, Calculated Keyfigures, Variables & Structures and created aggregates for frequently used queries and Jump queries, also worked with Web Application Designer and trained end users.
• Used tools such as Reporting Agent, Web Application Designer, APD, Information Broadcasting, etc.
• Experienced in Business Planning and Simulation (BPS) and worked on Planning Structures, Planning Functions, Planning Interfaces and Planning Applications.
• Good knowledge in the Business Objects and Crystal Reports.

EDUCATION

MCA (Masters of Computer Applications)

VISA STATUS US Green card Holder. TECHNICAL SKILLSERP Packages : SAP BI 7.0, BW 3.5, SEM-BPS, ECC 6.0, SD, MM, FI, CO ERP Reporting : BEx Analyzer, Browser, Web Application Designer, Query Designer Languages : ABAP/4 (BDC, ALE, BAPI), J2EE, JavaScript, UNIX Shell Script, Perl, SQL, PL/SQL, HTML, XML Operating System : UNIX (AIX/Sun Solaris 2.7), Windows XP/NT Databases/Tools : DB2 9.x, Oracle 10.x/8.x, Lotus Notes database Data Loader Tools : Websphere Transformation Extender 8.1 (WTX/Ascential), Websphere Flat File/XML Loader Utilities, DataStage (ETL) Applications/Tools : NW 2004s, NetWeaver Developer Studio (NWDS), Business Objects, BI Java SDK, Enterprise Portal 6.0, RAD (Rational Application Developer), SOAP, WAS 5.x, Oracle Web Server 4.0, Developer 2000(Forms 5.0, Reports 6.0), Power Builder 4.0/5.0, CMVC 5.0, MS-Excel, Crystal Reports

ASSIGNMENT HISTORY

Capgemini, VA, Confidential, Apr 2009 - Till Date

Environment: ECC5.0, BW 3.5, SD, MM, PP, FI, CO, AP, AR, BPS, ABAP/4 and DB2 9.x
Role: BI/BW Consultant

• Worked on the full implementation of Smithfield Foods legacy oracle data to SAP BW. The architecture involved custom InfoSources, InfoCubes and ODS for Order-To-Cash COPA, Material Movement, Sales Allocation, Broker Commission reporting, Merchandising, Credit Memo Reporting, Profit Center Reporting.
• Involved in all phases of project from Migration, Data Modeling, Configuration, Development, Integration Testing, Cutover, Training, Go Live and Production Support. Meetings on status, issues, and overall progress.
• Implemented Order-To-Cash COPA in SAP BW, Profit Center Accounting (PCA) and Production Allocation to Plants based on Material Movement and Sales (COPA) data.
• Worked on BPS in forecasting Sales Plan Data. Created planning areas, levels, packages, functions, layouts, transactional infocubes and variables. Worked on manual planning and planning functions like copy, distribution and fox formulas.
• Worked on extraction, transformation, loading and reporting of master and transactional data from R/3 and Flat Files into BW/BI. Enhanced standard and custom data sources. Used infoset queries in the custom data sources.
• Created Process Chains and carried out the automated scheduling of history data, adhoc from flat files, full and delta loads.
• Created and worked on different queries: Yearly, Monthly, Weekly Sales Margin Queries, Top N customers, Expense Reports, Profit and Loss report workbooks, Production Allocation, Tie-out reports etc.,
• Created calculated key figures, restricted key figures, structures, filters, variables, conditions. Worked on jump queries, web templates and reporting agent.
• Worked on the security authorization, creation and assignment of roles to Business User, End user & Casual Users.
• Created RFC function modules and created flat-file extracts from the trusted BW source for the corporate and other B2B customers. The ABAP report program utilized the necessary R3 tables and BW COPA cube data in the creation.
• Created function modules, report programs, user-exits for master and transactional data sources.
• Worked on migrating history data from Legacy Oracle system to SAP BW. Worked on number range conversion via ABAP Program.
• Performed ABAP customization and tuning on report programs, update rule, transfer routine, user-exits and reduced the long running loads, queries and reports to the optimized performance.

Environment: ECC5.0, NW 2004s,BI 7.0, FI, CO, AP, AR, GL, BPS, Analysis Process Designer (APD), ABAP/4 and Oracle 10.x
Role: BI/BW Consultant

• Worked on the extraction, transformation, loading and reporting of Domestic R/3 and International R/3 Financial Master and Transactions data into BW/BI.
• Carried out financial master data loads into BW for Profit Center Master, Profit Center Hierarchy, GL Account Master, Company Code and Company Code Hierarchy.
• Worked on Profit Center Accounting (PCA), Work Breakdown Structure (WBS), Cost Center Accounting (CCA), General Ledger (GL) and Special Purpose Ledger (SPL) cubes and queries.
• Used APD tool and configured selective field mappings, created transformation rules from multi-provider and loaded to DSO.
• Developed interface program with user driven input to extract the financials data from infoproviders to the downstream applications.
• Created planning areas, levels, packages, functions, layouts, transactional infocubes, variables and developed retractors. Worked on manual planning and planning functions like repost, copy, distribution and formula.
• Used Direct Update and Write-Optimized DSO (Data Store Object) to load the data into BI system.
• Carried out the scheduling of data loads via Process Chains and monitored the data loading process.
• Developed the BI training documentations for the end users.
• Handled and resolved the trouble tickets raised by end user. Communicated with Team Leads, Business Integrator to resolve and to get approvals for change requests.

Environment: ECC6.0, BI 7.0, ABAP/4, SD, MM, FI, CO, BPS, BEx Analyzer, NetWeaver Developer Studio (NWDS), BI Java SDK, J2EE, Enterprise Portal 7.0 and DB2 8.x

• The architecture involves custom InfoSources, InfoCubes and ODS and the enhancement of SAP standard business content in SD, MM, FI-AP/AR and CO modules.
• Involved in all phases of project from Blueprint, Configuration, Development, Integration Testing, Cutover, and Training to Go Live. Meetings on status, issues, and overall progress.
• Interacted with business and functional teams to design the Data Warehouse Architecture for closing the gap between business process and decision support. Involved In GAP Analysis, Realization.
• Worked on Material Management and Sales & Distributions for the supply chain data on Customer (0SD_C01), Vendor (0PUR_C02), Inventory (0IC_C03), Purchase (0PUR_C01), Quotations/Order (0SD_C05), Deliveries (0SD_C02) and Sales Overview (0SD_C05) infocubes.
• Migrated BW 3.5 datasources to BI 7.0. Merged the 2004s BI 7.0 and BW3.5 objects and created unified version. Generated transformations from transfer rules and update rules in the process of migration of data flow from 3.5 to 7.0. Implemented start and end routines with transformations.
• Created Data Transfer Process (DTP) to transfer data into BI from one persistent object to another object.
• Used Direct Update and Write-Optimized DSO (Data Store Object) to load the data into BI system. Used Real Time Acquisition DTP (RDA) to load data from PSA.
• Used BEx Query Designer to created queries on DSO, Infocubes, Multiproviders and published web reports.
• Worked on manual planning and planning functions like repost, copy, distribution and formula.
• Worked on queries involving Purchase Order, Price Trends, Vendor evaluation, Purchase Order - delivery & invoice, Stocks Overview, Stock Quantity, Inventory Aging, Incoming Orders, Shipment Costs, Item Fulfillment Cycle, Top Customers etc.,
• Executed iviews in Portal.
• Performance Tuning by building Aggregates, Rollups, Partitions, Indexes, Cache Warmup, Tracing the Query outputs, Redesign the cubes based on Dimensional Table sizes, precalculation workbooks and ABAP tweaks.
• Carried out the scheduling of data loads via Process Chains and monitored the data loading process.
• Developed different BI training documentations for different users based on their roles.
• Handled Production Break Fix and resolved the trouble tickets raised by end user. Communicated with Business Integrator to resolve and to get approvals for change requests.

IBM, NC, Confidential, Apr 2006 - Mar 2007
Environment: ECC5.0, BW3.5, ABAP/4, PP, FI, CO, SAP R/3, BEx Analyzer, BEx Query Designer, Web Application Designer and DB2 8.x
Role: BW Developer

• Used BW content extractor to extract data from SAP R/3 into BW. And upgraded data sources to new extract structures using LO cockpit. Enhanced Business Content and Generic InfoCubes (RS02) with delivered/custom InfoObjects & Keyfigures. Activated FI, CO Business content and transferred data from R/3 to BW and monitored.
• Carried out the scheduling of data loads via Process Chains and monitored the data loading process.
• Installed the relevant BW Business content and identified areas for Customization.
• Created Custom Infocubes/objects for the accommodating the global data available across the organization. Developed routines for update and transfer rules using ABAP.
• Assisted in performance tuning for loading data and improving the query response time using aggregates, indexing. Created Aggregates and Multi Cubes for performance and efficient utilization of data.
• Worked on Material View (0PP_C02), Work Center View (0PP_C01) infocubes and Work Center View Queries.
• Created dynamic reporting with slice & dice functionality and Web-based Interactive reports. Developed custom BEx queries against the Info cubes and ODS objects using BEx Analyzer.
• Created and deployed the BI java application reports as an iView onto the portal.
• Worked on CO-PA extracts, loads and reports on Operating Profit, Incoming Sales Order, Customer Profitability, Customer Sales Trend, Sales Volume and Revenue.
• Created Security Authorizations by creating Authorization objects and profiles to install customized roles.
• Conducted Training for End-users and Project Team members. Mentored the BW users in handling BEx Analyzer and Browser.
• Handled post-production support and development of new design cycles simultaneously.
• Involved in complete life cycle implementation for BW project.

IBM, NC, Confidential, Apr 2005 - Mar 2006

Environment: BW 3.5, SAP R/3 4.7, SD, BEx Analyzer, BEx Browser, Query Designer, DB2 8.x

Role:BW Data Access Developer

• Worked as a technical support team member in the creation, generation and trouble-shooting, error handling and debugging of reports.
• Worked with the end user to get a thorough understanding of the reporting requirements.
• Assisted in performance tuning and improved the query response times using aggregates, database partitioning and indexing.
• Worked on queries involving Product Profitability Analysis, Sales/Cost Analysis, Distribution Channel Analysis, Fulfillment Rates, Item Fulfillment Cycle Time and Product Analysis
• Created queries using BW reporting variables, navigational attributes and filters.
• Created Drill through Queries from summarized Info cube report to detail ODS data. Worked on Query building, Filtering, Structures, Free Characteristics, Restricted Key Figures, calculated key figures and Variables, Query variants using BEx Analyzer.
• Used filtering, conditions, variables, currency conversions, drilling, jump queries and navigational attributes.
• Familiar with Role based security and authorizations. Developed different BW training documentations for different users based on their roles.
• Worked on Go-live and production support activities.

IBM, NC, Confidential, Apr 2004 - Mar 2005
Environment: SAP BW 3.5, SAP R/34.6C, MM, PP, BEx Analyzer, BEx Browser, BEx Query Designer, DB2 8.x
Role: BW Developer

• As a part of the BW implementation team, involved in gathering user requirements and data modeling and used SAP-BW Extended star schema concepts.
• Activated BI Content for standard MM/PP Info Cubes, Info Sources & Info Objects.
• Worked with Data Management Group during the process of Data Analysis and Data Mapping.
• Worked on Daily basis Generic Extractors, Data Sources, InfoSources, Transfer Rules, Update Rules, InfoPackages, InfoObjects, ODS and InfoCubes.
• Implemented Updated Rules for InfoObjects and used Custom Exits in creation of Variables. Used debugging process for verification of extraction process.
• Enhanced master Data Sources for 0material and 0customer and created custom maser Data Sources using tables, views and set up delta for custom fields.
• Implemented custom designed notification mechanism for every day data load and used SAP Events and external e-mail mechanism to report the load status.
• Worked Business Content Installation and Activation, Data cleansing in PSA and error handling.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Worked on reporting using the BEx Analyzer to summarize data. Worked with aggregates, InfoSet queries, templates and workbooks.
• Worked on post production support activities include data loads, month end closing loads, and missing data issues in reports

Environment: SAP BW3.1C, SAP R/3 4.6C, MM, PP and DB2 7.x

• Involved in the development, testing of enhancements and user requirements for BW implementation by identifying the needs of customer, modeling the data, and defining the data sources at OLTP.
• Used SAP - Business Information Warehouse Extended Star Schema for data modeling.
• Worked on activating the standard delivered business content in the form of InfoObjects, InfoSources, ODS, InfoCubes, and customizing it by creating new business content using the AWB.
• Worked on data extraction of SAP R/3 system using various extractors and non-SAP systems (via flat file). Also worked on extending some of the extract structures by adding fields.
• Created new data targets i.e. InfoCubes and ODS by creating interfaces at BW and SAP R/3 level.
• Created several ODS objects for data staging. Configured data sources in R/3 by using LO Cockpit (LBWE). Scheduled and Implemented delta mechanism for periodic loads.
• Activated BI Content for standard SD/MM/PP Info Cubes, Info Sources & Info Objects.
• Worked on 0PP_C02, 0PP_C01 and 0PP_C06 PP infocubes.
• Used ABAP code in writing routines for transformation rules, whenever there was a need to enhance the requirements.
• Extensively involved in defining Hierarchies, ABAP in update rules and User Exits.
• Resolving the trouble tickets raised by end user, communicating with Business Integrator for resolving the issues and to get approvals for change requests.
• Designed and developed Master Data Infosources & transactional Data Infosources

Environment: SAP R/3 4.6C, SAP BW3.1C, SD, FI, DB2 7.1

• Worked as a post-production support team member and handled data loads jobs.
• Activated custom developed infocube to capture external data.
• Created Source System for SAP R/3 and Flat Files Systems. Configured ALE Settings in the creation of SAP R/3 Source System
• Created and Maintained Transfer Structures, Communication Structures, Transfer Rules and Update Rules for InfoSources, ODS objects and InfoCubes.
• Worked with Transactional Data InfoSources to load Data from SAP R/3 and Flat Files systems into SAP-BW
• Created Info Packages and Scheduled them in order to load Master Data and Transactional Data from SAP R/3 as well as Flat File Source Systems into BW
• Monitored the data loads and Loaded transactional data into PSA and updated data from PSA to ODS and activated ODS.
• Generated and Maintained Aggregates and Rollup activities on FI and CO InfoCubes as part of the Infocube Management.
• Documentation for Meta Objects like InfoCubes and InfoObjects.

Environment: SAP R/34.0B, MM, SD, ABAP/4 and DB2 7.1
Role: ABAP Developer

• Development of Interface for data loads from the legacy system to SAP.
• Extracted the data from Legacy system and performed the data cleansing.
• Designed and developed BDC program to Data upload to SAP.
• The BDC program has been scheduled to run at background.
• Created ABAP data conversion programs to load master, vendor and customer to SAP.
• Design, development, trouble-shooting and testing.
• Started SAP training as a developer for the SAP implementation team.

Confidential, MI, August 1999 - Mar 2001
Environment: RAD, J2EE, WAS, JSP, DB2 8.x, PL/SQL, XML, Web Services, Websphere ETL loader utilities, Ascential, AIX, Shell Scripts, Perl, Sax Parser, CMVC (Version Control), Developer 2000 (Reports 6i), Oracle Application Server 2.0 (OAS), Oracle 8.x, Sun Solaris, Windows XP

• In a team of 30, assisted as a Coordinator (onshore/offshore), Data Specialist, Java Developer and ReportDeveloperfor clientsIBM and Sun Microsystems.
• Interacted with multiple interface teams, test teams and performed as a lead in gathering information and coordinated troubleshooting, support and problem resolution efforts.
• Developed and implemented catalog data loading of various IBM, Lenovo brand products from SAP and non-SAP sources into E-Commerce (Common Commerce Engine - CCE) DB2 database.
• Developed various extractors, transfer and loader utilities using Java, JDBC for batch and real-time feed processing. The utilities pull include flat, XML catalog data file via FTP, MQ, Web Services and DbConnect.
• Developed Stored Procedures, Triggers, Packages and performed SQL tuning and improved the catalog extraction, load process and report generation.
• Implemented the generic extraction, transformation and loader utilities worldwide. The generic catalog utility supported 10 different brand catalog data loads.
• Fine-tuned the catalog loader utility to perform 25 million records in 2 hours.

Environment: Developer 2000 (Forms 4.5/Reports 2.5), Oracle 8.x, PL/SQL, Stored Procedures, Triggers, Packages, Pro*C, SQL tuning, UNIX, Sun Solaris, Windows 95

• Implemented various technology migration projects onshore and offshore for clients Lucent Technologies - NJ, British Oxygen Company - UK, Maersk Oil/Gas - Denmark, Exor Corp - UK.
• Assisted as a Lead, Report Developer and Programmer in the analysis, design, development and testing of migration applications from older character version of Forms3.0/Report 1.0 to Developer 2000 (Forms 4.5 / Report 2.5).
• Converted complicated reports like pre-printed stationery break reports, bar coding, inter-related reports, nested reports and matrix reports.
• Developed stored procedures, triggers and packages. Performed SQL tuning and enhanced the data retrieval for the report generation.
• Engineered the conversion of user-exits in Pro*c to DLL, PL/SQL and Reports 3.0. Handled Key-mapping issues with the end users.
• Constructed UNIX shell scripts invoking the forms and reports.

Confidential, India, Apr 1996 - Jul 1997

Environment: Power Builder 4.0, Oracle 7.x, PL/SQL, Stored Procedures, Packages, SQL tuning, Windows NT

• Assisted as a programmer in the migration and development of financial applications of Lease, Deposit and Hire Purchase System from FoxPro2.0 to PowerBuilder with Oracle as back end.
• Responsibility included database design, system study, coding and testing.
• Developed packages, stored procedures database triggers.
• Debugged, Fixed and supported multiple level testing with the end user.