Resume

Sign in

Data Training

Location:
Tampa, Florida, United States
Salary:
120000
Posted:
November 08, 2018

Contact this candidate

Resume:

SUMMARY

• Ability in analysis and modeling of business processes, gathering requirements and converting them to technical specification.

• Expertise in mapping business requirements to technical specifications and test cases

• Proficient in all phases of the System Development Life Cycle (SDLC)

• Modeling UML and Data OLAP, OLTP and Big Data- Erwin, Enterprise Architect, PowerDesigner

• Extensive offshore experience

• Experienced as a Project Manager, Lean Six Sigma, Agile and Scrum (IT, Maritime Industry, R&D, and Consulting)

• Experienced in Requirements' Analysis for private and government enterprises

• Extensive knowledge of Data Architecture and Data modeling (Conceptual, Logical, and Physical), BPM and UML

• Knowledge of SQL (Stored Procedures, Triggers, etc Relational Database Systems, DW and NoSQL

• Proficient in using and integrating office and business applications (Excel, Access, Visio, MS Project, etc.)

• Experienced in Technical Support, Technical Presentations, and Prototyping

• Extensive knowledge of computer programming languages, software architecture, analysis and design techniques

• Business Intelligence Architect (Integration, Analyzing, Reporting, DQM, OLAP, DW, KPI, Cubes, ETL, ELT)

• Analytics, PowerBI, Qlick, Tableau, ML, Data Mining, Knowledge Discovering

• Experienced in developing and delivering training materials; University Professor

• Experience in working as Technical Team Leader, Interface Architect for EDS

• Project Management Naval Industry and IT

• Knowledgeable in managing multicultural teams

• IT Professor Database and Data Mining Technological University of America (Bachelor and Master Degree Level)

• Know-how of EDI, FTP, SFTP, VAN, and AS/2

• Knowledge of Big Data, NoSQL, Hadoop, Spark, Impala, HBase, Hortonworks, Cloudera, Mongo DB

• Specializing in Spark Databricks

• Cloud, Virtualization, Azure, and AWS

• Operating Systems: Windows, UNIX, and Linux

• Enterprise Architecture, Mobile and web platform

LANGUAGES: English, Spanish, Russian

WEBSITES: www.linkedin.com/in/FrankQuintanaDataArchitect, SKYPE frankqr1

EDUCATION

Postgraduate studies in Statistics, Operational Research and Experimental Design. University of Havana

St Petersburg Marine State University, Ph.D. Naval Architect- Ship building Engineering St Petersburg Russia

University of Toronto, Ph.D. in Hydromechanics, Toronto, Canada

Database Development and Administration, Herzing Institute with HONORS, Ottawa, Canada

USA Accreditation of Ph.D. in Naval Engineering JS&A, FL, USA August 2010 and April 2018

Microsoft Certified Database ID 10199570, FL, USA July 2013

PROFESSIONAL EXPERIENCE

Data Architecture/Business Intelligence - Independent Consultant 06/2004 – Present

A List of some of my: Helical, Vista Technologies, AutoNation, Citrix, Versailles Garden Property Management, RentFree, Ubuy, and MedLab among others

Big Data and Analytics

• Big Data and Big Data Architecture, Hadoop, MapReduce, Architecture, Hortonworks and Cloudera, Spark Databricks, HDInsight, Azure Data Factory, and MySQL,

• Analytics Machine Learning with Spark (Databricks), Splunk and PowerBI, Excel Qlik, Birst and Tableau.

• Data migration using CloverETL, Pentaho, ADF, Snowflake

• Big Data modeling using Aqua Studio

• DWH and multidimensional using Snowflake, AtScale and Cloudera

Project Management and Business System Analysis

• Planning, organization, and prioritization of workloads, as well as development and presentation of status reports and progress meetings Lean Six Sigma, agile and waterfall methodologies

• Development of best practices procedures. Project Management using MS Project

• Development and maintenance of project documentation, management of deadlines, ambiguity, and conflicts

• Planning, organizing and prioritizing workloads.

• Development and presentation of status reports and progress meetings

Business and Systems Analysis-

• Discovering Business Rules and Workflows,

• Requirements Gathering,

• Development of Functional and Technical Specifications.

• Used RequisitePro to design and manage business rules and requirements,

• UML diagrams (Use cases, activity and class diagrams)

Business Intelligence Architecture

• Database and report migration (Oracle, SQL Server, Sybase.)

• Installation and configuration of SQL Server 2005-2012 and the BI stack.

• SharePoint 2007 and 2010 integration with SSRS

• Dashboard Design

• Kimball Methodology (DWH and other 3rd party tools Toolkit)

• BI Requirement Analysis (SSRS, SSAS and SSIS)

• BI Design (SSRS, SSAS and SSIS)

• BI Technical Documentation (using Metadata and 3rd party tools such as BIDocumenter)

• BI Security

• BI Testing

• Data Mining models

Business Intelligence SSIS

• Design, development and maintenance of ETL Packages in BIDS for operational databases and Data Warehouse

• Extension of package functionality using event handlers, configuration, variables and logs

• Implementation of Package Security

• SSIS Administration

Business Intelligence SSAS

• Dimensions hierarchies and cubes development and maintenance

• Development of partitions and aggregations

• Development of MDX queries

• Cubes and dimensions tuning and troubleshooting

• Implementation of Cube, KPIs and Analysis of Security Cataloging Services

• Data Mining, Machine Learning, Data Science

Business, Data and Application Architecture

• Database Modeling Design and Implementation (Conceptual, Logical and Physical SQL DDL)

• Database and Application Modeling using ER Studio, ERwin and PowerDesigner.

• Data Migration from Oracle to SQL Server using SSIS (SQL Server 2005-2012)

• Enterprise Architecture (Enterprise Architect 9 Altova Tools and)

• UML Design and Code Generation. (C# and Java)

• Responsible Traceability Procedures and Traceability Implementation between different domains of the Enterprise Architecture (Business, Data and Application Architecture)

• Responsible for Technical Documentation

• Reverse Engineering (Roundtrip from Legacy code to UML and Back to code)

• Report writing using SQL Server 2005-2012 Reporting Service (SSRS).

• Creating a Dashboard using Dundas for data visualization.

• Querying multiple sources using MDX, CTS, and Link servers

• Responsible for BPM

• Discovering Business Rules and Workflows, Requirements Gathering and Analyzing, Context Diagrams, Use Cases and other RUP diagrams.

• Development of Functional and Designing Specifications used RequisitePro to design and manage business rules and requirements.

TECHNOLOGICAL UNIVERSITY OF AMERICA 03/2011-03/2013

IT Professor (Bachelor and Master Degree)- Prepared curricula, Syllabus, tests and on-line classes Lectures in Database Systems, Business Intelligence, Knowledge Discovery and Data Mining, Social Media and Global IT, at the bachelor and Master level

ANC-AUTONATION 02/2000-10/2003

Main Tools: Oracle, PowerBuilder, Visual Studio, Sybase, SQL Server, MS Project, UNIX

Project Management- Planning, organization and prioritization of workloads, as well as development and presentation of status reports and progress meetings (agile and waterfall methodologies)

Business and Systems Analysis-Discovering Business Rules and Workflows, Requirements Gathering, Development of Functional and Technical Specifications. Used RequisitePro to design and manage business rules and requirements, UML diagrams (Use cases, activity and class diagrams)

Development of Architecture Solutions Standards and Documentation- Developed and implemented the SDLC process (Development of UML diagrams, Guidelines for software development, User Request Forms, User Acceptance Forms, Unit Test Forms, GUI Standards, Development of Architectural Standards, etc.)

Quality Assurance- Developed guidelines and procedures in order to enforce and/or facilitate the QA at all stages of the SDLC. Developed test cases for the projects mentioned above and tracking of requirements versus other artifacts such as test cases)

Lead Developer ATS (Application Title System) - The application interface with the Mainframe using batch jobs running in a UNIX server

Technical Leader and Support of Warrant Application

Analysis and Design of Data Models (ER-WIN and PowerDesigner)

Lead Developer of Tune Up-Mitchell Interface

Technical Support

EDS Canada in the CSDN 10 /1997-11 / 1999

Software Architect (Consultant)

I worked on Client System Delivery Network Project (CSDN) and on the Benefit Redesign Project (BRP) for the Ministry of Veteran Affairs of Canada. These systems were created to manage healthcare and other benefits for Canadian veterans.

There I was doing the following:

Design and development of GUI usability analysis and RAD, prototypes on-line documentation (on-line Help, HTML, and Intranet/Internet Analysis), IT Standards and Test Cases for the GUI. Analysis of business process, and elaboration of UML diagrams.

Project management by using MS Project 1995 and 1998 and PRIMAVERA in order to develop Gantt and PERT Chart, establish constraints and dependencies. Developed and maintained project documentation. Planned, organized and prioritized workloads; developed and presented status reports and coordinated progress meetings. Prepared and updated schedules and resource allocations. Was leading a team of analysts, GUI designers and technical writers

EDS - Prince Edward Island and Ontario, Canada, 04/1997-10/1997

Technical Leader

Main Tools: PowerBuilder, Oracle, C++, Novell, SQL Platinum and UNIX

Design and development of system components as: Error Handling Service, Help Services- Responsible for PQMS (Program Quality Manager System), Open Code Tables, Open Tables of Rates, Reports on IT performance, Submit Batch Process and other similar modules of general use.

Coding and maintenance of Payment Client and Health Benefits modules and data structures.

Tools used: UML, PowerBuilder, Oracle, C++, Novell and UNIX. Design, development, testing and documenting the Unit Process using the DMR-P+ methodology Analysis and Design of Logical Data Models (Entity definition using previously defined requirements and business rules, Normalization, ERD, Context Diagrams) as well as Physical Data Models (Tables, Index, PK, FK, Triggers, Stored Procedures and other data structures)

TRAINING & CONFERENCES

Author Syllabus. Data Professional (Data Analyst, Data Science and Data Engineers) Curriculum Tampa 2018

Speaker “The Modern Data Architecture-Business Intelligence (BI) and Big Data Management Systems (BDMS) SQL Saturday. 755 Nova University, June 2018

Speaker “Data Science and the changing Role of Data Professionals” SQL Saturday 755, Nova University, June 2018

Training Outsystem Low code Hack Day training, Epic Hotel Miami. April 2018

Speaker “The Modern Data Architecture, Big Data And Data Science” SQL Saturday 699,Tampa SFU, 2018

Training One Day Training- Power BI Pre-conference Pragmatic Works Tampa, 2018

Speaker “OLTP, OLAP, Big Data and the Languages and Paradigms of MICROSOFT BI, South Florida Code Camp at Southeast Nova University 2018

Speaker “Big Data and Data Science”, Technova Bar Camp X Anniversary, Tampa 2017

Speaker “ A New Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”, SQL Saturday 371, University of South Florida, Tampa, FL 2015

Training Tampa Bay TUG and the Tableau 9.0 Virtual Roadshow, Tampa, 2015

Speaker “An introduction to Business Intelligence and Big Data”, SQL Saturday 326-BA, Microsoft HQ, Florida, Tampa, FL 2014

Speaker The DW and Big Data Architecture, Nova University, Davie, FL 2014

Training MongoDB Road Show, Marriot Waterside, Tampa, FL, 2014

Speaker “An introduction to Business Intelligence and Big Data”, SQL Saturday 273, University of South Florida, Tampa, FL 2014

Training QlikView To Discover event, Miami, FL, 2014

Training Splunk NoSQL, Conference Orlando, FL, 2014

Training Cloudera Big Data Eden Roc Miami, FL, 2013

Training Cassandra Training “Query Language for Big Data”, 2013

Speaker “BI and BIDS an introduction to Business Intelligence and Big Data”, IT Palooza, Nova University, Davie, FL 2013

Speaker Big Data and Data Science. Barcamp Tampa Bay 2017. 10th Anniversary Event

Speaker New Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS). SQL Saturday 371, Tampa, 2015

Speaker “OLTP, OLAP, BI and Big Data”. IT Pro Camp Keiser University, Fort Lauderdale

Speaker “Code Paradigms in BIDS” SQL Saturday 226, Nova University, Davie, FL 2013

Speaker .NET Code Camp 2013, Nova University, Davie, FL 2013

Speaker SQL Saturday 189, San Jose, Costa Rica 2013

Training TDWI Dashboard, Peak 10 Data Center Solutions, Ft. Lauderdale. FL 2012

Training Code Camp Tampa 2012, University of South Florida, Tampa, FL 2012

Training SSIS Master Pragmatic works Training, Microsoft Fort Lauderdale, FL, USA 2012

Training South Florida SQL Saturday #168 Tampa BI Edition, Tampa, FL Nov2012

Speaker 2012-IT Palooza, Nova University, Davie, FL 2012

Training IT Saturday Nova University, Davie, FL USA 2011,2012

Training SQL Saturday Nova University, Davie, FL USA 2011

Training SQL Server Denali, Microsoft Fort Lauderdale, FL, USA 2011

Training SSIS Pragmatic works Training, Microsoft Fort Lauderdale, FL, USA 2011

Training MS SQL Server 2008 Business Intelligence. uCertify, USA 2010

Training What's New in Microsoft SQL Server 2008 for the Enterprise Platform, Microsoft, 2010

Training Implementing and Maintaining Microsoft SQL Server 2005, PrepLogic, FL USA, 2009

Training Introduction to Business Architecture. SOA Institute, USA, 2008

Training “The Scrum Development Process”. Scrum Alliances. USA 2007

Training Agile Architectural Modeling IBM Agile Group USA 2007

Training Business Analysis, BPM and SOA. BPM Institute, USA, 2004

Training.NET Summit. Microsoft, Ft. Lauderdale, USA, 2003

Training Business Analyst. RequisitePro, Rational University, Fort Lauderdale USA, 2001

Training Object Oriented Design using Rational Rose- Rational University, Atlanta USA, 2001

Training Mastering Web Application Using Microsoft Visual InterDev 6 Productivity Point International, Ft. Lauderdale, USA, 2000

Training Writing Effective Stored Procedures, SYBASE, Ft - Lauderdale, USA, 2000-

Training Advanced Transact SQL, SYBASE, Ft- Lauderdale, 2000.



Contact this candidate