PROFESSIONAL SUMMARY:

• 8 years of experience in IT industry in various aspects of software life cycle and extensive experience in Data warehousing, which includes Designing, Development, Implementation and testing of large data warehouse projects.
• 5 years of experience in Ab Initio.
• Strong experience of using Ab Initio tool in developing strategies for ETL (Extraction, Transformation and Loading) mechanism in complex and high volume Data Warehousing projects.
• Strong development skills include ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, support and documentation of the complete project.
• Extensive work experience in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on Unix environment, Proficient with various Ab Initio Parallelism, Transformation and Multi File System techniques, ACE and M - HUB.
• Strong work experience in using ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in UNIX Shell Scripts including Korn Shell Scripts.
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Expertise with most of the Ab Initio components like Database, Datasets, Partition, De-partition, Sort and Transform components.
• Experienced in working with xml files and queues.
• Experienced in designing scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, making use of Ab Initio suite.
• Experience in various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and MFS techniques.
• Experience in designing and implementing Ab Initio EME Metadata projects.
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies Proficient with various AB INITIO Parallelism and Multi File System technique.
• Extensive experience in using Ab Initio EME data store/sandbox for version control, code promotion, and impact analysis.
• Hands on experience with large scale data warehouse instance. Worked with deploying CPU heavy ETL process and tuning the complex Ab Initio process.
• Experienced in working with testing team and developed Unit test plan, test cases for component, data, stress test, regression test etc.
• Immense experience working with RDBMS such as MS SQL Server and other non-relational data sources such as flat files and XML files.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Ability to quickly grasp new concepts and apply software methodologies as per business needs.
• Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

ETL TOOLS: Ab Initio (GDE 3.1.5, Co>Operating System 3.1.x)

RDBMS: Oracle 11i,10g,9i/8i/8/7.x, MS Access, MS SQL Server, Teradata

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Database Tools: SQL *Plus, TOAD

Operating Systems: Windows 2000/XP/Vista/7, UNIX, Sun Solaris, Red hat Enterprise Linux

PROFESSIONAL SUMMARY:

Confidential, Dallas, TX

Ab Initio Developer

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Involved in development of Ab Initio graphs for loading and extracting data from various schemas relating to oracle database.
• Responsible for developing Ab-Initio ETL processes for Client, Dimensions and Fact table loading.
• Responsible for creating a Multi file system that is composed of individual files on that are partitioned and stored in distributed directories.
• Used UNIX environment variables in all the Ab Initio Graphs, which comprises of specified locations of the files to be used as source and target.
• Debugged and modified shell scripts using vi editor in UNIX environment in determining various graph paths and run file path for job request engine.
• Involved in testing and debugging the local and global graphs for the final load by comparing old and new global parameterized graphs for each sector specified and writing test cases reports for each job request for the job request engine.
• Parameterized and sectorized the graphs from local to global parameters for various job request loads.
• Extensively used Ab Initio components like Reformat, Redefine Format, Rollup, Scan, Input Table, Output Table, Partition By Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup, Replicate, Join,Xml combine.
• Implemented the Parallel application by replicating the components and processing modules into number of partitions.
• Involved in producing XML files and loading them into queues.
• Involved in the building and migration process.
• Involved in created psets for graphs using ACE, used Metadata hub.
• Designed and deployed well-tuned Ab Initio graphs (Generic and Custom) for ODS and DSS instances and created Sub-Graphs for code reusability in both windows and UNIX (K-shell Scripting) environments.
• Used EME data store to check in and checkout the graphs. EME also helps holding the changes by creating new version of the graph/s.
• Produced the required documents like Mapping Documents, Design Documents and Use Case Documents.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process
• Developed and automated control validations for the ETL process to appropriately tie the source and target data.

Environment: Ab Initio GDE 3.1.5,Co-operating System 3.1.x, Ab Initio EME, Oracle, Teradata, UNIX (K-shell), Shell Scripting.

Confidential, CA

Ab Initio Developer

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Involved in development of Ab Initio graphs for loading and extracting data from various schemas relating to Sybase database.
• Involved in creating sandbox in Ab Initio through GDE and as well running the shell script.
• Designed a graph for maintaining the history of data with retaining the surrogate key using Assign Key component.
• Used UNIX environment variables in all the Ab Initio Graphs, which comprises of specified locations of the files to be used as source and target.
• Debugged and modified shell scripts using vi editor in UNIX environment in determining various graph paths and run file path for job request engine.
• Extensively used Ab Initio components like Reformat, Redefine Format, Rollup, Scan, Input Table, Output Table, Partition By Expression, Partition by Key and Sort, Merge, Concatenate, Gather, Dedup, Replicate, Join.
• Implemented the Parallel application by replicating the components and processing modules into number of partitions
• Involved in the building and migration process
• Extensive experience using EME data store to check in and checkout the graphs. EME also helps holding the changes by creating new version of the graph/s.
• Produced the required documents like Migration Documents, Design Documents, Use Case Documents.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process
• Responsible for developing Ab-Initio ETL processes for Client, Dimensions and Fact table loading

Environment: Ab-Initio (GDE 1.14, Co>Op 2.14), DB2, TOAD V7.5, Teradata V2R5, SQL, HP-UNIX 11.0, ErwinAutosys, SQL, AQT(Advanced Query Tool),TOAD,SQL*Loader.

Confidential, Chicago, IL

Ab Initio Developer

Responsibilities:

• Involved in creating the Physical models from business requirements.
• Developed graphs separating the Extraction, Transformation and Load process to improve the efficiency of the system.
• Involved in designing Load graphs using Ab Initio and tuned the performance of the queries to make the load process run faster.
• Implemented SOX controls in various levels of SDLC to make the project compliant.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Reformat and Dedup.
• Implemented Lookups, lookup local, In-Memory Joins to speed up various Ab Initio Graphs.
• Extensively used Enterprise Meta Environment (EME) for version control.
• Involved in unit testing and assisted in system testing, integrated testing, and user acceptance testing.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
• Created Requirements, High level Design, Detail Design, Unit Test Cases documents following prescribed Fannie Mae standards.
• Utilized the FCS tool to build Ab Initio code.
• Designed and build Ab Initio generic graphs for unloading data from source systems. Validated the unloading process with the row count of the landed file with that of the source table row count.
• Incorporated Exception Handling in the graphs to keep track of anomalies in the incoming data and raise an alarm in such situation.
• Wrote script wrappers, using PERL, to call Ab Initio applications.
• Designed Ab-Initio graphs using GDE Conditional components.
• Developed shell scripts for Archiving, Data Loading procedures and Validation.
• Used Test Director to keep track of bugs.

Environment: Ab Initio CO>op 2.14, Ab Initio GDE 1.14, Trillium 6.0, TOAD, SQL, PL/SQL, UNIX Sun Solaris, Oracle 9i/8i, Teradata v2r5, Business Objects 5.1.7, Sun OS 5.10, perl, UNIX and Windows 2000

Confidential, Atlanta, GA

Ab Initio Developer

Responsibilities:

• Implemented Ab Initio configuration and set up well-tuned environments for Production, Development and Testing.
• Constructed an ETL system using the Ab Initio tool providing a fast development in a unified environment that will allow for easy maintenance of the system for the future.
• Created checkpoints, phases to avoid dead locks and tested the graphs with some sample data then committed the graphs and related files into Repository from sandbox environment.
• Schedule the graphs using Job Scheduler and loaded the data into target tables from staging area by using SQL Loader.
• Involved in creating the Generic graph for pulling the Data from the mainframe data files using the FTP component.
• Modified the Ab Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Responsible for creating the (MFS) Multi-file, which gives the user the ability to centrally control the distributed data files and they provide the scalability and the kinds of access patterns that parallel applications require.
• Used Ab Initio Components like Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc.
• Responsible for analyzing the source data and reporting data quality levels using Ab-Initio as an OLAP tool.
• Extensively worked with UNIX environment and created lots of UNIX process through the shell scripts and worked closely with UNIX administrator for any performance tuning.
• Performed development and test extraction, transformed and loaded (ETL) processes packaged as part of a large data warehouse application using Ab Initio, PL/SQL and Unix Scripts.
• Utilized the EME for version control, and tracking of changes made to new and old graphs.
• Responsible for interpreting the transformation rules for all target data objects and develop the software components to support the transformation. Coded and tested complex Ab Initio ETL routines.
• Worked on parallel processing methodologies, scalable architecture, appropriate use of Multi-File Systems, Ab Initio environment administration and performance efficiency techniques.
• Used Check in/Check out for the EME version control system.

Environment: Ab Initio CO>op 2.13, Ab Initio GDE 1.13, Trillium 6.0, TOAD, UNIX Sun Solaris, Oracle, Business Objects 5.1.7, Sun OS 5.10, perl, UNIX.

Confidential

SQL Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Involved in Planning, designing, and implementing application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL.
• Wrote complex T-SQL queries and stored procedures for Online Trading Application of Sharekhan.
• Created new tables, views, indexes and user defined functions.
• Closely worked with Sr. DBA and Sr. Developers to fasten certain daily jobs and stored procedures.
• Involved in performance tuning of T-SQL queries and worked with nested stored procedures.
• Created joins and sub-queries for complex queries involving multiple tables and fields.
• Developed new processes to facilitate import and normalization, including data file for counterparties.
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Worked on development on various reports and fact sheets using SQL Reporting services.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Prepared user manual and technical support manual.

Environment: Windows 2000 Server, MS SQL Server 2000, SQL, T-SQL, SQL Query Analyzer, MS Office, VB.