SUMMARY:

• 5+ years of experience as a SQL Server Developer/Business Intelligence Developer focusing on Database Design, Development, Data Modelling, ETL, Data Warehousing, OLAP Cubes, Reports and Data Visualizations
• Strong analytical skills using SQL Server databases, SSAS cubes, SSRS reports, T - SQL and MDX Queries.
• Proficient in data extraction, cleansing/data integration, and loading from different data sources using SSIS.
• Hands on experience with Data Marts, Dimensional Modeling, Star Schema, FACT and Dimensional tables and Operational Data Store (ODS) involved in Business Analysis of the OLTP and OLAP data.
• Proficient in creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX.
• Experience in generating custom reports and various types of reports like Tabular, AD hoc, Matrix, Drill Down, Drill Through using Power BI, SSRS and Tableau
• Extensively involved in writing T- SQL queries in Implementing and Developing Stored Procedures, Triggers, Joins, Views, User Defined Functions, Indexes and Subqueries.

TECHNICAL SKILLS:

Data Design and Development: MS SQL Server 2016/2014/2012/2008

Business Intelligence Tools: Microsoft BI Tools (SSIS, SSAS, SSRS)

Data Modeling Tools: SQL Server Data Tools, ER, Toad Data Modeler

Development Environment: Visual Studio.Net 2013/12

Language: T-SQL and Python, C#

Data Analysis: Numpy, Pandas, R, and Scikit-learn

Data visualization and reporting: Python (Matplotlib, Seaborn), Excel, Power BI, Tableau and SSRS

Operating Systems: Windows 10/8.1/8/7, Vista, 2003/XP/2000 Cosmos/scope and Azure Data Lake basic

PROFESSIONAL EXPERIENCE:

Data Analyst and Researcher

Confidential, Lynnwood, WA

Responsibilities:

• Collect data from different sources, analyze and put into database.
• Transformed and combined the data using Query Editor in the Power BI and created many calculated columns and measures using DAX in Power BI.
• Collect lightweight materials research data which are available in the web all over the world and manage the data in the database.
• Review educational modules which are in the National Resource Center for Material Technology Education website.
• Analyzed large volume data to understand Materials behavior and to design better materials for different applications.
• Used Python, data analytics tools, excel, power BI, Tableau.

Data Analyst

Confidential

Responsibilities:

• Created stored procedures, triggers, views, tables, indexes, joins, subqueries and constraints, user defined functions to extract, write and manipulate data.
• Performed data extraction, cleansing/data integration, and loading from heterogeneous data sources to destination using SSIS and experience in creating jobs and schedule SSIS Packages.
• Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.
• Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and scheduled daily data refresh in Power BI.
• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Generating ad-hoc reports using Power BI for weekly service report, Dashboard where client can see daily status.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.
• Created many calculated columns and measures using DAX in Power BI based on report requirements and published Power BI reports to end user via mobile.
• Integrate the Power BI Dashboards with SharePoint for restricted view with key stakeholders.
• Populated all the dashboards using Power BI Calculated measures and SQL Queries.

Technologies and tools used: MS SQL Server 2014/2012, SSAS, SSIS, SSRS, Python, R, Tableau and Power BI

SQL/Data Ware House/ETL Developer

Confidential

Responsibilities:

• Performed requirement gathering, created conceptual, logical and physical data models, involved in requirement analysis, development, testing and deployment of data warehouse using SQL Server.
• Created, developed and managed schema objects such as tables, views, indexes, stored procedures.
• Created ETL packages to validate, extract, transform and load data to data warehouse databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Transformer, lookup, merge, join, aggregator, sort, filter and remove duplicates stages were extensively used to data extract into staging.
• Worked on normalization techniques, normalized the data into 3rd normal form (3NF).
• Created fact and dimensional tables and creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX and DAX query.
• Implemented ETL techniques for data conversion, data extraction and data mapping for different processes as well as applications
• Created stored procedures, triggers, views, tables, indexes, joins, subqueries and constraints, user defined functions to extract, write and manipulate data.

Technologies and tools used: MS SQL Server 2008 R2, SSAS, SSIS, ER, Toad Data Modeler