Objective: Database administrator to utilize my research, communication, and documentation capabilities and to perform database design, integration, and optimization by applying my broad technical, financial, management, and training skills.
General: Application report writing, technical writing, requisition, purchasing, accounting, customer service, training, process analysis, inventory management, personnel management, preventive maintenance management, development, software lifecycle, quality assurance
Report Writing (Business Objects, Crystal Reports, Info Maker, SQL Reporting Services, company/application specific programs)
Operating Systems (NT, 98, 2000, XP, ME, NT server, Server 2000, Server 2003, UNIX [Apache and Solaris], Linux, OS2, VMS/VAX, DOS)
Database Platforms (SQL Server, Oracle, MySQL, Informix, Access, AS-400, Mainframe databases)
Database applications (SAP, SAP R/3, AutoCAD, KMS-DMS, RAPIID, Master Builder, Lotus, Thomson Elite Enterprise, Thomson Web View, Microsoft Great Plains)
Web FrontPage, Dream Weaver, Hot Metal Pro, Hummingbird
Other (IIS, SMS, Rational Robot, Remedy, Pivotal, VM Ware, Star Team)
Hardware: Midrange to mainframe servers, workstations, networks, data warehousing, other hardware
Intel Corporation - Divisional Recognition Award/Corporate
Recognition, Leadership and Peer Awards for team work, training, and technical knowledge
US Navy - Leadership Awards and Division recognition for team work, training and technical knowledge
Thomson Elite - Recognition for Team Work, Innovation and Initiative, and Technical and Professional Knowledge
Maggie Sottero Designs, LLC
Systems Administrator February 2011 – Present
Created new reporting set for all company reports. Upgraded Great Plains and customizations. Made final decisions for server hardware upgrade. Reprogramed show order system and removed initial design issues. Redesigned several application-based programs to function as web-based applications. Data analysis and design of reporting for customer service applications from raw CDR data. Lead CMS project team. Major contributor to WMS project team. Enhanced Great Plains stored procedures and customizations for better functionality.
Technical Consultant and Implementation Specialist January 2007-January 2011
Update and program applications for SQL and Oracle database applications. Design and implement reporting applications. Merge datamart /datawarehouse information with Ingenix insurance quoting application through backend SQL procedures and functions. Perform technical work, installations, and software upgrades to client systems / servers to include IIS, SQL 2005 Reporting Services, .NET programming, XML, SQL server management, and network issues. Train clients on technical upkeep and repair. Responsible for all application documentation, technical writing, and version control.
Contractor June 2006 – January 2007
Write test plans and automation scripts. Complete quality assurance documentation and small team management. Train personnel on application functionality. Conduct defect and quality assurance meetings as the subject matter expert. Troubleshoot bugs/issues and coordinate programming efforts and redesign documentation.
Test Engineer January 2004-June 2006
Write test plans, test cases, testing schedules, automated testing scripts, and defect reports. Conduct exploratory, regression, security, unit, application, web, and automated testing. Review functional and design specifications, ERDs, and data models for data warehousing and application design. Revise documentation and technical documents as needed. Train customers, management, development and other QA staff on application functionality and backend server maintenance. Work with management on CCB and CRB boards. Run defect management and analysis meetings.
Technical Specialist July 2001-Present
Evaluate and design networks and hardware for small businesses. Create estimates and proposals for bids. Create small to medium sized databases for financial, billing, and inventory management. Design, implement, and maintain websites. Provide bookkeeping, inventory, and office management on a temporary basis.
Systems Analyst/Web Administrator September 1997-July 2001
Develop applications following specified lifecycle process for division/department. Negotiate in management meetings for IT projects and funding. Write and review technical documents, operation manuals, training, and development documentation to fit changes in company policy or development needs. Lead SAP and web development projects in order to provide technical advice for phasing out older legacy systems with minimal operational impact. Train customers, development, contractors, and other shareholders on new and existing application functionality and impact. Perform functional analysis and impact analysis for new and existing projects.
Cryptologic Technician Maintenance February 1991-September1997
Build and maintain tracking database for classified material destruction. Manage inventory and supply for maintenance division with a budget of 20 million dollars. Develop new systems and perform research and development.
Cryptologic Maintenance Technician A and C Schools 1991-1992
Network and Fiber Optic Design 1995-1997
B.S. in I.T. - M.I.S.; National American University 2005