Candidate Information Title Data Analyst Sql Server and Oracle Target Location US-PA-Philadelphia	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Data Analyst Sql Developer Doylestown, PA Data Analyst Business Intelligence Morristown, NJ Power Bi Data Analyst Edison, NJ Supply Chain Data Analyst Coatesville, PA Data Analyst Business Edison, NJ Data Analyst - Work From Home Morrisville, PA Senior Data Analyst Philadelphia, PA

Database Developer/Data AnalystFirst Judicial District of PhiladelphiaOctStreet Address  - PresentCollaborated closely with Agile teams to gather and analyze requirements from business users and stakeholders.Developed and maintained Oracle Forms and Reports based on user requests, ensuring alignment with organizational objectives.Designed and implemented Statistical Reports for tracking case status, monthly, and quarterly counts, facilitating data-driven decision-making.Utilized SQL Loader for efficient loading of monthly county data from flat files to database tables, optimizing data management processes.Conducted database performance optimization by analyzing and optimizing SQL queries and procedures.Extracted and visualized data using SQL queries and Tableau reports to support business analysis and reporting requirements.Sr. Oracle DeveloperKentucky Board of Nursing, KYJuly20 - Sep23Led the migration effort of Oracle Forms and Reports from 9i to 12c, ensuring seamless transition and improved accessibility.Designed and developed SSRS reports for the MS SQL Server database, enhancing reporting capabilities and providing valuable insights for decision-making.Utilized SSIS for data integration tasks, ensuring efficient and reliable data transfer between disparate systems.Played a key role in the database migration from Oracle to Microsoft SQL Server, ensuring data integrity and system functionality.Collaborated with cross-functional teams to gather requirements, design solutions, and implement enhancements, ensuring alignment with business objectives.Data Engineer/ETL DeveloperIBM, Raleigh, NCSep18  June20Spearheaded the development of ETL workflows and mappings using IBM DataStage, facilitating efficient data extraction and transformation processes.Utilized SSIS for data integration tasks, ensuring seamless data transfer between heterogeneous data sources.Scheduled and monitored jobs for data extraction, transformation, and loading using IBM DataStage Director and SSIS, ensuring timely and accurate data delivery.Implemented performance optimization techniques, including index implementation and SQL query tuning, to enhance system efficiency and throughput.Collaborated with business analysts and stakeholders to understand requirements and translate them into technical specifications.Played a key role in supporting business and user acceptance testing, ensuring the quality and reliability of delivered solutions.Oracle DeveloperAnthem Inc., Norfolk, VA Nov17  Sep18Developed and maintained PL/SQL packages, stored procedures, and triggers for claims processing, ensuring system reliability and efficiency.Conducted performance tuning of SQL queries and PL/SQL code, optimizing system performance and responsiveness.Supported APEX applications and conducted performance tuning for PLSQL, enhancing application performance and user experience.Contributed to the development and maintenance of SSRS reports for business analytics, providing valuable insights for decision-making.Collaborated with cross-functional teams to gather requirements, design solutions, and implement enhancements, ensuring alignment with business objectives.Oracle PL/SQL & Apps DeveloperJ. M. SMUCKERS, Orrville, OHSep'16 - Sep17Designed and implemented ETL processes using SQL*Loader and Informatica PowerCenter, ensuring accurate and efficient data integration.Maintained Oracle Applications EBS R12 and conducted SQL query tuning, optimizing system performance and reliability.Developed and maintained PL/SQL packages, stored procedures, and triggers for application functionality, ensuring system integrity and reliability.Collaborated with business analysts and stakeholders to gather requirements, design solutions, and implement enhancements, ensuring alignment with business objectives.Provided technical guidance and support to junior developers, fostering a collaborative and productive work environment.Oracle PL/SQL DeveloperCredit Suisse, Morrisville, RTP, NCJan15- Aug'16Developed and maintained PL/SQL packages, stored procedures, and triggers, ensuring system reliability and efficiency.Coordinated with QA team and users for user acceptance testing, ensuring the quality and reliability of delivered solutions.Contributed to Oracle Database Migration from 11g to 12c, ensuring seamless transition and data integrity.Developed and maintained UNIX scripts for file transmission, ensuring secure and reliable data exchange.Provided technical support and troubleshooting for database-related issues, ensuring system stability and uptime.