SUMMARY

• Technology Architect with professional experience of 10 years & 10 months and with a zest for working in a fast paced environment with complex problems or business challenges,
• Expert in the Analysis, Application Design, Development life cycle, Design and code reviews, Enhancement of the existing system and Production migration and implementation activities,
• Worked as Ab Initio COE and helped resolving queries raised by users from different vendors working for Allstate,
• Rich experience in Planning, Effort Estimation, Work allocation and Resource Management, good exposure in working multiple projects following Agile methodology,
• More than 3 years of experience working as onsite coordinator for different client and location,
• Well versed with the EME concept, Shell scripting in UNIX, DW concepts, Dimensional modeling, Star and Snowflake schema,
• In ETL worked on various Transform functions, Parallelism, Version control, PDL programming, Continuous flows, Golden Golden gate component, Vector format processing, ICFF lookup as well as base components,
• Worked on creation Ab Initio plans and ESP scheduler,
• Worked on converting graphs PDL interpretation and resolving issues pertaining to dependency analysis to establish lineage in EME,
• Worked in projects which had Agile and Waterfall SDLC structures,
• Worked with aggregate components, partition and departition components, serial and multi file system, static lookup and dynamic lookup, read xml component, join and sort components,
• Strong command over Oracle and PL/SQL, Tivoli with Ab Initio ETL tool,
• Possess good knowledge and business understanding for different subject areas within the Insurance domain. Like Quotes, Claims, Policy etc,
• Capability to learn new things and to adapt quickly in new business and functional domains,
• Proficient in client interaction and communication,
• Worked as onsite coordinator and offshore development lead in multiple projects and led the team average size of 8 - 10 members,
• Interact with Business to understand the requirement, come up with technical design and flow. Prepare design documents,
• Responsible for developing Ab Initio graphs for the project as per the business requirement/Detailed design,
• Worked as Ab Initio COE and supported 300+ Ab Initio users from different vendors for Allstate to resolve their queries,
• Interact with the BA to get the transformation rules/mappings, discuss and resolved queries proactively,
• Conducting design and UTR review sessions with different teams,
• Supporting functional and system testing and other maintenance related activities of application including supporting Business for SIT/UAT,
• Code deployment in production, Implementing releases and changes in production and providing post production support till warranty period,
• Working on the analysis requests from clients for problem records reported during UAT and Production,
• Ensuring the optimum utilization of resources and capabilities for successful and flawless project deliveries,
• Providing effort estimates and resource utilization/plotting for the new work and enhancements,
• Interacting with different teams to setup the development environment, creating DBCR, getting new project created in EME, requesting for IDs and credential for the team etc,

TECHNICAL SKILLS

• ETL Tools: Ab initio (GDE 3.0 Co>Operating System 3.0),
• Base: ORACLE, Terad, DB2,
• Open Source - Big: Hadoop,,
• Operating Systems: Unix, Microsoft Windows XP/2003/2000,
• Programming: Unix Shell Scripting (Korn), PL/SQL,C++
• Scheduler: Tivoli, Ab initio Plans, ESP,
• Other Tools: SQL*Plus, Terad SQL Assistant, Rational Clear Quest, VIPER,
• Trained on warehousing and modelling concepts, Mumbai India,
• Attended BRE and Ab Initio Metaprogramming conducted by Ab initio corporation,

PROFESSIONAL EXPERIENCE

Consultant, Onsite coordinator

Responsibilities:

• Requirement analysis and designing technical flow and graphs.
• Developing Abinitio graphs & UNIX scripts and fine tuning them.
• Performing R&D to identify & rectify any Quality issue.
• Identify prod issue & solving production job failures.
• Helping Team members on any technical & application related challenges.
• High-level exposure in BRE.
• Meeting & bridge call with clients SME to understand and meet their requirement and to debug any issue.
• Performing Code reviews and performance tuning
• Production implementation and warranty support.
• Investigation and causal analysis of issues in SIT and UAT

Project leader, Onsite coordinator,

Responsibilities:

• Understanding the requirement specification and mapping rules for IDM Quotes, House and home Policy and cross sell modules and create a low level design
• Provide effort estimates, resource utilization and delivery milestone
• Leverage my knowledge of Ab-initio, Unix along with strong application development experience at offshore to develop and support IDM HnH Policy and Quotes Acquisition Funnel module
• Performing Code reviews and performance tuning
• Production implementation and warranty support.
• Investigation and causal analysis of issues in SIT and UAT

Confidential,

Responsibilities:

• As a Ab initio developer in the team was responsible for developing graphs in Ab inito as per the detailed design
• Working on UNIX scripts of the projects
• Reviewing AI graphs prior to migration to test environments
• Creation and enhancement of Ab Initio Graphs, Wrapper Scripts, Performance tunings of graph, sql.
• Creation of Jobs and streams for the project in TWS
• Analysis, Design and develop codes in Ab Initio and UNIX
• Conducted several design reviews and UTR reviews with Client team and onsite team.
• Interacting with Allstate BAs and tech leads and onshore counterpart to resolve functional queries
• Lead the offshore development team, and provide necessary support on any technical or functional issue

Confidential,Northbrook, USA

Responsibilities:

• Involved in design of dimension and fact for IDM Claims Module
• Involved in analysis and requirement analysis using D710
• Coordinating with offshore team and Allstate BAs to get the queries and concerns resolved proactively
• Involved in preparation of Technical design document (T235)
• Solving production issues and was involved in production support
• Investigation and causal analysis of various Production problems

Confidential,

Responsibilities:

• Understanding the complete work flow of the project
• Involved in design, development, testing and implementation of ISO premium, paid and outstanding losses
• Involved in preparation of HLD (high level design) and LLD (low level design) documents
• Solving production issues and was involved in production support
• Investigation and causal analysis of various Production problems assigning and delegating tasks to the team members and tracking them to the closure

Senior developer, Offshore

Confidential,

Responsibilities:

• My role was to do mapping analysis, functional analysis and query resolution with the designers and onshore counterparts
• Involved in preparation of Low level design document and create a process flow
• Assigning and delegating tasks to the team members and tracking them to the closure
• Groomed junior resources functionally and technically
• Provided support in system test, UAT, OAT, Defect fixing and Production support

Confidential

Responsibilities:

• I was involved in building, testing and implementing Change Requests.
• Build Graph and Unit test as per the specification.
• Participation in SIT support and Defect fixing
• Responsibility was to take enhancements and new development in hand and replace contractors
• Solving production issues and was involved in production support
• Investigation and causal analysis of various Production problems

ETL Developer offshore,

Confidential,

Responsibilities:

• Involved in build, unit testing, system testing and integration testing of all the module assigned to me
• Developed stage jobs and sequences.
• Fixed defects and performed execution to support system test
• Managed migration process for code implementation
• Onsite support for most of the runs during staff pilot
• On call support for most of the runs during staff pilot
• Prepared the Ranch User Guide for ETL to be used for production runs