A data enthusiast with overall 5+ years of IT experience in database design, development and Business Intelligence (BI) using Microsoft SQL Server 2008R2/2012 in development, test and production environments along with good knowledge of SDLC, Business Analysis (Waterfall and Agile Methodologies), requirement gathering, testing, and Quality Assurance.
*Expertise in data analysis and development using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)
*Expertise in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting Microsoft SQL Server 2008 R2/2012
*Excellent knowledge in high level design of ETL packages using SSIS for integrating data from heterogeneous sources like Excel, CSV, Oracle DB, Microsoft SQL Server and flat files
*Excellent understanding of SSAS and OLAP cubes
*Experience in writing expressions in SSRS and fine tuning reports
*Excellent knowledge in creating databases, tables, stored procedures, DDL/DML triggers, views, user defined functions, cursors and indexes using Transact-SQL
*Experience in performance tuning and query optimization
*Experience in designing dashboards, scorecards, OLAP charts and SSRS reports
*Experience in deploying, maintaining, administering and scheduling of SSIS packages
*Experience in creating star schema, snowflake schema for data warehouse design & implementation
Microsoft SQL Server 2008R2/2012, Microsoft Access, Oracle Database 10g/11g
Programming: SQL, Transact-SQL, C#, Python, ADO.NET, XML
Tools/Utilities: SQL Server Management Studio 2012, SQL Server Reporting Services (SSRS),
Report Builder 3.0, SQL Server Integration Services (SSIS), SQL Server Analysis
Services (SSAS), MS Office Suite
Microsoft: Microsoft Dynamics Student Certificate
Online: Programming with C#, Python, Excel for Data Analysis & Visualization
Oracle: Oracle Business Intelligence Suite 11g Certified Implementation Specialist
Business Intelligence Developer, 09/2014 to 12/2016 Eastern Michigan University EMU – Ypsilanti, MI
Designed data marts - (star and snowflake schemas) for Maximum Miniatures Inc., a company which sells painted figurines.
Performed ETL (Extract, Transform, Load) using SSIS packages to load data marts with data extracted from heteregenous data sources.
Designed Multi-Dimensional OLAP cubes for analyzing Manufacturing, Inventory and Sales Fact tables.
Defined key performance indicators (KPIs) to measure company performance against pre-defined goals.
Performed data mining to discover patterns in Customer and Sales data using different mining algorithms like Naive Bayes, Neural Networks, Clustering, Classification and Association Analysis.
Interviewed the stakeholders and conducted meetings with business users to gather requirements for UltimaCNCParts - an ecommerce company which sells automobile parts.
Designed business process flow and functional requirements for streamlining development of a BI solution.
Designed Entity-Relationship Diagram (ERD) for database design and implementation.
Developed the OLTP database and performed ETL using SSIS package to extract data from source systems and load the transactional SQL Server Database.
Worked with business users to validate the data in the transactional database.
Created and deployed parameterized reports and charts for reporting and quick data analysis.
Worked at the EMU CIS Department to develop close to 400 SSRS reports including tabular, matrix, chart, drill down, drill through, stepped reports, sub-reports, linked reports, parameterized and cascading reports.
Performed data analysis using Google Analytics to measure important web metrics against goal conversions to develop important reports & dashboards which helped make informed decisions.
Analyzed web metrics to develop marketing strategies for four different e-commerce businesses to increase lead generation.
Optimized marketing campaigns and product listings for targeting potential customers.
Developed Windows Form applications which can calculate GPA, restaurant bill, estimate cost for a cake factory, track weather and track students registered for a course using object-oriented programming (C#).
Developed console applications which can track student, teacher, course, program and degree information.
Programmer Analyst, 01/2012 to 08/2014 Tata Consultancy Services TCS – Mumbai, India
Played a vital role in maintaining global regulatory compliance by triaging, analyzing, capturing patient-drug safety data into Enterprise Database using company's front end applications.
Conducted thorough data analysis to develop executive reports and dashboards which enabled the steering team make fact-based strategic decisions leading to a $3 million increase in revenue in 2012.
Developed modules for training and mentoring associates which led to a 50% reduction in new recruit on-boarding time.
Received a certificate of appreciation for commitment to work excellence due to timely delivery of high-quality project deliverables on a consistent basis with a great focus on customer satisfaction.
Master of Science: Information Systems, December-2016 Eastern Michigan University (EMU) - Ypsilanti, MI Information Systems 3.86/4.00
Bachelor of Science: April-2011 University of Mumbai - 3.59/4.00
ACHIEVEMENTS, AWARDS & MEMBERSHIPS:
*Honor student for academic excellence, Winter 2016 at EMU April-2016
*Honor student for academic excellence, Fall 2014 at EMU January-2015
*Certificate of appreciation for outstanding work at TCS October-2013