SUMMARY:

Connector of people, data and technology—a strategic thought leader, with a demonstrated ability to deconstruct business problems, then frame and describe sustainable solutions in complex environments. A problem - solving technologist responsible for the design, implementation and integration of enterprise analytics and visualization solutions, complex OLTP data architecture, and cross-functional data delivery projects, using Agile methodologies coupled with data management best practices.

TECHNICAL SKILLS:

Databases:: Azure SQL, Oracle, SQL Server, Teradata, MySQL, Amazon RDS

BI Tools: Microsoft PowerBI, Cognos, MicroStrategy, Business Objects, SSAS, Tableau

Languages: PL/SQL, Confidential -SQL, R Scripting

Methodologies: Agile Proficiency (SAFe, Scrum, Kanban); Cloud and Terrestrial Data Architecture; Off-Shore Development Management; Machine Learning Confidential -scale

Project Management Tools: Microsoft Project, Team Foundation Server, Rally, Jira

PROFESSIONAL EXPERIENCE:

Confidential

Lead Consultant

Responsibilities:

• While maintaining a 98% utilization rate, leads projects as a data architect and lead consultant to deliver OLTP structures, data analysis, and on-premise-to-cloud migrations in Azure and AWS
• Provides technical thought leadership in the areas of data architecture, modeling, naming, governance and engineering across a diverse problem space in multiple industries
• Leads the delivery of adaptable, scalable data models in a fast-paced environment while balancing cost, efficiency, and speed-to-market for large financial and professional services clients
• Designs enterprise-scale data flows for ingestion, storage, and processing that maximize reusability and throughput with targets in Amazon RDS (Oracle) and Azure SQL
• Constructs visualizations in Power BI against dimension models and SASS sources

Confidential

Senior Manager

Responsibilities:

• Designed cloud-aware, scalable OLTP and reporting data models for use in six global data centers to support the Enterprise Assurance practice in SQL Server 2012 and Azure SQL
• Directly managed and coached six, multi-discipline agile teams and two scrum masters with overall responsibility for delivery, risk mitigation, timelines, budget, prioritization, and status reporting to client and internal leadership
• Ensured compliance with and promoted the adherence to data governance standards within the team
• Interviewing, hiring, and on-boarding technical (J2EE, Java-Script, Informatica PIM, AWS) resources based on customer project requests for “agile pods” and staff augmentation projects
• Prepared project roadmap, scope definition, project schedule, RFP responses, contract SOW, WBS, and RAID log for the data warehouse program
• Oversaw the creation and distribution of information resources through the creation of reports and dashboards that outlined the progress of program
• Managed on-site and offshore developers, coordinating daily hand-offs to ensure development and production support coverage for new development objects and the resolution of observations/defects
• Served as a Business Intelligence Subject Matter Expert (SME) for methodology, approach, and best practices definition and implementation
• As a senior member of $100M project, performed end-of-iteration presentations that outlined the work of the team while communicating a compelling view of the team’s purpose and values in a way that helps others understand the importance and impact of their contribution

Confidential, Atlanta, GA

Senior BI Architect

Responsibilities:

• In the second largest data warehouse in the country, served as a Teradata Data Architect. Primarily responsible for adding data structures to the Marketing Data Mart in a highly structured environment serving 50k users.
• Designed ETL flows, source-to-target maps, transformation rules, and reports, both SQL and look-and-feel, to support out-sourced and near-sourced development
• Using Erwin, designed fact and dimension table additions to existing 3500+ node data warehouse employing Kimball data warehouse modeling techniques
• Employed source system data profiling techniques to inform design of data structures
• Conducted review of SQL, Informatica mappings, and UNIX scripting for adherence to application design specifications and ensured traceability to business requirements
• Fostered an environment for shared responsibility, customer focus, and sound coding practices
• AGCO, Atlanta, GA, Senior Business Intelligence Consultant
• Served as the principal consultant delivering an HR data warehouse. The project was delivered from requirements gathering to delivery using Cognos’ BI Tools and Oracle 11.
• Led the effort to meet business owners to determine, document, and deliver solutions to meet their reporting and analytics needs
• Owned all aspects of delivering analytics solutions for the business, including predictive/prescriptive reports for the Human Resources VP
• Conducted full assessment gap analysis, hardware/software review, organizational capability, and project proposal of Human Resources data warehouse
• Designed, developed, and implemented HR data mart for Senior Vice Presidents using SAP as a data source and Cognos Web Tools for dashboards and reporting

Confidential, Atlanta, GA

Principal BI Consultant

Responsibilities:

• As the lead consultant and architect, created Retail Point-of-Service and Market Basket Analysis data marts using Cognos' DecisionStream for ETL and CA's ERwin for Logical and Physical Modeling in SQL Server 2008.
• Led construction and design of two full life-cycle data marts, 11 Impromptu reports, and four PowerPlay cubes using IWR and Enterprise Server for deployment to user community
• Trained business users and technical staff in basic statistical review for Market Basket Analysis, overview of BI infrastructure, and design methodology
• Responsible for the quality of data, reports, analytics and dashboards

Confidential, Atlanta, GA,

Business Intelligence Development Lead

Responsibilities:

• Supervised a five-person development team in estimation, planning activities and consensus negotiation among individual team members on various appointed tasks
• Designed, maintained, and updated Teradata data mart project using Informatica for ETL, Business Objects XI for reporting, and an Oracle 10i staging environment
• Coordinated BI data structure and data mart design, both logical and physical - methodology, and implementation, including three full life-cycle data mart projects and 15 minor release cycles