Database Analyst Resume
3.00/5 (Submit Your Rating)
Wells, Fargo
SUMMARY
More than 17 years programming and application development experience.
COMPUTER SKILLS
Languages:
- Proficient in COBOL, PL/SQL, SQL,Mapper
- Familiar with C, Pro*C, SAS
Software:
- Database: Oracle, Teradata.
- Platforms: Windows 95, Novell Networks, Windows 3.1, NT, AIX,UNIX, PC DOS, Windows XP
- Programming Tools: Toad, Teradata SQL Assistant,Net Express, Server Express, Micro Focus, Developer 2000
- Other: Discoverer, Lotus Notes, Outlook, VSAM Files
EXPERIENCE:
Confidential
INDEPENDENT CONTRACTOR
Responsibilities:
- Help set up home computers for people.
- Hook up monitor, speakers, printers and networks together.
DATABASE ANALYST
​Responsibilities:- Primary responsibilities including coding and testing using Oracle, UNIX, PL/SQL and Teradata.
- Troubleshoot issues that came up. Fixed or did work arounds to take care of these issues.
- Research issues for business customers.
- Worked with Users directly to solve issues they were having.
- Converted SAS SQL code to Oracle PL/SQL
- Converted PL/SQL code from Oracle to Teradata.
PROGRAMMER
​Responsibilities:- Primary responsibilities including coding and testing in Mapper maintaining existing systems and also upgrade existing code.
- Troubleshoot issues that came up. Fixed or did work arounds to take care of these issues.
- Kept a working Knowledge base of solutions to known issues.
- Worked with Users directly to solve issues they were having.
- Created Test Plans to test the solutions I coded.
CONSULTANT POSITION
​Responsibilities:- Primary responsibilities include creating reports using Suprtool, Query, and JCL on a HP3000 system and website testing.
ASSIST SALES MANAGER
​Responsibilities:- Primary responsibilities include process payments, answer buyer questions, make sure items get shipped out in a timely manner, and help owner with special tasks.
Programmer Analyst
​Responsibilities:- Primary responsibilities include analysis and resolve issues.
- Converted products from a HP3000 system using JCL and COBOL to a Sun Solaris using UNIX using COBOL.
- Wrote JCL scripts in UNIX environment.
- Managed the batch program changes and the capturing of the data to do parallel testing of production runs.
- Conversion decrease run time by over 300%
- Troubleshoot issues that came up. Fixed or did work arounds to take care of these issues.
- Created Test Plans for testing solutions of issues I coded.
Senior Programmer Analyst
​Responsibilities:- Managed a Data Warehouse for the main Annuity System using Pro-C, PL/SQL and UNIX. Users could create their own reports through Discoverer. This helped the Users and saved the developers from having to create all of these reports.
- Managed the Report System for the main Annuity System using PL/SQL,SQL,AIX UNIX, Discoverer and Developer 2000 all on an Oracle Database.
- I was the Discoverer Administrator for the Reporting System. I was Responsible for all moves of new and changes to any Discoverer Reports.
- Troubleshoot issues that came up. Fixed or did work arounds to take care of these issues.
- In charge of a knowledge base of solutions to known issues.
- Created Technical Specs from Business Specs to solve Business Issues.
- Created Test Plans for testing solutions of issues I coded.
Programmer Analyst
​Responsibilities:- Managed the Report System for the main Annuity System using PL/SQL,SQL, AIX UNIX, Discoverer and Developer 2000.
- I was the Discoverer Administrator for the Reporting System. I was Responsible for all moves of new and changes to any Discoverer Reports.
- Participated in converting a small Annuity System to the main Annuity System.
- Managed the Tax changes for the year 2000 on the Companies own Tax Reporting System using COBOL and on a AIX UNIX Platform. All on an Oracle Database.
- Troubleshoot issues that came up. Fixed or did work arounds to take care of these issues.
Programmer
​Responsibilities:- Worked on the main Annuity System and was part of a team that created and managed a Tax Reporting System from scratch using COBOL and AIX UNIX plateform
- Did Maintenance for the On Lines and the Reporting piece of the main Annuity System.
Confidential
Programmer
​Responsibilities:- I was trained for first 3 months on COBOL, and how there Annuity System worked
- Did Maintenance for the On Lines and the Reporting piece of the main Annuity System.