Database Manager Resume Examples in Word Format 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

Residence: 309 Lamp Post Lane • Camp Hill, PA 17001

Phone: 717-412-9876  Email: paige@gmail.com

Paige Miller

OBJECTIVE
	A rewarding position that challenges the limits of my skills and knowledge to design, create, and/or enhance software and reporting systems.

EDUCATION
	BS Mathematics, January 1996 Penn State University, State College, PA

TOOLS
	VB6, VB.Net, PERL, SQL, DMSII, URSA, Python, COBOL (Unisys and Net Express), Crystal Reports, SQL Query tools (e.g. Enterprise Manager, MS Query, Toad), Excel, Word, & Access, Visual C++, Java (Integrator), Java Script, PHP,  L.

ADDITIONAL SKILLS AND INTERESTS
	Problem solving, Web design, system analysis and optimization, debugging and improving software efficiency, writing/editing/communication, new technologies and innovative research.

CHRONOLOGICAL PROFESSIONAL EXPERIENCE
	Database Manager, February, 2011 – Present Basic Overnight Quarters, Camp Hill, PA System Administration Maintain 3rd-party RDPWin hotelier application, trouble-shoot user PC issues, maintain telephone extensions and Microsoft Exchange accounts.  Manage external IT vendors and infrastructure projects. Performed upgrades for hotelier platform, investigated system faults and desired enhancements, and configured system for on-going business needs. Upgraded/maintained Pervasive database and administrated user licenses. Provided IT support for Corporate and Operations offices. Provided user administration and system maintenance of the RDPWin application, including system upgrades, configuration, and issue resolution. Database Reporting and Enhancements Requirements gathering, design, development, and testing of reporting and system enhancement needs supporting the Accounting and Operations departments.  Reports created using Crystal Reports and Perl.  Created a GUI to facilitate apartment costing calculations and maintain existing long-term contract details.  Allowed for Excel export of multiple Costing estimates for side-by-side comparison and statistics. Enhanced, maintained, and developed over 500 new and existing Crystal Reports used for insight into the RDPWin reservation system, and for daily operations. Internet Presence Management Maintaine corporate web site via the CMS, including press releases, setting up new property listings, and performing updates to other content. Worked with Innlink to offer properties on the GDS and major merchant travel sites.  Populated the property database and configured the interface to the reservation system for up-to-date availability and rates information.
	Data Analyst, April, 2008 – January, 2011 Rowman & Littlefield Publishing Group, Blue Ridge Summit, PA System Reporting and Enhancements Requirements gathering, design, development, and testing of reporting and system enhancement needs supporting the sales, accounting, publishing, and distribution facets of the business.  Reports created using Crystal Reports, Perl, and a Java-based IDE.  Examples: Created a GUI to produce custom reports and perform db maintenance from input spreadsheets.  Key items were read from the spreadsheets and used to provide additional information about items, orders, or prices.  Database maintenance could be performed based on the input spreadsheet and parameters provided. Inherited, enhanced, and maintained 30-40 Crystal Reports and the accompanying SQL Server 2005 database.  The reports were based on stored procedures and views for book orders, account summaries, invoices, and inventory summaries. Using Perl, created accounting reports for each customer in pdf format and automatically emailed based on account data in an Access database. Created a plethora of automated java reports for obtaining summary and detailed views of inventory, orders, and accounting data encompassing millions of records. System Migration Developed Perl programs to migrate customers, orders, accounts receivable, and inventory data from Oracle SQL tables and dBase to AS/400 libraries (Bookmaster platform).  Created scripts to summarize the converted data and balanced the results to the new system.  Developed reporting applications and AS/400 queries for ongoing data analysis. System Maintenance Performed maintenance on the data based on departments’ needs.  Fixing issues with 3rd party system design faults, user errors, and migration problems.
	Business Analyst, September, 2007 – March, 2008 Intec Telecom Systems, Melbourne, Australia Telstra transformation project Gathered requirements for the mediation of telephone network usage and product event records for delivery to downstream billing and reconciliation platforms.  Authored requirements specification documents, reviewed system test plans, and assisted with implementation.  Conducted sessions with subject matter experts within Telstra, EDS, IBM, Accenture, and Alcatel to agree on standard data formats and validations. Systems Analyst, September 2006 – September 2007 Intec Telecom Systems, Mechanicsburg, PA Designed, developed, installed, and maintained VB.Net and VB6 front-end GUIs for the Customer Service department, including the creation of 20-30 Crystal Reports called by entering parameters on the client side.  The reports accessed a Sybase SQL database, and included sub reports, formulas, and conditional grouping & formatting.  Parameters were selected by the Call Service Representatives via VB controls – for example, date controls, multi-select list boxes, and drop-down combo boxes which drew their data from several tables in the relational Symposium database.  Gridlines were used extensively to allow for easy export to Excel.  The majority of the reports were used to obtain metrics for inbound service calls, involving hundreds of thousands of calls. Maintained Advantacs CABS mediation platform for multiple clients.  Performed upgrades, trouble-shooting, usage investigations, and enhancements.  The platform combined the use of Net Express COBOL for the business logic, Microsoft SQL Server 2000 for data storage, VB.Net for the front-end parameter maintenance, and PERL scripts to manage the system flow.  Responsible for creating, maintaining and enhancing the Crystal Reports, SQL tables, views, and stored procedures, in addition to the Cobol and .Net programs. Led conversion of legacy systems to the Intec core mediation product.  Migrated manually initiated file transfers from Visual C++, PERL, and Windows Batch to the Inter-mediatE platform for automated processing.  Wrote requirements, detailed design, and test plans.
	Systems Analyst, June 1998 – September 2006 EUR Systems, Mechanicsburg, PA Design, development and testing in the telephony industry – LEC and CABS billings, inter-company settlements, wholesale billing, and system conversions from Unisys A-Series to Windows platforms.  Experience with creating/maintaining batch, online (GUI and mainframe), and reporting systems for a varied customer base. Enhanced and maintained a wholesale billing platform for AT&T.  Upgraded the existing system to improve efficiency and offer additional functionality.  Designed and implemented a Visual Basic front-end for easy updating of mediation and billing parameters, dialing plans, and rate plans. Designed and implemented a wholesale billing platform for Global One, based in the UK and France.  Worked with the client to determine the business requirements, designed the billing solution, managed EUR’s relationship with the vendor in creating the GUI front-end, and worked with the mediation team to integrate smoothly with the billing engine. Programmer, March 1997 – June 1998 EUR Systems, Mechanicsburg, PA Converted legacy telephony billing systems from Honeywell mainframes (Easy Coder machine language) to Unisys A-series mainframes (DMS COBOL).  Re-wrote ITAC settlements system and LEC billing systems.

DEVELOPMENT LIFE-CYCLE EXPERIENCE

Extensive experience with all aspects of the SDLC process, from requirements gathering, design, development, testing, and implementation.  Worked with a SAS70 certified process, including extensive documentation throughout the project life-cycle. In initial phases, met with internal departments to work out their requirements into an effective system design.  Also worked closely with external customers to refine a general RFP into clear business requirements. Development experience includes working independently, as part of a team, and as a team leader in several operating systems, using a variety of programming languages, IDEs, and source code control packages. Extensive testing experience with performing unit and system testing on multiple staging environments, as well as assisting end-users with user acceptance testing. Unit testing of a new (or modification to an existing) report or program typically involved generating test data, using customer-provided samples, or a production extract into a testing environment.  Verification of unit test results included visual confirmation, separate SQL (or DMSII) queries, and file-comparison software. System testing (used as a catch-all term for all testing occurring after the initial unit testing proved that the software was working as the developer intended) varied according to the project.  For new reports, programs, or GUIs, the system tests usually involved discussing the results of the unit tests with the project originator to ensure that the results were as expected.  Modifications to existing software and system migrations typically included parallel and regression testing.  Pilot testing occurred in some instances for GUI and reporting software. Implementation experience included promoting software to several production environments.  For example: Creation of Install Shield or Inno Setup programs for GUI rollouts, creating install documentation, and assisting the system administrators with the installation process. Promoting code through source code control software in Unisys mainframe environment Copying executable files to windows servers, and htm/js/asp files to IIS web servers Conducted post-mortem meetings with internal/external clients to ensure that the deliverables were met, and that the software functioned as desired.

MISCELLANY
	US Citizen

Download Resume Format