Preeti Yadav

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

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

Master of Science in Business Analytics

University of Massachusetts Lowell (GPA 4.0) Sept 2018 – Ongoing

Bachelor of Technology

Rajasthan Technical University, India (GPA 3.5) July 2006 – May 2010 Experience

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

Worked closely with the client's team to analyze and consolidate project requirements and workforce management

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

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

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

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

Create and maintain 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

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

Combining data from different data sources and implementing it into various data warehouses (SQL server)

Support, develop and enhance multiple projects and modules as per the requirement specifications from client

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

Strong written and verbal communication/presentation skill

Advanced Excel and PowerPoint skills

Academic Projects

Telecom Churn Prediction (Fall 2018):

Analyzed and summarized prediction of Customer behavior using Data Mining methods

Data Analysis was done using classification models- Neural networks, Decision Trees and Support Vector Machines

Kickstarter Crowdfunding Project (Fall 2018):

Collaborated with team of 4 to come up with a Prediction Model for success/failure of Kickstarter project Technologies and Skills

Tools:

MSBI - Visual Studio 2008 and 2013

SSIS

SSRS

SSMS (SQL Server Management Studio)

Basics of Tableau

Microsoft Office

Azure Data Factory

SharePoint

IBM SPSS Modeler

Languages:

SQL

Python

Shell Programming

Skills:

Database Management

Business Intelligence

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 the best project and highly appreciated for its content

Appreciated multiple times by Client and Manager for quick resolution of tickets and for successful completion of Migration Project

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

Contact this candidate