We provide IT Staff Augmentation Services!

Data Architecture/business Intelligence - Independent Consultant Resume

0/5 (Submit Your Rating)

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
  • Big Data, NoSQL, Hadoop, Spark, Impala, HBase, Hortonworks, Cloudera, Mongo DB
  • Cloud, Virtualization, Azure, and AWS

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, and Linux•Enterprise Architecture, Mobile and web platform

LANGUAGES: English, Spanish, Russian

PROFESSIONAL EXPERIENCE:

Data Architecture/Business Intelligence / Independent Consultant 

Responsibilities:

  • Big Data and Big Data Architecture, Hadoop, MapReduce, Architecture, Hortonwork and Cloudera, Cassandra, MongoDB, CosmoDB and MySQL Analytics Machine Learning with Spark (Databricks), Splunk and PowerBI, Excel Qlik, Birst and Tableau.
  • Data migration using CloverETL, Pentaho, ADF
  • Big Data modeling using Aqua Studio
  • DWH and multidimensional using AtScale and Cloudera

Project Management and Business System Analysis

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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

Responsibilities:

  • 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.

We'd love your feedback!