Dear partners,
Please find the below profile/summary of our consultant P Kumar, Do you
have any suitable requirement for this profile pl send me on
mur...@asftonline.com
*SUMMARY*:
· 8 years of experience in designing, developing, maintaining and
building large business applications such as data migration, integration,
conversion, data warehouse and Testing.
- Experience using IBM Web sphere Ascential Data Stage Server/Enterprise
Edition, Quality Stage, Orchestrate/PX designing and developing jobs using
Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage
Administrator and Data Stage Parallel Extender.
· Expert in all phases of Software development life cycle(SDLC) –
Project Analysis, Requirements, Design Documentation, Development, Unit
Testing, User Acceptance Testing, Implementation, Post Implementation
Support and Maintenance.
· Business Requirements review, assessment, gap identification,
defining business process, deliver project roadmap including documentation,
initial source data definition, mapping, detailed ETL development
specifications and operations documentation.
· Expertise in data warehousing, ETL architecture, Data Profiling.
- Expertise in working with *IBM* *Data stage*, Administrator, Manager,
Designer, Director, *Parallel Extender and Quality Stage.*
- Worked on different versions of *Data stage (8.1 8.0 7.5 and 7.2*).
- Strong experience in using various stages like *Transformer,
Aggregator, Sort, Join, Funnel, Lookup* in designer.
- In depth experience in dealing with Data Stage stages (*Hash, ftp,
merge, sort, aggregator, lookup, transformer, filter etc.).***
· Experience in integration of various data sources like SQL
Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
· Strong experience in complex PL/SQL packages, functions, cursors,
triggers, views, materialized views, T-SQL, DTS.
· Expert in troubleshooting/debugging and improving performance at
different stages like database, workflows, mapping.
· Thorough Knowledge of different OLAP’s like DOLAP, MOLAP, ROLAP,
HOLAP.
· Intense Knowledge in designing Fact & Dimension Tables, Physical
& Logical data models using ERWIN 4.0 and Erwin methodologies like Forward
& Reverse Engineering.
· Experience in creating UNIX shell scripts and Perl scripts.
· Knowledge in design and development of Business Intelligence
reports using BI tools Business Objects, Cognos and knowledge in micro
strategy.
· Knowledge in Installation and configuration of Informatica server
with sql server, oracle and able to handle the Informatica administrator
tasks like Configuring DSN, creating Connection Strings, copying & moving
mappings, workflows, creating folders etc.
· Experience includes thorough domain knowledge of Business
Financial system, Banking, healthcare information technology, Insurance &
Reinsure, Pharmacy claims systems, Telecom Industry.
· Enthusiastic and goal-oriented team player possessing excellent
communication, interpersonal skills and leadership capabilities with high
level of adaptability.
*TECHNICAL SKILLS*:
*Data warehousing* Data stage, Informatica Power Center
9.0,8.6/8.5/8.1/7.1/6.2/5.1 for DB2, Metadata Reporter Data Profiling, Data
cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT &
Dimension Tables,
Physical & Logical Data Modeling, Data Stage 7.x, Erwin 4.0
*BI Tools *Business Objects
XIR2/6.0/5.1/5.0, Micro strategy 8, Cognos 8
*Databases* SQL Server 2005/2000/7.0/6.5,
Oracle 11 i/ 10g/9i/8i/8/7.3, Sybase, Teradata 6, My SQL, MS-Access, DB2
8.0/7.0
*Languages* C, C++, XML, SQL, T-SQL, PL/SQL,
UNIX Shell Scripting
*Operating System* HP-UX11/10/9,IBM-AIX4.0/3.1, Sun
Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP
Professional/2000/NT/98/95
*Other Tools * MS Visual Source Safe, PVCS, Auto
sys, Control M, Remedy, Mercury Quality center, Star Team.
*DB Tools: *SQL*Plus, SQL*Loader,
Export/Import, TOAD, SQL Navigator, SQL Trace
*P Kumar*
*mur...@asftonline.com*
*Curr. Loc: NJ*
*Reloc: NY,NJ,CT,MD,PA*
*$ 65/Hr*
*248-747-7907*
* *
--
You received this message because you are subscribed to the Google Groups
"US_IT.Groups" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to us_itgroups+unsubscr...@googlegroups.com.
To post to this group, send email to us_itgroups@googlegroups.com.
Visit this group at http://groups.google.com/group/us_itgroups.
For more options, visit https://groups.google.com/groups/opt_out.
