Harsh Chheda

adjq55@r.postjobfree.com

727-***-****

MSBI Developer

Summary:

•7 plus years of experience in Microsoft SQL Server 2016/ 2014/2012/2008 R2/2005 with an emphasis on design, development, enhancement, and automation, tuning and optimizing databases for high Availability, Performance and Security.

•Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

•Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.

•Familiarity in Huge Data Migrations, using SSIS, Bulk Copy Program (BCP) and Bulk Insert (BI).

•Highly proficient in packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.

•Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.

•Extensively worked on Control Flow Tasks such as For each Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task and Send Mail Task.

•Strong experience with T-SQL (DDL & DML) in implementing and developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, Indexes, User Profiles and Relational Database Models.

•Experienced in BI Development and Deployment of SSIS packages from MS - Access and Excel.

•Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, for source stream extraction, cleansing, and consumption publishing across multiple user bases.

•Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server.

•Excellent experience in designing and developing stylish and complex reports like reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and ad-hoc reports using Global variables, Expressions and Functions for Business Users using SQL Server Reporting Services (SSRS).

•Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

•Experience in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services SSAS 2005/2008/2208R2.

•Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.

•Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.

•Designed user defined hierarchies in SSAS including parent-child hierarchy.

•Hands on experience in working on SQL Server 2005/2008R2/2012/2016 databases, Azure SQL, Azure Data Factory &Azure Data Lake.

•Design, Developed, Tested and maintained Tableau Functional reports based on user requirements

•Familiar with database normalization in database designing. Adept in creating ER diagrams and mapping the data into database objects.

•Experience in Data Validation, Data Reconciliation, during data migration where the target data is compared against original source data to ensure that the migration architecture has transferred the data correctly

•Experience in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).

•Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.

•Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

•Involved in coding new and maintaining current business applications and systems using SQL.

•Experience in developing testing and debugging.

•Excellent interpersonal skills with problem solving and analytical skills.

•Strong communication skills (oral and written) along with good organizational skills.

TECHNICAL SKILLS:

Languages

T-SQL, PL/SQL, C, C++

Operating Systems

MS-DOS, Windows Server 2012/2008/2003/ XP/NT 4.0/98/95, UNIX

Database Tools

MS SQL Server 2016/2014/2012/2008 R2/2005, Oracle 11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database, Azure SQL

Data Warehouse Tools

SSIS, SSRS, SSAS 2016/2014/2012/2008 R2/2005

Data Modeling Tools

Power Designer, MS Visio, ERWIN

Reporting Tools

MS Reporting Server(SSRS), Excel Power View

Packages

MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS), Microsoft Performance Point Server

Work Experience:

Arbor Realty Trust-Uniondale, NY Nov 2018 to present

Role: MSBI Developer

Responsibilities:

•Extensive Experience in Agile Methodology, starting from SCRUM, business requirement gathering and analysis to testing and deployment.

•Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB Triggers and Indexes.

•Worked with the internal development team to provide the necessary SQL, PL/SQL, and other database management scripts to enhance, tune, related development activities.

•Worked on SQL performance tuning and done unit testing to check the performance on the changes made in the backend reflecting in the front end of the application.

•Developed, fixed bugs, tested and deployed SSIS packages using SQL Server 2016/2014/2012/2008 R2 Business Intelligence Development Studio.

•Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription Reports.

•Strong knowledge of Data Warehousing methodologies, concepts and implementation of Star Schemas, Snowflakes Schemas, Facts & Dimensions.

•Developed reports with consistent drill-down functionality including Drilldown report and Summary report.

•Working with management, developers and end-users participated in the design and implementation of databases to support the commercial side of the business.

•Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages.

•Migrate existing data into the Power BI.

•Created new cubes and modified existing cubes using SSAS 2008 to make data available

•Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

•Used DAX for creating Calculated columns and Calculated measures.

•Created many dashboards in Power BI using DAX expressions and deployed them using content pack.

•Designed and deployed rich graphic visualizations with Drill Down and Drop down menu option and parameters using Tableau

•Developed Tableau Data visualization using Cross tabs, Heat maps, Box and whiskers chart, Scatter plot, Geographic map, Pie chart, Bar chart and Density map

•Utilize Tableau Server to publish and share report with the business users

•Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.

•Creating Azure Data factories for loading the data to Azure SQL database from Cosmos platform.

•Experience in Dimensional Modeling, ER Modeling, FACT, Dimensional Tables and Operational Data Store (ODS).

•Successfully migrated data from several SQL Server databases to the oracle database by using PL/SQL, SQL.

•Analyzed source OLTP systems and created data mapping documents for the ETL process.

•Designed T-SQL scripts to identify long running queries and blocking sessions.

•Created SSIS templates for developing SSIS packages in such a way that they can be dynamically deployed in to development, testing and production environments.

•Involved in creating, modifying and troubleshooting SSIS packages.

•Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS

•Expertise in Relational Database Management Systems, including Normalization and De-Normalization Techniques, Constraints, Querying, Joins, Keys, Functions, Data Import/Export and Cursors.

•Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.

•Used JIRA as project management system and worked in AGILE environment.

•Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.

•Implemented transactions at package and task level in SSIS to meet the business requirements.

Environment: SQLServer2016/2014/2012/2008R2, Microsoft Access, SSIS, SSRS, SSAS, MS Azure, Microsoft CRM 2016/2014,Excel (VLOOKUP’s, Pivot Tables), MS Visual Studio 2015,Dashboards, Windows 2008, Windows XP, Oracle.

Sirius XM,Irving TX April 2017 to Oct 2018

Role: MSBI Developer

Responsibilities:

•Worked on Full life cycle development (SDLC) involving in all stages of development.

•Involved in system study, analyze the requirements by meeting the client and designing the complete system.

•Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

•Involved in Analyzing, designing, building, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.

•Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.

•Developed complex SQL Server (T-SQL) queries with Sub Query, Derived Query, Joins, Union, CTE, Stored Procedures, Functions, Views, Triggers, Dynamic SQL etc.

•Used SQL Profiler to estimate the slow running queries and Database Tuning Advisor for performance tuning purpose.

•Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.

•Involved in developing ETL for loading data into Database.

•Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.

•Worked with various SSIS control flow tasks and data transformations like Data Conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.

•Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer

•Created SSIS Packages to load variety of large volume data into data warehouse from different sources like CSV files, Text files and Excel Spreadsheets.

•Creating Packages on SSIS by using different Data Transformations like Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute SQL Task to load data into data warehouse.

•Worked extensively with Advance Analytics action, Calculations, Parameters, Trend lines, Statistics and Table calculation in Tableau

•Responsible for creating calculated fields, combine field, bins, sets and hierarchies using Tableau Desktop

•Involved in creating graphs by using measures and dimension data from various databases using data blending concept

•Successfully migrated data from several SQL Server databases to the oracle database by using PL/SQL, SQL

•Loaded data from flat files to oracle database and migrated from older oracle versions

•Data Factory for on-perm to Azure SQL and Azure SQL to Microsoft Cloud Internal Implementation COSMOS.

•Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.

•Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.

•Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.

•Used Report manager and Power BI to deploy reports, schedule reports and created groups and users.

•Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.

•Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

•Wrote complex SQL Queries using multiple joins for creating reports using Report builder based on the requirements.

•Designed SSIS packages to load data from source to Data Warehouse.

•Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.

•Created mappings and workflows as per the business requirement.

•Designed and Implemented plan for the moving data to various destinations.

•Designing Logical and Physical Data Model with Erwin r7.

•Worked on analysis of the data and develop plan based on the ETL specifications.

Environment: Microsoft SQL Server 2014/2012/2008/ R2, Data stage ETL, SSDT, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Power BI, Profiler, Visual Studio, Microsoft TFS, BIDS.

LA HEALTH CARE, Los Angeles, CA Aug 2015 to Mar 2017

Role: MSBI Developer

Responsibilities:

•Created Tables, Views, Users, Logins, Indexes, check constraints and business rules using T-SQL and maintained databases.

•Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat File Source, Transformation etc.

•Created SSIS packages to get data from different sources, consolidated and merged into one single source.

•Created detailed design and requirements documents with logic to help team members understand the requirements and design.

•Designed and implemented Relational Databases, Data Marts and Developed Reports to allow users to easily access data.

•Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.

•Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

•Involved in using TFS to check in and check out SSRS reports

•Performed Query optimization & Performance Tuning.

•Resolved and closed the Production tickets generated due to failure of daily incremental production jobs and provided on call support for Production issues

•Developed reports with consistent drill-down functionality including Drilldown report and Summary report.

•Healthcare Payer System - Health Trio - Claims Processing and Monitoring of daily operation

•Implemented and maintained all EDI payer files for private, Medicaid and Medicare insurance plans

•Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.

•Used SSRS to Create, Execute and Deliver Tabular, Matrix and Charts Reports.

•Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived Column, SQL Execution Task, Variables and Error Handling before loading data into the Data warehouse.

•Designed custom Dimensions and Facts Tables to extend data warehouse.

•Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.

•Involved in Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.

•Conducted system tests, troubleshoot customer issues and correct database defects.

•Created, tested and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.

Environment: MS SQL Server 2014/2008, SQL server Reporting Services 20014, SQL Server Management Studio, MS Excel, T-SQL.

GE Aviation, Cincinnati, OH Jan 2014 to Jul 2015

Role: MSBI Developer

Responsibilities:

•Worked on T-SQL programming, stored procedures, user defined functions, cursors, views, and management of linked servers to non-SQL server database.

•Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL to MS SQL as well as Created interface stored procedures used in SSIS to load/transform data to the database.

•Createdseveral Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.

•Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.

•Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.

•Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

•Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

•Used agile methodology for the development.

•Used SSIS jobs for importing data from the flat files that brings the data to the application tables.

•Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.

•Created reports by dragging data from cube and wrote MDX scripts in SSRS.

•Generated KPI for customer satisfaction survey results.

•Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.

•Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

•Used Team Foundation Server (TFS) for source control, and data collection.

•Created parameterized Reports using Charts, Cross-Tab and Sub-report types.

•Worked on SQL *Loader to load data from flat files obtained from various facilities every day.

•Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Axis Bank, Mumbai, India Sep 2012 to Dec 2013

Role: MSBI Developer

Responsibilities:

•Worked closely with BA, DBA to analyze business model, gather project requirement, and translated user requirements into conceptual, logical and physical data models.

•Developed, modified, and optimized complex queries to data retrieval and modification.

•Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

•Create and test DTS packages for importing and exporting data from data warehouse.

•Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.

•Created triggers and audit tables in order to capture the incremental data from OLTP and created complex stored procedures to perform data profiling in the pre-staging database.

•Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

•Scheduled replication on the databases.

•Actively participated in meetings to decide backup policies for database & perform back up operations on databases.

•Performed Join operations using on large scale database tables.

•Extracted data from Oracle DB using Import Export Wizard in SQL Server Management Studio.

•Used tools such as SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

•Documented the procedures and process.

•Tuned and Optimized SQL Queries using Execution Plan and Profiler.

•Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: SQL Server 2008/2005/2000, Windows Server 2003 R2 Enterprise.

Contact this candidate