RAJANI BEESAM

Data Analyst with 5 years of experience in mining, interpreting, and presenting large datasets to improve efficiency across the organization. Led the implementation of the new data analysis system, achieved quality, and increased data accuracy. Experienced in developing technical documentation, visualization, and providing data insight and impact to drive strategic decision-making.

• Master Data Analyst, CooperVision (Solvencia.Inc), 07/21, 06/23, Ensured master data integrity in key systems as well as keeping processes to support requisite data quality., Founded areas for data quality improvements and helped to resolve data quality problems through right choice of error detection and correction, process control and improvement., Collaborated with subject matter experts (SMEs) and data stewards to ensure enterprise data is correct, complete, secure, and dependable., Managed, analyzed, and resolved data initiative issues and managed revisions needed to best meet internal and customer requirements while adhering to data standards., Helped in data management and governance to ensure master data meets all stated business rules and requirements., Helped in application, implementation, and documentation of procedures of data management, including standards and guidelines to ensure access to and integrity of data sets., Conducted data cleaning to rid systems of old, unused, or duplicate data for better management and quicker access., Worked with Quality team to provide solution for conversion of languages in Lokalise., Maintained confidentiality and HIPAA compliance with all client information obtained in course of work., Reduced manual effort by automating key processes related to master data maintenance and updates using Power BI.
• Quality Data Analyst, OhioGuidestone, 10/17, 07/20, Extracted, interpreted, and analyzed data to find key metrics and transform raw data into meaningful, actionable information., Created, changed, and troubleshoot SQL queries, stored procedures., Cleaned, transformed model data to ensure and improve accuracy of metrics calculations., Helped in design, analysis, and development of data architectures for relational databases., Prepared visually impactful dashboards in Excel, Qlik view and Tableau for data reporting., Developed and automated tools and scripts to increase departmental efficiency and automate repeatable tasks., Optimized data collection procedures and generate reports on weekly, monthly, and yearly basis., Maintain confidentiality and HIPAA compliance with all client information obtained in course of work., Work with financial department and gather requirements, develop stored procedures to generate reports., Working knowledge of EHR systems., Involved in Performance Quality Improvement (PQI) meetings and developed monthly, quarterly, and annual based reports., Develop stored procedures for requirements from program directors and build SSRS reports., Worked with Subject Matter Experts (SME) and project team to gather all data migration and Data mapping requirement.
• Business Analyst, Nixsol Inc, 07/16, 09/17, Developed SQL processes to aggregate data from variety of sources Load externally generated data to Database Server., Worked on Database management., Processes data by SQL Query to make data usable for analysis and project trackers., Worked to find project needs, design relational model, and customize user dashboard., Performed and documented unit testing and system testing of entire ETL process., Position involved extensive routine operational reporting, ad hoc reporting, and data manipulation to produce routine metrics and dashboards., Visualizing analyses creatively using Excel/PowerPoint, Tableau Presenting and explain analysis., Developing data dictionary to ensure efficient communication among different vendors., Worked on Data governance and its workflows., Analyzed data to identify root causes of problems and recommend corrective actions., Created dashboards to monitor and track key performance indicators.