Data Analyst Business Intelligence

Jaswanth Sai Donepudi

**************@*****.*** +1-940-***-**** Denton, TX.

PROFESSIONAL SUMMARY

Data Analyst with 4 years of experience delivering data-driven solutions in technology-focused environments. Specializes in PL/SQL development, Oracle Exadata and 10g databases, and end-to-end ETL workflows. Adept at designing and optimizing complex queries, stored procedures, and data validation routines to ensure data quality and integrity. Advanced proficiency in business intelligence tools, including Power BI and Microsoft Excel, for building interactive dashboards and reporting solutions that support decision-making.

EDUCATION

Master of Science in Computer Science

University of North Texas 3.6/4.0

TECHNICAL SKILLS

Databases: Oracle 10g, Oracle Exadata, PL/SQL, Stored Procedures, Relational Databases

Data Analytics: Complex Query Writing, Test Scenarios, Integration Testing, Data Cleansing, Data Modeling

Data Engineering: ETL Workflows, Python (Pandas), Data Validation Routines, Data Profiling, Data Pipelines

Project & Process Management: Agile (Scrum), Financial Estimation Models, Sprint Planning, Resource Estimation

Business Intelligence & Reporting: Power BI, Microsoft Excel, Microsoft PowerPoint, Interactive Dashboards, Reporting Tools

WORK EXPERIENCE

Sorcero, Data Analyst Jan 2024 - Present

●Developed complex PL/SQL queries and stored procedures in Oracle 10g to extract, cleanse, and validate large volumes of unstructured medical data for analytics and downstream processing.

●Designed reliable data models and ensured seamless integration between relational databases and data warehouses, supporting the Sorcero Intelligence Platform’s analytics and reporting needs.

●Built and automated ETL workflows using Python and Pandas, transforming diverse datasets from multiple sources into consistent, high-quality assets for AI initiatives and decision support.

●Created and maintained interactive dashboards and reports in Microsoft Power BI, delivering actionable insights to both technical and non-technical life sciences stakeholders.

●Prepared structured datasets for AI and machine learning training, focusing on data completeness, accuracy, and regulatory compliance to support improved patient outcomes.

●Implemented rigorous data validation and profiling routines, proactively identifying data inconsistencies and driving efforts to strengthen data quality across all input pipelines.

●Utilized Microsoft Office suite, including Excel and PowerPoint, to document data mappings, present findings, and support requirements gathering with business and technical teams.

●Participated in Agile ceremonies, contributing to user story refinement, estimation, and sprint planning to ensure timely delivery of analytics solutions for the Sorcero platform.

●Worked closely with cross-functional teams to clarify analytical requirements, map data flows, and design solutions that address both operational and strategic business goals.

●Supported data governance efforts by maintaining lineage documentation and ensuring that all data handling practices adhered to organizational and industry compliance standards.

Apica, Data Engineer Jun 2021 - Jun 2023

●Developed and optimized PL/SQL queries and stored procedures in Oracle Exadata to support wholesale credit product data processing and KYC onboarding workflows for enterprise clients.

●Built data validation routines for client onboarding datasets, implementing checks for data completeness and compliance with regulatory standards in Oracle 10g environments.

●Created detailed test scenarios and executed integration testing to ensure robust interfaces between credit systems and enterprise onboarding platforms.

●Used Microsoft Excel and PowerPoint to prepare executive-level summaries and technical documentation, translating data analysis findings for both business and technical stakeholders.

●Designed end-to-end data pipelines supporting large-scale credit analytics, connecting multiple enterprise applications to provide unified reporting and operational dashboards.

●Participated in Agile sprint planning and estimation sessions, breaking down requirements, identifying dependencies, and prioritizing analytics deliverables for timely project completion.

●Developed financial and resource estimation models in Microsoft Excel to support project management and track effort across multiple data initiatives.

●Worked closely with technology and business teams to clarify wholesale credit product requirements and translate them into technical data solutions.

●Analyzed process flows across client onboarding and credit systems, identifying opportunities for automation and recommending improvements to enhance data integrity.

●Provided guidance to junior analysts, reviewing query logic and test plans while encouraging open communication and collaboration within distributed Agile teams.

CERTIFICATIONS

Microsoft Certified: Azure Security Engineer Associate

Google Data Analytics – Data, Data, Everywhere

IIT Bombay – RDBMS Training

Deeplearning.ai – AI for Everyone

UC San Diego – Mathematical Thinking in CS

Palo Alto – PCCET (Cybersecurity Entry Level)

Contact this candidate