Objective

Project Manager leading Web Solutions Development/Data Warehouse project s .

Summary of Qualifications

• Experienced manager and developer specializing in Visual Basic .NET, Visual Source Safe, C , Delphi, Cold Fusion, SQL Server 2000, Cognos series 7, Hyperion Brio, Erwin, Visio, MS Access, SDLC life cycle to include requirements gathering, data modeling, change management, and software architecture / design.
• Seasoned IT Professional with experience in planning, designing, developing, testing, and deploying web-based, data warehouse, and software development projects.
• Accomplished dynamic web page developer using HTML, DHTML, Cold Fusion, VB Script, Java Script, and ActiveX.
• Specialize in data modeling using Erwin and/or Visio, implementing, and administering relational database management systems using Microsoft SQL Server 7.0, 2000, and Transact-SQL.

Professional Experience

Confidential

Data Warehouse/OLAP

• Design and code Stored Procedures, DTS packages, triggers, and Views using T-SQL for maximum data optimization to include table design, view design, etc for ETL into Data warehouse / marts.
• Performance tune scripts/stored procedures using SQL Query Analyzer.
• Analyze data variances over time to identify trends/anomalies in data.
• Analyze OLTP systems in order to data model star schemas facts and dimensions using Visio to ETL into Data Warehouse
• Monitor change management using a COTS configuration management tool that facilitates SDLC lifecycle.
• Work with other PMs to allocate resources on various data warehouse projects.
• Coordinate pushes to stage and production with DBAs and Developers to comply with Sarbanes Oxley protocols.
• Utilize BI tools to build cubes in order to analyze data at the summary and detailed levels.

Confidential

OLAP/Cognos Admin

• Contracted to provide reporting capabilities from DB2 data warehouse to DFAS employees.
• Contracted to train users to use Report Net for their data reporting requirements.
• Contracted to analyze interfacing strategies between People Soft, Web Methods, Informatica, and Report Net to more efficiently pull data.
• Contracted to provide Report Net support to users experiencing login problems, connectivity issues, etc.

Confidential

Project Manager Web Solutions

• Provided customer support in all aspects of the web/software development lifecycle to the customer.
• Created BI Business Intelligence reports through Hyperion BRIO pulling data from the LMS's Sql Server data warehouse.
• Held numerous meetings with customers to analyze mission needs for the purpose of determining feasible requirements to ensure mission needs were being accounted for transformed business requirements to a formal requirements.
• Submitted/reviewed enhancement requests submitted to a formal board, which I sat, for review to ensure requests were properly prioritized based on available resources e.g. budget, human resources, and criticality and to facilitate change management.
• Analyzed legacy systems in order to re-development utilizing current technologies e.g. Visual Studio .Net, XML, Cold Fusion, Sql Server, etc .
• Spearheaded database design by data-modeling OLTP characteristics in new systems prior to implementation to ensure data normalization and efficiency.
• Convened meetings with customers recurrently to ensure their websites/web applications met mission needs and to gauge enhancements for future releases.
• Conducted weekly status meetings with developers to address questions/concerns on projects and heard feedback to more efficiently streamline our iDLC internet development life cycle approach.
• Met with upper management and fellow PMs recurrently to report status updates on project progress, estimated time of delivery relative to the documented project plans, and any issues relayed that could adversely affected project vigor.

Confidential

Sr. Database Specialist

• Gather requirements, designed, implemented, and deployed National Geospatial-Intelligence Agency's Program Development financial management database application.
• Supervised, reviewed, and mentored personnel on a multitude of contracts as Team Lead Manager.
• Served as liaison between Perot Systems and government leads in contracts negotiations/procurements.
• Performed in all aspects of software development life cycle from data modeling of the back end in SQL Server 2000 to implementation coding of the front end to data warehousing OLAP .
• Established and maintained a Windows 2000 server on behalf of the agency that was configured to serve hundreds in such capacities as file repository server, SQL Server, and Cognos Web Server.
• Integrated Cognos with my custom financial management application that automated the POM process by tying in MDC multi-dimensional cubes with data from the system's SQL Server 2000 data warehouse.

Confidential

Software Systems Programmer

• Enhanced and maintained software applications and web-based solutions directly supporting 350,000 Air Force personnel utilizing technologies such as Cold Fusion.
• Automated a manual process that enabled assignment officers to notify 33,000 officers world-wide of possible assignments on a quarterly basis that reduced notification time from 7 days to 1 day.
• Built an Assignment Selection Criteria Wizard that allowed assignment officers to search for officers who volunteered for jobs based on a wide variety of criteria such as location, job title, advanced academic degrees, and foreign language proficiency. This tool reduced search time by 75 and increased assignment matches by 30 .
• Wrote stored procedures in SQL Server 7.0 database replacing hard-coded queries thereby, optimizing and reducing system overhead by more than 40 .
• Composed and modified several reports with Active Reports to enhance and replace existing reports that were outdated and consumed valuable system resources this increased data retrieval times by 50 and improved overall system response time by 30 .
• Designed, documented, coded, tested, and maintained web/windows applications, and operating system enhancements in support of installation intelligence training systems.
• Provided software assistance to various base organizations supporting over 5,000 personnel.
• Coordinated software-engineering activities with element chief, customers, programming supervisors, software testers, quality assurance evaluators, and software project managers.
• Designed and implemented training application in C to assist newcomers in heading up skill-level training this effective tool overall procured its users 90 success rate.
• Analyzed existing programs for year 2000 compliance and ensured Department of Defense directed security features were functioning properly which confirmed all system roll-overs to 2000 transitioned smoothly without error.