Poornima Gaikwad
Sql Developer Data Analyst @Illinois State Police
Signup · Get unlimited contacts
WORK HISTORY
Sql Developer Data Analyst @Illinois State Police
Analyzed and optimized Illinois State Police’s application and its crime database (299+ tables), improving operational efficiency through actionable insights.• Led data migration from Oracle 10g to Oracle Cloud’s Autonomous Database, enhancing data accuracy and identifying 20+ critical optimizations using SQL and ETL processes.• Redesigned the client application in Oracle Application Express (APEX), implementing UI/UX improvements based on detailed analysis and user requirements, increasing user interface efficiency.• Developed/optimized T-SQL queries by 50% in Oracle SQL Developer, accelerating data retrieval.• Designed and executed 140+ test cases (system, unit, regression, UAT) based on user stories, resolving 120+ defects pre-launch to ensure 100% compliance with business needs and Quality Assurance standards.• Led weekly discussions with developers, end-users, and stakeholders to align system enhancements with business goals, resolve testing issues, and drive continuous improvements. Ensured CJIS compliance by implementing secure data practices, managing risks, and communicating critical requirements.• Documented database structure, SQL scripts, requirement traceability matrices (RTM), providing comprehensive records for future reference.
EDUCATION
KG Reddy College of Engineering and Technology
Bachelor of Technology - BTech, Computer Science
University of Illinois Springfield
Master of Science - MS, Computer Science
ABOUT POORNIMA GAIKWAD
I am a technology professional with a Master’s degree in Computer Science and over 4…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.