PROFESSIONAL SUMMARY

• Over Twelve years of IT experience in managing, analyzing, developing, Implementing, Application support & maintaining various business applications in multiple streams.
• Over Ten Years of strong experience in SAP & BI in various roles working with multiple functional areas including but not limited to CS, FI, SD, CO, QM, CS, Sales & Marketing.
• I worked in multiple roles throughout my career as project manager, tech lead, business analyst, software engineer, SAP analyst, BI developer, BO developer at some point of time.
• Expertise in Project Management Planning, Implementation and Documentation. Worked on complete System Development Life Cycle. Having good experience in handling cut over activities and critical tasks.
• Expertise in gathering the requirements, translating the business requirements into functional specs and reports and sharing with upper management. Sharing the Requirements with IT to discuss the technical feasibility options, preparing the test scripts, conducting the UAT.
• Conducting the gap Analysis and proposing the resolutions to improve the performance. Monitor the new deployed applications & existing applications for performance and collect the statistics for analysis and resolution.
• Expertise in Back-end Business Warehouse Components Extractors, Info Objects, Info Sources, Transformations, Update rules, Transfer rules, Info Cubes, Multiproviders, Transformations, DSO, OHD and DTP.
• Expertise in Front-end Business Warehouse Components Queries, Calculated key figures, restricted key figures, Structures, Variables, BEx Analyzer, Excel Reports web reports and Portals. BO reporting tools WEBI, Xcelsius. Involved with ASAP methodology for implementation right from blue print, gap analysis to customizations, Go-Live, Post-Live Production support, User training and Documentations.
• Involved in market research, sales analysis, forecasting and presenting data to the upper management using different reporting tools including but not limited to SAP reporting tools, Bex , Crystal reports and Excel, WEBI, Xcelcius.
• Creation of Roles, Authorization Objects for Authorization Checks, Activity Groups, Profiles and Reporting Agents to check Authorizations by the OLAP Processor. Involved in resolving the Security Issues.
• Automation of master data and transactional data loads, Managing and maintaining non-R/3 Master Data, Daily extracts and cube builds, Performance and tuning, BW configuration, ETL background and Info cubes design. Strong on End-to-End BW Configurations and Customizations from Extraction, Staging, Documentation, Transports, Loading and Reporting through BEx Analyzer and Portals.
• Monitoring the change tickets to see the progress and escalate where necessary to expedite the process to resolve the user issues.
• Prepared and conducted end user training on newly deployed changes/projects and update on upcoming and available new technologies.
• Expertise in FDA compliance reports documenting and testing to make sure it strictly falls under FDA rules and regulations.
• Worked in 24x7 environments to accommodate global users’ needs to make sure SAP and other bolt on system works properly.

TECHNICAL SKILLS

Business Intelligence: SAP BIW 7.0/3.5/3.1/3.0B, SAP BO 4.0, Portals
ERP: SAP R/3 ECC6/4.6b/4.6C, Netweaver 2004s/2004, SD, MM, CO, CS, FI, SCM, QR.
Reporting Tools: Portals, BEx, Crystal Reports, WEBI, Xcelsius & WAD, Excel
Operating System: UNIX, Windows NT/2000/XP
Programming Languages: ABAP/4, C, C++, Java, PL/SQL and ASP
Database: Oracle 8i, SQL Server 2000

Confidential, June’08 – Till Date

IT SPECIALIST/ANALYST

My role is to maintain and support user community by prioritizing and driving the projects, change work, incidents while improving the performance of the system. Gather the business requirements, design and deploy new solutions to fulfill business user requirements by using new features available in SAP and also making use of new front end tools like BO and Xcelcius reports. Working on flagship project One BI which is the long term solution to get rid of multiple BI environments and make one BI instance available for the end users as a single BI environment by reducing maintenance cost and delivering solutions fast.

Responsibilities:

• I worked in multiple roles at certain point of time as Business Analyst, SAP analyst, Tech lead, IT specialist, Project manager based on the requirement and availability.
• Involved in end to end process of new deployments or changes starting from requirement gathering from the users and up to post go live support including UAT & training, worked extensively to fulfill the user community reporting requirement to present to the upper management including Daily Sales Report (DSR).
• Worked on key issues faced by the users and worked with respective groups like basis, security to resolve the issues and improve the performance by taking care of the recurring problems beforehand.
• Worked with both the user groups and IT to better understand the requirements and technical feasibility and bring them under one hat to agree on the acceptable solution.
• Worked on several projects in SD, FI, CO, CS, QA areas to fulfill the user requirements by deploying the changes to improve the day to day activities of the users by enhancing the report usability for users.
• Involved in enhancing existing SAP BW DSO, Infocubes, Multiproviders, Transformations and Reports for SD, FI, QA, CS and purchasing areas to make use of the new features/content delivered by SAP to improve the Performance of existing solution and also fulfilling the user needs.
• Worked as a business analyst and team lead in multiple projects to implement the projects/changes in SAP for Healthcare and Lighting to fulfill the business needs including enhancements and new structure/data flow creation.
• Proposed, designed and developed Complaint analytics reports for FDA audit purpose. Tested thoroughly to make sure it follows FDA rules and regulations.
• Did the GAP analysis and worked with user community to improve the system usability and performance. Prepared documentation for knowledge transfer and training.
• Conducted and involved in power user group meetings to share the information between users and IT about the new developments, changes, roadmap and issues facing by the user community.
• Developed Score card reports and dashboard reports for Finance and Quality Business management for their analysis purpose.
• Involved and managed BW upgrade project to BI7 including planning, testing cutover activities and post go live support.
• Planned and managed training end users to transition from existing environment to New BI reporting tools and Web Portals to make sure migration goes through smoothly.
• Working on flagship project ONE BI, aim of this project is to keep one BI environment by getting rid of all the existing instances, it’s a challenging work and involves worldwide workforce to convert the structures of their existing BI to ONE BI instance.
• Planned and managed ECC6 upgrade, which is the latest version of R/3. Testing the system connectivity new enhancements available in ECC and testing performance and BI data loads to make sure system functions as normal without any interruptions.
• Worked with end user community to gather the report requirements, prepared functional specs and worked on design develop publish reports in portals and have them sent to the respective groups periodically.
• Managing and fixing the incidents where appropriate to make sure the open tickets closed on time and users issues resolved on time.
• Working on new BO technologies and reporting tools like WEBI, Xcelsius.
• Working on TERADATA and HANA feasibility options.
• As part of global team managing and working on multiple projects in different business units like healthcare, Lighting and Consumer Life style.

Environment: SAP R/3 4.6C/ECC, SAP BI 7.0/3.5, SAP BO 4.0, NETWEAVER 2004S/2004, Web Reports, Portals. ORACLE

Confidential, Sept’06 – June’08

SAP ANALYST

Lead the EP (Exploration& Production) Blueprint (Global) project, the aim is to keep all the SHELL Upstream operating unit’s environments in Synchronization. My responsibility is to Managing, Developing and Designing the Data model according to the user requirement and Production System activities like Creating the jobs, Scheduling, Data loading, Troubleshooting, Performance enhancements, Liaise with the users for their requirements and upgrade activities. Involved in Developing and designing SAP BW data structures and load processes. Designed and developed queries using WAD, Bex Analyzer and Browser to fulfill the user requirements.
To stabilize the BW system worked extensively to reduce the excessive customization in transformations, DSO, Infocubes and extractors to improve the performance by following SAP best practices.

Responsibilities:

• Lead the project by designing developing and customizing SAP structures and Reports to suit the business user community.
• Wore multiple hats as tech lead driving the development and business analyst to gather the requirement and do the gap analysis and share the findings with the technical team.
• Worked in Developing Multilayer structures ECR and ETR for Finance (Actual and Planned) and PM Related reports.
• Planned and managed BI 7.0 upgradation project for the Globalized ONE SAP System.
• Worked extensively in Technical Cutover (TCO) and Actual Cutover (ACO) for internal upgrades i.e. release from 4.5 to 5.0 and 5.0 to 5.5.
• Worked extensively in CS & SD related structures to reduce the extensive customization and to bring back the structures to normality by using SAP best practices.
• Supporting the worldwide users for their issues and resolving their problems where appropriate and preparing proper documentation for further help. Managing the change tickets to expedite the issue resolution.
• Provided dashboards, KPI’s for the business and involved in market strategy and market analysis, future trends and forecasting analysis using huge sets of data and presented using SAP and excel reporting tools.
• Involved in requirement gathering and gap analysis to improve the production environment and proposed the solutions based on ASAP methodology best practices.
• Worked in Loading (Daily, Weekly, and Monthly), Monitoring and troubleshooting the problems erected in the Production System.
• Conducted End user training to update and knowledge transfer on upgrades and newly available/implemented technologies.
• Designed and developed FDA Compliance reports and testing to make sure we strictly follow the rules and FDA regulations.
• Worked on 24x7 BW production support to resolve the issues to keep the BW system up and running.
• Looking after the Production System and Performance Enhancement activities. Scheduled and conducted the business & IT group meetings to share information between both the groups periodically to discuss the new changes, deployments and about the issues.
• Involved in developing the reports by using Bex Analyzer, Bex browser and also extensively involved in creating the Web Reports. Created Workbooks for the developed queries.

Environment: SAP R/3 4.6C, SAP BI 7.0/3.5, NETWEAVER 2004S/2004, WEB REPORTS, JAVA SCRIPT, PM, PS, SD, FICO, BSP, CRM, SEM, SCM, WINDOWS 2000 SERVER

Confidential, Sept’05 to Sept’06

SAP BW ANALYST
The overall objective of the APO/Oral Care Reporting project is to implement the Oral care Manual (Including Professional) Business unit into SPR (Supplier Planning Reporting) Application. The existing Gillette’s Supply Planning Reporting application in BW serves the purpose of reporting for Braun business. As Gillette is now switching over to APO SNP (Supplier Network Planning) from Manugestic systems for its Oral care Business; it needs to have reporting from BW for the same. This includes data loading, report modifications, BW modifications as well as design changes to accommodate the Oral Care business requirements.

Responsibilities:

• Working closely with the business to capture the requirements an challenges, prepared project initiation documents
• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization; Alpha Conversions, Tracing problem to R/3 and resolution.
• Customized Infocubes such as Sales Order cube (0SD_C03), Sales Delivery cube (0SD_C05), Used ODS to stage the data before transferring the ODS contents to the Info Cube. Created multiproviders for reporting to give details of delivery items and schedule line items.
• Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, V3 Updates, controlled by pull/push principle from OLAP system.
• Extensive experience in data design, data modeling, star schema and extended star schema, ASAP methodology, Info Cube partitioning, Setting customized Info Cube. Data extraction from R/3 and Flat file; SAP BW delta load, Info package creation, IPG.
• Was involved in upgrading the BW version from 2.0 to 3.0B and in the process checked the add-on upgrade requirements and new component requirements for BW 3.X
• Resolve and implement BW Query faults (Day to Day) and change requests.
• Involved in testing all the enhanced structures and reports to make sure everything works fine before moving it to Production and organized end user training before going live in production to make sure users understand the enhancements to their reports.
• Supported users 24x7 (production support) to monitor the BW loads and resolve the system issues.
• Created the Users and assigned them to the proper Roles. Checked the Authorization Issues and Roles. Involved in Security Issues.
• Extensively worked on WAD to generate the Web Reports in the form of Charts, Maps, and Graphs as per the user requirement.
• Extensively worked with WAD and BEx to Design and produce the Web reports and Bex Reports for the analysis purpose and formatting.

Environment: SAP R/3 4.6B, SAPBW 3.1C, SD, FICO WAD, JAVASCRIPT, BEX, ITS, SOLARIS, WINDOWS 2000 SERVER.

Confidential, Feb’05 to Aug’05
SAP BW CONSULTANT
Worked extensively in supporting worldwide users of SAP R/3 and BW applications and developing applications to address user needs, Providing the Documentation as per the customer requirement and responding to users’ issues and concerns on a day-to-day basis.

Responsibilities:

• Involved in the star schema design with multiple dimensions and fact tables.
• Extensively worked with the users to gather the report requirements and deployed Excel based and SAP reports and dashboards to fulfill management and user base needs.
• Involved in Upgrading BW and rectifying the problems erected at the time of upgrading.
• Involved with the BASIS team in setting up connectivity between SAP BW and R/3 systems for data extraction.
• Monthly & Weekly extractions are scheduled using Info Packages on Sunday nights & End of month by using after jobs & after events.
• Worked in designing the data model including Setting transfer rules, writing transfer routines, writing update start routine, and update routines.
• Set up statistics/aggregates rebuild and event-chains to notify end-user of report availability.
• Created ODS structures, Info-Cubes, custom Queries, etc.
• Generated reports using Web Application Developer and BEx Analyzer including RRIs.

Environment: SAP BW 3.5, 3.0B, SAP R/3 4.6C, SD, MM.

Confidential, Oct‘02 to Aug’04
SAP CONSULTANT
Description:
I was involved in the implementation of Objective setting and Appraisal component, Individual development Plan (IDP), Calibration for Personnel Development (HR Module) in BW. Custom development of these components was implemented on SAP R/3 4.6.

Responsibilities:

• Performed analysis, design, development and implementation of customized Info cubes and ODS Object for HR-PD module for HR reporting.
• Developed custom extractors on the R/3 OLTP systems and defined the extract structures on the source and target systems to make use of the SAP reports.
• Created various transfer rules, update rules and Transfer routines for restricting and transforming data as part of the data modeling.
• Developed custom reports and designed WEB template based on user requirements for trends and forecasting.
• Prepared documentation for BW development process, Installation and Troubleshooting guide for knowledge transfer.
• Was involved in creating Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
• Prepared group analysis using reporting features such as filters formulas and variables in the queries.

Environment: SAP BW 3.0B, SAP4.6C/4.7, HR-PA-PD

Confidential, Oct’00 to Sep’02
SOFTWARE PROGRAMMER
Description:
This facility allows the customers for online application for Citibank cards and eCard (Web enabled credit card) through the net. The members can also sign up for payment of utility bills like telephone, electricity, etc. using their credit cards through online. Various options were provided to facilitate the customers to bank through online services.

Responsibilities:

• Participated in developing code, perform unit/integration testing and support the product by serving as the top-tier customer support.
• Deployed new set of reports for management to get the usage and forecasting data for decision making by using Excel based reporting and dashboards.
• Was responsible for developing and modifying code written in PRO*C, PL/SQL stored procedures, functions and packages.
• Involved in various testing procedures, user training, on-site support and maintenance
• Served solutions to CITIBANK user queries and done system enhancements for various user requirements
• Was responsible for providing 24 hours Production Support to the existing system.