SUMMARY:	Around 13 plus years of hands on IT industry experience in the most
competitive and thriving environments in USA and India.	
•	Expertise in ETL Tools – Informatica (7.1.2,6.x) (Powermart, Power Center,
Server Manager and Workflow Manager) and DTS  (SQLServer 7.0/2000)(DTS Designer,
DTS Import/Export, DTS Object Model)
•	Extensive knowledge in the development of Stored Procedures, Functions &
Oracle Packages, Triggers using Oracle PL/SQL, Oracle 10G, 9i/8i/8.0/7.3, SQL
SERVER 2000, T-SQL. TOAD 8.1.6 as Front-end tool.
•	Extensive knowledge in developing batch programs using SQL*LOADER, DTS and 
Unix SHELL Scripts.
•	Acquainted in Abinitio ETL tool. Ab Initio (GDE 1.7.0.9, Co-Operating System
2.7.3)
•	DTS (Creating DTS, Active-x Scripts, Scheduling and Monitoring)
•	Hands on experience in UNIX shell scripting(scripts,crontab,awk,sed,grep) for
Job Scheduling, SQL Script execution.
•	Developing, executing and trouble shooting Autosys jobs.
•	Extensive experience writing Unix Shell Scripts for data processing, data
loading and scheduling jobs. Worked on HPUnix, AIX UNIX, Solaris and SCO
Unixware.
•	Documented Design Documents for ETL Mappings, Business Rules/Transformation
and conducted Design reviews with peers. Documenting ETL coding standards,
mappings to extract data from different sources to targets. Documentation of
Implementation Plan to migrate data from Development to Test to Production
Environment. Documentation of ETL mapping for Fianance/Accounting Related Source
and Target Tables. Documentation of Unit and System Test cases, Test Labs, Test
Plans and tracking defects using Mercury Test Director.
•	Strong in Data warehousing concepts using Normalized Multi-dimensional Star
Schema and Snowflakes methodologies. Worked on Ralph Kimball's & Bill Inmon’s
Methodology.
•	Experience in architecture, database modeling, analysis, design, development,
and data conversion.
•	Extensive experience in implementation of Data Cleanup procedures,
transformations, Scripts, Triggers, Stored Procedures and execution of test plans
for loading the data successfully into the targets. 
•	Technically proficient in Identifying and Resolving performance bottlenecks in
various levels like sources, targets, mappings and sessions.
•	Comprehensive working knowledge of Client/Server Architecture.
•	Proven ability to effectively manage time and resources and prioritize tasks
in order to consistently complete projects according to specifications and on
time.
•	Responsible for interacting with business partners to identify information
needs and business requirements.
•	Strong analytical and conceptual skills in database design and development
using Oracle, DB2 V8.0, MS SQL Server and MS Access. Proven expertise in ASP,
VB.NET, IIS, JavaScript and ASP. 
•	Creative problem solving capabilities, analytical approach and exceptional
technical writing skills.
•	Trained on Cognos EPSeries 7.0 & Business Object 5.1
•	Strong working experience in the Requirements Analysis, Data Analysis, Design,
Implementation, Testing of Data warehouses, ODS and Business Data marts 
•	Acquainted in Informatica 8.x features and architecture.

	
TECHNICAL SKILLS
Data Warehousing: Metadata, Datamart, Data cleansing, Erwin, OLAP, OLTP,
SQL*Plus, SQL*Loader, Informatica PowerCenter 7.1.2/6.1, Informatica PowerMart
6.x (Source Analyzer, warehousing designer, Mapping Designer, Mapplets,
Transformations). Acquainted in Abinitio ETL tool. Ab Initio (GDE 1.7.0.9,
Co-Operating System   2.7.3), SQLServer DTS 7.0/2000.                            
        
Business Intelligence: Trained in Business Objects 5.1.x (Designer, Supervisor,
Reporter & WEBI), Cognos 
7.0/6.0/5.x (Impromptu, Power Play, Transformer), Seagate Crystal Reports.     

Data Modeling: ERwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema
Modeling, Snow-Flake Modeling, 
FACT and Dimensions Tables, Physical and Logical Data Modeling
Data Bases: Oracle 10G, 9i/8i/8.0/7.3, DB2/AIX64 8.2.0,MS SQL Server 6.5/7.0,
2000, MS Access 7.0 / 97 / 2000,Sybase, TOAD 7.5,TOAD 8.1.6
Testing Tools: Mercury Test Directory 8.0
Job Scheduling: Autosys, for scheduling Informatica Workflows,Maestro.
Version Control: PVCS
Languages: SQL, PL/SQL, Transact SQL, UNIX Shell Scripting, Familiar with
Perl,VBScript, JavaScript, HTML, XML
Operating Systems: HP-UX, SCO-Unix, IBMAIX4.3/4.2,Solaris, Win NT/2000/98/95,
DOS.                              
Acquainted in Abinitio, MFS (Multifile System), Sandbox for Version Control and
Used Data Parallelism and Data Partition Components and Configured .cfg files for
Database Connectivity (Oracle and SQLServer.)