Candidates About

Pramoda K Tripathy

SAP BW / BOBJ/ABAP/ HANA Tech Lead

    Secrete Clearance - DOD and CBP

Summary

• Over 21 Years of Professional Experience (Including 9 years’ experience in LMP Project, US Army and CBP) in Analysis, Design, Development and Implementation of Business Applications, this includes around 16 years in SAP BW/BI, SAP BW powered by HANA, R/3 and ECC 6, ABAP as a SAP BW/BI Tech Lead Consultant and 5 years in mainframe application as a Senior Application Development DBA. Currently worked in SAP BI 7.3 and knowledge of HANA modeling.
• Implemented 15 full lifecycle BW/BI projects as Developer / Analyst and Architect
• Technical lead and developer/analyst for SAP BW 7.3 implementations powered by SAP HANA.

• Experienced with Data-Modeling, Data Extraction, InfoCubes, InfoSource, MultiCubes, Infoset, DSO objects, InfoPackages, DTP (BI 7.0), Process Chains, Autosys, Monitoring, LO Cockpit for SD, QM, MM, PP, EWM & FI/CO.
• Scheduling of Data upload with data Targets as PSA/DSO/InfoCube. Proposed Transformation (BI 7.0), Transfer Rules (3.X, 7.3), Update Rules (3.x, 7.3), Update Routines, Start Routines, End Routines and User Exits. Developed Roles and User Authorization.
• Utilized BEx Analyzer to build Queries as the data foundation for Business Objects.
• Created Custom Queries using Variables & Structures, Calculated Key Figures, Restricted Key Figures.
• Created BEx queries for WAD and data foundation for Business Object.
• Excellent experience in Performance tuning (ABAP, query and data load).
• Experienced with BO (Crystal, WEBI and Xcelsius) 4.0.
• In-Depth understanding of BW functionality….
  • SD - Order management, Pricing, Shipping, Delivery.
  • FI/CO – Financial Accounting General/SPL ledger, Accounts Receivables(AR) and Accounts Payables(AP)
  • MM -Inventory Management,
  • PP  - Production Planning,
  • QM – Notification, Task, Cause
  • HR – Human Resource
• Create and deliver training to BW end users.

Professional History

Computer science corporation,  Virginia, VA                                Sep 2008 – Present

BW/BI Technical Architect Lead Consultant

Client: Federal Project  (9 years’ experience in LMP Project(US Army and CBP).

• Currently involved as an architect and developer for LO Cockpit extraction to BW and reporting in CBP client.
• BW/BI Technical Architect /Developer for all functional areas.
• Worked in  SAP BI 7.3 and knowledge of HANA modeling.
• Involved as an architect and developer for SCPRT project (Supply Chain Planning  reporting.
• Worked as a technical lead on implementation of NULO reporting
• Successfully implemented GTAS/SFIS trial balance summary/detail reports.
• Worked on requirement gathering, design, development and implementation of BEx and Business Objects (Crystal, WEBI and Dashboard) reports.
• Worked as a technical lead to design and develop FI/CO and FI/FM reconciliation reports, AR/AP reports and UFO/UCO reports.
• Productionized ECC Queries to BEx queries as the data foundation for Business Objects (Crystal,WEBI and Xcelsius) reports.
• Successfully implemented Standard Financial Information System(SFIS) “Trial Balance Summary” and “Trial Balance Detail” Reports
• Successfully finished a enhancement project for Budget Stratification in BI 7.0.
• SD project to extract data from LO Cockpit (Sales, Delivery, Billing & Shipment) & Z-TABLES to EDW in BI 7.0 environment.
• Interacted with users to gather requirements and transformed them into a data model with the concept of star Schema.
• Data modeling and Defined dimensions.
• Developed the process to extract data from source system to different layers (Staging, Integration, Performance and Data Model).
• Designed and built Infocubes & ODS, Prepared Infocube and ODS Design Documents (Technical specs and Functional Specs).
• Designed and built InfoObjects and prepared InfoObjects design Documents (TS & FS).
• Designed and Built Multicubes, prepared Multicube Design Documents.
• Created transformation between Datasource and DSO/InfoCube.
• Created InfoPackages to load data from SAP to PSA.
• Created DTP to load data from PSA to DSO/InfoCube.
• Created Custom extractors in SAP using View, Table, Function Module to extract data from Z-tables.
• Developed User Exists, Start routine, End routine for Sales Orders, Delivery and Billing.
• Developed END routine to integrate Item level data with Header data.
• Prepared Unit test script for transports.
• Created flexible reports using calculated key figures, filters and variables. Provided drill down functionality on reporting. Extensively used all the features in BEx Analyzer for a different CR (Change request).
• Queries were developed using Filters, Formula, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Developed BO(WEBI, Dashboard) reports using BEx as the data foundation
• Created workbook for Budget Finder and Zero-demand query.
• Performance tuning for loading data and improving the query response time using BI Accelerator, Aggregates, Compression, partitioning and Indexing.

Environment: SAP BW 3.5, BI 7.0, BI 7.3, SAP R/3 4.6c, ECC 6, FI/CO,SD, HR, MM, PP, BW 7.3 powered by SAP HANA, BO(Crystal, WEBI, Dashboard).

Albany International Corporation                                         Apr 2008 – Aug 2008

SAP BW/BI Developer (Lead)

• Worked with several users, and interacted with them to gather requirements. and transformed them into a data model with the concept of star Schema.
• Involved in data modeling. Defined dimensions and developed a word sheet for fact table details in the BW extended star schema.
• Designed and built InfoObjects based on business requirements and prepared a Design documents.
• Designed/Built InfoCubes, ODS, Multicubes, InfoSet and prepared design documents.
• Created transformation(BI 7.O),communication structures, transfer structures, transfer rules and update rules.
• Developed a start routine and transfer rule to apply business logic.
• Created Custom /extractors in (R/3) using View, Table.
• Created DTP to load data from PSA to Target.
• Worked on creating infocubes and ODS objects for different applications that include Notification, Claim amount, Sales Revenue, Profitability, Cost Center, Accounting, Inventory, Customer Hierarchy, Product Hierarchy.
• Modified standard and created custom infosources, datasources, infoObjects, ODS and infocubes.
• Tailored transfer structures, communication structure and Update Rules using ABAP and Formula Builder.
• Created Infopackages and Scheduled loading of data to BW Server and used the BW Monitor to monitor data loading into the Info Cube.
• Build process Chains for running Deltas for Batches jobs in Logistics.
• Configured Job Schedule monitor, user role maintenance.
• Used Multiprovider and Infosets for reporting.
• Used LO and Business content extractors to extract data from SAP R/3. Also used Flat file extraction from other data sources.
• Analyzed business reporting requirements that could be satisfied with SAP business content and delivered cubes and installed the necessary objects.
• Provided Documentation on all the developed cubes in all the modules and also the changes made to the delivered cubes to satisfy the business reporting in this specific site.
• Worked with hierarchies and also did a lot of formatting in the BEx to meet end user requirements.
• Created flexible reports using calculated key figures, filters and variables. Provided drill down functionality on reporting. Extensively used all the features in BEx Analyzer.
• Queries were developed using Filters, Formula, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Assisted in performance tuning for loading data and improving the query response time using Aggregates, Compression, partitioning and Indexing.

Environment: SAP BW 3.5, BI 7.0, SAP R/3 4.6c, QM, SD, MM, PP, FI/CO

Pactiv Corporation. Chicago, IL                                              Aug 2006 – Mar 2008

Senior System Analys

• Key player in Upgrade project from BW 3.1C to BI 7.0.
• SD project (CaseFill reports) in BI 7.0.
• Extracted data from Oracle to BW for S&OP report.
• Prepared designed documents and data model for S&OP projects.
• Designed and built InfoObjects based on business requirements
• Designed/Built InfoCubes, Multicubes and prepared InfoCube/Multicube Design Documents.
• Created communication structures, transfer structures, transfer rules and update rules.
• Developed a start routine and transfer rule for unit of conversion.
• Created Custom /extractors and Infocubes SD/MM (Sales Order, Delivery).
• Worked on BW performance and Tuning (Query).
• Created Setup jobs for Lo Cockpit Extract structures in R/3 and Customized extractors
• Activated LO cockpit extract structures for Logistics .
• Performed extraction from multiple source systems including SAP (using LO) and flat files.
• Created queries using variables, restricted key figures, filters, exceptions, conditions, free characteristics and almost all BEx features.
• Production Support team member After Go-live
• Improved loading performance by carrying out number range buffering, deleting secondary index, run Stats on Cubes/ODS using transaction DB20 and Database level.
• Improved query performance by creating Aggregates, secondary Index, Partition Infocube.
• 24/7 on call production support (Both backend and Front End).
• Monitored Jobs in BW and R3 systems.

Environment: SAP BW 3.1C, BI 7.0, SAP R/3 4.6c, SD, MM, HR, BI-Integrated Planning.

Accenture, Chicago, IL                                                              June 2005 - July 2006

SAP BW Specialist

• Attended Knowledge Transfer (Technical and Functional) Meeting in the client side to understand the system.
• Designed Infocubes & ODS, Built Infocubes & ODS and Prepared Infocube and ODS Design Documents.
• Designed InfoObjects based on business requirements and built InfoObject and prepared InfoObjects design Documents.
• Designed Multicubes, Built Multicubes and prepared Multicube Design Documents.
• Created communication structures, transfer structures, transfer rules and update rules.
• Created Custom/extractors and Infocubes SD/MM (Inventory, Purchasing, Production.)
• Modified standard and created custom infosources, datasources, infoobjects, ODS and infocubes.
• Tailored transfer structures, communication structure and Update Rules using ABAP and Formula Builder.
• Created Setup jobs for Lo Cockpit Extract structures in R/3 and Customized extractors
• Performed extraction from multiple source systems including SAP (using LO), flat files and APO
• Performed data extraction from R/3 and APO into ODS/InfoCubes using extractors
• Prepared Unit test script.
• Activated LO cockpit extract structures for Logistics .Build process Chains for running Delta (Batches) after manually INIT loads in Logistics.
• Created InfoSets for Delivery ODS, and created Bex queries for SNP Report, Net requirements Validation report, Supply Chain Report, Schedule Adherence Completion Report
• Created queries using variables (custom, SAP), restricted key figures, filters, exceptions, conditions, free characteristics and BEx features.
• Used job-scheduling tools (process chains and event handling) to load data.
• Prepared technical design and unit test documents for BEx reports
• Created transport to move infoObjects, Infocubes, Multicubes, Infopackages, BEx Reports from development region to system test region.
• After Go-live as a Production Support team member resolved issues connected with running the query, drilling down by Hierarchy.
• Improved loading performance by number range buffering, deleting secondary index, run Stats on Cubes/ODS. Built Aggregates, secondary index to improve query performance.
• Development User Exits, ABAP Routines for GL, Special ledger, Sales Orders, Billing.
• Build process Chains for running Deltas for Batches jobs in General Ledger,          SPL & Logistics.
• Worked on performance and tuning (Query).

Environment: SAP BW 3.0b & 3.1c, SAP R/3 4.6c, SD, MM, FI/CO,APO

JPMorgan Chase, CHICAGO, IL                                                                             APR 2002 – May 2005

Application Dev. Analyst (Level II)

• Gathered user requirements and created a data model with the concept of star Schema.
• Designed and Built Infocubes & ODS. Prepared Infocube and ODS design documents
• Designed and built InfoObjects - prepared InfoObjects design documents
• Created custom/extractors and InfoCubes for FI/CO,AP,AR.
• Modified standard and created custom InfoSources, DataSources, InfoObjects, ODS, and InfoCubes.
• Tailored transfer structures, communication structure and Update Rules using ABAP and Formula Builder
• Created Setup jobs for Lo Cockpit Extract structures in R/3 and Customized extractors to the Business requirements
• Worked on creating infocubes and ODS objects for AR and AP reports.
• Created Infopackages and Scheduled loading of data to BW Server. Used the BW Monitor to monitor data loading into the Info Cube.
• Built process Chains for running Deltas for Batch jobs.
• Configured Job Schedule monitor, user role maintenance.
• Used Multiprovider and Infosets to extract data from tables and table joins.
• Analyzed business reporting requirements that could be satisfied with SAP business content and delivered cubes and installed the necessary objects.
• Provided Documentation on all the developed cubes in all the modules and also the changes made to the delivered cubes to satisfy the business reporting in this specific site.
• Worked with hierarchies and also did a lot of formatting in the BEx to meet end user requirements.
• Involved in complete life cycle implementation of SAP BW in FI/CO modules.
• Created flexible reports using calculated key figures, filters and variables. Provided drill down functionality on reporting. Extensively used all the features in BEx Analyzer.
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and Variables
• Assisted in performance tuning for loading data and improving the query response time using aggregates, infocube partitioning and indexing.
• Handled postproduction support-Training and preparing manuals for end Users.

Environment: SAP BW 3.0b & 3.1c, SAP R/3 4.6c, FI/CO, AR, AP

Client: ALIT and Satyam Computer Services, Virginia, VA                      Jan 1992 – MAR 2002

Senior Application Dev. DBA (Fulltime Employee)

• Leadership role in all projects
• Wrote functional specifications and design documentation
• Analysis, High level Design, Data Modeling, Physical database/table creation and maintenance
• Load data from sequential files to DB2 tables, Extracted data from DB2 databases

Environment: SAP ABAP, COBOL, ORACLE , DB2, CICS, VSAM, Easytrieve, C,JAVA and  SAS

EDUCATION:

• Bachelor of Aeronautical Engineering – India
• Trained in Project Management from a reputed Institute.

TECHNICAL SKILLS:

SAP                                   BW 7.3 powered by SAP HANA, HANA, SAP BW 3.5, NetWeaver 2004s (BI 7.0), BI 7.3, BI – Integrated Planning, SAP R/3 (SD, MM, PP, EWM,HR, FI/CO) 4.6C, ECC 6, APO, ABAP,

Front End OLAP Tools   BEx Analyser, Web Application Designer, BO 4.0 (Crystal, Webi and Xcelsius)

Operating Systems            Windows, UNIX, OS/390 (Mainframe)

Data bases                        Oracle 8i/9i, SQL Server, Developer 2000, MS-Access DB2 6.0/ 7.0

Office Tools                      MS OFFICE 2000, Microsoft Excel, Visio, PowerPoint

Mainframe                        DB2, COBOL, CICS, VSAM, Easytrieve, FOCUS, SAS, MQSeries, Java, C