Curriculum Vitae
Rajeev Haranahalli
RAJEEV HARANAHALLI #806,
Willowbrook Drive,
Norristown, PA 19403
Phone No (M): 484-***-****
Email:aca1ks@r.postjobfree.com
Objective:
To pursue a challenging career as a Data warehouse Professional and
contribute in the design of Decision Support Systems that will deliver data
in time and meet their business requirements.
Professional Summary:
> Over 9.5 years of total IT Experience on Banking, Capital Markets and
Pharma Industries.
> Over 8.5 years of Data Warehousing experience in the Business
requirement Analysis, Application Design, Dimensional data modeling,
Designing, coding, development, testing, deployment, post production
support of business applications with RDBMS and Informatica for the
Banking, Capital Markets and Pharma Industries.
> Have implemented multiple end-to-end projects over the years
successfully.
> Strong in client facing roles. Involved in gathering the reqirements,
converting the requirements into technical specifications, Develop,
Test, Deploy and maintain.
> Strong understanding of Data warehouse concepts, ETL, Star Schema,
Snowflake, data modeling experience using Business Process Analysis,
Reengineering, Dimensional Data modeling, FACT& dimensions tables,
physical & logical data modeling.
> Strong Experience in identifying and resolving performance issues in
Informatica, SQL, indexing etc.
> Experience in working with multiple RDBMS including Oracle 11i/9i/8i,
Teradata and DB2.
> Have suggested solutions and process improvements to the clients
during the project execution phases.
> Created complex mappings using Lookup, Joiner, Aggregator and Update
Strategy Transformations.
> Possess excellent communication and interpersonal skills and ability
to work in a team as well as individually and communicate effectively.
> Innovative in Approach; Enjoys learning new methods and ideas and
putting them into daily practice.
Technical Skills
ETL Tools : Informatica 8.6, 9.1.
DBMS/RDBMS : Oracle 10g, 11g, DB2, Knowledge on
Teradata.
Programming Languages : SQL, PL/SQL, C.
Operating System : Windows Family, UNIX with Shell
Scripting.
Scheduling Tools : Autosys, UC4.
GUI : Visual Basic 5.0.
Data Modeling Tools : ERWIN 3.5
Experience Details
Presently Working as a Senior Systems Analyst at Accenture Pvt Ltd,
Collegeville, Pennsylvania.
Previously worked with Wipro Technologies from March 2006 to Dec 2006 and
at iGlobal Software from Sept 2003 to Feb 2006.
Qualification Details
B.E. in Computer Science from Malnad College of Engineering, Hassan (Mysore
University) with 76.6%.
Professional Experience
1.Project Title : Sales Reporting System
Duration : June 2011 - Till Date.
Team Size : 4
Client : PFIZER.
Environment : Informatica 9.1, Oracle 11g,.
Description: The client is the leading Pharma company in the world. Pfizer
needs reports on different Inventory and Sales metrics to make meaningful
business decisions and to be ahead in the competetion. The SRS system
captures the Customer data, the products data, the company data, the On
Hand, On Order, Pulls & Point of Sales data. This data is transformed and
reported on sales of different products, the customer, the time period, the
quantity sold and the total sales on a daily, monthly and yearly basis.
Responsibilities:
1. Study and Understand the Physical Data Model.
2. Analyse the requirements.
3. Create the ETL Design Document.
4. Create the HLD, Data Flow Diagrams and LLDs.
5. Create the mappings, worklets & workflows according to the requirements.
6. Work on the basic unit testing of the mappings.
7. Migrate the mappings from one environment to the other.
8. Support & Maintenance of the system.
9. Enhancements as and when needed based on business needs.
2.Project Title : China BI
Duration : Nov 2010 - May 2011.
Team Size : 4
Client : PFIZER.
Environment : Informatica 8.6, Oracle 10g,.
Description: The client is the leading Pharma company in the world. Pfizer
has its business in different countries. So it is imperative that it needs
a report from where ever it does its business to make meaningful business
decisions. The China BI basically captures the Customer data, the products
data, the company data, Indirect Sales data and the sales force data. This
data is transformed and reported on sales of different products, the
customer, the time period, the quantity sold and the total sales on a
monthly basis. China Project enable business to perform the sales analysis,
at sales force level, product level and
customer level.
Responsibilities:
10. Study and Understand the Physical Data Model.
11. Analyse the requirements.
12. Create the ETL Design Document.
13. Create the HLD, Data Flow Diagrams and LLDs.
14. Create the mappings, worklets & workflows according to the
requirements.
15. Work on the basic unit testing of the mappings.
16. Migrate the mappings from one environment to the other.
3.Project Title : Core BI
Duration : May 2010 - Till Date.
Team Size : 4
Client : PFIZER.
Environment : Informatica 8.6, Oracle 10g,.
Description: The client is the leading Pharma company in the world. Pfizer
has its business in different countries. So it is imperative that it needs
a report from where ever it does its business to make meaningful business
decisions. The Core BI basically captures the Customer data, the products
data, the company data, Indirect Sales data and the sales force data. This
data is transformed and reported on sales of different products, the
customer, the time period, the quantity sold and the total sales on a
monthly basis. Core Project enable business to perform the sales analysis,
at sales force level, product level and
customer level.
Responsibilities:
17. Study and Understand the Physical Data Model.
18. Analyse the requirements.
19. Create the ETL Design Document.
20. Create the HLD, Data Flow Diagrams and LLDs.
21. Create the mappings, worklets & workflows according to the
requirements.
22. Work on the basic unit testing of the mappings.
23. Migrate the mappings from one environment to the other.
4. Project Title : Philippines BI
Duration : Oct 2009 - Apr 2010.
Team Size : 4
Client : WYETH.
Environment : Informatica 8.6, Oracle 10g,.
Description: The client is the leading Pharma company in the world. Pfizer
has its business in different countries. So it is imperative that it needs
a report from where ever it does its business to make meaningful business
decisions. The Philippines data mart basically captures the Customer data,
the products data, the company data and the sales force data. This data is
transformed and reported on sales of different products, the customer, the
time period, the quantity sold and the total sales on a monthly basis.
Philippines Project enable business to perform the sales analysis, at sales
force level, product level and
customer level.
Responsibilities:
24. Study and Understand the Physical Data Model.
25. Analyse the requirements.
26. Create the ETL Design Document.
27. Create the HLD, Data Flow Diagrams and LLDs.
28. Create the mappings, worklets & workflows according to the
requirements.
29. Work on the basic unit testing of the mappings.
5. Project Title : MEXICO BI
Duration : Jan 2009 - Aug 2009.
Team Size : 5
Client : WYETH.
Environment : Informatica 8.5, Oracle 10g,.
Description: The client is one of the leading Pharma companies in the
world. Wyeth has its business in different countries. So it is imperative
that it needs a report from where ever it does its business to make
meaningful business decisions. The Mexico data mart basically captures the
Customer data, the products data, the company data and the sales force
data. This data is transformed and reported on sales of different products,
the customer, the time period, the quantity sold and the total sales on a
monthly basis. Mexico Project enable business to perform the sales
analysis, at sales force level, product level and
customer level.
Responsibilities:
30. Study and Understand the Physical Data Model.
31. Analyse the requirements.
32. Create the ETL Design Document.
33. Create the HLD, Data Flow Diagrams and LLDs.
34. Create the mappings, worklets & workflows according to the
requirements.
35. Work on the basic unit testing of the mappings.
6. Project Title : CANADA IMS
Duration : June 2008 - Dec 2008.
Team Size : 5
Client : WYETH.
Environment : Informatica 8.5, Oracle 10g,.
Description: The client is one of the leading Pharma companies in the
world. Wyeth has its business in different countries. So it is imperative
that it needs a report from where ever it does its business to make
meaningful business decisions. The Canada IMS data mart basically captures
the Customer data, the products data, the company data and the sales force
data. This data is transformed and reported on sales of different products,
the customer, the time period, the quantity sold and the total sales on a
monthly basis. IMS Project enable business to perform the sales analysis,
at sales force level, product level and
customer level.
Responsibilities:
36. Study and Understand the Physical Data Model.
37. Analyse the requirements.
38. Create the mappings, worklets & workflows according to the
requirements.
39. Work on the basic unit testing of the mappings.
7. Project Title : IBD/IT
Duration : Mar 2007 - June 2008.
Team Size : 5
Client : UBS.
Environment : Informatica 8.5, Oracle 10g, UNIX.
Description: The client is one of the leading Investment Banking Firm in
the world. The development of Banker Portal plays an important role in the
growth of their business. The Banker portal includes all the activities
from the time an opportunity is sensed till the time a deal gets worked out
/scrapped. This Banker portal includes a number of sub-modules like client
planning, client interaction, revenue Booking, Expense Management,
Dashboard etc.
Responsibilities:
40. Study and Understand the Physical Data Model.
41. Analyse the requirements.
42. Create the mappings, worklets & workflows according to the
requirements.
43. Work on the basic unit testing of the mappings.
8. Project Title : WMR
Duration : June 2006 - Dec 2006.
Team Size : 8
Client : Lehman Brothers.
Environment : DB2, DB Artisan 8.1.
Description: The client is one of the leading Investment Banking Firm in
the world. The development of data warehouse is inextricably the Business
need of the Enterprise. The goal of the WMR initiative is to attain core
competencies in client reporting for IMD High net worth individuals in
businesses like pim, pam etc. One of the main objectives is to provide
timely, accurate and comprehensive solution for strategic portfolio summary
reporting, incorporate AI Data into existing Neuberger reporting.
Responsibilities:
44. Study and Understand the Physical Data Model.
45. Derive the queries based on the relationship between different entities
and prepare the query document.
46. Prepare the Test Case Document.
47. Interact with the client and validate the data.
9. Project Title : DIA-RDS
Duration : March 2006 - June 2006.
Team Size : 16
Client : Lehman Brothers.
Environment : Informatica, DB2, DB Artisan 8.1.
Description: The client is one of the leading Investment Banking Firm in
the world. The development of data warehouse is inextricably the Business
need of the Enterprise. They had a need for an analytical data warehouse to
deliver unified view of data across IMD. They had a need for a data
integration layer integrating data across all sources of common data.
Deploy the Reporting Data Store (RDS) providing a consolidated and
normalized data view to all applications. They wanted to optimize data
access and storage for end-user performance and to create common services
to facilitate and standardize presentation and data analysis.
Responsibilities:
48. Study and Understand the Physical Data Model.
49. Derive the queries based on the relationship between different entities
and prepare the query document.
50. Designing and optimizing the mapping to load data in slowly changing
dimension.
51. Performance tuning of mappings and sessions.
10. Project Title : Banking Management System
Duration : Aug 2005 - Feb 2006.
Team Size : 8.
Client : Allied Bank, South Africa.
Environment : Informatica 6.1, Oracle 9i.
Description: The client has been a leading bank in SA. It has won a
reputation for being one of the most reliable and best performing
commercial bank in SA. The development of data warehouse is inextricably
the Business need of the Enterprise. They had a need for an analytical data
warehouse to improve the decision-making system. They wanted to get the
information about season wise analysis, target customer groups, loss making
schemes, profitable schemes, Branch wise analysis etc.
Responsibilities:
52. Design mapping as per ETL specifications.
53. Dimension Loading.
54. Designing and optimizing the mapping to load data in slowly changing
dimension.
55. Used workflow manager to create and configure workflow and session
tasks to load the data.
56. Performance tuning of mappings and sessions.
11. Project Title : Inventory Analysis
Duration : Oct 2004 to May 2005
Team Size : 8.
Role : Developing, Testing.
Environment : Informatica 6.1, Oracle 9i.
Description:
Universal solutions is one of the leading processing company in Malaysia.
This warehouse is developed for Inventory analysis of the value of
material, labour and associated overhead cost incurred to provide products
for sale to customer etc. Data from heterogeneous Operational Source
Systems is received in different formats. The incoming data is saved into a
delimited file format and then loaded into the staging area. Data cleansing
is done in the staging area and then data is extracted, transformed and
loaded into the warehouse using Informatica 6.1.
Responsibilities:
. Designed the ETL processes using Informatica tool to load data from File
system, MS Access and Oracle into the target Oracle 9i database.
. Developed various kinds of mappings.
. Optimizing the mapping to load data in slowly changing dimensions.
12. Project Title : San Miguel Sales Analysis
Duration : Feb 2004 to June 2004
Team Size : 8.
Client : San Miguel.
Environment : Informatica 6.1, Oracle 9i.
Description: San Miguel Pure Foods Company Inc. is one of the Philippines's
leading producers and marketers of branded food products, both in human and
animal nutrition with a business portfolio that is unparalleled in the
industry. The company offers a complete line of food products and services
for both individual and food service customers. Its businesses range from
vegetable oils, feeds, flour, poultry, fresh and processed meats, and diary
products to food service. This Project involved in creating a data
warehouse for sales reporting system. Data from ODS was extracted,
transformed and loaded into data warehouse using Informatica.
Responsibilities:
57. Designed and implemented various transformations using Informatica.
58. Developed various kinds of mappings.
59. Optimizing the mapping to load data in slowly changing dimensions.
60. Used workflow manager to create and configure workflow and session
tasks to load the data.
61. Test mapping to assure that data is loaded as per ETL specification.
62. Performance tuning of mappings and sessions.
Personal Profile
Sex Male.
Date of Birth 1st JULY 1979
Marital Status Married