Data Engineer

SHUBHAM CHATURVEDI

ac1pdi@r.postjobfree.com www.linkedin.com/in/shubham-chaturvedi

774-***-**** github.com/schaturvedi2016

SUMMARY: 3+ years of experience in Database Management and Data Warehousing (ETL). Seeking a Full-Time Database/ETL Developer role at your company.

EDUCATION:

University of Massachusetts Dartmouth, MA Sep 2015 - May 2017

Master of Science in Computer Science GPA - 3.59

Visvesvaraya Technological University, Karnataka, India Sep 2008 - Jun 2012

Bachelor of Engineering in Computer Science

TECHNICAL SKILLS:

Operating Systems : Windows, Linux (Fedora, Ubuntu).

Languages : Java, PL/SQL, TSQL, HTML, JavaScript, CSS, UNIX Shell script.

Framework/Software : D3.js, MS Word, MS Access, MS Excel, JSON, JQuery, XML, GIT/GITHUB.

Databases : Oracle 11g/10g/9i, SQL Server 2016, MongoDB (Beginner), PostgreSQL (Beginner).

Tools/IDE : Informatica Power Center V9.x, Visual Studio Code, SOAP, JIRA, TOAD, Eclipse.

OLAP/BI Tools : Cognos 8 Series, R.

WORK EXPERIENCE: Aug 2012 – Jul 2015

Aviva Life UK - ETL Informatica Developer (Insurance Domain)

Wipro Technologies, Bangalore, India - Project Engineer: Data Warehousing

Designed, Developed, Tested, and documented the Informatica mappings and SQL codes.

Developed effective working relationships with client team to understand requirements and write technical specification and documented it properly.

1+ years of experience in Reporting tool COGNOS ( 8.4)

Knowledge in Full Life Cycle development of Data Warehousing Agile methodology experience.

Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Experience with dimensional modeling using star schema and snowflake models.

Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

The solution provided such as DB2 configuration, data modeling (physical & logical), and identification of trusted data sources, database creation, and ETL processes.

Expertise in creating and scheduling Informatica jobs using Informatica session, Windows scheduler and with UNIX.

Performed Impact Analysis of the changes done to the existing mappings and provided the feedback

Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.

Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

Worked on Oracle 11g and MS SQL Server environments and used Triggers, TSQL, Functions, Cursors, SQL, and PL/SQL, to maintain the database.

Worked with post development cycles and applications in Production Support.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Aviva Life UK - IBM MDM Production Maintenance (Insurance Domain)

Wipro Technologies, Bangalore, India - Project Engineer: Data Warehousing

Increased the productivity of team by saving approximately 2 to 3 hours of work each day to load policy data into MDM database, by automating the policy data load.

Maintained redundancy, standardized the data, and incorporated the MDM rules to eliminate incorrect data in Database.

Supported production environment of MDM implementation remotely (During Hot Fixes) and tuned some of the aspects of MDM processing through MS SQL, log checker and Putty UNIX server.

Worked on Oracle DB, tuned the performance of existing SQL queries, and documented the operation support guide for future reference.

Expertise in team management with multiple platforms and on cross technology.

ACADEMIC PROJECTS:

An Open Source tool for Rotorcraft Tradespace Exploration (Master’s Project) Dec 2016 – May 2017

University of Massachusetts Dartmouth, MA

Considering cost and availability, Optimized the mathematical model using Differential Evolution algorithm in Python to perform and visualize Tradespace.

Scaled the optimization methods to n components which was an improvement to the previous model and used PyQT5 python library for the GUI designing.

US Presidential Debate 2016 Sep 2016 – Dec 2016

University of Massachusetts Dartmouth, MA

Conducted text analytics along with visualization of data which contained speech of the presidential candidates.

Used Python and database techniques for cleaning the data, used JavaScript and D3.js technology when performing the web based visualization.

Visualized the data which showed some interesting patterns and gave a summarized and detailed description of data.

Inventory Control Management Database Project Feb 2016 – May 2016

University of Massachusetts Dartmouth, MA

Maintained a proper variety of required items, increase inventory turnover, reduce and maintain optimize inventory and safety stock levels, obtain low raw material prices, reduce storage cost, reduce insurance cost, reduce taxes

FBI Hate Crime Analysis USA Feb 2016 – May 2016

University of Massachusetts Dartmouth, MA

Worked on the dataset available on FBI site and visualized the data to understand the interesting patterns, rates, the severe affected regions of United States and the agency type involved in it.

Used JavaScript, CSS, HTML, D3, and JSON and conducted the interactive visualization, to answer several questions which were unanswered just by seeing the dataset.

Online Retain Application Database Sep 2011 – Dec 2011

Visvesvaraya Technological University, Karnataka, India

A customer can register to purchase an item. The customer will provide bank account number and bank name (can have multiple account number). After registration, each customer will have a unique customerid, userid and password. A customer can purchase one or more item in different quantities. The items can of different classes based upon their prices. Based on the quantity, the price of the item and discount (if any) on the purchased items, the bill will be generated. Made a bank account which required to settle the bill. The items can be ordered to one or more suppliers.

Contact this candidate