ABHIJEET TYAGI

ac95os@r.postjobfree.com +1-224-***-****

Summary

ITIL certified professional with 13+ total years of IT experience in Business Requirements Analysis, Application Design, Development, Implementations, Testing & Support of Data Warehousing business systems for highly regulated industries such as Banking & Finance (JPMC, Citibank, Standard Life Investments & American Express) and Healthcare (IMSHealth & Optum). Proficient in designing ETL solutions, from estimation to deployment and support phase of projects, to meet business challenges and objectives and leading software development teams.

Skills

Project management & delivery

Solution Architecture

ETL

RDBMS

Leadership

Mentoring

Agile methodologies

Ab Initio suite of products

Unix Scripting

QA

Database (Oracle, Teradata, DB2, SQL Server, Netezza, etc.)

Big Data (Sqoop, Hive, HDFS, Python, HBase, Spark)

Autosys/Control M/Airflow

ServiceNow

Experience Summary

Extensive experience in analysing, designing, building and testing complex ETL applications showcasing strong data integration skills in a team-based software development lifecycle

Build strong relationships with key customer stakeholders to advise, partner, and drive execution

Skilled in developing technical solutions to meet business goals and strategies in a fast-paced environment with competing priorities, while effectively managing time and workload expectations

Successfully designed and managed technology projects in Agile methodologies using technology, people and processes

Proven ability in working alongside senior leadership in project/program management, status reporting

Experience in requirement analysis, estimation, project planning and tracking, resource allocation, etc.

Expert in data profiling, data quality and analysis to design and build a robust and scalable applications

Have extensive exposure to Ab Initio suite of products and RDBMS Databases and Hadoop integration

Strong working knowledge in unix (automating executions, wrapper scripts, etc.) and sql languages along with exposure to Oracle, DB2, Netezza, MYSQL, Sybase and SQL Server databases

Expert in building complex applications from scratch and delivering high quality code

Experience in gaining understanding of business requirements, goals, and risks in order to formulate and define the technical scope and objectives of projects, requirements gathering, creation of high-level and low-level design documents

Excellent communication, analytical and reasoning skills complemented by leadership and interpersonal skills

An effective leader with proven abilities in leading teams during the project phase and guiding team members and enabling knowledge sharing amongst the team

Professional Experience History

Exusia (Optum - Healthcare)

Director July `16 – Till Date

Build new Ab Initio applications from scratch and deliver in Agile methodology

Conduct knowledge transition (Hands-on) sessions for project team to build Big Data capabilities and own a new framework built using Spark (Scala), Python & Unix Scripts

Provide architectural direction to team members, mission critical work streams and work within the agile framework

Trained and mentored team to build applications in Agile methodology

Design complex applications in Express>It from scratch and deliver high quality deliverables in aggressive timelines

Co-ordinate with business partners and offshore to ensure successful and timely completion of deliverables

Analyse requirements and prepare functional & technical specification documents

Profile and analyse data to understand it better and design the ETL applications accordingly

Created automated scripts for tagging code to send email to teams for tag object analysis

Design and build reusable components to enable quicker build of code

Implemented architectural improvements and designed solutions for better performance and scalability

Managed design, development, testing and warranty support of projects to deliver complete application to delight of customers

Recommended best practices to CoE team for code validation, tagging and deployments

IMS Health (Global Reference Repository – Healthcare)

Technical Leader September`14 – July `16

Took up additional responsibility of project management for CMMi level 3 audit and certification

Converted the status from red to green in CMMi certification prep audits and the project was preferred over other projects and selected as the first one to be audited in CMMi level 3 external audit

Played role of Technical Application owner of Global Reference Repository and helped business design and build critical aspects of the application including enhancing its capabilities

Manage a 400K healthcare project housed in UK and India and has users spanning across globe

Involved in project management, effort estimation, project planning, resource forecasting, stakeholder management, project tracking and monitoring

Create and maintain project plans communicating milestones, issues, resolutions and escalations to all stake holders

Responsible for people management, including goal setting and providing performance feedback for a team of 11 people

Turned around the project to reduce project timeline by 20% and progress even with high attrition of experienced people in the team

Managed development and testing teams to work as one project team by improving coordination and resolving conflicts

Formation and implementation of Ab Initio CoE including creating training plans and conducting training programs designed to train resources with varying levels of skillsets

Trained in Hadoop, Hive, Pig, Spark, HBASE, etc.

Wipro Technologies (Analytics & Information Management – Banking & Financial Services)

Ab Initio Tech Lead December`13 – September ‘14

Follow the SDLC life cycle model for projects in managed services engagement

Managed L0 estimates for work order after initial analysis using units of work following the WBS methodology

Engage review sessions with various stakeholders in project

Mentor and lead team members on process and development activities and deliverables

Lead initial discussions with business and technical SMEs on understanding requirement and getting sign-off on functional and technical design documents and solutions to ensure application meets business and performance requirements

Work with peers and manager to ensure assignment deadlines are communicated and being met

Manage and/or develop code with team along with extensive unit testing

Get design and code reviewed and sign-offed by architect and CoE teams

Migrate code to testing environment and support system integration and user acceptance testing

Trained in Informatica, Big Data and Hadoop basics, Agile methodology, Scrum Master, etc.

Syntel Ltd. (Strategy Offerings Group – Banking & Financial Services)

Ab Initio Lead & Specialist July`09 – November’13

Worked with Standard Life Investments in Edinburgh, UK from October’11 to May’13 and was involved in development, maintenance projects and production support (incident/change/problem management) of batch and real-time applications

Worked with American Express as senior Ab Initio consultant for end-to-end data warehousing projects

Helped create Ab Initio training program and train resources to build ETL capabilities of the team

Create LLD and discuss it with architects and stakeholders

Co-ordinate application development activities with offshore development and testing teams and ensure timely closure of defects

Define timelines of development and testing activities and ensure adherence to project timelines

Profile source data before beginning development to better design the application

Define data quality rules in discussion with the business users

Provide solutions to improve efficiency and performance of existing applications

Create processes/automated tools to streamline repetitive tasks saving time and effort for development and/or business community. These tools improved efficiency by 30%

Tata Consultancy Services Ltd.

Ab Initio Developer July`05 to June’09

As onsite coordinator with JP Morgan Chase in US from August ’07 to September ’08

Lead and co-ordinate development and testing activities with offshore team

Improve performance of the existing processes as volume of data was expected to go into millions of records

Develop end to end generic applications involving multiple graphs, xfrs, dmls, etc. to load data into fact and dimension tables of the FDW architecture

Develop application to extract data from FDW tables and load into OFSA tables where OFSA calculations will be performed and load calculated data back into FDW tables

Extract data from FDW fact table and load into materialized views

Certifications & Awards

Project Manager for project audited/certified for CMMi 3 certification

ITIL foundation

Capital Markets (Dealers) Module certification from National Stock Exchange of India

Capital Markets certification from Syntel’s BNFS University

Payments certification from Syntel’s BNFS University

Received SYNTEL’s EXCELLENCE Award in Q1 ’13 and SMART STAR Award in Q2 ’10

Brain bench Ab Initio certification

TCS Ab Initio certification

Education

B.Tech. (Electrical) from NIT Kurukshetra, Haryana, India

Personal Information

Date of Birth: May 11, 1983

US Work Authorization: H1B visa

Contact this candidate