Sql Server Project Manager

RICHARD BRYANT

**** ******** **** • Elk Grove, CA 95624 • ******************@*****.*** • 916-***-****

Highly Motivated Business Process Analyst / Senior Systems Analyst / Senior Software Developer with Extensive Record of Achievement in Leading Analysis, Design, and Improvement of Systems

SUMMARY OF QUALIFICATIONS

• Business Process and Systems Analyst with expertise in structured and object-oriented analysis and design using latest UML methodology; analytical problem solver able to gather requirements and lead teams to strong results. Experienced in managing and developing Oracle, Microsoft .Net Client-Server and Web Applications.

• Over 20 years experience in Software Development Life Cycle (SDLC) support that includes Project Management, Project Planning, Business Analysis, System/Software Analysis, System/Software Design, Software Coding, Testing, Integration and Maintenance.

• Outstanding communicator with exceptional skills in presentation and written documentation; consultative professional able to collaborate with internal and external stakeholders to achieve required outcomes.

• Team player with strong work ethic who puts in all necessary time and effort to ensure success.

• Secret Security Clearance (last held 1997).

TECHNICAL SKILLS

CERTIFICATIONS

• Sun Certified Java Programmer, 2006

• Microsoft Certified Internet Application Developer, 2003

• Oracle Certified Internet Application Developer, 2001

PLATFORMS AND TOOLS

• SOFTWARE: MICROSOFT OFFICE SUITE, MS VISIO, MS PROJECT, CRYSTAL REPORTS

• LANGUAGES: C#, C, C++, BASIC, PASCAL, ADA, COBOL, JAVA, JAVASCRIPT, VISUAL BASIC, VB.NET, C#.NET, ADO.NET, APS.NET,ASP, SILVERLIGHT, PL/SQL, TRANSACT-SQL, HTML, XML, XSLT

• DEVELOPMENT TECHNOLOGIES: VISUAL STUDIO .NET, ORACLE FUSION MIDDLEWARE (ORACLE FORMS, ORACLE REPORTS, ORACLE DISCOVERER, ORACLE JDEVELOPER), ORACLE DESIGNER, IDEF0, IDEF1X

• DATABASE AND BUSINESS INTELLIGENCE (BI): ORACLE, SYBASE, MS SQL SERVER,SQL SERVER 2005, SQL SERVER 2008, MS ACCESS, MS IIS SERVER

• OPERATING SYSTEMS: MS WINDOWS, SUNOS/SOLARIS, IRIX, HP-UX, APPLE MACINTOSH, VAX/VMS

CORE COMPETENCIES

• Business Process Analysis, Process Improvement, Systems Analysis, Structured and Object-Oriented Analysis and Design, Object-Oriented Analysis Using Latest UML Methodology, Project Management, Teamwork, Mentoring

• EDUCATION AND TRAINING

• MASTER OF SCIENCE, SOFTWARE ENGINEERING

• GPA: 4.0 ● Summa Cum Laude

• BACHELOR OF SCIENCE, COMPUTER SCIENCE

• GPA: 3.5 ● Magna Cum Laude

• NATIONAL UNIVERSITY Sacramento, CA

PROFESSIONAL EXPERIENCE

INDEPENDENT CONSULTANT 11/2010-PRESENT

Elk Grove, CA

• Web Development, Western Festival Non-Profit Organization, 11/2010-Present

o Design, Develop and implement new website for the Elk Grove Western Festival.

o Responsible for upgrade and continual maintenance for website.

o Utilize ASP.NET and Silverlight.

o Created windows email web service for sending web site generated emails.

• Parade Director, Western Festival Non-Profit Organization, 03/2009-06/2009

o Organized the 2010 Elk Grove Western Festival Parade. Duties include:

Communicated with parade applicants and participants.

Processed more than 110 parade applications.

Led team of volunteers to check in and line up parade participants.

Instructed several volunteer parade judges how to use and fill out judging forms.

GENSA CORPORATION 11/1997-06/2010

North Highlands, CA

Responsible for working on a variety of software projects for many California state agencies and for private sector companies. Most of these projects require expertise in the entire software lifecycle development process from analyzing and documenting business processes through the implementation of new software systems.

• Senior Systems Analyst, Department of Health and Human Services (DHHS), 05/2010-08/2010

o Built message mapping between Health Level 7 (HL7) VXU message format and California Immunization Registry (CAIR) system, including patient records, immunization history, patient address, and medical providers.

o Created procedures stored in Microsoft SQL Server to exchange VXU, QBP, and RSP data between BizTalk and the CAIR Registry SQL Server database.

• Business Process Analyst, Caltrans, 08/2006-08/2008

o Analyzed current business processes for Extra Work Bill (EWB) & Pavement Asphalt Concrete Reporting System (PACRS) projects against system and worked with internal teams to fix issues and recommend enhancements.

o Resolved all issues to meet original system requirements; ensured timely completion of schedules.

o Secured development and implementation of new feature by collaborating with EWB and PACRS users through all enhancement phases.

o Conduct project planning and scheduling on EWB and PACRS modifications.

o Conduct JAD session meetings with project staff for development and modifications for EWB.

o Proactively prevented issues by identifying risk areas with changes to EWB, PACRS, and document plans.

o Performed Oracle Discoverer training and consultation to EWB staff.

o Performed knowledge transfer of EWB and PACRS system to new maintenance project staff.

o Provide Oracle expertise, for Oracle 10g forms and reports development and Oracle 10g DBA support to Caltrans personnel.

o Enabled improved data transfer between CAS and EWB by maintaining and developing enhancements.

• Business Process Analyst, Department of Industrial Relations (DIR), 08/2006-12/2007

o Collaborated directly with DIR Budget Office to adopt BIS / BMS system developed and used by Department of Fish and Game and Department of Insurance; modified BMS components to meet fiscal reporting needs.

o Facilitated loading legacy data into application by modifying and documenting data import process.

o Extended web-based ad-hoc reporting tool Oracle Discoverer, used to allow DIR business analyst the ability to query budget and accounting information from the BITS system and generate required fiscal reports.

• Senior Systems Analyst, RobbJack, 04/2006-08/2006

o Successfully implemented X-Series solid carbide end mills for the RobbJack Speed and Feed web application

o Utilized VB.NET, ADO.NET and T-SQL to implement new features.

• Senior Systems Analyst, Caltrans, 09/2004-07/2006

o Provide on-site, day-to-day Oracle expertise, for Oracle 10g forms and reports development and Oracle 10g DBA support to Caltrans personnel for the Extra Work Bill (EWB) web application.

o Enhanced interfaces with the legacy COBOL mainframe CAS system and EWB.

o Analyzed enhancements and new feature development adhered to Caltrans Software Development Life Cycle and Support standards.

o Re-engineered MS Access equipment rental rate (EWRR) program used to determine equipment rental rates on Caltrans construction projects; designed, developed, and installed new equipment rental rate (EQRR) program.

o Conduct Joint Application Development (JAD) sessions with project staff and domain knowledge experts to define business and software requirements.

• Senior Systems Analyst, Maximus Inc., 06/2004-09/2004

o Created financial reports / statistical reports with Oracle Reports, contributed to Oracle Forms open enrollment application and form letters, and developed routines to convert / load data from VSAM files into Oracle database.

• Senior Systems Analyst, Office of Statewide Health Planning and Development (OSHPD), 04/2004-06/2004

o Installed / performed integration testing / support for OSHPD’s Web-based intranet security awareness training system developed with Microsoft VB.NET and Microsoft SQL Server database.

• Engineering Process Manager, Internal Project, 10/2003-04/2004

o Developed Gensa’s software process improvement manuals and handbooks following the Capability Maturity Model (CMM) for Software (SW-CMM) SEI guidelines. The SW-CMM is a process maturity framework to help software organizations improve their software process.

• Systems Analyst, Department of Veterans Affairs (VA), 2003

o Demonstrated how position description files could be parsed and stored in MS SQL Server database by developing description Web application prototype in ASP.NET, delivering easy, efficient search capabilities.

• Systems Analyst, Caltrans, 08/2003-10/2003

o Delivered emergency support in resolution of issues with EWB system, and served as lead software analyst in upgrade for EWB and CCIS system at Caltrans Division of Construction.

o Successfully validated all data against Caltrans Constructions Business Rules before it can be used in reports and transferred to the Construction Administration System (CAS) for contractor payments.

o Systems are developed using Oracle Forms 6i and deployed on Oracles 9i Application Server to intranet Caltrans clients and Internet Construction contractors.

o Provide technical support for Caltrans analysts running reports using Oracle Discoverer.

• Systems Analyst, Davidson Institute, 07/2002-08/2003

o Created new MS/SQL Server 2000, ASP.NET custom Web application, client-tracking system with family information, contacts, schooling, referrals, testing, special interests, and complete detail of every contact.

o Modified and implemented new database design to increase performance and ease of access between the application program and the database.

o Create client reports utilizing Crystal Reports for Visual Studio .Net.

o Create Data Transfer program using Visual Studio .Net windows application that transfers the old client MS Access database data into the new SQL-Server database.

• Systems Analyst, Caltrans, 07/2001-07/2002

o Implemented user-requested modifications, including user interface changes, performance tuning, and generation and modifications of Web-enabled reports using Oracle Reports Developer; performed training.

o Generated batch processes using PL/SQL and Oracle-scheduled jobs and modifications to interface file for sending and receiving data from Caltrans Transaction Account Management System (TRAMS).

• Project Manager, Department of Motor Vehicles (DMV), 12/1999-03/2002

o Managed estimating, scheduling, risk analysis, business process / software requirements analysis, software design, development, testing, implementation, and training for upgrades to motor carrier permit (MCP) software.

o Authored MCP Software Change Document outlining all requirements, design modifications, and program changes required in implementing enhancement.

o Successfully developed and implemented Motor Carrier action rules engine and state machine, allowing changes to permit status, assessment of fees, and generation of notice letters with rules / logic stored in database, enabling quick and easy changes.

ADDITIONAL EXPERIENCE

• Software Engineer, Computing Devices International, 02/1992-10/1997

o Led integration of hardware and software supporting the System and Technology Integration Center (STIC).

• Software Engineer – TAWS / JIES, Systems Manager – Sacramento, SYSCON Corporation, 10/1984-02/1992

o Oversaw systems / networks; led development of Tactical Analysis Workstation and Joint Interoperability Evaluation System for procedural interface certification of Tactical Digital Information Link (TADIL) interfaces.

COMMUNITY MEMBERSHIPS

• Board Member, 2011 Parade Director, Elk Grove Western Festival

• Member, Elk Grove Strauss Festival Dancers, 2008-Present

Contact this candidate