Data Developer

Contact

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

www.linkedin.com/in/ravi-v-patel-

a75537169 (LinkedIn)

Top Skills

SQL

Data Warehousing

Business Intelligence

Ravi V Patel

Business Intelligence Developer at NYC Department of Health and Mental Hygiene

New York City Metropolitan Area

Summary

Experienced Business Intelligence Developer with a demonstrated history of working in the hospital & health care industry. Skilled in SQL, Python, SQL Server Integration Services(SSIS),Power BI,Databases, Data Warehousing, and Data Visualization, and SQL Server Reporting Services(SSRS). Strong information technology professional versatile in Data Analysis and ETL.

Experience

NYC Department of Health and Mental Hygiene

Business Intelligence Developer

March 2019 - Present (1 year 11 months)

Greater New York City Area

• Analyze and Maintain sensitive clinical and non clinical data for the bureau.

• Build and Maintain Dynamic Data Pipelines using SSIS(including C# custom scripts)

• Develop SSRS and PowerBI reports and dashboards for internal and external users using multiple different DataSources (Amazon Redshit,Azure,Salesforce,etc).

• Gather requirements from business stakeholders to develop insight on various health care data.

• Ad hoc analysis and reporting.

• Develop and Optimize Stored Procedures.

• Utilize R,Python, and SQL to effectively solve business problems.

• Perform minor DBA work for on premise Servers.

• Maintain DW design for data coming in from various sources including Salesforce

• Maintain Salesforce data integrity and Perform minor SF Admin tasks Maimonides Medical Center

Jr Business Intelligence Developer

June 2015 - February 2019 (3 years 9 months)

Brooklyn, New York

Page 1 of 3

•Design, develop, test, and deploy MS SQL Server Analysis Services (SSAS) tabular and multi-dimensional models

•Deliver enterprise BI solutions using Microsoft SQL 2012, SQL 2014 Microsoft BI stack (SSIS, SSAS, SSRS), I-Dashboard.

•Create cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.

•Support the design, planning, implementation, administration and maintenance of the business intelligence platform. TRAC Intermodal

Junior SQL Developer

October 2014 - May 2015 (8 months)

Princeton NJ

•Provided day to day production support of the in-house applications from a MS SQL perspective

•Responsible for gathering, compiling and synthesizing information into a data warehouse that will be used to manage and support business decisions.

•Developed the BI Data Warehouse data flows and processes based on requirements for the data warehouse and application interfaces.

•Designed and implemented data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views) MMIT (Managed Markets Insight & Technology)

QA Intern

March 2014 - July 2014 (5 months)

Yardley, Pennsylvania

•Worked closely with both the business (User/Marketing/Analyst) and development teams to resolve issues such as Requirement Gaps, Design Documents, System Demo, and Defect Resolution.

•Participated in the creation of QA Traceability Matrix by contributing daily project status, estimated Test execution competition.

•Tracked Defects with Severity, resolved defects and change status in Quality Center 10.0.

•Used SQL Script in a SQLPLUS utility to test data validation and designed SQL Query using Join, subquery, and view to perform Transaction Testing. Education

Page 2 of 3

North Brunswick Township High School

Page 3 of 3

Contact this candidate