SUMMARY:

• Over 8 years of experience in design and development of Business Intelligence and Database Solutions with expertise in Database and Data warehouse modelling.
• Experience with implementing ETL, Master Data Management and Data Migration solutions using MS SQL Server SSIS/DTS on SQL Server 2012/2014/ 2016 .
• Experience developing reports using Microsoft Reporting Technologies in SSRS and in Power BI.
• Experience in leading and coordinating onsite and offshore teams.
• Good knowledge of Data warehouse concepts and principles - Data Modelling, Dimension modelling, Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Good experience with best practices in Database Modelling, ETL and Reporting Solutions.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, DB Tuning Advisor, Activity Monitors and Commands.
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server
• Expertise in T-SQL (DDL and DML), PL/SQL, Stored Procedures, triggers, Cursors, Indexes and Functions, Share point and Microsoft Team Foundation Server.
• Strong experience designing and implementing Replication.
• Proficient with SQL Enterprise Manager/Management Studio, SQL Query Analyzer, Business Intelligence Development Studio, SSDT, SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Strong understanding of Health care, Claims processing, ERP, CRM and Supply Chain Management Systems.
• Good team player with a strong work ethic and desire to learn and share knowledge, and possess excellent organizational, interpersonal and communication skills.

TECHNICAL SKILLS:

BI Tools: SSRS, SSIS, Power BI

Data Modeling: Erwin 4.0/3.5, Dimensional Modeling

Languages: T-SQL, PL/SQL, VBScript, .Net

Databases: SQL Server 2014/2012/2008/2005, Oracle 10g/11g, DB2, Azure

Tools: Management Studio, Toad, Oracle SQL Developer Loader, BIDS, SSDST, Query Analyzer, SQL Profiler, TFS, SVN

Operating Systems: Windows 2012, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. BI Consultant

Responsibilities:

• Responsible for Installation and Configuration of MS SQL Server 2014in both test and production environment.
• Installed and Configured SSIS 2014 in both test and prod environments based on Windows Server 2012.
• Extensively worked on profiling data from Oracle EBS, Syteline, Titan and other ERP systems.
• Defined and developed logical and physical data models to support business needs.
• Responsible for developing ETL (Extract, Transform and Load) processes using SSIS 2014 Project deployment model and SSISDB Catalog for logging.
• Deployed, scheduled and maintained various SSIS packages.
• Designed, developed and administered rich BI visualizations in Power BI using data sets from files and databases. Created complex interactions between different visuals (charts and maps) in a report, published and shared the reports and dashboards, Installed and configured Power BI Gateway for auto refresh of data based on a schedule, implemented hierarchies for drill down and up of reports to help with detailed analytics, managed access for security and used R packages for custom visualizations.
• Developed and supported legacy SSRS reports as we have different reporting environments based on merger of Sherman Dixie and Cretex companies.
• Used DAX to implement different calculated measures and KPIs in Power BI and tabular modelling.
• Developed and supported data feeds for Power BI reports and Dashboards.
• Performance monitoring, Disaster Recovery plan implementation, managing backups and applying patches and hot fixes for SQL Server databases.

Environment: PowerBI, SSIS, SSRS, T-SQL, SQL Server 2014/2016, SSDST, Azure, Tabular Modelling.

BI developer

Responsibilities:

• Coordinated between onsite and offshore teams.
• Worked on Wellness Care Management (WCM) project to fetch data from different data repositories and load into data mart for reporting.
• Developer on Revenue Management and Risk Adjustment (RMRA) project related to Affordable Care Act (ACA), to map, design and develop different data feeds to Edge server and Risk view server.
• Extensively worked on diagnosis codes (ICD-9 and ICD-10), procedure codes, professional, facility, vision and drug claims, lab results, member and member enrollment, provider data, provider specialty, Employer group, Medical group, Medical group affiliation and Exchange data.
• Used complex SQL scripting like stored procedures, table valued and scalar functions, views and SQL queries together with SSIS packages for data extraction, transformation and loading.
• Profiled source data from heterogeneous systems like Portico, Facets, EDW, and MOSCAR etc.
• Worked on mapping ICD9 to ICD10, BCBSM specialty to CMS specialty, BCBSM Rate Area ID to CMS Rate area ID etc during claims loads and/or submitting data to different government based engines.
• Worked on commercial and Medicare Advantage business processes.
• Designed and developed data feeds to Inovalon HEDIS (Med Assurant) engine that is used for calculating different measures used for STAR rating and analytics. Worked with Inovalon Flow Chart Designer and Quality Insight for implementing custom health care measures for analytics.
• Developed and supported to and from data feeds from MCIR (Michigan Child Immunization Repository) to collect vaccine information on periodic basis.
• Involved in design, profiling, development and deployment of complex ETL solutions by extracting data from heterogeneous sources like XML files, flat files, Excel, DB2, Oracle and SQL Server databases etc.
• Worked on ETL of supplemental Information from various Provider Organizations (PO’s) used for analytics. This process involved complex error validations for rejecting records that do not meet the requirements and also merging rejections that were also rejected by BCN (Blue Care Network: HMO business of BCBSM).
• Defined and developed Data Model and Data Flow documents.
• Test and deploy staging and production database changes. Refreshed test databases as needed for supporting testing activities. Troubleshoots and resolves database, application and development related problems.
• Designed developed, published, scheduled and supported Power BI reports based on data in CPDM data mart.
• Created rich standard and custom reports and visualizations in Power BI for insights into the data.
• Created complex interactions between visualizations and developed slicers for slicing and dicing of data.
• Developed rich map visualizations using Power BI for Geocoding
• Used Tortoise SVN and Red Gate source control for version control
• Worked on developing .Net application which helps in deployment of SQL scripts and SSIS Packages.
• Used C# to develop script tasks to develop custom functionalities

Environment: T-SQL, SQL Server 2012/2008R2, SSIS, Power BI, C#, Management Studio, SQL Profiler, BIDS, SSDST, SharePoint, Portico, Red Gate Tools, Inovalon Flow Chart Designer and Quality Insight.

BI Consultant

Responsibilities:

• coordinated between onsite development and business teams.
• Extensively worked on profiling data from various Healthcare Source systems and Financial Systems like EPIC Clarity.
• Worked on Project planning and Status tracking.
• Designed and developed ETL Framework. Log and Audit data of detailed errors, package executions and variable values are stored at centralized database location for later look up and analysis.
• Designed and developed SSIS Package template, so similar development practices are followed by all SSIS developers for logging, configurations and error handling.
• Designed and developed control tables that had to be used by various SSIS developers to store and retrieve source and destination Connection strings information, Incremental column and data info, table and columns names for Meta data driven implementation etc.
• Worked closely with the business to ensure data warehouses are able to support all business requirements across the organization.
• Defined and developed logical and physical data models to support business needs.
• Used EPIC Clarity data models to build data feeds.
• Worked on EPIC Crystal integration
• Responsible for developing and unit testing of ETL (Extract, Transform and Load) processes.
• Developed and fixed custom applications built on .Net framework using C#.
• Used Change Data Control (CDC) changed tables for incremental loads into Data Warehouse.
• Designed and developed ETL using CDC changed tables, CDC functions/SP/Jobs like get all and/or net changes, map LSN(log sequence number) to time, column ordinal, Is bit set, capture and clean up jobs for incremental loads of CDC Changed tables into Data Warehouse.
• Experience setting up database and tables for CDC and configuring them for better performance using different parameter values namely maxtrans, maxscans, polling interval for scan job. Worked with different mappings of data (diagnosis codes) during ETL.
• Perform data cleansing and data auditing to ensure data quality.
• Involved in performance and tuning the ETL processes.
• Identified slowly changing dimensions and determined the hierarchies in the dimensions
• Created, maintained and manage documentation for data warehouse design and ETL development.
• Extensively used SSRS to implement reporting solutions with Share point Integration.
• Integrated SSRS Server with Share Point Server.

Environment: T-SQL, SQL Server 2008R2, SSIS, SSRS, Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, BIDS, CDC, SharePoint, HealthCare Systems, EPIC Clarity.

Softwares

Responsibilities:

• Used SQL profiler to view indexes performance to eliminate table scan.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Used multiple join statements to retrieve data from multiple tables.
• Performed efficient tuning of SQL source queries for data load/usage of stored procedures for performance.
• Developed client applications, report models and reports using SSRS and BI studio by pilling data from the cubes and relational tables.
• Created various DTS packages for data transfer and migration.
• Involved in analyzing and designing disaster recovery/replication strategies with business managers to meet the business requirements.
• Worked as a developer in creating complex Stored procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Creation/Maintenance of indexes for fast and efficient reporting process.
• Created reports using stored procedure that involved in scheduling, creating snapshots and subscriptions for the reports(SSRS).
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment: MS SQL Server 2005/2000, MS Excel, Windows 97/2000/XP, ADO.NET .