PROFESSIONAL SUMMARY:

• Enterprise Cloud Application/Data Architect with extensive experience in enterprise application architecture, solution architecture, data architecture, managed services, and application integration. Implementing data strategies, standards, quality, and managing master data for industries of Higher, Testing Lab, Investment Securities, Public Transportation (Fare Management), and Logistics & Transportation in AWS cloud/ on - premises environments.
• Architecting applications, enhancements, solution optimizations, business process workflows, delivering data management and integration solutions for enterprise BI projects; ensures implementation of ETL process and data architecture are properly functioning from sources.
• Managing and designing optimized solutions, process workflows, multiple projects design and development using Agile, Waterfall methodologies. Complete software development life cycle (SDLC) experience from solution requirements collection (SRS), design, development, implementation to UAT.
• Leading efforts to maximize the quality and increase the efficiency to deliver business-driven solutions. Identifying and guiding development activities in alignment with best practices, focusing on presentation, integration, data management, and service/application design.
• Creates, informs working designs based on existing, new architectures in coordination with EA; promotes pattern and service reuse to reduce maintenance cost. Collecting technical requirements for projects and assisting project teams in translating requirements, enterprise models into solutions that meet business value objectives and they are aligned with standard

TECHNICAL SKILLS:

EA and BPA: Adoption of TOGAF 9.1 Enterprise Architecture Framework, TOGAF's deliverables, ArchiMate 2.0 and BPMN 2.0 through and application in real world solutions, EDW and OLTP application architecture/modeling, AWS RDS, AWS Physical Design

Architecture Tools: VisualParadigm, Erwin, Visio, ArchiMate, TOAD Data Modeler, Eclipse

Frameworks Methodologies /System Deployment: Enterprise Architecture, TOGAF, MVC Cloud Application, RDBMS Oracle Application, Micro Services, and Decision Support System (DSS) Waterfall, Agile, Iteration Planning, Various MVC development, and Mix System Configuration, System Testing and Deployment

Management: JAD Session, Off-shore Management, In-house Management, Project Mini Charters, Issue Resolution, and Technical Requirements

Analysis/Design: Software Requirement Specifications (SRS), Data modeling, Process Workflows, State Diagrams, Use Cases, User Stories, Data Profiling, Data Mapping, Data Flow Diagrams, Prototyping, Sequence Diagrams

Languages and Schema Designs: Bash, Shell, DCL, PHP, Ruby, PL/SQL, Oracle SQL, MySQL, PostgreSQL, Rails, Groovy, Grails, Yii2, JavaScript, XML, WSDL, XSD, JSON

Databases (RDBMS): Oracle RDBMS 11g, MySQL, PostgreSQL, Mongo, IBM Informix

Software/BI Tools: Discoverer, NetBeans, nteliJ, PhpStorm, TOAD, SQL Developer, Argos ER, Crystal Reports, SequelPro, Cognos, Informatica, IEllucian s C-Tools.

Operating Systems/ Platforms: Linux, UNIX, VAX/OpenVMS, MS Windows, Mac OS, DEC Alpha, Luminis, PHP - NUKE, SOAP, OpenBSD, OpenSSH, CP/M, OS400

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

ERP Integration Architect -- Consultant

Responsibilities:

• Project involves evaluating gaps of BI layer analysis for migration from existing Ellucian ERP system's finance, Business Intelligence, Custom Reporting, and Human Resources module to Workday Human Capital Management ERP module.
• Evaluating Business, Data, Applications and Technology aspects along with contextual, conceptual and logical levels of detail in determining the gaps of IT assets and Workday HCM integration.
• Supporting application integration and directing development teams in where to find a certain functionality of code, as well as which components may communicate with Workday and how.
• Acting in a consulting capacity of integration for the reporting components at logical tier. Providing direction and reviews solutions with regards to dependencies, working with project teams to ensure consistency and coherence with the enterprise architecture.

Confidential - Chicago, IL

AWS Enterprise Cloud Application Architect Consultant

Responsibilities:

• Architecting enterprise database conceptual and logical models for product extension and ensuring project level data model alignment. Providing leadership and coaching to DW/BI team members for issues requiring methods, technical expertise or complex design/development knowledge.
• Responsible for creating the overall design standards for the cloud based solution for smart cities to support vendor management, ensure continuity of the physical design across the multiple vendors that may be involved in the build out of the Cloud Application.
• Translate AWS RDS strategy to execution via conceptual/solution architectures and governance, setting direction and architecture patterns for target state data designs.
• Acting in a consulting capacity in the implementation of the data management lifecycle components. Providing direction and reviews solutions with regards to data architecture, working with project teams to ensure consistency and coherence with the enterprise architecture.

Consultant - Chicago, IL

AWS Enterprise Cloud Architect

Responsibilities:

• Designing enterprise database conceptual and logical models and ensuring project level data model alignment. Providing leadership and coaching to DW/BI team members for issues requiring methods, technical expertise or complex design/development knowledge.::
• Responsible for system planning, design and implementation. Designing and deploying scale-able, highly available, and fault tolerant systems on Cloud utilizing MVC framework, MySQL, and PHP in development of proof of concept as demo for functional capabilities of the Application.
• Applying AWS RDS strategies on Data Tier of the environment. Actively lifting and shifting of existing on-premises application to Cloud. Establish & standardize cloud architecture and drive structure for use of the AWS Platform.
• Acting in an advisory capacity to the project; setting technology standards, security standards, and process to execution via conceptual/solution architectures and governance, setting direction and architecture patterns for target state data designs.

Confidential - Chicago, IL

ERP Application, Data Architect

Responsibilities:

• As a consultant on the project, responsible for implementation, integration, leading technical team of an ERP application, and architecting Canonical Data Model to facilitate integration with multiple applications to target ERP on Oracle and Java Platforms. Additionally, involved in defining, reinforcing industry standards in data quality, data integrity, documentation of business processes, technical and business rules.
• Successfully evaluating existing resources, meeting with business stakeholders to discover process needs, identifying implementation needs within business process.
• Determine integration points, Architectures ("As Is" & "To Be"), comprehending Business, Data, Applications, Technology aspects, contextual, conceptual and logical levels of detail.
• Proposed integration Hub consist of Canonical Integration Layer that includes data translation, rules engine, distribution/routing, composition, and Adapters. Architected adaptation layer which consist of data handling, interaction framework, low level API’s, protocol conversion, and data transport.
• Leading the technical teams, during the entire integration, development, and deployment processes of the designed architecture for the solution. Propose industry standards in conversion/integration of legacy data, introducing practices that will prevent data quality and data governance problems.
• Building Data elements inventory, facilitating integration and documenting requirements. Producing deliverables by putting together business data quality rules and technical data quality rules for the sources and target to in corporate in canonical data model.

Confidential - Chicago, IL

ERP Database Architect - Consultant

Responsibilities:

• Successfully evaluating current business workflows, existing resources, identifying gaps, placing industry standards and utilizing TOGAF standards in solution.
• Building IT elements inventory, documenting processes for the current state of the source code, determining complex workflows for the future state of the solution.
• Analyzing and building deliverables by putting together business rules and constraints for current processes, requests, request’s frequencies, and categorizing requests.
• Determine cost and time in maintaining sources, help higher management understanding IT Investments and return on the investment in the maintenance of current assets.
• Propose practices that will prevent data quality and data governance problems. Preparing formal reports and presentations of findings and recommendations.

Confidential - Chicago, IL

AWS RDS Cloud Architect

Responsibilities:

• Project involves building a cloud-based OLTP enterprise solution for group of clients. This solution leverages various application frameworks that focus on modernizing Cloud based Financial Custody System.
• Architecting physical model, RDBMS solution architecture of high-availability, establishing standards across modules; developing stored procedures and functions for the complex workflows of the solution.
• Analyzing the base architecture for Oracle/MySQL RDBMS, identifying, selecting, and utilizing core capabilities that will transform the new system to meet business needs. Designing data flows to support the development of the solution.
• Driving cross-functional execution of multiple programs, from concept to delivery. Leading teams responsible for delivering projects, oversee the definition, planning, monitoring, and other aspects.
• Managing all technical matters of the project; reviewing new/proposed designs, determining gaps, and coordinating the technical team for implementation.
• Successfully evaluating existing business architecture of OLTP systems, identifying gaps, designing logical, physical architecture for this cloud-based solution.
• Successfully analyzed applications, architecture of the Engineering Lab System, determined process flows, participated in preparing proposal of rules based subsystem for testing process of multiple products.
• Architected physical model for the proposed Engineering Assessment Platform (EAP) system integration. Participated in all the stages of designing high-availability Integration sub system and SDLC.
• Designed web service to support Enterprise Message based integrations; accomplish reduction in technical scope and therefore the elimination of the Oracle SOA Suite.
• Data Design for the Messaging, Managed Oracle/MySQL packages, stored procedures, functions, development, established standards across modules.
• Simplified the integration architecture that eliminate changes to support error handling. Successfully accomplished the task of sending Test Plan XML messages to LabWare, and displaying errors to the EAP-UI.

Confidential Northbrook, IL

Enterprise Data Architect, Technical Lead

Responsibilities:

• Provided services in creating Enterprise Architecture Knowledge Management Process and related deliverables; evaluating and selecting appropriate Enterprise Architecture Tool(s) to support the new process.
• Architected data model for common patterns, reporting mechanism for application exceptions, and exception management pattern that allow automated processes to react to and manage application exceptions.
• Provided a solution that allow users to interact with Ryder in the creation and management of a service related case; manage and automate the mapping of 3rd Party data and services to Ryder standards.
• Built physical model for code translation between application systems, designed and developed BizTalk components to support the architecture.
• Proposed a standardized approach for detecting and handling exceptions that occur in the BizTalk Server environment. Designed a group of SOA enabled business services that expose business processes via a standardized set of contracts.

Confidential - Chicago, IL

ERP Integration/Enterprise Application Architect

Responsibilities:

• Successfully evaluating existing business processes for proposed eCommerce solution, identifying gaps, architecting logical, physical architecture for (AWS) cloud-based system.
• Database modeling and RDBMS designing of high-availability Online Transaction Processing systems, establishing standards across modules; leading development of messaging queue solutions between multiple platforms.
• Maintaining technical, application, data, business process, and infrastructure views of the architecture. Developing a "big picture" vision of architecture strategy utilizing Visual Paradigm, ERWIN, Visual Studio, XMLspy, and eclipse as the canonical modeling tool.
• Managing all technical matters of the project including stakeholders buy-in for the solution, estimating timelines and costs for the Program Manager, and coordinating the technical team for go-live implementation.

Confidential - Fort Myers, FL

ERP Integration Lead

Consultant

Responsibilities:

• Successfully architected solution for transient student project; reviewed, analyzed specifications, determined gaps, provided optimum solution based on Confidential standards, implemented, and integrated these enhancements into ellucian™ Banner ERP suite.
• Conducting detailed analysis for existing business requirements of the project; proposing alternative solution, defining implementation/integration alternatives, and designing a highly configurable solution that met current and future business needs.
• Implementing unique approach in building SOA (XML) contracts of transient student request for Enrollment and Cost-of-Attendance Status in alignment with request.
• Defining the services for SOA components and developing the orchestrated solution that reduced 60% of the originally estimated development time. Providing alternative solution to a static approach reducing an estimated 80% in future code maintenance.
• Leading and developing the PL/SQL packages, functions, DDL scripts, deploying these scripts enhancing the ERP capabilities to respond to institution's requests and generating responses efficiently while complying with universal Confidential standards.

Confidential - Chicago, IL

ERP Data Warehouse Analyst - Consultant

Responsibilities:

• Completing the requirements, coordinating resources related to functions, processes, data management, and applications service. Designing architectural solutions, functional performance tuning, and project effort estimates.
• Conducting design discussions in a cross-functional environment, applying architectural/development standards, best practices, and building repositories.
• Analyzing existing UNIX CRON jobs for ETL processes, writing optimized CRON jobs and BASH scripts. Placing TOGAF 9.1 document standards, mapping business processes and data interactions for the migration project.

Confidential — Chicago, IL

ERP Integration, Implementation - Consultant

Responsibilities:

• Acting as the in-house SME of higher ERPs and working directly with project teams/business leads. Driving development and integration of new ERP database model to maximize flexibility while limiting the effects of changes in the source systems.
• Integrating business events publishing (BEP) via OracleStreams, propagating, populating queuing table, and formatting XML payload for SOA contracts to access.
• Developing and deploying complex PL/SQL packages, functions, procedures, table level compound triggers, and materialized views configuring integration Business Event Publishing dynamically.
• Interfacing between five applications through SOA platform with Banner® ERP suite, working with project teams, creating canonical data model components applying Confidential standards including component XML Schema Definition (XSD) and web services.
• Documenting the database requirements and performing database analysis for source/target systems data quality and architecting functional design and implementing technical database solutions.
• Solving critical business intelligence needs for Key Performance Indicator (KPI) reports to measure performance against goals by modeling components of the Data Warehouse environment for Integrated Data Repository (IDR) application needs.
• Directing IDR data development team to ensure consistency and integration with existing EDW structure, modules metrics, dependencies, and validation rules.
• Working with external vendors responsible for custom development of Student Information System, collaborate integration efforts, discuss gaps, create deployment schedule to ensure proper alignment of deployment with custom interfaces to avoid any conflicts or failures.

Confidential - Texas

ERP Data Analyst

Responsibilities:

• Defining requirements from functional specifications for Confidential Louisiana, developing ETL processes as it flows through the different systems, resolving data quality issues.
• Creating three tier ETL process which at self-service layer takes input, at application layer validate business process, eliminate errors by reporting various invalid data, and finally at database layer refining and uploading data to ERP modules from legacy DB.
• Developing SQL and PL/SQL scripts, packages, functions, and procedures for subject specific materialized views to support BI, institutional research, and other end-points.
• Converting solution/delivery requests into detailed work-plans and timelines that meet the needs of functional management and process owners.
• Performing migration utilizing C-Tools (SunGard data conversion tool), supporting deployment and enhancements of new releases to production.
• Building DB interfaces, writing technical specification for legacy institutional research interfacing, and crosswalk with the universities' legacy components.
• Participating in implementation/integration of Financial Module of Banner® ERP for a group of community colleges (LCTCS) and the third party vendor interface to assist in tracking transfers from other institutions.

Confidential - River Forest, IL

Lead ERP Solution Analyst and Sr. Oracle Developer BI

Responsibilities:

• Recognized for delivery of expert services for consortium of higher universities and associated organizations in architecting, analysis, designing, customizing, Component Based Development (CBD) for enhancements of ERP suit’s functionalities.
• Producing competitive edge solutions in database designs and development of PL/SQL packages, functions, procedures, and all kind of triggers for Oracle RDBMS.
• Serving as technical SME of multiple modules of ERP suite, introducing platform independency in development process of ERP’s component base development (CBD). team on new Groovy platform and anticipated change in development.
• Establishing Data Governance, Master Data Management standards, designing a multi-step ETL process for ad-hock Business Intelligence (BI) reporting, analytics data, handling dependencies, and enforcing business rules.
• Architecting enterprise database models ensuring they are viewed, interpreted, and used in a consistent and effective manner. Performing data architecture of conceptual, logical, physical (entity-relationship) database designs for high-availability solutions.
• Modeling of logical/physical source system for data warehouse, conducting facilitated sessions, and working with developers to create materialized views as necessary.
• Establishing standards across modules, data normalization, and de-normalization as well as dimensional modeling for operational data stores (ODS). Carrying out configuration decisions, determining impacts on project and integration approaches based on impacts.
• Managing large/complex OLAP systems, business processes, and inter-process communication. Updating data models including physical and logical models of the data warehouse, data mart(s), staging area, and source systems using BI tools.
• Directing new data development and ensuring consistency/integration with existing EDW structure. Maintaining data architecture, metadata, master data, data management standards, data dictionaries, and data element naming conventions.
• Extending the existing product functionality and introducing completely new custom modules that seamlessly integrate with the standard product and functionality.
• Performing SQL code reviews, offering performance related improvements to the team utilizing technical, business insight, existing, and emerging technologies. Evaluating technology solutions, capabilities, and alignment with business objectives.