Professional Profile
Srinivas has over * years and 10 months in SAP ECC 6.0 & SAP BI 7.0, BW 7.3
Worked with Fortune 500 Companies in Full life cycle implementations which
includes BI 7.0 and BW 7.3, Implementations, Enhancements and Production
Support in SAP Financials (FI/CO), AR, AP, AA, GL, CCA, PCA, CFP, FSL, RI,
HR and Logistics (MM, SD) modules. Worked on Enterprise Portal Net weaver
2004S.
Worked on SAP Business Objects and Business Intelligence 4.0.
Having Onsite Experience with UK, USA and having valid B1 Visa for US.
SAP BW 7.3 and BOBI 4.0 Certified.
SAP HANA 1.0 Certified.
POC Experience on SAP HANA:-
> Involved in preparing Attribute view, Analytical view and
Calculation View from SAP and Non sap Sources.
> POC Experience on HANA with Business Objects reporting tools like
Dashboard, WEBI Crystal Reports etc.
> Experience on HANA Integration with IDT and UDT Semantic Layers.
> Knowledge to Create on Flat file Source Systems.
> Knowledge on HANA Replication Technologies.
> Knowledge on HANA Administration.
> Involved to Transit Provider through Bex Reports.
Career Objective:
o Looking forward to challenging position as the consultant and apply my
experience, development and marketing power of the organization's
Product and increasing their market value.
Professional Expertise:
o Experienced in conducting design sessions to evolve system
specifications and test plans with the ability to handle training
sessions and documentation.
o Excellent problem resolution skills with ability to work under
pressure in a highly visible role.
o Aptitude for analyzing, testing, debugging code, identifying problems
and creating solutions.
o Excellent Time Management skills.
o Good Team Player with excellent communication skills.
Expertise in ASAP methodology:
o Proficient in all the five phases of ASAP methodology.
o Analyzed the Client/End user reporting requirements, identified the
Standard Business Content for business Scenarios and translated the
requirements in to specifications.
o Involved in the Design & Construction Phase and Build & Test Phases,
Fit-Gap Analysis, Process Design Documentation.
o Expertise with the work involved in Realization and Final preparation.
o Conducted post-go-live and End user trainings.
Recent Accomplishments
Project Name : Air Products
Organization : IBM India Private Limited
Duration : Feb '14 to Till Date
Client Name : Air Products, USA
Team size : 4
Environment : SAP ECC 6.0, SAP BW 7.3, BO 4.0
Role : Sr. Software Engineer
Project Name : Shell -Automated Dashboard and Sales Apps
Organization : IBM India Private Limited
Duration : Sep '13 to Jan'14
Client Name : Shell, UK
Team size : 6
Environment : SAP ECC 6.0, SAP BW 7.3, BO 4.0
Role : Sr. Software Engineer
Summary:
Royal Dutch Shell plc (LSE: RDSA, RDSB), commonly known as Shell, is an
Anglo-Dutch multinational oil and gas company incorporated in the United
Kingdom and headquartered in the Netherlands.[2] Created by the merger of
Royal Dutch Petroleum and UK-based Shell Transport & Trading, it is the
largest company in the world-ahead of Wal-Mart Stores, Inc.-in terms of
revenue,[1] and one of the six oil and gas "super majors".
Shell is also one of the world's most valuable companies.[3] As of January,
2013 the largest shareholder is Capital Research Global Investors with
9.85% ahead of Blackrock in second with 6.89%.[4] Shell topped the 2013
Fortune Global 500 list of the world's largest companies.[5] Royal Dutch
Shell revenue was equal to 84% of the Netherlands's $555.8 billion GDP at
the time.[6]
Shell is vertically integrated and is active in every area of the oil and
gas industry, including exploration and production, refining, distribution
and marketing, petrochemicals, power generation and trading. It has minor
renewable energy activities in the form of bio fuels.[7] It has operations
in over 90 countries, produces around 3.1 million barrels of oil equivalent
per day and has 44,000 service stations worldwide.[8] Shell Oil Company,
its subsidiary in the United States, is one of its largest businesses.
Responsibilities:
> Developed High Level Design Document for Shell Automated Dashboard.
> Involved in preparing the data flow charts of each application,
maintenance of documentation for each gathered requirements
> Developed Technical Speciation's Like APD, DSO, Cube,
Multiprovider, Transformation, DTP and BEx Reports.
> Worked on Routines and Auto load Process for Transformation, DTP
and Process Chains
> Worked DTP Routine for Target cubes
> Created Process Chains for Governance Association, Customer, and
Country, Monthly and YTD Transaction data, Customer, Product, KPI
and BWA Automate Index.
> Interacted with the End Users, Business Analysts and responsible
for Involved in training sessions to impart knowledge on BW and
Report Design.
> Worked on Flat file load for Auto Load Object.
> Worked on Webi and Dashboard Reports for Customer & Product areas.
> Worked on OLAP, WEBI and Dashboard Reporting tools.
Project Name : ROCHE-HEALTHCARE
Organization : Tech Mahindra
Duration : JUN '12 to AUG'13
Client Name : Roche, Basel
Team size : 6
Environment : SAP ECC 6.0 SAP BI 7.0, BO 3.1
Role : Project Lead
Summary:
Fritz Hoffmann was the founder of F. Hoffmann-La Roche & Co. on 1st October
1896 in Switzerland. Shortly, after the foundation of the Company, offices
and manufacturing sites of Roche were opened in several other countries.
Headquartered in Basel, Switzerland, Roche is one of the world's leading
research - oriented healthcare groups in the fields of pharmaceuticals and
diagnostics. Roche's innovative products and services address needs for the
prevention, diagnosis and treatment of disease, thus enhancing people's
well being and quality of life. Since then Roche has grown into one of the
leading healthcare companies in the world.
Responsibilities:
> Developed Function specs, Technical Specs as per the templates
Quality standards.
> Involved in System study & Business requirements analysis &
documentation.
> Going through the Technical Specification and performing GAP
Analysis.
> Interacted with the End Users, Business Analysts and responsible
for Involved in training sessions to impart knowledge on designed
universes and published reports.
> Involved in preparing the data flow charts of each application,
maintenance of documentation for each gathered requirements.
> Involved in creating Open Hub Service to extract the data to flat
file.
> Developed various data extraction procedures for master data and
transaction data using LO cockpit and Generic extractors for
customer defined tables.
> Involved in User manual preparation and end user training.
> Created various standard and custom reports using Query Designer by
incorporating all the features available in BI 7.0.
> Created Infocubes, DSO, Multiprovider based on Sales, inventory and
Financial reports
> Worked on Inventory module and created Product family, Country and
Regional CDI Reports.
> Exporting the Reports to info view and scheduled the reports
depending upon the requirements.
> Worked on Flat file uploads for Master Data and Transaction data.
> Designed Bex and BO Queries using Structures, cells, Variables,
static and Dynamic Filters, Restricted and Calculated Key Figure in
query Designer.
> Created Dashboard, Spread sheet Table, Score card, Chat, Selectors,
Check box, using the xcelious components.
> Created and deployed Web Intelligence Reports through Info View
> Developed of Dashboard Xcelious Reports using Bex Queries.
Project Name : MYLAN-PHARMA
Organization : Wipro Technologies
Duration : Dec '11 to May'12
Client Name : Mylan, US.
Team size : 5
Environment : SAP ECC 6.0, SAP BI 7.0 AND BO 3.1
Role : Sr. Software Engineer
Mylan is one of the world's leading generics and specialty pharmaceutical
companies, providing products to customers in approximately 140 countries
and territories. The company maintains one of the industry's broadest and
highest quality product portfolios, which is regularly bolstered by an
innovative and robust product pipeline. With a workforce of more than
20,000, Mylan has attained leading positions in key international markets
through its wide array of dosage forms and delivery systems, significant
manufacturing capacity, global commercial scale and a committed focus on
quality and customer service.
Through its India-based subsidiary Mylan Laboratories Limited, Mylan has
direct access to one of the world's largest active pharmaceutical
ingredient (API) manufacturers. This relationship makes Mylan one of only
two global generics companies with a comprehensive, vertically integrated
supply chain. Mylan Laboratories Limited also is one of the world's largest
producers of API used to make generic antiretroviral (ARV) therapies for
the treatment of HIV/AIDS.
Additionally, Mylan operates a fully integrated specialty pharmaceutical
business, Mylan Specialty (f/k/a Dey), which produces innovative medicinal
therapies, including EpiPen (epinephrine) Auto-Injector.
Responsibilities:
> Actively and regularly involved in Load Monitoring of Daily,
weekly, and Monthly, Data Loads using Process Chains
> Validating the installed Business content objects
> Transported the developed BW objects to quality and production.
> Handled the tickets using Remedy tool.
> Resolving the data discrepancy related tickets raised by business.
> Responsible for suggesting measures to improve the production
system environment so that the queries have a better response time.
> Maintaining Reconciliation's to verify the data in SAP ECC 6.0 and
SAP BI are same or not after the data loads
> Analyzed and corrected production support problems as they occur in
the SAP BW System.
> Interacted with the end users, Business analysts and responsible
for involved in training sessions to import knowledge on designed
universe and published reports.
> Exporting the Reports to infoview and scheduled the reports
depending upon the requirements.
> Created the reports using Business Objects functionality's like
slice and Dice, Drill mode, Cross Tab, Master Detail, Custom Sorts
etc.
> Designed and developed the universe as per requirements.
Project Name : CHARTIS-INSURANCE CFP, FSL & RI
Organization : IBM India Private Limited
Duration : Sep' 10 to Dec' 11
Client Name : Chartis, US.
Team size : 22
Environment : SAP ECC 6.0 AND BI 7.0
Role : Sr. Software Engineer
Chartis Inc. was a subsidiary of American International Group formed in
2009 to oversee the property-casualty insurance arm of AIG in preparation
for a possible initial public offering or spin-off. The company ultimately
cancelled those plans, and rebranded the unit back to "AIG" in most markets
in late 2012.
American International Group, Inc. - also known as AIG - is a multinational
insurance corporation with over 63,000 employees globally. AIG companies
serve customers in more than 130 countries around the world; the company is
a provider of property casualty insurance, life insurance and retirement
services, and mortgage insurance. AIG's corporate headquarters are in New
York City, its British headquarters are in London, continental Europe
operations are based in La D fense, Paris, and its Asian headquarters are
in Hong Kong. According to the 2013 Forbes Global 2000 list, AIG was the
62nd-largest public company in the world.[4]As of April 21, 2013, it had a
market capitalization of $57.53 billion.
Responsibilities:
> AS SAP doesn't have module for Re-Insurance, Chartis has developed
Re-Insurance module and certificated by SAP.
> To Develop New Module in SAP I have extensively studied insurance
and Re-Insurance Concepts and involved in Creating data Flow for
the same.
> Going through the Technical specification and performing GAP
Analysis.
> Worked on RI Master Data Like Nature of Treaty, Treaty Status,
Treaty Slip, Line of Business, Contract Account,
Treaty+Period+Section, Teaty+BP+Broker, Participation Period,
> Worked on preparation of Back end Technical Specs and development
activities for CFP, FSL and RI.
> Worked for Controlling Data Source Like 0CO_OM_CCA_9 &
0co_OM_CCA_4.
> Worked for Business content Master Data Objects for Business
Partner, Insurance Object and Contract Account.
> Created Real Time cubes and Multiproviders (standard and real-time
Cubes) based on the user requirement.
> Created Real time cubes and multi-providers (Standard and real time
cubes), based on the user requirement
> Worked for Installment Plan, Open Items, Shadow GL, OGIS,
Reconciliation, BP Claim, BP Cash, Dunning, Contract Account
Partner.
> Worked on Reports for CFP, FSL and RI.
> Worked for RDA for UK GAAP and UK Stat and developed GL Reports
> Involved in Managing of InfoCubes, which involves InfoCube Content,
Performance issues like Indexes, Statistics, Compression of
InfoCube and Rolling up the data to the Aggregates.
> Created and scheduled the Error DTP to handle the error records in
the Error Stack.
> Worked extensively in Front-end Business Warehouse Components like
Queries, Calculated key figures, restricted key figures,
Structures, Variables, Exceptions and Conditions.
> Created and maintained Open Hub Services (OHS) to export data from
the info providers to external source for OGIS.
> To optimizing Query Performance Created Line item dimensions.
> Represend onsite for reverse knowledge transfer to client to
exercise understanding of applications.
> Worked on Transport request, Unit, Integration, Regression, and UAT
in quality and production system.
Project Name : PROMARK - BANKING
Organization : MphasiS an HP Company
Duration : Jan' 09 to Sep' 10
Client Name : Promark, US.
Team size : 1
Environment : SAP ECC and BI 7.0
Role : Sr. Software Engineer
DETROIT - Dhivya Suryadevara has been named chief investment officer of GM
Asset Management, effective today. Suryadevara was previously managing
director of investment strategy and fixed income for GM Asset Management.
She replaces Walter Borst, who recently announced his departure from GM to
become chief financial officer of Navistar International Corp.
"Dhivya's experience and strong track record in leading our investment
strategy and asset allocation for our pension plans will serve her well in
this important role for the company," said Dan Ammann, GM executive vice
president and chief financial officer. "I'm confident that she will build
on the great work the team has accomplished over the past few years.
General Motors Co. (NYSE:GM, TSX: GMM) and its partners produce vehicles in
30 countries, and the company has leadership positions in the world's
largest and fastest-growing automotive markets. GM, its subsidiaries and
joint venture entities sell vehicles under the Chevrolet, Cadillac, Baojun,
Buick, GMC, Holden, Isuzu, Jiefang, Opel, Vauxhall and Wuling brands.
Responsibilities:
> Actively and regularly involved in Load Monitoring of Daily,
weekly, and Monthly, Data Loads using Process Chains
> Responsible for suggesting measures to improve the production
system environment so that the queries have a better response time.
> Performed design changes to improve the database utility and
provide an efficient data warehousing environment.
> Responsible for handling the Service Request.
> Developed various test case scenarios and validated the BI reports
against the ECC tables at various stages of development such as
unit testing, functional unit testing and comprehensive integration
testing.
> Corrected Erroneous records in Error Stack and executed the Error
DTP to continue the loading process as part of testing in Quality
Box
> Extensively worked on the Data warehouse Workbench for Configuring,
Scheduling and Monitoring functions.
> Involved in query optimization and performance.
> Worked with Basis Team system copies and refreshed BI prod with pre-
production environment.
> Resolved security related issues in the design of roles needed for
the assignment of the queries and transaction codes to the end
users and super users.
> Maintaining the queue - related to the system generated tickets and
customer generated tickets
> Maintaining Reconciliation's to verify the data in SAP ECC 6.0 and
SAP BI are same or not after the data loads
> Handled the tickets of priority 1, 2 and 3 by following (SOP)
Standard Operating Procedures and never missed the (SLA) Service
Level Agreement
> Developed and documentation strategy for the tracking of the
changes and project progress.
> Liaise with SAP Basis Technical team regarding BI Transport
requests.
> Performed unit testing, Regression testing, regression testing and
user acceptances test (UAT) for GL, AP, AR, CCA, PCA, AA and CO.
> Developed universe user documentation guide for the end users.
> Implemented OSS notes for improving the delta load performance.
> Involved in applying the BI Support packages and fixed when
required using the service market place.
Project Name : GMAM - BANKING
Organization : MphasiS an HP Company
Duration : Jan' 08 to Dec' 08
Client Name : GMAM, US - Onsite
Team size : 4
Environment : SAP ECC AND BI 7.0
Role : Sr. Software Engineer
DETROIT - Dhivya Suryadevara has been named chief investment officer of GM
Asset Management, effective today. Suryadevara was previously managing
director of investment strategy and fixed income for GM Asset Management.
She replaces Walter Borst, who recently announced his departure from GM to
become chief financial officer of Navistar International Corp.
"Dhivya's experience and strong track record in leading our investment
strategy and asset allocation for our pension plans will serve her well in
this important role for the company," said Dan Ammann, GM executive vice
president and chief financial officer. "I'm confident that she will build
on the great work the team has accomplished over the past few years.
General Motors Co. (NYSE:GM, TSX: GMM) and its partners produce vehicles in
30 countries, and the company has leadership positions in the world's
largest and fastest-growing automotive markets. GM, its subsidiaries and
joint venture entities sell vehicles under the Chevrolet, Cadillac, Baojun,
Buick, GMC, Holden, Isuzu, Jiefang, Opel, Vauxhall and Wuling brands.
Responsibilities:
> Involved from Business blue print and gathering user requirements and
segregate the users based on roles and prepare a document called BI
documentation tree.
> Installed Business content cubes and DSO from BI content for all FI
Modules based on requirements.
> Build financial Infoproviders like ZFIAPO03, ZFIAP_C03, ZFIAPO06,
ZFIAP_C02, ZFIARO03, ZFIAR_C05, ZFIAR_C03, ZFIAA_C12, ZFIADS11,
ZFIADS12, ZFIGLO15, ZFIGLO04, ZFIGL_C04, ZCCA_C05, ZCCA_O02, ZCCA_C11,
and ZCCA_C03 & ZOPA_C11.
> Migration of data source from 3.x data flow to 7.0 flows using with
export and without export.
> Extracted data from SAP ECC and Non-SAP systems (Via Flat file)
> Involved in development of FI data sources related to GL, AP, AR, AA,
CCA, PCA, and MA.
> Designed and developed DSO's and Cubes for standard sources from ECC.
Created Transformations and assigned rule groups in the Application
areas for finances.
> Improved performance by implementing indexes, Aggregates and
Repartitioning of Cubes.
> Worked in Designing in Multiproviders, Infoset and Queries.
> Developed Hierarchies for Company Code, Profit Center and GL Account.
> Extensively worked on BI security issues and Created roles and
Authorizations.
> Worked with Bex Analyzer in building queries and defining rows,
columns and free characteristics, providing drill-downs, worked with
Restricted Key Figures, Calculated Key Figures, Formulas, Conditions,
Exceptions, and Variables & Structures.
> Designed Bex Reports like Client Reports, Balance Sheet Reports,
Income Statement Reports, AP Aging Reports, OROS Expenses Reports,
Asset Acquisitions, Asset History Reports, Depreciation Reports, But
for Reports, Variance Analysis Reports, Cost Center Reports, Monthly
Budget Reports, Project Plan and Trend Analysis Reports
> Involved in documentation and trained end - users in sing BEx analyzer
and Web Portal.
> Document Test Plans and complete unit testing of developed objects and
reports & involved in Design of tech specs
Project Name : XEROX
Organization : MphasiS an HP Company
Duration : June' 07 to Dec' 07
Client Name : XEROX, UK - Onsite
Team size : 4
Environment : SAP ECC AND BI 7.0
Role : BW Developer
Xerox was founded in 1906 in Rochester as The Haloid Photographic
Company,[8] which originally manufactured photographic paper and equipment.
The company subsequently changed its name to Haloid Xerox in 1958 and then
simply Xerox in 1961.[9] Xerography, a modern word meaning "dry writing"
developed from two Greek roots, is the name of the process invented in 1938
by Chester Carlson and developed by the Haloid Company. The company came to
prominence in 1959 with the introduction of the Xerox 914,[10] the first
plain paper photocopier using the process of Electro-photography, (later
changed to xerography) discovered by Chester Carlson, which he developed
with John H. Dessauer.[11] The 914 was so popular that by the end of 1961
Xerox had almost $60 million in revenue. Revenues leaped to over $500
million by 1965. Before releasing the 914, Xerox had tested the market by
introducing a developed version of the prototype hand-operated equipment
known as the Flat-plate 1385. This was followed by the first automatic
xerographic printer, the Copyflo, in 1955. The Copyflo was a large
microfilm printer which could produce positive prints on roll paper from
any type of microfilm negative. Following the Copyflo, the process was
scaled down to produce the 1824 microfilm printer. At about half the size
and weight, this still sizable machine printed onto hand-fed, cut-sheet
paper which was pulled through the process by one of two gripper bars. A
scaled-down version of this gripper feed system was to become the basis for
the 813 desktop copier.
Responsibilities:
> As one of the Technical consultants in implementation team,
involved in gathering user requirements, analyzing the internal
business units and data modeling.
> Extensively built queries on Info Cubes, Remote Cubes, DSO Objects,
MultiProviders, and Info Sets using BEx Query Designer, Analyzer,
publishing and integrated for EP.
> Transfer of Business Content from MM, SD & HR AREA to active
version with all its dependence objects like queries, Data Source,
Transformations, DTP etc.
> Extensively worked on Data source enhancements, Generic extraction
through Table, View and function modules using ABAP.
> Appended the data source structures to include new fields, written
ABAP code in the user-exit to fill the extraction structure.
Created custom info objects, characteristics and key figures.
> Involved in Initializing the LO Data sources - 2LIS_11_VAITM and
2LIS_11_VASCL by Activating the Business Content Data Sources,
Maintaining the Extract Structure, Generating the Data Source,
Activating the Data Source, Enhancing the Data Source and Used the
Enhancement RSAP0001 to fill the data into the Fields Enhanced.
> Loaded sales data into Cube (0SD_C03) using the following
extractors: 2LIS_13_VDITM, 2LIS_13_VDHDR, 2LIS_12_VCHDR,
2LIS_12_VCITM, 2LIS_11_VAHDR, 2LIS_11_VAITM.Staging. Configured
Data sources in R/3 by using LO Cockpit (LBWE) initialized the
setup tables. Scheduled and Implemented delta mechanism for
Periodic loads.
> Created Info Packages for Full, Initial, and Delta Loads for both
Master data and Transaction data
> Human Resource Module implementation and Understanding and managing
the responsibilities of the Project.
> Worked on roles and authorization for the developers and copied the
roles for the other instances.
> Using Bex Query Designer to define Complex Queries, defining
Exceptions, Conditions which nare later deployed in variety of
scenarios.
> Extensively worked on Variable User exits using RSR00001.
> Provided input, recommendations, and resolutions for technical
issues.
> Transport Organizer - maintained transport throughout BI landscape.
> Developed flexible queries with variables using filters,
Navigational attributes, Restricted Key figures, Reusable
structures and Currency translation factors in Bex to facilitate
further data analysis. Worked on Variables, Filters, Conditions,
Exceptions, Restricted Key Figures and Calculative Key Figures to
make report flexible, interactive and to flag Exceptions. Worked on
variety of reporting requirements using concepts of variable
offsets.
> Implemented Report to Report Interface (RRI) to Jump from
Summarized Sales Information infocubes to Detail Sales Information
infocubes.
> Involved in testing the reports and performing necessary changes as
per the new business logic
> Installed Business Content Purchasing, Sales Overview Cube and
designed and activated Customer service to meet user needs. Created
several DSO objects which act as data
Educational Background
Master of Business Administration (Marketing & HR) from Nagarjuna
University
Technical Skills
Operating Systems:
Windows 2003.
Databases:
Oracle, HANA.
Technologies:
Datawarehousing
Reporting:
BEX and BO
Primary skill sets:
SAP BW, BOBI, HANA