**** **** *** ** ****** Panchal adhgk0@r.postjobfree.com
Rochester, MN 55901 www.linkedin.com/in/darpanpanchal +1-952-***-**** SUMMARY: Working as a healthcare professional with CitiusTech Inc. for their clients on healthcare domain. I have a strong experience developing business intelligence and data warehousing solutions for healthcare, insurance and manufacturing organizations. I have played an important role in projects as onsite coordinator, data analyst and ETL developer across my 11 years of experience.
EDUCATION Graduation: May 2009
B.Sc. Information Technology – Mumbai University, India TECHNICAL SKILLS
Languages : T-SQL, SQL, Python
Database : DB2, SQL Server, Oracle
ETL Tools : Informatica PowerCenter, SSIS, AQT
Reporting Tools : QlikView, OptumOne Analytics, Tableau, SSRS
EHRs : Epic, MICS LastWord, Cerner
Servers : MS Server 2008, UNIX
Miscellaneous : TFS, Jira, Population Health workflows, Epic clarity and Hyperspace platform WORK EXPERIENCE
ETL Developer and Onsite Coordinator CitiusTech Inc (Client: Health Management) May’20 - Current o Analyzing client’s existing BI setup and provide solution to move to Azure Cloud. o Coordinate with cloud architect to set up BI infrastructure on cloud. o Identify and mitigate risks in rehosting client’s reporting solution post separation from parent organization. o Plan to develop a new BI solution using Azure cloud capabilities (kickoff in 2021). o Technologies: SQL Server 2016, SSRS, SSIS
Data Analyst and ETL Developer CitiusTech Inc (Client: Leading Hospital in US) Oct’15 - Apr’20 o Analyzing source data primarily from Epic Clarity to pull data for BI reports. o Developing ETL logic using SSIS, SQL scripts or AQT tool as requested. o Maintenance and enhancements of existing ETL logic and reports. o Identifying and discussing ways of improving patient care using data analytics. o Helping client improve their accuracy in billing for services by supplying supporting reports. o Technologies: SQL Server 2012, DB2, AQT, SSIS, OptumOne, Epic Hyperspace and Clarity database.
Report Developer and Onsite Coordinator CitiusTech Inc (Client: Radiology Solutions) Sept’14 - Oct’15 o Developed BI reports on top of their proprietary imaging software. o Reports measured the performance and utilization of their proprietary software. o Provided their customers with insights on their Radiology system’s health. o Technologies: SQL Server 2008, QlikView.
BI Consultant CitiusTech Inc (Client: Leading Hospital in US) Dec’13 - Sept’14 o Performed requirement gathering to design their enterprise datawarehouse. o Worked extensively in data analysis on their EHR systems. o Involved in designing data models.
o Developed S2T mappings for datamarts.
o Technologies: SQL Server 2008, Excel, Informatica PowerCenter, SharePoint.
ETL Developer CitiusTech India (Client: Healthcare Service Provider) Dec’12 - Dec’13 o Designing and developing ETL logic for their enterprise datawarehouse. o Responsible for monitoring the nightly ETL jobs. o Part of team involved in improving performance of existing ETL to accommodate growing data volume. o Involved in converting legacy ETL mappings developed using SSIS and SQL scripts to Informatica. o Technologies: SQL Server 2008, SSIS, Informatica PowerCenter.
ETL Developer iGATE Solutions (Client: Leading Comm. Equipment Mfr in US) Nov’09 - Dec’12 o Designing and developing ETL for their reporting portal. o Worked with ERP IT team on integrating their new solution to their EDW. o Worked with Level 2 IT support team on fixing their data issues. o Technologies: Informatica PowerCenter, Oracle, UNIX, OBIEE. RELEVANT PROJECTS
Online YellowPages Sem 6 - Apr’09
o This was a prototype developed in line with YellowPages search tool used by customer care representative to navigate through caller’s request.
o This was a telephone service helpful during the times when Internet wasn’t accessible to people in India. o Software involved data entry mechanism and categorizing data into different categories, region and interests. o Technology: Microsoft Access, VB6
EXTRA CURRICULAR
Zonal captain in CitiusTech for Minnesota region wherein I manage organizing social events for Minnesota based employees.
Conducting interviews for ETL positions in CitiusTech.