Lead Analyst Resume
Atlanta, GA
SUMMARY:
- Currently an analyst and data modeler for a Teradata warehouse
- Teradata Consultant
- Personally developed REDataCenter.com: a data warehouse and BI solution for real estate brokerages
- Led 3 successful data warehouse teams
- Extensive design and programming experience: assembler drivers to drag - and-drop UI creation.
- Management including Director of a 140+ person team
TECHNICAL SKILLS:
Skills: Logical and physical modeling (Erwin & Toad); Teradata (certified in 1996): database, SQL, tools and utilities; SQL Server; Visual Studio/SSIS; Oracle SQL; PHP; HTML/CSS; VBScript; Excel/VBA Script
Expertise: Finance and Accounting; Non-profit operations; Project Management, Real Estate; Logistics: Order Fulfillment, Warehouse Operations, Delivery; Process Management (including Six Sigma); Personnel Management
PROFESSIONAL EXPERIENCE:
Lead Analyst
Confidential, Atlanta, GA
Responsibilities:
- Designed and implemented a data quality management sub-system using BTEQ, stored procedures, views, FastLoad and VB Script. It generates an automatic email with HTML results. It includes self-verification.
- Responsible for requirements, business rule validation, data analysis and data validation for all releases. This includes generating the views used by the BI team.
- Created REDataCenter.com, a software as service offering which uses SQL Server 2008, SSIS and PHP
Director
Confidential, Duluth, GA
Responsibilities:
- Led team which created a data warehouse and data marts for Federated Logistics’ research, reporting and analysis; dashboard metrics and reports supported achieving and maintaining $150 Million per year savings
Confidential
Responsibilities:
- Led development of a web-enabled reporting system using Crystal Info Server and Oracle.
Vice President
Confidential, Charlotte, NC
Responsibilities:
- Responsible for data sourcing projects and production information delivery
- Caused change in policies and strategic direction regarding use of the corporate data warehouse thereby increasing programmer efficiency
- Managed pilot team of developers on SP2/DB2PE
- Defined metadata requirements for corporate organizations
- Designed and implemented change control process and tool for Unix/Oracle data mart development
Account Consultant
Confidential, Richmond, VA and Charlotte, NC
Responsibilities:
- Migrated Oracle solution to Teradata
- Project manager and developer on Teradata benchmarks; used DDL, SQL, Unix, MicroStrategy
- Delivered presentations and consultation to multiple Fortune 100 companies covering: business aspects of data warehousing data warehouse architectures hardware technologies differences between various databases (Oracle, Teradata, DB2/PE), physical database design
Re-engineering Consultant & Database Project Manager
Confidential, Dayton, OH
Responsibilities:
- Managed team establishing the common world-wide data warehouse for all Confidential &T GIS product information
Consulting Analyst & Manager
Confidential, Atlanta GA
Responsibilities:
- Played a major role in defining the strategic direction for open systems selling, implementation and support
System Integration/Project Planning Coordinator
Confidential, Atlanta, GA
Responsibilities:A
- Developed project schedules and resource plans for board level review during Confidential &T acquisition
Team Leader
Confidential, Atlanta, GA
Responsibilities:
- Implemented QFD/House of Quality for definition of new product
Manager
Confidential, Atlanta, GA
Responsibilities:
- Established and managed process for project prioritization, budgeting and scheduling for organization
- Implemented a plant wide leadership and project management program
- Received the highest rating possible for coaching and developing associates
Project Planning Consultant
Confidential, Dayton, Ohio
Responsibilities:
- Audited a major Confidential program
- Established development quality metrics and project schedule tracking mechanisms.
Manager
Confidential, Cambridge, OH
Responsibilities:
- Responsible for dramatic improvement in the software/systems development and quality management processes.
Lead Analyst
Confidential, Cambridge, OH
Responsibilities:
- Provided technical support to customers and systems integration groups.
- Developed several operating system modules and drivers in assembler.