Sql Server Data

Murali

SQL Server BI developer

Ph: 669-***-****

*********@*******.***

Fremont, CA.

Summary of Qualifications and Skills:

Professional experience around 3.5 years in the field of Business Intelligence with expertise in SQL Server Integration services, Analysis and Reporting Services and Power BI, Mdx, Dax queries using TFS in Health care and Insurance, Financial domains.

Good Experience and understanding on Database Development, Data warehousing, modeling, Design and Data Management and Star schema and Snowflake schemas and DataMart’s, Operational Data Store

Experience working in Agile methodology and completing tasks with in Sprints.

Experience to read, analyze, interpret, and prepare technical documents

Good understanding of Kimball methodology of data warehouse.

Good Experience in Power BI for Data Visualization and Interactive drill down reports using slicers and dicers in Power BI and Excel, PowerPivot.

Exposure to cloud based solutions such as Azure on how to create the instances and auto scaling and load balancers and launching databases on Cloud instances.

Launching EC2 instances on amazon cloud service and creating RDS data bases like oracle 11g.

Key Performance Indicators (KPI's) Understand Key Performance Indicators that drive company measurement.

Created and maintained complex SSAS multidimensional cubes and written MDX queries to retrieve the aggregated data from the cubes.

Extensively worked on error handling at different levels of SSIS packages like control flow & data flow level.

Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all.

Deployed the created SSIS packages in Development and Testing environments and executing SSIS packages using C#/.Net scripting.

Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi-cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.

Extensive experience on T-SQL and SQL Server on creating tables, triggers, user profiles, relational database model, data dictionaries, user defined functions, views, and data integrity.

Extensive experience in developing Power BI reports and data visualization from various data sources.

Extensive experience in data migration from different sources including flat files, My SQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008.

Experience in SQL Server and T-SQL (DDL and DML Commands) in Constructing Tables, Normalization Technique on Database table.

Experience in OLTP and OLAP environment that include Production, development and implementation.

Expert in SSRS reports using Drill Down, Drill Through reports, Tabular reports, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets.

Technical Summary

DATABASES:

MS SQL 2012/2014, Oracle 10/11G, My SQL, MS Access

ETL TOOLS:

SSIS and Knowledge on Informatica

Reporting Tools:

SSRS and Power BI, Excel knowledge on Tableau

Analytics tools:

SSAS with Mdx

Data tools:

SQL plus, TOAD, SQL server

Version control

Team foundation server (TFS), GIT.

Professional Experience

Power BI developer Feb 2017 to Date

Mytree, Fremont, CA.

Project: This project is for Baylor health Medical to analyze the patients EMR data and reduce the patients wait and reduce the readmission cost for chronic diseases.

Environment: SQL Server 2016, Power BI, Dax functions. Azure, Tableau, T-SQL, SSMS.

Responsibilities:

Facilitated the sales team by creating a visualization dashboard, which uploads a weekly CSV file, runs analysis using historical data in the data warehouse and visualizes the results using bar & pie charts.

Worked on Power Query in Power BI desktop to edit the queries and Model for data modelling and establishing the relationships.

Worked on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team using Power BI service to create the dashboards.

Installed Power BI azure service pack to analyze the usage of instances in Azure, tried to minimize the number of instances which are not used which reduced the cost

Developed T-SQL Ad-hoc Datasets Analytics for the HealthCare Provider Sunshine Act Compliance Audit.

Implemented real-time responsive reporting solutions with tableau by connecting to the SQL Server database through On-Premise Gateway also used Dax for doing calculated measures and for creating new columns.

Implemented real-time responsive reporting solutions with Power BI, by connecting to the SQL Server database through On-Premise Gateway also used Dax for doing calculated measures and for creating new columns.

BI developer Jul 2016 to Dec 2016

Software Bloc, Plano, TX.

Project: Analyzing Hilton Hotels Financial data from the Peoplesoft ERP system to understand cash flow from order to cash to procure to pay and inventory, treasury and spending analysis in different departments for decision making and cost reduction.

Environment: T-SQL, SSIS, SSRS, MS SQL Server 2012/2014, Power BI, Tableau, Dax, Excel, Power pivot, Power view.

Responsibilities:

Analyzed the OLTP structures and created staging database for ETL process.

Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.

Designed dimensional data model utilizing star schema with multiple facts, slowly changing dimension (SCD) tables.

Created source to target data mappings for the ETL process using SSIS.

Developed number of business oriented reports utilizing Power BI and Tableau.

Developed dashboards with Power BI which display key KPIs for business analysis and decision making.

Delivered business oriented reports with subscriptions in Power BI services.

Design scorecards and different dashboards with slicers utilizing Power BI.

Implemented Power BI PowerPivot for data analysis by developing various aggregation and calculations.

Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.

Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View.

SQL/BI Developer Jun 2013 to Jul 2015

Tech Mahindra, Hyderabad, India.

Project: AAA insurance company is the client who is a largest insurance company operated in North America. Object of the project is to extract the data from multiple sources transform load into data warehousing and creating cubes on the top of these cubes and create reports to better understanding the business flow.

Environment: T-SQL, SSIS, SSAS, SSRS, MS SQL Server 2012/2014, Power BI, Tableau, Mdx, Dax, Excel, Power pivot, Power view, C#/.Net framework, TFS.

Responsibilities:

Wrote complex SQL queries using all kinds of joins, sub queries to retrieve data from the database.

Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data marts.

Extensively worked on error handling at different levels of SSIS packages like control flow & data flow level.

Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all.

Deployed the created SSIS packages in Development and Testing environments and executing SSIS packages using C#/.Net scripting.

Developed custom reports and deployed them on server using Power BI

Used slicers and dicers in the Power BI reports to slice the data as per the dimensions like location, time, data from the highest to lowest level granularity to analyze the data.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.

Involved in Installation, configuration and setting of Database servers for various test and development environments.

Created partitions and designed aggregations in Cubes.

Created perspectives in SSAS and configured security levels for the Cubes.

Written MDX Queries on the top of the cubes and used MDX functions like YTD, MTD, FILTER, NONEMPTY, QTD to retrieve the data for desired granularity.

Connected SSAS database to Power BI to analyze the data from the cubes and imported it onto Power BI service to analyze and publish onto Power BI mobile apps which are installed on the marketing people Android and IOS devices by enforcing security layers.

Designed KPI's in SSAS and imported them to Excel.

Responsible for Query optimization and Performance tuning.

Responsible for debugging and troubleshooting issues, as well as production support.

Interact with Business users, collect requirements and perform documentation.

Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.

Database Engineer Intern

Ad-hoc Solutions, Hyderabad, India Oct 2012 to Feb 2013

Environment: SQL Server 2008/R2, T-SQL Procedures, Functions, Triggers.

Responsibilities:

oResponsible for providing technical support for database environment, assessing and implementing new technologies. Assisted development team with data issues. Designing and implementing database warehouse schema and OLAP operations. Developed various database objects (stored procedures, tables, triggers, etc.). Worked on tools like SQL Server, MySQL.

Education:

Bachelors in Electronics and communication engineering 2013 from JNTU University.

Masters in Computer science from Class of Dec 2016 with 3.57 GPA.

Contact this candidate