SUMMARY:

• Over 8 years and 10 month of work experience in development, customizations and implementationin sap business intelligence landscape
• Executed software projects for Media and entertainment, banking, healthcare, auto and energy industry
• Experience in leading teams. Handled multiple roles - team lead, application developer, seniorSoftware engineer
• Oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

TECHNICAL SKILLS:

Programming Languages: JAVA, SAP ABAP, C, C++

RDBMS: Oracle 11.2

Tools: & Utilities: Service center, HP Quality center, TMS, RTC, Service now, RPM

FUNCTIONAL EXPERIENCE: SAP FI, SAP HR, SAP CRM, SAP SD, SAP MM

ERP: SAP BI 7.3, SAP BI 7.0, SAP BW 3.5, SAP BPC, SAP HANA, SAP BO

Operating Systems: Windows 9x/2000/XP, Linux, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Torrance CA

SAP BI Consultant

Responsibilities:

• Extensively worked on development of Tax Report
• Developed business requirements, worked with the business to gather requirements andwas responsible for delivering
• Involved in creation of functional specification & technical Specification
• Worked with the testing team and created test cases
• Responsible for Loading Requirements and test cases into HP ALM and mapping of requirements to test cases with traceability

Confidential, Charlotte, North Carolina

SAP BI Consultant

Responsibilities:

• Extensively worked on HANA POC
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW
• Involved in performance issues like, Compression of Info Cubes, and Rolling up the data to the
• troubleshooting of data loading errors, Investigated issue and formulated effective solutions
• Managed and monitored data loads from R/3 to BW using Initialization with delta update and full update methods

Confidential, Stamford, Connecticut

SAP BI Consultant

Responsibilities:

• Involved in project estimation of BI project comprising development of TNE reports,
• Held discussion with UBS stakeholder to finalize project plan
• Drafted BI project plan, evaluated project strategy to implement requirement
• Collaborated with Wealth Management and investment banking user to clearly understand TNE business requirement
• Enhanced extractor, remodeled info provider, created transformation, created queriesto accommodate requirement
• Trained business user to be familiar with new developed reports
• Developed semantic partition based on Wealth management and Investment divisions to facilitate partitions based on UBS bank divisions

Confidential, Newark, New Jersey

SAP BI Consultant

Responsibilities:

• Gathering requirements, conducting AS-IS and TO-BE sessions, analysis, data modeling, design specification, development, data extraction, reporting, unit testing, trouble-shooting, integration and user acceptance testing, documentation and maintenance
• Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gap & Impact analysis documents, Step by step solution and Transport sequence
• Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects
• Worked on customization and enhanced the extract structure to support business needs
• Worked with LO cockpit data sources and data extraction
• Designed and developed various Data targets and Info providers like DSO (ODS), Info cubes, Info objects, Multiproviders and Infosets using Admn workbench (RSA1)
• Reconciliation of BI reports with the ECC & legacy data as wells as the reports
• Trained the client's technical as wells as the business teams on how to use the ongoing application
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning
• Customizations - Enhanced the Business Content Objects data structures of FI related and customization; configuration, update/transfer rules creation

Confidential, Newark, New Jersey

SAP BI Consultant

Responsibilities:

• Involved in migrating workbook from 3.5 to 7.x version following workbook migrationStrategy
• Involved in migrating query from 3.5 to 7.x version following query migrationStrategy
• Assisted business user during baseline testing, guided user to compare workbook
• Baseline result before and after upgrade and facilitated client testing through several sessions
• Trained business user to upgrade ad hoc query using 7.X Bex query designer
• Performed SPAU and SPDD activities as part of upgrade activity, made changes in customize objects
• Resolved complex issues associated with sales stats workbook
• Fixed info set inconsistency issues occurred after upgrade, activated infoset and moved transportacross landscape to fix the same
• Implemented sap notes to fix authorization issues occurred after upgrade

Confidential, Newark, New Jersey

SAP BI Consultant

Responsibilities:

• Designed new InfoCube Payments on RNP for immediate amount, 30 Day amount, terminationamount in FI-CA module and all corresponding components like info objects, infosource, datasourceTransformation, update rule and queries
• Involved in creation and transporting generic data Source on table FKKMAKO to extract data forrequired fields
• Created Process chains for all Master data and transaction data loading process
• Created Multiprovider on RNP cubes to assist reporting on reconnection orderInvolved in preparation and review of technical designs, unit test plans & documentationdesigned and mapped source and target structures to load transactional data and master datasetup up delta load
• Loaded the data into system using info packages by initializing the full and delta process.
• Created DTPs and Error DTPs in BI to load and monitor the data into info providers
• Performed reconciliation to check the data accuracy by comparing the data in ECC and BW
• Reviewed all the reports and carried out the necessary modifications as per the requirement and alsoas per the convenience of the end user.
• Worked on the Dollars Collected on RNP report for populating the missing data in the fields.

Confidential

SAP BI Consultant

Responsibilities:

• Responsible for delivering optimized solution to Disney client in the CRM, Charged labor,Recruiting, Staffing, benefits process area.
• Carried out analysis, and troubleshooting of data loading errors, Investigated issue andformulated effective solutions
• Provided post implementation support, planned and carried out enhancement and update
• Managed production of enhancements and problem resolution for sap bi system
• Handled production issues, quarter end monitoring of payroll, benefits, personal administrationand organizational management.
• Design, develop and support processes and procedures to ensure data quality and integrityusing BI/BW
• Monitor and tune reports to minimize processing times
• Involved in creating and maintaining infocubes, operational datastore, data Sources, transferstructures, communication structures, transfer rules and update rules, infopackages.
• Involved with PSA in Monitoring the Data Transfer from Source Systems into BW for Flat fileextraction.
• Monitoring of daily loads and analyzing the reasons for frequent load failures
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW
• Involved in escalating prioritized tickets regarding extractions, performance issues and load failure

Confidential

SAP BI Consultant

Responsibilities:

• Interacted with business end users to gather requirements and transformed them into a data model withthe concept of Extended Star schema
• Installed relevant SAP Business content
• Ability to quickly grasp business requirements and data models
• Lead analysis sessions, gather requirements and write specification and functional design documentsfor enhancements and customization; Analyze product impact
• Worked in Front-end Business Warehouse Components like Queries, Calculated key figures, restricted keyfigures, Structures, Variables, Exceptions and Conditions.
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Worked extensively on Data Extraction from SAP R/3 using LIS Extraction, LO Extraction, Scheduling, Monitoring, BEX Analyzer, BEX Browser, Workbooks, and Report-to-Report interface.
• Experience in creating Info objects, Info sources, Transfer Structures, Communication Structures, Info Cubes, ODS, Info package
• Well conversant in data staging (PSA and ODS to info Cubes), data monitoring (RSMO).
• Communicate activities/progress to project managers, business development, business analysts and clients

Confidential

SAP BI Consultant

Responsibilities:

• Extensively worked on Process chains for sequential background scheduling of Master and Transactional Data up on triggered by events in source systems
• Scheduled Info Packages in order to load master data and transactional Data from sap R/3 as well as flat file Source Systems into BW
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Extensively involved in production support like daily job monitoring
• Data loading was monitored (mostly for invalid characters) and re-loaded to DSO
• Correcting and maintaining work log for data loading errors in a shared folder
• Involved in handling tickets, resolved tickets raised by Business Users
• Involved in performance issues like, Compression of Info Cubes, and Rolling up the data to the Aggregates and partitioning of Info Cubes.
• Optimized query performance and loading performance with the various tunings
• Maintaining and redefining aggregates if required on weekly basis

Environment: SAP BI 7.0, BW3.5

Confidential

ABAP developer

Responsibilities:

• Created an Interactive Reports on blocked invoices
• Report to display all material rates by using Material number, Sales Organization, and Distribution Channel and condition type.
• Developed a report which will list out all the purchase order details and the secondary list contains all the information about the supplier.
• Developed an interactive report which displays the list of purchase requisitions in the basic list according to the user’s selection screen and which in turn allows the user to modify the purchase requisition in the secondary list.
• Created an interactive report to list the purchase orders details for a vendor.
• Created Report to Display the Details of Sales Quantity in the given date. Outputs Material No, Material Disc, Plant, current Month Sales, Previous Month Sales, Last Year same Month and Date (Quantity). Data was extracted from VBRK, VBRP.
• Sales, Last Year same Month and Date (Quantity). Data was extracted from VBRK, VBRP.
• Developed ABAP List View report program for Material Values to display list of all materials under a plant. Selection screen contains plant, material type
• Developed a Report To print report of all the items whose quantity is bellow re-order level
• Created a report to display sales order and dispatch details.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets

Environment: R/3 4.7