Resume
Sign in

Project Manager Sql Server

Location:
Houston, Texas, 77064, United States
Salary:
$42/hr
Posted:
February 15, 2012
Email:
uzewcb@r.postjobfree.com
Contact Info:
*******.***@*****.*** (***)***-****


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