| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate RESUME OF Candidate's Name
Career Summary:Looking for a BSA, Team Lead or Data Analyst contract position due to my strong background in business analysis, database administration, data analysis, data modeling and team/project management. My capabilities for merging business needs with technical solutions via a positive, team-oriented approach have resulted in applications that are designed to enable future growth and support reporting and analysis needs. I have successfully led teams in data warehousing and OLTP application development projects.Specific expertise in: Requirements gathering, creation of scope, process and data models, MDM, rules and use cases Database administration and/or reporting per queries on Teradata, Oracle, Netezza, DB2 and SQL Server Design of software applications and of data warehouses for decision support and performance optimization Development of Project Plans, Process Flows, Source to Target Mappings, Standards / Procedures, Entity Relationship Diagrams, Data Dictionary and Metadata; Conceptual, Logical and Physical Models Presentations using Excel with charts and pivot tables, PowerPoint and other methods Personnel supervision and project team lead Ability to bridge the business and IT realms via excellent verbal and written communication Information Systems Plan (ISP) development; project plans and time/$ estimates of work Enterprise data architecture, to include globalization and integration of diverse data sources Strong SQL, most recently on Teradata, Oracle, Netezza, and SQL Server databases Data conversion specifications and implementation; data cleansing and integrity Conceptual, logical and physical data design, 3NF or Dimensional, ErWin, ERStudio and Power Designer
Selection of database vendors; ETL (extract/transform/load), reporting, and data design tools Exposure to Informatica, Business Objects, Tableau, MongoDB, Hadoop, AGILE, and ArcGIS Excellent analytical and problem solving skills, working independently or on teams Experience in financial brokerage, payments, marketing, petroleum management, airline applications, aviation, utilities, telecom, insurance, cable-internet-phone, satellite TV, government land management, and conferencing solutionsProfessional Experience:NV5 buys Quantum Spacial / BLM Sept, 2021 - June, 2023Business and Data Analyst work within the Data Resource Team at the BLM Data design and governance with GIS datasets on the Grazing and Energy Project. This includes: - Potential Fossil Yield Classification - analysis to load hundreds of geologic maps for 8 states - Water Wells - analysis to document a Geocortex application for possible future rewrite Data and domain design for feature classes to keep inventory on Shooting Ranges Data design using ER Studio for the National Scenic and Historic Trails and for RECS 2.0
Sanborn Map Company / BLM Nov, 2020 - Sept, 2021Business and Data Analyst work within the Data Resource Team at the BLM Data design and governance with GIS datasets on the Grazing and Energy Project. This includes: - Application for Permit to Drill - guiding the GIS merge of national, state office and field office data - Potential Fossil Yield Classification - doing the schema and specification to load geologic maps for Florida - Oil and Gas Wells - leading schema development for 5 feature classes and tracking load issues to be fixedBoeing / Jeppesen Feb, 2019 - Apr, 2020Systems and Data Analyst work within the Data Architecture group
Did requirements gathering/documentation and collection of metadata on hundreds of applications These are the projects that were involved:
Cloud Data Hub - gathered requirements for putting data from AHM (Airplane Health Management), ADW (Analytics Data Warehouse), and ARMS (Aircraft Reliability and Maintainability System) into the Azure Cloud for use by SSA (Self Service Analytics). Portfolio Data Map - identified Subject Matter Experts and set up meetings to obtain aviation metadata information on over 270 Applications within 9 Portfolios. Provided recommendations to the Analytics and the Integration Work Groups.WOW! (Wide Open West) Feb, 2018 - Jan, 2019
Business and Data Analyst work within the Data Warehousing group (BIANQA) Handled business and data analysis, dashboard design, requirements and mapping documentation, and led various people through design, development, QA and moves to Production within an Agile environment These are the projects that were involved:
Sales Flash Dashboard (Tableau) - displayed numerous metrics involving New Connects, Call Center, Door-to-Door, and Headcount and Productivity Worker data cleanup to improve information on Employees and Contractors Call Center Sales Dashboard (Tableau) - coordinated the design and display of numerous metrics on 3 tabs, from Calls Handled and Sales to Connects and Products; numerous filters and a strong hierarchy with Locations, 2 levels of Managers, and Sales Reps; data from 2 billing systems and several employee sources and IVR Budget and Forecasting data capture for tracking against Sales Flash dataCharles Schwab Dec, 2015 - May, 2017
Business Systems Analyst work within the Data Warehousing group (GDT) Handled business and data analysis, logical modeling on ErWin, occasional project management and cost estimation, and led various people through design, development, User Acceptance Testing and moves to Production within an Agile environment with documentation and tracking in JIRA. These are the source systems that were involved:
American Express Credit Card - application and status tracking Lynx replacement with Salesforce dot com (SFDC) primary and foreign key modifications, source file changes, and major testing Schwab Intelligent Advisory (SIA) in-house Financial Planning data, TimeTrade Appointment (third party vendor) data, and over 20 tables in a Money Guide Pro set of vendor software information collected from individual investors and advisors. Yodlee Held-Away Account and Position information along with aggregation of that data
Dish Network May, 2010 - Nov, 2015Staff Data Analyst
Handled data analysis, architecture and design, DFD s and STM s for a Receiver Connectivity data mart which supports numerous reports and commission payments Numerous data analysis activities for the Enterprise Data Warehouse conversion on a CSG Billing Transformation project, including a very involved Deployment Plan for Teradata and Netezza; led 7 system tests to insure a good Go Live Implemented a 3rd Party Vendor s software involving a data migration and 4 encrypted daily files to support activities at 8 collections agencies; this increased Dish revenue by $2.7 million per month and decreased legal issues by 70% Managed the project intake/initiation for the Data Warehouse with gathering of LOE s from 5 groups Guided defect tracking and resolution on the Customer 360 initiative Handled the addition of census and programming usage data in Teradata for Aprimo and the Marketing teams.CONNECT The Knowledge Network Dec,2009-Mar,2010
Sr. Consultant
Business and data analysis related to multiple OBIEE projects ErWin was used to reverse engineer production and development environments, including numerous Subject Areas and a Business Dimensional ModelWestern Union / First Data Corporation 1997-2008Business Analyst for Consumer Modeling and Analytics Nov, 2004 - Nov, 2008 Advised several marketing teams via reports using Customer Relationship Management (CRM) data Handled the statistical analysis of customer, loyalty card and transaction information to measure trends and effectiveness of marketing campaigns and new product introduction Specific projects included: Analysis of migration patterns of Brazilians and Central Americans to New Orleans after Hurricane Katrina to better understand the movement of customers A compilation of more than 30 Direct Marketing Campaign ROI reports to measure incremental lift; development of visual charts to compare larger initiatives to similar control groups Demographic analysis of ethnic groups, including US senders to various countries to better target marketing campaigns and understand the profitability of those corridors Inputs for data cleansing and aggregate tables to speed the data access and accuracy
A comparison of the Western Union, Orlandi Valuta and Vigo brands in the money transfers from the US to Mexico including detailed geographical and agent segmentation Coached an offshore resource in India to successfully complete 8 projects in less than 2 months for 3 Marketing groups.Western Union / First Data Corporation Aug, 2000 Nov, 2004
Senior Data Analyst
Handled the data design and administration involving coordination between Project Managers, Programmers, Database Administrators and Clients Application data design for the Inventory Create and Update System, Payment Services Information System, Cashtax Enrollment, Dashboard and others Used Dimensional Modeling for Data Warehouses and 3rd Normal Form on OLTP systems
Requirements definition and third party software analysis for the Merger Integration department
Led a team of DBAs on the Dashboard data warehouse project in data design, tool selection - Informatica and Business Objects - and ETL strategy and development; used the Kimball Lifecycle methodology for data marts with fact, dimension, and aggregate tables
Vendor selection for the Western Union Customer Database
Organization of a four day seminar on enterprise data topics for 70 FDC employees from five locations Received a First Data Collaboration award in 2003 for managing this successful eventWestern Union / First Data Corporation Apr, 1997 Jul, 2000Senior Database Administrator
Database design and implementation for the Electronic Federal Tax Payments System, an application that moves more than $4 trillion annually to the IRS, has over 200 large tables and data replicated across 3 IBM mainframes Experience supporting over 100 developers on this large project Selection of the Power Designer data modeling tool to capture logical and physical metadataCap Gemini America Aug, 1993 - Apr, 1997
Senior Consultant
Provided database design and administration support and consultation to a variety of clients Created an Information Systems Plan at Total Petroleum
Administered DB2 databases at Public Service Company (now Xcel Energy)
Provided analysis and data design at Lee Company in Kansas City
DB2 database administration at First Data CorporationTotal Petroleum Jul, 1988 - Jul, 1993Database Administrator Production database design and administration to support the acquisition and movement of petroleum products from their source through their eventual sale at retail outlets On call support and release upgrades for 3 DBMSs, query tool administration, disaster recovery testing, and performance tuning Led data design and conversion specifications for 2 data marts to help business users optimize the trucking and pipeline movement of petroleum among wells, refineries and storage facilitiesCap Gemini America Mar, 1987 - Jul, 1988Senior Consultant and Technical Services Manager Provided senior level support on IT projects for several clients, and served as an internal administrator for other consultants at Cap Gemini At Mountain Bell (became Qwest and now Century Link), did data administration, designed DB2 tables and handled conversion responsibilities on a Carrier Subscription System development project Led 4 programmers on the NPA Split project, which renumbered some of the 303 area code's territory to have 719 numbers Administrative management of 10 consultants
Education & Training:Bachelor of Science in Mathematics, Minor in Computer Science At Texas Tech University in Lubbock, Texas
2 classes in 2008 at University of Colorado at Denver in the Masters of Engineering, GIS ProgramThe Data Warehousing Institute (TDWI)Technical and Business Methodology Classes & SeminarsJoint Application Design (JAD) Facilitator SkillsBusiness Process Reengineering (BPR)Database Administration and DesignProject Management SkillsContact At: PHONE NUMBER AVAILABLE or EMAIL AVAILABLE |
