SUMMARY

• Data/BI Engineer Over 5 years of experience in data analytics, driving BI roadmap, architecting, data acquisition, metric generation and visualization. In - depth working background in data modelling, ETL, OLTP and OLAP systems. Expertise in multiple ETL tools, reporting and data visualization tools, databases and architecting self-service analytics. Comprehensive experience in QlikView scripting, visualization and QlikView Management Console tasks
• Advanced knowledge of healthcare terminology, EHR systems, practice management systems, scheduling systems and billing systems. Expertise in using SQL Server Reporting Services (SSRS) to install, configure, develop and deploy reports.
• Experience in Tableau Desktop, Server, Reader, Public and Mobile for various versions of Tableau v2018.x and Tableau 10.x. Skilled in building source marts and subject area marts for extracting, transforming and loading data from multiple sources into an enterprise data warehouse. Experience in developing SSIS packages for company-wide custom logging and error handling
• Proficient in design and development of various dashboards, reports utilizing visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other, making use of actions and expressions according to the Business requirement. Skilled at internal and external collaboration with corporate stakeholders to drive actionable data insights
• Hands-on experience with scripting languages like python, shell scripting.

TECHNICAL SKILLS

Database: Microsoft SQL Server, DB2, Oracle

ETL Tools: Microsoft SSIS

Reporting and Visualization Tools: QlikView, Tableau, SAP Crystal Reports, Microsoft SSRS

Programming Languages: SQL, T - SQL, Oracle PL/SQL, .Net, Java, C/C++, Python

PROFESSIONAL EXPERIENCE

Data/BI Engineer Business Analytics

Confidential, Asheville, NC

Responsibilities:

• Directly responsible for requirement gathering and analysis, profiling source data, building ETL data pipeline and visualization. Developed self-serving QlikView dashboards using an iterative process which produced high-level KPI/metrics for senior management, provided improved insight of data and processes, and resulted in a 30% increase in performance and an 11% increase in revenue
• Built the data governance dashboard to measure server performance, frequent errors and user sessions, producing a 15% improvement in overall server performance. Created client-centric metric visualizations that directly resulted in a 16% increase in dashboard adoption. Developed data models with QlikView script and a data warehouse through source marts and subject area marts
• Interfaced with company stakeholders and external vendors for source data collection, building metrics, KPIs and data validation. Collaborated interdepartmentally to identify primary business questions and standardize key metrics and measurements; developed business rules, prepared test case scenarios and performed unit testing
• Analyzed assigned business requirements and tasks to estimate the feasibility, costs, time and labor necessary to design and implement a complex technical solution; created the design documentation for this project.

Data Engineer/Mission Medical Associates Finance

Confidential, Asheville, NC

Responsibilities:

• Designed, implemented and maintained database schemas, ER diagrams, data modeling, tables, functions and triggers, constraints and indexes. Utilized ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into a data warehouse and an operational reporting database. Worked closely with team members to support daily operation of the practice management systems and related applications; worked extensively on error handling
• Implemented SSIS package security; executed, managed and monitored SSIS packages
• Developed datasets to perform reporting which included interactive drill down reports, report models and ad-hoc reports; built tabular, cross-tab, charts, parameterized, cascaded and sub-reports using SSRS. Documented designs and architected data maps; developed data quality components, and established and conducted unit tests
• Designed, developed, debugged and tested stored procedures; configured files and implemented best practices packages to maintain optimal performance. Created design related artifacts i.e. data models, mapping documents, architecture diagrams and data flow diagrams.

SQL Developer

Confidential

Responsibilities:

• Data integrity and referential integrity when loaded to source-staging tables. Created tables to capture errors and data from failed validation checks; developed partitioned tables and created indexes, constraints, triggers, synonyms, database links, table spaces, roles, etc. in Staging and Destination schemas
• Developed dynamic SQL used in procedures and function for the data extraction and loading process; created an index for the Staging environment to facilitate faster data loading. Generated documentation for all processes involved in the ETL mechanism. Worked with various complex queries with joins, sub-queries and nested queries in SQL to model test cases
• Built complex mappings which included implementation of business logic to load data into Staging area. Contributed to database administration; created databases, users, schemas and tables. Co-managed security, including granting and revoking privileges on database objects

Software Engineer Intern

Confidential

Responsibilities:

• Gathered requirements and developed the technical design document and user stories. Designed the data model and ETL process to load archived files and scheduled ETL packages from various ticketing vendors. Developed a web application to analyze time-specific passenger data and trip information.