Database Developer/dba Resume
Montgomery, AL
PROFESSIONAL SUMMARY:
- Web, desktop, SSIS application developer with 20+ years’ experience in creating and maintaining systems across civilian, federal, and military industries.
- Active Secret Clearance.
- Expertise in providing guidance and support to developers and end - users, and facilitating software development lifecycle (SDLC) to meet project requirements.
- Demonstrated leadership skills that enable teams to achieve project goals, develop innovative systems, and sustain organizational standards and objectives.
AREAS OF EXPERTISE:
- Application Development
- Data Migration & Consolidation
- Project Management
- Software Development Lifecycle
- Staff Development
- Website Management
TECHNICAL SKILLS:
Languages: C# .Net, Visual Basic .Net, ASP .Net, Visual Basic, ASP, JSP, SQL, PL/SQL, HTML, CSS, and JavaScript
Applications: Microsoft Visual Studio, SQL Server Integration Services (SSIS), ETL, DTS, and Crystal Reports
Application Servers: Microsoft IIS, SQL Server (up to 2012)
Operating Systems: Windows Server 2000/2003/2008/2012
PROFESSIONAL EXPERIENCE:
Confidential, Montgomery, AL
Database Developer/DBA
Responsibilities:
- Provide MS Access and MS SQL Server programming support for upgrade of Confidential MSAT application.
- Collaborate with Business Analyst and Subject Matter Experts to interpret MS Access reports, queries, and tables in order to build similar experience in MS SQL Server/web.
- Create SSIS packages to import fixed length flat files from mainframe computer.
Confidential, Montgomery, Al
Senior Programmer | Task Lead
Responsibilities:
- Provide programming support for upgrade of Confidential application; designed application in C#.Net with SQL Server database backend.
- Collaborated with external groups to develop solution to migrate data to Confidential application from existing COTS application (Hyland Confidential ) to new COTS application (Hewlett Packard Records Manager).
- Backup and restore of SQL Server databases for ongoing software/systems development.
Confidential, Montgomery, Al
Senior Programmer
Responsibilities:
- Oversaw upgrade of Confidential Enhanced Maintenance Operations Center application; designed application in C#.Net with Oracle database backend.
- Collaborated with external groups to develop solution to import data to Confidential application to enable Confidential field users to view aircraft from multiple Confidential units.
- Authored documentation to support ongoing software/systems development.
Confidential, Montgomery, Al
Client Service Provider
Responsibilities:
- Created, verified, and uploaded XML and Comma-Separated Values ( Confidential ) files utilizing MS SQL Server 2012 (SQL Server Management Studio) and SQL Server Integration Services (SSIS) packages (ETL) to support US Government’s Education Data Exchange Network (EDEN).
- Built complex SQL queries using SQL Server Management Studio and SSIS to create XML files; designed C#.Net website to support EDEN development and devised XSLT templates to instruct in-house users on data upload and verification.
- Prepared documentation to explain user review, approval, and disapproval processes for data upload, notification tools, comparative data analysis reports, and site administration.
- Uploaded verified education files to website on-time for first time in system history; investigated and resolved technical issues related to data uploads.
Confidential, Montgomery, Al
Systems Analyst
Responsibilities:
- Upgraded Confidential Facility Circuit Information Tracking ( Confidential program managing facilities and circuits for long haul communications contract.
- Migrated three versions of Sybase to MS SQL Server 2012 utilizing SQL Server Management Studio/ SSIS/ETL tools and technology.
- Created C#.Net desktop frontend with MS SQL Server backend to enable users to manipulate data, and migrate or export select data to comma-delimited text files to facilitate data loads to secure servers; developed SQL server jobs to backup version control software (Team Foundation Server) databases.
Confidential, Montgomery, Al
Chief of Software Development
Responsibilities:
- Provided supervision, oversight, direction, and project management to a team of 5 developers supporting and creating innovative software solutions integrating ASP.Net, Visual Basic.Net (windows forms and web), HTML, CSS, JavaScript, Microsoft Access and Microsoft Excel (including VBA for formulas and functions for reporting purposes).
- Administered web applications through Microsoft IIS.
- Educated developers on Confidential development standards and business rules.
- Directed project development lifecycle, including meeting with functional area, requirements gathering, database design, frontend prototyping, coding, application release to user, and application maintenance.
- Maintained large legacy application built in Visual Basic 6 during upgrade to ASP.Net webpages; managed web, desktop, and database applications, including data transformation services (DTS) built to export data to comma-delimited text files, facilitate file compression, and support FTP for cross-country access.
- Used SQL Server Management Studio/SSIS to transfer data from Membership tables on Production to Development database.
- Conceptualized process to replicate Confidential membership data to backup site.
Confidential, Montgomery, Al
Developer | Analyst
Responsibilities:
- Maintained and oversaw new development of eight Confidential websites using Java Server Pages; executed queries and stored procedures using PL/SQL.
Confidential, Montgomery, Al
Web Manager
Responsibilities:
- Established and actualized strategic long-term goals, policies, and procedures for online content development and management.
- Planned new corporate website project and managed development from concept to delivery; coordinated with design professionals on page and template creation.
- Led initiation of development and web standards, and provided guidance on web and desktop applications created by in-house web programmers using Visual Basic.Net and ASP.Net.
- Liaised between in-house users and vendors to resolve issues with new website, and provided comprehensive training to in-house users on content management system.
- Investigated, resolved, and safeguarded against security issues; provided insight on security issues, equipment needs, and software requirements to enhance end user experience and data security.
- Interpreted customer feedback to ensure best web experience for end user.
- Created SSIS packages to move data between large database systems.
- Administered web applications through Microsoft IIS.
Internet Applications Manager
Confidential
Responsibilities:
- Administered internet applications posted to Confidential website through Microsoft IIS; ensured applications functioned properly, monitored and analyzed user experience through user groups and help desk application.
- Directed application development lifecycles for web and desktop applications, and provided user support and training for in-house developed applications.
- Implemented in-house developed Help Desk software to control and document software changes.
Computer Programmer
Confidential
Responsibilities:
- Designed software solutions for Confidential utilizing HTML, Cold Fusion, MS Visual Basic and MS Office Suite. Created macros, functions, and formulas in Microsoft Access and Excel for Confidential internal users.
- Maintained, enhanced, and upgraded in-house developed membership system.
- Leveraged MS Access and Crystal Reports to generate and deliver reports for individual departments and applications.