UTKARSH SAXENA
+91- 8090683141
[email protected]
Data Analyst
Noida, Uttar Pradesh
SUMMARY
PL/SQL Developer & Data Analyst with 4+ years of experience in designing, developing, and optimizing
relational databases, data pipelines, and analytical reports. Proficient in writing complex SQL queries, PL/SQL
stored procedures, packages, and performance tuning techniques using tools. Strong experience in data
migration, reconciliation, and data quality assurance. Skilled in collaborating with business stakeholders to
gather requirements, create test cases, and deliver insights through data analysis and visualization. Adept in
tools such as Oracle, SQL Developer, Power BI, Excel,Python, and PySpark.
EDUCATION PROFESSIONAL EXPERIENCE
Data Analyst / PL/SQL Developer
Galgotias University Ultragenic Research & Technologies Private Limited | 2022 - Jul 2025
Master of Computer Applications
Immediately Available
2019 – 2022
Project:- Database Migration & Optimization
Lucknow University As part of a large-scale digital transformation initiative for a global
Bachelor of Computer Applications pharmaceutical client, I led critical components of a database
2016 – 2019 migration and optimization project, with a strong focus on data
quality, system performance, and legacy-to-modern system
SKILLS integration.Executed Exploratory Data Analysis (EDA) on large-scale
SQL, PL/SQL & Oracle Code life sciences datasets, managing over a billion rows using advanced
System Design & Data Management SQL and PL/SQL.
SQL Tuning & Query Optimization Developed and optimized PL/SQL procedures, functions, and
Power BI, DAX, Power Query triggers for data transformation and validation.
Python, PySpark Refactored existing Oracle application logic to improve query
Excel (Advanced), PowerPoint performance using EXPLAIN PLAN, SQL Trace.
Data Migration & ETL Leveraged PL/SQL for efficient data handling during migration.
Data Profiling & Cleaning Created frameworks for data quality checks, error handling, and
Requirement Gathering & Testing transformation rules to maintain data integrity.
Agile & Scrum Methodologies Led technical workshops onsite for a top-tier pharmaceutical
Alternative Solutions client, showcasing SQL-driven migration strategies.
Debugging Collaborated with business users to gather requirements,
Support & Communication analyze legacy and target data structures, and define migration
rules.
Coordinated with cross-functional teams to compile
TOOLS & TECHNOLOGIES deliverables aligned with business expectations.
Oracle 11g/12c
SQL Developer, Project:- Data Extraction & Reconciliation
Power BI, Tableau (basic) In parallel to the migration initiative, I was also responsible for
Python, Jupyter Notebooks managing the data extraction and reconciliation phase, a critical
Excel Macros stage in ensuring data accuracy and regulatory compliance post-
Jira migration.
Wrote optimized SQL queries to extract specific safety case
details from legacy and new databases.
CERTIFICATIONS Performed end-to-end data reconciliation and validation during
MachineLearning fromIntershala and after migration to ensure integrity.
Conducted manual testing and validation of SQL queries using
GenerativeAIfrom Google Cloud
test scenarios, test plans, and test cases.
AWARDS Documented detailed test results and created defect logs for
resolution tracking.
Automated repeatable data validation tasks using PL/SQL
Gold medalist in Master of Computer scripts, enhancing testing efficiency by 30%.
Applications
