Oracle Developer or Systems Analyst or DBA or Data Architect Resume

Title
Oracle Developer or Systems Analyst or DBA or Data Architect

Primary Skills
Seeking IT position developing, analyzing, documenting and supporting databas...

Location
US-IL-Streamwood

Posted
Oct-08-08

DATA ARCHITECT / DBA / SENIOR SYSTEMS ANALYST

* Secret Security Clearance (Current obtained in 2006)
* Oracle Performance Tuning and Application Tuning
* Oracle database administration, development, and deployment expert that effectively collaborates across all business levels to meet or exceed business needs
* Leads small to large size projects by combining IT and business expertise with excellent interpersonal skills to create a synergistic IT team which provides responsive support across all business levels
* Strategic thinking from micro to macro levels
* Keen ability to conceptualize complex concepts into simplified terms to effectively present technical information to clients, users, and non-technical staff to design efficient solutions
* Systemic approach to design and problem solving
* Lead the analysis, troubleshooting and research of business opportunities and develops solutions/recommendations
* Maintains and improves existing applications
* Provided consulting services/expertise on the use of applications and tools
* Perform thorough analysis, programming and testing to ensure defined requirements are met efficiently while ensuring high quality
* Six Sigma green belt with a proven track record of discovering and implementing cost saving initiatives



TECHNICAL SKILLS:

Completed Oracle 8i DBA Certification classes.
Attended Oracle 10G product launch and Microsoft 2003 product launch.

Applications:
Oracle Forms, Oracle DBA Studio and Enterprise Manager, Oracle Migration Assistant, TOAD, Jetforms, Word, PowerPoint, Visio (Reverse Engineered Databases), Expert with Excel and MS Exchange, Primavera: Team Play and Team Player, Remedy.

Operating Systems:
Unix, AIX, Windows NT, 2000, XP

Databases:
Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g

Languages:
SQL and PL/SQL, Unix/AIX Shell Script, C, C++, Java, HTML, TCL/TK


EXPERIENCE: USMEPCOM, NORTH CHICAGO, IL 2005-2008

Oracle Forms Developer

* Develop Oracle Forms to process people into the US Militaries.
o Instrumental with upgrading to Oracle Forms 10g from Oracle Forms 6i
o Application performance tuning
o Instrumental with implementing Biometrics
o Modified menus, created database roles and setup security access
o Created and debugged Oracle Database Views
* Provide daily IT support for the Military Entrance Processing Stations to resolve production issues
* Oracle Database Administration
o Instrumental in Database and Oracle Forms upgrades
o Create & Manage User Accounts
o Create & Debug Stored Procedures
o Database Performance Improvement
* Data Dictionary design and documentation
* Serving on PAT (Process Action Team) team to implement SEI/ Capability Maturity Model Integration (CMMI).
* Serving on Change Assessment Process team to review Problem Reports and System Change Proposals and provide and/or implement technical solutions.
* Convert business requirements into logical data models.
* Created and modified Jetforms, including SQL and AIX data population and merging scripts
* Debugged various issues with software, OS, Network, and hardware
* Worked with web master to develop a web based tool for people to enter their weekly significant activities, and roll them all up into one report for management.
* Developed ODS data models

Product Evaluations, LaGrange, IL 2004-2005

DBA for MS SQL Server

* Supported & Developed SQL Server database for core business functions.


MOTOROLA, INC., LIBERTYVILLE, IL 1988-2003

Database Architect for PCS Supply Chain 2001-2003

* Created Datamart
o Created database objects & administered users
o Automated data collection from 4 regional Oracle databases, & 1 SQL Server database.
o Imported 2 Access databases utilizing Oracles migration assistant
o Worked with web master to create web based reports & utilities
* Conducted business analysis and requirements gathering. Acted as liaison between business units and technology.
* Created Entity relationship Diagrams (ERD), Data Flow Diagrams (DFD), Process Diagrams, Flow Charts, Work Flow Diagrams, General Solution Diagrams, Overall Architecture diagrams. Architectural Diagrams (How databases, data warehouses and data marts are interconnected).
* Participated in all stages of development projects from architecture discussions, data modeling (physical and logical) using Visio, through code evaluation and tuning to production releases.
* Performed reverse-engineering using Visio and the development of administrative scripts and tools.
* Discovered data migration tool and created a process that resulted in 95% reduction in migration time which provided the product management department with competitive analysis 8 days ahead of schedule.
* Designed and implemented various ETL and data cleansing methods to ensure maximum data integrity throughout the company.
* Performed Application DBA tasks including the creation of user schemas and database objects, data export/import, SQL and PL/SQL tuning and inter-application connectivity issues.
* Troubleshooting and problem resolution of network performance, server and application issues, data integrity issues and database performance.
* Led a data integrity project providing analysis to identify and correct records with inaccurate codes.
* Oracle database and application performance tuning
* Created SQL data loading scripts to load data from Excel to Oracle.

Lead Software Engineer/Systems Analyst 1994-2001

* Optimized web based reports, tools & utilities by improving database response time
* Optimized SQL statements
o Rewrote SQL code to meet standards
o Analyzed SQL statements
o Used HINTS to enforce use of indexes
o Rewrote WHERE clauses to return only data needed
o Recompiled code using new libraries
* Optimized database
o Created database clean up scripts
o Analyzed database objects
o Coalesce Tablespaces
o Identified mutating tables, & corrected by reorganizing triggers
* Led a factory commonization project. Converted seven factories (each with their own database, reports, and software tools) to one database. Reduced 300 web-based reports down to 20. Commonized software tools. This also included commonizing the procedures and practices that affected the data input into the database. Project was completed three months ahead of schedule and resulted in significant savings, and reduced the need software technicians from 15 to 3 while providing the same level of support.
* Achieved SEI level 3 certification for CIM (Computer Information Management) group
* Troubleshooting and resolution of applications, connectivity issues, database issues, server and upgrade (Oracle databases and UNIX Servers) issues.
* Created project plans for upgrading UNIX Servers and Oracle databases.
* Created, tested and documented disaster recovery plans and procedures and defined data archiving plans.
* Documentation of systems and applications. Created Entity relationship Diagrams (ERD), Data Flow Diagrams (DFD), Process Diagrams, Flow Charts, Work Flow Diagrams, General Solution Diagrams, Overall Architecture diagrams, Context diagrams (showing the middleware interface), and Architectural Diagrams (How databases, data warehouses and data marts are interconnected).
* Responsible for monitoring and resolving network performance issues.
* Created and documented policies and procedures to ensure continuous improvement.
* Evaluated and selected new tools and software for the business units.
* Supported new and existing software development projects with logical data and process modeling activities.
* Interacted with business users and provided Solution Architect level support; analyzed data requirements and develop enterprise models in support of business applications, data warehouses and data marts.
* Developed and maintains documentation of data and information management process models.
* Collaborated at all levels of IT to provide 7X24 support of current systems and develop new systems including design, implement, test and deliver information architecture and technical solutions integrating information architecture requirements with other enterprise architecture requirements to produce a cohesive enterprise architecture design.


Technical Supervisor (Cellular) 1993-1994

* Trained electronic technicians how cellular phones work and make phone calls (AMPS, NAMPS, CDMA:1G; 2G; TDMA, GSM)
* Created Electronic technician accuracy reports by developing new SQL queries and modifying existing code (C, SQL, Unix).
* Created Process Diagrams, Flow Charts, Work Flow Diagrams, and General Solution Diagrams.
* Created and implemented the TEAM (Taking Effective Action for Motorola) program producing multi-million dollars of savings in the areas of safety, cost, and efficiency.


Held various manufacturing positions with Motorola 1988 -1993

MILITARY:

Electronic Counter Measures\Electronic Warfare Specialist (Secret Security Clearance) 1983-1987
Community College of Air Force (58 Credits) Major: Electronics

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Streamwood, IL | Resumes in Illinois

View other Oracle Developer or Systems Analyst or DBA or Data Architect resumes, Programmer / Developer resumes