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.
