SUMMARY:

• Reviewing business processes to determine material & labor waste, redundancy, and more importantly opportunities for improving production and/or efficiency as well as developing the necessary solutions has been a staple of my career over the past 15 years.
• From creating simple macros in AutoCAD, Excel and Access early in my career, to developing complete software/database packages utilizing VBA and relational database design as an independent consultant/business owner, to working in a fast paced I.T. environment creating ad - hoc reports, analyzing data, gathering business requirements, documenting technical processes and SOPs, and developing Informatica mappings within a dynamic Reporting/BI team; my career has laid a foundation for me to provide immense value to a great variety team workplace environments.

TECHNICAL SKILLS:

• Full Lifecycle project experience as an ETL/Informatica developer
• ETL project Technical Design review, estimation, data mapping documents, development, unit testing, debugging & troubleshooting, and migration/CM.
• Experience in building a true BI team (Developers, Leads, Analysts, Architects, etc), Technical processes, templates, standards, etc.
• Transition to a true Data Warehouse using Oracle & Informatica from a traditional reporting team which utilized MS Access & Excel for data movement and reporting.
• Data Warehousing modeling knowledge (normalized modeling vs dimensional modeling)
• Knowledge of Dimension and Fact tables, Star Schema and Snow Flake Schema for dimensional modeling
• MS Access database design, normalization, development, and administration
• VBA Program development (utilizing Ms Access, Excel, and AutoCAD).
• Business process analysis and development
• Data Integration and Integrity Analysis utilizing moderately complex SQL code Troubleshooting and problem solving (deep dive analysis and root cause issues, not just symptoms)
• MS Office SQL Borland StarTeam TOAD Data Analyst ActiveBatch
• Informatica Power Center (v 9.1) including Informatica Developer, Mapping Designer, Workflow Manager, Repository Manager.

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

Informatica Developer

Responsibilities:

• Develop simple to moderately complex mappings, sessions, worklets, and workflows for multiple projects using Informatica 9.1
• Utilizing varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Sequencers, Command Tasks, Event Waits, Assignment Tasks, PRE/POST SQL, etc.
• Create Data mapping documents, Project estimates, Unit Test Documents, and Migration documents
• Research and analyze existing processes utilizing flat files (excel, csv, txt, asc, etc.) and develop ETL processes to replace old legacy processes.
• Provide Production Level support for multiple ETL projects.
• Navigate in UNIX environment using VI commands to research Session Logs, Workflow Logs, Bad files, and parameter files.
• Extensively used mapping parameters and variables in different mappings.
• Assisted in creating Global & Session parameter file system to be implemented as part of our overall ETL framework
• Created Target Load Order Plan when loading data into multiple targets based on requirements.
• Create Plans, Jobs, file triggers/handling/archiving, and schedules in ActiveBatch to execute Workflows and maintain source/target flat files

Confidential

Data Analyst

• Develop new or revised reports based on data & process research and analysis to maintain data integrity and increase productivity, efficiency, and accuracy.
• Research & Analyze Oracle database tables, views, mviews, relationships, and data & business process flow in order to maintain and/or develop new reports/processes
• Help build reporting team through screening, interviews, technical competency tests (SQL & Data Analysis)
• Create ad-hoc reports & data extracts using simple to moderately complex SQL code (including Oracle Analytical Functions)
• Meet with business users to better understand requirements, asks, and desired end results

Confidential, Fort Worth, TX

Contractor

• Analyzed, Debug, and Update/Develop MS Access programs & generated reports/extracts for multiple departments (Sales, Finance, Operations, I.T.)
• Analyzed data in existing Excel spreadsheets and in Oracle DB to determine and maintain Data Integrity
• Developed new MS Access programs to replace manual processes
• Generate on-going & Ad hoc reports using SQL, MS Access, and MS Excel
• Develop SOP documents for technical and business end users

Confidential, Dallas, TX

Contract for Railway

• Analyzed MS Access program for importing, manipulating, and transferring data from MS Excel spreadsheets.
• Analyzed data in existing Excel spreadsheets to assist with the developing a more efficient Access database.
• Developed a new MS Access program to more efficiently import, export, and process the data utilizing Excel spreadsheets.
• Created a user’s guide for the Access program.

Confidential,Haltom City, TX

Contract for Airlines

• Converted existing Excel spreadsheets into a normalized MS Access database for maintaining job order information and inventory.
• Analyzed existing Excel spreadsheets to assist in the development of the above Access database.
• Updated an AutoCAD 14 VBA program to work with AutoCAD 2008.
• Upgraded the AutoCAD VBA program to automate several manual operations.
• Converted AutoCAD VBA program to VB.NET.
• Created a text file manipulation VB.NET program.
• Created a user’s guide for the Access and AutoCAD VBA programs.