Lakshmanan R
Chennai,India
Summary
Highly skilled and experienced Data Analyst with 9+ years of expertise in generating timely and accurate reports for analysis. Proficient in writing SQL queries, including joins, analytical functions, set operators, and sub queries, to generate reports in SQL Server based on client requirements. Skilled in analyzing data to create daily, weekly, monthly, and quarterly reports. Possesses basic knowledge of Power BI and the ability to map flat files in SSIS. Extensive usage of MS Excel, including VLOOKUP, Pivot table, HLOOKUP, and Pivot Chart. Proficient in creating views and temporary tables in SQL. Utilizes formulas to enhance process efficiency and maximize accuracy. Experienced in using VBA for report automation and utilizing Power Query and SPSS Statistics to handle large datasets. Seeking a challenging position where skills can be effectively contributed and knowledge can be implemented in an innovative environment to improve professional growth and company excellence.
Overview
10
10
years of professional experience
Work History
Senior Data Analyst
Optum Health and Technology India Pvt Ltd
09.2023 - Current
- Proficient in SQL Server for data extraction, analysis, and reporting, including the use of joins, analytical functions, set operators, and sub queries
- Skilled in generating reports in SQL Server tailored to client requirements
- Skilled in effectively managing claim rejections by collaborating with clients and offering tailored recommendations for reprocessing claims in alignment with CMS guidelines
- Supported the organization in managing all CMS deadline activities by preparing deadline-specific documents for clients and ensuring accurate submission of all claims to CMS
- Provided comprehensive training on products to new joiners effectively
- Oversaw the complete implementation process for healthcare clients by collaborating with the onshore team, developers, and support Team
- Additionally, worked closely with clients to acquire and integrate all historical datasets into the system
- Performed extensive data cleaning tasks to maintain data accuracy and uphold system integrity
- Experienced in processing risk adjustment claims for markets such as Medicare EDPS and RAPS
- Managed the end-to-end incorporation of three healthcare clients through coordination with onshore team, developers, and support team
- Preparing weekly and monthly Claim and File Reconciliation reports
- Validate the incoming file based on the existing File structure
- Process the incoming claim files, submit them to CMS, and follow up on the response files
- Once received, load the response files into the system
- Experienced in comparing data between the user interface (UI) and the database to ensure consistency and accuracy
- Analyzing raw data to provide metrics and meaningful data to the Clients
- Proficient in performing file operations using batch files and command prompt to streamline processes and enhance efficiency
- Skilled in managing diverse file types, processing large datasets, and converting complex data into user-friendly formats
- Experienced in creating views and temporary tables in SQL Server to enable efficient data retrieval
- Experienced in analyzing and redesigning existing macros to enhance functionality and optimize performance
Business Analyst
Equitas Small Finance Bank
03.2022 - 09.2023
- Work with strategy and Analytics function for branch banking & Liability division
- Analyzing large dump data like CASA and TD by using Power query and SPSS tool to find day wise growth
- Prepare the report for Business performance Budget vs Target framework
- Writing an SQL query (such as Joins, analytical function, set operators and subqueries etc.) and generate the report in SQL Server based on the client requirement
- Analyzing raw data to provide the metrics and meaningful data to the Zone, Region, Cluster and Branch
- Prepare and publish the agreed reports at the agreed frequency on web (Daily, Weekly & Monthly)
- Provided technical support and ideas to team members
- Analyze and redesign of existing macros
- Automated crunch report and daily, weekly and monthly utilization reports using VBA with Excel and SPSS
- Providing Data for Monthly, Quarterly and half yearly Contest as per the requirements
- Solving queries received through mails, calls from Branch end
- Team coordination for New Reports, and enhancement in existing Reports with Development Team
- Developing various dashboard, financial reports, complex formulas, templates
Data Analyst
Episource India Pvt Ltd
08.2018 - 03.2021
- Managed the end-to-end incorporation of Three healthcare clients through coordination with onshore team, developers, and support team
- Preparing daily, weekly, and monthly Claim and File Reconciliation reports
- Validate the incoming file based on the existing File structure
- Process the incoming Claim files and submit them to CMS
- Execute QA test cases, monitor the QA testing status & working together with developers to get all identified issues before the final incorporation
- Writing an SQL query (such as Joins, analytical function, set operators and subqueries etc.) and generate the report in SQL Server based on the client requirement
- Converting the file format vice versa using Python and Notepad++
- Import excel and Flat file into database using SSIS
- Analyzing raw data to provide the metrics and meaningful data to the Clients
- File operations by bat file and command prompt
- Handling Flat file, Excel file and CSV Files
- Creating Views and Temp table in SQL Server for retrieving the data quickly
- Creating a presentation for weekly client call meeting
- Analyze and redesign of existing macros
MIS Analyst & Project Coordinator
Think-up Technology Solution
01.2015 - 07.2018
- Preparing daily, weekly and monthly reports
- Non-Billed items shared to customer and interacting with them
- Processing financial transaction like – Cancellation and processing non-financial transaction like - POA Updating
- Managing incoming volume and make it sure to complete it by end of day
- Maintaining an update tracker of process
- Underwriting and processing the customer requested documents
- Sending Duplicate copy of client data as per instruction of client’s
- Analyze, redesign (Re-engineering) and maintenance of existing macros
- Writing a SQL query and generate a report in SQL Server based on the client requirement
- Developing various Excel tools, dashboard, pivot table, financial reports, complex formulas, templates
- Analyzing raw data and provide the metrics and meaningful data to the business and user
Education
Master of Computer Applications -
Tamilnadu College of Engineering
Coimbatore01.2014
Bachelor of Science - Maths
Government Arts College
Udumalpet01.2011
Skills
- Advanced Excel
- Sql Server
- Power Query
- SPSS
- Power BI
- VBA Macro
Languages
Tamil
English
Timeline
Senior Data Analyst
Optum Health and Technology India Pvt Ltd
09.2023 - Current
Business Analyst
Equitas Small Finance Bank
03.2022 - 09.2023
Data Analyst
Episource India Pvt Ltd
08.2018 - 03.2021
MIS Analyst & Project Coordinator
Think-up Technology Solution
01.2015 - 07.2018
Master of Computer Applications -
Tamilnadu College of Engineering
Bachelor of Science - Maths
Government Arts College
Similar Profiles
Rajeswari DRajeswari D
Coding Analyst at Optum Health and Technology India Pvt. LtdCoding Analyst at Optum Health and Technology India Pvt. Ltd
KANMANI MATHIALAGANKANMANI MATHIALAGAN
Senior Medical Coder at SHAI Health Pvt LtdSenior Medical Coder at SHAI Health Pvt Ltd
Vignesh M KVignesh M K
Executive Medical Coder at Optum Health & Technology India Pvt. LtdExecutive Medical Coder at Optum Health & Technology India Pvt. Ltd