Sign in

Business Intelligence Developer

Montreal, Quebec, Canada
November 11, 2017

Contact this candidate

Mr. Gaurav Amrutkar

Apt No. ***, **** St-Marc, Montreal, Email:

Quebec, Canada-H3H2G7 Contact No: +1-514-***-****

LinkedIn: 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


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


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

Contact this candidate