SUMMARY:

• 9+ years of experience in Design, Development, Integration, Implementation and Maintenance of Business Intelligence platforms.
• Extensive experience of 4+ years in the Healthcare domain with varied knowledge expertise on hospital processes and department functionalities which include Claims billing related knowledge (ICD9 and ICD10 codes, DRC Codes), Medicare, Medicaid related processes, OR Scheduling etc.
• Capable of gathering client facing business requirements, KPIs and translating them into functional specification documents
• Proficient in multiple Business Intelligence tools such as Tableau, Pentaho, Qlik and Power BI
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Worked with blending disparate data sources into a common reporting tool by creating workflows using Alteryx.
• Experience in complete software development life cycle (SDLC) from gathering requirements, Analysis, design, development, testing and deployment.
• End to end experience in designing and deploying data visualizations using Tableau.
• Extensive experience working as a Business Technical Consultant with specialization in Tableau, Pentaho, SSRS, Qlik View, Alteryx, Coremetrics and Google Analytics.
• Proficient in development and maintenance of Power BI dashboards/reports
• Design and model data sets with Power BI desktop based on measure and dimension as defined by customer needs and dashboard needs.
• Expert in creating Power pivots, Power views using tabular model (DAX), Cubes (MDX) and SQL queries.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Proficient in writing complex Formulas, Sub Reports, Summary Reports.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues with in Tableau.
• Deployed the reports and Scheduled Reports for the use of end users and customers.
• Worked extensively with creating reports as per user requirements using Reporting Services.

TECHNICAL SKILLS:

BI REPORTING TOOLS:: Tableau Desktop, Public, Server, PowerBI, Qlik, Pentaho

DATABASES:: Oracle, MySQL, Teradata, SQL Server

OPERATING SYSTEMS:: Windows 95/98/2000/XP/Vista/7

OTHER TOOLS: Alteryx, JIRA, Confluence

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Reports Senior Consultant

Responsibilities:

• Spearheaded the Reports around SNAP (Supplemental Nutrition Assistance Program), TANF (Temporary Assistance for Needy Families and Medicaid Project.
• Overall project objective was to to understand their existing Reports design, translate these legacy reports into the new Reporting solution, Tableau
• Day to day activities included understanding existing design, identifying data elements, understanding the data warehousing design, testing logic on the reports by writing queries in SQL.
• Reports Track Lead for Integrated Eligibility SNAP/TANF project.
• Subject matter expert in Tableau, Integrated Eligibility Process for Reports and client legacy reports Process.
• Blended multiple disparate data sources using SQL and Tableau functions to achieve creation and deployment of Tableau dashboards
• Combined several singular legacy reports using dashboards and reports using complex Tableau functionalities such as Parameters, conditional formatting, dashboard filtering in order to provide ease of usage and accessibility for client consumption.
• Configured Tableau server to load and provide user accounts and access permissions at different levels to safeguard confidential and proprietary information.
• Delved into the existing design and provided expert analysis on the report design, creation and implementations in accordance to the new system.
• Provided guidance in database structure and design for optimum performance of reports framework.
• Conducted design and analysis sessions for more than 600 reports .
• Analyzed existing data elements and compiled them into logical datasets in the Reporting Layer to combine report areas for easy access for reports.
• Managed the creation of design documentation and other training documents for clients
• Managed scope of the project and provided Input in change reports, and out of scope additions to balance client and project expectations.
• Tested the reports for logic as well as ETL implementation.
• Managed action items and deliverables through JIRA and JAMA.
• Coordinated timelines and provided updates to upper management to ensure project success and on time delivery.

Environment: Tableau, JIRA, JAMA, SQL Server Management Studio, Word, Excel, Sharepoint

Confidential, Pasadena, CA

BI Developer/Business Systems Analyst

Responsibilities:

• Worked on improving the patient throughput for the emergency department in helping them identify pain points using systemic breakdown of process using data.
• Primary responsibilities included building intuitive visualizations and charts using Tableau, which helped guide the users identify problem areas and make informed decisions based on the performance of KPIs associated with the project.
• Conducted Requirement Elicitation sessions which involved getting a deep understanding of different facets in hospital processes involving hospital departments such as clinical, financial etc.
• Created Tableau dashboards for Various hospital Departments such as Billing Claims, OR, Emergency Department and Management Level dashboards.
• Conducting brainstorming sessions in order to identify Key Performance Indicators along with the identification of data elements required to identify shortcomings of KPIs
• Involved in creation of individual views for individual projects for optimal functioning of database with regards to the project
• Created dashboards and stories in Tableau by connecting to individual views.
• Made use of complex functionalities such as custom SQL, Data blending, parameters, LOD expressions etc.
• Created data visualizations Conducted data validation by querying the database values and comparing them to existing reports.
• Created new Power BI Reports and maintained existing Reports that were used in Power BI.
• Provided guidance in the migration of some reports from Power BI to Tableau Reports and Dashboards.
• Created Power BI Reports using functionalities such as Power pivots, Power views using tabular model (DAX), Cubes (MDX) and SQL queries.
• Connected and extracted data from SQL database to create and manipulate data using views and organized data sources for ease of report consumption.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Decrypted the relationships between data elements using Cerner Coding Language scripts and then used these to identify the location of the data elements in existing data marts.
• Created basic ETL packages using SSIS.
• Assisted in enhancing and modification of existing Tableau reports along with quick turnaround on Ad-hoc reports

Environment: s: Tableau, Power BI, SQL Server Management Studio, SQL Server Integration Services, Cerner, Sharepoint

Confidential

Data Analyst

Responsibilities:

• Gathered requirements from business owners and translated high level objectives into Key Performance Indicators (KPI)
• Identified the various different data sources and defined each of the datasources in process flow diagrams to visualize importance in data flow journey
• Used Alteryx for Data wrangling, cleansing and blending data into Qlikview for reporting
• Worked with the marketing division to identify key performance metrics for ad serving and obtained the required information from ad server
• Led defining the website tagging process and served as the subject matter expert in website tagging in the right places with the correct tags so that relevant information flowed into the data source, IBM Coremetrics.
• Translated KPIs into user stories in JIRA along with the acceptance criteria.
• Conducted user acceptance testing of website Analytics
• Created reports in IBM Coremetrics for validating performance of website.

Environment: s: Qlikvew, Alteryx, IBM Coremetrics, Google Analytics, Google tag manager, JIRA, Confluence

Confidential, San Jose, CA

Digital Marketing Analyst

Responsibilities:

• Oversaw all BI and Analytics of data, including data collection, analysis and visualization, dashboards, A/B testing, reporting.
• Used data analysis skills to measure, report and streamline the effectiveness of online advertising of the media division.
• Participated and contributed in the campaign management process which included research and evaluation by analysis.
• Created, automated and maintained daily, weekly monthly reports on various advertising metrics based on ad placement, ad effectiveness, site health and site anomalies along with ad-hoc reporting.
• Provided key insights on content management along with cross functional aand cohort analysis for targeting customer base to improve effectiveness of ads.
• Worked in collaboration with cross functional teams like Ad operations, Sales, Finance, Product Management and external business partners to provide business insights and reports.
• Experience working with Adobe SiteCatalyst for generating and analyzing first party reports
• Blended data from different data sources in order to provide cross functional reports across various teams.
• Provided cross channel data integration using Google Analytics and other third party data sources and providing predictive analysis and in-depth data analysis for business modeling and strategies.
• Interpreted data of customer satisfaction and mobile metrics using Foresee and provided data insights in the form of reports.
• Provided in depth analysis for data trends and anomalies and placed several periodic checks for notification and prevention of site anomalies.
• Used Tableau for creating reports and also provide forecasting data for future site traffic and revenue.

Environment: Google Analytics, Birst BI and Data Warehouse, Pentaho Data Integration, Tableau, MS Office (Excel, PowerPoint, Word), Windows

Confidential, Richmond, VA

Business Systems Analyst

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating Stored Procedures, tables, and views for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Environment: Tableau V 7/8 (Desktop, Server, Reader)

Confidential, Richmond, VA

Business Systems Analyst

Responsibilities:

• Responsibilities include executing, directing, and coordinating all software configuration, system installation, and customer service activities for implementation of AgileTrac solutions in hospitals.
• Gather requirements, create project management documents and manage schedules.
• Translate customer requirements to the development in order to obtain customized software aligning with customer requirements and requests.
• Configure the application to define user and administrative roles and security access for each of the different roles
• Coordinate defining and executing application changes by collaborating with Project Managers, Design and Development teams.
• Conduct Pre-Live Conformance Testing scripts to ensure complete usability of software along with testing results documentation.
• Conduct training based on different roles and responsibilities to end users and also compile and provide documentation
• Provide end user deployment support for new implementations.
• Created views using SQL that was published to internal team for review and further data analysis.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential, Baton Rouge, LA

Business Systems Analyst

Responsibilities:

• Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mockups for reporting.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed and maintained reporting using in MS Excel queries and SQL.
• Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
• Created Test Cases, Activity Diagrams, and System Flow Charts.
• Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.