We provide IT Staff Augmentation Services!

Consultant, Onsite Coordinator, Resume

Foster City, CA

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

Confidential, Foster City, CA

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,

Confidential, Northbrook, USA

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

Project leader, Offshore

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
Module leader and Onsite Coordinator

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
Module leader, Offshore

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
Developer and Onsite Coordinator,

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

Hire Now