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