We provide IT Staff Augmentation Services!

Consultant, Onsite Coordinator Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Technology Architect with professional experience of 10 years & 9 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, CDC Golden Golden gate component, Vector format processing, ICFF lookup as well as database 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 data 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 of data 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

TECHNICAL SKILLS

ETL Tools: Ab initio (GDE 3.0 Co>Operating System 3.0), Data Stage

Database: ORACLE, Teradata, DB2

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, Teradata SQL Assistant, Rational Clear Quest, VIPER

PROFESSIONAL EXPERIENCE

Confidential

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 Data 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

Confidential

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

Project leader

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

Module leader and Onsite Coordinator

Responsibilities:

  • Involved in design of dimension and fact for IDM Claims Module
  • Involved in data 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

We'd love your feedback!