Data Sql Server

HARPREET SINGH

214-***-**** ********.***********@*****.*** http://www.linkedin.com/in/harpreet-singh-arora Microsoft certified MSBI(SSIS,SSRS)/Power BI Developer having around 3 years of experience in Database and BI

(Business Intelligence) Solutions using Microsoft Technologies which includes Database Design and Development, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and TSQL, Power BI, Power Pivot and Tabular Model, DAX, MDX.

Summary of Expertise:

• Extensive experience in Design, Development, Implementation of Database systems using MSSQL 2008/2012 for OLTP systems and Microsoft BI for OLAP systems

• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables using Analysis Services

• Good experience in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Replication and Documentation.

• Experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, SQL Joins, User defined Functions, Relational Database Models and Data Integrity

• Experienced in building complex ETL packages using varied and complex data sources and merging them into a single data model

• Skilled in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities

• Expertise in writing SSIS packages with Configuration, Custom Logging, Deployment, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables, Expressions, Procedure Error Handling and Data Error Handling, in SSIS

• Experienced in report generation using Crystal Reports and Excel spreadsheet.

• Experienced in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.

• Proven Power BI development experience with desktop and Pro versions. Familiarity with Direct Query functionality within Power BI

• Provide analytical, complex and specialized client service analysis using PowerBI dashboards

• Experienced in developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, PowerView, SQL Server Reporting Services)

• Experience in creating Index, Stored Procedures, Views, appropriate Functions, and Triggers for efficient data manipulation and consistency

• Experience in designing Database Models using MS Visio and ERWIN for both Relational and dimensional modeling

• Hands on Experience with Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services

(SSAS)

• Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) like List, Matrix, Drill-Down, Chart and Sub Report

• Experience in writing Direct query, creating relationship between imported entities, derived column, measures,

(visual, page and reports) filters, Role level security using DAX functions

• In-depth understanding of SQL Server Migration and problem management and experience in Publishing and scheduling the report using gateway in Power BI services

• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS

• Good in gathering Business Requirements from business stakeholders, analyzing, documenting System Requirement specification, Functional Requirement specifications

• Ability to work in challenging and versatile environments and strive for excellence

• Flexible and versatile to adapt to any new environment and work on any PROFESSIONAL EXPERIENCE

OraMetrix, Dallas, TX October 2017 – January 2018

Web Analytics Intern

• Digitally promoted company’s website through Google Adwords campaign which increased customer base by 30%

• Developed automation scripts in Google Adwords to extract campaign data in Excel and generate statistical reports

• Utilized SSIS for extracting data from multiple sources to load it into a central repository with some transformations

• Analyzed KPI’s and trends on Piwik tool that helped in increasing market visibility and designed dashboard on Tableau Spectrum, Denver, CO May 2017 – August 2017

PowerBI/Data Analyst Intern

• Imported Sales data from SQL Server Express into PowerBI and managed relationships between facts and dimension tables

• Built effective Sales Report/dashboards using visualizations such as Bar Chart, Line Chart, Donut Chart, Map, Tree Chart, Table and Matrix Visuals, Slicers, Gauge for goal setting etc.

• Utilized Advanced DAX functions to calculate Rolling Average of Sales per week and Running Total of customer base over time

• Finally pushed the report on Cloud (PowerBI Service) and created app for easy access of the report to clients Infosys, Pune, India June 2014 – June 2016

MSBI (SSIS, SSRS, SSAS)/Power BI Developer

Highlights & Responsibilities:

• Good knowledge in preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL

• Hands On experience in Developing multiple kind of Power BI Reports and Dashboards

• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service & Report Server

• Explored & Analyzed data in a variety of ways and across multiple visualizations using Power BI

• Gathered the business requirement and functional specification of the client module with Business Executives & Analysts

• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access

• Involved in Data Scrubbing and Data Cleansing using MDS, DQS

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS

• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance

• Created Dashboard Reports using Power BI and Tableau

• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports

• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data

• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS)

• Migrated an existing SQL Server Database to use Azure Database

• Published Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query

• Managed relationship between Power BI using Schemas such as Star & Snowflake

• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions

• Good knowledge in Data Cleansing using Power Query in Power BI Desktop Editor

• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks

Environment: MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014

(SSAS), SQL Server Reporting Services (SSRS), MDX, DAX, T-SQL, Microsoft Visual Studio 2014, JIRA, MDS, DQS Power BI Desktop, Power Query, TFS, Tableau, Azure, MS Access, ETL, Excel. ACADEMIC PROJECTS

Built Virtual Assistant using Alexa Skill on AWS January 2018 – April 2018

• Built an infrastructure for Alexa on AWS using RDS MySQL DB instance, EC2 instance, VPC with subnets and Security Groups, Lambda function and then finally added Alexa skill to it Business Data Warehousing – QlikView, QlikSense August 2017 – December 2017

• Extracted data from multiple data sources (SQL Server and SQLite) into QlikView to build the semantic layer

• Implemented Dimensional and ER data model for Airbnb database by resolving loops and SQL traps using QlikView

• Developed front end application in QlikView thereby providing insights and recommendation regarding causes of deaths in US High Performance Analytics – SAP HANA August 2017 – December 2017

• Implemented data modeling in SAP HANA and inserted records to analyze Time-Based, Derived and Normal Attribute views, Analytic Views, Calculation Views and Stored Proc with and without input parameters Data Visualization – R, Python, Tableau January 2017 – May 2017

• Used python for web scrapping to extract CSV file for football and analyzed the resultant data using Tableau

• Implemented decision Trees, K-means clustering analysis using R programming and visualized the data in Tableau to provide insights on the survival probability of people on titanic Business Analytics – SAS (E-Miner) January 2017 – May 2017

• Determined whether air pollution is significantly related to Mortality using regression techniques in SAS Enterprise Miner

• Implemented various Descriptive and Predictive modelling techniques such as Regression, Decision Tree, Clustering, Neural Networks to analyze and predict the key factors impacting Housing price in Nashville using SAS Enterprise Miner EDUCATION

The University of Texas at Dallas May 2018

M.S., Information Technology and Management GPA 3.4 Jaypee Institute of Information Technology May 2014 B.E., Electronics and Communication Engineering GPA 3.5 CERTIFICATIONS & TECHNICAL SKILLS

Certifications: Microsoft Certified Technology Specialist (MCTS), Microsoft Certified Professional SQL Server 2012 (MCP) Cloud Services: AWS EC2/ EBS/ ELB, S3, VPC, Route 53, Lambda, IAM, CloudWatch, CloudFront Networking: TCP/IP, UDP, FTP, DHCP, HTTP, IPv4, SSH Analytics Tools: Tableau, QlikView, QlikSense, PowerBI (DAX), SAS (E-Miner), MS Excel (VLOOKUP, Pivot), Google Analytics Softwares: ERWIN, MS Visio, MS Visual Studio, MS Access, ArcGIS, Putty, MS Project, VMWare Databases: SQL Server 2016, Oracle, MySQL, PostgreSQL, SAP HANA Programming: Java, R, Python, SQL, T-SQL, PowerShell Scripting ORGANIZATIONS & VOLUNTEER EXPERIENCE

Intelligence Analytics Society – Member, UT Dallas August 2016 – May 2017

Contact this candidate