SUMMARY:

• 15 Years on IT experience
• Over 12 years of Ab initio & 3 Years of Ab Initio administration experience
• Proficient in ETL, Ab initio, Teradata and DW Concepts
• Proven over many times in achieving the business objectives by leading in analyzing, designing, and implementing various ETL solution.
• Have sound experience in both Production support and Development projects
• Experienced in working in both SDLC life cycle and Agile based development environment.
• Designed, Developed, Implemented and Executed new build projects and played a key role in contributing towards the Architecture of the application.
• Have designed and developed generic process involving plans and graphs in achieving the full benefits of re - usability and PSETS
• Have designed and developed generic re-usable components performing specific functionalities
• Proficient and have used most of the Ab initio components and have designed and developed graphs to fulfill complex business requirements
• Have worked with most Database (SQL Server, Oracle, Teradata, DB2), ASCII Files, EBCIDIC Files and XML Files
• Have used Ab Initio Plans and PDL.
• Admin
• Automated Co>Op Installation process
• Performed EME Upgrades / EME purges / EME Re-Image
• Performed Metadata Hub Upgrades & Created a Framework for Metadata Hub Migrations

TECHNICAL PROFICIENCIES:

Platforms: Windows 7, LINUX RHEL6, HP UNIX

ETL Tool: Ab initio GDE 3.2.4 / Co>Op 3.3.2.7 / EME Co>Op 3. 3.2.7 / TRMC / Metadata Hub 3.3 / DQE 3.2 / Control Center 3.2 / Ab - Help / AIW / TRWI

Databases: Teradata, Oracle, SQL Server, DB2

Languages: Shell Scripting, SQL, PL/SQL

Scheduling Tool: Control M, Autosys, Abinitio Control Center

Change Management: Remedy / HPSM / Lotus Notes

PROFESSIONAL EXPERIENCES:

Confidential, Columbus, OH

Ab initio Lead Designer

Responsibilities:

• Involved in the end to end development till implementation of the enhancements request for their quick capital product rollout
• Involved in the end to end development till implementation of the new and enhancements request for CRM switch to Salesforce.
• Was involved in the requirements gathering session.
• Created the ETL design approach and design
• Created the necessary ETL graphs and Abinitio Control center Jobs scheduling.
• Performed unit testing and code migration for QS
• Supported the QA and UAT testing
• Production implementation and once the application was stable transitioned to the L3 Support.
• Individual Contributor

Confidential, Charlotte, NC

IT Technical Lead

Responsibilities:

• IT Data Quality appconfigs to publish the metrics to Metadata Hub
• Creating the Abinitio ETL infrastructure to capture the Data Quality metrics and integrate it to the Market Risk Trading Desk hierarchy
• Create the sourcing generic graphs for processing the DQE published Metrics.
• Creating the enrich infrastructure to integrate the data quality metrics to the Market Risk Trading Desk hierarchy
• Performed the upgrade of Abintio environment to version 3.3.2.7 and Abintio Express IT DQE upgrade to 3.3.2.0
• Involved in the design of the Data Model for the Reporting Data marts.
• Plan activities based on schedule.
• Analyze requirements and design / development of Appconfigs for capturing the Data Quality and ETL enrich infrastructure
• Code review to ensure best practices and design standards.
• Monitor and track the delivery to ensure the delivery timelines are met.
• Productionize new batch jobs and Monitor Production to ensure the SLA’s are met.
• Keep the stakeholders updated on the progress and challenges.

Confidential, Hartford, CT

Lead Administrator

Responsibilities:

• Ab initio Co>Op Installation & configurations also worked to create automated package for coop installation
• Performed POC and complied steps and implemented EME Upgrades / EME purges / EME Re-Image through all regions
• Updated the enterprise Ab initio bridge monitor and maintenance script to include additional functionality
• Evaluated TRW and replaced AIW with TRW through all the regions.
• Created a framework to manage the ab-cinfo daemon to leverage the use of BIOS based Co>Op keys
• Played a key role in the Enterprise Ab initio infrastructure conversion from RHEL5 to RHEL6 Linux OS - Which involved server build / software installation / Data mounts build / Configuration setup / Data Rsync and cutover
• Performed Metadata Hub Upgrades & Created an enterprise Framework for Metadata Hub Migrations
• Supported DQE Teams in creating initial application configurations and troubleshooting issues
• Responsible to Monitor Maintain and own the Business Intelligence and Analytics Infrastructure with Products such as Ab Initio Coop 3.2.3, 3.2.6; Ab initio EME 3.2.7.4, Ab initio GDE 3.2, Ab initio Metadata 3.2.4.2, Ab initio Data Profiler, Ab initio Web-BRE and the related environments such as JRE, Teradata Client, SQL Gateway Servers, Unix Servers, Windows Gateway Servers
• Research future Ab Initio Product releases and install & evaluate for potential adoption for product installations and upgrades. Create and deploy server packages including hot fixes, server patches and perform ongoing environment upgrades.
• Work with Ab Initio on any ongoing issues create necessary package for support and perform steps recommended by Ab initio and work towards a resolution.
• Perform proof of technology or Proof of Concept for a business intelligence application to prove out new capability and functionality on new applications or new features of existing applications become available.
• Run LOB admins meeting where we publish the agenda and track ongoing activities
• Work with Ab initio to procure the required new / upgrade software and server keys as applicable
• Review Release notes and access impacts to the existing infrastructure and plan for any other related software upgrades
• Work with the architecture team to put together hardware and software requirements to build necessary environments if applicable
• Perform POC in Internal Lab environments and perform validations and create validation steps for higher regions
• Create necessary steps / scripts to automate where ever possible and have it tested in the Lab environment.
• Access Impacts and collaborate with stake holders to work out a schedule
• Implement the upgrade / new build / configurations change / etc.

Confidential, Hartford, CT

Ab initio Technical Lead

Responsibilities:

• Analyze requirement and Identify task and plan and schedule activities
• Act as SME and perform High level design and review Low level design.
• Trouble shoot design challenges and provide solutions.
• Review code to ensure best practices and design standards.
• Engage related parties to plan and perform release activities
• Monitor and track the delivery to ensure the delivery timelines are met.
• Keep the stakeholders updated on the progress and challenges.
• Work towards the Release schedule to meet the planned targets
• Analyze requirement and compute LOE.
• High level design.
• Review Low level design.
• Trouble shoot design challenges and provide solutions.
• Code review to ensure best practices and design standards.
• Monitor and track the delivery to ensure the delivery timelines are met.

Confidential, Richmond, VA

Ab initio Technical Lead

Responsibilities:

• Create the sourcing generic graphs for both Confidential Brokerage and Confidential Direct bank. There were about 3 sources each with specific validation and layout requirements.
• Create a generic UNIX shell script wrapper script to deal with parallel processing of source file there by reducing the job scheduling foot print.
• Created the design pattern for the distribution interface.
• Plan activities based on schedule.
• Analyze requirement and compute LOE.
• High level design.
• Review Low level design.
• Trouble shoot design challenges and provide solutions.
• Code review to ensure best practices and design standards.
• Monitor and track the delivery to ensure the delivery timelines are met.
• Keep the stakeholders updated on the progress and challenges.

Confidential, Richmond, VA

Ab initio Lead Designer

Responsibilities:

• Was involved in the end to end development till implementation of the SBB MPE Project.
• Was involved in the requirements gathering session.
• Created the ETL design approach and design
• Created the necessary ETL graphs and UNIX wrapper scripts.
• Performed unit testing and code migration for QS
• Supported the QA and UAT testing
• Production implementation and once the application was stable transitioned to the L3 Support.
• Individual Contributor

Confidential, Richmond, VA

Ab initio Technical Lead

Responsibilities:

• Created the design patterns for Mobile audit logs project.
• Created design patterns for processing XML processing.
• Plan activities based on schedule.
• Analyze requirement and compute LOE.
• High level design.
• Review Low level design.
• Trouble shoot design challenges and provide solutions.
• Co-ordinate with offshore on the deliverable.
• Created design patterns where ever applicable.
• Code review to ensure best practices and design standards.
• Monitor and track the delivery to ensure the delivery timelines are met.
• Keep the stakeholders updated on the progress and challenges.

Confidential, Richmon,d VA

Ab initio Designer

Responsibilities:

• Was involved in the end to end development till implementation of the Full Statement Project.
• Was involved in the requirements gathering session.
• Created the ETL design approach and design
• Created the necessary ETL graphs and UNIX wrapper scripts.
• Performed unit testing and code migration for QS
• Supported the QA and UAT testing
• Production implementation and once the application was stable transitioned to the L3 Support.

Confidential

Ab initio Designer & Senior ETL Developer

Responsibilities:

• Was involved in the end to end development till implementation of the Project.
• Was involved in the requirements gathering session.
• Created the ETL design approach and design
• Created the necessary ETL graphs and UNIX wrapper scripts.
• Performed unit testing and code migration for QS
• Supported the QA and UAT testing
• Production implementation and once the application was stable transitioned to the L3 Support.

Confidential

Senior ETL Developer

Responsibilities:

• L3 Production support for GFS ETL applications.
• Coordination with the Onsite Technical Leader
• Analyzing defects on an application identifying the root cause and a possible solution
• Work on enhancements, analyzing and coming out with design
• Do development work on the enhancement request
• Do Unit testing on the development

Confidential

Associate Consultant

Responsibilities:

• Design, Development and Unit testing
• QA Testing support