G Pratik

MSBI Developer

ac80jw@r.postjobfree.com

PROFESSIONAL SUMMARY

Highly motivated, solutions-driven software professional with around 7 years of strong experience in Software Design, Data Modelling, Dashboard Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Healthcare, Insurance Academic and Finance industries etc.

Hands-on star and snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts,, Data Mining and Analytics, Data Marts and OLAP technologies.

Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modelling, Normalization and De-Normalization techniques for both OLTP and OLAP systems

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) using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI.

Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.

Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).

Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)

Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.

Experience with advanced Power BI topics such as complex calculations, table calculations, geographic mapping, performance optimization

Experience on publishing Power BI reports on dashboards in Power BI server

Designed and developed Power BI graphical and visualization solutions based on business requirement

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.

Experience in Production/Customer Support, Deployment, Development and Integration.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules with quick learning capabilities.

Enjoys working in collaborative team environment and produced qualitative results independently with minimal supervision.

Excellent team management skills with Onsite-Offshore work co-ordination, good business acumen, effective communicator with Business Users and Senior Managers and Executives.

EDUCATION

Master of Science in Computer Science January 2017 Fairleigh Dickinson University, New Jersey

Coursework: Data warehousing and data mining, DBMS, Software Engineering, Data Analytics (Hadoop and R), Advanced Business Process Management

Bachelor of Science in Information Technology May 2013

Shridhar University, India

TECHNICAL SKILLS

BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Self BI with Excel

ETL Tools

SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI).

Databases

MS SQL Server 2005/2008/2012/2014, Oracle 10g, Teradata

Database Query Tools

SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013, SQL Profiler, DQS, Toad for SQL server

Web Technologies

JavaScript, HTML

Others

HP ALM, TOAD, SQL Loader, MS Office, Smart FTP, Ultra Edit, Auto system, Unicenter, Control-M, Quality Center, MS. Visio,

Operating Systems

Windows NT 4.0, Windows 95/98/2000/XP, HP Unix

SQL Programming

SQL, TSQL, PL/SQL

Statistical Tools

MS-Excel, MS-Office

PROFESSIONAL SUMMARY:

NYC Health and Hospitals Corp (HHC), NYC, NY June 2018 - Present

MSBI Developer

Description: The project involved in maintaining data collections, designing ETL packages and creating monthly and weekly reports for the business user and the management team with SSRS.

Responsibilities:

Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.

Used SQL Server Integration Services (SSIS) and migrated data from heterogeneous sources and legacy systems (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.

Designed and tested packages using SSIS utilizing checkpoint, logging, breakpoint, and transaction optionsfor tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion for each Loop Container.

Intensively worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS and worked with Web Service task where some of the binary files will be converted into XML element to place in Message Broker queue.

Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.

Performed incremental loading from source systems, like SQL Server, into data warehouse & data marts using a combination of techniques including T-SQL, Slowly Changing Dimensions(SCD), and Change Data Capture(CDC)

Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.

Created stored procedures, Cursors, Joins in T-SQL.

Created a variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, and configured report server

Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions

Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.

Created sophisticated calculated members using MDX queries and designed and created aggregations to speed up queries and improve performance in SSAS.

Involved in designing and publishing visually rich and intuitive Power BI dashboards

Planned, coordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse database while ensuring data integrity.

Experience working with XML documents, strong report/dashboard design experience and passionate practitioner of effective data visualization.

Environment: Microsoft SQL Server 2014, Microsoft Excel, SSIS/SSRS/SSAS, ETL, Microsoft Office, MS VISO, Profiler, C#.net, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server.

Schlumberger, Houston, TX Feb 2017 - June 2018

SQL BI Developer

Description: The primary goal of this project was to create SSIS packages to integrate the data contained in various external file systems and SQL server database and to generate the reports using SSRS.

Responsibilities:

Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.

Troubleshooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs.

Worked on the fixing the bad data in Legacy Tables in batches, created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.

Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS

Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.

Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables with high level SSIS package execution.

Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in SSIS

Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.

Worked on development and implementation of SSAS cube dimensions and their deployment and production support.

Worked on Development and implementation of SSRS reports and ran them as per the requirement.

Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.

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

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.

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

Published Power BI Reports in the required origination's and made Power BI Dashboards available in Web clients and mobile apps.

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

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

Celgene, Summit, NJ Feb 2015 - Dec 2017

SQL BI Developer

Responsibilities:

Developed Stored Procedures, Views, user defined functions, encrypting database tables with column encryption using DES algorithm, Temporary Tables, and table valued parameters and Common table expressions as per the requirement.

Used XML datatype extensively and performed DML operations on the given XML data.

Experience in creating SSIS packages, deploying the packages to production server using BIDS package deployment wizard and SQL server data transformation services new deployment wizard available with SQL server 2012.

Experience in developing SSIS packages for administering SQL server.

Worked on different types of control tasks of SSIS like WMI data task, MSMQ task, Web service task, Script task, Ftp task to upload and download files, worked with different types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also used XML task to validate XML files and XSLT for generating html pages from XML.

Worked on different kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and UnPivot.

Excellent report creation skills using Microsoft SQL Server 2005/2008/2012 using Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created different types of reports which involve more number of groupings and multi-value parameters.

Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.

Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005/2008/2012 (SSAS).

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers

Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.

Worked very closely with Business Customers, End Users and resolved any business process related issues

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

Legit Infomatics Pvt Ltd, Mumbai, India Feb 2013-Dec 2014

SQL Developer

Responsibilities:

Involved in review and finalizing the technical specifications of source-target mapping documents

Communicated with the Business Users to understand the requirements.

Created reports for calculating the number of hours scheduled and the calculations made for the payment.

Generated periodic reports from the cube based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).

Deployed and configured the reports in the Report Server.

Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008

Wrote complex correlated sub queries to generate reports.

Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible

Environment: SQL Server 2008, SSRS 2008, SSAS, Visual Studio 2008, XML, XSLT, MS Office and Visual Source Safe.

Contact this candidate