Sr. Database Developer Sample Resume Format in Word Free Download -->

Sr. Database Developer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download



 


Paige Mattens
E-Mail: paige@msn.com     ●    Cell: 540-974-9876
 



Summary

 

Hands-on experience in all phases of development life-cycle, from requirements gathering through production deployment. Experience in analyzing requirements and creating detailed specifications and reliable, accurate code. Equally comfortable in a team or independent task environment. Excellent communication skills (verbal and written). Proven technical lead developer experience.

Professional Experience





Sr. Database Developer
January 2010-Present


Blackstone Technology Group


·        Served as lead developer on FEMA NFIRS Data Warehouse Initiative and kept the project on schedule through User Acceptance Testing.
·        Created the Project Plan (MS Project) for the NFIRS Data Warehouse Initiative and worked with project manager to finalize the schedule.
·        Created a logical and physical star schema design for NFIRS Data Warehouse Initiative, including the Oracle database table structure and Business Objects Universes.The design incorporated some of FEMA existing conformed dimensions.
·        Created an attribute transformation rule document for ETL from NFIRS source system to the Data Warehouse Star Schema.
·        Executed the technical development of the FEMA NFIRS Data Warehouse, including the Oracle tables, views, packages, jobs, mviews, sequences and the Business Objects Universes and table driven row level security. All database development was conducted using a text editor and Oracle PL/SQL. All universe design work was executed through BO Universe Designer
·        Pioneered partitioned tables in FEMA Data Warehouse: NFIRS Data Warehouse initiative involves approximately 800 GB of data and growing.
·        Pioneered incremental data loads for FEMA Data Warehouse using Oracles Change Data Capture and nightly refresh jobs using Oracles job scheduling.
·        Created multiple star schemas and universes for other FEMA Data Marts.
·        Maintained legacy star schemas and universes for other FEMA Data Marts.
·        Adhered to strict CMMI level 3 development practices in all phases of the SDLC.

Tools:Oracle PL/SQL, Business Object XI (WebI, Designer), Rational Toolset (ReqPro, ClearCase, ClearQuest, RQM), SQL*Plus, SQL Developer, MS Project, MS Office 2003 and 2007



Reports Team Lead
September 2008-January 2010


K12, Inc


·        Managed daily reports team activities and projects.
·        Implemented Oracle Business Intelligence Enterprise Edition, OBIEE.
·        Manage multiple data interfaces with external customers including: Scantron, Naviance, Presidium, and School Messenger.
·        Created night batch processing jobs for OLTP systems using Unix Cron, Oracle Scheduler, and PL/SQL.
·        Created and updated triggers, procedures, packages, Materialized Views, Unix Shell Scripts.
·        Created ETL procedures for multiple Dimensions and Fact Classes for Star Schemas.
·        Provided production support via SQL script creation for bugs/shortcomings in legacy systems.
·        Administered Development database: implemented periodic data refreshes using Oracle Data Pump, created/maintained tablespaces, schemas, users, permissions.

Tools:Oracle PL/SQL, OBIEE, Jira, Confluence, SQL*Plus, PL/SQL Developer, Unix, Bash Shell Script, Oracle Data Pump.



Data Warehouse Architect/Developer
October 2008-September 2010

Applied Computing Technologies, Inc.

·        Design, Develop, and maintain Star Schema to support the Federal Emergency Management Agency (FEMA) under the Department of Homeland Security (DHS).
·        Identify transactional source data for staging purposes, design Star Schema (Dimension/Fact Tables), and create the ETL (Extraction, Transform, and Load) code.
·        Optimized existing implementations by refactoring the ETL code. This resulted in a 75% performance increase.
·        Created ODS (Operational Data Store) solutions for GIS (Geographic Information System) customer reporting capabilities.
·        Developed a generic logging API for all ETL code. Used for auditing nightly warehouse refresh routines.
·        Developed/maintained Business Objects XI (BO) reporting universes using BO Designer tool.
·        Created program specific Business Objects training documentation for end-users.
·        Created/maintain Business Objects Corporate Reports used by various FEMA customers/entities.
·        Maintain the FEMA Enterprise Data Warehouse Website.
·        Followed all Configuration Management policies and guidelines to ensure version control.
·        Created OLTP system package used to interface FEMA’s requisition system with the DHS contracting solution (completed while on 3 week detail).
Tools/Languages: Oracle PL/SQL, Toad, AquaData Studio, SQL*Plus, EditPlus, Notepad, Textpad, Microsoft Office Suite (VBA), Visio, PVCS Tracker, PVCS Version Manager, Internet Explorer, Business Objects Enterprise suite.

Systems Analyst/Test Engineer
January 2005 - October 2006
Applied Computing Technologies, Inc.
·        Primary responsibilities include testing/debugging front-end applications and server side database code for multiple NEMIS Platform projects.
·        Served as Technical Lead for web-based reengineering project for the Community Information System (CIS).
·        Optimized multiple CIS reports to utilize views versus stored procedures cutting response time by 50 percent.
·        Created table structure and implemented database package for new CIS module utilizing Oracle PL/SQL.
·        Served as requirements specialist for multiple projects including: Credit Card Transaction Management System (CCTMS), NEMIS AR Interface upgrade, Web-based Emergency Support Module.
·        Maintained existing packages, triggers, and views as business requirements were added or changed.
·        Served as CCTMS Point of Contact for user issues including: data corrections, ad-hoc reports, and data analysis.
·        Utilized MS Office suite to create multiple types of documents including: SOPs, Test plans, Requirements, and Statements of Work
·        Served as lead Tester FEMA Web-Based Disaster Declaration application.
·        Created multiple modularized WinRunner scripts utilizing the Transaction Scripting Language (TSL) to help streamline regression and functional testing.
·        Provided training and oversight for new employees brought into the testing team.
Tools/Languages: Oracle PL/SQL, Mercury Test Suite, TSL (Transaction Scripting Language), XML, SQL*Plus, Toad for Oracle, Microsoft Office Suite. Visio.

Information Technology Specialist
July 2003-January 2005
Federal Emergency Management Agency
·        Managed implementation of IFMIS (Integrated Financial Management Information System) Smartlink enhancement: Gathered requirements, designed and executed test plans, provided production support upon implementation.
·        Conducted NEMIS ES testing in support of multiple releases.
·        Created multiple reports for CCTMS analysis using Clear Access reporting tool.
·        Utilized SQL to analyze table data when conducting application tests.
·        Accumulated hands-on knowledge of FEMA IT policies and procedures.
·        Created Unix shell scripts that produced files used to test various IFMIS functionality.

SUPERVISOR RECOGNITION


Present Supervisor:
Received ACT All Star Performer Award in December 2005 in recognition of outstanding contribution to the team and customer support.  Peter worked with FEMA for a number of years on some of the same applications in which he now supports - this enabled him to hit the ground running and immediately become a productive part of the team. He has a tremendous aptitude in learning new tools such as Test Director, WinRunner, Quick Test and a new software tool purchased by ACT - WebCEO.

General Dynamics Contractor Team Lead:
“His technical and analytical skills are highly regarded by both Anteon [GD] and the FEMA client.  He has proven himself through periods of intense disaster support operations, routine grind and repeated “fire drills” to be reliable, thorough and completely professional.  His personal contributions and his commitment to teamwork are noted and appreciated daily”.

Education



Virginia Polytechnic Institute and State University

1990-1994
Blacksburg, VA
·     Completed three years of education with a concentration in Mathematics
Lord Fairfax Community College
2001-2003
Middletown, VA
·        Completed multiple programming course including C/C++ and database design






Download Resume Format 

0 comments:

Post a Comment

Resumes By Categories

1-5 Years Experienced CV 10-15 Years Experienced CV 10th Standard 12th Standard CV 15-20 Years Experienced CV 20-25 Years Experienced CV 30+ Years Experienced CV 5-10 Years Experienced CV Accounts CV Aeronautical CV Automobile Engineer B Com CV B Pharma CV B.Tech CV BA CV BA Philosophy CV Banking CV BBA CV BBM CV BCA CV BDS CV Beautiful CV Bio Technology CV BMS CV BPO Call Center CV BSC CV BSC IT CV Business Analyst CV CA CV Cashier CV CEO CV CFA CV Chemical CV Civil Engineering CV CMA CV Commercial CV Cook CV Cover Letter for Resume CS CV D Pharma CV Diploma CV Doctor CV draff Economist CV Electrical CV Electronics CV Engineer CV Fashion Designer CV Films CV Finance CV Foreign Resume Format Fresher CV GM CV Hotel Management Housekeeping CV HR CV ICWAI CV Import Export CV Industrial Engineering CV Instrumentation CV Insurance CV IT CV ITI CV journalist CV LLB CV M Com CV M Pharma CV M Phil CV M Sc Computer Science CV M Tech CV M.Tech MA CV Manager CV Marketing CV Mass Communication CV MBA CV MBA Event Management MBA Finance MBA Hospitality CV MBA HR CV MBA IB cv MBA Marketing MBA Production MBA Quality MBA SCM CV MBA System MCA CV Mechanical CV Medical Representative CV Mining CV MMS CV MS CV MSC CV Over 25 Years Experienced CV Paint Technology CV Pharmacy CV Phd CV Philosophy CV Project Manager CV Psychology CV Purchase CV Quality Engineer Real Estate CV SAP ABAP CV SAP Basis SAP BI CV SAP BO CV SAP CRM CV SAP CV SAP FICO CV SAP HR CV SAP MM CV SAP PP CV SAP SD CV SAP Security Six Sigma CV Special Resume System Administrator CV Teacher CV Textile CV Treasury CV USA Resume Web Designer CV