Sarada Chintalapati Present Employer: Tata Consultancy Services
Email :
[email protected], Phone : 09886115713
Objective
Seeking a challenging position in a company that will utilize my analytical and practical skills. I have around 2 years of experience in Software Development Life Cycle. Areas of expertise include Data warehousing, OLAP and ETL tools, Oracle database.
Qualifications
EXPERIENCE SNAPSHOT Technical Specialization Programming Languages: PL/SQL ETL Tools: Informatica Power center 7.1,
Reporting Tools: Business Objects 5.x. Cognos
Qualifications Degree and Date
University
Bachelor of TechnologyJune-2003 10+2
Jawaharlal Nehru Technological University Andhra Pradesh
10th
Other Tools: PCAnywhere, PL/SQL developer Repository: CVS, Quick place of GE.
Page 1 of 5
Percentage
-
85%
-
82%
72%
Professional Memberships / Certifications Professional Society / Certification Informatica Certification. Six Sigma Green Belt.
Database Management Systems: Oracle 9i, SqlServer2000.
Board of Intermediate Education- AP Railway Mixed High School
Major and Specialization Computer Science and Information Technology.
Member Since / Date Certified July-2005 Mar-2006
EEXPERIENCE April 2004 – Till Date Working as Assistant Systems Engineer in Tata Consultancy Services (GE GDC), Bangalore, India.
Project Details Project
Electronic Product Data Management
Customer
GE – Health care
Period
Sep-2005 – Till date
Description
GE Healthcare provides transformational medical technologies that are shaping a new age of patient care. GE Healthcare’s expertise in medical imaging and information technologies, medical diagnostics, patient monitoring systems, disease research, drug discovery and biopharmaceuticals is dedicated to detecting disease earlier and tailoring treatment for individual patients. EPDM Provides a tool where individual users are enabled to create reports from data in the production PDM system. It allows the users to select from a wide range of production system data elements and apply report formatting output options. Informatica is used to build the business logic at the backend, ensure that the performance is tuned for the most efficient use of the BI infrastructure. Cognos provides reporting facility to User with security levels defined.
Role
Team member
Tasks Handled
1. Requirement Analysis and Effort Estimation. 2. Co-coordinating with onsite for requirements and Project deliveries for ETL. 3. Design of processes to extract, transform and load data from different file source systems via Informatica mappings into the data warehouse. 4. Developing Informatica Mappings. 5. Scheduling of Informatica Mappings for daily/weekly load. 6. Data Analysis and Reconciliation Windows NT Oracle 9i database Teradata
Solution Environment
Tools
Informatica
Project
EEF Data Warehouse Support.
Customer
GE – EEF.
Page 2 of 5
Period
Apr-2005 – Aug-2005.
Description
Italy Risk Exposure and Monitoring Application provides the business users the analysis of Risk involved in a lease/ Rental application. Source database is MS SQL server and generated flat files that consisted risk factor calculations. Italy Risk daily load involved Lease/Rent source data coming from 3 different platforms viz. Liscor, Xerox and Extranet. Data of applications received and contracts made for Lease/Rent of GE equipments on a daily basis is provided in flat files. Initially the whole process was in MS SQL package which loaded data from flat files to the database. This project involves developing mappings which simulated the existing MS SQL package to load data to the Database which was useful for Risk Exposure and monitoring application.
Role
Team member.
Tasks Handled
1. Developing Informatica Mappings. 2. Scheduling of Informatica Mappings and procedures for daily/weekly load. 3. Data Analysis and Reconciliation Windows NT Oracle 9i database MS SQL server
Solution Environment
Tools
Informatica
Project
Siebel Data Mart
Customer
GE – EEF.
Period
Jan-2005 – March-2005
Description
GE European Equipment Finance (EFF) pioneer and specialized in providing solution to the prospective customer in European market. Siebel Data Mart provides solution for various reporting and BI solutions starting from the lowest level of granularity. It has source system as Siebel and it further serves as source to various reports and for Customer Centric Process Management Digital Cockpit.
Role Tasks Handled
Page 3 of 5
It provides business solution for GE –EEF Business for various financial reports at various levels of hierarchy, with security at different levels. Informatica is used to build the business logic at the backend and Business Object Web-I provides online reporting facility to User with security levels defined. Team Member. 1. Requirement Analysis/Gap Analysis and Effort Estimation. 2. Co-coordinating with onsite for requirements and
Solution Environment
Project deliveries for ETL. 3. Design of processes to extract, transform and load data from different file source systems via Informatica mappings and stored procedures into the data warehouse. 4. Scheduling of Informatica Mappings and procedures for daily/weekly load. 5. Data Analysis and Reconciliation Windows NT Oracle 9i database Siebel.
Tools
Informatica, Business Objects
Project
Customer Centric Process Management Digital Cockpit.
Customer
GE – EEF.
Period
Apr-2004 to Dec-2005.
Description
GE European Equipment Finance (EFF) pioneer and specialized in providing solution to the prospective customer in European market. The Customer Centric Process Management project is to provide the client to analyze the business in terms of graphical representation, and provide a web based intranet portal application that covers GE EEF Business management. It aims to build a consistent architecture for PAN-European Solution. To build a process to plug in new metrics as and when the need arises.
Role
Handling backend for CCPM.
Tasks Handled
1. Requirements Analysis/Gap Analysis and Effort Estimation. 2. Co-coordinating with onsite for requirements and Project deliveries for ETL. 3. Design of processes (including error strategy) to extract, transform and load data from different file source systems/Siebel Source Systems via Informatica mappings and stored procedures into the data warehouse and cockpit. 4. Scheduling of Informatica Mappings and procedures for daily/weekly load. 5. Data Analysis and Reconciliation
Solution Environment Windows NT Oracle 9i database Tools
PERSONAL PROFILE
Page 4 of 5
Informatica Data Ware House (ETL) tool.
Date of Birth Sex Nationality
: : :
8th September, 1982 Female Indian
Passport No.
:
A9852638
Permanent Address
:
Present Address
:
Phone Mobile E-mail
: : :
Plot No. 12, Brindavan Colony, Sainikpuri post, Secunderabad -94 #1217, 2nd A cross,18th Main, 2nd phase, JP Nagar, Bangalore. 91-04-27110458 91-9886115713
[email protected] [email protected]
Page 5 of 5