We provide IT Staff Augmentation Services!

Data Analyst Resume

3.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • An experienced Oracle professional development/Data Analyst experienced using Oracle and UNIX in Web and Client/Server environments projects.
  • Oracle experience: Databases, Forms, Reports, SQL and PL/SQL Developer.
  • Experience upgrading Oracle Forms from 6i to 9i to 10g.
  • Experience building backend automation wif Python and Oracle reporting.
  • Experience migrating legacy system data to new client/server systems.
  • Full SDLC experience.
  • Excellent communication skills; experience mentoring staff.
  • Current member of multiple Oracle user groups, and Python user groups.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, and 12c

Operating Systems: Unix, Linux, Windows 9x, Windows 7

Performance Tuning: Quest SQL Optimizer, Explain Plan, SQL Trace

Languages: PL/SQL, SQL, Shell Script, HTML, Perl, Python 3

Tools: Oracle Developer Suite 10g, Oracle Report Builder 4.5, 6i, 9i, 10g, Oracle Forms Builder 4.5, 6i, 9i, 10g, Subversion, TOAD, SQL Developer, Jupyter Notebook

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Data Analyst

Responsibilities:

  • Responsible for Analyzing Business Requirements, Developing, Testing, and Support of PLSQL programs for Market Regulatory On-Line (MROL) Surveillance Reviews.
  • Closely working wif Regulatory Operation Department of teh Exchange on UAT Test Cases development.
  • Develop and implement SQL or PL/SQL batches for Regulatory processing of MROL Regulatory reporting system for business rules.
  • Develop programs for Compliance Department wif our Integrity Assurance reporting system for daily processing including LULD and Timeliness/Sent to Tape System Integrity Checks.
  • Created and continue to enhance teh Infrastructure for libraries for backend Python scripts
  • Develop Python scripts for automation of nightly jobs on various jobs from reports for Surveillance and Regulatory requirements.
  • Participated on rewrite project FOCUS on Access to PL/SQL stored procedure and conversion from Oracle Reports 10g to BIRT Reports.
  • me Participated in CAT UAT Testing for OTQT and UDDQ using Jupyter Notebook using teh CAT API (Restful Webservices)
  • Created functional and technical specifications, test plans, end-user documentation.
  • Provide support business to existing mission critical PL/SQL application in Production and Maintenance.
  • Participated in Collaborate wif other developers in Communication and Team Interaction to solve problems.
  • Shared noledge wif presentation on topics to share wif teh development group.

Confidential, Naperville, IL

Data Analyst

Responsibilities:

  • Analyzes, develops, tests, and supports all aspects of Oracle PL/SQL procedure development.
  • Develop complex procedures, data transaction volumes and tuning experience.
  • Strong noledge of Forms and Reports and SQL coding design patterns.
  • Writing Unix shell scripting experience.
  • Provide mentoring to support team members.

Confidential, Rosemont, IL

Data Analyst

Responsibilities:

  • Working in Confidential project following its Methodology.
  • Gathering requirements from clients to form Business specs.
  • Analyzes, designs, develops, tests, and supports all aspects of Oracle PL/SQL procedure development.
  • Developer Complex procedures, high transaction volume and tuning experiences
  • Strong noledge of Oracle features and SQL coding design patterns
  • Writing Unix shell scripting experience.
  • Feels comfortable in assuming different roles as a member of teh development team.

We'd love your feedback!