LAKSHMI TANUJA TANGA

Client: BlueCross BlueShield of South Carolina

• Developed and maintained recurring monthly, quarterly, and semiannual reports using MS Access and Excel, ensuring timely and accurate data delivery.
• Analyzed and extracted data from multiple sources to support I/S business operations, covering people data, vendor metrics, budgeting, and timekeeping.
• Automated routine reports reduce manual effort by 25%, and improve report turnaround time.
• Designed advanced Excel formulas and macros to streamline data processing, improving data accuracy, and efficiency.
• Collaborated with stakeholders to gather report requirements, ensuring ad hoc reports met business needs, and data-driven decisions.
• Ensured data integrity by performing data cleaning and validation, reducing errors in reporting and analysis.
• Enhanced reporting accuracy by optimizing data retrieval methods, and implementing best practices in data formatting and structuring.
• Maintained strict deadlines, ensuring all recurring and ad hoc reports were delivered on schedule, with high accuracy.
• Developed and maintained SharePoint repositories, improving data organization and accessibility for reporting processes.
• Identified inefficiencies in reporting workflows, and implemented process improvements, reducing reporting cycle time by 15%.
• Worked closely with IT and data teams to identify appropriate data sources, and ensure seamless integration into reporting frameworks.
• Documented reporting processes, ensuring knowledge transfer, and standardization for future enhancements.
• Led process automation initiatives, leveraging VBA and Power Query, reducing manual data entry by 30%, and increasing productivity.

Department: College of Engineering and Computing.

• Supported office operations by managing and organizing administrative projects, ensuring efficiency in daily tasks.
• Created spreadsheets in Microsoft Excel for record-keeping and reporting.
• Optimized document management, handling copying and filing to improve accessibility and retrieval speed.
• Conducted basic data analysis, summarizing office activities and visitor inquiries to identify trends.
• Assisted in office workflow optimization, identifying inefficiencies, and suggesting improvements.
• Handled administrative support for faculty, ensuring smooth processing of requests and project materials.
• Developed organizational strategies for better resource management, improving office productivity.
• Executed research tasks as needed, gathering and compiling information for office reports.

Department: Yvonne and Schuyler Moore Child Development Research Center.

• Collected and analyzed large-scale national data sets, employing data collection using Logi Report Builder to ensure comprehensive and accurate data acquisition.
• Cleaned and processed data using advanced Excel functions, ensuring data readiness for detailed analysis, while improving processing accuracy by 20%.
• Conducted statistical analysis on child development data using SAS, identifying trends and patterns that supported key research outcomes.
• Created data visualizations using tools like Excel and PowerPoint, enhancing the clarity and accessibility of research findings for stakeholders.
• Developed interactive dashboards in Power BI to visualize and monitor key metrics, enabling stakeholders to make data-driven decisions with real-time insights, and improved reporting efficiency.
• Developed custom scripts and macros in Excel for automating data transformation, reducing manual labor, and improving efficiency by 30%.
• Collaborated with multidisciplinary teams, including researchers, educators, and policymakers, to align data insights with project objectives.
• Documented data collection methodologies and procedures, ensuring reproducibility and consistency across future research projects.
• Performed quality control checks on datasets before analysis, reducing potential errors in the final research findings.
• Managed and organized research documents and data sets on SharePoint, ensuring seamless collaboration and version control across teams, while enhancing data accessibility and workflow efficiency.
• Provided real-time data support to team members during research presentations and meetings, facilitating informed decision-making.
• Assisted in the development of research reports for publication, contributing to peer-reviewed articles, and policy recommendations.

Department : Darla Moore School of Business

• Conducted consumer behavior analysis related to marketing and linguistic claims, using SAS and Excel to provide actionable insights.
• Improved data collection efficiency by 30%, optimizing methods through automation, and restructuring workflows to reduce redundancy.
• Streamlined volunteer recruitment processes, ensuring representative samples for research studies, and improving recruitment effectiveness by 25%.
• Implemented data validation protocols that increased the quality of datasets by 40%, reducing error rates, and improving overall research reliability.
• Monitored study protocol adherence, ensuring data collection followed stringent quality control standards, and minimizing discrepancies in datasets.
• Coordinated with faculty and research teams to align project goals with data-driven insights, leading to more impactful study conclusions.
• Developed standard operating procedures for data collection and analysis, ensuring consistent methodologies across multiple research studies.

• Utilized Electronic Health Records (EHR) systems to manage and maintain patient records, ensuring compliance with HIPAA, and other data privacy regulations.
• Implemented data management protocols to improve data accuracy and completeness, increasing the reliability of patient information by 25%.
• Applied data analytics techniques to extract meaningful insights from patient records, aiding in the development of personalized treatment plans.
• Conducted data quality checks and audits on patient records, identifying discrepancies, and improving the integrity of healthcare data.
• Collaborated with clinical teams to analyze patient outcomes, providing data-driven insights that directly informed treatment strategies.
• Developed dashboards and reports using Excel, providing healthcare providers with real-time access to critical patient data.
• Assisted in the integration of EHR systems with data analytics tools, enhancing the clinic’s ability to derive actionable insights from patient records.
• Participated in interdisciplinary meetings to provide data-driven recommendations that supported clinical decisions and treatment plans.