SKILLS

• Databases: MS Access 1997/2002/2003/2007/2010/2013 , Oracle 9i and 10g , SQL Server 2000/2005/2008/2008R2/2012 , Peoplesoft, DB2, Paradox, SAP
• Datawarehouse: Teradata w/Teradata SQL Assistant Programming Languages: SQL, PL/SQL, VBA, T-SQL, .Net, MDX Operating Systems: Windows 95/98/NT/2000/2003/2007/XP/Windows 7, Windows 8 Software: Tableau, Business Objects, Microstrategy, Informatica, SAS, Toad, Crystal Reports, Oracle Discoverer, Cognos, Erwin, Documentum, Sharepoint, Summation, Dreamweaver, Power Point, Corel Draw, Visio, Flash, Illustrator, Calyx Point, Office 2003/2007/2010, Word, MS Excel, WordPerfect, FrontPage, PageMaker, Outlook, Lotus Notes, Peachtree, Symphony, Access Runtime

CAREER EXPERIENCE

Confidential

Business Analyst

SME on Cargo business account information. Provided analysis services via SQL Server, Teradata, Access, Excel, VBA, and QA for Cargo shipping department regarding international accounts. Additionally, provided data cleansing for department accounts information.

Confidential

Database Specialist

Access Database consultant for home mortgage loan processing industry to ensure updates of payouts of homeowners and validations returned all monies from mortgage company to homeowners. Use of VBA programming.

Confidential

SQL Developer

• Updated multiple Access databases for Workers Compensation, General Liability, Health, and Auto insurance reporting via VBA code.
• SSIS for data warehouse buildout on SQL Server 2005
• Created ERD for main database to define primary and foreign key locations as well as data mappings for data warehouse build.

Confidential

Access Developer/Data Analyst

• Contract to update several 3 Access databases.to track safety concerns with railroad locomotive and car wheels used by the Mechanical Operations and NOC departments with over 30 users.
• Created BI reports.
• Scrubbed all database objects/VBA in preparation for partial turnover to WebFocus, SQL Server, and other technical support.
• Used SharePoint to post database information on a weekly basis.

Confidential

Access Developer/Data Analyst

• Remote access contract to develop Access 2010 database for Space Planning Department to track all store display units based on size, type, and season. The development of this database was primarily created for data analysis, reporting, user input.
• Used VBA, Oracle, SQL Server 2005, JDA, and ETL to import and scrub data.
• Created additional BI reports from SQL SSRS, Microstrategy, and Oracle

Confidential

Access Developer/Data Analyst

• Contract for updating of current 2007 Access Database which tracked all electrical outages and lockouts throughout the North Texas region.
• Created Data Model ERD, Technical Specifications, and Field Data Definitions for new database to be created to mimic old database but with correct naming of objects, form controls, and VBA code.

Confidential

Access Developer/Data Analyst

Contract for updating several 2003 Access databases to track equipment being used by Office Depot warehouse associates entering and leaving the warehouse, manager safety meeting scheduling, and reporting of associate efficiency to ensure individual goals were met.

Confidential

Senior Business Analyst

• Contract for development of multiple 2007 MS Access databases for automated and ad hoc reporting and for tracking new, under review, and completion of MLS, MI, Second Lien, and Valuation cases.
• Major data scrubbing and ETL requirements and downloads using MS Access 2007, VBA, Toad, Business Objects, and Oracle.
• Updated SharePoint site connected to Access Database.
• Main focus on Deed in Lieu and Short Sales completions.

Confidential

Access Developer/Data Analyst

• Remote access contract for development of multiple 2007 MS Access databases and 2007 Excel spreadsheets utilized for data mining, data cleansing, data migration, data manipulation, and data scrubbing ETL to discover a variety of information specifically to assist in the packaging migration process of applications vendor and business developed for organizations throughout Citigroup globally.
• Provided customer assistance to packaging migration requestors globally.
• Developed Power Point training guides for packaging request process.
• Developed SharePoint site for team use.

Confidential

Team Lead

Contract for installation of staff and teller workstations throughout the DFW area due to merger with Washington Mutual banks.

Confidential

Access Developer/Data Analyst

• Contract for development of MS Access database to be utilized to track the allocation, utilization, and capacity of all airport terminals and buildings fiber optics Single Mode/Multi Mode and copper wiring.
• Use of VBA code to further enhance Access database.
• Conducted audit of DFW Airport's software licenses.

Confidential

Access Developer/Data Analyst

Short term contract developing small MS Access database for engineering department to identify radio frequency changes for T-Mobile's RF sites in the Southern Region of the United States. Additionally, used MapInfo to identify radio frequency readings from various Southwestern United States locations.

Confidential

Consultant/Access Developer

• Short term contract modeling and development of several Microsoft Access databases for use by mainframe technical professionals to provide enhancement of conversion for Capital One's new banking organization to include data migration, data warehouse, and ETL development.
• Developed Access Database by use of VBA code to supply mainframe technical professionals ability to update security mainframe in a more timely manner RACF, Top Secret, TouchPoint, and MPS .
• Developed Access Database to identify corrections necessary to align recently acquired data to current company standards included ad hoc reports, pivot tables, pivot charts, and crosstabs .
• Provided consulting services for improvement of current mainframe security databases.

Confidential

Access Developer/Analyst

Short term contract to remedy issues with multiple users throughout the United States running 2003 Microsoft Access databases over WAN which continuously incurred both database corruption and decelerated speed of the application tremendously.

Confidential

Access Developer/Data Analyst

• Contract position for 1997 Microsoft Access database conversion project.
• Member of six man team in conversion of Access accounting databases to DB2, Essbase, and SQL.
• Utilized Excel, ETL, and VBA development for over 400 company accounting databases.

Confidential

Consultant/Data Analyst

• Contract position to model and develop 2002 Microsoft Access database for Network RF Engineering department to provide cell site demographics, types of field equipment at cell sites, and information detailing cell site status.
• Provided report generation, analysis, and validation.

Confidential

Consultant/Access Developer

• Developed and modeled 2003 Microsoft Access database pivot tables/crosstabs/macros for change Toad, Oracle, SQL, PL/SQL, SQL DTS, ETL for data scrub, Informatica, Erwin, SAS, Unix . Creation and updates of Oracle Tables.
• Provided Report Generation, Analysis, and Validation.
• Created Excel spreadsheets for data manipulation and analysis.

Confidential

Access Developer/Data Analyst

• Contract position to provide report generation/analysis, research/reporting, and survey development.
• Developed and modeled Access database for array of executive online courses Harvard analysis pivot tables/crosstabs/charts/dashboards and reporting Excel, Toad, Oracle, Discoverer, SQL, Peoplesoft to include analysis of course enrollment/completion, registrants, demographics, and management.
• Reviewed and performed validation to ensure accuracy.
• Creation of marketing material for HR Workforce Development and outside vendor provided courses Flash and PowerPoint to increase enrollment.
• Research of online course material for HR employee course work.
• Creation of surveys to generate ideas and input of course registrants.

Confidential

Access Developer/Data Analyst

Contract position to develop Access database to analyze and report all property demographics owned by EMC Mortgage.

Confidential

Access Developer/Data Analyst

Contract position to develop Access database for telecommunications engineering department designed ad hoc reports depicting client/business demographics, installation costs, sales, and revenue, etc.

Confidential

Project Assistant

• Developed Access database for the Fleet Acquisitions Department.
• Designed and maintained departmental intranet web site to display information on all leased and owned vehicle costs and demographics.
• Produced Crystal Reports to detail extensive leased/owned vehicle history and costs. Assisted in annual departmental budget forecasting.
• Supported Human Resources Incentive Compensation department including the Vice President, Assistant Vice President, Directors and Managers.
• Conducted audits of incentive payouts to various groups SAP and Y2K and earned
• Individual Excellence Award bonus in the amount of 500 for locating invalid incentive compensation payouts.

Confidential

• Telecommunications Coordinator/Legal Secretary/Word Processor/Reporting Specialist/Software Trainer
• Provided real estate, corporate, mortgage, litigation, ERISA, labor, environmental, and Patent support.
• Telecommunications Coordinator to provide add/moves/changes to phones as well as Octel voice mail.
• Provided training on company software for both staff and attorneys.
• Provided legal secretarial support and word processing.

Confidential

Sales Assistant/Admin

Provided sales assistance to medical imaging associates to include administrative assistance, expense reports, calendar, and customer service. Provided analysis of sales per demographics, associates, and products