Sr Database Developer & Analyst
Resume:
Terrence S. Miller
Oracle Developer
**** ********* **. ***********, ** 45458
****************@*****.***
********.*.******@********.***
PROFESSIONAL PROFILE
Mr. Miller has more than 12 years of expertise working in analysis, design, development, testing, and implementation of data marts and data warehouses, as well as experience in universe design, creation, testing and maintenance using Business Objects tools and applications. Extensive experience with Oracle RDBMS utilizing PL/SQL, and Teradata EDW, utilizing Teradata BTEQ, MultiLoad, FastLoad, and FastExport tools.
TECHNICAL SKILLS
Languages: PL/SQL, BTEQ, Unix shell script, XML, SAS, Action Script
Databases: Oracle 11g RDBMS, Teradata EDW v2r6.0
ETL Tools: Informatica PowerCenter
OLAP: Business Objects
Other Software: Toad, SQL Plus, Microsoft Office 2007/Vista/XP/2000, Windows NT
Operating Systems: Windows 2007/2000/98, HP-UX, VAX VMX
PROFESSIONAL EXPERIENCE
Teksystems contracted to JPMorgan Chase
Oracle Developer January 2011 – Present
Responsible for the design, development, coding, testing, debugging and documentation relating to the Integrated Pricing Administration (IPA tool) for Treasury Services Pricing Event Integration Team.
Interface Developer
Overview:
• Member of Treasury Services Pricing Event Integration Team tasked to design and develop stored procedures relating to the Integrated Pricing Administration (IPA) an internal tool that is used for price-modeling, cross-selling opportunities for Treasury sales Officers.
Responsibilities:
• Design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of multiple user areas.
• Worked closely with client management to identify and specify complex business requirements and processes and performed research to evaluate alternative solutions to complex multi-million dollar project that will be consolidating silohed tools and technologies (SAS, .NET, SQL) all to Java.
• Worked with Java Team to resolve design issues and increase application efficiency.
Environment:
• Oracle 11i, Toad, Windows 2007
Dynamics Research Corporation
Senior Systems Analyst November 2006 – December 2010
The Requirements Interface Process Improvement Team (RIPIT) fields Data Query Requests from client functional analysts leveraging data derived from DSD D200A Secondary Item Requirements System (SIRS), and develops SAS procedures utilizing SAS programming language, in order to output result data sets into report format and return back to the requesting functional analysts for use in projecting future aircraft maintenance spares requirements for the Air Force. Designs, develops and maintains interactive web based interfaces and reports utilizing Flash technology for use by client analysts in order to provide them ready access to recurring report information.
Interface Developer
Overview:
• Core member of team tasked to build online interfaces for USAF D043 Master Item Identification Control System (MIICS) for utilization by functional analysts.
Responsibilities:
• Build and test interface reports according to user specifications.
• Field Data Query Requests from client functional analysts leveraging data derived from USAF DSD D200A Secondary Item Requirements System (SIRS)
• Created XML documents for data retrieval across applications.
Environment:
• SAS 9.2, Macromedia Flash 8
Logtec Inc.
Senior Systems Analyst January 2005 – November 2006
At the Headquarters Air Force Materiel Command (HQ AFMC) Wright-Patterson AFB (WPAFB).
Working for Q303 Depot Maintenance Integrated DataMart EISS/EIIA, coordinated migration and integration of Q303 production Oracle database into AF GCSS-DS Teradata data warehouse.
Overview:
• Core member of the team responsible for migrating existing Oracle RDBMS to Teradata EDW environment.
Responsibilities
• Utilized PL/SQL, Teradata BTEQ, MultiLoad, FastLoad, FastExport and Informatica ETL software in migration implementation.
• Performed creation and implementation of Universes for integration effort utilizing BOBJ Business Objects.
• Managed the collaborative efforts of the prime contractor, subcontractors, and client to develop an integrated test and quality assurance plan.
• Created a Change Control process to manage ongoing system changes/ updates, and generated notifications to end users and other impacted internal departments.
Environment:
• Windows 2003, Business Objects 6.5.2, Oracle 9i RDBMS, Teradata EDW v2r6.0, UNIX HP-UX
Haverstick Government Solutions
Senior Systems Analyst June 2000 – January 2005
Overview:
• Provided support to the Q303 Depot Maintenance Integrated DataMart EISS/EIIA at the Headquarters Air Force Materiel Command (HQ AFMC) Wright-Patterson AFB (WPAFB).
Responsibilities:
• Developed and performed maintenance on back-end software written in PL/SQL to convert Government legacy system data into format suitable for Oracle data warehouse.
• Performed analysis, design, mapping and coding of processes relating to the conversion of legacy COBOL into ORACLE PL/SQL stored procedures.
• Created and maintained documentation for support of back-end systems and databases.
• Developed custom UNIX scripts to automate manual processes.
• Managed the completion of project milestones.
Environment:
• Windows 2000/2003, Oracle 9i RDBMS, UNIX HP-UX
Ciber Inc.
Database Programmer/Analyst February 1998 – May 2000
Overview:
• Assigned to NCR, Business Systems Division, handling daily, weekly and monthly batch processes.
Responsibilities:
• Provided modifications/testing to existing SQL code on a UNIX platform for daily, weekly and monthly common script report generation.
• Wrote UNIX shell scripts to expedite routine tasks such as report generation, error checking for SQL queries and application migration. Building and testing specific views that combine data from both the primary and weekly data marts.
• Assigned to Reynolds & Reynolds, provided modifications/testing to existing COBOL code on a VMS platform for the Year 2000 Project.
Environment:
• Windows 98/NT, Teradata, UNIX HP-UX
Key Corporation
Database Developer/Analyst February 1994 – May 2000
Overview:
• Core member of team building VoiceCall, a real-time automated ATM management/dispatch system which monitors status and progress of service calls, and health and status of Diebold and NCR manufactured ATM machines.
Responsibilities:
• Design, develop, test, implement, and maintain the VoiceCall database system.
• Analyzed nature of ATM faults, hardware or software, determined possible solutions, and notified or assisted branch personnel in remedying faults using GASPAR4 Real-time ATM monitoring system.
Environment:
• Windows 95/NT, Gaspar4
Project Engineering Inc.
Database Developer/Analyst April 1992 – June 1994
Overview:
• Assigned to design and develop a mainframe database to track software project development status for NASA Goddard Space Flight Center Software Engineering Research Facility.
Responsibilities:
• Design, develop, test, implement, and maintain the Software Project Data Repository (SPDR) database system.
• Developed suite of reports for dissemination to users performing statistical analysis.
• Applied Function Point Analysis methodology to complete a quantitative measure of the code size of NASA White Sands Ground Terminal (WSGT) 550,000 Source Lines of Code.
Environment:
• VAX VMS, Ingres RDBMS
Contact this candidate