Data Project
Resume:
Global Business Services
Vivek Srivastava
Cell : 001-201-***-****
E-mail : ****************@*****.***
Charlotte,NC- 28262
Profile
Over 8 years and 2 month of work experience in development, customizations and implementation in sap business intelligence landscape
Currently associated with IBM
Executed software projects for Media and entertainment, banking, healthcare and energy industry
Experience in leading teams. Handled multiple roles – team lead, application developer, senior
Software engineer
Oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.
Skill Set
T 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
Educational Qualification:
B.Tech in Electronics & Communication, August 2006
Major Achievement:
Rewarded “Best Performance award for year 2013 by PSEG SAP director recognizing contribution towards project activitivies
MAJOR ASSIGNMENTS
Bank of America April’15 till date
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 performance issues like, Compression of Info Cubes, and Rolling up the data to the
aggregates
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
UBS FINANCIAL SERVICES April ’14 till April,15
677 Washington Boulevard \
Stamford, Connecticut
SAP BI Consultant
Project: UBS Dragon
Roles and 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 queries
to 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
PSEG, 80, Park Plaza Jan'2012 – March, 2014
Newark, New Jersey
SAP BI Consultant
Project: PSEG ADM
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
PSEG, 80, Park Plaza July '2013 – Jan, 2014 Newark, New Jersey
SAP BI Consultant
Project: PSEG SAP BW Upgrade
Roles and responsibilities:
Responsibilities:
Involved in migrating workbook from 3.5 to 7.x version following workbook migration
Strategy
Involved in migrating query from 3.5 to 7.x version following query migration
Strategy
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 BeXQuery 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 transport
across landscape to fix the same
Implemented sap notes to fix authorization issues occurred after upgrade
PSEG, 80, Park Plaza August '2012 – Jan, 2013
Newark, New Jersey
SAP BI Consultant
Project: PSEG RNP Report Development
Responsibilities:
Designed new InfoCube Payments on RNP for immediate amount, 30 Day amount, termination
amount in FI-CA module and all corresponding components like info objects, infosource, datasource,
transformation, update rule and queries
Involved in creation and transporting generic data Source on table FKKMAKO to extract data for
the required fields
Created Process chains for all Master data and transaction data loading process
Created Multiprovider on RNP cubes to assist reporting on reconnection order
Involved in preparation and review of technical designs, unit test plans & documentation
designed and mapped source and target structures to load transactional data and master data,
setup 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
Performed the unit testing after the data has been loaded into the development and released the
transports into the quality after the success of the unit testing.
Involved in transport collection and release of transports from quality to production,interacted with
the end user and solved the issues that occurred during the end user testing and releasing into the
production successfully.
Reviewed all the reports and carried out the necessary modifications as per the requirement and also as per the convenience of the end user.
Worked on the Dollars Collected on RNP report for populating the missing data in the fields.
Walt Disney Company Feb,2010 – Nov'2011
Project: DISNEY ADM
SAP BI Consultant
Roles and 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 and
formulated effective solutions
Provided post implementation support, planned and carried out enhancement and updates
Managed production of enhancements and problem resolution for sap bi system
Handled production issues, quarter end monitoring of payroll, benefits, personal administration
and organizational management.
Design, develop and support processes and procedures to ensure data quality and integrity
using BI/BW
Monitor and tune reports to minimize processing times
Involved in creating and maintaining infocubes, operational datastore, data Sources, transfer
structures, communication structures, transfer rules and update rules, infopackages.
Involved with PSA in Monitoring the Data Transfer from Source Systems into BW for Flat file
extraction.
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
IGATE, IN Dec 2008 – Dec 2009
SAP BI Consultant
Project: Swissrey Servicedesk Implementation
Responsibilities:
Interacted with business end users to gather requirements and transformed them into a data model with
the 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 documents
for enhancements and customization; Analyze product impact
Worked in Front-end Business Warehouse Components like Queries, Calculated key figures, restricted key
figures, 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
IGATE, IN July '2007 – Nov ’2008
SAP BI Consultant
Project: NBCU BI Project
Responsibilities:
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 from Offshore
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
Managed and monitored data loads from R/3 to BW using Initialization with delta update and full update methods
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
Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures
Environment: SAP BI 7.0, BW3.5
IGATE, IN Jan '2007 – Jun ’2007
ABAP developer
Project: OC ABAP Development
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
Contact this candidate