OBJECTIVE:

BI (Business Intelligence) Architect / Developer / Analyst / DBA / Big Data

SUMMARY:

• Microsoft Certified Solution Expert (MCSE) for Business Intelligence with expertise in designing and delivering business intelligence solutions in various domains of IT industry like Healthcare / Clinical trials, retail, pharmaceuticals and manufacturing.
• Extensive experience designing and developing robust and scalable Microsoft BI reporting and analytics solutions by SQL Server Integration Services (SSIS), SQL Server Analytics Services (SSAS) and SSRS, ETL, T - SQL.
• Strong T-SQL skills with experience writing complex queries, views, CTE, UDFs and Stored Procedures, triggers.
• Proficient in both administration and development tasks with primary expertise in Microsoft SQL Server design, development and administration.
• Proficient in data warehouse OLAP data modeling and SSAS, MDX, cube developments.
• Solid knowledge of Microsoft DQS (Data Quality Services) and MDS (Master Data Management Services), data mining, and Agile software development lifecycle (SDLC).
• Proficiency with reporting tools such as SSRS, Crystal Report, SharePoint, KPIs and dashboard.
• Exceptional analytical and problem-solving skills and strong ability to act proactively, meet tight deadlines, prioritize and multi-task effectively in a fast-paced environment.

TECHNICAL SKILLS:

Database: MS SQL server Enterprise 2005/2008/2012/2014 , SSIS/SSAS/SSRS, DQS, MDS, T-SQL, PL/SQL, MySQL

Languages: VB.NET, C#, Python, R, DMX, MDX, DAX, SAS, Matlab, XML, HTML, PowerShell

Tools: Word, Excel 2010/2013, PowerPoint, Power Pivot, SharePoint, PerformancePoint, Power BI, Visio, Access, SharePoint, PerfMon, SQL Server Profiler.

Business Intelligence: Microsoft SQL Server Business Intelligence, SAP data services, Tableau, Hadoop.

Operation Systems: UNIX, Linux, MS-Windows

WORK EXPERIENCE:

Confidential

SQL BI Developer

Responsibilities:

• Planned and evaluated impacts of Epic upgrades; Prioritized related code changes for data marts and extracts. Prepared pre-deployment document for Go-Live and completed upgrades successfully.
• Architecting and building data marts and data warehouses for clinical reports and patient throughput real-time analysis.
• Developed ETL templates for the team and leveraged certain design patterns for complex projects.
• Developed and maintaining Confidential survey reports for hospitals.
• Contributed to the improvement of the efficiency of data warehouse team and proactively mentored team members on project related issue. Enforced naming convention for SSIS and database objects based upon Microsoft best practice.

Confidential

Sr. Database Administrator

Responsibilities:

• Monitor database operations, analyze and respond to performance and other maintenance issues.
• Evaluate database performance by identifying and resolving production, UAT, application development problems, including system memory, CPU and I/O performance as well as database health.
• Provide TSQL best practices to developers for better query performance.

Confidential

ETL Programmer / Developer

Responsibilities:

• Defined and implemented migration strategies from legacy systems to new data warehouse architecture.
• Developed SAS or SQL codes to measure quality metrics including HEDIS measures. Also built chart reviews for quality measure purpose.
• Built key performance indicator (KPI) reports for stakeholders. Incremental loading Medicare/Medicaid enrollment files, denominator files, and all claim-related files from clients to data marts or Enterprise data warehouse. Built crosswalks for Providers/Practices/Members. Loaded immunization data in HL7 message by customized script task.
• Identified and resolved data issues by communication and discussion with data analysts and clients and builds positive relationships between business users and IT staff and between various teams in the IT function.

Confidential, Santa Clara, CA

Database Engineer

Responsibilities:

• Participated in requirements gathering, documentation, testing, and production implementation of new and existing ETL processes. Created technical specifications and developed codes to ensure solutions meet business and data requirements.
• Created and altered functions, stored procedures, triggers, and other SQL database objects that assist in the implementation of business logic and data flows.
• Developed, managed, and monitored various SSIS packages for data integration from flat files and OLTP system.
• Migrated and maintained database of digital product collections, created indexes, stored procedures and triggers.
• DB Support including DB installation/configuration, backup/restore, access & privilege control, performance tuning, online/offline index rebuild, ad hoc query & report with all tier-1 DBs running on MS H/A clusters plus Disaster Recovery via SQL log-shipped or SQL mirroring DR.
• Performed DBA duties, monitored data activities and maintained databases.
• Created and ran unit level QA regression tests for new technical features of internal Confidential tools.
• Conducted performance tuning on SQL queries, store procedure, SSIS package and OLAP queries.

Confidential, Durham, NC

Research Assistant

Responsibilities:

• Proposed and developed two novel modeling methods to simulate electromagnetic waves . They combined spectral accuracy with geometric flexibility and are promising to use in circuit packaging and EMI/EMC studies.
• Coded in C/C++, compiled and ran on Linux and post-processed result data with Matlab, Excel, and SSRS.
• Designed and developed logical and physical data models. Optimized queries, stored procedures, and views for stability, scalability and efficiency.
• Migrated MySQL and Oracle databases to SQL Server.
• Tested and validated with analytical solutions and benchmark problems. Presented and published results in journal.
• Applied machine learning tools to analyze unstructured geophysical data.