Informatica certified professional
Resume:
Pradeep Kunju
(C) 818-***-**** Email: ************@*****.***
SUMMARY OF SKILLS
Experienced in Data Warehousing and Business Intelligence applications
Experienced in all phases of the project life cycle including Dimensional Modeling, ETL and Business Intelligence.
Excellent Experience in ETL Tools - Informatica PowerMart v5.1/6 & Power Center v5.1/6.2/7.1.3/8.6
Familiar with Cognos Business Suite – Impromptu v6.0/7.0, PowerPlay v6.6/7.0
Extensive experience in Data Modeling, Design, Development. Experienced in creating logical and physical design of databases. Designed data warehouses and databases using Erwin 3.5.2 and Designer 2000.
Proficient in Ralph Kimball’s Methodology, Bill Inmon Methodology and Data Mart approach for designing Data Warehouse.
TECHNICAL SKILLS
Languages C, SQL, PL/SQL
Data Warehousing
INFORMATICA– Informatica PowerMart v5.1/4.6 & Power Center v5/6/7/8,
COGNOS – Impromptu 6.0/7.0, PowerPlay 6.6/7.0
MSOLAP: Analysis Server
Databases Oracle 8.0, UDB/DB2, Informix, Essbase, SQL Server 2000/7.0/6.5, MS Access
Design Tools Erwin 3.5.2
e-CRM Talisma – e-Sales, e- Marketing, e-Service
Platforms Windows NT/2000, Sun Solaris 5.0
EDUCATION
BTech (Electronics and Communication)
IBM ACE Application Developer Course
CERTIFICATION
Informatica Certified Designer versions 5/6/7/8
Informatica Certified Administrator versions 5/6/7/8
Informatica Certified Consultant versions 5/6/7/8
TRAINING
Informatica versions 6/7/8
PROFESSIONAL EXPERIENCE
1) Data warehousing consultant Jan 05 - Present
PROJECTS
Client: Expedia Inc Nov 06 till present
Role: ETL Developer & Administrator
Performed Finance production implementation, daily support, documentation and knowledge share as part of Enterprise Data warehouse (Denali) - Phase1. Was involved in Value Score and Datamart implementation, and support for Denali – Phase 2. Enabled the Informatica Superglue application to perform its advertised functionality. Worked on Finance pre-runs and month-end runs.
Responsibilities
Design and development of Informatica ETL for Enterprise Data warehouse (Denali)
System testing, and UAT of Informatica workflows and mappings
Scheduling of Informatica workflows according to SLA requirements
Daily support of Denali-Phase1 (LZ/ADS), Phase2 (Value Score), Datamarts and Email phase applications.
Code migration of various Denali phases to Production and DR.
Handled etl bug fixes, mapping changes to incorporate new functionality based on business requirements.
Handled Finance pre-run and Month-end runs.
Worked on the Informatica upgrade from 7.1.4 to 8.5.1 version.
Documentation and knowledge share of Denali applications.
Setting the Informatica production security management that entailed creating user groups and assigning privileges.
Taking regular backup of the repository, Metadata Reporting and tuning of the repository tables.
Running daily schema audits on NRT databases using the metadata application which identifies changes in NRT that can be balanced with Site Sup requests, off cycle releases, etc.
Loading over 85 database Power Designer models into the Superglue application and began running schema audits against the Live Site databases enabling DB Developers the ability to identify, clean up and prevent inconsistencies between the PD model in the specification and actual production databases.
Custom changes to the application that enabled the Superglue application to show data lineage between NRT, LZ, ADS, FJE, and reporting applications in EDW.
Environment: PowerCenter 7.1.4/8.5.1, Superglue, DQ XI, DB2 UDB, Sun Solaris, PL/SQL, Flat files, Unix scripts
Client: Cingular Wireless – Blue to Orange Conversion Jan 05 - Oct 06
Role: ETL Developer & Database coordinator
Designed and developed mappings in Informatica to load data from Blue Billing to Orange Billing systems. Sources were Oracle and XML. Target was primarily flat file. Extracted data from Oracle Financials using Informatica’s Oracle eBusiness adapter. As Database co-ordinator, was responsible for source data environments, and making sure they meet the needs of Developers and Analysts. Maintained reference document for all source systems data locations. Performed shake-out of databases after refreshes to ensure there is enough storage, proper users/tables/tablespaces etc.
Responsibilities
Installation and configuration of Informatica PowerCenter 7.1.2
Creating Informatica Repository in Oracle to store the metadata required for the Data Conversion.
Setting the security management that entailed creating user groups and assigning privileges.
Creating Informatica maps using various transformations like XML Parser, Source Qualifier, Expression, Look up (connected and unconnected), Stored Procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
Used Informatica’s oracle eBusiness adapter to extract data from Oracle Financials
Designing and documenting validation rules, error handling and test strategy of the maps.
Parametrising the informatica sessions to ensure easy handling of load environments like Dev, SI, QA and Production.
Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
Developing shell scripts to automate the batch runs and maintaining them.
Performance tuning of the sessions using Workflow Manager Statistics and front end query tools.
User and Technical Documentation
Responsible for source data environments and making sure that they meet the needs of Dev, Ops, and Analysts; work with team leads and PM's to resolve gaps
Maintain reference document for all source systems data locations (databases and logins), unix hosts, TNS entries, assist with user logins, etc.
Keep track of scheduled environment refreshes and coordinate/communicate with Dev, Ops, and Analysts to prepare for the impacts
Shake out databases after refreshes to ensure there is enough storage, proper users/tables/tablespaces are there, etc.
Point of contact for troubleshooting database issues
Point of contact for environment change requests
Point of contact for activity scheduling and communication (with help from team leads) (i.e. data provisioning vs. reporting vs. execution vs. testing vs. dry runs, etc. making sure people are not getting in each others' way)
Environment: PowerCenter 7.1.3, Oracle 9i, Sun Solaris 2.9, PL/SQL, Flat files, Unix scripts
2) Company: Euro-Web India
Title: Software Engineer (May 00 – Dec 04)
PROJECTS
Ranbaxy- DSS System for Finance, Sales and Inventory Feb 04 – Dec 04
Role: Informatica Consultant
The project was to develop a Sales Analysis system for Ranbaxy. It involved moving data from the OLTP production environment to a staging area. The data from the staging environment is then extracted and transformed and loaded into the mart. The source is Oracle database and the target is Oracle database. Informatica was used as the ETL tool and Cognos BI suite was used for analysis.
Responsibilities
Interacting with the business users to understand the requirement.
Working with Informatica Power Mart Designer, Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer, Repository Manager and Server Manager.
Creating mappings to populate the dimension tables and the fact tables.
Creating workflows and batches for the load and scheduling the same.
Performance Tuning – this involved testing source, target and sessions for the bottlenecks, tuning the transformation queries, index creation.
Environment: Informatica PowerCenter 6.1.2, Oracle 8i, Cognos Impromptu 6.0, Power Play 6.6
Nestle India Ltd- Consumer Repository Mar 03 – Jan 04
Role: Data warehousing specialist
The Consumer Repository would feed the various customer relationship management applications like Epiphany and also generate feeds for the Nestle call center. The Project consisted of creating a relational model from various data feeds using Informatica PowerMart 6.1. The sources were XML and flat files. The data was staged in SQL Server 2000 and then transformed and loaded into the relational schema in Oracle.
Responsibilities
Design of logical process flow from source to target.
Documentation and logical schema creation using Erwin
Installation and configuration of Informatica PowerMart 6.1
Creating Informatica Repository in Oracle.
Creating user groups and users within them and assigning selective privileges and permissions.
Creating Informatica maps using various transformations like Source Qualifier, Expression, Look up (connected and unconnected), Aggregate, Sorter, Update Strategy, Joiner, Filter and Router.
Created Advanced External Procedures in Informatica to handle Trillium functions like Parsing, Geocoding and Matching.
Generating XML output files from the repository
Parametrising the Informatica sessions to ensure easy handling of load environments like SI, QA and Production.
Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
Taking regular backup of the repository, Metadata Reporting and tuning of the repository tables.
Environment: PowerCenter 6.1, Oracle 8i, XML, Trillium.
Monsanto (India) Ltd- Financial Datamart Jan 02 – Feb 03
Role: ETL Team Lead
Worked closely with the dimensional modeler during the user sessions and reports analysis to arrive at the dimensions and the facts. Used Erwin to document the dimensional model and forward engineer the physical schema. Designed and Developed interfaces in Informatica PowerCenter 5.1 to populate Financial Datamart from flat files, XML files and Sybase database. The interfaces extracted data from the various source systems, transformed the data according to the business logic and populated the Data mart in SQL Server 2000.
Responsibilities
Dimensional Modeling and Documentation/Schema creation using Erwin
Installation and configuration of Informatica PowerCenter 5.1
Creating Informatica Repository in Oracle 7i to store the metadata required for the Data Mart.
Creating user groups and users within them and assigning selective privileges and permissions.
Creating Informatica maps using various transformations like Source Qualifier, Expression, Look up (connected and unconnected), Stored Procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
Wrote PL/SQL scripts to performance tune sessions.
Designing and documenting validation rules, error handling and test strategy of the maps.
Parametrising the Informatica sessions to ensure easy handling of load environments like SI, QA and Production.
Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
Performance tuning of the sessions using Sybase front-end utility.
Taking regular backup of the repository, Metadata Reporting and tuning of the repository tables.
Environment: Erwin 4.0, PowerCenter 5.1, Sybase, Oracle 7i
Alstom Ltd, India- Data Conversion for I2 Implementation May 00 – Dec 01
Role: Data Conversion Specialist
Designed a logical model for the I2 Active Data warehouse (ADW). Designed and Developed interfaces in Informatica PowerCenter 5.0 to populate ADW from Northstar2000 and Peoplesoft. The interfaces extracted data from Northstar2000 in Informix and Peoplesoft in DB2, transformed the data according to the business logic and populated the ADW in Oracle. The dimensions of Sales analysis were customer, product and region for the different measures of sales revenue, cost of sales, gross profit, gross profit %, net sales and quantity sold.
Responsibilities
Installation and configuration of Informatica PowerCenter 5.0
Creating Informatica Repository in DB2 to store the metadata required for the Data Conversion.
Setting the security management that entailed creating user groups and assigning privileges.
Creating Informatica maps using various transformations like Source Qualifier, Expression, Look up (connected and unconnected), Stored Procedure, Aggregate, Update Strategy, Joiner, Filter and Router.
Designing and documenting validation rules, error handling and test strategy of the maps.
Parametrising the informatica sessions to ensure easy handling of load environments like Dev, SI, QA and Production.
Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
Developing shell scripts to automate the batch runs and maintaining them.
Performance tuning of the sessions using Server Manager Statistics and front end query tools.
Taking regular backup of the repository, Metadata Reporting and tuning of the repository tables.
User and Technical Documentation.
Training the team, handholding and post implementation support.
Environment: PowerCenter 5.0, Oracle 8i, Informix, Sun Solaris 5.0
Contact this candidate