SUMMARY

• 10+ years of IT experience in software development, designing and implementing with major focus on data warehousing and database applications.
• 8 Years of experience in using of SQL.
• 6+ years of experience with Database relational models, stored procedures, and views.
• 6 years of strong data warehousing experience using ETL tool Ab initio.
• 4 Years of experience in Korn shell script program.
• 3+ Years of proven experience in data modeling, data management, data warehousing, data transformation, metadata and reference data management and Erwin tools
• 3 +Years of experience in designing, developing, implementing and maintaining applications in risk management, fraud control and online bill payment.
• 3+ Years of experience in using of Teradata,DB2.
• 2 +Years of experience in using of BRE (Business rules Engine)
• 2 + Years of experience in using of Auto Sys scheduler tool.
• 1 + Years of experience in Ab Initio Application Support.
• 1 Year of strong data warehousing experience using ETL tool Informatica.
• Experience working with various Heterogeneous Source Systems like Oracle, SQL Server, Teradata, DB2 UDB and Flat files.
• Experience in coding SQL, PL/SQL, T - SQL. Good knowledge in working with Relational database utilities like TOAD, SQL Assistant, SQL Loader.
• Experience in Product migration and Release management Process.
• Worked with continuous components and XML components in Ab Initio.
• Strong Knowledge with Batch Jobs atomization tools Autosys, Maestro.
• Knowledge in EME Check - in and check - outs and Sand-Box Creation.
• Worked with using EME for Version control, Impact analysis, Dependence analysis for Common projects, higher environment migrations.
• Vivid experience in using Korn Shell Scripting to maximize Ab-Initio parallelism capabilities and developed numerous Ab-Initio Graphs using Data Parallelism and Multi File System (MFS) techniques.
• Experience in design, development, and test applications using Ab Initio Software.
• Sound Knowledge in data warehouse concepts, STAR Schema, SNOW FLAKE Schema designs and dimensional modeling.

TECHNICAL SKILLS

Operating Systems: DOS, UNIX, Windows 95/98/2000, NT 4.0, XP

Database Management Systems: Oracle8i/9i,SQLServer2000,2005,MS Access,DB2,Teradata

Programming Languages: C, C++, Java Script, PL/SQL

GUI and Web Technologies: Visual Basic 5.0,6.0, VB.NET and HTML, XML,Crystal Reports 11.0,9.0

ETL Tools: INFORMATICA,5i,AbInitio 1.13,1.14,1.15.6Co>OpSystem 2.13,2.14,2.15.6,Conduct>It

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Ab initio Support/Developer

Responsibilities:

• Developed high level and low level design document for processing each Fund Extracts and documenting the various implementation done during the branch of the Confidential application.
• Developed ETL Data Flow process for Confidential Project by using Microsoft Visual studio.
• Involved in source to target data field mapping discussions, Production support,ab initio support, .
• Developed various graphs which include Extracts, Packages, and Schedule for executing one of query based on period and loading it into the Funds database.
• Used different Ab-Initio components like Subscribe, Batch Subscribe, Publish, Multi publish, Continuous update table, Read XML, Write XML, partition by key and sort, dedup, rollup, scan, reformat, join and fuse in various graphs.
• Also used components like trash, run program and run sql components to run UNIX and SQL commands in Ab Initio.
• Involved in writing SQL queries to migrate a Extracts from DEV to UAT.
• Involved in writing SQL - Join queries to need to know funds loaded or not into database.
• Written several UNIX control scripts, specific to application in order to pass the environment variables.
• Responsible for exctract a data(daily, weekly, monthly) from database and to maintain a historical data in Database for BI Reports
• Phasing and comute points were used in the graphs to avoid deadlock, control the subscribers messages and commit changes to the database at every compute point.
• Various ab initio commands such as m ls, m cp, m mv, m db, m touch were used extensively to operate with multifiles.
• Involved in project migration from development to UAT using Hermes Package.
• Involved inProduction implementationbest practices.
• Used different EME Air commands in project promotion like air tag create, air save, air load, air project export etc
• Writing a JIL program to run a jobs automatically through Autosys.

Environment: Ab Initio GDE 1.15, 1.16 Co>operating system 3.0, Unix, Db2,Oracle,SQLServer, QTODBC,SQLDBX, Putty, SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Shell Scripts, XML, XSD, Autosys

Confidential, Atlanta, GA

Sr. Ab Initio developer

Responsibilities:

• Developed high level and low level design document for processing each feed and documenting the various implementation done during the course of the Project.
• Developed ETL Data Flow process for Confidential Project by using Microsoft Visio.
• Involved in source to target mapping discussions.Participating in various data cleansing and data quality exercises.
• Developed various graphs which include extracting various XML files and loading it into the database.
• Phasing and check pointing were used in the graphs to avoid deadlock and recover completed stages of the graph, in case of a failure.
• Various ab initio commands such as m ls, m cp, m mv, m db, m touch were used extensively to operate with multifiles.
• Performed data cleansing and data validation by using various ab initio functions like is valid, is defined, is error, is null, string trim etc.
• Involved in code reviews, performance tuning strategies at ab initio and Database level.
• Involved in moving applications from AIX to Linux server and modified the shell scripts for that application in order to run on Linux server.
• Involved in Migration of code from DEV to QA and also from QA to PROD by using Heats ( Confidential Utility).
• Created HDDTM ( Confidential ETL process Dynamic Tast Manager) plans, Go Scripts and child plans to run the jobs in sequence.
• Involved in Production support to monitor the jobs and schedules through IBM Maestro 8.5 Tivoli Workload Scheduler.
• Involved in unit testing of the graphs and also prepared test cases document.

Environment: Ab Initio GDE 1.14, Co>operating system 2.14, Teradata, Unix, Db2,Oracle,SQL Server, Teradata Sql Assistant, Putty, SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Shell Scripts, XML, XSD, Maestro 8.5.

Confidential, TN

Sr. Ab Initio Developer

Responsibilities:

• Development of source data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Created the mini specs for different applications.
• Involved in review the data Analysis, best practices.
• Developed various Ab-Initio graphs to validate using data profiler, comparing the current data with previous month data.
• Used different Ab-Initio components like partition by key and sort, dedup, rollup, scan, reformat, join and fuse in various graphs.
• Also used components like run program and run sql components to run UNIX and SQL commands in Ab-Initio.
• Written several unix control scripts, specific to application in order to pass the environment variables.
• Responsible for extracting daily text files from ftp server and historical data from DB2 Tables, cleansing the data and applying transformation rules and loading to staging area.
• To insert data into Teradata Data warehouse using utilities, FastLoad MultiLoad, BTEQ Scripts Tools.
• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
• Involved in Design best practices and Coding and documentation best practices.
• Writing the .dbc files for the Development, Testing and Production Environments.
• Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify the functional, data quality, performance of graphs.
• Performing transformations of source data with transform components like join, match sorted, dedup sorted, de-normalize, reformat, filter-by- expression.
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited.
• Written several unix control scripts, specific to application in order to pass the environment variables.
• Development of UNIX Korn shell scripts to automate job runs or Support the redaction infrastructure and SQL and PL/SQL Procedures to load the Data into Database.
• Involved in project promotion from development to UAT and UAT to promotion.
• Involved inProduction implementationbest practices.
• Used different EME Air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: A Initio GDE1.14,Co-Op2.14,UNIX, Oracle 10.x,TOAD, DB2, SQL Server 2005,Windows’ XP, Teradata, Auto Sys

Confidential, Harrison, NY

Ab Initio Developer

Responsibilities:

• Involved as designer and developer for commercial business group data warehouse (CBGDWH).
• Development of source data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Created the minispecs for different applications.
• Making automate the development of Ab initio graphs and functions utilizing the meta data from EME to meet SB data redaction requirements.
• Developed various Ab-Initio graphs to validate using data profiler, comparing the current data with previous month data, applying the AMS standards.
• Involved in AMS installation in dev, testing the AMS and promote to SIT, SIT to UAT and UAT to production.
• Used Different Ab-Initio components like partition by key and sort, dedup, rollup, scan, reformat, join and fuse in various graphs.
• Also used components like run program and run sql components to run UNIX and SQL commands in Ab-Initio.
• Used USPS address mapping system for correcting the customer address.
• Performing transformations of source data with transform components like join, match sorted, dedup sorted, reformat, filter-by- expression.
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited.
• Involved in project promotion from development to UAT and UAT to promotion.
• Involved inProduction implementationbest practices.
• Using modification of the Ab intio EME to house the required redaction Mata data.
• Used different EME air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: Ab Initio GDE1.13, Co-Op2.13, UNIX, Oracle 9i, SQLServer Navigator 5.0,SQL Server2000, Cygwin, AMS Software,Maestro, DB2, Teradata, Windows2000, Crystal Reports 9.0

Confidential, Plano,TX

Ab Initio Developer

Responsibilities:

• Involved with business users to prepare functional specification and technical design documents for ETL process for complete data warehouse cycle for AT&T wireless customer support and sales.
• Developed Jobs and used Ab-Initio as an ETL tool to load the final loads.
• The project is to centralize the reporting system, previously used a hard coded program.
• Developed various Ab-Initio graphs for customer credit, contact, account detail, account XRef, data inserts & updates, data validate graphs, TN inserts & updates, calling plan, network service XRef graphs and refresh graphs.
• Used various Ab-Initio components of partition, de-partition, database, datasets, transform, FTP and sort to build graphs in GDE
• Developed Ab-Initio graphs for data validation using validate components.
• Created Ab-Initio multi file systems (MFS) to take advantage of partition parallelism.
• Developed several stored procedures and functions to make the existing code to be executed and make it more dynamic which is now considered to be the centralized program for the existing running programs and the new EDW project.
• Developed several database triggers to maintain the data integrity.
• Developed and loaded parameters called during the execution of the EDW program for dynamic execution.
• Wrote several SQL* loader programs to load small loads into temporary tables for the data, which may be required to move among different unix servers and databases while the program is running.
• Developed several KShell(Korn-Shell) programs, functions and packages to do the pre - inspection, post - inspection, pre - extraction inspection of the data getting loaded every week and populate errors, which are again used to generate error reports responsible for the automation of Ab-Initio graphs using KShell(korn-shell) scripts.
• Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify the functional, data quality, performance of graphs.
• Documentation of complete graphs and its components.

Environment: AbInitio GDE1.12,Co-Op2.12, UNIX, Oracle 9i, SQLServer Navigator 5.0, DB2, Teradata, Windows2000

Confidential, Columbous, OH

Ab Initio Developer

Responsibilities:

• Extracted data from oracle database and the extracted data are used to populate the data warehouse tables.
• Associated with financial data mart.
• Used Ab-Initio as an ETL tool to pull data from source systems, cleansing, transform and load data into databases.
• Developed transformation logic and business rules for ETL purpose.
• Involved in Ab-Initio graph design and performance tuning to load graph process.
• Convert the date formats from yymmdd to oracle standard date format.
• Used Ab-Initio repository to store the developed graphs, for future dependency analysis when needed.
• Uncompress the source data using the GUNZIP component and translate the data from EBCDIC to ASCII.
• Responsible for creating test cases to make the data originating from the source was making it into target properly in the right format.
• Created Ab-Initio multi file systems(MFS) to take advantage of partition parallelism.
• Implemented a 4-Way multi file system that was composed of the individual files on different nodes that were partitioned and stored in distributed directories.
• Designed and developed Ab Initio graphs, using different components viz. Reformat, rollups, scan, and Join etc. Performed functional testing of graphs.
• Created summary tables using ROLLUP and SCAN components and verified graph accuracy based on business logic.
• Responsible for making sure that data is clean, consistent, and synchronized across platforms.
• Identified ways to speed up current Ab-Initio graphs to maximize performance.
• Automated both monthly and weekly refresh (data load) using the cron utility.
• Created crontab jobs to run the different application at a time.

Environment: Ab Initio GDE1.12, Co-Op 2.12, UNIX, PL/SQL, Oracle 9i, SQL Server7.0, WindowNT

Confidential, San Francisco, CA

Ab Initio Developer

Responsibilities:

• Created Ab-Initio graphs to load large volume of data around several GB to TB.
• Used the Ab-Initio Web Interface to Navigate the EME to view graphs, files and datasets and examine the dependencies among objects.
• Extracted data from Oracle and used them to populate Teradata Data Warehouse tables associated with Data Mart.
• Created Korn Shell scripts and cron jobs to refresh the load on weekly basis.
• Developed complex Ab Initio XFR’s to derive new fields and solve various business requirements.
• Created test scenarios that were used to validate the Ab-Initio graphs.
• Designed and developed complex Ab-Initio graphs using Aggregate, Join, Rollup, Scan, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions. Developed complex graphs in normalizing the 3-D data in the Excel Spread Sheet into 2-D flat file. Later this flat file was in to Oracle Data Marts.
• Created various Ab-Initio Multi File Systems (MFS) to run graphs in parallel.
• Responsible for cleansing the data from source systems using Ab-Initio components such as reformat and filter by expression.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions and tested various graphs for their functionalities.
• Developed several partition based Ab-Initio Graphs for high volume data warehouse.

Environment: Ab Initio GDE1.12, Co-Op 2.12, UNIX, PL/SQL, Oracle 9i, SQL Server7.0, Windowing

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts to translate business requirements into technical specifications and involved in extraction, transformation and loading of data.
• Extracted source data from sybase, flat files, XML, TeraData, oracle, IMS and VSAM and loaded to a relational warehouse.
• Implemented SCD methodology including type 1, type 2 and type 3 changes to keep track of historical data.
• Implemented aggregate, sorter, router, filter, joiner, expression, lookup and update strategy, normalizer, sequence generator transformations.
• Extensively worked on mapping variables, mapping parameters, workflow variables and session parameters.
• Used the workflow manager to create workflows, worklets and tasks.
• Involved, created UNIX shell scripting and automation of ETL processes using crontab
• Used debugger to test the mapping and fixed the bugs.
• Involved in design of logical and physical data models using Erwin designed and developed impromptu distributed catalogs (involving joins, conditions and calculations).
• Created multi-dimensional cubes using power play transformer.
• Performance tuning of queries using ANALYZE tables and SQL Trace.
• Documented informatica mappings, design and validation rules.
• Involved in design of logical and physical data models using Erwin designed and developed impromptu distributed catalogs (involving joins, conditions and calculations). Created multi-dimensional cubes using powerplay transformer.

Environment: Informatics Power Center 5.0, Cognos Impromptu 6.6, Power Play, Transformer 6.6, ERWIN 4.0, Oracle 8i/9i, MS SQL Server 2000, PL/SQL, Toad 7.0, Unix 5.0.5, Windows 2000

Confidential

Developer

Responsibilities:

• Physical Database Design and development, plementation.
• Responsible for creating Database objects like Tables, Cluster/Non-cluster index, Unique/Check Constraints, Stored Procedures, Triggers, Rules, Defaults and Views.
• Responsible for database Backups and Recovery.
• Responsible for Query optimization and Performance tuning.
• Used SQL Server Performance monitor to find out the I/O, CPU issues.
• Monitor NT Event log for system, application errors, CPU & Memory usage Backup registry, keep emergency repair disk as current and server available disk space.
• Extensively worked with BCP to Import & Export data From/To flat files.
• Responsible for SQL Server Standard security implementation, managing SQL Server connections and granting permissions for user(s) and objects.
• Used DBCC to check physical and logical consistency of the database and solved page allocation errors and Table corruption.
• Used Database object Transfer utility to transfer the data and database objects from local to remote server.

Environment: MS SQL Server 7.0, MS ACCESS 97, Visual Basic 6.0, MS Windows 95, Windows NT 4.0. PL/SQL, Toad 7.0, Unix 5.0.5, Windows 2000