Melissa Piazza - Systems Analyst Resume Simple
SUMMARY
A seasoned professional with over 10 years of experience in IT industry. Expertise in data analysis, design, development, testing, implementation and maintenance of business applications using Oracle, SQL Server, DB2, Oracle, Sybase, Teradata, and UNIX.
SKILLS
  • test, project, architect, informatica, windows, validation, qa, solutions, databases, reporting, sql, unix, analysis, cases, uat, reports, test cases, plsql, etl, design, tivoli, sdlc, solution design, process flow, file, application design, pl sql, database
  • test, debug, engineering, oracle, informatica, server, computer, implementation, basic, test execution, test plans, evaluations, administration, databases, scripting, database management, fix, management, oracle sql, offshore, sql server, database systems, software, unix, life cycle, testing, visual
WORK EXPERIENCES
  • 2017-12-252017-12-25

    Systems Analyst

    Hiram High School

    • Design, development and implementation of ETL processes, test cases, and database validation of DataStage jobs. Created UNIX shell scripts to automate the process of loading data from the Oracle DB.
    • Worked with project managers, business analysts, and QA team to develop and implement Oracle reports for the PeopleSoft trading system.
    • Responsible for the implementation of the database and data migration from Sybase to Teradata using TOAD. The process was used to extract the data from the flat file.
    • Worked on Oracle database and Informatica data modeling, business objects, and functional requirements, involved in UAT, and technical support.
    • Performed data analysis and data migration from Sybase to Oracle database. Involved in designing and developing the PL/SQL packages to extract the data from the Oracle database.
    • As a lead Developer, involved in the development of the Oracle database and OLAP application for the client. IT is a self-service portal for the customer.
  • 2017-12-252017-12-25

    Senior Database Engineer

    John Mcdonogh Senior High School

    • Software development, testing, administration, maintenance, and support of DB2 database, Oracle PL/SQL, UNIX, IBM Tivoli, and z/OS computers.
    • Responsible for the production support of the Oracle service Bus (OSB), which includes: administration, maintenance, performance tuning, and development of the test case management system.
    • Responsible for the design, development, testing, maintenance, and administration of Oracle PL/SQL and DB2 stored procedures, and training to offshore team.
    • Perform DBA duties including: development, testing, support, and maintenance of Oracle PL/SQL, service oriented, and production databases.
    • Assist in the development, maintenance, and support of the Oracle database and application service, including scheduling of the jobs, and deployment of the code to the DBA team.
    • Assist in the development, maintenance and support of the Oracle service Bus (OSB), IBM DB2, CICS, and SQL Server environments.

 Cornell University School of Industrial and Labor Relations 

 U.S. Treasury Department Seized Property Auctions