Supriya Pandhre

Email: adjry6@r.postjobfree.com Cell: (334) 332 - 4496

PROFESSIONAL SUMMARY

8+ years of experience as a BI Engineer in an Agile environment - proficient in Python, SQL, Power BI, SSIS, SSRS.

Designed and lead the development, maintenance, and enhancements of BI solutions for the team.

Performed Extract, Transform and Load (ETL), data modeling for the Datawarehouse, created visualization dashboards using various reporting tools like Power BI, Tableau.

Strong experience with Data and System Analysis to identify gaps and find alternate solutions.

Gathered requirements and translated them to technical specifications.

Experience in all the phases of Software Development Life Cycle (SDLC) right from designing to presenting and everything in between like coding and testing.

TECHNICAL SKILLS

Languages: MSSQL, Python, C#, BI Data tools (SSIS, SSRS)

Reporting Tools: Power Bi, Tableau

Database: MS-SQL Server 2000/2005/2008/2012 /2016/2019

Tools: Microsoft Excel, MS Visual Studio.NET 2013/2005/2008, SSMS, Power BI, PyCharm, Datawarehouse, Jupyter Notebooks

Azure/AWS Data Engineer Certification in progress

PROFESSIONAL EXPERIENCE

Relias, Cary February 2017 - Present

Sr. BI/ETL Engineer

Responsibilities:

Initiated a product to create a visualization dashboard for the client’s key metrics to show visual trends of their cost and facility utilization in Power BI (DAX queries where required). This also involved creating the data model for the dashboard. This helped the client to understand how our product helped them manage prescriptions and monitor performance along those metrics.

Implemented ETL pipelines to process raw data into our database and Datawarehouse, that involved creating scripts in C#, PowerShell and python. Identified data discrepancies to ensure Integrity and consistency of the data. Reviewed ETL workflows for performance and recommended process improvements. Responding to and resolving load failures and performance issues

Led a high-visibility project where I had to create critical reports and dashboards which involved writing complex SQL queries, stored procedures. Created reports in SSRS and dashboards in Power BI/ Tableau. Created data models using Star and Snowflake schema. This project helped the medical providers (Clients) acquire state-funding for Behavioral health services.

Using Data profiling, implemented various processes to support timely, cost effective delivery of information. Communicated with the team and the Client to determine Project requirements and created technical requirements that aligned with the vision for the product. Mentored other team members with queries, scripts and with the day to day processes.

Collaborated with internal stakeholders to refine requirements, offering consultation/ guidance to client facing team members. Made improvements to BI engineering methods, techniques, standards, policies and procedures by identifying gaps in current processes.

Environment: SQL, SSRS, SSIS, C#, Power BI, Datawarehouse

Measurement Incorporated, Durham October 2015 – February 2017

Data Analyst

Responsibilities:

Created/ maintained tables, stored procedures for the SBAC (Smarter balanced assessment consortium) test using MS SQL 2012, 2008R2. Performed DML/DDL tasks along with creating triggers, pivots, cursors as required.

Optimize SQL queries/ stored procedures for better performance, schedule jobs for periodic runs.

Created reports in SSRS and package sin SSIS to load data into the database.

Create various documents to streamline the processes, tasks.

Environment: SQL, SSRS, SSIS, C#

Angel Broking, Mumbai – India Feb 2008 – August 2011

Software Engineer

Responsibilities:

Involved in the entire software life cycle for analysis, design and development using ASP.NET Framework 3.5 standard web controls for Web form designing. Programming with Front end mark-up code in ASP.net and backend in C#.net. Creation of stored procedures, functions, triggers and optimized queries for performance using SQL Server 2005. Performed search engine optimization (SEO) on websites and worked on the analytics.

Interfaced with the client for requirements gathering, analysis and documentation of business needs for creating various hospital websites. Performed gap analysis to identify the tasks required to be accomplished and formulated a plan of action for providing and implementing customer specific solutions.

Coordinated and interfaced with cross-functional offshore teams to achieve timely completion of the project utilizing project management skills. Conducted regular internal quality control tests to ensure product quality throughout the project lifecycle in order to meet and exceed customer expectations.

Provided turnkey solutions to clients by documenting product specifications to ensure smooth execution and functionality. Coordinate and follow up with clients to address any concerns.

Environment: MS Visual Studio . NET, C#, ASP.NET, MS SQL

EDUCATION QUALIFICATIONS

Post Graduate Diploma in Advance Computing, Feb 2008

Bachelors in Computer Science, March 2006

Contact this candidate