SUMMARY:

• 5 years of overall experience in the field of Information Technology with focus on Development, Implementation and support in different projects including Data Warehousing and Database Applications. Over 2.5 years of ETL expertise with excellent exposure to Ab Initio in high volume, parallel processing data environments.
• Has good experience in extensively used ETL methodologies for supporting data extraction, transformations and loading processes using Ab Initio. A goal oriented, well disciplined, client focused and team player with good leadership and excellent interpersonal/ communication skills.
• Good experience in Developing, deployment, delivery activities & Supporting Ab Initio ETL applications & used most of the GDE components in Ab Initio and well versed with the Data Warehousing concepts.
• Strong experience in Relational Databases like Oracle, SQL Server.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling and Configuration Management.
• Experienced with various Ab Initio parallelisms and partitioning techniques and implemented number of Ab Initio Graphs using Data parallelism and Multi file system (MFS) techniques.
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Good exposure to SQL, PL/SQL stored procedures, Triggers and Packages.
• Expertise and well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components.
• Experience with various Ab Initio components such as Join, Rollup, Concat, Gather, Interleave, Dedup Sorted, Merge, Scan, Partition, Validate, FTP etc.
• Very good experience with SQL Server & Oracle Databases.
• 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.
• Good working knowledge writing UNIX Shell scripts, SQL and PL/SQL queries for ETL process.
• Good knowledge and learning about AIR commands.
• Extensively used Ab Initio EME data store/sandbox for version control, code promotion, and impact analysis.
• Self - motivated, creative Good problem solving and analytic skills to resolve the problem and finding the root cause efficiently on time.

TECHNICAL SKILLS:

Operating System: Windows Server 2000/2003/2008, Red Hat Linux, Unix

ETL Tools: Ab Initio, SSIS

Database System: SQL Server 7/2000/2005/2008/2008R2, MySql, Oracle

Language/Scripting: C, C++, JavaScript, VB script, PHP, UNIX Shell Scripting

Data Warehousing: OLTP, OLAP, Normalization, Facts, Dimensions, Snow Flake Schema, Star Schema, SSIS

Web Concepts: Ajax, JQuery,XML, HTML/DHTML,CSS,MVC,Symfony

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Ab Initio Developer

Responsibilities:

• Extensively used Ab-Initio ETL tool in designing & implementing Extract Transformation & Load processes. Different Ab Initio components were used effectively to develop and maintain the database.
• Understanding and analyzing the Data Model and Technical Specifications document.
• Understood the business requirements with extensive interaction with users and reporting teams and assisted in developing the low level design documents.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like checking and checkout were used for this purpose.
• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for automating the ETL process through scheduling.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup (instead of joins), In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Extensively worked with Multi files system and used Partition Components and Departition components.
• Used Debuggers and Watchers to test and examine the behavior of the components.
• Code, test, modify, debug, document, and implement Ab Initio Graphs utilizing the GDE environment and EME.

Environment: Ab Initio 3.0.1, UNIX Shell Scripting, UNIX, Windows XP, SQL server 2008/2008R2,Oracle10G, Autosys

Confidential, Natick, MA

Ab Initio Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Developed graphs to unload data into tables and validate the new data in comparison with already existing data.
• Worked with Partition components like Partition-by-Key, Partition-by- Expression, Partition-by-Round robin to Partition the data from Serial File, using Multi file system.
• Worked with Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifiles accordingly.
• Performed transformations of source data with Transform Components like Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup.
• Experienced in using EME (Check-in, Check-out, Version Control).
• Involved in solving Testing issues and review Test cases.

Environment: Ab Initio 3.0.1, UNIX Shell Scripting, UNIX, Windows XP, Oracle 10g, SQL Server 2008R2

Confidential

SQL Server DBA

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Involved in creating and maintaining database objects such as indexes, views, stored procedures, and user defined functions in T-SQL.

Environment: MS SQL Server 2000/2005 (32 bit & 64bit, MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), T-SQL