Data Project

Preeti Yadav

**** ***** **, ********** ** *****

******************@*****.*** 978-***-**** www.linkedin.com/in/preeti-yadav18 Education

• Master of Science in Business Analytics Sept 2018 – Dec 2019 University of Massachusetts Lowell (GPA 3.9)

• Bachelor of Technology July 2006 – May 2010

Rajasthan Technical University, India (GPA 3.5)

Experience

BI Consultant III, Mirai Advisory – Boston MA April 2019–Ongoing

• 6+ years of experience with Data Modeling, Business Intelligence and Data Analytics

• High level expertise in ETL and SQL

• Key BI resource responsible for end-to-end development of BI ALM (Asset and Liability Management) project to restructure the old legacy system and to build ALM Data Mart (SQL)

• Familiar with TABLEAU’s best practices in Data Visualization, Storytelling, and Data-Driven Reporting

• Developed Data Quality framework aimed at centralizing ALM data to mitigate operational risk and addressing structural risk from a powerful solution

• Handled Project Management on JIRA Agile Framework and documented workflows in Confluence

• Developed SSIS workflows to integrate data from vendor systems and load into ALM Data warehouse

• Collaborated with cross-functional teams to capture and define business requirements of optimum data warehouse BI solution and Robust Reporting

• Conducted Root Cause Analysis of issues (i.e. reporting logic, process issues, data entry errors, etc.) and communicated the findings to leadership as well as educated the end-users

• Worked on CDO (Chief Data Officer) Reconciliation Project consolidating the record count and their monetary amounts from the source and destination tables

• Strong Analytical and Communication Skills

Senior Software Engineering Analyst, Accenture Services Pvt. Ltd – Hyderabad, India Aug 2016 – Oct 2017

• Created and delivered control flow in Azure Data Factory to integrate disparate data sources from CRM

• Built multiple processes through SQL Server Integration Services (SSIS) to develop a data warehouse project

• Proposed process improvement and performance tuning suggestions in SQL to client and implement them after client’s approval, maintaining strict deadlines

• Created and maintained fully automated CI/CD pipelines for code deployment using Octopus Deploy and PowerShell

• Experienced in working with version control systems like GIT and used Source code management client tools like GitHub

• Used SCRUM for Agile development and participated in team led solutions, reviewing peer’s code for quality and completeness

• Worked closely with client's team to analyze and consolidate project requirements and Workforce Management

• Led a team of interns and mentored them with functional and technical insight of the account with which they were able to deliver projects within strict deadlines independently

• Created and maintained resource management dashboard for my team which helped to better allocate the teams’ resources for all projects

Consultant, Capgemini India Pvt. Ltd – Hyderabad India May 2012 – August 2016

• Performed comprehensive analysis and implementation of SSIS packages

• Learned the Agile model of software development processes and took ownership of all coding, testing and collaboration

• Combined data from different data sources and implemented it into various data warehouses (SQL server)

• Worked on critical issues, analyzed and investigated the failures and implemented proper resolution to business units defining the root cause

• Involved in migration related activities (From SQL 2008 R2 to SQL 2014 and OWB to SSIS) which included creation of stored procedures in SQL from Oracle code, upgradation and re-application of auditing framework of SSIS packages from Visual Studio 2008 to Visual Studio 2013

• Advanced Excel and PowerPoint skills

Technologies and Skills

Tools:

• MSBI - Visual Studio 2008 and 2013

• SSIS

• SSRS

• SSMS (SQL Server Management Studio)

• JIRA & Confluence

• Basics of Tableau

• Microsoft Office

• Azure Data Factory

• IBM SPSS Modeler

Languages:

• SQL (Advanced)

• Python Basics

• Shell Programming

Skills:

• Database Management

• Business Intelligence and Reporting

• Data Mining

• Leadership

• Predictive Data Analytics

Certifications

• Oracle Database SQL Certified Expert

• Implementing Data-warehouse using SQL certified

Achievements

• Telecom Churn prediction project was awarded as the best project and was highly appreciated for its content

• Appreciated multiple times by Client and Manager for quick resolution of tickets

• Awarded ‘RISING STAR’ twice for being a consistent performer and ‘STAR MEMBER’ of the project once for never missing a deadline

Contact this candidate