SUMMARY OF QUALIFICATIONS

• Ambitious results-oriented Data analyst with over 12 years of experience in Data Analysis applied across a broad range of commercial and military environments. Possess over 7 years of Business Intelligence experience in the development of research protocols, managing databases, compiling data, analyzing data and presenting research results in a variety of formats. Also, brings over 5 years of Management and Technology Consulting experience with the ability to articulate answers and recommendations to the target audience.
• Expert in a variety of Technologies i.e. - Business Intelligence Tools, Spreadsheet, Presentation, Operating Systems, etc.
• Advanced knowledge in a broad range of technologies i.e. - Querying Languages, Databases, etc.
• Proficient in an assortment of technologies i.e. - Extract Transform Loading ETL , Scripting Languages, Customer Relationship Management CRM

TECHNOLOGIES

PROFESSIONAL EXPERIENCE

Confidential

Data Systems Engineer

• Design, develop, and maintain data that feeds the software applications that drive the company's applications which aggregates and visualizes energy data using an array of software i.e. - Pentaho, MySQL, Perl, etc
• Optimize the company's database schemas, writing stored procedures and direct manipulation of the database to facilitate these functions Create and modify unit tests for the software applications that drive the company's applications
• Designing database schemas that perform well in complex web-based user interfaces manipulating database contents from Perl and Java code, including streaming of data into the database and extracting for use in reporting user interfaces

Confidential

Business Intelligence Developer

• Works within a SCRUM Team to create relevant reports and metrics to help users understand the impact the mobile application has on their business primarily using Pentaho PostgreSQL and PL/SQL
• Develops data warehousing and data mart components including ETL, XML, Meta Data, Facts and Dimensions employing Star and Snowflake Schemata as well as Logical Data Model, Product Data Management, Entity Relationship Model, etc
• Creates relevant design documents to support the clients understanding of the reports and metrics uses soft skills to influence and recommend how the relevant documents should be interpreted i.e. Data dictionaries, mappings, etc.

Confidential

Senior Consultant

• Leading and developing data warehouse and business intelligence solutions utilizing the Microsoft BI platform and product stack i.e. - SQL Server Analysis Services SSAS , SQL Server Reporting Services SSRS , PowerPivot, Power view, etc.
• Data mart/warehouse modeling based on business requirements and optimization of data models for business intelligence implementations maintaining existing data warehouse and business intelligence implementations
• Leading meetings in preparation of project planning directly with clients, business users and sponsors including requirements, architecture review and project milestone sessions

Confidential

Data Management and Integrations Consultant

• Developed reporting processes via a simplistic database MS Access interface that allows for ease of production and real-time assessment of information subsets extracted from SalesForce.com and FinancialForce
• Work with Subject Matter Experts to design, develop, test and deploy database s , extrapolating information from SalesForce.com and FinancialForce.com
• Created data flow for project whereby information is: extracted from SalesForce.com transferred into Informatica, translated from Informatica into MS SQL Server and finally processed by MS SQL Server then imported by MS Access

Confidential

Supply Chain Business Intelligence Analyst

• Employed dynamic hypothesizes and sound analytical methodologies to evaluate supply chain opportunities in terms of cost, lead-time and quality tradeoffs resulting in recommendations to senior leadership
• Worked closely with Logistics, Finance and Process teams to identify supply chain cost challenges and opportunities by product, by route to market and distributor driving actions to realize Return on Investment ROI opportunities
• Employed a broad range of software and business applications in order to gather, evaluate and present findings plus recommendations to executive decision makers i.e. - Business Objects, MySQL, SQuirrel SQL, Excel for Mac, Keynote, etc

Confidential

Business Intelligence Advisor/Data Modeling Analyst

• Worked with Business, IT and cross-functional project teams to drive technical and functional designs for BI solutions derived/defined business requirements, developed data modeling concepts, and setup data architectures enterprise wide
• Leveraged an understanding of multiple data structures and sources within USAA data architecture ie. SAS Server, SAP, etc. to perform complex data manipulation employing data mining, analytical tools and mathematical techniques
• Used SAS Enterprise Guide and related statistical tools i.e. SPSS, R,TOAD and other SQL software to mine, analyze and model data then deciphered and articulated the message in the complex data sets to USAA stakeholders

Confidential

Lead Operations Research Analyst

• Team lead for Air Force Intelligence and Cyber market responsible for growing existing work, developing new clients, implementing tools to aid in decision analysis whose output can easily be captured and reported i.e. Dashboards, etc.
• Lead for Business Intelligence, responsible for implementation of the Cross Industry Standard Process for Data Mining Methodology CRISP-DM upon existing processes to identify deficiencies and develop methods to improve productivity
• Assisted clients by ensuring that the decisions are quantitatively and qualitatively supported by rigorous statistical methods presenting refined results from statistical software SAS, SPSS, etc. and streamlining business decisions

Confidential

Operations Research Analyst / Systems Engineer

• Provided Systems Engineering insight and expertise to support the refinement of current and established engineering policies and procedure within NAVAIR exploiting statistical software such as MS Excel, Minitab, SPSS and SAS
• Led four person team providing analysis support for the Portfolio Management Decision Support System PMDSS delivered to Office of Chief Naval Operations Warfare Integration OPNAV N8F to aid in vital budget decisions
• Researched, Derived, Analyzed factors and influences to Total Ownership Costs within Naval Aviation Enterprise NAE acquisition programs lowering acquisition costs utilizing statistical software and math methodologies to aid in analysis

Confidential

Lead Operational Test Analyst

• Planned and executed operational tests using Design of Experiments DOE methodologies to characterize aircraft combat capabilities, identified deficiencies, and recommended corrective actions reported results using MS PowerPoint
• Executed test programs with a budget in excess of 10.3M led a four person team providing operational testing analysis for Cargo, Tanker, Utility and Special Operations Aircraft avionics and munitions
• Presented funding recommendations via MS PowerPoint to Office of Secretary of Defense and top Air Force officials, in support of major acquisitions, production and fielding decisions throughout the Air Force

Confidential

Operations Research Analyst

• Developed a web-based application, using HTML XML, to modernize manual systems and processes giving them Internet-based functionality, which increased access and security of the data for senior leaders throughout the command
• Created a tracking matrix in MS Excel to organize, analyze, and prioritize allocations of surveyed assets across the Iraqi Theater MS PowerPoint provided visual representation which improved decision making by leadership in theater
• Significantly contributed to mission success by dedicated analytical support to Commanders Evaluation Board assessed business problems, asked key questions and gave data-driven recommendations to board members

Confidential

Production Analyst

• Developed and implemented demographic analysis tools using MS Excel, MS Access Base SAS that monitored, evaluated and proved feedback of production data for enlisted and officer personnel requirements Air Force wide
• Extracted, Transformed and Loaded ETL data used to perform market share analysis, ad hoc queries, and forecasted effects of end strength results in Base SAS, to support Air Force Recruiting Services' mission decisions
• Verified and validated accuracy of multiple database systems i.e. MS Access, Oracle etc. to assist in updates of theses systems detected problems and potential inefficiencies then implemented processes to streamline data efforts