Dharmeesh**

Sr. SQL BI Developer

469-***-****

ac0xqh@r.postjobfree.com

SUMMARY:

Highly motivated SQL server/BI Lead with around 8+ years of IT Experience having multiple skill set and Extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Power BI, Tableau, Cognos and Microstrategy TALEND (BIG DATA) for building, deploying and managing applications and services through a global network of Microsoft-managed data centers.

Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016.

Worked on Cloudera, Hortonworks Hadoop Distribution Environment.

Expert database engineer, NoSQL and relational data modeling using Microsoft Sql server.

Extensive knowledge of data warehouse methodologies.

Querying using Cloudera Hive for processing of data.

Proficiency in Database design, Coding, unit testing and Implementation.

Strong ability to analyze user requirements, Business Requirement Specifications.

Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2008R2/2008/2005.

Worked in Implementation life cycles of both Agile and Waterfall Methodologies.

Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.

Extensive knowledge in Tuning T-SQL queries to improve the database performance.

Performed data migration using tools like Data import/export, BULK_INSERT and BCP between different heterogeneous systems and SQL Server.

Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages.

Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS.

Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).

Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.

Built a DataWareHouse on SQL Server & Azure Database.

Involved in importing data from large RDMS systems to Hadoop using Sqoop.

Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources.

Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.

Worked on creating Azure Data Factory for moving and transforming the data.

Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations

Worked on Power BI which acts like a cloud service that works with Excel to provide a Self Service BI.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.

Built a Data Warehouse on SQL Server.

Hands on Experience working with to analyze the structured, non-structured data from various sources.

Involved in performance tuning by checking the loads on Indexes by using sql profiler and Tuning advisor.

Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).

Involved in keeping the team focused and on track and also established meeting times, places and agendas.

Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.

Also worked on statistics which are auto created on a table/view basically used in query tuning.

Also have knowledge on various industries like insurance, Finance, Investment banking, Property and casualty insurances, health care, Retail.

TECHNICAL SKILLS:

BI Tools

SSIS, SSRS, SSAS, TALEND, POWER BI

RDBMS Servers

MS SQL Server 2016/2014/2012/2008R2/2005

Operating Systems

Windows, Linux

Programming Languages

PL/SQL, T-SQL, .Net, C#, Java, Ruby, Python, Pig Latin.

Databases

NoSQL, DB2, MySQL, Oracle, SQL Server, Sybase,

Office Applications

MS Outlook, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Configuration Tools

Team Foundation Server (TFS), GitHub

Data Base Monitoring Tools

SQL Monitor from Redgate, SQL Profiler (SQL Server)

PROFESSIONAL EXPERIENCES:

American Psychological Association,Washington,DC Mar 2016 to Current

Role: Sr. BI Developer

Project Description: Project goal was to enrich the membership related data and administrators accelerate their business by optimizing and taking charge of their management, different kinds of insurance liabilities like professor liability, research liability, student liability and casualty processes. The project also involved providing necessary reports for creating data-driven strategies.

Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.

Involved in importing data from large RDMS systems to Hadoop using Sqoop.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.

Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.

Designed SSIS packages to transfer data from various sources like Oracle, text files, XML Files, SQL Server, Excel and Access to SQL Server.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.

Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.

Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.

Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLOOKUP functions and formulas.

Data warehouse, Business Intelligence architecture design and develop. Designed the ETL process from various sources into Hadoop/HDFS for analysis and further processing.

Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.

Worked with Sqoop to import/export data from relational database to Hadoop and flume to collect data and populate in Hadoop.

Creating Managed tables in Hive.

Worked on Azure Data Lake Analytics with Azure Data Lake Store for providing the highest level of performance, throughput, and parallelization of big data workloads

Integration of Data by Orchestrated ETL pipelines, Profiling, SCD, with SQL, SSIS, Azure Data Factory.

Using Power BI Connect live to Analysis Services models – both Tabular and Multidimensional cubes.

Involved in data migration from Oracle to HDFS.

Developed Reports to Visually explore data and create an interactive report Excel and Power BI.

Using a Query Editor in Power BI performed certain operations like Fetching data from different file.

working with import and direct query, creating custom table in the Power BI.

Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.

Working with different transformations, Applied steps in query editor.

Created hierarchies and measures.

By using Power BI Desktop Connected to various Data sources, Working with different visualizations

Worked on Importing custom visualizations.

Worked with table and matrix visuals, Worked with different level of filters.

Used various Data Visualizations with Power BI.

Single row & multi row cards.

Publishing a report to Power BI Services.

Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.

Involved in designing Partitions in Cubes to improve performance using SSAS.

Applied various data transformations like slowly changing dimension, aggregate, lookup, multicasting, conditional split and derived column in SSIS.

Created Tabular model reports to slice and dice huge volumes of data.

Using Tabular model provided more security to data at Row level.

MDX Programming, DAX Expressions, Analysis and Business Forecasts.

Created dimensions by defining Parent-Child relationships, using different dimension types.

Involved in planning, defining and designing star/snowflake diagrams using Erwin on business requirement and provided documentation.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.

Worked on Adding tiles to the dash boards, images to the dashboards using Power BI services.

Created Groups, content packs, Enterprise gateway in Power Bi Pro.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Cloudera, HDFS, Hive, Pig, Sqoop, Azure, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2010, NetBeans, Eclipse, VBScript.

eClincialWorks LLC, Westborough, MA Jan 2015 to Feb 2016

Role: Sr. MSBI Developer

Project Description: Converting the various hospital database Management systems into the eClinicalWorks application database system including the prestigious project like NFL (National Football League), SEAWORLD, etc. involving various other healthcare Software and multi layered architectures. Provided the Exception reports which uses SSRS and Tableau. A multi-year data migration project to bring the Patient data into Microsoft SQL Server based solution.

Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and Sql Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, Sql Server Migration Assistant (SSMA) and SSIS packages.

Worked on Health Data Conversions for NFL (National Football Leagues) and SeaWorld

Generating on demand reports using eBO reporting using SSRS and adhoc reporting using report builder feature in SSRS.

Architected Cubes with PowerPivot, MDX, SSAS.

Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS.

Worked on Azure Data Factory to orchestrate the ingestion of data from various sources like Azure tables, Azure SQL Database, Azure SQL DataWarehouse, Azure Storage Blobs, and on-premises databases to Azure Data Lake Store.

Till now Analyzed around 50 Different Hospital/Patient Database Management systems and provided optimized solutions for handling them better.

Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.

Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.

Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.

Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints & Database triggers.

Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions.

Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.

Involved in using Sqoop for importing and exporting data into HDFS

Unit tested and tuned SQLs and ETL Code for better performance.

Created and maintained Technical documentation for launching HADOOP Clusters and for executing Hive queries and Pig Scripts.

Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).

Deployment of SSIS packages and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.

Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.

Conduct Code Walkthroughs, and perform SSIS/SSRS peer reviews.

Used Team Foundation Server 2010 to check in code artifacts and Techno solutions, Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.

Created database-staging tables for running the QAS batch for Postal Address Validation.

Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012, SQL Server 2008R2, T-SQL, Cloudera, Hbase, HDFS, MapReduce, Hive, Pig, Sqoop, Microsoft Access, SSRS, Azure, Microsoft Excel, VBScript, ERwin 7.2, SQL Server Migration Assistant (SSMA),

Hershey’s – Hersheys, PA Feb 2012 to Dec 2014

Role: MSBI Developer

Project Description: Hershey’s is a leading chocolate producing company in the world and the no1 chocolate manufacturer in USA. This Project involved complete logical and physical design of a database application to the size more than 300 GB of sales and Inventory management. Involved in design, development of database application, implementations, data cleansing, disaster recovery strategies, migration of databases, implementing SSRS and SSIS. It is Basically a One stop for all the need of Business Users.

Gathered business requirements by interacting with the Business Analysts.

Installed and Configured SQL Server 2005

Configured the Window Server for required Service Packs.

Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic

Designed and implemented Stored Procedures and Triggers for automating tasks

Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Compliance Group, Order Flow management (OFO) Group, Network Planning Group.

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Maintain Operators, Categories, Alerts, Notifications, Jobs, and Schedules. Monitor connections, locks and performance of SQL server.

Designing and building data load procedures using MS SQL Server.

Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.

Documented all the procedures and processes for future references.

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, Windows XP, NetBeans, MS Visual Studio 2005.

Broadcom Corporation, Irvine, CA. Nov 2010 to Jan 2012

Role: Sr. ETL Developer

Project Description: Developing a new DBMS system and implementing the packages and reports as per the requirements of the internal departments involving Accounts, Finance and HR. Creating and enhancing the RDBMS systems on existing Payroll/Financial Databases using SQL server 2005/2008 and BIDS (SSRS, SSIS)

Installed and configured SQL Server 2008, SQL Server Integration Services and SQL Server Reporting Services.

Involved in requirements analysis, development, deployment and unit testing of components.

Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).

Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008

Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSRS Packages.

Deployment of SSIS packages to the Production environment.

Create and published various parametrized and cascading reports for the finance and HR department

Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.

Designed and deployed reports with Drill Down, Drill Through, and Drop down menu option, Parameterized, Sub-reports and Linked reports.

Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Involved in optimizing report performance using Report Caching and Snapshots.

Converted Crystal Reports to SSRS reports.

Environment: MS SQL Server 2005/2008, SSRS 2008, T-SQL, SSIS 2008, MS Visual Studio 2005.

IRUS INFOTECH PVT. LTD, Hyderabad, INDIA Aug 2008 to Oct 2010

Role: SQL/Business Intelligence Consultant

IRUS INFOTECH PVT, is a world leader in providing IT consulting and software services to the finest global organizations. The EPM project deals with Optimization of the existing SQL queries to improve the performance of the system and creation of new stored Procedures, Indexes and Triggers for further enhancements.

Installed & Configured SQL Server 2000 for Development Purpose

Migrated certain packages from SQL server 7.0 to SQL server 2000

Created DTS packages to transfer the data from Oracle to SQL Server 2000

Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.

Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).

Performed tune to optimize SQL queries using SQL profiler and query analyzer.

Involved in performance tuning of the database and T-SQL queries using Explain Plan.

Created Indexes, Constraints and Rules on database objects.

Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard.

Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch.

Developed Triggers on Views to populate base tables.

Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.

Create stored procedures and user defines functions to supports efficient data storage and manipulation.

Handling database objects with Enterprise Manager

Provided Technical Documentation for future enhancements.

Environment: MS SQL Server 7.0/2000, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, Windows Server 2000.

Bachelors: Electronics and communication Engineering University of Allahabad 2008.

Contact this candidate