COMPETENCIES:

Project Coordination\Implementation

Business Systems Analysis

Process Analysis and Improvement

Financial Modeling, Analysis and Reporting

AIS\FIS Analysis & Design

Requirements\Specifications Gathering and Documentation

Data Analysis\Modeling\Migration\Testing

Database Design & Development

Applications Design, Development and Implementation

Project & Systems Documentation

User Acceptance Testing

Systems Development Methodologies

SOFTWARE:

MS Office 2007\2010 COM

MS SharePoint, NetMeeting

Oracle 8i/9i, Oracle Financials

MS Access, MS Excel 2007\2010

Microsoft Project Server

VB.Net 2005, 2012, MFC, COM

ADO\DAO\ODBC Access 2007\2010

Microsoft Visio 2007\2010

DDL, DML, Server - Side Scripting

Visual Basic for Applications\COM

MS PowerPoint, MS Outlook

OO Design

Business Objects

SQL Server 2000\2005\2012

DAO, ADO, ADO.Net

Winforms, MS Office forms

SQL Server SSIS, SSAS

Microsoft BI Developer Studio

TeraData 13.0 SQL( Confidential -SQL, Jet, PL\SQL, Teradata) ODBC for major RDMS platforms

PROJECTS\EXPERIENCE:

Confidential. Irving, Texas

Consultant\Analyst/HRIS Database Developer\Administrator

Responsibilities:

• Performed systems analysis and development tasks for centralizing HR and Payroll functions from Regional facilities to Corporate Offices in Irving, Texas.
• Created Compensation Data database from Automated Data Processing (APD) data feeds for use in metrics reporting
• Interacted with end-user communities and data warehouse developers to define and collect system requirements, identify data sources, elucidate metrics calculations, and schedule monthly reporting deliverables.
• Created Position tracking application to expose vacant Positions for use by departmental supervisors throughout corporate regions
• Created application to fuse legacy Paid Time Off (PTO) data with ADP data to enable adjustments to employee accounts
• Created Position Requisition Application, user interface, and designed database to house requisition data
• Created Texas and Louisiana Work Force Commission quarterly Wage reports and submitted data to state agencies
• Developed Payroll Overtime tracking charting application to display trends by Facility and Department
• Created database and reporting deck for internal demographics information - Diversity and Inclusion (147 charts for 13 Regions)
• Created graphical (Visio) application to generate organizational structure based departments reporting to other departments
• Created SSIS packages for uploading nightly data interface files from ADP system
• Gathered business requirements from user communities
• Setup testing scenarios for application\repository process and data validation

Tools: SQL Server 2012 Management Studio, SQL Server Business Intelligence Developer Studio, Server Manager 2012, SQL Agent, Confidential -SQL, SQL Server Integration Services, PowerShell, ETL, Stored Procedures, VBA, MFC, COM, MS Excel, MS Graph, MS Access, MS PowerPoint, Automation, Interop assemblies, Application\Data Testing, Data Mapping, VB.Net, VSTA, Windows Forms, ADP Virtual Edge, MedAssets Data, Lincoln Mutual Data, McKesson Data

Confidential, Coppell, Texas

Consultant\Applications Developer

Responsibilities:

• Mortgage banking database platform upgrade from DB2 to Teradata project
• Evaluated SQL results for comparison between output on IBM DB2 and Teradata 13.0 systems
• Built project tracking application using testing results data from HP Quality Center

Tools: SQL, VBA, MS Access, MS Excel, JIRA, HP Quality Center

Confidential, Dallas, Texas

Consultant\Analyst/Applications Developer

Responsibilities:

• Created process flow and data flow documentation for Asset Inventory and Sales legacy system (Integrated Sales Tool).
• Developed Variance Flags By Asset (VARBA) application using Confidential -SQL, stored procedures and MS Excel reporting front-end for reconciling data in four repositories.
• Created SQL Server-MS Excel application for tracking loan inventory thru litigation process (Receivership Assets In Litigation (RAILS), Pre-Litigation status to final Judgment).
• Created forms for data entry and record viewing (Asset Servicing Technology Enhancement Project (ASTEP) database)
• Loaded incoming MS Excel data files from banks to SQL Server tables

Tools: SQL Server 2005 Management Studio, SQL Server Business Intelligence Developer Studio, Confidential -SQL, Table Joins, Data Manipulation and Data Definition Language SQL scripting, Agile, SSIS, SSAS, ETL, VSTA, MS Excel, Interop Assemblies, Pivot Caches\Tables, MS Visio, MS Access, VBA\COM libraries, Automation

Confidential, Plano, Texas

Consultant\Business Analyst

Responsibilities:

• Designed suite of interactive Business Intelligence applications for Home Loan and Portfolio functions on Mortgage Data Warehouse (MDW) platform.
• Interacted with end-user communities and data warehouse developers to define and collect system requirements, identify data sources, elucidate metrics calculations, and schedule monthly reporting deliverables.
• Lead design\development\testing\audit efforts for reporting applications (Portfolio Volumes, Portfolio Quality, Portfolio Performance, Macro Environment, Originations Volumes, Originations Portfolio, Originations Performance, Default Management, Loan Modification, Recast, Pricing, Marketing Efficiency, Warehouse Efficiency, Comparative Originations Quality, and Executive Summary Decks).
• Created testing scenarios and procedures for verification audits of reports against data repositories and previous monthly reports.
• Administered monthly cycle of collecting alterations to data and report requirements.
• Eliminated inefficient time consuming manual processes for generating monthly home loan, portfolio, and mortgage reports and replaced manual system with automated reporting process.
• Composed Teradata SQL scripts and stored procedures for generating source data and preparing data for use in populating MS Graph charts.
• Served analyst community as an expert reference for VBA\COM\ExcelWord applications development helping analysts create VBA Add-Ins for Excel, use formulas (H-Lookup, V-Lookup), build pivot tables, build charts, format worksheets\charts, and automate the extraction of data from repositories.
• Created and updated project planning, requirements tracking, and development issue tracking logs.

Tools: MS Excel, MS Visio, MS PowerPoint, MS Graph 8, VBA\COM libraries, Agile, Teradata v13.0, SQL, Table Joins, Data Sourcing\Mapping, Data Manipulation and Data Definition Language SQL scripting, Agile Development model, VPN

Confidential, Terrell, Texas

Consultant\Business Systems Analyst

Responsibilities:

• Designed\Implemented MS Excel Operational\Financial Metrics Reporting Application for summarizing\displaying information for Architectural Glazing Systems business (Custom designed\engineered frame and glass structures for office buildings\sky scrapers serving US and international markets).
• Application extracts data from recently implemented ERP system\other custom databases and calculates metrics for Marketing, Sales, Materials costs, Labor, Variable Spending, Factory Production, Safety, and Financial Returns.
• Created MS Access forms for configuring periodic data sets, commanding processes\calculations, and data view\entry\edit of weekly metrics.
• Composed SQL scripts and stored procedures for creating and extracting data sets used in reporting application.
• Created help forms and supporting procedural\instructional usage documentation for maintenance of application.

Tools: MS Excel, MS Access, VBA\COM, Automation, Epicore (ERP, MRP, AIS modules), Agile, SQL Server 2005 Management Studio, SQL Server Business Intelligence Developer Studio, Confidential -SQL, ETL, Table Joins, Data Sourcing\Mapping, Data Manipulation and Data Definition Language SQL scripting, SSIS

Confidential, Addison, Texas

Consultant\Database Project Analyst

Responsibilities:

• Conducted evaluation of data, design, and control issues of AIS database used for processing revenue and expenses related to the operation of staffing temporary labor services (nursing, allied, non-clinical support) to hospitals throughout the USA.
• Interacted with accounting managers and staff to identify flaws in system, investigated causes of annual audit findings and formulated solutions, documented user processes and proposed system design, and presented findings to IT department management.
• Designed new relational\normalized database model, created prototype database for new structure in MS Access, identified and removed duplicate records, created project schedule for phases and sequences of developing new system, created GUI prototypes, created tables and migrated data to SQL Server platform, defined project, functional, reporting, and documentation requirements for in-house development effort and eventual upgrade and integration with enterprise level architecture.

Tools: MS Access, MS Excel, MS PowerPoint, VBA, Excel and Access COM libraries, DAO\ADO, Automation, SQL\ Confidential -SQL, SQL Server 2005 Management Studio, Data Manipulation and Data Definition Language SQL scripting, SSIS, ETL, Table Joins, ODBC, MS SharePoint, MS Visio, MS Project

Confidential, Richardson, Texas

Consultant\IT Busines s Analyst

Responsibilities:

• Designed\Implemented several custom applications for automating all the tasks involved in provisioning (creating, modifying, and resetting roles and access privileges) user accounts from work orders generated by intranet request system in support of larger Tivoli Identity Manager (TIM) implementation project.
• Work request volume automated ranged from applications with 500 requests per year to 40,000 requests per year. Guided development through analysis, development, testing and implementation. Applications consisted of MS Excel front end and .Net Console Application with ODBC connections to SQL Server and Oracle databases and Internet Explorer\HTML automation.
• Designed\Implemented SOX contingency planning database to manage the transition of 80,000 workers during potential labor strike by various unions under different contracts set for renegotiation\potential strike in April 2009. Database tracks 17,000+ job-codes by application, identifies personnel and systems impacted by a strike, provides information for deactivating union worker accounts and activating temporary labor replacement accounts, generates managerial reports for business unit, location, job titles, head count, and resource planning purposes. Designed prototype database in MS Access with VBA\COM extraction of Questionnaires (Excel workbooks) from MS Outlook email attachments and imports from SharePoint tables. Documented Use Case scenarios for data entry and reporting functions.
• System later upgraded to SQL Server backend with Questionnaire feed from SharePoint tables. Participated in pre-deployment final testing and data cleanup efforts.
• Designed\Implemented interactive activity report\pivot extracts for Point-of-Sale system in MS Excel\VBA for use in identifying obsolete user\system accounts.
• Interacted with Application business owners and support staff to research and define system processes and requirements, created and archived systems requirements documentation, guided application development projects through design, development, and user acceptance phases, and archived applications code modules in ClearCase versioning software.
• Served as Tier I Systems Administrator for development team application versioning using ClearCase version 7.0 (CCase Web, Remote Client, HomeBase).
• Provided operational support and on-call duties for Point of Sale Application\Database serving thousands of retail outlets across USA.

Tools: VB.NET 2005, MFC, VBA, MS Excel, MS Access, MS Office COM libraries, MS Office Inter-operative Assemblies, ADO, MS SharePoint, MS PowerPoint, Agile, SQL, Table Joins, Data Manipulation Language scripting, SQL, ODBC, Automation, Oracle 9, JavaScript, MSHTML COM, HTML, MS NetMeeting, VPN, LoadRunner, DataLoad, ClearCase, MS Visio

Confidential, Dallas, Texas

Consultant\Business Data Analyst

Responsibilities:

• Designed\Implemented CPM scheduling application for Cellular Systems Software Design Project Managers use in scheduling the rollout of individual code components into finished products to meet commitment deadlines. Application utilized MS Excel as front end with connections and data extracts to MS Project Server, SQL Server, ClearQuest, and Oracle Data Marts. Iteratively added new features to application based on user community needs, tested data and processes for multiple release versions, and deployed\supported application to multi-site international user community.
• Designed\Implemented cellular phone programming-code inspection application necessitated by need for CMMI quality assurance certification. Designed prototype database in MS Access\VBA COM with MS Excel as front-end\data source. Upgraded prototype to Winforms and Excel GUI with Oracle backend. Created forms for extracting archived Excel workbooks and statistical report extracts, DDL statements for table creation, stored procedures for centralization of processing,
• Designed\Implemented code storage application in MS Access\VBA for entry, storage, and retrieval of module and code (procedures, classes) samples and examples for reference and reuse. Application allows for search and retrieval of records based on selections in multiple drop-down menus.
• Created supporting systems documentation, procedural documentation, and diagrams for development efforts.
• Interacted with project managers, end users, and support staff to define applications requirements, created user system interaction procedures, documented use cases, guided projects through design, development, and user acceptance phases, and addressed operational concerns of applications.

Tools: VBA, VB.Net 2005, Windows Forms, MS Office Inter-operative Assemblies, Automation, Excel and Access Object Libraries, MS SharePoint, MS PowerPoint, ADO, ODBC, SQL, Table Joins, Data Sourcing\Mapping, Data Manipulation and Data Definition Language SQL