Navatha Reddy Gajjela
Summary
With nearly 7 years of experience in data analysis, business intelligence, and data engineering, this professional specializes in delivering accurate data insights for decision-making. Expertise includes SQL, SSRS, Power BI, Tableau, and SSIS. Additionally, holds a Microsoft Certified Fabric Analytics Engineer Associate certification and possesses a background in developing data models, dashboards, and workflows. Prioritizes efficient reporting, automation, and Agile collaboration to meet business requirements.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Database Analyst
Merchants Bank of Indiana
02.2019 - Current
- Designed and maintained SSRS-based ad-hoc reports audited by federal agencies including MIAC, Fannie Mae, and Freddie Mac, ensuring compliance with industry regulations.
- Created SQL queries for custom reporting needs, reducing report generation time by 30%.
- Built SSRS pipeline reports, improving visibility into loan workflows and enhancing portfolio management.
- Automated recurring SSRS reports to reduce manual work and ensure timely delivery.
- Developed parameterized reports in SSRS, enabling stakeholders to interact with filtered data.
- Conducted root cause analysis using SQL to resolve data discrepancies, increasing accuracy by 35%.
- Integrated SQL-based data validation into financial reporting processes to improve reliability.
- Wrote stored procedures and triggers to automate data updates and streamline processes.
- Designed SQL scripts to monitor database performance and prevent bottlenecks.
- Built Power BI dashboards for tracking loan performance and financial trends.
- Improved SQL queries and SSRS reports to reduce processing time and enhance performance.
- Led the creation of audit-ready financial reports using SSRS to meet regulatory requirements.
- Collaborated with stakeholders to define requirements and develop dashboards in SSRS and Power BI.
- Applied Agile methods to manage tasks, ensuring efficient completion of reporting and data projects.
- Worked closely with IT staff to ensure seamless integration of database elements into new or existing applications, promoting optimal system functionality.
- Proactively engaged in ongoing professional development to maintain expertise in current database management systems and practices.
Data Analyst
PTS Corp
07.2018 - 02.2019
- Created and managed reports using SSRS and Crystal Reports for decision-making.
- Designed Tableau dashboards to improve operational insights and efficiency.
- Developed Power BI dashboards for performance tracking and analysis.
- Conducted portfolio analysis using Tableau and Crystal Reports, reducing processing times.
- Validated post-migration data to ensure integrity and compatibility.
- Built predictive models for loan performance and market trends.
- Created parameterized SSRS reports for customizable business intelligence.
- Resolved data inconsistencies using SQL, improving accuracy by 25%.
- Executed SSIS packages for seamless integration of data from multiple sources.
- Utilized data visualization tools to effectively communicate business insights.
Data Analysis Intern
Lake County Prosecutor's Office
01.2018 - 05.2018
- Supported the enhancement of the office's database system by creating custom SQL queries, facilitating streamlined data management and improved case handling efficiency
- Contributed to the development of Power BI dashboards under mentorship, which visualized case processing times and efficiency metrics, aiding the office in identifying areas for operational improvement
- Gained experience in using Tableau to analyze historical case data, helping to uncover trends and insights that assisted in strategic case prioritization and resource distribution efforts
- Actively participated in Agile methodology workshops and applied Agile principles to data projects, enhancing team collaboration, and project management skills, and accelerating the delivery of data-driven solutions
- Enhanced data accuracy by conducting thorough data cleaning and validation processes.
- Performed ad-hoc analyses as requested by senior leadership, providing crucial support for decision-making processes.
Education
Master of Science - Information Technology and Business administration
Valparaiso University
05.2018
Skills
- SQL, SSRS, SSIS, Power BI, Tableau, Microsoft Fabric
- Business Intelligence: Reporting Automation, Dashboard Development, Data Visualization
- Data Analytics: Performance Metrics, Root Cause Analysis, Trend Analysis
- Data Engineering: ETL Processes, Data Modeling, Data Integration
- Agile Collaboration: Sprint Planning, Task Management, Team Coordination
- Stakeholder Communication: Requirements Gathering, Reporting, Collaboration
Accomplishments
Microsoft Certified: Fabric Analytics Engineer Associate
Certification
- Microsoft Certified: Fabric Analytics Engineer Associate
- Earned:2024-07-18 | Expiry:2025-07-19
https://www.linkedin.com/in/navathareddygajjela/
Timeline
Database Analyst
Merchants Bank of Indiana
02.2019 - Current
Data Analyst
PTS Corp
07.2018 - 02.2019
Data Analysis Intern
Lake County Prosecutor's Office
01.2018 - 05.2018
Master of Science - Information Technology and Business administration
Valparaiso University
Similar Profiles
MICHAEL EisingMICHAEL Eising
VICE PRESIDENT MORTGAGE COMPLIANCE MANAGER at MERCHANTS BANK OF INDIANAVICE PRESIDENT MORTGAGE COMPLIANCE MANAGER at MERCHANTS BANK OF INDIANA
Elizabeth GrayElizabeth Gray
Personal Banker at Merchants Bank Of IndianaPersonal Banker at Merchants Bank Of Indiana
KARA SANDOVALKARA SANDOVAL
Senior Personal Banker at Merchants Bank of IndianaSenior Personal Banker at Merchants Bank of Indiana