SUMMARY:

• Senior ETL Designer/Developer/Onsite Lead/Tech Lead with strong 7 plus years of experience in Analysis, Design, Developing and Maintaining large Enterprise
• Data ware house systems using AbInitio as the primary ETL tool on Unix/Linux based operating system connecting to multiple different data sources including (but not limited to) Teradata and DB2.
• Excellent hands on experience with Project Management, End to End project ownership, Resource forecasting, Managing multiple offshore teams, Liaising with other teams to capture requirement and convert it into ETL specific requirement.

TECHNICAL SKILLS:

• DB2
• Oracle
• Informix
• SQL Server
• MySQL
• Familiarity with SAS Enterprise Guide and SAS Enterprise Miner.
• Unix Shell Scripting (Korn, Bash, C shells)
• Perl, Awk, SED
• Maestro, Tivoli Work Load Scheduler (TWS)
• HP Quality Center
• Control - M
• Data Modelling
• Dataware Housing Concepts
• Master Data Management
• MS Office suite
• AbInitio EME
• Plan>IT
• AbInitio Dynamic Task Manager(DTM)
• SQL
• Core Java
• TOAD
• SQL *PLUS
• Maestro JSC
• SQL Server Enterprise Manager
• Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, St Paul, MN

Information Engineer

Responsibilities:

• Actively working with architects and ETL Infra Admin group to revamp the ETL infrastructure under Shared Business Intelligence service portfolio. Primary tasks involve EME structure redesign, Generic components design and development, evaluation of new tools and redesign of the entire ETL portfolio.
• Working on design of Reinsurance repository project to integrate Reinsurance data into the existing dataware house.
• Allocation of tasks to multiple vendors (Cognizant, Accenture and L&T) and leverage offshore resources to keep the cost of the project down.

Confidential, Richmond, VA

ETL Designer and Developer

Responsibilities:

• Currently working on design and development multiple subject areas of Cards Data warehouse (CDW), including (but not limited to): CDW Core Billing, CDW Card Guard, CDW Model scores to name a few.
• Familiarizing self to various subject areas of Capital One to act as Subject Matter Expert (SME) in near future.
• Working actively to set up onsite/offshore Design, Development and Level 3 support team.
• Currently engaged in dual role of Tech Lead/ Onsite Coordinator and Designer.
• Currently acting as Knowledge Transition Lead for CDW Level 3 team ( Confidential team is taking over multiple projects from Infosys Technologies Ltd). Currently, my team is in knowledge acquisition phase for multiple segments.

Confidential, Atlanta, GA

ETL Designer and Developer

Responsibilities:

• Designed and Developed multiple ETL systems of Enterprise Data warehouse (EDW), including (but not limited to):
• Vendor Store Support Reporting (Vendor SSR) and Cost Analytics
• Interfaced with BI Team (Microstrategy, Hyperion), Data Modeling Team and Business user for POC (Proof of concept).
• Extensively worked with Business users, Enterprise Architects, EDW Architects and BI team to design the end to end solution.
• Worked with Data modeling team to create the logical and physical data model to support BI teams reporting needs and provide Business users with a reporting solution satisfying business needs.
• Worked in an offshore - onsite model with a offshore team size of 5 members to Design, Develop, Unit test and QA support activity.
• Single handedly completed the deployment of code to production systems and provided warranty support.
• Currently working with Support Existing Systems team to transition the project for extended production support while providing the warranty support until the Hand over Take over (HOTO) activity is complete.
• The project satisfies THD’s vendor reporting needs and will be extensively used by Store Managers and Assortment planners.
• The ETL is AbInitio and BTEQ code with data residing on Teradata and Microstrategy being the BI layer.
• My primary role in this project is to own the delivery of ETL components and ensure that ETL components are designed and developed without any gaps to interface with the BI reports.

Confidential

ETL Developer

Responsibilities:

• Extensively worked AbInitio ETL tool with DB2 and Oracle as database to design and develop ETL solution.
• Transition and understanding of as is processes, issues, defects and batch flows from various sources for Billing and Payments program.
• Preparing Low Level Design documents, Project Support Documents and other major tollgates documents.
• Performed effective Internal Quality Assessment (IQA) and External Quality Assessment (EQA) for ETL code of team and external teams.
• Developed and maintained the ETL code for Electronic Billing and Payments program primary responsible for feeding data to the BT.com’s billing portal.
• Extensively worked with EBCDIC files.
• Restructured large UNIX and PERL programs for project specific requirement.
• Worked on multiple smaller sized Java enhancements as and when required.
• Supporting lower life cycle batch jobs
• Participating in holiday readiness activities for 2 consecutive years with great success
• Reporting project status and ticket metrics to management in adherence to SLAs.
• Working on creating new metrics to report figures on support tickets, maintaining support logs, weekly dash board, automation, creating FAQs and maintenance manual.
• Taking up primary pager support after a quick ramp up.

Confidential

Trainee

Responsibilities:

• Trained with Software Development Life cycle methodologies and its various variants which are used in today’s industry.
• Trained on bridging the technology and implementation gaps between Theoretical Computer science and practical implementation.
• Trained for developing effective communication skills, managing resources by power of persuasion, emotional intelligence and various other management techniques.
• Trained in internal company specific methodologies.
• Trained in Foreign language, German.