Project Manager Sql Server

Senior Business Systems Analyst

PROFESSIONAL SUMMARY

* 10+ experience in IT and Business support

* Strong business intelligence skills

* Proven ability to train and support end users

* Knowledge and skills to manage a full SDLC process

* Seven years of database administration experience

* Outstanding analytical and problem solving skills

AREAS OF EXPERIENCE

Business and Data Engineering

Supply Chain Management Object Oriented Analysis & Design Business Intelligence

Relational Database Management Customer Relationship Management Software and System Testing

Software Development Life Cycle Business Process Modeling SSIS/SSRS/SSAS

User and Technical Training Requirements Gathering Data Analysis

Industry and Business Exposure

Warehouse/Logistics Accounting/Finance Transportation Equipment Maintenance

Property Management Government Education Procurement

EDUCATION

Bachelor of Computer Science (BS), 2001 – Prairie View A&M University – Prairie View, Texas

PROFESSIONAL EXPERIENCE

DynCorp International, LLC 2009 – 2011

Information Management System(IMS) Analyst for a global government services provider in support of U.S. national security and foreign policy objectives. Majority of projects were in support of personnel in Kuwait and Afghanistan.

Role: IMS Analyst

Responsibilities: Gathered business requirements and needs through interviews, shadowing, use cases, prototyping, and questionnaires. Utilized business process models and diagrams to effectively communicate with end users, stakeholders, SMEs, and technical team to ensure that user and system requirements were fully understood by key members. Member of project team that implemented change, modification and upgrade of business processes and 70+ medium- to large-scale software and system applications to satisfy Logcap IV project requirements, performance expectations, and government service level agreements (SLAs) in Kuwait and Afghanistan. Created workflow diagrams for ‘as is’ and ‘to be’ processes. Experience in full SDLC lifecycle implementation of enterprise resource planning (ERP) focusing on Warehouse Management, Inventory Management, Logistics, Procurement, and Accounting software solutions. Performed unit, implementation, regression, black box, and user acceptance testing. Designed, developed, and instructed training courses for new and updated logistics, warehouse, and maintenance software via instructor-led group and one-on-one instruction as well as teleconferencing to personnel in Kuwait and Afghanistan. Conducted Train-the-Trainer sessions for Logcap IV managers and created Quick Reference Guides (QRGs) for end-users.

Tools: Methodologies: Use cases, Rational Unified Process, System Development Lifecycle, Business Process Modeling

Operating Systems: Windows Server 2005/2008, Windows 7/Vista

Applications: MS Visio, MS Project, Quick Test Pro (QTP), SharePoint BI, MS Office, Adobe Illustrator, Snagit

Role: Database Analyst

Responsibilities: Designed data models and mapping for data being extracted, transformed, and loaded into data warehouse. Integrated, cleansed, and transformed data from various databases and sources into data mart for the warehouse and logistics department using the star schema. Performed analysis on an OLAP cube for the accounting department, which after drilling down discovered costly inventory duplication errors that once issue was resolved, saved the company over $500K. Developed an Excel PivotTable for the director of maintenance that highlighted assets, serial numbers, sites, operators, and functional status. Performed ad-hoc queries from SQL server databases based on varying departments’ business intelligence requirements. Created a comprehensive reporting dashboard via MOSS 2007 to enhance the reporting needs of warehouse and logistics departments. Possess solid experience with SQL server development (stored procedures, views, triggers, query optimization).

Tools: Operating Systems: Windows Server 2005/2008, Windows XP/Vista/7

Server: Integration, Reporting, and Analysis Services, MOSS 2007

DBMS: Excel, SQL Server 2005/2008

Applications: MS SQL Server Management Studio, SharePoint BI, MS Office

Lonestar College System 2006 – 2009

College Math Professor that taught introductory and intermediate college algebra utilizing instructor led, CBT, and e-learning to effectively teach students algebraic concepts for a publicly funded community college system that serves the Greater Houston area.

Role: College Professor

Responsibilities: Implemented various learning tools (i.e. technology, life applications, and visuals) to enhance students learning and to make abstract algebraic concepts real and tangible. Observed, analyzed, and received feedback from students on their learning and comprehension of mathematical concepts to modify and revise lecture, supplements, and applications that addressed various learning styles. Participated in an e-learning and instructor led pilot program that focused on improving a professor’s instructional design and delivery of materials by applying Bloom’s taxonomy levels of learning. Received recognition in department for actively participating in the college’s initiative, “Achieving the Dream”, by mentoring, tutoring, and encouraging minority and economically disadvantaged students to stay in school and successfully receive a degree or certification.

Tools: Methodologies: Bloom’s Taxonomy

Operating Systems: Windows Operating Systems, Windows XP

Applications: Blackboard, MS PowerPoint, Adobe Illustrator, MS Office

EADS 2004 – 2006

Information Management Systems Analyst for a global aerospace and defense corporation that is a military contractor worldwide. Most projects were in support of the procurement and accounting departments.

Role: IMS Analyst

Responsibilities: Technical lead in deployment and integration from IBM Mainframe to client/server system. Consulted with stakeholders to conduct a requirements and needs analysis concerning present and future software/system application requirements and needs. Advised project manager and development team on effective change management approaches and made recommendations for improvements throughout the process. Held workshops for employee focus groups to ensure there was a thorough understanding of upcoming system and software changes. Met with design and development team members on a continuous basis to confirm that change management requirements were understood and planned accordingly. Communicated with vendors and suppliers to identify process and delivery improvements which decreased materials shipment and delivery times. Responsible for maintaining relationship with vendor to ensure that compliance was in alignment with contractual obligations and statements of work. Experience in RFQs, RFPs, contract negotiations, and vendor selection process.

Tools: Operating Systems: Windows XP, Windows Server 2000/2003, IBM Mainframe

Methodologies: Waterfall, Unified Modeling Language

Applications: MS Office Suite, MS Visio 2003, MS Project 2003

DBMS: MS Access, SQL Server 2003

Coding: C++

Role: Database Administration

Responsibilities: Experience in designing, coding, and maintaining databases in SQL Server environments. Analyzed, identified, resolved, and updated information in procurement and inventory databases. Evaluated logistic and procurement departments’ database processes to recommend business solutions to increase vendor response and faster delivery time. Consulted management on application and database enhancements that would improve business processes and increase document workflow. Generated reports for department managers based on business goals and departmental objectives. Designed, developed, and implemented data backup and restoration procedures. Analyzed and modified existing databases to increase optimal performance through query optimization and stored procedures.

Tools: Operating Systems: Windows XP, Windows Server 2000/2003, IBM Mainframe

Applications: MS Office Suite, Lotus Notes

DBMS: MS Access, Excel, SQL Server 2003

Coding: SQL, MySQL

Allen House Properties 2001 – 2004

Technical Support Analyst that provided onsite technical support to employees of a multimillion dollar property management company.

Role: Technical Analyst

Responsibilities: Provided consultation to personnel on upgrades and hardware/software recommendations that would improve the speed of their operations and system security after analyzing their business systems and user needs. Upgraded new software and resolved Tier 1 help desk issues. Lead in software implementation, upgrades, and installing internetworking hardware (PCs, printers, scanners, and phones). Developed a technical knowledge base that was used by management, staff, and residents. Created and maintained instructional training materials on Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook), Cisco phone and timekeeping software.

Tools: Operating Systems: Windows 98/2000/ME

Applications: MS Office Suite, proprietary software

Role: Database Administrator

Responsibilities: Designed, developed, and maintained a resident database using MS Access. Ran database reports in MS Excel and Access.

Tools: Operating Systems: Windows 98/2000/ME

Applications: MS Office Suite, proprietary software

DBMS: MS Access, Excel

MILITARY EXPERIENCE

Texas Army National Guard – Company A 136th Signal Battalion, Houston, TX – 1991-1999

31U – Signal Support Systems Specialist Rank: Specialist

Duties: Installed, maintained, and troubleshot Signal support systems and terminal devices, to include radio, wire, and battlefield automated systems. Operated and maintained designated database systems. Performed Signal support functions, to include providing technical assistance and training for user owned and operated automation and communications equipment and software. Prepared and integrated Signal operations orders and reports.

Security Clearance – Secret

Discharge – Honorable

Contact this candidate