Technical Skills Summary

• 6 years of extensive experience in Information Technology
• 6 years of extensive experience in Software Design and Development Life Cycle Model
• 4+ years of extensive experience in Data Warehousing Concepts – Component, Data, Pipeline Parallelism, Data Integration etc
• 4+ years of extensive experience in Ab-Initio Data Warehousing ETL Tool
• 4+ years of extensive experience in Ab-Initio GDE 1.15, 1.14, 1.13
• 4+ years of extensive experience in Co>Operating System 2.14, 2.15
• 4+ years of experience in Batch Data Processing Structure
• 4+ years of extensive experience in Enterprise Meta Environment EME
• 4+ years of extensive experience in Ab-Initio project related deployments
• 4+ years of experience in Korn Shell Scripting
• 4+ years of extensive experience in Bath Data Job Scheduler Tool - Autosys
• 4+ years of experience in UNIX, LINUX, AIX technologies
• Experience in Mainframe Technologies
• Experience in Alebra - Mainframe/Open Systems Data Transfer Tool
• Experience in DEG
• Experience in ClearCase Source Control Tool
• Experience in ClearQuest
• Experience in programming languages C, C++, JAVA, C#, PERL
• Experience in SQL, PL/SQL, .NET framework
• Experience in databases - MS Access, MS SQL Server, Oracle
• Team leading skills, Multi-tasking skills
• Production application support skills, Troubleshooting and Problem solving skills

IT Experience Profile

• Around 6 years of experience in the Information Technology industry, extensively in Financial and Retail Industry
• Involved in several successful critical projects spanning financial, retail and medical domains
• Proven track record of delivering small to large-scale, mission-critical projects using Data warehousing technologies and skills to solve critical business problems and delivering the projects effectively on time
• Extensive experience in designing, implementing, delivering, maintaining and supporting small scale to large scale projects
• Experience in delegating and managing off-shore team
• Worked as Senior ETL Developer at Confidential, Chicago, Illinois (June 2008 – Oct 2012) in Enterprise Data Hub
• Worked as C# Developer at Confidential, Lisle, Illinois (January 2008 – May 2008)
• Worked as JAVA developer in several university related research projects while pursuing Masters in Computer Science from Confidential University
• Worked as C++, JAVA Developer (January 2002 – July 2002)
• Technical Experience at TransUnion June 2008 – October 2012

Customer: Confidential 
Company: Confidential
Project Name: CIA/ADE 
Type of Delivery: Quarterly

Description:
ConfidentialCIA/ADE Data Mart is an application which delivers potentially identified new subjects with Discover as subscribing code and with complex rules. It also delivers the identified subject’s trade, inquiry, public record information and other common information to the customer. This application is scheduled to run every quarter of the year. 
I had worked with huge volume of data in this application for example I had dealt with approximately 150 million records for trade reports for each delivery. 
Responsibilities:

• Designed and implemented pre-processing Ab-Initio header graph to identify potential subjects based on complex rules and technical requirements.
• Designed, implemented and unit tested the main engine using a series of Ab-Initio graphs which delivers the identified subject’s trade, inquiry and public record information.
• Implemented Korn Shell scripts for post processing i.e. cleanups etc
• Published the output files to Mainframe using Alebra transfer tool.
• Graphs involved following Ab-Initio components: Input file, Lookup file, Reformat, JOIN, Output file, Replicate, Subgraphs, Sort, Gather, Partition by expression etc
• Implemented Autosys JILs to run the jobs in batch.
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for subsequent runs of every quarter of the year.

Customer: Confidential 
Company: Confidential
Project Name: Student and Personal Loans 
Type of Delivery: Quarterly

Description:
Confidential Personal and Student Loans extract is an application which delivers the customer with subjects who have taken Student and Personal Loans based on specified rules. It also delivers the customer with pre-defined Peers of Discover for example Bank of America, Wells Fargo, USBANK etc. This application is scheduled to run every quarter of the year. 
Responsibilities:

• Designed and implemented series of Ab-Initio graphs to identify subjects based on technical requirements.
• Designed and implemented the Peer identification graphs and post processing graphs.
• Published the files to Mainframe using Alebra transfer tool.
• Graphs involved following Ab-Initio components: Input file, Lookup file, Reformat, JOIN, Output file, Replicate, Subgraphs, Sort, Gather, Merge, Custom Components, Partition by expression etc
• Implemented Autosys JILs to run the jobs in batch.
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for subsequent runs of every quarter of the year.

Customer: Confidential 
Company: Confidential
Project Name: Premium Fraud Alert and IDMV 
Type of Delivery: ADHOC/On Demand

Description: 
Confidential Premium Fraud Alert is an application which identifies and delivers the subjects who are involved in any Fraud related activities within last one year. 
Responsibilities:

• Designed and implemented series of Ab-Initio graphs to identify fraud related subjects based on technical requirements.
• Graphs involved following Ab-Initio components: Input file, Lookup file, Reformat, JOIN, Output file, Replicate, Inflate, Sort, Merge, Partition by expression etc
• Implemented Autosys JILs to run the jobs in batch.
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for subsequent runs of the year.
  

Customer: Confidential 
Company: Confidential
Project Name: Medical Collections Extract
Type of Delivery: Quarterly

Description:
ConfidentialExtract is an application which identifies and delivers the subjects whose accounts are tagged as collection accounts. 
I had worked with large volume of data for example I had dealt with approximately 10 Giga Bytes of data for these extracts. 
Responsibilities:

• Designed and implemented Ab-Initio graphs to identify subjects with medical collections.
• Graphs involved following Ab-Initio components: Input file, Reformat, Filter by Expression, Output file, Sort, Merge etc
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for subsequent runs of every quarter of the year.
  

Company: Confidential 
Project Name: G2 Depersonalization
Type of Delivery: Yearly

Description:
Confidential is a complex process used to scramble and shuffle subject’s indicative data. Data created using this process was used in all demos to customers to get a look and feel of the real-time information.
Responsibilities:

• Designed and implemented complex series of Ab-Initio graphs to apply shuffle and scrambling rules on the subjects in order to simulate real-time process.
• Graphs involved following Ab-Initio components: Generate Records, Input file, Reformat, Filter by Expression, Output file, Sort, Gather, Merge, JOIN, Redefined Format, Partition by round robin, Partition by expression etc
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for subsequent runs of the year.
  

Customer: Confidential 
Company: Confidential
Project Name: GGDD Request Interface 
Type of Delivery: ADHOC/On Demand

Description:
Confidential Interface is a generic application which delivers customers with the requested data like subject’s indicative data, their trade and trade history information etc.
I had worked with huge volume of data for example I had dealt with approximately three Tera Bytes of data for trade history reports for these extracts. 
Responsibilities:

• Designed and implemented command line interface using Korn Shell script for processing a request received through a spreadsheet and converting it into a control file used for extracts.
• Designed and implemented series of Ab-Initio graphs to extract the requested information Trade, Trade Activity, Trade History, Inquiries etc.
• Designed and implemented post processing Korn Shell scripts to schedule and cleanup Autosys jobs to run in batch.
• Graphs involved following Ab-Initio components: Input file, Lookup file, Reformat, Filter by Expression, Output file, Sort, Gather, Merge, JOIN, Redefined Format, Partition by round robin, Partition by expression etc
• Documented the flow process and instructions for maintaining the project and transitioned it to the application support team for any subsequent deliveries.

Company: Confidential 
Project Name: Generic Data Loader 
Type of Delivery: Hourly

Description:
Confidentialis a generic tool which transforms and loads any kind of flat files or tables to any kind of database tables like Sybase IQ, Oracle etc. 
Responsibilities:

• Designed and implemented pre-processing Ab-Initio graphs to cleanse the input files.
• Designed and implemented main Ab-Initio graph to read flat files (Alebra logs, System Logs, Automated Logs, Daily Logs) or tables (Oracle, Sybase), to reformat and to load them to any Database tables.
• Designed and implemented post processing Korn Shell scripts to send emails after successful load of logs.
• Graphs involved following Ab-Initio components: Input file, Reformat, Filter by Expression, Output file, Input Table, JOIN WITH DB, Output Table etc

Technical Experience at Confidential January 2008 – May 2008

Worked as C# Developer at SAIC, Lisle, Illinois

Technical Experience in Confidential January 2002 – July 2002

Worked as JAVA Developer at VISU Consultants Ltd, India

Education

• Masters in Computer Science from Confidential University
• Bachelor of Engineering in Computer Science from Confidential University