RASHMI KASOJU

1-480-***-**** ad3hre@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/rashmi-kasoju-a33aa7157/ SUMMARY

• Over 5+ Years of IT Experience as a Business / Data Analyst and Data Scientist in Data Modelling.

• Strong Experience in Business and Data Analysis, Data Integration, and Data Visualization.

• Strong database and data management skills.

• Strong knowledge of Microsoft products including Excel and PowerPoint.

• Strong experience with Scrum methodology and well-versed in writing user stories.

• Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design

• Proficient in Technical and Business writing, Business Process Flow, Business Process Modelling, and Testing

• Domain knowledge and experience in Retail, Healthcare, and Production industries.

• Hands-on Experience in writing SQL and PL/SQL queries.

• Proficient in data visualization tools such as Power BI, Python-Matplotlib/Seaborn, and Microsoft Visio to create visually powerful flow charts and reverse engineer database relationships.

• Solid knowledge of relational databases, data modelling/business intelligence, and report design

• Design, develop, and analyse reports/visualizations to suggest opportunities to improve our data acquisition process, including reducing costs or improving capacity and quality.

• Maintain a strong understanding of our evolving data acquisition process and the associated workflows.

• Maintain a Business Intelligence tool to ensure all reports are up to date and meet business users’ needs.

• Lead activities necessary in providing data analysis as a service to the Reporting and Analytics Team.

• Gathered and loaded data into Power BI from various sources including SQL Server, Web sources, and Excel files.

• Assembled large, complex data sets that meet functional / non-functional business requirements.

• Designed and executed analytic projects and generated insights to support business decisions using advanced analytical and visualization techniques such as descriptive, predictive, and prescriptive analytics.

• Communicating with and supporting various internal and external stakeholders.

• Worked with the technology and analytics team to support the development of tools and dashboards.

• Trained in Cloud Software as a Service (Saas) Tool-SAP Analytical Cloud Tool. TECHNICAL SKILLS

• Databases: MySQL, Microsoft Access, SQL Server, Oracle

• Programming Languages: Python, SQL

• Data Analysis/Visualization Tools: Power BI, Microsoft Visio, Excel, Python - Matplotlib / Seaborn, Software as a Service (SaaS) SAP Analytical Tool, SPSS

• Applications: Service Now, Citrix Workspace, Optum ECG Quick Connect, SharePoint, Azure DevOps

• Skill Set: ETL Process/ Data Integration, Data Visualization, Data formatting, ERD Modelling, Predictive Modelling, Sequential Query Coding (SQL), Exploratory Data Analysis (EDA), SDFC Data Analytics Life Cycle, Coggle Mind Map, IBM Watson Studio, Rapid Miner, SPSS, IBM Content Manager, CMOD Google Analytics, Mainframe Programming, Microsoft Access, Microsoft Excel, Mainframe Passport, Tableau Desktop, MySQL, Python Jupyter Notebook

(Matplotlib, Sci-kit learn NumPy, Pandas), HR Workday Learning Partner, SharePoint. EXPERIENCE

HMS/Gain well Technologies Texas (Remote)

Business / Data Analyst June 2021 - Present

• Conduct and perform Higher level business and product data analysis using the SQL code to update for deliverable processing following the Business Requirements for Co-ordination of Benefits.

• Utilize SQL to create ad-hoc requests to provide internal reporting metrics and research potential data issues and abnormalities.

• Responsible for running, monitoring, and analyzing the flow of direct bills cycle and disallowance cycle of Medicare and Commercial Insurance Billing through Mainframe Passport programming and IBM Content Navigator

/CMOD.

• Perform complex data analytics to identify medical cost drivers and measure effectively.

• Maintain and update internal database to track the progress of cycles and projects using SharePoint Tracker.

• Prepare ad-hoc reports for summary analysis of outstanding balance recoupment amount of various health plans contracts through SQL querying varying from intermediate to complex.

• Experience in analytics alongside understanding source data using Mainframe and CMOD environments. Experience in working effectively on multiple complex projects whilst managing multiple SLAs to anticipate and coordinate with various health plans.

• Responsible in regulating the weekly, monthly, and quarterly reports Medicare and Commercial Insurance Billing for Quality Assurance through product requirements docs and effectively transmit via on demand Request (ODR), Launchpad B2B Protocols and Momentum Triggers.

• Design and plan Standard Operating Processes (SOPs) following established approach and methodology and assists in formulating recommendations to improve and support business activities.

• Maintain dashboard and provide data insights to identify issues, trends, or exceptions to drive support business growth opportunity.

• Perform product analysis and deliver using undocumented research methods, Root Cause and Corrective Action

(RCCA) methodology and act as a Subject-Matter-Expert (SME) during extensive review of delivery processing for Business Process Improvement.

• Communicates the business requirements to Engineering Analysts by constructing basic conceptual data and process models which includes data dictionaries and volume estimates, frequencies for cycle run.

• Maintain the deliverables of reports through Azure DevOps Kanban board and make SFTP and B2B transmissions through EDI server following the HIPPA regulations.

• Experience in usage of applications like SharePoint for deliverables of Quarterly, Monthly cycles for Various Health Plans and State Plans - Managed Care Organizations (MCO)

• Reformatting of reports with the use of Microsoft Access database and align the text source data for tabbed editing of health reports with Notepad++

• Experience with ServiceNow Application to track and raise IT tickets to Electronic Data Interchange (EDI), Application Development Services team, Cycle Analytics and Processing, Carrier Optimization teams for deep-dive analysis on health plan carriers and overall cycle analysis.

• Experience in working with IBM Content Navigator (ICN) to read and extract of JCL Reports and trained in IBM Control Manager On-Demand (CMOD)

• Experience in Creating Health Report analysis on health quality and cost information of various Claim types of amounts and carrier information and provide relevant transition of reports through Tableau Desktop for health plans, state plans and providers.

• Obtained training in handling large SQL queries in Teradata, Training in Python to enhance visualization and data analysis skills to bolster the business analysis management.

• Gathering, analysing, and documenting health plan Claims, Carriers and Provider data revenue workflows to determine dependencies for improving the Moving Average Paid Amount or the Claim Amount.

• Health Plans and State Plans Worked on few but not limited to: Cal Optima, LA Care, San Mateo, San Francisco, Paramount Health Plan, UHC Florida -Optum, Well Point, Anthem Blue Cross, Metro Plus Plan, El Paso, Alameda, Virginia, Boston medical health plan and State Plans such as Arkansas, Virginia, Alabama. Revalsys Technologies Pvt Ltd. Texas (Remote)

Data Scientist Apr 2020 – Sep 2020

• Analysed structured data and unstructured data and developed deep-dive analysis and statistical models to support data-driven decisions for marketing and sales operations teams.

• Managed the development of data transformation and data automation routines. Troubleshoot and increase efficiency of existing Business Objects Reports

• Built and maintained tables and database using. sequential (SQL) queries to further add, modify, and delete data, and update tables.

• Provided reporting from the current technologies – Microsoft Access, Microsoft Excel, SQL Server, and Business Objects.

• Responsible for maintaining DB and data calling through complex and efficient SQL code and leveraging Exploratory Data Analysis (EDA) techniques to develop insights from digital and call operations data.

• Responsible for supporting ongoing maintenance of existing reports and universes as well as new report development. Providing Data Analysis & Master Data Management (MDM) expertise across a Siebel environment, and across related source systems.

• Worked with clients and stakeholders across Compliance, Audit, Control and Middle Office to understand business requirements towards reporting and data.

• Experienced in Interpreting analytic outputs and data by using relevant and consumable visualization reports and dashboards.

• Familiarity with the Financial Service industry practices and in coordinating and managing request for information that may include market data, transaction data and vendor data.

• Represented as a bridge to translate business requirements to data and analytics needs for the LOB portfolio.

• Participated in knowledge transfer within the team and other business units, including participation in cross- functional groups or committees.

• Served as an authority on a given business domain and provided Business Expertise to place context around analytics discovery.

• Worked closely with Data Engineers to create services that can ingest and customize, where applicable the business objects and report and supply data to and from both internal and external sources and ensure data quality and timeliness.

• Trained in Python for advanced data analytics and visualization with Pandas, NumPy, and Matplotlib libraries.

• Trained in Developing advanced data analytical models and techniques from supervised and unsupervised statistical analysis and predictive modeling through IBM Statistical Package for the Social Sciences (SPSS) and Python Random Forest Predictive Modelling.

• Maintained RDB with DDL & DML commands using MySQL and gained exposure to various phases of SDLC. Revalsys Technologies Pvt Ltd India

Data Analyst Jan 2019 – July 2019

• Managed, Automated, and Standardized daily, monthly, and quarterly reporting structure to the Account Managers, RDs, and VPs of multiple clients.

• Drafted integrated Tableau workbooks from multiple data sources such as SFDC, & Excel using data blending and cross-database joins

• Responsible in applying and understanding of respective business strategies to produce relevant and meaningful data analysis and materials to support business goals and objectives via SQL querying, python NumPy and matplotlib and Tableau dashboards.

• Produced insights and Develop analysis with data Integrity to illustrate and recommend business actions to align with strategy and/or solve business problems that drive value for stakeholders in new areas.

• Performed analysis, translating data into information to answer business questions through analytics lifecycle of hypotheses, testing, data gathering, analysis, story building, and data presentation to stakeholders monthly or quarterly based on SLAs and reported day-to-day support and delivery of analytics.

• Procured knowledge in generating dashboards, customized reports, and analysing customer data in SAP.

• Attained experience in handling huge data, pivot tables/charts, and built insights using MS Excel Power Pivot.

• Gained extensive experience with AGILE methodologies in software projects, participated in SCRUM meetings, following biweekly sprint schedules.

• Created business workflows on the revenue module for the clients to get a better understanding of the software and prepared a detailed BRD including all functional and non-functional requirements.

• Coordinated tasks with other programmers, business users, database administrators, testing team, and development team. Ensured all technical artifacts complied with corporate SDLC Policies and guidelines.

• Trained in Developing strategy & integrated the analytical module with the latest database schema to increase productivity.

• Trained for Joint Requirement Planning (JRP) sessions with Business User Groups, along with conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

• Involved in formal requirements gathering methodologies and developed Standard Business Procedure reports based on specifications.

Medha Servo Drives Pvt Ltd India

Data Analyst Jun 2018 – Dec 2018

• Conducted background research on potential locomotive services with fuel-saving systems and proposed solutions for operational efficiencies.

• Performed data analysis using Power BI and advanced Excel Power Pivot to extract actionable insights and identify category trends and purchase patterns for fuel-saving mechanisms of propellers.

• Gathered existing data to generate analysis on cost efficiencies and presented reports through SPSS Statistics bi- weekly for sales and other revenue impacts using current data elements such as logistics inventory, and financial reports.

• Developed regression model to prove the significance of propulsion equipment to diesel-electric locomotives and understand key variables that affect the annual turnover of manufacturing units.

• Performed data analysis to monitor daily KPI performance using Power BI Analytics for potential locomotive services with fuel-saving systems.

• Investigated the changes in key metrics, coordinated with designers and developers, and proposed solutions for operational efficiencies.

• Performed ETL for data cleaning and data validation of existing spreadsheets to promote a robust data management platform, resulting in accurate data analysis and entry using MS Excel Power Pivot.

• Worked alongside research coordinators, and statistical analysts for advancing and modifying existing statistical/mathematical software in line with research plans for potential fuel-saving solutions.

• Create dashboards for identifying the cycle trends using real-time data, and compile analysis reports for Revenue Cycle and management.

• Participate and identify opportunities for implementing delivery process improvements.

• Trained in environments such as Power BI, MS SQL Server/SSRS, MS Excel Power Pivot, MS Office suite. EDUCATION

The University of North Texas,2019-2021 Denton, Texas Master of Science: Data Science GPA: 4.0/4.0

Jawaharlal Nehru Technological University,2014-2018 Hyderabad, India Bachelor’s: Electronics and Instrumentation GPA: 4.0/4.0 CERTIFICATION and RECOGNITIONS

Recognised as Gainwell Technologies- Hall of Fame 2023 for Client Support for LA Care and Cal Optima Health Plan.

Udemy Certified SAP Analytics Cloud Course (Credential no.: d3403fdf-7553-4680-8a2b- aa30e56b3b37)

IBM Certified Data Analysis with Python. (Credential ID: QZS3T8KE2WV6)

General Electronics (GE) Certified Digital Technology Data Analytics Program (Verification Code: ekDDpMyEEfrNkuhMu)

LinkedIn Certified SQL: Data Reporting and Analysis. (Certificate ID: AVjkyVRm2kqfjxxGfUbO8DYQ2bVS)

LinkedIn Certified SPSS Statistics Essential Training. (Certificate ID: AZtWUZVRtsvNav5YootVhivmVFwk)

LinkedIn Certified Foundations of Enterprise Content Management. (Certificate ID: AZfuVfHgRpbkX3- yWBVjkU8wDotq)

Udemy Certified Web Scrapping for Beginners using Python. (Credential no.: UC-abda8f01-d876-4eb2- 8bdc4c23ec658875)

Awarded Gold Medal for Academic Excellence in Bachelor's.

Certification on Business English Certificate (BEC) by Cambridge English.

Certification for Communication and Personality Development from CELT at Osmania University, India.

Contact this candidate