• Managed the retail client portfolio and performance by tracking the performance of newly introduced value proposition designed to reduce loss in retail sales and increase in credit penetration.• Custom designed automated reports in SAS and excel to track performance of the value prop and its affect on customer sales, credit penetration and customer re-engagement.• Communicated with multiple departments such as marketing, operations, IT and retail partners to coordinate the flow of the project.• Designed business and technical requirement documents and acted as a liaison between the business and data solutions team.• Designed "1-pager" presentations for executives giving a high level view of the portfolio performance.• Developed business presentations to communicate the solution to a potentially broad array of functional teams and senior managers.• Proactively identified new initiatives to drive sales, increase revenue, decrease costs, improve operations and increase business profitability.

• Provided guidance and supervision to 7-8 data analysts and statisticians while coordinating with high ranking state officials and the Centers of Medicare and Medicaid Services (CMS) to develop strategies to detect fraud in Medicare and Medicaid programs.• Mentored and trained staff on SAS, work processes, procedures for Medicare and Medicaid.• Performed proactive analysis by reviewing claims data to detect fraud and identify program vulnerabilities.• Reviewed Medicare and Medicaid medical policies as well as state and federal regulations to identify program vulnerabilities suitable for proactive studies.• Made policy and claims edit recommendations to strengthen the integrity of the Medicaid program to high ranking state officials (e.g. Director of Program Integrity)• Generated graphs and summary tables for effective representation of trends in data using SAS.

• Analyzed and validated Medicare and Medicaid claims data with SAS programming to detect fraud, and abuse in approved or pending payments, violation of Medicare laws and policies revealing overpayments in millions of dollars.• Performed proactive analysis on claims data to detect fraud in advance and effectively presented them to Law enforcement and state officials. Proactive analysis was performed via identifying outlier activity by computing z-scores and/or by building drilldown/trending reports.• Designed several standard SAS scripts, ad hoc and periodical standard reports, graphs and summary tables for effective use by the Data Analysis team.• Improved efficiency and reduced work load by designing excel to SAS interfaces to extract and report data for the Benefit Integrity team• Designed Microsoft Access database used to upload claims into the government RAC system.• Effectively participated in brain storming sessions with senior management, subject matter experts, benefit integrity experts and medical nurses.• Generated graphs and summary tables for effective representation of trends in data using SAS.• Quality checked peer’s work before the reports went to law enforcement agents/OIG.• Proficiency in handling large datasets (10 Million plus records) and expertise with analytical reporting using advanced Excel features like Pivot Tables, V Lookup’s and VBA Macros.• Mentored and trained staff on SAS, work processes, procedures for Medicare and Medicaid. Trained the Iowa state government staff in using Data Probe and Medicare data.

• Effectively gathered high level business/project requirements and created Technical and Functional Specification documents.• Created and maintained tools for effective tracking of installations, maintenance and legacy meters using SAS, Excel and Microsoft Access.• Effectively cleaned, imputed and analyzed millions of records, performed data loads, extracts and queries.• Successfully generated and maintained list of meters for third party Vendors.• Assisted the network deployment team in analyzing and developing meshes for smart meter deployment.• Effectively generated letters and postcards to contact customers for installations.• Successfully developed handoff packages for Business.• Performed analysis of the given data and drew accurate inferences, in accordance with the objectives of the analysis.• Gathered data required to conduct analysis from several sources, compiled it together in prescribed format and performed effective analysis.• Implemented Logical Design and Physical Design of the databases, tables and indexes.• Evaluated the given problem, situation and crisis, investigated for solutions using data analysis practices and prepared analysis reports.• Responsible for capacity planning, backup and restore strategies, database maintenance and performance tuning.• Assisted in creating the planning model for effective allocation of resources.• Generated reports for higher management using Microsoft Access and Excel.• Effectively conducted gap analysis between the as-is and to-be systems, to create system process maps.• Provided recommendations on Business Processes and workflow.

• Successfully designed external and internal design documents, implemented coding, unit testing, system acceptance testing and user acceptance testing support on projects ‘Customer Number Range’, ‘Supplier Finance Application’ and ‘Supplier Finance Application Internet Invoice factoring’.• Modeled key database structures for the product.• Resolved queries and supported business stakeholders throughout the user-testing phase.• Documented new functional requirements or changes to existing functional requirements• Assumed and maintained Quality Control responsibilities within the project team, which led to zero defects after project implementations.• Acted as a liaison between the project stakeholders and the finance team to understand the requirements.• Analyzed data and created applications using Plex and AS400 database.• Mentored new recruits and coordinated work between the different project sites.• In addition to UK, the project was subsequently implemented in HSBC Hong Kong and HSBC China as well