Redesigned and automated the legacy Daily Accessibility reports to a self-serve consolidated dashboard that pulls call metrics by different segments and displays YOY monthly trending analysis. This dashboard is the source of truth within our department and other departments and reduced reporting inquiries by 30%.Consolidated the major 4 Avoidance Detail Reports into a single self serve Tableau Dashboard that services avoidance analytical needs across the enterprise. This tool saved the team from more than 800 manual reports which takes more than 20% of the daily Developed path analytics logic and dashboard for the PANS and internal verification system dataEnhanced the Metrics by LOB Dashboard and integrated Salesforce Chat and Web metrics and improved runtime performance by 90%.Architected the analytical layer's PCS 1 to 2 question change for the Post Call Survey Dashboards.Collaborated with vendor and WFM during Aceyus 4.6 UpgradeDeveloped Clinical Variance Trending and Summary Metrics for Management’s Monthly reporting

Established a Consolidated Pipeline interactive dashboard that integrated the databases of two commercial loan providers and merged metric logic. Collaborated with business partners to develop an affordable housing loan distribution dashboard displaying the heat map  of LITHC, Affordable, and HAP loan that was integral to the approval of Freddie Mac Affordable License for CRE.

Developed proactive data strategies regarding sales, audiences, marketing, and competition and presented recommendations to senior leadership that drove both strategic and operational changes in business.Created a new reporting layer and built Sankey analytics and segmentation solutions that visualized member engagement and helped predict future customer journeys.Developed the propensity models which helped advisors and marketing target,outreach, and retain participants.Collaborated with the business partners, product managers, and other stakeholders to develop functional analytics solutions and architected the OmniChannel Analytics platform that integrated Big Data pipelines such as call center, campaign(Silverpop), census, and consumer web data.Established large-scale reporting dashboards that enhanced and optimized ad-hoc reporting solutions.

Implemented the design and development of the Data Warehouse (including multiple datamarts) and the associated ETL of subject level data using tools such as SAS, Informatica Developer, and Denodo Virtualization. Data mined and analyzed relational database to drive the data discovery and extraction of healthcare disability claims, benefits, and payments history attributes.Researched and developed data integration solutions to conform multiple data sources  in the functional, subject, and consumer layers to support reports driving data strategies.Led the effort in building XREF for ICD 9 codes mapped to ICD 10 and converted existing reports to reflect ICD 10. SME in a team of developers that delivered the FINEOS (Insurance & Claims) Application datamart and consulted on Group Insurance datamarts (Dental, Vision, Group Disability - LTD,STD).Managed the BIA team’s transition to Agile by being the pilot Scrum Master and provided project/ team metrics (JIRA) to the stakeholders

Successfully led 22 global banking and finance projects to delivery and implementation on schedule and under budget, managing both domestic and international project teams.

Performed regression testing of the Hayneedle website by using SQLyog, MySQL and TestCompleteManage the quality assurance of the flash site team -The Foundary and its mobile platformsWork with Oracle EBS to test and analyze the order management process of Hayneedle and TheFoundary.com