Customer Sql
Resume:
Aida Hailu **** Opal Street
Broomfield, CO *****
*****************@*****.***
To obtain a software developer position that allows me to learn new technologies while utilizing my experience programming skills in applications Pro*C, SQL, PL/SQL, SQR, UNIX and Shell Scripting
WORK EXPERIENCE:
EXPERIENCE
July 2008 to July 2012
Staples Inc.
Senior Systems Analyst Broomfield, CO
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables
• Participated in Agile project management methodology
• Involved in tuning SQL queries to the database to get them perform better by using EXPLAIN PLAN
• Involved in developing UNIX shell scripts for Loading Database Tables
• Created data patches using PL/SQL and Store Procedure for Insight Delivery Method Tool (in-house developed customer reporting tool)
• Utilized C application and PL/SQL (Pro*C) tools on the Oracle database to create custom media bill invoices
• Managed the personal tuxedo development board on Linux platform; created processes and services to code and complete unit testing and devised accurate technological solutions through the application of the full Agile development life cycle process
• Supported existing customer reporting inventory sourcing from Reporting Database and the Data Warehouse to fix issues and add enhancements and help develop new customer reports, as needed
• Prepared and checked in custom media bill code for deployment to production systems
Consulted tier II support to resolve customers custom invoice issues as escalation processes warranted and meeting the SLA
• Communicated, and reprocessed failed custom invoices with Finance billing analysts to repost customer invoices
March 2001 to July 2008
Corporate Express
Developer/System Analyst Broomfield, CO
Responsible for:
• Experienced over Six years of exclusive experience working with SQL, PL/SQL, PRO*C
• Supported Insight (in-house developed customer reporting tool) to help set up appropriate environments (development, test, production), enhance end user functionality, resolve environment-related errors, and research reporting execution errors.
• Worked media billing and customer reporting related Remedy service desk tickets on a solo basis or as support Working with Business Analysts to define requirements
• Attended projects design and review meetings
• Analyzed and debugged jobs and procedures
• Supported existing customer reporting inventory sourcing from Reporting Database and the Data Warehouse to fix issues and add enhancements and help develop new customer reports, as needed
• Worked closely with Customer Reporting to do code reviews, sequel reviews, troubleshoot issues, and collaborate on design
• Created data patches using PL/SQL and Store Procedure for Insight Delivery Method Tool
• Performed SQL Tuning on several SQR Reports
• Participated in unit and/or system testing of customer reports
October 1998 to January 2001
BT Office Products
Programmer/Analyst Arlington, TX
• Developed and tested code using QUIZ and QTP for the client and/or server components of BT Office client server distribution software
• Assisted with Y2K complaints
• Supported testing and application support as needed
SKILLS:
• Languages: Oracle SQL, Oracle PL/SQL, DB2, UNIX Shell Scripting, RPGIV
• Operating System: UNIX AIX, Windows XP/2000/NT/95/98 , AS/400
• Databases: Oracle 8i/9i/10g
• CM: Start team, TOAD, SQL*Plus
• Other Tools : Rational Rose, TOAD, Putty, Telnet
EDUCATION, CREDENTIALS
Bachelor of Science, Information System
University of Texas at Arlington, Arlington, TX
Master of Science, Database Technologies
Regis University, Denver, Colorado
REFERENCES
Available upon request
Contact this candidate