Project Manager Sql Server

Hands-on techno-functional, results-oriented business analyst/project

manager with 13+ years of IT experience in program management, project

management, client relationship management, IT management (all aspects),

custom software development, database administration/programming, Crystal

Reports, SSRS and COTS implementations. Well-seasoned with experience

directing multiple projects utilizing Agile, Scrum, Iterative, MSF and

Waterfall software development/project management methodologies.

Knowledgeable in all phases of SDLC performing business process analysis to

achieve significant productivity gain and quality improvements on all

projects. Experience with multiple ERP, CRM, WMS and web technology

project implementations as well as hands-on experience programming, network

administration/design, Windows/Unix server build and administration and

database administration/programming.

Work Experience:

Spectrum Services 2/09 - Present

Consultant

. McKesson Paragon Database Administration including Paragon Upgrade,

Data Extracts for California State and Federal Reporting, data

extracts for outside vendors to conduct quality of service/customer

satisfaction surveys, Reporting using SSRS and Crystal for Infection

Control, Nursing, Discharge Planning, Case Management, Utilization

Review, pharmacy, etc. Create automated ETL functionality for state

and federal reporting as well as outside vendors to create mass

mailings out of utilizing SSIS. Financial Reporting out of Paragon

for Patient Financial Services, Reports for Payroll out of Kronos and

Abra, Pathways reports for Financial Services/Accounting and Materials

Management.

. Epic ADT/Prelude Implementation - Lead AC position. Requirements

gathering, system build, etc. Identity including MPI duplicate

cleanup process prior to MPI import into Epic.

. Report programming from Crystal Reports/Business Objects and SSRS out

of various database systems.

. Technologies used in this position - SQL server, Cisco, Windows, IIS,

Visual Studio .NET, MS Office including Excel and Access, Kronos,

Abra, Crystal Reports, T-SQL, Visio, Project, Exchange, Active

Directory, Epic ADT/Prelude (certified through Summer 2009 version)

and some Cadence (not certified in Cadence).

Rady Children's Hospital 2/08 - 2/09

Sr. Business Systems Analyst

Brought on as a Senior Analyst to work on various database projects, was

moved to Epic project after person in that position left the organization.

. Responsible for McKesson Centramax for Telephone Triage.

. Project managed and implemented High Risk Infant Clinic EMR.

. Project managed and implemented Cochlear implant systems.

. Project managed and implemented Sage FAS.

. Project managed and implemented Sage CIP.

. Performed Business process analysis and Visio diagrams/documentation

of all registration areas, UR/UM and billing/collection departments.

. SQL server DBA duties for projects (table creation, user creation,

database creation, view creation, etc.)

. Moved to Epic project when Epic Application Analyst left Rady's. Was

responsible for project management and Epic Lead AC duties including,

creating and updating WBS/project plans in MS Project,

scheduling/leading meetings, programming workflows and masterfiles,

defining requirements, etc.

Jarden Corporation

Senior Programmer/Analyst Contract to Hire Position 11/05 -

3/08

Brought in to Lead the implementation of an Oracle-based warehouse

management/ERP/Manufacturing and Supply chain systems including EDI

functionality, WMS functionality, Shipping and Receiving functionality,

Inventory Control functionality, RFID functionality, Business Objects

Enterprise reporting and carton labeling systems and programming. Lead the

implementation of SQL server-based parcel shipping system (ConnectShip) in

their Fontana, California, Neosho, MO and Milford, CT distribution centers

to interface with SAP, Oracle and AS400 (JD Edwards).

. Gather end user requirements, conduct JAD sessions with SMEs, key

stakeholders, end users and project champion, document this

information for submission to vendors for bidding process and use

during the course of the project.

. Gather hardware and software requirements from software vendors.

. Gather pricing information from software vendor.

. Initiate RFP process, obtain bids from vendors for selection process

and lead selection process.

. Monitor and manage payments to vendors.

. Conduct User Acceptance Testing.

. Specify interface requirements and build between JDE, SAP and Oracle.

. Specify and program printing and reporting requirements out of systems

via SSRS and Crystal Reports Enterprise.

. Create training materials and perform training sessions of end users.

. Specify, design and install and configure web server for distribution

of Oracle printing and reports and SQL server reports to all users in

the organization which require report functions without need for

Client software.

. Interface with outside vendors during the course of the implementation

through go-live for issue identification/resolution as well as

managing budget and vendor payment at milestones.

. Specify and develop/oversee modifications to both Oracle and

Connectship applications, databases and interfaces, test and obtain

approval from department managers.

. Managed development team, specification phase, testing, hardware,

software, infrastructure, training, end-user/management signoff and

post go-live support.

. Implemented web interface for customers to enter orders into the

system, other than via EDI to enhance customer ordering experience and

enable smaller non EDI customers to enter their own orders without

calling customer service thereby reducing operating expenses.

. Design EDI carrier specific RFID/non-RFID labels using Loftware

labeling system.

. Perform data analysis to identify root cause for issues and make

appropriate adjustments/recommendations as required.

. Server Build and Administration (Unix/Windows).

. Database Administration in Oracle and SQL server.

. Report Programming in Crystal Enterprise.

. Design, set-up and maintainance of all Unix and Windows based servers,

wireless access points (802.11g) as well as print servers and printers

for reporting and RFID and non-RFID label as well as report generation

in distribution center.

. Post go-live program owner of Connectship (SQL server) performing DBA

duties, reporting, end user support and VB.NET, PL/SQL and T/SQL

programming .

. Monitoring EDI transaction logs and maintain compliance with vendors

for Fontana location, review of vendor guides to maintain compliance

with trading partners, reporting, data analysis and identification of

root cause and performing corrective measures when vendor requirements

changed or issues identified for all departments.

. Agile/Scrum methodologies used on these projects.

. Technologies used in this position: Oracle 9i, SQL server 2000/2005,

SSIS, SSRS, SSAS, VB Scripting, VB.NET, Windows 2000/2003, Unix,

Crystal Reports/Business Objects 8-11 (350+ reports programmed and

implemented web intelligence/Enterprise), PL/SQL, T-SQL, Loftware,

Oracle 11 ASCP WMS, Catalyst, Sato, Printronix, Oracle Forms, Oracle

Reports, JD Edwards (AS400), EDI, ERP, ASCP, SOX, GMP. Build and

maintain all servers and perform maintenance as needed using W2K,

W2003 and HP-UX. ITIL, RCA, Business Intelligence, Data Analysis,

Cisco networking equipment.

The Minka Group

Project Manager Contract Position 2/05 - 11/05

Brought in to complete conversion of corporate data processing system

(parent and five subsidiary companies including Minka Lavery, Minka

Aire, Metropolitan Lighting, George Kovacs and Ambiance Lighting) from

Cobol to Oracle 9i and 10g databases running on Sun Solaris 9. Prior to

bringing me on as the project manager, the project had been in progress

for 5 years and was only approximately 20 percent complete. Completed

project within 9 months with successful conversion to Oracle and Logistic

Labeling System (web labeling).

. Selection via RFP and management of 3 outside service providers (C3,

AOC USA and Allen Group).

. Managed 7 internal programmers.

. Gathered end-user requirements via one-on-one meetings with SMEs and

JAD sessions.

. Manage all project meetings.

. Specification/design, hardware and software requirements.

. Manage User Acceptance Testing process.

. Manage change management process.

. Served as lead programmer role delegating work to programmers and

overseeing programming and testing.

. Managed implementation and go-live of custom programmed e-commerce,

EDI transaction processing, CRM, ERP, WMS, manufacturing, accounts

payable, accounts receivable, general ledger, purchasing department,

logistic warehouse inventory control system, customer service system,

sales department functionality including commission system, sales

analysis reports and order processing system. Managed keeping the

project on time and on budget.

. Managed Project for Web interface carton labeling system for

suppliers/vendors in China (Logistic Labeling System) thus saving the

corporation several hundred thousands of dollars per year in labeling

costs.

. Managed web ordering system programming.

. Managed requirements gathering and programming Business Intelligence

reporting systems for Sales, Purchasing, Finance, Senior Management,

Accounting, Manufacturing, Quality Control, Sales and Warehousing.

. Responsible for maintaining communication between team managers, end-

users, programmers and outside service providers.

. Programmed using PL/SQL, TCL, Oracle Forms and Reports.

. Responsible for testing programs with end-users/department managers,

performing data analysis to identify root cause, identifying necessary

modifications/bug fixes and assigning duties to programmers,

interacting with outside service providers and specifying interface

requirements and testing for proper functionality, keeping project

moving, on-time and on budget.

. Converted projects from Waterfall to Agile methodology.

. Technologies used in this position: Java, SQL, PL/SQL, Oracle 9i,

Oracle WMS, Oracle Forms and Reports, Crystal Reports, TCL, RMAN, OEM,

Business Analysis, Visio, Project Management, Process Improvement,

EDI, SOX, GMP, Business Intelligence, Data Analysis, Agile

methodology.

Access Data Solutions

Lead Systems Analyst/Project Manager 2/03 - 2/05

Managed large and small corporate IT redesign projects for a consulting

company.

. Design, install, document and maintain Windows, Novell and Linux

networks, Exchange systems, web presence, SQL server and Oracle server

database systems.

. Gather end-user requirements via one-on-one interviews with SMEs, key

stakeholders and project champions.

. Specify, design, program, test and implement custom database

applications including, CRM, ERP and web applications for clients.

. Iterative/Waterfall PM methodologies used in this position.

. Respond to RFPs from potential customers, prepare bids and go over

requirements with customers.

. Duties included specification of hardware, software, network

infrastructure, bid preparation, keeping projects on time and on

budget, interfacing with clients, obtaining payments when milestones

are met.

. Data analysis/creation of statistical reports to make recommendations

for customer's sales, accounting, finance, purchasing and management

roles.

. Provide end-user training and support for clients.

. Notable Projects included : CheckMaster Agency - Corporate

Information System redesign JazzTrax - Web playlist implementation,

corporate IT management contracted, Stein-Whittington - Development

and implementation of Block Trade program with Charles Schwab, Desert

Veterinary Specialists - Implementation of new EMR, IT infractucture

and Radiology systems, Valley Health Systems - Epic ADT

implementation.

. Programming languages used in this position: Java, HTML, Flash,

Dreamweaver, Oracle Forms and Reports, Oracle 9i, SQL server 2000-

2005, SSIS, SSAS, SSRS, SOX, Business Intelligence, Data Analysis,

PL/SQL, T-SQL, Crystal Reports/Business Objects 8-10 implementation

including web intelligence/desktop intelligence, RMAN, OEM, Visio,

Epic ADT/Prelude master file, category list, workflow and report

build.

Sorrento Telecom, Inc.

Manager of Information Systems 5/97 - 02/03

Originally hired as intern, was promoted to Manager after completion of 6

month internship position.

. Training and management of seven employees including annual

performance reviews. Responsible for the hiring, training and

continuing education, professional growth and performance

evaluation/review of employees in the IS Department.

. Responsible for overseeing direction of IT department including

research on latest technologies then recommendation to Senior

Management for approval.

. Project management for all corporate IT projects including budget,

scope, requirements gathering, specifications, testing, training and

maintenance and payments to vendors.

. Responsible for contract definition/negotiations/payments with all

vendors.

. Responsible for approval and purchase of new hardware, software and IT

equipment, telecom equipment and office equipment.

. Prepared all departmental reports and budget.

. Interacted between the controller and the Vice President of STI on

manners concerning the IS Department.

. Responsible for installation, maintenance and programming of all

corporate intranet and extranet, databases, network infrastructure,

helpdesk, corporate time-keeping system, telecom, office equipment and

software.

. Agile/Scrum methodologies used in this position.

. Technologies used in this position: Visual Basic, Oracle 9i, RMAN,

OEM, SQL server 2000, Oracle Forms and Reports, SQL, PL/SQL, HTML,

Javascript, VBscript, Visio, Project, Kronos, Cisco.

Education:

Coleman University, La Mesa, CA

Bachelor's Degree in Computer Science, GPA of 3.9

California College of Health Sciences

Associate's Degree in Respiratory Therapy.

Technical Knowledge:

Network Administration:

Novell Netware 4.x-6.0, Win 95, 98, XP, NT, 2000, 2003 Active Directory,

DNS, DHCP, VPN, Samba, Exchange 5.5 & 2000, Veritas Backup Enterprise,

Linux, UNIX system administration, Apache, IIS, Cisco Routers, Cisco

Catalyst Switch, Cisco IOS - VLSM, IGRP, EIGRP, RIP, OSPF, BGP, access

lists, frame relay, ISDN, ATM, PPP, VLAN (VTP), trunking, etc; SNMP - HP

OpenView, LAN Auditor; Sniffer, What'sUp Gold, PC Anywhere, ZENworks, VNC,

Dameware, Remote Desktop, Mac OS9-OSX, PC configuration/repair.

Application Software:

MS Office Suite 97/2000/2003 (Access, Word, PowerPoint, Outlook Express,

Excel, Publisher, FrontPage, Visio, Project), MS Sharepoint, Quick Books,

Norton Antivirus Corporate, McAfee, TrendMicro, WordPerfect 5.1-9.0,

Photoshop, Flash, Dreamweaver, Sage Asset Management, Oracle ASCP,

McKesson, Kronos, Epic ADT/Prelude and Identity Certified through summer

2009 version, Mckesson CentraMax, Paragon reporting, Pathways Materials and

Financials reporting, Business Objects/Crystal Reports Enterprise 8-XI.

Programming Skills:

Java, JavaScript, PERL, HTML, Visual Basic. NET, VB Script, VBA, C/C++,

PL/SQL, SQL Plus, Oracle Developer, Oracle Forms and Oracle Reports, TCL,

JDeveloper, Oracle Discoverer, Crystal Reports 8-XI, Business Objects, SAS,

statistical reporting, CRM, ERP, EDI, SDLC, UNIX Shell Programming

(bash/ksh, Cshell).

Database Skills:

Oracle 9i-10g database administration, Data Analysis, Oracle Enterprise

Manager (OEM), Oracle Security, RMAN, Oracle 11 ASCP, Microsoft Access

2000-2003, SQL server 2000-2005 database administration all aspects

including SSIS, SSAS, SSRS, T-SQL.

Contact this candidate