S Basu Email & Phone Number

Cupertino, California, US

• Understand the Requirements and Functionality of the application from specifications.
• Used Gap Analysis for understanding the efficiency of the models.
• Utilized Python, Tableau, Splunk and PL/SQL, to examine data for trends, patterns, and anomalies, and identify errors, fraud, inefficiencies, or noncompliance with policies and standards.
• Identified emerging risks by collaborating with audit and business management team members to develop continuous auditing and monitoring routines using data analysis of historical data.
• Provided support for investigations, relating to financial fraud, warranty fraud and policy non-compliance issues for Global Security, Legal and Internal Audit departments.
• Utilized statistical methods to analyze and generate useful business reports.

Florham Park, New Jersey, US

• Performed analysis of client's employee data using SQL to test the employees getting correct health plans for pharma industry.
• Helped with documentation of the requirements.
• Used IBM Cognos for reporting, scorecarding and monitoring.
• Used data analysis to develop insights for selection of health plans by employees in different regions in US
• Designed Tableau dashboards to deliver data visualization reports related to different health plans
• Created SQL scripts for extracting data from mainframe jobs running at back end

• Integrated various systems with HEDIS and create design for HEDIS and other systems to pull data in HEDIS.
• Participated in HEDIS supplement file formatting to improve data quality for HEDIS.
• Participating in Business Requirement gathering from businesses, stake holders and converting them to Business Requirement Documents (BRD) and performed role of Business Analyst.
• Deals with new federal mandated CMS (Medicare) per affordable care act, such as including and reporting an accumulator for overall claim payment. Study NCQA HEDIS Technical specifications to develop processes to report.
• Designed and Developed database for HEDIS and C-and D-Measures including Fact and Dim tables, ETL packages to load data from source to target tables, Writing processes for claims, lab, pharmacy, Member Eligibility data.
• Design and Developed for HEDIS and C- and D-Measures processes to calculate denominator, numerator and exclusions based on CMS and HEDIS requirement for each measures requirements.

Sausalito, CA, US

• Data analysis and reporting using MySQL, MS Power Point, MS Access and SQL assistant.
• Involved in MySQL, MS Power Point, MS Access Database design and design new database on Netezza which will have optimized outcome.
• Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Involved in writing scripts for loading data to target data Warehouse using Bteq, Fast Load, Multiload.
• Create ETL scripts using Regular Expressions and custom tools (Informatica, Pentaho, and Sync Sort) to ETL data.
• Involved in loading data between Netezza tables using NZSQL utility. Developed SQL Service Broker to flow and sync of data from MS-I to Microsoft's master database management (MDM).

Pune, Maharashtra, IN

• Identify and drive revenue opportunities for company with process Automation.
• Develop and present proposals. These proposals may include Statements of Benefits, Scope,Conceptual Designs, Project Organization, Support strategies.
• Writing Business Requirement Specifications that successfully delivered necessary change in a manageable and non-intrusive way.
• Implementation of new designs within the Business Operating Model.
• Involved in workshops / training / presentations.
• Providing a link between the company and development team regarding software functionality throughout the development cycle.