SQL Developer

Nirup Reddy Madduri

https://www.linkedin.com/in/nirupreddymadduri +1-903-***-**** *********@********.***

PROFILE SUMMARY

Certified Data Science Associate with hands-on experience in Data analytics algorithms using SAS, R and great interpersonal skills.

Detail oriented IT professional with 2 years of experience as BI developer with excellent communication skills.

High expertise in creating reports and dashboards using Business Intelligence and Data Visualization Tools like Tableau.

Experience in working with cross functional global clients in analyzing and reporting from large scale data stores.

EDUCATION

The University of Texas at Dallas Masters M.S., Management Information Systems (GPA 4.0) May 2018 SASTRA University Bachelor’s in Technology (B.Tech – Electronics & Communications) May 2014

TECHNICAL SKILLS

Tools: SAS, SAS enterprise miner, SSIS, SSRS, Tableau, Hadoop Stack, Hive, PIG,

SAP Business Objects BI4.1, Erwin, Microsoft Excel, Microsoft Visual Studio

Database: Ms Access, Microsoft SQL Server, Dimension Modelling, ER Modelling, ETL

Analytical Tools: SAS, SQL, R, T-SQL, Scala, Google Analytics

PROFESSIONAL EXPERIENCE

Ford Motor Company

SQL Developer SQL, Tableau, SSIS, SSRS, Erwin May 2014 – Jul 2016

Designed Conceptual Logical and Physical database models using Erwin based on client’s requirements

Created scripts to implement Tables, Stored Procedures, Triggers and Views as per the requirements

Created SSIS packages to extract, transform and load (ETL) into data warehouse database

Developed SSRS reports for MTD, QTD, YTD reports on sales of car parts for tracking KPI performances

Improved the availability time of application by 9% by developing SQL queries to analyse and correct the failed jobs

Performed ad-hoc analysis and generated SQL server reports using SSRS on sales data

Created Hierarchies to facilitate drilling down data from highest to lowest granularity of data

Generated reports using Tableau to describe the regional sales of the car parts and accessories

American Heart Association

Data Analyst SAS/R, Excel & Tableau Jan 2018 - May 2018

Predicted Top walkers using various demographic factors of participants by running various statistical models

Used interactive dashboards in Tableau to analyse current market performance of AHA

Increased the donations by 4% by predicting new marketing for organizing events using quantitative models

Adoholic

Marketing Strategy Consultant Google Analytics May 2017 – Nov 2017

• Proposed a marketing strategy using extensive market research, segmentation, competitor profiling.

Improved website traffic of the client through data analysis using Google Analytics, A/B testing by 30%

ACADEMIC PROJECTS

Business Data Warehouse Design Tools: SAP Business Objects BI4.1 and Tableau Sept 2016 - Dec 2016

Designed ER model and Dimension model database for Glassdoor and built universe on top of this models.

Implemented slowly changing dimensions Type2 and Type3 for accessing history of data changes.

Generated canned reports using WebI, dynamic visualizations, ad-hoc analysis reports and dashboards using Tableau.

Database Management System Design Tools: Erwin, SQL Server, Microsoft Access Sept 2016 - Dec 2016

Designed Conceptual, Physical and implementation data models for registration, transactions and feedback.

Created and maintained database objects like Tables, Views, Indexes, Constraints, indexes and Triggers.

Developed complex SQL queries for data-analysis and data extraction.

Student Performance Analysis of Portuguese Schools Tools: R, SAS, Excel, Tableau Sept 2016 - Dec 2016

Applied logistic regression and decision trees to predict student’s performance with 0.119 Averaged square error.

Built statistical models using Regression and Clustering that explains 85% of variation in student’s performance.

Made recommendations to school and parents for improving the performance of students.

Customer Classification Tools: SAS, Microsoft Excel Jan 2017 - May 2017

Reduced number of the predictors using Principal Component Analysis (PCA) while retaining 90.34% of the variation.

Analyzed various aspects of the data and profiled into various segments using Clustering and Association Rules.

Built Predictive model using Decision Trees to predict target purchase indicator with an ASE of 0.132

Profits Analysis AmazingMart EU Tools: Excel, Tableau Aug 2017 – Nov 2017

Performed time series analysis and represented the profits trend using Tableau.

Created a Dashboard to dynamically view the profits of marts in various states of European Union.

Blended data from various sources to calculate various performance indicators.

Predicted best performing departments using dual axis charts.

PROFESSIONAL CERTIFICATIONS

Dell EMC: Data Science - Associate

Udemy: Tableau 10 Advanced Training: Master Tableau in Data Science.

Google: Google Analytics Individual Qualification.

Contact this candidate