SUMMARY:

• Enterprise Application/Data Architect with extensive experience in enterprise application, data architecture, managed services, and ERP applications. Expertise in designing, implementing, integrating, and migrating applications for industries in the field of Higher Education, Testing Lab, Investment Securities, Fleet Management, and Cloud based technologies (AWS).
• Architecting applications, enhancements, solution optimizations, business process workflows, delivering data management and integration solutions for enterprise BI projects and ensure implementation of ETL process and data architecture are properly functioning from sources.
• Managing application integration within ERP suite and cloud applications; utilizing Business Event Publishing, Business Event Integration Services on a Service Oriented Architecture (SOA) platform and publishing events including AWS and other cloud technologies.
• Specialization in business process improvement, business process re - engineering; Micro Services Architecture, EDW Architecture, Integration/ETL Architecture, Data Profiling/Analysis, leading development, implementation, and legacy applications migration.
• Complete software development life cycle (SDLC) experience, collecting software requirements specifications (SRS), ETL design, development, implementation, complex integration on disparate technological platforms/data sources.

TECHNICAL SKILLS:

Analysis/Design: Data modeling, ETL Data Mapping, Data Flows, Data Profiling, Business Process Diagram, Process Map, Software Requirement Specifications (SRS), and Use Cases

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

Management: JAD Session, Off-shore Management, In-house Management, Issue Resolution, and Presenting solutions to key stakeholders

Architecture Tools: VisualParadigm, Erwin, Visio, Archimate, TOAD Data Modeler, XMLSpy, Eclipse

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

Software/BI Tools: TOAD, SQL Developer, SequelPro, Argos ER, Discoverer, Crystal Reports, Cognos, Informatica, Ellucian's C-Tools etc.

Languages and Schema Designs: PL/SQL, Oracle SQL, MySQL, Bash, Shell, DCL, Perl, Java, Ruby, Groovy, Yii2, JavaScript, XML, WSDL, XSD, JSON

Frameworks: Methodologies

System Deployment: Enterprise Architecture, TOGAF, Web Application, Oracle Application Development, and Decision Support System (DSS),Waterfall, Agile, Iteration Planning, Various MVC development, and Mix System Configuration, System Testing

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

PROFESSIONAL EXPERIENCE:

Enterprise Cloud Architect (AWS RDS) - Consultant

Confidential,Chicago, IL

• Current project involves development/maintenance of cloud based AWS RDS Solution's reference architectures (Current State & Future State), comprehending Business, Data, Applications & Technology aspects of the system along with contextual, conceptual and logical levels of details. Setting directions for extended data model to facilitate integration with multiple applications to target cloud application on MySQL and Java Platforms.
• 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.

ERP Application, Data Architect, Technical Consultant

Confidential

• As a lead, 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 (Banner 8.x, XE) 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, Reference 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.

ERP Application/Data Architect - Consultant

Confidential,Chicago, IL

• Current project involves evaluating IT assets for an ERP in Advancement division. Facilitating and documenting requirements meetings with stewards, stakeholders, development teams. Placing industry standards in documenting workflows, business rules, processes and rules involved in processes.
• 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.

Enterprise Data Architect - Consultant

Confidential,Chicago,IL

• Project involves building a cloud-based OLTP enterprise application for internal client. This application leverages various application frameworks that focus on modernizing Financial Custody System for investment security firm.
• 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 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 of a project.
• 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.

Enterprise Data Architect and Technical Lead

Confidential,Northbrook, IL

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

Application/Data Architect, Technical Lead

Confidential

• Provided services in creating Enterprise Architecture Knowledge Management Process and related deliverables; evaluating appropriate Enterprise Architecture Tool(s) to support the new process.
• Architected data model for common patterns reporting mechanism, application exceptions, and exception management 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.
• Integrated 3rd Party Fleet Management Vendor platform with the Ryder systems. Leverage the system foundations to support future providers, enhanced value proposition for On-Demand customers resulting in higher levels of growth.

Enterprise Architect Application & Services

Confidential,Chicago, IL

• The assignment involved providing advisory services for enterprise solution. Assisting business in defining the mission, goals, critical success factors, principles, and policies for data and information quality.
• 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.

ERP Integration Lead - Consultant

Confidential,Fort Myers, FL

• Successfully architected solution for transient student project; reviewed, analyzed specifications, determined gaps, provided optimum solution based on PESC 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 PESC standards.

Enterprise Data Warehouse Analyst - Consultant

Confidential,Chicago, IL

• Upgraded architecture for an EDW at the Confidential by introducing TOGAF 9 framework, guidelines, and by building artifact repositories based on framework for a legacy Data Warehouse migration project.
• 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.

ERP Integration, Implementation - Consultant

Confidential,Chicago, IL

• At Apollo Group, I designed, integrated, and implemented the strategy for ellucian™ Banner® ERP suite with other ERP and financial applications. This was done by leveraging a variety of source and engaging with client and various vendors. Lead the technical teams, during the entire process and deployed the solution to multiple systems globally.
• Leading ellucian™ Banner® ERP interface design, and development project. Assessing existing processes to meet changing business requirements, defining source to target mappings/context diagrams, and designing data flows in an Agile environment.
• Acting as the in-house SME of higher education 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) utilizing Oracle technology, 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 PESC standards including component XML Schema Definition (XSD) and web services.
• Preparing requirements documentation, flow diagrams, and solution plans for Banner® Workflows. Documented workflows including all business, functional and technical details to ensure highly available ongoing operations.
• 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.

ERP Data Analyst, Migration/Implementation Consultant

Confidential,Texas

• Successfully migrated legacy data to a module of Banner® ERP suite, developed, and enhanced component based objects of SunGard ERP suite for NSU, LA. Evaluated ERP business processes, analyzed reporting needs of institution, and performed data conversion.
• Defining requirements from functional specifications for NSU Louisiana, developing ETL processes as it flows through the different systems, resolving data quality issues.
• Communicating with key business and IT stakeholders to confirm requirements, design alternatives, facilitating discussions, and driving requirements sign-off.
• 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.

Sr. ERP Solution Analyst/Oracle Developer BI

Confidential,River Forest, IL

• Recognized for delivery of expert services for consortium of higher education 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). Training 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.