SUMMARY:

• Around 8 years of strong experience in IT including SAP BI 7.0, SAP BO, PL SQL
• Experience in data warehousing, business intelligence, report development and documentation
• Experienced in developing data flow diagrams, data path diagrams and purdue models
• Experience giving end-user training for SAP solutions and preparing the training material and presentations.
• Proficient in technical documentation including technical specifications, test plans, requirement specifications, Business Requirement Document BRD , Functional Requirement Document FRD and non functional requirement documents, etc.
• Experienced in interviewing the business users and SME's providing recommendations to resolve issues for various business/technical groups and defined strategic solutions to the business problems in a multiple project environment.
• Working experience in cross-functional team environments. Strong interpersonal and communication skills.

SKILLS:

• Development: C, C
• Technologies: SAP, Business Intelligence, UML
• Operating Systems: Windows 98, Windows XP, Windows 2000, Windows 7 and UNIX
• Databases: SQL Server, Oracle

Tools: SAP Web Dynpro, SAP ABAP, SAP BW/BI, SAP Portal, SAP Business Explorer BEx , SAP Business Objects, SAP Business Workflow, SAP CRM, SAP HANA, VBA, Control M, ITSM, SSAS, SharePoint, Crystal Reports, ERWIN Data Modeler, MS Visio, Microsoft Project Plan, Qlikview, Splunk, Orion

EXPERIENCE:

Confidential

SAP BI and BO Support

Confidential is one of the world's leading integrated energy and technology companies. They explore, produce and transport crude oil and natural gas, refines the market and distributes fuel and other energy products, manufactures and sells petrochemical products, generates power and develops future energy resources, including bio-fuels and geothermal energy. The project at Chevron focuses around aligning all of the assets used in the San Joaquin Valley Business Unit in accordance to Chevron and industry standards, thereby ensuring Evergreen compliance. This project further extends its scope to implementation of Lean Sigma business process.

• Built a Data Warehouse using SAP Business Warehouse which aggregates data from multiple SOR's in San Joaquin Valley.
• Built a reporting cube in SAP Business Warehouse that pulls data from Data Warehouse for pivot reporting.
• Fixed all existing reports that were directly tied to multiple SOR's in San Joaquin Valley.
• Built new reporting data systems and security around the systems to ensure right users have access to pull data from SOR's.
• Created the data flow and data path diagrams to show the interactions between the various applications.
• Hands on development of SAP BW/BI objects, Enhance DataSources, Perform Data Extraction and Data Loading
• Extensively used BEx Analyzer, created queries with Variables, Restricted key figures Calculated key figures
• Experience in loading data from flat files, R3 and non-SAP data source systems.
• Involved in the full cycle development and implementation of BW/BI as per client's requirements.
• Provided consulting to define scopes and implement company-wide business process refinement strategies, communication plans, and solutions.
• Streamlined the existing processes and proposal of the new processes to keep audit compliance evergreen.

Environments: SCADA PCN, LOWIS, SAP Business Warehouse, SAP Business Explorer, SQL Server, SSAS, SharePoint, MS Visio, MS Project Plan, Microsoft Office, EWRIN Data Modeler, ITSM, Excel VBA, Splunk, Orion, Qlikview

Confidential

SAP BI and BO Support

Confidential is the world's largest wholesale technology distributor and a global leader in the IT supply-chain, mobile device lifecycle services and logistics solutions. As a vital link in the technology value chain, Ingram Micro creates sales and profitability opportunities for vendors and resellers through unique marketing programs, outsourced logistics and mobile solutions, technical support, financial services and product aggregation and distribution. This project involved generating reports on time and also monitoring loads all through their supply chain cycle.

• Monitored the BI Load for countries in North America, EMEA and AP.
• Involved in bug fixes in the process chains, DTP, Load Cycles and PSA in SAP BI.
• Created the batch process and scheduled the load jobs in parallel on a daily basis.
• Implemented BO report monitoring for the various countries.
• Designed the universe by using SAP BI as the backend.
• Responsible for onsite, offshore coordination to ensure adherence to report delivery schedules.
• Provided 24x7 emergency support.

Environments: SAP Business Intelligence, SAP Business Objects, SAP Business Explorer, ITSM, SharePoint, Microsoft Office, Excel VBA

Confidential

SAP Consultant, Expense Control Dashboard

Confidential is focused on providing branded consumer goods. The company's products are sold in over 180 countries around the world. Primarily through mass merchandisers, grocery stores, membership club stores, drug stores high-frequency stores and the neighborhood stores, which serves the consumers in the developing markets. The expense control dashboard was built to save user preferences.

• Worked with the project managers and end users to discuss and decide the business goals and strategies of the project.
• Responsible in creation of InfoCubes, InfoSources, replicated DataSources, loaded Master Data from flat files and from OLTP, Multi providers and ODS objects.
• Created ODS update rules and InfoPackage to load data, installed Business Content, created aggregate InfoCubes
• Developed custom extractors to extract data out of custom tables in R3.
• Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
• Installed Business Content as and when required.
• Responsible in solving performance-related issues.
• Created and maintained queries in BEX Analyzer and BEX Web application Designer for analysis and reporting with Workbook and Web Reporting respectively.
• Involved in creation of reports using BEX Analyzer such that the execution time is evenly distributed throughout the report by using free characteristics, Restricted keyfigures,
• Calculated keyfigures, Variables, Exceptions, Navigational Attributes, Text Variables, Filters, Structures and Conditions.
• Prepared the estimation sheets and requirements as well as defined the timelines for each individual object.
• Created the unit test cases, use cases and executed them.
• Performed and monitored the unit testing, integration testing, user acceptance testing and implementation of the application through various environments such as development, quality and production.
• Provided Go Live support after deployment of the project.

Environments: SAP BI/BW, Microsoft Office

Confidential

SAP Consultant, Creative Touch Interiors, Estimation Bidding Tool

Confidential one of the largest wholesale distribution companies in Confidential. HD Supply provides a broad range of products and services to the customers in the infrastructure and energy, maintenance, repair and improvement and specialty construction markets. The company also operates about a dozen business units, including its Canadian arm HD supply in Canada. This project involved moving all of their existing business logic which was on excel onto a Web based application.

• Gathered business / user requirements from the development team at the client site, and created Project Scope document and functional specifications.
• Converting high-level design specifications to detailed functional and technical specifications.
• Interviewing and Coordination with end users communities understand their requirement
• Gathered Reporting Requirements and arrived at the best Reporting Model using Business Objects teams.
• Used Administrator Workbench to create Data Sources, Info Objects, and, Info Cubes, DSO objects, Info sets, Multi-providers, update rules and transfer rules.
• Data extraction from ECC source system such as SD, using LO Cockpit process and Flat files.
• Created generic data sources to extract data from various data sources to achieve end-user requirements.
• Excellent communication and management skills and ability to work as part of a team Used Process Chain and the Reporting Agent to automate data loading, delta uploads, Performance tuning, printing and Exception reporting.
• Designed aggregates for performance improvement of existing queries.
• Scheduling, Monitoring and transporting objects in Dev, QA, Prod systems.
• Maintained customer exit code to maintain the period of data dynamically.
• Developed queries using BEx analyzer. Create variables, calculated and restricted key figures, filters and conditions in BEx query designer.
• Automated the error handling which triggers the email to the intended recipients in case of the erroneous records

Environments: SAP BI/BW, Excel VBA, Microsoft Office

Confidential

SAP Consultant, SAP Implementation

Confidential has acquired the Paulsboro refinery of Valero on the US east coast, along with the associated lubes marketing business, logistics assets, etc. PBF has also acquired the Valero's Delaware City refinery. PBF wants to assess, plan and execute the transition of the IT applications, infrastructure and support to the PBF energy environment including the implementation of a fit for purpose, scalable financials and maintenance backbone. PBF has decided to implement SAP as its core Financials, Procurement and Maintenance backbone for its acquired refineries. L T InfoTech is partnering with PBF as the systems integrator for this implementation. Project involved migration of the legacy systems to SAP.

• Experience in loading data from flat files, R3 and non-SAP data source systems.
• Created various data targets, including info objects, info cubes, DSOs, multi providers, info set queries and open hub destinations in SAP BI 7.0.
• Established a flat file connection for flat file data sources and RFC connections for ECC 6.0 data sources.
• Created info packages to load data into PSA and maintained full updates as well as delta updates accordingly.
• Replicated manually created as well as predefined ECC data source to SAP BI source system.
• Developed data source enhancement due to changes in client's requirement.
• Established transformation and managed data transfer process DTP between BI data source to BI data target.

Environments: SAP BI/BW, Control M, SQL Server, Microsoft Office

Confidential

SAP Consultant, Project Invensys

Confidential is a global engineering and information technology company headquartered in London, Confidential. Project involved migration of their legacy systems to SAP.

• Involved in gathering business requirements from business analyst for data modeling.
• Extensive interaction with End Users to gather all specifications for Data Modeling and development.
• Customized InfoCubes and used Transfer rules, Update rules and start routines.
• Developed BW objects IO, Queries, ODS, Extractors, Info Sources and Info Packages , Update and Transfer rules.
• Developed various data extraction procedures for master data full and delta upload for attributes, texts, hierarchies and transactional data full and delta, and generic extractors for customer-defined tables.