SUMMARY:

Over 15 years IT experience in multiple industries as a Business Analyst, Data Analyst, Process Analyst, and Database Designer/Developer. Highly organized, persistent and creative with acute attention to detail. Solution developer with extensive experience in data analysis (ETL and OLAP), VB/VBA development, process automation and custom/ad - hoc reporting. Proficient and flexible technical analyst fluent in all phases of software development including: identifying and documenting requirements, creating technical and design specifications, interface design, application design and development, interactive report design and decision automation.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX/AIX, Linux

Languages: VB/VBA, PL/SQL, SQL*Plus, NZSQL, KornShell, JCL, T-SQL, XML/HTML

Databases: Access, SQL Server, Oracle, Confidential

Software/Tools: Office, SQL Developer, SharePoint, PuTTY, Toad, Visual Web Developer Express 2013, Visio

Methodologies: OOAD, Prototyping, XP, Agile, Scrum, RUP, RAD, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. Data Analyst

Responsibilities:

• Identified data discrepancies between internal systems of record and determined appropriate steps to resolve (one-time update, modify query logic, etc)
• Modified stored procedures and production queries to include additional data cleansing and validation based on new discoveries.
• Updated canned reports as needed and created custom reports showing various metrics for monitoring recently resolved data issues as well as real time statistics for several KPIs.

Confidential, Plano, TX

Sr. Data Analyst, VBA Developer

Responsibilities:

• Supported metadata management, data quality implementation, cleansing, harmonization and maintenance processes and tools for Configuration Management System ( Confidential ) data.
• Standardized data cleansing and harmonization with relevant stakeholders.
• Documented Confidential definition and implementation of data quality rules for Confidential data.
• Analyzed and profiled Confidential data to increase quality as it relates to accuracy, completeness, consistency, integrity, timeliness, conformity, and validity.
• Performed ongoing metadata maintenance and content updates for Confidential data.

Confidential, Irving, TX

Sr. Data Analyst, VBA Developer

Responsibilities:

• Created an Access database to generate nine reports and post to Confidential Intranet every week. Many of these reports are extremely complex. (44) input files from five different sources must be updated prior to generating new reports. Eliminated user errors and isolated data issues by designing fully automated routines to validate, format/modify, import, and log all input files. Further ensured reporting accuracy by fully automating output report generation, validation, logging, and posting using VB/VBA. Note that Confidential original reporting process took two days to complete. After redesigning and streamlining logic and adding comprehensive error-checking Confidential entire process now takes only 40 minutes and six button clicks.
• Created an Access database to cleanse and validate then load repair vendor invoices and detail files every month. Designed a comprehensive routine using VB//VBA to automatically handle Confidential entire ETL process which provides a complete PASS/FAIL/SKIP report card for each file prior to loading. Developed (11) standard reports that are posted each month and developed (69) custom reports to filter and report on Confidential data in every other reasonable way based on Confidential target audience. Created SQL scripts and Cron jobs to stage and upload/replace records in Confidential Data Warehouse using Oracle ODBC connections.
• Created an Access database to enable Planners to select unassigned repairs then export selections into a template for seamless upload into SAP. This custom utility was created in Access 2010. Confidential interface was streamlined such that each Tab was auto-populated thus only requiring Confidential user to select parts (via a checkbox) and click buttons. Confidential interface and export functionality was created using VBA and produced a fully formatted and completed template with all of Confidential users' selected parts. Automating this process completely eliminated user errors and dramatically improved efficiency and increased daily output by 300 to 400%.
• Created a fully automated Excel Workbook using VB/VBA for use by Sparing Analysts and Repair Analysts to determine exact sparing levels at each location and multiple create repair orders simultaneously. This workbook was interactive and allowed users to 1) select excess spare quantities to be transferred to locations with a shortage, 2) select which parts to send out for repair, and 3) automatically generate and export a fully formatted and filled out spreadsheet for uploading into SAP. This workbook contained extensive validation which prevented input errors as well as help buttons next to certain command buttons that displayed a detail explanation of Confidential process(es) executed by that button.
• Completed various research and reporting requests on part usage, failure rates, and other ad-hoc requests.

Confidential, WY

Part Owner, Business Advisor

Responsibilities:

• Assisted aging parents in transforming family business from small town grocery and deli into a Bed & Breakfast.
• Assessed condition of property, negotiated sale of commercial freezers and various shelving/displays, scheduled major repairs and helped with physical renovation.

Confidential, Irving, TX

Sr. Database Developer, Sr. Operations Analyst

Responsibilities:

• Managed 64 UNIX, Linux, and Windows servers and Oracle and Confidential databases including production access, code promotion, security monitoring and reporting, password management, and software installation, licensing and renewals.
• Worked with client and PM to determine scope and Confidential on production requests, new file receipts, process changes, etc. Worked with BAs and technical team to review processes and identify scripts to be modified and then determine what functionality would need to be created. Interacted extensively with Tech Team Lead to define coding requirements and with Lead Analyst to define process documentation and testing requirements.
• Managed much of Confidential manual ETL process, created/modified KornShell scripts for receiving, validating, cleansing and loading files from various sources. Created/modified SQL scripts to refresh large tables (200mil+ recs) using DDL, DML, T-SQL, and some Perl for reporting.
• Created and maintained an extensive Operations and Procedures Manual used for BA and Tech Team reference and for training new team members.
• Created numerous scripts for monitoring server activity and intrusion attempts as well as several scripts for automating file archiving and managing landing directories.
• Developed and documented procedures for promoting new code into production.

Confidential, Irving, TX

Sr. Data Analyst, Reporting Specialist

Responsibilities:

• Worked with Commercial, Residential, and Electric Delivery managers to gather, analyze, and report on Customer Satisfaction survey data.
• Analyzed customer response data regarding their experience with Confidential Call Center to gauge Agent performance, customer experience, and overall process effectiveness in approximately 180 areas.
• Standardized raw data from numerous sources using Informatica then loaded into a Customer Satisfaction data warehouse. Established solid, repeatable processes for capturing, processing, and reporting Customer Satisfaction data.
• Developed two Access 2002 databases to automate Confidential collection of raw data files from various sources, including Confidential, Word documents, Confidential files, Excel spreadsheets, and text files. Wrote several modules (SQL, VB/VBA) to automate import and validation routines.
• Designed several high level summary reports and dozens of very comprehensive spreadsheets. Developed highly customized macros for filtering, copying values, formatting, exporting and printing. Created interactive spreadsheets to allow managers to forecast.
• Performed code reviews for all databases, spreadsheets, macros, and modules used to capture, validate, manipulate, and report on Confidential data to ensure accuracy and standardize reporting methods for Confidential Data Analytics team.

Confidential, Irving, TX

Sr. Business Analyst, Application Support

Responsibilities:

• Supported over 30 applications for Public Affairs, Investor Relations, Office of Confidential Secretary, Aviation, and Confidential and Facilities.
• Worked with Confidential Managers in Public Affairs, Investor Relations and Office of Confidential Secretary on Confidential management of their software including risking each application and completing risk assessments (RAs), classifying data, establishing service level agreements (SLAs) and business level agreementsK.
• Assisted Business Owners with regular Access Reviews for each of their applications to verify user permissions and reviewed and updated LAN Share Access Review reports.
• Responsible for full spectrum troubleshooting on eight internally developed Microsoft Access applications including conducting data analysis, data cleansing, design and functionality enhancements, permissions and user training issues, and restoring from backups.
• Designed new custom install routines for eight Microsoft Access databases used to simplify and automate installation of these applications on user workstations with restricted rights. Completed coding and design enhancements for three applications.

Confidential, Irving, TX

Team Lead, Web Interface Specialist

Responsibilities:

• Reviewed and analyzed over 50 use cases for a new Computer Aided Facilities Management web application to be used to track over 480 corporate facilities worldwide.
• Established web standards unique to this application and created ‘look and feel’ templates to be used for Confidential portal and all pages within this intranet site.
• Designed over three-dozen web pages using Visio for graphics and buttons, and for presentation of general page layout.
• Designed Confidential CSS and assisted in Confidential rendering of these screens using Dreamweaver to create a prototype to demonstrate functionality and personality of new web site to client.
• Assisted with Confidential test scripts and with Confidential testing of Confidential web pages to ensure finished product followed intended flow and navigability.

Confidential, Carrollton, TX

Web UI Designer

Responsibilities:

• Designed 14 new web screens for an existing web application used to track and monitor all phone activity in approximately 1400 prisons.
• Worked closely with Confidential marketing and IT managers to create a new ‘look and feel’ for client’s web site.
• Established new standard for client’s web site colors and graphics, and created Confidential new layout to be used for Confidential rest of this web site.

Confidential, Dallas, TX

Process Analyst, Application Developer

Responsibilities:

• Analyzed client’s existing software and business processes and created two new applications to manage workflow.
• Designed and developed an Access database to allow users to maintain Agent information including Agent’s hierarchy, licensed states, fees, associated companies, leads, taken rate, hire and termination date, vesting period, etc.
• Designed and developed an Access database to allow users to maintain providers, plans, rates, policies, advances, and commissions.
• Tables for both databases were stored in a third database, which contained all business rules and established relationships to ensure data integrity. Each database contained dozens of customizable reports (sorting, filtering, date and monetary ranges, etc.)

Confidential, Dallas, TX

Business Analyst, Application Developer

Responsibilities:

• Worked with Accounting managers to create a budgeting and forecasting application that automated Confidential updating and summarizing of several reports and spreadsheets and allowed users to capture data and view budget and forecast information in real time.
• One unique feature of Confidential application was a pop-up window that provided users with Confidential ability to project numbers for different departments and save their notes and calculations, similar to on-screen scratch paper.

Confidential, Irving, TX

Application Developer, Project Manager

Responsibilities:

• Created several custom applications for use by Confidential Settlement Services division and Accounting Department (payment posting). Completely redesigned Confidential Title Tracking database for EnTerra Settlement Services. This database was used to monitor, track, and maintain mortgage loan applications.
• Created a loan fee calculator which dramatically reduced errors by automatically calculating all fees and associated charges for each order. Created a customer information application which allowed users to quickly locate customer contact information and check Confidential status of all required documents.
• Lead project team of 7 in designing a new accounting application using VB 6.0 and Crystal Reports. This application was used to post payments to orders and allowed users to split payments over several orders, reverse payments, reassign funds between clients and orders, generate client statements and invoices, and refund clients and branches.