SUMMARY

• 8 years of SAP experience of BI/BW Modules as Functional Consultant wif BPC SRM, MM & QM understanding of software Implementation, Enhancement, Development Support Projects and administration. Having experience across different industry verticals including Hi­Tech, Chemicals, Oil & Gas and Precision Engineering, worked wif renowned Companies like SAP Labs, IBM, Shell and UBS bank
• Hands on Experience and Technical Proficiency in Data Modeling - Info objects, DSO, Info Cube, Multi-Providers, APD’s, Data Loading and Delta Management.
• Reporting using BEx Analyzer such as Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions, Filters, Conditions
• Involved in various development, enhancement and upgrade projects.
• Performance tuning of infocubes by Compression, partitioning the cubes, BW statistics and BEx query reporting.
• Supplier Relationship Management (SRM): Including three full life cycle implementation and one Upgrade Project right from Blueprint ­ Gap Analysis ­ Customizing ­ Go­Live, Post­go­Live Production Support, Document preparation and End User Training. The project wif SAP Labs to provide Support to all SRM Customers across the globe on versions SAP SRM 3.0, 4.0 and 5.0 and the current project wif Cornell University is an implementation project on SRM 5.0 and upgraded to SRM 7.0 recently.
• Material Management (MM): Experience covers one life cycle implementation and one upgrade project wif extensive experience in configuring and customizing for Procure to Pay on various SAP R/3 Material Management versions including 3.1H, 4.0B, 4.6C, 4.7, ECC 5.0 & ECC 6.0 ­ EHP4 including Business analysis.
• Inventory management (IM): Experience in configuring and customizing various movement types for Goods Movements, Physical Inventory, Instrumental in setting reorder level, safety stock, maximum stock, etc.
• SAP BW Accelerator (BWA) and creation of BIA Indexes.
• Housekeeping activities like PSA deletion, change log deletion, BIA Index creation and deletion for Info cubes
• Managing large volume of data wif yearly or quarterly DSO’s, Infocubes and adding new objects to Multiproviders to make sure the un-interrupted reporting to end users
• Solving high-prioritized tickets regarding extractions, load failures and reporting issues.
• Presenting weekly status reports to the Project Management, informing them on the status of each deliverable.
• Responsible for TEMPeffective communication between the project team and the customer and providing day to day direction to the project team and regular project status to the customer.
• Having good Analytical, Problem solving, Communication and Interpersonal skills wif ability to interact wif individuals at all levels.
• Experience in End-to-End Life Cycle Implementation projects using ASAP methodology. Expertise in BW system - Data Modeling, Extraction, Supplier Data Loading, Scheduling, Monitoring, and Reporting Environments.
• Experience in Designing and Development of various BW objects like Info Objects, Info Cubes, DSO’s, Data Sources, composite providers, Extract Structures, Extractors, Data Sources, Transformations, Multi Providers, Info Sets, and Aggregates etc.
• Proven experience of implementing WF in the Supply chain process and integration wif Logistics.
• Workflow Production Support - Housekeeping jobs, workflow monitoring, production issue analysis and resolution.
• Proven experience of implementing WF in the Supply chain process and integration wif Logistics.
• Expertise in FI extraction, which includes getting data from AR and AP and from GL Accounts.
• Very strong knowledge and hands on experience in developing the solutions for Logistics modules like Purchasing, Sales, Deliveries, Shipping.
• Setup tables filling for the LO-Cockpit and used the V3 Update for Delta Management & Data Source Enhancements.
• Managing of Info Cubes, which involves Info Cube Content, Performance issues like Indexes, Partitioning Info Cube, and Compression of Info Cube and rolling up the data to the Aggregates as well as the DSO for huge data content.
• Expertise in Reporting wif Business Explorer using BEx Analyzer, BEx Query Designer, Web Application Designer, Condition Reporting, Exception highlighting, developed Queries, Queries using Filters, Free Characteristics, Calculated Key figures, Restricted Key figures, and Variables.
• Design and configure BPC (BPC 10 Net Weaver version) structures Models, Dimensions, Attributes, Hierarchies, and Security Profiles.
• Design and configure MS Excel based templates that would be used to enter different types of data (future forecast, price projections, and assumptions)
• Design and develop transformation and conversion files for deriving master and transactional data from BI to BPC.
• I was also involved in developing script logics, BADIs, BW process chains and routines. I developed currency conversion BADI to facilitate real-time conversion using write back BADI framework.
• Developed input schedules and reports in EPM 10
• Extensively worked on data load using data manager packages.
• I was also involved testing and post-delivery support.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SAP BW Lead Developer

Responsibilities:

• Developing options for data access (i.e. web solution, R/3 drill through, ODS reporting, master data reporting, 3rd party tools)
• Working wif training development to include data access solution in BW course materials
• Created generic data sources and managed delta mechanism to pull data from source system. Built data sources for different custom condition tables related to pricing.
• Used standard extractors to extract sales/billing conditions data to build the pricing waterfall mechanism which has complex transformation routines to calculate chargebacks, adjustments, rebates etc,.
• Customized sales and delivery Info Cubes and ODS objects for data staging in BW
• Analyzed ERM, MDM and translated it to BW design.
• Created Info Sources for upload of master and transactional data.
• Assigned Data Sources to Info Sources, maintained communication structure and transfer rules
• Monitored the performance of the queries and Implemented SAP delivered SD/PS Info cubes in Business Warehouse.
• Extracted data for Commitment/Actual and Budget in Project Systems.
• Extracted data from flat files and generic data sources, LO cockpit Data Sources into PS and SD Cubes.
• Scheduled data loads in BW both for delta and full uploads.
• Compressed and Roll-up the extracted data.
• Activated the technical business contents.
• Monitored the performance of the queries.
• Designed delta loading strategies, Process chains and scheduled batch jobs
• Created DSO’s for custom data sources built on the data pushed from third party toolslike informatics, Vendavo. Managed Open Hub that pushes data to third party tools
• Worked on SOLMAN and GRC for security, transporting objects to different systems.
• Created SQL scripts for validation and unit testing of view at each level of development.
• Developed complex logical expression, input parameters, input variables for filtering the data at database level.
• Worked on advanced data modeling techniques which involved open ODS views, composite providers in BW modeling. Used XML editing for creating multiple analytic privileges and re importing them to the respective packages.
• Managing off-shore team, reviewing the design and making sure the deliverables meet the timelines.

Environment: SAP BW 7.4, SAP BO

Confidential, St. Paul

SAP BW Lead Developer

Responsibilities:

• Understanding the business process and creating the specifications document and get it reviewed before starting the development
• Gatheird User Requirements, Analyzed reporting requirements, Gap Analysis, Evaluated Standard Business Content, Design and Development - Data Mapping, Design of Functional and Technical specifications.
• Extensive knowledge and experience wif BW Extraction, BW loading, building BW cubes, DSO, and multi-providers related to Integrated Planning components
• Modified standard and created custom Data Sources, Info Objects, DSO and Info Cubes for SRM,SD, MM & FI.
• Non-SAP Data Access tools (e.g., Business Objects, Cognos, Crystal Reports, and other certified data access tools)
• Visual Basic development
• Web development
• WAP (wireless) development
• R/3 drill-through
• Extensively worked on Sales data extraction i.e. from order to cash (OTC).
• Worked on LO cockpit for Maintenance of extract structures for Orders, Billing & Deliveries.
• Responsible for developing Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI
• Material(s) data extracted from ECC and validation are created in BI Start routine for BOM structure.
• Conducted SAP BI training sessions to Power users and business users.
• Responsible in optimizing the data load process to minimize load time and fix the causes of load failures.
• Used reusable structures, exceptions, variables, filters, restricted and calculated Key figures for reporting.
• Creation of BO universes in IDT on top of HANA calculation views
• Creation of WEBI reports on top of BO universes
• Testing the data in the models end to end and support the business users wif any questions.
• Understanding GAP request specifications and, Technical Specification, Unit Test Plans, Code walk through Document, SQL Trace and Runtime analysis for developing application programs.
• Ensuring quality process and coding guidelines and standards in the project by all team members.
• Created Sales operation report, which is used to list customers and associated sales partners as on date in SD
• Customizing SRM Business Workflows suiting to Customer requirements.
• Design and test the Item based approval for SRM workflow for Shopping cart based on Product Category, Material types, Order Value, Fund, etc.
• Design and test the Item based approval workflow for SRM Purchase Order based on different PO Value Configure Backend Integration Elements of an e­Procurement scenario like SRM/CRM settings Configure the RFC settings related to SRM and the relevant ECC backend
• Troubleshoot on all the e­Procurement Processes like Shopping cart, Purchase Order,etc
• Maintain, support and provide enhancements for the existing ABAP code using BADIs, Enhancement section, Enhancement point and Enhancement spot in SD.

Confidential , MI

SAP BW Lead Developer

Responsibilities:

• Interact closely wif the Business team and functional consultant on getting the requirements
• Understanding the business process and creating the specifications document and get it reviewed before starting the development
• Developing prototypes of data access for review wif end users
• Developing the required data access solutions
• Testing of all developed solutions
• Ensuring integration testing of data access solution
• Developing a production support plan
• Creation of HANA optimized DSO’s, BEx query’s
• Creation of complex transformations wif start, end routines ABAP logic
• Mapping different data sources and getting data to a single DSO wifout duplications
• Bex query for complex KPI’s and creation of reports to integrate them to the portal
• Helping business users wif all the testing
• As one of the primary SAP BPC Business Developer, I was responsible for supporting day to day BPC needs, continuously enhance solution for better usability and roll out additional functionality. I resolved lot of technical issues closely coordinating wif SAP Support team.
• I was involved in gathering requirements and document functional and technical specification documents.
• I also developed archiving strategy to move and maintain data volumes relating to historical data. I also developed BPC Job Failure alert program to notify support group in case of any job Failures.
• I developed process chain to facilitate actuals delta load from ECC/BW in EPM cubes. I also configured and automated master data dimension load process.
• I configured parallel processing logic for script logic process resulting in significant time benefit during data processing.
• I was involved in Report development in Finance (Department Spend), Headcount (Compensation Summary), and Capital (Asset and Depreciation planning). I developed real-time BADI to facilitate real-time depreciation.
• I configured BPF to facilitate Forecast open/close activities, also configured Data manager to copy/archive forecast versions.

Confidential, Seattle

SAP BW/BPC Developer

Responsibilities:

• Interact closely wif the Business team and functional consultant on getting the requirements
• Understanding the business process and creating the specifications document and get it reviewed before starting the development
• Developing the associated interface programs and/or customized web enhancements, if necessary
• Configuring the Reporting Agent, if necessary
• As a one of the primary developer, I was responsible for understanding the functional specification of the client requirements and create technical specification.
• Configuring BPC environments and models
• Configuring BPC Security for Task/Data Access Profiles, creating Teams and assigning Users
• Ensure master data, transaction data integrity
• Configuring and testing default BPC script logic
• Developing reporting and input schedules based on client specifications
• Create month-end closing Data manager package
• Developed Security, Work Status and Interfaces to ECC.
• Supported and developed Training Material and various Test Plans
• Involved in Unit testing, String testing, Go-live support and post-production activities.

Environment: SAP BW on HANA, SAP LUMIRA and Tableau

Confidential, Austin, TX

SAP BI Lead Developer.

Responsibilities:

• Extensively worked in configuring Business Information Warehouse objects including Info object, Info cube, DSO objects, Data source, Info package, Data Transfer Process, Transformation and Multi providers
• Extensively involved in Activating the Business Content for Info cubes, Data Sources, Multi providers
• As one of the primary SAP BPC Business Developer, I was responsible for supporting day to day BPC needs, continuously enhance solution for better usability and roll out additional functionality. I resolved lot of technical issues closely coordinating wif SAP Support team.
• I was also involved in developing script logics, BADIs, BW process chains and routines. I developed currency conversion BADI to facilitate real-time conversion using write back BADI framework.
• Configured Backend Integration scenario by defining the Logical System and RFC Destination
• Setting up Organization, Components of an Organizational Plan, Attributes and Attribute inheritance and
• User Maintenance Tools.
• Expertise on Master Data replication and maintenance Replication and Integration of Business Partners Configure Transaction types
• Configure Vendor Synchronization Process
• Workflow Configuration and Workflow start conditions
• Developed input schedules and reports in EPM 10
• Created APD’s to transfer data from Info Providers to Flat Files & to databases.
• Configured BEx Queries for Free Characteristics, Calculated and Restricted key figures
• Scheduling and Monitoring Extractor schedules and monitoring data load.
• Performed various data load (Init, Delta, Full & Repair full)
• Involved in changing the existing data model of an Info cube by adding new characteristics and key figures wif initialization of data source in SAP R/3.
• Created process chains, scheduled Daily/Weekly/Monthly data loads and monitored the loads
• Error Rectification during data load ( Manual update, Re construction, Checking TRFC connection, Processing failed IDOC, DSO Activation, Editing invalid characters in PSA )
• Involved in performance tuning activities using Rollups and Compression. Involved in the performance tuning of info cubes, BW statistics and Bex query reporting.
• Worked on BI Accelerator
• Involved in identifying performance issues and coordinating wif the team members to bring back the system to normal condition
• Creation of Ad-hoc queries to get the historical data for business users
• Involved in housekeeping activities like PSA deletion, change log deletion Index creation and deletion for Info cubes
• Performed Unit, Integration & UAT Testing.
• Involved in solving high-prioritized tickets regarding extractions, load failures and reporting issues.
• Presenting weekly status reports to the Project Management, informing them on the status of each deliverable.
• Managing this offshore team in support activities
• Responsible for TEMPeffective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Environment: SAP BI 7.0, SAP BI 7.3

Confidential, Austin, TX

SAP BI LEAD Developer

Responsibilities:

• Created Flat file data source in Business Objects Data services (BODS) and also imported the SAP BI tables into BODS which serves as the BI data source including importing the HANA tables.
• Built the ABAP dataflow using Flat file / BI as data sources. The transformations and SQL scripting were performed in the flow.
• Scheduled the batch jobs in BODS to populate the HANA target tables.
• Monitoring the batch job in Central Management Console (CMC).
• Created the Information models in HANA Studio which includes HANA tables, Attribute views (Master data), Analytical views (Multidimensional model), Calculation views (complex models) using Union operation.
• Totally 12 tables which includes both master & transactional data were joined wif source data size of 130 GB's and 700+ Million records. Also, the compression ratio was achieved in a factor of 1:4, while the data was moved to HANA database.
• Also, the store level and Article level hierarchy was achieved in the HANA studio.
• Built Universe using complex calculation view created in HANA Studio through Information Designer Tool (IDT).
• The IPR Sales & Report was built in Web Intelligence tool using universe as the query. The Drill down / up functionality was enabled in the report including the Hierarchy.
• Finally, a complete BI report was implemented in HANA wif the Article / Site drilldown and the performance factor is 200% as compared to the same report in SAP BI live system.
• Created and showed the report in IPAD using Business explorer in SAP BO.

Environment: SAP HANA, SAP BO Data services, SAP BO (Information design tool, WEBI, Dash board designer, Business explorer (IPAD reporting))

Confidential

SAP BI Developer

Responsibilities:

• Activating BI content in New customer Production and Test systems.
• System upgrade and activation for new support packages.
• Broadcasting the reports in the customer desired language.
• Scheduling the Data loads Using Process Chains.
• Creating, Monitoring and Error Handling of Process chain.
• Real Time Data Acquisition monitoring and error handling.
• Implementing SAP Notes after the import of Hot Fixes related to BI corrections.
• Joint Incident Handling wif the “Expert Support” colleagues of SAP Labs, Bangalore in order to reduce the total cost of ownership of the project.
• Providing quick and quality resolutions for the issues reported by the customer through the BCP tool
• Supported All SAP Business By Design Customers by Monitoring, Analysing and Solving the Health Check Incidents and Customer Incidents using Customer Relationship Management @ SAP, Customer Support System (CSS) and Service Provider Cockpit (SPC).
• Posted Knowledge Base WIKI articles for Technical solutions to the issues encountered in new support pack levels.

Environment: SAP Net weaver BI