Pavan C Email & Phone Number

Atlanta Metropolitan Area

• Assisted in collecting and documenting business requirements from stakeholders using interviews, surveys, and observation techniques.• Performed basic data analysis using PowerBI and Excel , SAS to support business decisions and provide data-driven insights.• Created reports and dashboards to visualize data findings and presented them to leadership, offering suggestions for improvement.• Mapped and documented business processes and workflows, identifying areas for process improvement and efficiency.• Collaborated with team members and stakeholders to ensure a clear understanding of requirements and deliverables.• Developed and maintained robust data models and reporting systems, leveraging SQL for database management and advanced analytics concepts in Python.• Participated in user acceptance testing (UAT) to ensure that solutions met business requirements, documenting and reporting any issues.

Savannah, Georgia, United States

• Performed basic data analysis to support business decisions, recognizing patterns in data to support healthy business growth.• Developed data models and reporting systems, increasing departmental productivity.• Created data visualization dashboards using PowerBI and Power Suite delivering actionable insights to stakeholders and driving data-informed decision-making.• Assisted in coordinating and facilitating project meetings and tracking project progress using project management software.• Supported project management activities, ensuring the timely delivery of analytics solutions aligned with business objectives.

Kent, Ohio, United States

enhance performance.• Managed daily data operations across Microsoft Access and SQL Server Integration Services (SSIS), ensuring data accuracy and timeliness.• Supported the review and analysis of external data sources, recommending and implementing strategies to standardize schemas.• Assisted in preparing presentations and reports for management, contributing to data-driven decision-making across university departments.• Interpreted and communicated analytical results to university leadership and departments, facilitating strategic discussions and actions that contributed to the enhancement of academic and administrative processes, utilizing SQL, Python, and data visualization tools.• Developed and maintained robust data models and reporting systems at Kent State University, leveraging SQL, SAS for database management and advanced analytics concepts in Python, resulting in data-driven decision-making across university departments.• Designed and implemented technical processes addressing university business challenges, such as optimizing ETL processes using Informatica and SSIS, resulting in improved operational efficiency and performance metrics for key stakeholders.

India

• Automated mortgage reports using structured query language (SQL) and Python in various technologies such as Katelon Tiger VNC, facilitating the extraction of both recent and previous client data efficiently.• Reduced data processing time for mortgage reports by 30% through the implementation of automated test scripts and optimized SQL queries.• Accomplished automated mortgage reports and conducted performance testing across multiple browsers including Chrome, Microsoft Edge, and Firefox, in various environments including quality assurance (QA) and production (Prod).• Achieved a 20% improvement in system performance by conducting rigorous performance testing across multiple browsers and environments, ensuring optimal user experience.• Demonstrated proficiency in SQL for data manipulation and analysis, enhancing data accuracy and reliability within mortgage reports at Fidelity National Financial.• Collaborated within cross-functional teams to ensure the smooth execution of projects and contributed to the improvement of quality assurance processes at Fidelity National Financial.

India

• Demonstrated proficiency in SQL by developing and optimizing database queries and managing relational databases, contributing to the efficient storage, retrieval of data.• Leveraged Python programming skills to automate tasks and streamline processes, enhancing productivity and efficiency within the APSSDC projects.• Improved project efficiency by 15% through the implementation of optimized Python database code, reducing latency in data retrieval and processing.• Achieved a 25% reduction in system downtime by implementing proactive monitoring and maintenance strategies, ensuring uninterrupted access to information.• Contributed to ETL processes by manipulating and transforming data using Python and SQL, ensuring data integrity and consistency across various platforms.• Gained exposure to ETL tools such as Informatica and SSIS, assisting in data extraction, transformation, and loading tasks, thereby facilitating seamless data integration and management.