SUMMARY:

• Ten years of overall IT experience in developing and supporting large - scale enterprise software solutions using Ab Initio.
• 10+ years of ETL (Extraction, Transformation and Load) experience using Ab Initio.
• Experience in design and development of large-scale DWH systems which source data from disparate sources.Rich experience working in Banking Domain - well-versed with Credit Risk Management and Basel Compliance.
• Expertise in Retail domain and excellent functional knowledge of Supply Chain Management.
• Experienced in developing coding standards, specifications, business rules and documentation.
• Expertise in production support and Third Line support activities.
• Experienced as a Service Delivery Lead implementing ITIL principles.
• Good working experience in PL/SQL.
• Extensively worked with databases and loading/unloading using Ab Initio. Well-versed with database concepts.
• Experience in working with test teams and creating test plans and testing concepts.
• Scheduling experience - well-versed with scheduling concepts. Hands-on experience with Tivoli Work Scheduler.
• Worked on fine tuning schedules to achieve significant time savings during batch jobs.
• Involved in creating the Logical and Physical design of the Data Warehouse.
• Well-versed with Data warehousing concepts.
• 2+ years of development experience in MS Access, VBA and SQL.
• Progressive educational background with Master’s degree in Management Information Systems with a perfect 4.0/4.0 GPA.
• ITIL v3 Foundation certified.

TECHNICAL SKILLS:

ETL Tools: Ab Initio 3.0/2.15/2.14

Version Control: EME, CVS, WinCVS, SVN

Programming Languages: C, Java, R and VBA

Database Technologies: Oracle, Db2, MySQL, MS Access, FOXPRO

Other Tools: Toad, IBM DataStudio

Operating Systems: UNIX, Windows, Linux

Scheduler: Tivoli Work Scheduler, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Ab Initio Consultant

Skills Used: Ab Initio, Oracle, Control-M

Responsibilities:

• Design and develop graphs using Ab Initio for enterprise-level complex data integration across multiple, disparate systems.
• Translating Change requests into technical design.
• Optimize run times of graphs to mitigate the risk of missing Service Level Agreements as data volumes increase with time. Also devise strategies for optimizing server utilizations for shared services.
• Implement reusable framework to reduce development time. Design generic graphs for CDC (change data capture), surrogate key generation, housekeeping, data depersonalization and data enrichment.
• Participate in the high level architecture to define the high level design and assist designers in low level design discussions.
• Implementing application level tactical solutions and enterprise-wide strategic solutions for Disaster recovery.
• Provide Post Go-Live Support for Business Analytics Solutions and provide warranty support.
• Perform root cause analysis on all batch processes and resolve critical production issues and validate all data and devise integrity checks on databases and provide L3 support to all ETL applications.
• Provide support for System Integration Testing (SIT) and code and implement defect fixes.
• Design review and suggesting optimization strategies for all multiple graphs
• Mentoring new team members.
• Design batch schedules and help in optimizing server utilization. Hands-on experience in Control-M Scheduler.

Confidential, UK

Senior Ab Initio Developer and Technical Lead

Responsibilities:

• Design, develop and support ETL processes using Ab Initio
• Translating Functional requirements into technical design.
• Fine tuning the mapping rules to adapt with exiting customer information base for all insurance customers.
• POC and regression testing for the initial skeletal design.
• Designing generic graphs for CDC (change data capture), surrogate key generation and enrichment.
• Developing, reviewing and testing final data processing graphs.
• Implementing major enhancements like upgradation to higher version EME for all the applications.
• Up gradation of the MDE (Metadata Driven Engine) platform to accommodate new strategic solutions.
• Creation of common work areas for sharing source data with upcoming projects and facilitating the IM strategy.
• Implementing application level tactical solution for Disaster recovery.
• Designing a strategic DR solution for Insurance suite.
• Migrating the “acquire and publish” MDE application to live environment.
• Deployment of Major enhancements and new releases by incorporating new data sources.
• Optimize run times of graphs to mitigate the risk of missing SLA as data volume increases with time.
• Design review and suggesting optimization strategies for all emerging Applications on the GDAP platform.
• Mentoring new team members.
• SPOC for Insurance MI suite of projects and facing off with business for all their issues. Providing updates of batch interruptions. Regular meetings with business users to identify service improvements.
• SME for acquire and publish framework projects.
• Design batch schedules and help in optimizing server utilization. Hands-on experience in Tivoli Work Scheduler.
• Supervise the day-to-day activities of ETL developers in the capacity of Team Lead
• Assist operation teams in OAT (operational acceptance testing). Operational Acceptance Testing.
• Design and build reusable Ab Initio graphs and sub-graphs
• Design custom Ab Initio graphs
• Undertake design and code reviews

Confidential

Ab Initio Developer

Responsibilities:

• Actively involved in all phases of project development life cycle.
• Created technical design documents.
• Developed Ab Initio graphs for receiving the data for various dimensions all the way to populating the dimension tables.
• Data verification and validation processes.
• Understanding the JPMC Ab Initio development framework.
• Ab Initio Development of custom graphs for pre-processing and post processing components.
• Load metadata into the framework tables for generation of file layouts and other scheduling components.
• Configure the data mapping, build, test and deploy BRE components into the graph.
• Unit testing and work with users on data validation.
• Developing the Korn Shell scripts for wrapper automation of ETL by taking care of the exception-handling.
• Performance Tuning of Ab Initio graphs processes and load routines using parallelism (pipeline component & data) and best practices.
• Developed Complex Ab Initio XFRs to derive new fields and accommodate various business requirements
• Extensively used EME for version control management and dependency analysis.
• Ensured data is clean consistent and synchronized across source platforms. Review data loaded in the DWH for accuracy.

Confidential

Technical Team Lead

Responsibilities:

• Supervise, Design and develop a metadata driven platform for reducing development effort for all future ETL solutions using metaprogramming feature of Ab Initio.
• Develop a reusable framework for Acquire and Publish that will be used for all data acquisition and cleansing from various source systems and provide a uniform version for all downstream systems.
• Design review and suggest optimization strategies for all emerging applications on the GDAP platform.
• Upgrade MDE (Metadata Driven Engine) platform to accommodate new strategic solutions.
• Creation of common work areas for sharing source data with upcoming projects and facilitating the Information Management strategy.
• Work with business users to identify and implement service improvements for better efficacy of customer campaigns.
• Develop Unix Korn Shell scripts (wrapper scripts) for automating exception handling.
• Collaborate with other Domain Architects, DBA, Data Modelers, Support Groups and also Application Development & Test teams to ensure timely deliverables.
• Architect utilities to extract valuable technical information to provide insights on performance, volumes, and statistics from Production Logs.
• Operational/service improvements through improved scheduling.

Confidential

Technical Lead

Responsibilities:

• Designed and developed and supported the extraction, transformation and load process (ETL) for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Prepared Low Level Design (LLD) documents working alongside Business Analysts.
• Prepared LLD documents using mapping documents provided by BAs.
• Used Ab Initio GDE to generate complex graphs for the ETL process.
• Extensive experience in scheduling the Ab Initio deployed scripts using TWS.
• Performed the tuning of graphs to improve performance
• Defining business rules and transformations for data coming from source systems into the datawarehouse.
• Modified the Ab Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Analyze business requirements and developed metadata mappings andAb InitioDMLs.
• Support for user acceptance testing.
• Production migration and production support (3rd line).Confidential

Confidential

Ab Initio Consultant

Responsibilities:

• Onsite Technical Lead for PSO Batch module with team members working from Mumbai (India) and Manila (Philippines).
• Creating interfaces between various systems and developing graphs using Ab Initio.
• Responsible for business requirement and analysis from business users.
• Designed and developed enhancements and fixes for existing graphs.
• Tuning of Ab Initio Graphs for better performance.
• Formulating Unit Test Plans for the developed components.
• Hand-on experience with multi-file systems.
• Interact with Confidential to gather requirements for enhancements; design and develop code changes.
• Version control using CVS.
• Provide a point of contact for questions and information regarding PSO Batch.
• Maintain and update documentation for PSO batch.