PROFESSIONAL SUMMARY:

• An HL7 certified healthcare technology professional with extensive knowledge of Healthcare domain and HL7 messaging.
• Worked on several healthcare products that offer host of features like continuity of care record (CCR), continuity of care document (CCD), patient’s demographics and clinical data management, chronic disease management, e - prescribing (e-Rx) and PQRS.
• Over 8 years of experience in Software Industry working on several technologies like .Net, Microsoft Business Intelligence, Scripting and Open Source projects, software development frameworks and other reporting and database technologies.
• Managed all phases of Software Development Life Cycle (SDLC) including activities like providing documentation on design, testing and migration from development to production.
• Strong Dashboard design experience and passionate practitioner of effective data visualization and familiar with best practices around visualization and design.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts, Line Charts and Bar Charts as well as creating custom calculations in Tableau.

TECHNICAL SKILLS:

Environment: Windows

Languages: HTML, CSS, JavaScript, JQuery, AJAX, XML (Schemas, XSLT), PowerShell, SQL, MDX

Reporting Technologies: Tableau, SSRS, Performance Point Services (PPS) 2010

ETL Technologies: SSIS

Microsoft Technologies: ASP.NET, C#, VB.NET, MSBuild, Silverlight, WiX

Other Technologies: Cruise Control.Net

Database: SQL Server 2005/2008

Servers: IIS

Development Tools: Visual Studio 2005/2008/2010/2012

Management Tools: VisualSVN, TFS

Domains: Healthcare

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

Main Technologies: SSRS, Tableau, SSAS cube, MDX

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Scheduled extract refresh for weekly and monthly reports.
• Converted existing BO reports to Tableau dashboards
• Implemented calculated fields, members and parameters
• Implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Actions, Calculations, Parameters, Maps and table calculations.
• Developed Tableau visualization using Cross tabs, Heat maps, Box and Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
• Created SSRS Reports and wrote MDX queries for it
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Provided Production support to Tableau users

Confidential, Rochester, MN

Main Technologies: SSRS, Performance Point Services (PPS) 2010, Tableau, MDX

Responsibilities:

• Analyzed the requirement to provide suggestions to create different types of charts
• Developed SSRS charts and implemented drillthrough, drilldown reports
• Implemented cascading parameters and KPI dashboard in SSRS
• Deployed SSRS reports to SharePoint Server
• Designed PPS Analytical Dashboards, Scorecards and Reports using OLAP charts and SSRS Reports embedded in PPS to visualize data and its trend over a period of time
• Implemented complex time-intelligence filters in PPS that auto-update the dashboard to show new data only when available
• Fixed bugs

Confidential, Rochester, MN

Main Technologies: Tableau, Excel worksheet

Responsibilities:

• Gathered Business Requirements by interacting with Project Manager and Division Managers
• Created dashboards for analyzing Employee FTE excel sheet using Tableau 10.0
• Established live connection to Excel workbook kept at a shared location so that the data is always real-time
• Built interactive visualizations in Tableau to better understand the data in the spreadsheet
• Fixed the bugs

Confidential, Rochester, MN

Main Technologies: SSRS, SSAS Multi-Dimensional Cube, MDX

Responsibilities:

• Worked with Business Analysts to understand the requirements
• Designed the SSRS report and wrote MDX queries to bring data from cube
• Implemented cascading parameters, drilldowns and drillthroughs to show data at various level
• Deployed the SSRS reports to SharePoint servers and SSRS native servers
• Fixing bugs/issues modification of logic

Confidential, Rochester, MN

Main Technologies: SSRS, MDX

Responsibilities:

• Actively involved in requirement gathering, functional and technical specifications
• DesignedSSRS report and wrote MDX queries to bring data from cube
• Created various types of drilldowns, drillthroughs and sub-reports that have cascading parameters, Tablix, charts etc.
• Testing the reports and data validation with the cube
• Deploy the dashboard to native reporting servers and SharePoint Integrated mode

Confidential

Main Technologies: .NET Framework 3.5, ASP.NET using C#, VB, JavaScript, SQL Server 2005, SSRS, SSIS, Telerik Controls, Ext-JS, RESTful services, TFS

Responsibilities:

• Involved in Analysis, Design and Development phase of all modules
• Analyzed the requirement and created design document
• Discussed specifications and functionality issues with Business Analyst and participated in daily Scrum calls and discussions with product owners
• Coded as per the specifications and performed unit testing of various functionalities
• Designed Server Controls, User Controls, Data Grid controls, Form Validation controls in Telerik.
• Developed RESTful service to enable communication between Ext-JS application and the .Net Application
• Developed SSIS Packages for extracting the data from source systems and populate the reporting database.
• Developed SSRS Reports for analysis of processed patient measures that will be sent to CMS in PQRS XML format
• Suggested new features to stakeholders so that it makes patient data management easier
• Fixed bugs

Confidential

Main Technologies: WiX 3.0/3.5, CruiseControl.NET, PowerShell, VisualSVN, SSIS, ASP.NET, C#, PowerShell

Responsibilities:

• Independently created BI-Clinical installers in WiX, customized them according to specific requirements client or functionality and deploying them
• Wrote deferred and immediate custom actions in C# to perform tasks that are not provided out of the box by WiX
• Understood Confidential processing and ensured that it works under different environment and configurations of the client
• Wrote PowerShell scripts to automate the deployment process.
• Integrated different components-upstream/downstream
• Managed deployment activities and coordinated between the different engineering teams
• Managed the product upgrades/versioning.
• Ensured timely release of the software for testing/production
• Ensured that the build status is maintained and all check-ins are associated with proper comments
• Completed the installation and setup of VisualSVN. Configured user authentication and custom hooks to adhere to defined standards
• Conducted Training for developers on usage of VisualSVN and its client Tortoise SVN