SUMMARY

• Over seven years of IT experience in software analysis, design and development for various software applications in client - server environment with over 5 years experience in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems and OLAP application development in Windows and Unix platforms.
• Over Four years of solid experience in theAnalysis, Design and Development of Data warehousing solutions and in developing strategies forExtraction, Transformation and Loading (ETL)mechanism usingAb Initio.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution usingAb Initio/Informatica Power center 6.2/6.1/5.1.
• Highly experienced in ETL tool Ab Initio in using GDE Designer. Very good working experience with all the Ab Initiocomponents.
• Expertise and well versed with variousAb Initio Transform, Partition, Departition, Dataset and Database components.
• Experience withAb InitioCo-Operating System, application tuning, and debugging strategies.
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Very good experience withSQL Server & Oracle Databases.
• Involved in implementation of Business Intelligence Applications usingCognos and Business Objects, building Data Marts and enterprise wide Data Warehousing.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files.
• Experience in developing Entity-Relationship diagrams, Logical and Physical Data Models, and the use of Data modeling tools.
• Excellentanalytical & problem solving and business interaction skills.
• Excellent Written and verbal communication skills.

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica Power center, Power mart.

OS: Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x.

Databases: Oracle 10g/9i/8.x, MS SQL Server.

Languages: C, C++, Java, XML, Visual Basic 6.0/5.0, SQL, PL/SQL, Transact-SQL and Perl.

OLAP/Tools: Cognos (Impromptu, Power Play), Business objects, Micro Strategy, Oracle Reports.

Packages: SQL* PLUS, Toad 7.x, SQL Loader, Erwin 4.0, MS Visio 2002.

Scripting: UNIX Shell (Ksh/Csh).

PROFESSIONAL EXPERIENCE

Confidential, NY

Abinitio Developer

Responsibilities:

• Extensive usage of Multifile system where data is partitioned into four partitions for Parallel processing.
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Responsible for cleansing the data from source systems usingAb Initio componentssuch as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter - by-Expression, Rollup
• Worked with Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifiles accordingly.
• Worked with Partition Components like Partition-by-key, Partition-by-expression Partition-by-Round Robin to partition the data from serial file.
• Used Toad to verify the counts and results of the graphs.
• Involved in System and Integration testing of the project.
• Wrote several Shell scripts, to remove old files and move raw logs to the archives.
• Tuning of Ab Initio graphs for better performance.
• Process and Transform delta feeds of customer data, which comes in daily.
• Developed dynamic graphs to load data from data sources into tables and to parse records.

Environment: Ab Initio (Co.Op 2.15, GDE 1.15.9.2), UNIX, EME, Teradata TOAD, CONTROL-M and Windows

Confidential, Philadelphia, PA

Abinitio Developer

Responsibilities:

• Acting as an Abinitio developer at client place taking care of development, testing and implementation phase.
• Creating mappings using Abinitio ACE tool as front end and using Frame work developed in Abinitio GDE at the back end.
• Design data model for target tables in the data mart (Facts and Dimensions. Currently using STAR schema model).
• Constant communications with business and Business Analysts to develop mappings for loading data from MCAD i-series system to DM Netezza system.
• Writing queries for testing source (Db2) to target (Netezza) data.
• Creation of Job definitions using OpConsole scheduler and automating the loads.
• Monitoring and Supporting the Production box for all ACE frame work related projects.
• Performing enhancements to the frame work in the back end, in case if any issues are identified.
• Handling Admin related acitvities, like creating projects, creating db projects, providing EME access to individuals e.t.c.

Environment: Abinitio 3.1.5, Abinitio ACE Tool, DB2 System I Navigator, Netezza and OpConsole.

Confidential

Responsibilities:

• Involved in design, development and testing ofAb Initiographs for formulary management system.
• Translating the logical data model to a physical database design, database construction, design optimization and functional testing.
• Performed Reverse engineering on existing graphs and stored procedures to know their present functionality and in turn to know where specific enhancements are to be applied.
• ImplementedData Parallelismthrough graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initiopartition componentsto segment data.
• Developed parameterized graphs usingformal parameters.
• Developed Ab Initio graphs tounloadrequired data from database.
• Developed Ab Initio graphto load data intofact tablesandupdatedimensionaltables.
• Used various component ofAb Initio graphslike‘Partition By Key’, ’Sort’, ’Reformat’, ‘Join’, ‘De-Dup’etc. to impose business logic on the incoming data for loading and maintainingDimensional tables(insert/update), such that the history of the records could be retained, for recurring loads.
• Was involved in designing, writing packages, stored procedures, cursors, functions, etc.
• Designed documents for the enhancements, which are applied as part of phase 5 of the project.

Environment: Ab Initio GDE 1.3, Co op 2.13,Oracle8i, PL/SQL, Microsoft SQL Server, UNIX TOAD 7.5, Windows XP, Business objects.

Confidential

Junior Abinitio Developer

Responsibilities:

• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed PL/SQL Business Functions for Web Users For Flexible Querying.
• Developed Mappings for the Category, Specification, Code, and Type areas.
• Involved in design, developing and testing the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract /Transform/Load data).
• Involved in quality assurance of data, automation of processes, programming for data manipulation and graphics, validation of programming, and presentation of results.
• Provided data modeling services for a large data warehouse design.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.
• Involved in fixing repository related, Reader process and External procedure problems.
• Involved in loading data to staging area and into Warehouse tables using SQL Loader.

Environment: Informatica 5.1, Oracle 7.x/8, DB2 UDB, SQL, PL/SQL, SQL Server (7.0), TOAD, Erwin 3.5, Sun Solaris and Windows NT.