SUMMARY

• 7+ years of technical expertise on delivering data warehouse solutions using Ab Initio, Continuous Flows, BRE, Conduct>IT, UNIX, AutoSys Scheduler and Oracle.
• Worked closely with business analysts from requirements gathering to project delivery.
• Worked extensively on Secure Financial Data and Pricing Data.
• Designed and developed common infrastructure for extraction of pricing data.
• Developed jobs for reconciliation of reference data.
• Provided solutions for results data warehouse that handles pharmacy data.
• Expertise on almost all phases of Data Warehouse development including gathering requirements, designing Ab Initio - ETL architecture, development of Ab Initio graphs(batch & continuous), implemented meta data programming in Ab Initio transforms, job scheduling using AutoSys, testing in all environments, peer review, bug fixing, creating production ready system and production support.
• Expertise on data warehousing concepts like dimensional modeling, Snow flake schema, Star schema.
• Expertise on design, development and testing of continuous graphs that process XML messages.
• Expertise on developing UNIX wrapper scripts and extensive knowledge on developing generic Ab Initio graphs, and reusable components.
• Conducted internal training sessions on Ab Initio and UNIX for a team of 17 novices.
• Excellent analytic, interpersonal and communication skills, a creative problem solver, self-motivated, with aptitude to assimilate new technologies.

TECHNICAL SKILLS

ETL Tools: Ab Initio v3.1.5 (Design, development, testing of Ab Initio graphs Batch and Continuous), developed business rules using BRE, designed and developed plans using Conduct>IT, Simple Metadata programming.

Scripting Technology: Shell scripting in UNIX.

Scheduler: AutoSys.

SQL Skills: Oracle (TOAD, SQL Developer, DB Visualizer, Aginity)

PROFESSIONAL EXPERIENCE

Confidential

Ab Initio Consultant

Responsibilities:

• Work closely with the business to deliver solutions for their pharmacy and retail operations.
• Architect, develop and implement solutions using Ab Initio and SQLs for Results MSS Business Operations.
• Attend regular meetings with Business Analysts to review mappings and translate business logic to technical requirements.
• Implemented real time processing, which won huge appreciation on the business side as this was the first time the client had ever run business with real time data processing using Ab Initio.
• Offer L3 Production Support.
• Generate reports in the form of excel sheets for business.
• Run SAS Exception Reports.

Environment: Ab Initio EME, GDE 3.1, Conduct>It, Batch and Continuous Flows, Linux OS, Oracle 11g, Aginity, DB Visualizer, Netezza, SAS

Confidential

Ab Initio Lead

Responsibilities:

• Responsible for end-to-end inception of Ab Initio ETL framework for the global pricing MDM application which serves as the central data environment for the client’s global business applications.
• Manage a team of 10 ETL developers (4 onshore, 6 offshore), responsible for regular development and maintenance of Ab Initio ETL loader jobs and framework.
• Conduct weekly status calls with onshore / offshore developers and participate in regular management meetings to discuss upcoming production releases.
• Facilitate regular code reviews and knowledge transfer sessions to ensure best practices are followed throughout the full development life cycle.
• Attend regular meetings with Business Analysts to review mappings and translate business logic to technical requirements.
• Designed common infrastructure for extraction of pricing data for Citi internal and external vendors.
• Worked closely with business analysts from requirement gathering to project delivery.
• Designed and developed plans using Conduct>IT, generic and custom graphs with Ab Initio, UNIX scripts and reusable components.
• Worked on both loaders and extracts.
• Implemented Meta data programming in Ab Initio transforms.

Environment: Ab Initio EME, GDE 3.1, Conduct>It, Batch and Continuous Flows, Linux OS, Oracle 11g, AutoSys, SQL, KSH.

Confidential

Technology Consultant

Responsibilities:

• Task Estimation, Monitoring, Analysis, Design and Develop solutions using Ab Initio, BRE, Design document Preparation and L3 Technical Support.
• Assign task to team on a daily basis and reviewed the work before implementing the application to Production.
• Creation and update of both technical and functional documents.
• Developed continuous flows to process real time XML messages and made updates to 59 tables using simple PL/SQL procedures.
• Designed and developed generic batch process for TLM processing.
• Handled multiple applications to simplify, standardize and uniformly publish data across Capital Markets and Banking in Data Distribution Infrastructure.
• Collaborated/Drove the multiple teams involved in delivering the project on time.
• Documented and shared concepts with teammates.
• Created the Mapping document by translating all Business requirements into meta data names.
• Created Technical Design Documents and Mapping Documents for most of the applications that handle secure data.
• Designed and developed continuous flows and batch processing systems using Ab Initio.
• Provided Secondary Support for high critical systems.
• Worked on BRE to develop business rules and implemented them in Ab Initio graphs.
• Prepared technical design documents.
• Provided support to testing team and worked on incident tickets.

Environment: Ab Initio GDE v 1.1 till V3.0, EME, Conduct>It, Continuous Flows, Linux OS, Oracle 11g, AutoSys, SQL, KSH.