Mr. Gaurav Amrutkar
Apt No. ***, **** St-Marc, Montreal, Email: ac29jw@r.postjobfree.com
Quebec, Canada-H3H2G7 Contact No: +1-514-***-****
LinkedIn: https://www.linkedin.com/in/gaurav-amrutkar/ Professional Summary
Total 4.3 months of Techno-functional experience in Insurance financial domain with a strong technical background
Involved in solution designing, development, SME, defect coordinator, Tech lead and project delivery using SDLC as well as Agile Methodology
Strong experience in Business Intelligence domain, Data Warehousing, ETL processes (using Ab-Initio and Informatica), OLAP
Excellent analytical skills with solving large, complex data problems and the process of building and determining a solution.
Have end-to-end implementation experience (ETL to reporting solutions), which includes Configuration, Development, Testing, Documentation, and Application support. Good amount of experience in production support as well as release world of IT projects
Well versed in designing multi-threaded applications with various ETL parallelism techniques and implemented Ab Initio Graphs using Data, Component, pipeline parallelism and Multi File System (MFS) techniques
Good knowledge of Data warehousing concepts, SSIS, PL/SQL and Business Objects and proficient in RDBMS like Oracle-SQL, DB2, SQL Server
Excellent programming skills with ability to automate routine tasks using UNIX Shell Scripting and good experience in SQL, Query optimization and DBA activities
Proficiency in Data analysis, Database management, Design and data modeling
Knowledge on Hadoop (Big Data Processing), underlying technologies of Hadoop like HDFS, Hive, Impala, Pig, YARN and Oozie scheduling tool etc
Strong experienced in using Tivoli Workload Scheduler (TWS) workflow scheduling tool and Ticketing tool - Service Now – ITSM tool
An enthusiastic, project-oriented team player with good communication with an ability to develop creative solutions for challenging client needs. Good amount of experience in production support as well as release world of industry IT projects.
Good experience working on production support activities, solving incident tickets under SLA, coordinating offshore-onshore activities, resolving production failures on the fly
Excellent programming skills in C++ with good understandings of Object Oriented Programming
(OOP) concepts
Education
Master of Science, Computer Science
Concordia University, Montreal, Canada January 2016 to August 2017 Bachelor of Science, Information Technology
University of Mumbai, Mumbai, India June 2007 to July 2011 Technical Skills
ETL tools: Ab Initio(GDE 3.2.2, Co>Op 3.0.4.0), Informatica and SSIS 2008
RDBMS: Oracle 11g, DB2,MySQL, SQL Server, MS Access
Reporting tools: SAP Crystal Reports 2013, Business Objects (4.1)
Programming Languages: UNIX Shell Scripting, SQL, C++, Core java, PL / SQL, Lisp, Prolog, AspectJ, Big Data, Hadoop, MapReduce, HDFS, Hive, Impala, Pig, Sqoop, C
Tools : Putty, Toad, IBM DB2, Oracle SQL developer, SQL plus, Service Now- ITSM Ticketing tool, Amazon web services, Microsoft Azure
Version Control Tools: Enterprise Meta Environment (EME), SharePoint, TFS, SVN, Git Lab.
Job Scheduler: Tivoli, Oozie
Certifications:
Big Data Hadoop Foundation training by IBM– Level 1 September 2017
Accenture Certified - "Ab-Initio Advance class" December 2012
Accenture Certified - "Ab-Initio Introduction class" June 2012
Accenture Greenfield Induction training program October 2011 Work Experience
Senior Software Engineer Oct 2011 – Dec 2015
Accenture Services Pvt Ltd, Mumbai, India
Client: Allstate Insurance
Technologies: Ab Initio(GDE 1.13, Co>Op Sys 2.13), Informatica Power Center 9.1.0, UNIX Shell scripting, C++, Oracle SQL, IBM DB2, Toad, SQL Plus, PL/SQL, Hadoop, HDFS, Map Reduce, Hive, HBase, Sqoop, Pig, Performance Tuning
1. Express Repair Link
As the number of acquisition is increasing, the need to maintain a single database has increased. This project involves the migration of data from old V2 to new v3 database to have multi company sup- port. We follow Ab Initio ETL process for this.
Roles & Responsibilities
Role of Ab Initio Developer and Tech Lead
Requirement Gathering, Prepare detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process, Coding for creating generic graphs and UNIX scripts for multiple source extraction.
Creation of flexible design to rollout countrywide data in chunks
Code review with junior developers. Offshore defect coordinator which includes defect analysis and fixing the defects
Develop PL/SQL for loading staging to target tables
21 Million records including 100 GB of blob extraction, transformation and load to be performed 2. Financial PET redesign (Performance enhancement) One of the performance enhancement critical projects to convert a PL/SQL package to Ab- initio code. The existing daily package took 15 hours to execute and thus there was a need to redesign the package to Ab-initio code
Roles & Responsibilities
Gather requirements, design technical Architecture, High Level Design and Test deliverables
Analyze the pain point for the existing PL/SQL code
Modify the existing SQL to get performance gain
Create Ab Initio ETL A&D documents and define logics for the enhancements
Decrease runtime to 2 hours from existing 15 hours
Work on projects optimizing Visual C++ codes for financial software using Microsoft Visual Stu- dio 2005.
3. SIU– Fraud analytics: Enhancement 2 – Agile Methodology As a part of this module (Special Investigation Unit), the monthly refresh was to be made weekly as per the business demand. This module had saved nearly 10 million dollars for the client. This forms the basis for performing trend analysis to identify providers, agents and customers indulging in fraud and abuse in the Medicare sector on weekly basis. We follow Informatica ETL (Extract, Transfor- mation and Load) process.
Roles & Responsibilities
Developing Informatica 9.1.0 mappings, sessions and workflows using various transformations
Backend development in Oracle 11g (SQL, PL/SQL), Unix shell scripting
Performance tuning based on Unit Testing and Performance Testing
Lead daily scrum calls from offshore to understand the business requirements from onshore senior management team and client
Senior Developer for this project to analyze the pain points to gain performance of the monthly refresh to get it to weekly.
Gather requirements, design technical Architecture, High Level Design and Test deliverables cus- tomized as per the client’s requirements.
Participate in high-level design sessions and be the Accenture Point of Contact with client Tech- nical Architect and BA team for clarifications during Analysis and Design phases. 4. Allstate Roadside Services
There was a need to process large amount of data related to Allstate roadside services and then use that data in one of the application of Nextgen claims. Roles & Responsibilities
Role of Data engineer and Hadoop developer
Analyzing the Big Data requirements and transforming it into Hadoop Centric Technologies
Worked on providing Proof of Concepts for various clients using Hive, Pig & Java Map-Reduce
Data analysis on humongous datasets and discover insights using Impala queries and create visualization reports
5. Ab Initio Save File automation
Save file creation is very important in terms of migration of abinitio objects from one server to another server. The main challenges were the manual efforts. This efforts procedure required a lot of efforts from developers and also increased the risk of human error like many times a tag in save file is created wrongly. There was a need for automating a utility which wrapped contents of the arti- facts to be deployed in production.
Roles & Responsibilities
I single handedly developed a UNIX shell script to eliminate this manual task such that all the manual work is will be done by UNIX shell script. I came up with a strategy to automate this whole manual process.
This automation thus helped to save efforts of abinitio developer such that the each save file started to be created within 5 mins.
With the help of the utility, I was able to save atleast 5-6 hours of deployment efforts of developer which enabled him to focus on more important things.
There is no chance of creating wrong tag in save file.
Later, this tool was started to use in my entire project. Also, later I published this tool on Accen- ture level during ‘Accenture Technology innovation contest’ so that this tool can be used by all projects in Accenture in order to save manual efforts.
I was recognized with a top innovation in ‘Accenture Technology innovation contest’. 6. Production Support activities
Good experience working on production support activities, solving incident tickets under SLA, coor- dinating offshore-onshore activities, resolving production failures on the fly Roles & Responsibilities
Handled high priority tickets related particularly to Ab Initioy, providing resolution under SLA
Fair bit of knowledge with Business Objects reporting development, deployment and trouble- shooting. Also, used Events for Daily/Weekly /Monthly Scheduling of the reports.
Extensive testing and migrating the reports or objects from development to Production system. Imparted knowledge transition to the new joiners related to the project and Ab Initio in particu- lar
Continuous Monitoring of all the Ab Initio Jobs and ensuring that the application was always up and running.
Academic Projects
Concordia University, Canada
Project: Diagnostic System July 2017 – August 2017 Features Developed: We have implemented a diagnostic system in 3 languages (Prolog, Lisp and As- pectJ) to diagnose the cases of various diseases like Influenza, AIDS, Hepatitis C, and Pregnancy. In this project, we have developed a logic for detecting the disease based on the list of symptoms provided by the user during runtime.
Technologies Used: Prolog, LISP, AspectJ, Java.
Project: Highly Available CORBA Distributed Staff Management System (DSMS) May 2016 – Aug 2016
Features Developed: The project was to implement a highly available CORBA DSMS which tolerates process crashes only(no software bugs) using unreliable failure detection. Technologies Used: Java RMI, CORBA, SOAP/REST Web Service, Socket Programming (TCP/ UDP), Multi-threading, Junit, SVN.
Project: Tower Defense Game in Java Jan 2016 – April 2016 Features Developed: A desktop based game developed in java swing. Critters move on a User created map from the start point to the end point. The towers will fire at the critters and kill them as they move from start to end point. Some of the implemented patterns include Observer, Singleton, Factory, and Strategy.
Technologies Used: Core Java, JavaDoc, Junit, SVN. Achievements:
Won “Accenture Technology Delivery Innovation” contest February 2015
Won Accenture "Focuses on delivering excellence" award September 2015
Won Accenture "Collaborates effectively" award December 2013
Won Accenture "Organizes Quality Work Efforts" award August 2013
Won Accenture "Maximizes Team's Performance" award June 2013
Won Accenture "Anticipates and Handles Critical Situations" award December 2012