SUMMARY:

• Result oriented Enterprise Data and Analytics professional with 20+ years of experience in leveraging analytics to drive organizational growth, performance and profitability. Over 13 yrs. of experience in DW / BI AWS certified Solution Architect with good knowledge of Hadoop and Big Data technologies for Advanced Analytics and Machine Learning using on premise and Cloud Technologies
• AWS Certified Solutions Architect: Good knowledge of Advanced Analytics, Big Data and Cloud based solution architecture.
• Worked on POC to migrate on - premise DW to cloud for advanced analytics.
• Around 1.5 yr. experience using Spark and Hadoop frameworks
• Worked on HDFS and Elastic MapReduce(EMR) for reducing ETL batch job time on a distributed cluster.
• Designed and built time series prediction models, anomaly detection and machine learning applications
• Data Warehouse Management and Design: 13+ yrs experience working hands on with Management and business users Planning, architecting, developing and maintaining Enterprise Data warehouse and BI solutions both on-premise and in Cloud. Good knowledge of best practices in designing
• Star schema based EDW using Kimball concepts and Agile Methodology.
• Big Data / Advanced Analytics Implementation using Hadoop technologies and Data Lakes
• Business Intelligence Solutions: 13+ years hands-on experience in Architecting, Building and Maintaining EDW and BI solutions on major BI platform with a focus on Master Data Management and Data quality.
• Tableau - Maintained and developed dashboards and reporting solutions on Tableau Server.
• Microsoft BI Technology - SSRS (Reporting Services), SSAS (Analysis Services) and MDX. Designed BI Cubes and created complex reports using SSRS and MDX custom queries.
• SAP Business Objects - 4.1 Designed BO universes, created reports and Dashboards.
• Oracle OBIEE - developed RPD, and designed the frontend analytics and reports.
• SQL Databases and queries: Good knowledge of databases and use of SQL queries for adhoc reporting. Extensive experience in performance tuning of BI reports and SQL Queries.
• ETL Tools - Good knowledge of SSIS and calling stored procedures using SSIS with a strong focus on Master Data Management and Data quality.
• BI Data Governance and Master Data Management - worked with senior leadership and stakeholders to develop and maintain a single source of truth for published and adhoc reporting through EDW and BI solutions
• P roject Management: Served as Project Manager on several Business Intelligence, Operational performance improvement and Lean Six Sigma projects. Proficient in leading cross-functional teams to identify, prioritize, and design solutions for monitoring and improving business processes and making informed decisions.
• People Management, Collaboration and Leadership skills: Excellent relationship management skills. Extensive experience working with and supporting senior executives. Excellent team player and a BI Manager managing a team of developers and analysts
• Problem Solving Techniques and Lean Six Sigma Principles: Lead major lean six sigma projects in Healthcare. Provided and analyzed data to enabled data driven decisions in the organization.
• Analytical and Interpretation Skills: Proficient in Advanced Analytics and lending strategic insights to critical business, financial and operational issues through KPIs, Financial / Operational Metrics, Business Intelligence Dashboards, Adhoc analysis and Reports.
• Change Management Skills: Certified Practitioner of Prosci Change Management principals.

TECHNICAL SKILLS:

• AWS certified solutions architect with proficiency in designing cloud based solutions
• Proficient in designing BI Solutions, dashboard, reports and scorecards.
• Proficient in ad hoc Data Analytics - Descriptive, Predictive and Prescriptive
• Proficiency in Big data analytics - Hadoop, Spark, MapReduce, Data Lakes, RedShift, HDInsight, Cloudera
• Communication and Interpersonal Skills - Good communicator and Interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential,Houston, Tx

Group Manager

• Design and Development of DW / BI Datamart Solutions using Microsoft Technologies using agile project management methodology for both frontend and backend development to facilitate adhoc and advanced analytics requirements of the business users
• Experience using on premise and cloud based technologies for text and big data analytics projects.
• Evaluating various big data and cloud solution providers and their offerings
• Developing POC and Implementation roadmap for bigdata and advanced analytics implementation
• Development of complex reports and dashboards using Tableau and sourcing data EDW and Reporting servers
• This dashboard was created for the top management and the Program Managers to get an overview of the performance trends and identify key issues for each Program in a single dashboard with guided analytics and drill through capabilities. Sourced data from SSAS Cube using MDX so that the business logic was consistent within the organization. Combining data feeds from multiple data sources and used Parameters, Filters, LOD / Table calculations and user based security.
• This dashboard was created for Client Services team to identify noncompliant providers by rating providers based on Quality, Finance and Operational Metrics. The dashboard provided aggregated scores - overall and for the market apart from individual provider scores. This helped identify individual KPIs that were an issue, Markets that needed additional support and providers that needed additional handholding.
• This Dashboard was created for Medical Directors to review the productivity and performance of the Internal MDs and Nurses. This required extensive use of benchmarking the individual user performance to the peer groups
• Other Operational Dashboards like Auto Approval Dashboard and Rules and Criteria dashboard for operational improvement and to help improve operational efficiencies.
• Managing a team of analysts and developers
• Master Data Management and designing and development a Metadata Repository for Data Management.
• Change Management and User Support and Training for adoption of BI Tools and Analytical Solutions

Confidential,Houston, Tx

Sr. Business Intelligence Architect

• BI Project Management - Managing a team of analysts and developers. Serving as a Project Manager for various BI Projects following Agile and PMO methodology.
• Hospital’s Financial Analytics Project
• Transaction Control and Charge Reconciliation Reporting Project.
• Executive’s Daily Statistical Dashboard
• Labor Productivity / Units of service Reporting Project
• Nursing Operations Dashboard
• BI Solutions Design and Developing using OBIEE and Business Objects 4.1
• Performing Logical and Physical Data modeling using ERwin.
• Sourcing data using ETL Tools like SSIS
• Developing the OBIEE RPD and BO Universes.
• Developing complex reports and dashboards
• Design and development of the Enterprise Data Warehouse - sourcing and validating data
• Designing and developing a Metadata Repository for Master Data Management.
• Providing adhoc reports / data pulls for business and audit requirements
• Training users to develop report and perform adhoc queries.

Confidential,Houston,Tx

Sr. Business Analyst

• Used Microsoft Technologies SSIS, SSAS, SSRS, MDX, Power Pivots to design & develop BI solutions that supported business needs.
• Master Data Management and Data Integrity for consistent reporting of information.
• BI Reporting and Dashboards for Operations and Revenue Management decision support.
• Worked with business users to identify KPI’s and reporting needs
• Sourced the required information from the various business applications to develop BI Cubes, Reports and Dashboards.
• AR and DSO Monitoring.Part of a Litigation Project with responsibility to pull data and documentation from the databases.
• Monitored reimbursement trends and identified XPayers (Payers with low reimbursements) for negotiations.
• Worked on Denial Management Project to identify the major denial reasons and recover Lost Revenue.
• Worked closely with the Revenue Cycle Department to monitor reimbursement trends and identify projects to resolve reimbursement issues.
• Designed and developed a BI solution to monitor AR Trends, forecast collections for the following periods and monitor collector performance and efficacy.
• Collections Forecasting.
• Developed a collection forecasting model to forecast collections based on actual revenue by Payer and their reimbursement trend.
• Developed the collection budget and compared the actual collections to the forecasted collection.
• Financial Reporting, Statistical Analysis and Recommendation.
• Presented monthly Operational and Financial reporting and analysis to management.
• Provided adhoc data and reports for audit requirements
• Provided adhoc analysis using Statistical and BI tools to identify trends and support business decisions.
• Lean Six Sigma, Operational and Revenue Cycle Management Projects.
• Participated in various Lean Six Sigma projects to increase Operational and Revenue Cycle efficiency.
• Le ad various Revenue Cycle Management Projects

Confidential,Houston,Tx

Sr. Business Analyst

Responsibilities:

• Provided Monthly Operational / Benchmarking / Financial Reporting, Analysis and Recommendation.
• Analyzed and Developed financial, operational and clinical reports.
• Performed cost, revenue, productivity and physician program studies.
• Developed forecasting model to calculate the projected collections.
• Developed a model to calculate the actual AR due to the absence of contractual write-offs.
• Lead various operational projects to meet continuous Business Process Improvement Goals.
• Lead various revenue cycle management projects to maximize reimbursements.
• Coordinated ASC acquisition and merger projects using MS Project & Visio.
• Defined and documented business office policies and procedures & conducted compliance audits.
• Developed Patient Satisfaction Survey reporting application in VB.net and Crystal Reports
• Serving as IT Administrator, ensuring implementation of new technology solutions.
• Deployment of new technologies to support the IT / Telecom / Business needs of the Company.
• O verseeing Exchange Server and SQL Database maintenance, security & backup.
• Implementation & Administration of Practice Management Software, EMR Software, Ad hoc reporting tools Cognos PowerPlay, Crystal reports and Windows Sharepoint Services.