Nakul Vanga
Charlotte,NC
Summary
Results driven SQL developer with over 3 years core skills in business intelligence reporting and relational database management systems in health care domain with experience in processing large scale stores of organized and disorganized data into harmonious and accessible business intelligence tools. Proven ability to prioritize requirements in agile environments and optimize ETL process, ensuring data accuracy and insightful visualizations for executive leadership.
Overview
7
7
years of professional experience
1
1
Certification
Work History
SQL/BI Technical Consultant (Remote)
Xybion
10.2024 - Current
- Built and tested numerous client clinical management reports converted from legacy database to EPIC clarity reports using SAP Crystal report 2008.
- Interfaced Xybion Emidence Medical billing workflow with EPIC application.
- Pulled large amount of provider activity from many EPIC modules (ex: Attending, Visit, Admit, Discharge, Consulting, Episode of care, Treatment Team, Surgeon/Op time) and deployed reports to SSRS server.
- Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
- Formulated stored procedures to perform index maintenance and data profiling for loading
data marts and generated report datasets. - Defined data sources and data source views for OLAP cubes utilizing SSAS.
- Created laboratory instrument interface parsing profiles using in-house MIDAS application and T-SQL queries.
- Created SSIS packages to Extract-Transform-Load (ETL) from transactional system (OLTP) to analytical system (OLAP).
- Created various complex reports using Crystal Reports XI R2.
- Optimized SQL queries to make the report run faster.
- Enhanced and modified existing reports by creating new parameters and formulas.
- Scheduled reports using Info view to run reports as per business user requirements.
- Assist business for setting up the security profiles on enterprise.
- Responsible for setting up the database logon info and parameters on info view for the users to run the reports.
- Created Views/Stored procedures to generate test data for reporting purpose.
- Modified existing reports by adding new logic as the line of business changed periodically.
- Migrated reports from development environment to UAT and Production environments.
- Created reports with parameters, Sub reports, cross tabs, charts, Running totals, Sub totals and embedded linked and unlinked sub reports using Crystal reports.
- Created nested, conditional subgroups and formatting features in reports.
- Developed Sub reports called from the main report to implement the business logic.
- Responsible for defects raised during the testing of the reports.
- Assist UAT team in testing reports and advise them with necessary changes.
SQL BI Analyst
Children’s Hospital of Philadelphia
09.2023 - 10.2024
- Created clinical reports for Electronic Health Record (EHR) summaries, including patient histories, treatments, and outcomes.
- Involved in testing and upgrading of reports to EPIC 2016 for CHOP health system.
- Responsible for extracting and organizing patient information from EPIC's patient queue system.
- Queried business analysts and end user teams to define intelligence needs, structuring subsequent information gathering efforts accordingly.
- Prioritized requirements to be developed according to Agile methodology.
- Created Financial reports for revenue and expense tracking across practices and generated reports for billing and payment information.
- Designed customized data collection models for specific visualization tasks.
- Created dashboards to monitor and track key performance indicators.
- Created tables, stored procedures, views, indexes, Triggers, Constraint, temporary tables and
user-defined data types and functions using T-SQL. - Worked on all activities related to the development, implementation, administration, and
support of ETL processes for large-scale data warehouses utilizing SSIS. - Conceptualized the data migration strategy to populate the data mart with facts and
dimensions tables. - Ensure data accuracy and consistency through data cleansing and validation.
- Developed and maintained Power BI reports and dashboards for various departments within
the organization. - Created data visualizations using pie charts, trends, gauges, and scorecards in Power BI to
effectively communicate key business metrics and insights. - Developed metrics and created calculated columns and measures using DAX and established KPIs to report the state of the business to the executive team.
- Created dashboards to track Financial KPI's such as Average treatment costs, Claims denial rate, Insurance claim processing cost and operational margins.
- Published Power BI reports to Power BI Services and shared them with other teams.
- Designed & developed ETL jobs or extracts to pull the data from multiple sources required for
the Visualizations. - Implemented row-level security and groups to restrict data access in Power BI reports.
- Optimized reports with modifications to embedded queries and/or stored procedures.
Junior Data Analyst
RWJBarnabas Health
01.2023 - 09.2023
- Interacted with business users and performed Gap analysis of user requirements.
- Prepared business requirement document and converted to functional requirement specification.
- Developed reports against EPIC Clarity and Caboodle data warehouse linking Employee health database tables.
- Design, develop, publish and support reports and run back end code for many EPIC areas and data models.
- Generated high level Tableau based dashboards with aggregated data on admissions, finances, departmental metrics, and facility performance for strategic decision making.
- Created dashboards to track operational KPI's such as average length of stay (ALOS), patient room/bed turn over rate, ER wait time, ER duration of treatment.
- Worked with report development manager on requirements and worked on the delivery timelines and technical delivery.
- Utilized Tableau to link data from different connections together on a single dashboard and to filter data in multiple views at once.
- Designed data mart and data warehouse using StarSchemas.
- Created Tableau server backups using Tabadmin utility.
- Experienced with creation of user, user groups, projects, setting up active directory users, giving appropriate permissions for viewing published dashboards and scheduling data refresh.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Utilized SQL Profiler to performed root cause analysis for the tickets assigned in JIRA.
- Assisted business analysts and content developers in leading design reviews to create a
proof of concept for the entire project. - Converted business needs into technical stories to be picked up in the sprint for
development. - Analyzed raw data from various sources and created data models for data transformation.
- Utilized SSAS tabular models, SSAS Cubes, SQL databases, SQL data warehouses, Excel, CSV.
- Created joins and views in the database for better consumption of data for reporting.
- Conducted performance tuning and optimization of reports for enhanced user experience and reduced latency resulting in better productivity through faster insights.
- Created Data Dictionary and Data mapping document for the existing dashboards to provide
an in-depth understanding of the dashboards.
Accounting Clerk
Goddard School
12.2021 - 05.2022
- Created detailed expense reports to facilitate reimbursement for business expenses incurred.
- Input monthly invoices with consistent accuracy.
- Maintained accounting records utilizing in-house and client systems.
- Managed accounts payable and receivables and payroll.
- Identified and resolved internal accounting variances, promoting data accuracy.
- Managed and responded to correspondence and inquiries from customers and vendors.
- Tracked financial progress by creating quarterly and yearly balance sheets.
Student Assistant (Desktop Support)
Rutgers University
09.2018 - 03.2020
- Tested added functionalities for any bugs in Rutgers applications such as web mail and course elections prior to deployment.
- Created user accounts and assigned permissions.
- Responded to customer inquiries and provided technical assistance over phone and in person.
- Configured hardware, devices, and software to set up work stations for employees.
- Sorted and routed mail and packages to recipients.
- Generated performance and trend reports and filed paperwork.
Education
Bachelor of Science - Political Science/History
Rutgers University
New Brunswick, NJ12-2023
Skills
- C#Net, T-SQL, PL/SQL
- MS SQL Server 2019/2017/2016, Oracle 10g/9i/8i
- SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS)
- Power BI Report Builder, Tableau, Crystal Reports XI/9
- EPIC 2012/15 (Clarity, Caboodle data warehouse, EPIC-Crystal integration)
- JIRA, Agile, Waterfall and Scrum methodologies
- Bitbucket, Git Hub
- Visio, MS Word, MS Excel, MS Access and MS Project
- Azure Stretch databases
Professional Summary
- Participate in software solutions deployment from the beginning to the end based on the Software Development Life Cycle.
- Experience with data analysis, data modeling and data presentation and importing data from SQL Server and Oracle DB to Power BI/Tableau to generate reports.
- Experienced in business intelligence development in EPIC reporting workbench.
- Worked on Clarity component database models for reporting and analytics in EPIC EHR (Electronic Health Record) software.
- Experienced with EPIC Crystal integration for Crystal reports, EPIC template creation, EPIC report creation, Validated report output accuracy against EPIC charts.
- Maintained, enhanced, and administered data dictionaries, physical and logical database models.
- Developed complex reports, visualizations, dashboards and supported the existing reports using SQL Server Reporting Services (SSRS), Power BI and Tableau based on the end user requirements.
- Designed and developed secure data lake systems, ensuring scalability and security.
- Demonstrated strong scripting skills, essential for complex database operations and automation.
- Developed a deep understanding of legacy architecture, system dependencies, and data relationships.
- Leveraged extensive experience with SQL Server 2016 and above, ensuring optimal database performance.
- Applied expertise in T-SQL and Stored Procedures to develop efficient database solutions.
- Experienced in handling large datasets from multiple sources for insurance claims, insurance KPIs , blend, manipulate and transform data according to business analytics needs.
- Built and deployed complex, scalable SSIS packages for ETL and data processing from multiple source systems.
- Utilized database troubleshooting, performance tuning, and optimization experience.
- Ensured data integrity and security across all database systems and migrations.
Certification
Microsoft - Power BI Data Analyst Associate
Microsoft - Azure database associate
Timeline
SQL/BI Technical Consultant (Remote)
Xybion
10.2024 - Current
SQL BI Analyst
Children’s Hospital of Philadelphia
09.2023 - 10.2024
Junior Data Analyst
RWJBarnabas Health
01.2023 - 09.2023
Accounting Clerk
Goddard School
12.2021 - 05.2022
Student Assistant (Desktop Support)
Rutgers University
09.2018 - 03.2020
Bachelor of Science - Political Science/History
Rutgers University
Similar Profiles
SOWNDHARYA JSOWNDHARYA J
LEAD DATA ANALYST at XYBION INDIA PRIVATE LIMITEDLEAD DATA ANALYST at XYBION INDIA PRIVATE LIMITED
SOWNDHARYA JSOWNDHARYA J
LEAD DATA ANALYST at XYBION INDIA PRIVATE LIMITEDLEAD DATA ANALYST at XYBION INDIA PRIVATE LIMITED
Balakumaran GSBalakumaran GS
Marketing Manager at Xybion CorporationMarketing Manager at Xybion Corporation