Project Manager Sql Server

Senior Business Analyst with over ** years experience working with

requirements gathering, development/design documents, which are fully

documented, clear, concise, unambiguous, and are buildable. Have extensive

knowledge of the System Development Life Cycle (SDLC), including water fall

and RUP (Rational Unified Process) methodologies. Have extensive UML

(Unified Modeling Language) in creating use case models, including

activity, sequence, and communication diagrams. Have experience utilizing

tools such as XMLSpy, Erwin, and SQL queries (such as select, insert,

update, and delete statements) to view and verify data, and the database

table structures, for functionality of applications.

. Bachelor's Degree in Computer Information Systems, with more than 17

years IT experience (more than 10 years as a Business Analyst, providing

process, cost, as-is, and requirements analysis).

. More than 10 years of software development experience designing and

developing solutions for customers that allow the customer to be

successful.

. Expert level of knowledge, and experience using, Microsoft Office Tools,

such as Word, Excel (including complex formulas), Power Point, Visio,

Access. This includes Microsoft Office suite versions from Office 97

through Office 2007.

. Expert level knowledge and experience in use case modeling and

documentation. Also extensive experience in process analysis, modeling,

documentation, and design.

. Expert level experience in communicating to technical and business teams,

as well as leading presentations, pre-sales discussions, and training.

. Expert written and verbal communications skills at all levels of a

company (from the CEO to the front-line workers).

. Strong, detail oriented, analytical, written, and verbal communication

skills

. Have strong interpersonal skills, and work very well as a team member and

is self motivated to identify issues, find solutions, and work the

solution to a final resolution.

. Have more than 7 years experience in the healthcare industry (6.5 years

of which is in the Healthcare Insurance industry)

. Have more than 8 years experience in the consulting realm.

. Have more than 10 years experience in development of web-based,

client/server, and legacy applications. Have extensive SQL and database

experience in designing logical and physical data models.

. Have extensive experience managing and working in projects, managing

customer expectations during the requirements gathering process, applying

methodologies/ standards, developing Use Case models of business

requirements, provide in-depth analysis of client business processes from

differing departments for creation of functional requirements, guiding

and coordinating the planning, marketing, training and operating of

automated systems to customers (clients).

. Extensive experience and skills in identifying, documenting,

prioritizing, communicating, as needed, escalating issues to project

staff and management appropriately.

. Extensive experience and skills in evaluating true requirement needs and

determining how existing application products and technology may address

the needs of the customer (client) to fulfill the requirement needs and

develops recommendations, as needed.

. Extensive technical knowledge in web development including:

o Microsoft Visual Studio, ASP, VBScript, DHTML, CSS, JavaScript, ERWin

(data modeling tool), SQL Server, Oracle, Windows 2000 Server and

Advanced Server, IIS, Index Server, Adobe Photoshop, Adobe Illustrator,

Macromedia Dreamweaver, Microsoft Exchange, Microsoft Office (including

VBA), and Macromedia Homesite.

. Create business logos and custom graphics for clients.

. Create and implement web graphics utilizing Adobe GoLive, Macromedia

Dreamweaver, Adobe Photoshop, and Illustrator.

. Data Analysis of proposed systems, Data Modeling utilizing ERwin,

installation, and maintenance of databases (SQL Server, Oracle, and

Microsoft Access).

. Unit, system, and user acceptance testing of developed systems.

. Writing user and system maintenance manuals and providing training of

users and technical staff of new systems.

. Providing pre-sales support, technical and business analysis, functional

and non-functional requirements gathering, creating requirements and

technical specification documents, responding to RFI's and RFP's,

estimation of cost and resource needs, creating and providing

presentations as well as presenting to clients, assisting in closings,

providing recommendations of hardware and software, to creating data-flow

and system-flow diagrams.

. Provide analysis current and the creation of new processes.

. Extensive project management experience managing multiple projects of

various sizes and complexity utilizing Microsoft Project and has advanced

knowledge of Microsoft tools.

. Release management experience of multiple simultaneous projects of

varying sizes and complexity. Tracking and forecasting resource needs.

Tracking and forecasting revenue. Finding and addressing issues in

releases and making management aware at an early stage to mitigate these

issues to a successful completion.

EDUCATION

[pic]

. BS/CIS, Devry Institute of Technology, Irving Texas

(President. s List, Dean's List, Cum-Laude)

PERSONAL TRAINING

[pic]

. Certificate, Computer Information Systems, Texas Institute,

Dallas, Texas, 1988

. PowerBuilder Courses, Denver, Colorado, 1996

. MS SQL Server 7.0, Aurora, Colorado, 1999

. Member of IIBA (International Institute of Business Analyst)

2006 - Present

EXPERIENCE

[pic]

Streffco Consulting, Englewood, Colorado, (2/10 - Present)

Business Analyst - Contract

Assignment: Kaiser Permanente, Aurora, CO

. Provide as-is departmental process, reporting, and data analysis

of breakpoints that will occur in the current system, if left as is, at

the time of transition of EGSMC to eSummit.

. Create departmental as-is departmental process and breakpoints

documents to verify processes, reporting, views, and data needs.

. Create the Current State document that will encompass all

departments interviewed of their processes, as needed, reporting, data,

and, view needs. Obtain sign-off of this document from various members of

these specific areas.

. Provide Scoping Matrix documentation of departmental breakpoints

identified during interviewing with various SME's to assist management in

scoping the impact of EGSMC transitioning to eSummit.

. Will be providing requirements gathering, and documentation, of

data solutions for reporting, views, data needs, and process changes as

needed. This will allow Kaiser Permanente to have the least impact at

time of EGSMC's transitions to eSummit in 2011.

. Will be providing creating use cases diagrams and documentation,

of solutions for data needs, reporting, views, as well as process

diagramming of changes as needed.

Cricket Communications, Greenwood Village, Colorado (10/07 - 4/09)

IT Project Manager II

. Managed projects of varying sizes and complexities from simple

promotional projects, such as new rate plans and sales, to new product

offerings, such as Data Backup and Mobile Music, of which are considered

large projects.

. Managed launches of customer call centers in the US, Canada, and Central

America.

. Participated in monthly launches and assisted in the definition and

execution of user acceptance testing (UAT).

. Utilized such tools as Microsoft Project, Excel, Word, SharePoint,

Microsoft Office 2007, and Telelogic's Doors, Change, Synergy, and

Quality Center.

. Created project plans, budget plans, resource requirements, project risk

analysis, maintained issue logs, as well as providing weekly status

reports.

. Led kick off meetings, tracked all project activity to made sure work was

getting accomplished and on time and budget.

. Provided post mortem in determining what went right and what went wrong

and areas for improvement.

. Documented information and sent out to all groups in the attempt to

better processes.

. Assisted in the definition and training of BA's and FA's to assist in

strengthening their requirement documentation of all projects.

. Utilized - Use Cases, Use Case Models, Sequence Diagrams, Process

Diagrams, and Activity Diagrams. As well as the purpose of each document

type, what type of information goes into each.

Fiserv, Inc., Denver, Colorado, (2/06 - 10/07)

Release Manager, Sr. Business Analyst

. Reported directly to the Executive Vice President of Product Engineering,

. Provided release management for five different software products, each

with multiple projects for numerous clients, in different locations.

. Provided project management services to these products creating and

tracking project plans, release plans, working with Product Management in

determining scope of releases, capacity planning, resource usage and

forecasting, revenue forecasting, lead teams to successful completions of

their projects on a regular basis.

. Tracked down missing requirements to make sure development had everything

they would need to design and develop and QA had the information required

to test.

. Assisted in the design, analysis, and presented findings to upper

management, training, implementing, and tracking a new SDLC process

utilizing RUP methodology and UML.

. Release management, for tracking workflow of projects.

. Created training classes on how to write solid requirements and use case

creation.

. Worked closely with the VP of QA in creating and standardizing test cases

and testing processes.

. Worked closely with the VP of Development in implementing new processes

in the development of products.

. Work closely with the Executive Vice President of Product Engineering in

preparing financial reports, release status reports, and project status

slides sent to Professional Services individuals to present to their

clients.

. Estimated resource needs of projects and forecasted future resource

needs.

. Tracked billable and non-billable work cost to the company and forecasted

future cost of projects as they came up.

. Gathered requirements - interfaced with product managers, writing

requirements and use cases utilizing the UML use case modeling and the

RUP methodology.

. Researched internationalization of tax reporting requirements for a

client in Canada.

. Assisted in testing functionality of development against requirements

reporting defects as required.

. Verified defect I had submitted once development had addressed the issue

of the defect, assisting QA in their testing efforts.

ClientSolv Technologies, Denver, Colorado, (8/05 - 12/05)

Business Analyst / Report Analyst - Contract

Assignment: US Department, Denver, CO

. Provided requirements gathering of applications, utilities, and reports

from clients of various departments within the HAC (Healthcare

Administration Center).

. Wrote requirements documentation of various subsystems of the CPS re-

hosting system utilizing Use Cases (Visio) and Microsoft Office Suite

(Word, Visio, Excel, Microsoft Project, and Power Point) utilizing RUP

and UML methodologies.

. Provided reports development support utilizing Oracle Reports.

. Created design documents for applications, utilities, and reports.

. Utilized Use Cases (Visio), RUP, Microsoft Office Suite, Oracle Report

Designer 9i on an Oracle 9i database, Visio, and TOAD.

. The Rehost application was hosted on a Linux platform, utilizing J2EE,

JSP, and JDBC.

Express Personnel, Denver, Colorado, (1/04 - 8/05)

Business Analyst / Report Analyst - Contract

Assignment: US Department, Denver, CO

. Provided requirements gathering of applications, utilities, and reports

from clients of various departments within the HAC (Healthcare

Administration Center).

. Wrote requirements documentation of various subsystems of the CPS re-

hosting system utilizing Use Cases (Visio) and Microsoft Office Suite

(Word, Visio, Excel, Microsoft Project, and Power Point) utilizing RUP

and UML methodologies.

. Provided reports development support utilizing Oracle Reports.

. Created design documents for applications, utilities, and reports.

. Utilized Use Cases (Visio), RUP, Microsoft Office Suite, Oracle Report

Designer 9i on an Oracle 9i database, Visio, and TOAD.

. The Rehost application is hosted on a Linux platform, utilizing J2EE,

JSP, and JDBC.

Independent Contractor - 1099

Business Analyst / Consultant, Aurora, Colorado, (6/02 - 1/04)

Assignment: Bingham Services and Maintenance (Albuquerque, New Mexico)

- 6/03 - 12-31-03

. Designed and created a website to allow users to view services offered by

Bingham (www.BinghamServicesandMaintenance.com).

. Designed, built, and maintained the company's computers and network

systems. Utilized Adobe Illustrator 10, Adobe Photoshop 7.0, Macromedia

Dreamweaver, ASP, HTML.

Assignment: Heart & Sole (Albuquerque, New Mexico) 6/03 - 12-03

. Maintained the store's hardware and assisting in definition of plans of

expansion.

. Utilized Adobe Illustrator 10, Adobe Photoshop 7.0, Macromedia

Dreamweaver, ASP, HTML.

Assignment: Project C.U.R.E. - Volunteer (Englewood, Colorado) 6/02-

10/02

. Setup network

. Network Administration and Maintenance

. Set up and maintained Exchange Server, Outlook, SQL Server 2000, Access

2000, customized applications, and maintained the LAN.

Assignment: House of Prayer Church (Tampa Bay, Florida) - 6/02-9/02

. Created the church's logo, designed and built the church's website

(www.houseofprayerchurch.org), and provided maintenance of the website.

. Provided requirements gathering, holding discussions of approach and user

approval of pieces of the site as they were completed.

. Utilized ERWin (Data Modeling), Macromedia Dreamweaver, Adobe Illustrator

10, Adobe Photoshop 7.0, ASP, and HTML.

Qwest Communications (Qwest Global Services), Denver, Colorado, (2/00 -

6/02)

Senior Technical Strategist/Business Analyst/Project Manager/ Developer

. Gathered requirements from clients, wrote and maintained the Functional

and Technical Specification, Proposals, Statements of Work, and Project

Plan documents.

. Researched the best possible technology that best fits the requirements

of the client.

. Negotiated pricing with third party vendors on behalf of the client.

. Gathered business rules and run strategic requirements meetings.

. Spear headed the customer consultant relationships and assist in closing

the deal between the sales team and the customer.

. Defined standards of development, process of engagement, and approval of

documentation to the client.

. Assisted in the development of data models and the instantiation of the

data model to a database and tables utilizing ERWin to create databases

in Oracle 8i, SQL Server 2000 database engines, as well as Access

databases.

. Utilized SQL to verify data.

. Developed web-based applications utilizing Use Cases (using Visio), RUP,

XMLSpy (for data verification and making sure all tags existed and were

closed), ERWin (Data Modeling), ASP, SQL Server 2000, and Oracle 8i for

various clients from basic websites to large-scale ecommerce web systems.

. Populated tables for testing and involved in data migration from various

databases to specific databases.

. Provided project management for multiple projects utilizing Microsoft

Project 2000.

. Provided training of usage applications to clients at either their site

or our site.

. Provided training of usage and maintenance of databases to allow the

customers to maintain their databases.

. Gave sales and technical presentations of proposed systems utilizing

Microsoft PowerPoint 2000 and XP.

. Assisted in setting up and maintaining web servers, installing software

onto desktops, laptops, and servers as needed.

. Created proto-types for customer presentations utilizing Microsoft Access

2000 and 2003.

Blue Cross Blue Shield of Colorado, Denver, Colorado, (12/97 - 2/00)

Senior Client Server Architect/Project Manager/Developer

. Created standards of development, create and maintain web server

services, oversee and develop all web development authorized by the

business

. Taught HTML, ASP, CSS, NT Administration, and Web Administration.

. Created specs for NT Web Servers, and web development workstations.

. R&D all tools to be used for web development which included, Use Cases,

Class Diagrams, Sequence Diagrams (utilizing GD Pro), MS Visual Studio

6.0, Homesite 3.0-5.0, MS FrontPage 98 - 2000, MS FrontPage 98 - 2000,

IIS 4.0 - 5.0, NT 4.0 and Windows 2000, Slick Edit, Apache Web Server,

Netscape Web Server, Oracle Web Server, MS Certificate Server, MS Index

Server, MS Transaction Server, MS Source Safe, ASP Mail, MS Exchange, and

MS Outlook.

. Stayed abreast of new and upcoming technologies to help steer the

business into a direction that would allow the ability of new

technologies to be utilized when needed

. Ordered, installed, and maintained all web servers and network

components.

. Provided training on the usage of various applications built by the

development team.

. Designed, implemented, and maintained all databases created by our team.

. Assist the helpdesk in troubleshooting, and the installation and

maintenance of software.

. Created various Access database systems for various departments.

o Access databases allowed individuals the ability to create form letters,

mailing labels, tracking legal contracts, generate legal contracts, and

various other tasks as needed.

o Maintain Access and SQL Server databases for the users as required.

o Analyze data elements in the creation of both logical and physical data

models.

o Evaluated normalization of data within the data model tables, make model

adjustments, and instantiate the model into a physical database.

o Utilized SQL in investigating data within the database and maintained the

database.

. Worked closely with customers

. Conducted JAD sessions with SME's to gather requirements to gather

requirements for various web applications.

. Wrote requirements and design documentation of these systems, developed,

implemented, and maintained these various web applications, systems, and

databases.

. Developed a web application and database to allow the Human Resource

Department the ability to input, open, close, cancel, and reopen jobs

that were available for hire.

. Web applications utilized MS IIS 4.0, MS NT 4.0, Oracle 7.3.4, ERWin 3.5,

Visual Interdev 1.0/6.0, and MS IE 4.0.

. Developed web application databases that displayed from a database, a

list of providers for a given health plan, name, city, hospital, PCP,

specialty, male or female, and handicap accessible.

o Utilized MS IIS 4.0, MS NT 4.0, Visual Studio 6.0 (utilizing Visual

Interdev 6.0), MS SQL Server 7.0, and ERWin 3.5

Denver Technical College, Denver, Colorado (4/97 - 12/98)

Instructor CIS

. Instructed an NT Administration, Web Development, and Introduction to

Programming courses.

Perot Systems (3/92 - 12/97)

Team Lead/Project Manager/Business Analyst/Software Engineer

. Consultant provided various roles to the client from leading development

teams in the development of solutions

. Provided project management to assure that the team meets their goals in

a timely basis at or under budget

. Provided business analysis through gathering requirements, making

recommendations of process modifications and technologies, to software

engineering writing and developing the solutions.

. Provided data analysis and data modeling service to customers in the

creation of databases for various projects

o Utilized ERWin on Oracle, SQL Server, and Access databases.

o Verified data on a regular basis utilizing SQL.

Contact this candidate