Data Sap
Resume:
Richa Jain
E-mail: ****.*******@*****.***
Contact: 425-***-****
PROFILE SNAPSHOT
Data warehouse and BI consultant with nearly 5 years of professional experience which includes Development and Support in SAP BI 7.0 and BW 3.5, Involvement in two End to End life cycle implementations and involvement into design and development of BW objects, Transformations, Business Content configuration as well as generating reports and post implantations support.
PROFESSIONAL SUMMARY
Nearly 5 years’ experience in SAP Netweaver 2004s/BI 7.0, BW 3.5 and other data warehousing technologies. Involved in design, development, implementation and support of SAP BI/BW applications.
Experience in leading technical/functional team for technical realization of DW BI solution.
Experience in creating Generic Data Sources in SAP R/3.
Developed SQLs, Extracts, Transformations, Loads and various ETL designs in SAP BI 7.0 and 3.5x.
Experience in creating Info Package to create Process chains and Scheduling of data loading with Full/Initialization/Delta upload method.
Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.
Skilled in Data Modeling using Entity Relationship (ER), Multi Dimensional/Star Schema and Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data model.
Experience in Data Integration of Non SAP data sources (Flat Files) with SAP BI.
Involved in the postproduction support, which required Infocube management using Compression, Rollup, and Reconstruction.
Good Understanding of business Process for Designing the Analytical Reports.
Experience in Designing of Multi providers and Infosets.
Understanding of Start and End Routines.
Experience in Rev Track System for SAP Transports.
Experience in data loading and monitoring job, scheduling and automating process chains.
Good understating of BO reports and connectivity of SAP BI to BO system.
KEY SKILLS
Data Warehouse: SAP BI 7.0, BW 3.5, Standard SQL
ERP Packages: SAP R/3 6.0(Functional), SAP Netweaver 2004s.
Reporting Tools: SAP BEx Designer, Web Reporting.
Platforms: Windows (XP, NT, 2000, Vista).
Functionality of MS Excel
Functionality of BO Reports
EDUCATION
B. E. In Computer Science from Govt. Engineering College, Ujjain ( MP)
Higher Secondary (12th) from Raman Higher Secondary School, Bhopal (MP)
High School (10th) From Govt. Higher Secondary School, Pindrai, Dist- Mandla (MP)
EMPLOYMENT DETAILS
Employment-1
Company Name : Jindal Steel & Power Limited
Location : Raigarh, Chhattisgarh
Employment Period : 05th May 2008 to 31st March 2010.
Designation : Engineer (SAP BI Consultant)
Department : Information Technology
Employment-2
Company Name : IBM India
Location : Bangalore, KA
Period : 05th May 2010 to 21st Oct 2013
Designation : System Application Developer- SAP BI
PROJECT DETAILS
1- Henkel FMO
Role - Team member
Duration - March 2013 to Oct 2013
Team Size - 15 members
Environment - SAP BI 3.5x
Company - IBM India PVT LTD, Bangalore
Responsibilities
Understanding of Functional Specifications and creating high level design.
Understanding of Layered Architecture.
Build activities involve end to end development of clusters from scratch starting from data source to Reports.
Creating process chains for data loads.
Analyzing the Bex reports at technical and functional point of view to resolve client issues.
Preparing Hand over Documents and giving back to client.
Business Understanding of Henkel.
Transportation Management System.
Supporting the data loading process and resolving issues during loads.
Working on change request tickets as small modification and enhancement without impacting existing system
2- Shell Crystal MI
Role - Team member
Duration - Jan 2011 to nov 2011
Team Size - 30 members
Environment - SAP BI 7.0
Company - IBM India PVT LTD, Bangalore
Responsibilities
Understanding of Functional Specifications and creating high level design.
Doing the prototype work once design is frozen.
Understanding of Layered Architecture.
Build activities involve end to end development of clusters from scratch starting from data source to Reports.
Creation of Info Objects, DSO, Info Cubes, Multi Providers and Transformations.
Co-ordinate with ABAP Team and for Writing start and End Routines.
Creating process chains for data loads.
Creating queries for the cluster using Query Designer involving Calculated and Restricted KFs, different Variables, formulae, Conditions, Exceptions Filters etc.
Preparing Hand over Documents and giving back to client.
Further transporting the objects to Acceptance, Quality and Production system using Rev-track
Transportation Management System.
Doing data loads.
2- Shell GSAP Build
Role - Team member
Duration - May 2010 to Dec 2010
Team Size - 35 members
Environment - SAP BI 7.0
Company - IBM India PVT LTD, Bangalore
Responsibilities
Understanding of Functional Specifications and High Level Design.
Doing the prototype work once Design is frozen.
Build activities involve of clusters Reports.
Creation of Info Objects, DSO, Info Cubes, Multi Providers and Transformations.
Creating queries for the cluster using Query Designer involving Calculated and Restricted KFs, different Variables, formulae, Conditions, Exceptions Filters etc.
Preparing Hand over Documents and giving back to client.
Further transporting the objects to Acceptance, Quality and Production system using Rev-track
Transportation Management System.
Working on NLS load and Data Archiving.
3- JSPL Akriti
Role - Team member
Duration - May 2010 to Dec 2010
Team Size - 40 members
Environment - SAP BI 7.0
Company - Jindal Steels & Power Pvt. LTD
Responsibilities
Gathered requirements from functional users for cross-functional analysis.
Understanding of Standard Data sources for Requirements.
Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
Worked with functional consultant for mapping the source data (R3/non R3) to target Data Sources in BI. Defined the initial sizing requirements based on source data volume estimates.
The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
Enhancement of Standard Data Sources and standard info Providers. Also configured BW objects including generic data sources to extract data from R/3 systems.
Designing of Generic Data Sources for PP and HR for Fulfilling the Requirements of users also.
Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in MM ( Purchasing), PP and HR areas. Created SAP BI reports which include Plan/Actual revenue comparison.
Designing of Process Chains and Day to Day Data loading Activities and monitoring for Post Go-live Support
Further transporting the objects to Quality and Production.
Understanding of Transportation Management System.
Good Understanding for Roles and Authorizations.
PERSONAL DETAILS
Gender : Female
Residence : 15216 16th place NE unit 29, Bellevue, zip code 98007
E-Mail : ****.*******@*****.***
Work Permit : L2 visa with EAD
Contact Number : 425-***-****
Contact this candidate