PL/SQL Developer/Data Analyst Resume Plano, TX - Hire IT People

COMPUTER SKILLS:

Analytical Tools: Oracle SQL PLUS, Microsoft Excel spreadsheet, Excel Visual Basic, Word, PowerPoint, Visio. TSO, TMON for DB2, TMON for CICS, IBM MVS Utilities(IEBGENER, IEFBR14, etc.), MVS PKZIP, ZOS DB2 High Performance Unload/Upload, Teradata BTEQ, Archmain, Fast Unload and MLOAD, MS SQL Enterprise Manager, Teradata SQL Assistant and TOAD for Oracle, PL/SQL Developer, Rapid SQL, SQL PLUS.

Computer Languages: PL/SQL, SQL Loader scripts, Enterprise COBOL, COBOL II, CICS Command Level, Visual Basic, Excel VBA, HTML, XML, Informatica ETL (Extract Transform and Load), Oracle database store procedures, UNIX scripts and SQLs. SAS on MVS. IBM Messaging Queue.

Computer Platforms: ZOS MVS, TSO, Sun UNIX, IBM UNIX - AIX, NT Servers, XP Window and Window 7.

Relational Database Management Systems: Oracle, IBM ZOS DB2, IBM AIX Universal Database, Teradata, Microsoft Access 2007, MS SQL server.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

PL/SQL Developer/Data Analyst

Responsibilities:

Extract historical currency conversion rates from reliable web sources, upload the historical rate to an Oracle table then modified existing store procedures and views to refer the currency conversion rate table.
Defined sources, created tables, developed the process, tested the process, installed the process to the production and documented the process.

Technical Platforms: Oracle 11g PL/SQL, SQL Developer, Rapid SQL, SQL PLUS, SQL Loader.

PL/SQL Developer/Data Analyst

Confidential

Responsibilities:

Converted manual Oracle queries to PL/SQL stored procedures and reduced the SQL execution time from 8 hours to 2 hours; automated PL/SQL procedures and logged execution results in an audit table.
Created PL/SQL dynamic queries using reference cursor, collections, user defined functions and bulk inserts to extract hundreds of millions rows.
Gathered the requirements from business analyst, defined the processes, created database tables, developed the processes, tested the processes, installed the processes to the production and documented the processes.

Technical Platforms: Oracle 11g PL/SQL, SQL Developer, SQL PLUS, SQL Loader.

Confidential, Lewisville, TX

Data Analyst

Responsibilities:

Consolidated IT software asset transitions status into Access database; wrote SQLs to extract transition data into Excel spreadsheet; wrote excel formulas to summarize transition data to support upper managers’ decision making.
Analyzed data and generated ad hoc reports.

Analytical Tools: MS Access 2007/2010, MS Excel 2007/2010, VBA.

Confidential, Richardson TX

Program Analyst

Responsibilities:

Created LMS XML files and reformatted PeopleSoft XML feeds to upload users, academic courses, and student enrollments to Blackboard System.
Wrote PL/SQL block routines to consolidate ORACLE data for ad hoc report requests.
Installed and tested 3rd party teaching packages to Blackboard systems.
Trouble shooting eLearning Life Cycle production issues and applied solutions.

Technical Platform: HTML, JAVA, XML, PL/SQL Oracle 11g, SQL Developer, SUN UNIX Scripts, SUBVERSION.

Confidential, Richardson TX

Data Analyst

Responsibilities:

Analyzed production data, applied database solutions and resolved production.
Developed Oracle11g PL/SQL packages/procedures/functions to automate users’ reports as daily, weekly, monthly, quarterly and annual DBMS jobs
Quickly learned how to use Toad Report Manager to convert spread sheet reports to PDF formatted reports.
Quickly learned how to read the codes generated by PL SQL Query Reporter to solve production issues.

Technical Platform: PL/SQL, Oracle 11g, PL SQL Developer, TOAD Report Manager, DBMS JOBS, CVS.

Confidential, Plano, TX

Software Engineer

Responsibilities:

Tailored off - the-shelf business applications into IT production environments.
Wrote Functional Specification and Technical Specification
Defined, designed, developed and implemented ETL modules to pull datamart data from various sources(Teradata, UDB, DB2, XML, etc) and to consolidate the data then apply incremental changes to ORACLE tables.
Worked closely with business analysts to provide project estimates; wrote dynamic SQLs to define data flows for new business requirements. Researched interface data to provide volume estimates.
Worked closely with database administrators to review logical data model and then to implement the physical data model.
Conducted business data analysis using database utility tools, Excel spreadsheets and VBA. Extracted and tested production data in an environment that other testing teams would use.
To support System and UAT testing, wrote BTEQ, Export, FastLoad, MLoad utility modules to extract then to upload Teradata data from production to test environments.

Technical Platform: XML, PL/SQL Oracle 11g, SQL PLUS, SQL LOADER scripts, ZOS DB2, AIX UDB, Teradata, MS SQL Server, SQL Assistance, TOAD, Informatica PowerCenter, AIX Unix Scripts, Java, JEE, Spring, COBOL, i2/JDA Retail Suite, ESP, REMEDY, CHAGNE MANAGEENT, SUBVERSION ENDAVOR, JCL, TSO.

We provide IT Staff Augmentation Services!

Pl/sql Developer/data Analyst Resume

Plano, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship