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)
• Extensive offshore experience
• Experienced as a Project Manager, 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)
• Experienced in developing and delivering materials
• Knowledgeable in managing multicultural teams
• Know - how of EDI, FTP, SFTP, VAN and AS/2

TECHNICAL SKILLS:

Big Data, NoSQL, Hadoop, Spark, Impala, HBase, Hortonworks, Cloudera, Mongo DB, Casandra English, Spanish, Russian

PROFESSIONAL EXPERIENCE:

Data Architect/Business Intelligence - Independent Consultant

Confidential

Responsibilities:

• Database and report migration (Oracle, SQL Server, Sybase, Cognos, Crystal Reports, etc.)
• Installation and configuration of SQL Server R2 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
• 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
• Design, development, maintenance and upgrade of operational and analytical reports.
• Design and development of BI architecture and components for all BI, reporting and dashboard technologies
• Preparation and maintenance of a written technical documentation detailing the contents and operation of each report.
• Development of stored Procedures and parameterized Reports
• Report Manager Administration
• Report Tuning and Troubleshooting
• Usage of Power Pivot, Excel Services, PerformancePoint, PowerView, QlikView and Tableau
• 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
• 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 )
• 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 Reporting Service (SSRS).
• Creating a Dashboard using Dundas for data visualization.
• Querying multiple sources using MDX, CTS, and Link servers
• Responsible for BPM
• 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.
• 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.
• Planning, organization and prioritization of workloads, as well as development and presentation of status reports and progress meetings agile and waterfall methodologies
• 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)

Confidential

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

Responsibilities:

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

Confidential

Software Architect (Consultant)

Responsibilities:

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

Confidential

Technical Leader

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

Responsibilities:

• Design and development of system components
• 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)