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.• Collaborated with departmental managers to outline the specific data needs for each business method analysis project.• Operated technical components within large data sets, and communicates findings effectively through modeling, analysis and written presentations.• Delivered various insights, and recommendations, and coordinates between ops, business development, analytics, and other internal groups.• Planed and conducted AppleCare Compliance audits and investigations to adhere to Apple's policies and investigational procedures.• Developed and implements prioritized audit plans based on risk. Developed standard and ad-hoc reports for Compliance analysis and provides recommendations to management based on data analysis performed.• Identified and assesses fraud and service related risks, consulting with business management on risks and controls.• Independently evaluates the reliability and integrity of AppleCare's control environment, including security and other business controls for new and existing systems, policies and procedures.

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• Visualized vision and dental plans using Business Intelligence tools like Tableau and made documentation for meetings and presentations.• Converted, cleaned, analyzed, organized and documented large data files (10000 - 1 million records)• Reduced report turnaround time, from weeks to hours to load the data faster into the system• Performed analysis for employees getting medical plans with effective presentations as well as performed hypothesis tests; z-test, t-test using R to analyze number of people that accessed the medical plan• Transform & ingest NY E-ZPass customer data from OLTP system to OLAP data warehouse using SQL, PL/SQL scripts, Alteryx and OBIEE tool for business data analytics and reporting• Created reporting infrastructure that can automatically publish daily, weekly, monthly and quarterly operational reports for business managers showcasing business trends and key metrics• Develop data manipulation and transformation workflows in Alteryx to clean, transform and automate future data pull and storage operation in RDBMS• Build Tableau dashboards using the transformed data to perform comparison of key business metrics across sectors; highlight the trends occurring in different service areas to help business managers understand the irregularities if any

• 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 HEDIS performance.• 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 from Source system.• 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.• Participated in a change management in our organization for process reviews.• Participated in URDS project (Re-Write of entire Database on dimensional model design using star-schema model) during initial phase of conception and design. Provided architectural assessment for design consideration (Data Type, Configuration tables, Control tables, Fact and Dimension tables and application use for different team’s requirement such as HEDIS, C and D Measures applications).• Worked on complex SQL Queries for performance tuning, space utilization, data integrity and consistency across entire application development. Analyzed existing SSIS package, make changes to improve its performances, add standard logging, configuration system. Carried out SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.

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). • Worked on Data modeling using Dimensional Data Modeling, Star Schema/Snow Flake schema, and Fact& Dimensional, Physical&Logicaldatamodeling. • Generated Stats pack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth. • Collaborating with business and technology teams. Involved in Data Analysis-Data collection, data transformation and data loading the data using different ETL systems like SSIS and Informatica. • Performed data review, evaluate, design, implement and maintain company database. • Involved in construction of data flow diagrams and documentation of the processes. Performed source to target mapping as part of data migration from JD Edwards system to Agile PDM system. • Data Migration testing and implementation activities using SSIS and SSRS tools of Microsoft SQL Server 2008. Responsible for accuracy of the data collected and stored in the corporate support system. • Interacted with end users for requirements study and analysis by JAD (Joint Application Development).

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.• Responsible for scoping the business requirements and developing technical solutions.