Data Sql Server

Summary:

Database Developer with * years of work experience in Database design, analysis, modelling, support and development of MS SQL Server. Supportive and enthusiastic team player with a willingness to learn and explore new things. Currently, looking for a full-time opportunity in database and data warehouse development, data analysis starting immediately.

Software Skills:

Databases: MS-SQL Server, MySQL, Oracle, Postgres

Tools/Softwares: Tableau, SSIS, AWS, Power BI, Microsoft Excel, Talend Integration Studio, SSRS, SSAS, Qlik sense,

Informatica, Datastage, Wrangler, RStudio, Visual Studio, Toad Data Modeler, JIRA, HP QC 10

Programming Skills: Python, Java, R, HTML, CSS, JavaScript

Certifications: Certification in Data Mining from Northeastern University Program

Professional Experience:

Berkshire Hathaway Specialty Insurance, Boston (Software Engineer Intern) July 2016 – Dec 2016

Developed and executed Test Scripts using Functional Requirement Documents and Test scenarios for Positive, Negative, Boundary cases and performed all types of testing on workflows and application software.

Involved in UAT testing in UAT environment, Prepared UAT test cases and testing estimates.

Created advanced Microsoft Excel functions, VLOOKUP, MACRO and other excel functions to create pivot tables.

Extracted, compiled and tracked data, and analyzed data to generate reports and initiated more efficient and optimized data collection procedures.

Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.

Conducted detailed analysis of complex business processes, data requirements and proposes solution.

Developed, administered and maintained training documentation and acted as point of contact on use of software tools.

Accenture Solutions & Pvt Ltd, India (Database Developer) June 2010 -July 2015

Developed and debugged complex SQL server queries, Stored Procedures, User Defined functions(UDFs), Views in MS SQL Server to support the business requests.

Extracted, cleansed, transformed and loaded data into data warehouse using ETL(SSIS)

Designed SSIS packages with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.

Implemented SSIS packages by deploying, maintaining, alerting, scheduling the SSIS packages

Defined the data mapping, Slowly Changing Dimension SCD logic for ETL jobs assisting the development by 85%.

Developed parameterized reports, sub-reports, Drill down and Drill through reports using SSRS.

Created reports and dashboards with interactive views, trends and drill downs using Tableau and Power BI.

Maintained regular backups, restore databases and transaction logs as needed.

Involved in trouble shooting and performance tuning activities of databases for better performance and concurrency.

Academic Projects:

Data Warehouse creation and BI Analysis for Retail Company Course: Data Warehousing and Business Intelligence

Created a data warehouse and loaded the data warehouse from different data sources (SQL Server, MySQL, Postgres, Oracle, flat files) into SQL server using Talend Enterprise Data Integration tool and SSIS. Created Slowly Changing Dimensions for unit prices and unit costs that changed independently 3 times in two year’s time period.

Loaded the rejection records and tracked the reasons for rejections and performed BI analysis for trending, ranking, comparison, contribution and geomap analysis using various tools like Power BI, Tableau, Qlik Sense.

Loyalty Predictive Analysis of Customers for Retail Industry Course: Advanced Data Sciences and Analytics

Developed a model in R and Azure Machine Learning Studio to analyze and predict if a given customer is loyal based on behavioral input parameters and achieved an accuracy of 67%.

Developed a web application in Spring-MVC, Hibernate and integrated it with Azure Machine Learning Studio using REST API to deploy the prediction model using AWS. Performed various analysis and visualizations using Tableau.

Sentiment Analysis and Product Recommendations Course: Big Data Engineering

Performed sentiment analysis on training dataset of 2GB size about product reviews on Amazon retail website, applied Multinomial NAÏVE BAYES algorithm to determine overall positivity and negativity of a text review.

Performed product recommendations to the users based on Mahout Recommendation library and built Hadoop Distributed cluster of 4 servers using AWS EC2 instances for MapReduce Operations.

Education:

Northeastern University, Boston, MA Sept 2015 - August 2017

Master of Science – Information Systems

University of Pune, Pune, India August 2006 - May 2010

Bachelor of Engineering – Electronics and Telecommunication

Contact this candidate