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 training materials
• Experience in working as Technical Team Leader, Interface Architect for Confidential
• Knowledgeable in managing multicultural teams
• Exposure to NoSQL and BigData concepts
• IT Professor Database and Data Mining Confidential (Bachelor and Master Degree Level)
• Know - how of EDI, FTP, SFTP, VAN and AS/2

PROFESSIONAL EXPERIENCE:

Data Architecture/Business Intelligence

Confidential

Responsibilities:

• Database and report migration (Oracle, SQL Server, Sybase, Cognos, Crystal Reports, etc.)
• Installation and configuration of SQL Server 2005-2008 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 and SSIS)
• BI Design (SSRS, Confidential and SSIS)
• BI Technical Documentation (using Metadata and 3rd party tools such as BIDocumenter)
• BI Security
• BI Testing

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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 and Tableau

Confidential

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

Confidential

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

Confidential

Responsibilities:

• 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

IT Professor

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

Confidential

Technical Leader

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

Responsibilities:

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