Data Oracle
Resume:
Summary of Skills
Professional Experience
Over *+ Years of focused
experience as BI Consultant AGYLISYS
in Oracle BI Application with April 2011 - Till Date
a strong background in
Business Intelligence Agilysys is a leading provider of innovative IT
Platform development. solutions, with special expertise in select markets,
including retail and hospitality. We use technology -
Technical Experience: including hardware, software and services - to help
customers resolve their most complicated IT needs.
Developing informatica SDE, Agilysys has been recognized as a best-of-breed
SIL and PLP Mapping. integrator that has invested in technical know-how and
Designing DAC tasks, subject earned premier certifications-including Citrix,
areas and execution plans. Microsoft, NetApp, IBM, HP, EMC, VMware and Cisco-in
Data Validation of Dimensions multiple areas of infrastructure.
and Facts in ETL. .
Strong on Unit testing and Role : BI Consultant
Troubleshooting skills. Scope : Implementation of Oracle BI Applications for
Had exposure in Oracle Financial, Enterprise Sales and Order Management
Business Intelligence Analytics with E-Business Suite R12.1.1 version)
Enterprise Edition (OBIEE)
[RPD, Answers and Dashboard] Responsibilities:
Customization and development of OOTB and new ETL
Experience in Gap Analysis Mappings for Oracle EBS Adaptor.
process with the client Worked on Informatica Power Center tool - Source
requirements. Analyzer, Data warehousing designer, Mapping & Mapplet
Designer and Transformation Designer.
Received appreciation mails Enhanced Revenue, Cogs and Sales Invoice OOTB Facts.
from the client side Team Customization for MCAL (Fiscal Calendar) Tables as per
lead for handling critical the requirements.
tasks in claim and financial Extensively used SCD type -1 for the implementation of
part with utmost accuracy the incremental logic.
meeting, timely deadlines. Create QA test scripts for the data validation of the
ETL process.
Tools Maintaining tasks in synchronize with QA, DEV and PROD
Informatica 8.6.1/8.6.0 Environments.
DAC 10.1.3.4.1 Worked on DAC metadata - design and configuration.
OBIEE 10.1.3.4.1 Customization of the RPD for the new columns and tables
added in Warehouse by following business rules.
Implemented Parameterization concept which helps the
Programming Languages mappings to run under any schema with required source
& Scripting and target DDL.
SQL Played major role in development of Data mart
PL/SQL consisting of various Fact and Dimension tables for
C, C++ Data warehouse Applications.
Database
Oracle 10G/9i. Technology:
SQL server 2008 BI Apps 7.9.6.1
OBI EE 10.1.3.4
Informatica 8.6.1
Operating Systems DAC 10.1.3.4.1
Windows 2000/NT Oracle 10g
4.0/98/95/ME/XP Windows XP, Unix
ANSELL HEALTH CARE Dec 2010 -
Work Experience March 2011
Working as BI Consultant in
KPI Partners, Bangalore Ansell Limited is a global leader in barrier protective
(India) from April 2010 to solutions, with operations in the Americas, Europe and
Till Date Asia. With operations in the Americas, Europe and Asia,
Ansell employs more than 11,000 people worldwide and
Worked as BI Consultant in holds leading positions in the natural latex and
Ezilon Technologies, synthetic polymer glove and condom markets.
Hyderabad (India) from April
2009 to April 2010 Role: BI Consultant
Scope: Implementation of Oracle BI Applications for
Supply chain and Order Management with the E-Business
Suite R12.1.2 version.
Educational Background
Bachelor of Technology in
Computer Science in Responsibilities:
Jawaharlal Nehru Customization and development of new and OOTB ETL
Technological University Mappings for Peoplesoft Adaptor.
(Hyderabad, Andhra Pradesh, Worked on Informatica Power Center tool - Source
India) Analyzer, Data warehousing designer, Mapping & Mapplet
Designer and Transformation Designer.
Made configuration changes to the data model, ETL, and
OBIEE metadata.
Implemented Parameterization concept which helps the
mappings to run under any schema with required source
and target DDL.
Involved in the error checking and testing of the ETL
procedures and programs in Informatica session log.
Involved in Performance tuning for mappings and
sessions
Played a major role in Unit testing of the mappings
developed.
Used Work flow Manager for Creating, Validating,
Testing and running the sequential and concurrent
Implemented Hard delete Logic of the data from the data
mart level with a post sql at the target.
Extensively used SCD type -1 for the implementation of
the incremental logic.
Create QA test scripts for the data validation of the
ETL process.
Worked on DAC metadata - design and configuration.
Customization of the RPD for the new columns and tables
added in Warehouse by following business rules.
Technology:
BI Apps 7.9.6.2
OBI EE 10.1.3.4
Informatica 8.6.1
DAC 10.1.3.4.1
Oracle 10g
Windows XP, Unix
NOVARTIS
July 2010 - Till Date:-
Novartis is a world leader in the research and
development of products to protect and improve health
and well-being. The company has core businesses in
pharmaceuticals, vaccines, consumer health, generics,
eye care and animal health.
Role : BI Consultant (Production Support)
Scope : Production Support (Implemented Oracle BI
Applications for HR Analytics with PeopleSoft 8.9 )
Responsibilities:
Analyze and fixing the Critical issues.
Worked on Informatica, OBIEE and DAC tools for the
issues raised accordingly.
Technology:
OBI EE 10.1.3.4
Informatica 8.6.1
DAC 10.1.3.4.1
Oracle 10g
Windows XP, Unix
PROGRESSIVE INSURANCE Apr 2010 - Nov
2010
Progressive is one of the largest auto insurance groups
in the US. Progressive offers auto insurance,
motorcycle insurance, boat, RV, home insurance and
more. Progressive works with more than 30,000
independent insurance agencies. The company has more
than 450 claims branches and 22 service centers with
more than 11 million policies in force.
Role: BI Consultant
Scope: Implementation of HR Analytics Oracle BI
Application.
Responsibilities:
Implemented the out of the box HR Analytics 7.9.6
components.
Worked on Informatica Power Center tool - Source
Analyzer, Data warehousing designer, Mapping & Mapplet
Designer and Transformation Designer.
Made configuration changes to the data model, ETL, and
OBIEE metadata.
Perform an initial load of the data with the history
available in PeopleSoft.
Extensively used SCD type -1 for the implementation of
the incremental logic.
Create QA test scripts for the data validation of the
ETL process.
Configure the DAC metadata. Create new tasks, subject
area, and Execution Plan for the client.
Perform a full load of the data.
Worked on adding prompts to the dashboard pages both at
the dashboard level and page level based on the
requirement.
Technology:
BI Apps 7.9.6.1
OBI EE 10.1.3.4
Informatica 8.6.1
DAC 10.1.3.4.1
Oracle 10g
Windows XP, Unix
SDUSD
Oct 2009 - Apr 2010
San Diego Unified School District (SDUSD) is a custom
student analytics project that aims to provide a
unified analytics and reporting for all the schools in
the San Diego district. SDUSD has marked more than 150
years of service to San Diego's children.
Role: BI Consultant
Scope: New development of ETL mappings and OBIEE
reports.
Responsibilities:
Worked on Informatica Power Center tool - Source
Analyzer, Data warehousing designer, Mapping & Mapplet
Designer and Transformation Designer.
Development of reports using Oracle Business
Intelligence Enterprise Edition (OBIEE) [Answers and
Dashboard]
Worked on adding prompts to the dashboard pages both at
the dashboard level and page level based on the
requirement.
Extensively used SCD type -1 for the implementation of
the incremental logic.
Create QA test scripts for the data validation of the
ETL process.
Configure the DAC metadata. Create new tasks, subject
area, and Execution Plan for the client.
Technology:
OBI EE 10.1.3.4
Informatica 8.6.1
Oracle 10g
Windows XP
QUALCOMM ENTERPRISE SERVICES Apr 2009 - Oct 2009
The project is intended as a product offering to QES
customers enabling them to have timely/actionable
information derived from data across various
applications for which the customer is licensed.
Role: BI Consultant
Scope: New development of ETL mappings
Responsibilities:
Implemented Parameterization concept which helps the
mappings to run under any schema with required source
and target DDL.
Involved in the error checking and testing of the ETL
procedures and programs in Informatica session log.
Involved in Performance tuning for mappings and
sessions.
Played major role in development of Data mart
consisting of various Fact and Dimension tables for
Data warehouse Applications.
Played a major role in Unit testing of the mappings
developed.
Used Work flow Manager for Creating, Validating,
Testing and running the sequential and concurrent
Sessions
Implemented Hard delete Logic of the data from the data
mart level with a post sql at the target.
Extensively used SCD type -1 for the implementation of
the incremental logic.
Technology:
Informatica 8.6.1
Oracle 10g
Windows XP, Unix
1
2
3
Think Oracle BI, Think KPI
[pic]
[pic]
Ajay Kumar Vaddepelli
BI Consultant
Ajay Kumar Vaddepelli BI Consultant
****.**********@***********.***
Contact this candidate