Data Analyst Business Intelligence

KUSUMA MANDYAM

Denver, Colorado, ***** 970-***-**** ******************@*****.*** LinkedIn GitHub

3+ years of experience in SQL development, data visualization, and business intelligence.

Proficient in creating and managing stored procedures, triggers, and views to enhance database functionality.

Experienced in performance tuning and query optimization, improving database efficiency.

Skilled in implementing data security measures and user access controls in SQL environments.

Expertise in utilizing SQL for data integration and migration across platforms and systems.

Familiar with advanced SQL functions, including window functions and common table expressions (CTEs).

Proven track record in optimizing database performance, managing IT systems, and delivering actionable insights to support strategic decision-making.

Experienced in conducting data quality assessments and implementing data validation techniques.

Strong background in writing technical documentation for data processes and database architecture.

Proficient in leveraging SQL with BI tools (Power BI, Tableau) for dynamic reporting and dashboard creation.

Knowledgeable in managing cloud-based SQL databases such as AWS RDS and Azure SQL Database.

Committed to improving data processes and methodologies through best practices and automation.

Passionate about leveraging data to drive innovation in healthcare IT and enterprise systems.

Skilled in testing, statistics, process improvement, algorithms.

Experience:

SODEXO SOUTH DAKOTA, USA BUSINESS DATA ANALYST Aug 2023 – Dec 2023

Analyzed financial data to support budgeting and forecasting processes, ensuring alignment with company goals and identifying cost-saving opportunities.

Assisted in the preparation of monthly, quarterly, and annual financial reports, ensuring accuracy and compliance with internal policies and external regulations.

Reconciled accounts and verified financial transactions, identifying discrepancies and implementing corrective actions to maintain financial integrity.

Collaborated with cross-functional teams to streamline financial processes, improving operational efficiency and reducing invoice processing times.

Assisted in the preparation and analysis of cost reports for client accounts, providing insights that supported strategic decision-making and improved financial performance.

Monitored and managed accounts payable and receivable, ensuring timely processing and minimizing outstanding balances.

Supported internal and external audits by providing required documentation, ensuring compliance with accounting standards and Sodexo’s financial policies.

Utilized accounting software to track financial transactions and generate reports, improving accuracy and reducing manual data entry errors.

DXC TECHNOLOGY Bengaluru, IN ASSOCIATE SOFTWARE ENGINEER Mar 2022- Aug 2023 DATA ANALYST

Designed and optimized complex SQL queries to retrieve, analyze, and report on large datasets, enhancing data accessibility for business intelligence teams.

Developed stored procedures, views, and triggers to automate data processing, reducing manual tasks and ensuring accuracy.

Managed database performance and indexing strategies to improve query efficiency and maintain data integrity.

Implemented and customized ServiceNow modules for incident, problem, and change management, streamlining workflows and enhancing operational efficiency.

Developed ServiceNow automation workflows, reducing response times and improving service request handling.

Analyzed IT processes to identify automation opportunities within ServiceNow, leading to a reduction in ticket resolution times.

Oversaw IT operations, ensuring system reliability, security, and availability across multiple applications and databases.

Coordinated cross-functional teams to deploy IT solutions, managed project timelines, and ensured alignment with business objectives.

Led incident response and troubleshooting efforts, minimizing downtime and improving overall IT service quality.

Developed and enforced IT policies, best practices, and documentation to enhance team productivity and maintain compliance.

HARITHA IT SERVICES Tirupati, IN DATA ANALYST (SQL Developer) Mar 2020 – Mar 2022

Built SQL scripts to automate data extraction, transformation, and loading (ETL) processes, reducing data processing times by 30%.

Created data models and performed normalization to optimize database structure, supporting efficient data storage and retrieval.

Conducted SQL performance tuning and indexing, resulting in query speed improvements and reduced load times across critical applications.

Configured ServiceNow to automate onboarding and offboarding workflows, ensuring smooth, compliant transitions for employees.

Developed custom ServiceNow dashboards and reports for real-time insights into key metrics, improving decision-making for IT and business leaders.

Integrated ServiceNow with other ITSM tools and applications, providing seamless data flow and reducing system redundancies.

Directed IT infrastructure projects, coordinating with vendors and stakeholders to ensure timely delivery and within budget.

Designed and implemented a disaster recovery and business continuity plan, securing critical operations during unexpected disruptions.

Established KPIs and performance metrics to monitor IT operations, resulting in a 25% improvement in service uptime and response rates.

Internship:

Data Operator Aarthi Scans and Labs Chennai, India

Built Python scripts to clean and preprocess datasets, improving data accuracy for operational analysis.

Designed real-time dashboards for tracking lab operations, enhancing SLA compliance.

Data Technician Sri Venkateswara Institute of Medical Sciences Tirupati, India

Managed and maintained electronic health records to ensure compliance with healthcare regulations.

Analyzed patient data to identify trends and support initiatives for improving healthcare outcomes.

Created clinical dashboards to provide physicians with actionable insights on treatment efficacy.

Publications:

Published a paper in “European Journal of Molecular & Clinical Medicine” on Advance treatment regimes and application of regenerative medicine for human male infertility treatment. https://ejmcm.com/article_3258.html

Programming Languages: SQL, Python (Pandas, NumPy, Matplotlib, Scikit-learn), Java, C++, PL/SQL, JSON, VB, .NET

Database Management: MySQL, SQL Server, Oracle 12c, AWS RDS, MongoDB, DynamoDB

Data Visualization Tools: Power BI, Tableau, Excel (Pivot Tables, VLOOKUP, Charts)

Cloud Technologies: AWS (EC2, S3, RDS, Lambda, CloudWatch, IAM, CDK)

ITSM Tools: ServiceNow (Configuration, Workflow Automation, Dashboard Design)

Frameworks & Tools: React, Spring Boot, Apache Tomcat, Struts, Node.js, Hibernate

Software Development Methodologies: Agile, Scrum, SDLC, OOAD

Version Control: Git, SVN, RTC

ETL Tools: Informatica, Talend, SQL scripts for ETL processes

Testing, statistics, process improvement, operating systems, lightning, IP, HubSpot, Google Analytics, Go, Forth, Firefox, cookies, communication, collaboration, classification, assembly, algorithms, ad technology

Projects

Sales Data Dashboard (Power BI):

Built interactive dashboards analyzing sales trends and revenue growth using public datasets.

Healthcare Data Analysis (Python):

Processed patient admission data to uncover trends and suggest strategies for reducing readmission rates.

ServiceNow Integration:

Automated IT workflows, integrating multiple systems for seamless ticket management.

Education

DAKOTA STATE UNIVERSITY – 90% South Dakota, USA MASTERS IN INFORMATION SYSTEM

SAVEETHA SCHOOL OF ENGINEERING – 82% Chennai, India BACHELOR IN BIOMEDICAL ENGINEERING

Contact this candidate