Yamini Krishna
Cincinnati,OH
Summary
Adept at leveraging extensive experience in data analysis and IT service management, I significantly enhanced operational efficiency and decision-making. My expertise in SQL and collaborative problem-solving skills have driven improvements in service quality and data-driven insights, aligning with key business objectives.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Sr. Database Report Writer
North American Risk Services
03.2024 - Current
- Expertly design and develop Web Intelligence reports using SAP BI universe design tool, Crystal Reports (SAP Crystal Reports 2019/2020) and ad-hoc using Oracle SQL Server ensuring accurate, secure, and efficient data reporting for business users.
- Optimized complex SQL queries to generate standard reports that could be used across multiple clients, ensuring consistency and efficiency in report generation.
- Administered BI folder security, user/group security via CMC to ensure proper access control and data protection across multiple departments internally and for external clients as well.
- Monitored and supported report schedules; utilized Query Builder to analyze and resolve scheduling issues, optimizing report generation processes and reducing delays.
- Monitor month end reports and work on the failed reports.
- Working on the migration of Business Objects (BO) from on-premise infrastructure to AWS, utilizing Oracle GoldenGate for real-time data replication, ensuring efficient cloud data management and minimal downtime.
- Perform complex calculations on the backend related to claims and financial data, ensuring the accuracy of data for reporting and business decision-making as per clients requirements.
- Regularly updated and managed reports on the SILO site, improving accessibility and ensuring that reports are readily available for business stakeholders.
- Develop visually appealing and insightful dashboards using DOMO BI for metrics and daily tracking sessions.
- Managed and track the ORAETL process to streamline data extraction, transformation, and loading tasks, ensuring seamless data flow across systems.
- Utilize Toad and DBeaver for database management, query optimization, and advanced data analysis, ensuring accuracy and efficiency in report generation and database operations.
- Developed complex SQL queries for standard reports, allowing for reuse across multiple clients and significantly reducing development time.
- Worked on advanced Excel to create an interactive dashboards for yearly metrics for auditing purpose.
- Daily communication with the Infrastructure team, SAP BO Architect, Client Relations, and the Development team to gather requirements and ensure that reports and BI solutions meet business needs.
Data Analyst Intern
BroadMinds Inc
02.2024 - 03.2024
- Assisted in the development and optimization of ETL processes using SSIS to streamline data integration
- Collaborated with senior analysts to design SSRS reports and generated user-friendly business intelligence reports.
- Wrote SQL queries to extract, filter, and analyze datasets from multiple sources.
- Utilized advanced Excel functions such as pivot tables, VLOOKUP, complex formulas, and data visualization techniques to support data analysis and reporting tasks.
- Data Cleaning & Transformation: Assisted in cleaning, transforming, and validating data to ensure accurate reporting and analysis using ETL tools and advanced Excel features.
ITSM Data Analyst
IBM
10.2019 - 07.2022
- Leveraged ITSM data to identify patterns and trends, proactively predicting potential issues, and recommending preventive actions to minimize disruptions and improve operational efficiency.
- Created comprehensive reports and interactive dashboards using Power BI and SQL to communicate data-driven insights to IT service management teams, stakeholders, and leadership, enabling data-informed decision-making and performance tracking.
- Managed major incidents by analyzing root cause data, providing detailed post-incident reports, and coordinating with cross-functional teams to implement preventive measures and improve incident response.
- Utilized data analytics to investigate and uncover root causes of recurring issues within IT services, providing actionable insights to reduce incidents and improve service quality.
- Actively reviewed, assessed, and approved change requests, participated in Change Advisory Board (CAB) meetings, ensuring all changes were properly evaluated and aligned with business requirements.
- Conducted ticket quality evaluations and prepared detailed KPI metrics using advanced Excel to offer deeper insights into performance trends and areas for service improvement.
- Created and maintained interactive ServiceNow dashboards and reports, enabling real-time tracking of service performance, incident resolution, and customer satisfaction metrics.
- Facilitated communication across multiple teams, including IT service management, development, and operations, to ensure alignment on project goals, issue resolution, and process improvements.
- Applied ITIL best practices throughout the IT service management lifecycle, focusing on incident, problem, and change management processes to ensure alignment with business objectives and continuous service improvement.
- Worked within agile environments, contributing to sprint planning, daily stand-ups, and retrospectives to ensure continuous feedback and improvement in service management processes.
- Utilized Microsoft Office Suite for Preparing and delivering data-driven presentations for client audits, providing transparency into performance metrics, service trends, and areas of improvement.
Education
Master of Science - Information Technology
University of Cincinnati
Cincinnati, OH12-2023
Skills
- Data Analysis & Reporting Tools: Power BI, Tableau, SSRS, SSIS, SSAS, SAP Business Objects (BO), Crystal Reports, Web Intelligence reports
- Database Management & Development: SQL Server Management Studio (SSMS), PL/SQL, Python (Basics)
- Data Querying & Scripting: SQL, PL/SQL
- IT Service Management: Incident Management, Problem Management, Change Management, Service Level Management
- Microsoft Office Suite
Certification
- AZ 900 Microsoft Azure Fundamentals .
- DP 900: Microsoft Azure Data Fundamentals
- Power BI Udemy
- ITIL Foundation and RCV Intermediate Certification – AXELOS Global Best Practice.
Timeline
Sr. Database Report Writer
North American Risk Services
03.2024 - Current
Data Analyst Intern
BroadMinds Inc
02.2024 - 03.2024
ITSM Data Analyst
IBM
10.2019 - 07.2022
- AZ 900 Microsoft Azure Fundamentals .
- DP 900: Microsoft Azure Data Fundamentals
- Power BI Udemy
- ITIL Foundation and RCV Intermediate Certification – AXELOS Global Best Practice.
Master of Science - Information Technology
University of Cincinnati
Similar Profiles
Sarah DuRapauSarah DuRapau
Compliance Data Integrity Coordinator at North American Risk ServicesCompliance Data Integrity Coordinator at North American Risk Services
Cassandra EubankCassandra Eubank
Senior Litigation Adjuster at North American Risk ServicesSenior Litigation Adjuster at North American Risk Services
Noah EastmanNoah Eastman
Assistant Unit-Manager at North American Risk Services (NARS)Assistant Unit-Manager at North American Risk Services (NARS)