SUMMARY Expertise is intentionally broad-based to meet the adaptability and demands of a continuously changing business and IT Market. Background includes a BS in Mechanical Engineering, Kepner-Tregoe Project Management, Agile Development Methodology, and an ability to understand both business and technology needs. Recognized attributes include providing top service delivery via excellent written and verbal communication skills, analytical thinking, and being a team player. My primary interest is in a Solutions Analysis/Business Analyst position that focuses on Business Intelligence. BUSINESS AND TECHNICAL QUALIFICATIONS

• Mortgage Broker, Life Insurance, Property and Casualty, Equities, Fixed-Income, Derivative Instruments, Series 6 and Series 63 Previously licensed with Primerica Financial Services subsidiary of Citigroup Inc
• Corporate/Commercial Real Estate

• Process/Quality Engineering

• Business Intelligence / Physical and Logical Data Modeling

• Human Capital Analysis

• Object-oriented programming, Agile Development Methodology

Project Management

• Java, HTML, SQL, DML, DDL, Microsoft Office automation VBA , MS-Office, MS-Project, MS-Visio
• Netezza, Oracle, SQL Server, DB2

• MicroStrategy, Cognos, Arcplan

• MS-Office, MS-Project, MS-Visio

EXPERIENCE Confidential Hospital Cost Analytics Premier is a 2006 Malcolm Baldridge National Quality Award recipient. It is a performance improvement alliance of more than 2,900 U.S. hospitals and 100,000-plus other healthcare sites utilizing the power of collaboration and technology to achieve high quality, cost-effective care. Solutions Analysis

• Performed ROM estimation for entire fiscal year of work requests for Pharmacy Failure to Supply Project, which was used for budgeting and prioritization of work. Involved facilitating meetings with business analysts and subject matter experts. The high-level analysis performed resulted in better clarification, additional requirements, and removal of redundancies. One month of work or approximately 20,000 was saved due to solution analysis.
• MicroStrategy / Netezza Senior Business Intelligence Developer

• Provided end-to-end application development and technical analyst support for hospital Supply-chain business intelligence applications including MySpend, PharmacySpend, PremierSpend, and Food Service.

• Consulted with business partners and analysts to clarify business requirements

• Designed and developed physical and logical data-models for Ascend Compliance member program, Contract Pricing Updates, SupplyView, and other initiatives.

• Designed and developed type-2 dimensional data model for tracking monthly changes in the group purchasing membership hierarchy used to reconcile Food Service account payables. Resulted in resolution of long-experienced data integrity issues.

• Received 2012 Premier Values Award for performing as Lead Developer on SupplyView project. Successful implementation of the SupplyView project was crucial to retaining one of Premier's key customers.

• Designed and developed processes to manage member reference data for SupplyView project and other initiatives.

• Took initiative to fill temporary project management role and coordinate cross-team dependencies for Netezza database server upgrade. Involved coordination of work for security framework, application, and SQL changes. Saved Premier 125,000 in monthly support fees by meeting contract deadline.

Confidential

Senior Business Analyst Provided business and technical analyst support for AG Edwards merger scalability initiatives concerning the annual account fees process and intranet application. Facilitated requirement gathering meetings and design sessions. Composed business requirement and functional requirement documents for offshore development team. Requirement documentation incorporated UML diagrams for web application design. Used Mercury Quality Center for test plans, test scripts, and tracking application defects. Wrote SQL to test data integrity of Actuate reports and validate business rules. Confidential Project Manager / Business Analyst

• Provided Project Management support for Corporate Workplace Business Intelligence initiatives and change requests. The Corporate Workplace Line of Business provided space planning and property management services for Corporate Real Estate clients. Consulted with business partners and composed business requirement documents for reporting needs. Coordinated work of MicroStrategy Developers, Oracle Data Modelers, and Java programmers for project implementation. Defined projects by determining work break down structure, identifying resource requirements, and calculating estimated level of effort. Planned projects by sequencing deliverables, scheduling deliverables, and scheduling resources. Managed project risk by developing workaround solutions. Managed relationship and expectations of business clients.
• Designed and project managed automated data extraction and delivery process which transported data between data warehouse and FTP server to bridge the gap between operating systems and adhere to corporate security standards. Property management vendors used the data for facility environmental risk management.

• Project managed Occupancy Savings business intelligence initiative with the goal of identifying inefficient use of space. The project was estimated to save over 100 million dollars for managed facilities in North America.

• Wrote SQL using TOAD and composed test scripts for Internal User Acceptance testing IAT to validate user requirements with development.

• Utilized Mercury Quality Center Issue Tracking system for resolving software defects.

Confidential Senior Business Analyst Provided support for Change Management Centralization project which supported Corporate Investment Banking Technology internally developed applications. The project's purpose was to ensure cost avoidance and compliance with the Sarbanes-Oxley Act SOX and the Gramm-Leach-Bliley Act GLBA within the Software Development Life Cycle. Modeled business processes using UML uses cases and activity diagrams in order to document the current process and identify opportunities for process improvement. Produced scheduled reporting for monitoring overall project progression against baseline schedule during implementation. Confidential Senior Business Analyst Designed and validated SQL Sever data integrity triggers to ensure accurate financial reporting for Corporate Investment Banking projects. Confidential Business Analyst/Senior Reporting Consultant

• Provided project support for Business Intelligence tool selection and documentation of business rules.
• Translated business reporting needs into technical requirements. Acted as liaison between business units and ETL development teams. Provided ad-hoc and standard periodic reports to Client Resolution Team, Operations, Marketing, and Senior Management. Programmed Oracle packages stored procedures using PL/SQL in order to encapsulate and centralize business rules for reporting use

Confidential Senior Business Analyst

• Wachovia Human Resource Department Outsourcing HRO
• Composed knowledge transfer documentation for Report Analyst outsourcing. Translated business reporting needs into technical requirements. Helped maintain data dictionary and prompt dictionary for newly designed Cognos reports. Participated in internal user acceptance testing of production ready reports.

Confidential

• MicroStrategy Report and Report Object Developer
• Developed MicroStrategy reports and report objects used for General Banking Group HR reporting.

• Created MicroStrategy report filters and custom groups used to load Job Family data mart within Oracle.

• Created HR forecasting metrics in MicroStrategy.

• Assessed data integrity of underlying data model.

• Administered security settings for user groups.

Senior Management Reporting Consultant

• Consulted with HR Business Partner teams to determine information requirements for managing human capital. Provided error-free ad-hoc and standard periodic reports to clients in Human Resources HR and Finance departments. Facilitated business requirement gathering meetings with HR Senior Executives to design dashboard reports.
• Served as project manager and developer for Demographics Report Suite used for managing diversity of the General Banking Group's 48,000 employees. The dashboard is used by HR Action Committees and HR Business Partner Team Leaders to consult with State CEOs Tier 2 Leaders .

• Designed reports from OLTP and OLAP data systems using MicroStrategy, Crystal Reports, Access, and TOAD.

Business Analyst

• Provided project management support and programmed applications for various corporate initiatives. Team member for HR Data warehousing and Annual Common Review Salary Administration projects.
• Consulted with GBG Finance CFO to increase the efficiency and accuracy of the annual Common Review process used to update salaries and review ratings for the General Banking Group population.

• Translated Salary Administration Project business requirements into technical requirements and developed an application using Oracle, Microsoft Access, Visual Basic, Excel, and Crystal

• Wrote test scripts for end-users to test application functionality and identify nonconformance.

• Served as team member for HR Data warehouse data dictionary meta-data development.

Confidential Programmer Analyst

• Provided global IT support for Engineering Services, Sales, Marketing, and E-Commerce departments by maintaining existing Domino Lotus Notes systems and developing new solutions. Supported a web-based Notes application that tracked customer requests for literature. Delivered business solutions using software development life cycle processes SDLC . Provided assistance with rollout of new Customer Relationship Management CRM system called E-Sales. Developed client server applications. Created process flow diagrams to analyze business process and aid in application design. Constructed entity-relationship diagrams and object hierarchy models for design. Created reports and graphs using Seagate Info Crystal Reports , Access and Visual Basic.
• Piloted first SDLC process used by Corning included analysis, design, development, testing, and support phases and documentation.

• Project managed Electronic Scheduling Board facilitated meetings gathering business and technical requirements and analysis review.

Confidential Programmer Analyst Gathered requirements and delivered solution used to analyze and record accounting variances for regional offices. Integrated Microsoft Access and Microsoft Excel. Confidential Product Engineer Team member responsible for Full-life cycle development of electronic control valve used for automotive climate control. Designed validation testing, troubleshot and discovered product defects, and maintained inventory for entire project. Developed applications to generate reports and graphs for Quality Control statistics, product performance statistics, and manage project inventory. Confidential District Leader / Financial Analyst

• Marketed financial products and services to Retail and Institutional clients. Recruited and trained Sales Representatives. Provided Asset Management, Debt Management, and Risk Management financial services to individual clients. Retail products included Life Insurance, Property and Casualty Insurance, Mortgages, Conventional Loans, and IRAs. Institutional products included 401K plans, and SEPs. Securities included Mutual Funds and Variable Annuities.

• Performed individual and group presentations for sales, recruiting, and training purposes.

• Interviewed clients to extract financial data and compose Financial Needs Analysis FNA . The FNA indentified financial goals, income risk, investment risk profile, and debt freedom date.

• ollected saliva samples to determine insurability.

• Provided home inventory service for Property and Casualty clients.

• Sold debt acceleration programs and investments based on investment risk profile.

• Facilitated roll-over transactions from 401K plans to IRAs and Variable Annuities.

Confidential Programmer Analyst

• Access Database Design Visual Basic Programming
• Debugged erroneous queries, reports, and GUI's for existing application. Removed hard-coding from existing system and designed more scalable and functional application.

Confidential Process/Quality Engineer

• Customer Quality Team Coordinator
• Led containment and corrective action efforts for internal and external customer quality issues.
• Designed Access database to monitor product line performance, tracked returned material, documented repairs, and automated management tasks
• Applied 8D problem-solving techniques and Statistical Process Control SPC to uncover quality problem root causes developed containment and corrective actions.
• Redesigned manufacturing process workflows to increase efficiency.

Confidential Programmer Analyst

• Competitive Assessment Visual Basic Programming Internship
• Using self-taught Visual Basic programming, developed solution to automate competitive assessment process using Excel Automation.
• Plant-10 Maintenance Supervisor Internship