hi
here is the summary of my consultant, please let me know if you have any
suitable requirements.
· *Seven years* of IT experience in the Requirement Analysis, Data
Analysis, Application Design, Application Development, Implementation and
Testing of Applications in Data warehouse with strong business knowledge of
*Financial, Insurance and Pharmaceutical projects*.
· Experience as technical consultant in using *Informatica* *PowerMart
/* *PowerCenter v 8.1/7.1.2/6.2/5.1* (Repository Manager, Mapping Designer,
Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer,
Transformations Designer, Warehouse Designer, Power-Exchange for DB2, Power
Connects for ERP) *as ETL tool on Oracle, DB2 *and *SQL Server Databases.*
· Involved in full length Life-Cycle implementation of ETL process.
· Worked on new features in Oracle 10g like *Rollback Monitoring,
Materialized Views, **Flashback Table *etc.
· Migrated the Mappings and Workflows through *Mainframes.*
· Expertise in creating data-warehouse and scheduling work-flow
using *Oracle Warehouse Builder*(OWB)
· Experience in developing various Informatica Transformations and
Mappings.
· Experience in integration of various data sources like Oracle,
DB2, Flat Files, and files into the staging area.
· Experience in Dimensional* Data Modeling*, Star Schema Modeling,
Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data
Modeling, Erwin 4.x.
· Experience in writing *UNIX *shell scripts and automating the
Informatica Processes.
· Created *JCL *and scheduled the jobs using Scheduling tool using *
CA7.*
· Working knowledge of *PL/SQL, SQL*, programming.
· *Develop Architect design *and Process flow*.*
· Experience with data reengineering, and data standardization.
· Experienced in overall *Data Warehouse, Database, Informatica
Performance* tuning for better performance.
· Good experience in writing test plans and test cases.
· Involved in identification of facts, measures, dimensions and
hierarchies for OLAP models.
· Used *Scheduling* *Automation Tools* like *Autosys *and *Control M
*.
· Performed some *DBA Functionality* by creating tables,
constraints, granting permissions, move data from one server to another etc.
Communicated with DBAs and ETL admin for major issue either via raising
tickets or contacting them directly in emergency situations.
· Experience in using testing tools like *Test Director.*
· Excellent analytical, problem solving skills and a motivated team
player with excellent inter-personal skills, communication and presentation
skills.
* *
EDUCATION
* *
· *Masters in Computer Science.*
* *
* *
* *
TECHNICAL SKILLS
* *
*ETL Tools** ** ** **: Informatica* PowerCenter /
PowerMart 8.1/7.1.2/6.2.1.0/5.1.1, Power
Exchange, Power Analyzer, MQ
Series, SQL*Loader.
* *
Hardware : UNIX, LINUX Servers.
*Database** ** :* Oracle 10g/9i/8i, Sybase, DB2,
TERADATA*,* SQL Server.
*Operating Systems** ** : *UNIX, LINUX, IBM Mainframes, AS/400,
Solaris,
* ** * Windows XP/00/NT/98/95.
*Programming Lang** ** : *SQL, PL/SQL, C, Unix Shell scripts, HTML.
*Automation Tools** ** *: Autosys, Control M.
*Utilities* : Toad, SQL Navigator 4.4
*Reporting Tool* : Business Objects, Hyperion, Cognos.
*Testing Tools* : Test Director.
EXPERIENCE
*Client: **AETNA, CT** ** **
**(Mar **‘**08 **–** Till Date)*
*Role: Sr. ETL Programmer/Analyst*
*Project Description:* *AHIA (Aetna Health Information Advantage)*
AETNA* *is one of the nation's leading diversified health care
benefits* *companies.
AETNA has been the leading provider of workers compensation insurance,
programs and services. The primary objective of this project is to get data
from different sources and perform the necessary operations on the data as
per the user requirement and load it on to the Oracle which will eventually
be used by other applications.
*Responsibilities:*
- Extensively used Informatica to load data from different data sources
into the oracle data warehouse.
- Involved in *Data Cleansing *and* Extraction*.
- Involved in Data modeling and design of data warehouse in star schema
methodology with confirmed dimensions and FACT tables.
- Extracted data from sources like DB2, Oracle, Sybase, Fixed width and
Delimited Flat files, transformed the data according the business
requirement and then Loaded into the Oracle Database.
- Modified several of the existing mappings and created several new
mappings based on the user requirement.
- Maintained existing mappings by resolving performance issues.
· Developed the *Design Document* for each ETL mapping, defining the
source and target tables and all the fields, transformations and the join
condition, which helped the users to better understand the type of data.
- Created Mappings using Mapping Designer to load the data from various
sources using different transformations like Aggregator, Expression, Stored
Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence
Generator, Source Qualifier, and Update Strategy transformations.
- Implemented *Slowly Changing Dimensions* (SCDs, Both Type 1 & 2).
- Handled operating system tasks by generating Pre and Post-Session *UNIX
* Shell Scripts.
- Created and Scheduled Sessions and Batch Processes based on demand
using Informatica Server Manager.
- Developed *UNIX *shell scripts for ETL implementation.
- Created and loaded reporting data-warehouse using ETL
capabilities of *Oracle
Warehouse Builder*(OWB)
· Involved in Writing Shell scripts to automate Pre-Session and
Post-Sessions Processes.
· Used *Scheduling Too*l *Autosys* to schedule UNIX shell scripts,
PL/SQL scripts and Informatica jobs.
- Developed *reusable Mapplets* and Transformations.
- Used pmcmd command to schedule sessions and batches.
*Environment: Informatica Power Center 8.6* (Workflow Manager, Workflow
Monitor, Repository Manager), *OWB*, *UNIX*, SYBASE, WindowsXP/2000, TOAD,
SQL server, DB2, *Oracle 10g*, SQL, PL/SQL.
Thanks & Best Regards,
Kumar M.A.
Virgo, Inc || "Technology Leaders"|| 333 N Oxford Valley Road ||
Suite 405 Fairless Hills || PA 19030 || Fax: 215 279 8715 ||
Ph: 215-310-1562 Ext 214||
Email: [email protected] <[email protected]>||
Web: www.virgosystemsinc.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"jobinusa" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/jobinusa?hl=en
-~----------~----~----~----~------~----~------~--~---
