We provide IT Staff Augmentation Services!

Data Architect - Consultant Resume

CAREER OBJECTIVE:

I have more than 30 years of experience in DBMS architecture and development as Data/Information Architect, Technology Architect, Application Architect, Enterprise Architect, DBA, System Architect, Senior Developer, Database Designer and Team Leader. I am seeking position in challenging environments where I can bring the value of my knowledge and experience.

SUMMARY:

  • Designed, developed and implemented software for Banking, Finance, Retail, HR, Health Care and Manufacturing for both, public and private sector.
  • Utilized different methods for conceptual, logical and physical data and process modeling.
  • Worked on designing, modeling and improving performances on several OLTP and Data Warehouse applications, relational and multidimensional.

TECHNICAL SKILLS:

Applications: Oracle e - BusinessSuite 11i, 12 (GL, AP, FA, CM, AR, and Workflow), Oracle Retail 12, 13 (Retek) RMS, ReSA, RDW, POS, BO, CO, PeopleSoft 9.2 FMS and HRMSVarious third party and custom made applications.

Tools: ORACLE RDBMS 5, 6, 7, 8, 8i, 9i, 10g, 11g, 12c, RAC, Data Guard, ASM, OEM, Designer/2000, Forms 2.3, 3.0, 4.5, 6i, 9i, 10, Reports 1.0, 2.0, 2.5, 6i, 9i, BI Publisher, SQL*Loader, SQL*Plus, PL/SQL, WebLogic, J2EE, .Net, T-SQL, VB, JAVA, Oracle Application Server, Oracle SOA Suite, ODI, AIA, WebLogic, Hyperion, DB2, Informatica, Cognos, Business Objects, Hadoop, Netezza, Aginity, Hue, Visual Studio, MS SQL Server, Power BI, MS Projects, Azure, Zachman Framework, Kimball Lifecycle Toolkit, Visio, PowerDesigner, TOAD, Spotlight, Oracle Financial Analyzer, Share Point, OWB, Oracle Discoverer, Windows Server, LPAD, SSO, RMAN, CURAM, DataStage, ERWIN, UML, RUP, ETL TOOLS, PVCS, CVS, HEAT, MERCURY, UNIX (SOLARIS, HP, SCO, NCR, AIX, LINUX), VAX/VMS, IBM CICS, COBOL

EMPLOYMENT HISTORY:

Data Architect - Consultant

Confidential

Responsibilities:

  • Working as information/data architect for major data warehouse Risk Management regulator reporting BI projects RBIO (Risk Business Intelligence Office) and RLOB (Retail Line of Business).
  • Working on defining processes on Hadoop, Netezza and Oracle and creating conceptual, logical and physical data models for ORACLE, Netezza, Hadoop and MongoDB using Hue, Aginity, TOAD and Erwin 9.64. Reporting tool was Cognos.

Data/Application Architect - Consultant

Confidential

Responsibilities:

  • Participated in workshops with business stake holders to analyze impact of moving major BI applications to the Microsoft Azure Cloud
  • Worked as Data and Application Architect on PSAE data warehouse application applying Agile approach and using Informatica as ETL tool.
  • Created CDM, LDM and PDM for PSAE data warehouse application and 2 brand new OLTP applications PFAAM and PFAAMU based on analyzing business processes and having workshops with business people
  • Led a project and worked on DCP (Data Collection Platform) Artifacts to help obtaining cluster and corporate approvals for conceptual (CP1), logical (CP2) and physical (CP3) level artifacts.
  • Created many PL/SQL scripts for data migration for 2 brand new OLTP applications
  • Performed tasks regarding data analysis, data cleansing and data quality management
  • Created metadata management policy for the whole EDCS set of collections/applications
  • Applied AGILE approach, Oracle 11g, TOAD, Visio, PowerDesigner 16.5 and .NET. ETL tool was Informatica. Used Power BI Desktop.

Data/Technology/Application Architect - Consultant

Confidential

Responsibilities:

  • As a part of enterprise architecture team worked on Phase 2 of IFIS renewal project artifacts to align logical and physical level of architecture with the newly defined business architecture and changes required by upgrade to Oracle E-Business Suite Release 12.Successfully got endorsement of ACT (Architecture Core Team) and approval of ARB (Architecture Review Board) for the Confidential 2 and Confidential 3 artifacts.
  • Created mapping for Data warehouse application based on Oracle Discoverer and Hyperion between major reports and database elements
  • Used Visio and PowerDesigner 16.5.
  • Applied principles of combination of TOGAF and Zachman Framework

Application Architect/Senior DBA - Consultant

Confidential

Responsibilities:

  • Worked on team to implement Oracle Retail 13.1 solution. Performing tasks regarding technology and application side of the implementation and infrastructure development.
  • Performed tasks of Application Portfolio Rationalization in order to streamline existing applications for the client
  • Created, implemented and maintained most suitable architecture for various development and testing environments required during implementation period. Provided full technical support to the client and implementation team and led the technology team. Implemented Oracle SOA Suite with WebLogic and BPEL process manager
  • Applied various Oracle patches and helped with compiling and setup Oracle Retail software components
  • Installed and setup AIA (Application Integration Architecture) 2.5 and PIP (Process Integration Pack) between Oracle Retail software and existing PeopleSoft ERP application in the following environment: Oracle DB 11gR2 SOA Suite 10g Oracle WebLogic 11g Oracle ODI 10g AIA and PIP 2.5 OAS 10g Oracle Retail (RIB, RSL, ReIM, RMS and RPM) 13.1.6

Application/Information Architect - Consultant

Confidential

Responsibilities:

  • Worked on enterprise architecture team to deliver Confidential artifacts as part of IBA project (IFIS Baseline Architecture). IFIS (Integrated Financial Information System) is implementation of Oracle e-Business Suite application with many extensions and customizations with OLTP and BI parts. Prior to that worked on a team to complete same artifacts (Row 3 and Row 4) for HST implementation impact on IFIS (Integrated Financial Information System).
  • Successfully passed ACT and ARB reviews for the artifacts.
  • Worked on Row3 artifacts for EPP (Enterprise Payment Program) project.
  • Used Visio and PowerDesigner 15.2. Applied principles of combination of TOGAF and Zachman Framework

Information/Data Architect - Consultant

Confidential

Responsibilities:

  • Worked on Conceptual Data Model for CPIN (Child Protection Information Network) project.
  • Based on Business Function Model and inputs from business stakeholders defined and maintained Conceptual Data Model in order to get ready for fit/gap analysis with few COTS solutions.
  • Followed all OPS architecture standards and guidelines in order to pass throw the gates.
  • Took part in workshops with various business groups in order to present current model and to get better understanding of the requirements.
  • Used PowerDesigner 15.
  • Modeled business and systems processes based on findings through use case scenarios and data models
  • Participated in activities selecting CURAM as the case management COTS solution

Data Architect/DBA - Consultant

Confidential

Responsibilities:

  • Provided technical support for the data mining company. Worked on data and application architecture in order to achieve best results from 3-tier multi-server and multi-database environment. Both, OLTP and Data Warehouse in-house built applications were used.
  • Improved performances with tuning database and applications
  • Created backup strategy and implemented it using RMAN.
  • Implemented Data Guard, ASM and RAC solutions for the major data warehouse database.
  • Created and implemented patch applying strategy.
  • Performed reverse engineering and created logical and physical data models for the major OLTP and Data Warehouse databases and schemas. Oracle 10g, 11g, Solaris 10 and Oracle Application Server 10.2, ERWIN 7.3.

Technology Architect/DBA - Consultant

Confidential

Responsibilities:

  • Provided technical support for the EPP (Enterprise Payment Processing) project as a part of IBM team.
  • Confidential has purchased Oracle Retail solution to support payment processing throughout all ministries.
  • I provided technical support in creating best suitable architecture to comply with OPS standards.
  • Installed POS and RMS components of Oracle Retail application.
  • Designed and developed interface between Oracle Retail and Oracle GL.
  • Created many PL/SQL scripts for data migration
  • Explored all options for the Oracle Retail infrastructure components
  • Participated in regular meetings with business team from all ministries in order to prepare and perform POC (Proof of Concept) and CRP (Conference Room Pilot) presentations for all stakeholders.
  • Oracle 10g, Oracle Application Server 10.2

Data Architect/Application Architect - Consultant

Confidential

Responsibilities:

  • Responsible for data architecture on DFRR (Derivatives Financial Regulatory Reporting) data warehouse project.
  • Existing application is being redesigned in order to provide better UI and reporting capabilities.
  • My team had been helping business people to define their requirements and helped user’s community as well to provide them with the best way how to handle various adjustments and reporting requests on daily basis.
  • Performed activities relating to Application Portfolio Rationalization
  • Created new data model and generated many useful reports to help business group to do proper data usage analysis for the existing and new data. Used Erwin 7.1.
  • Database was MS SQL Server

Data Architect/Application Architect - Consultant

Confidential

Responsibilities:

  • Responsible for data architecture on Impaired Loan Sub-Ledger (ILS) and WCDW (Wholesale Credit Data Warehouse) projects as a part of Basel II initiative. ILS was the brand new application and is some combination of data warehouse and OLTP application with feeds from other systems in the bank and its own user interface allowing users to control all relevant data regarding impaired loans.
  • Designed and created Packages and Stored Procedures as a part of inbound and outbound feeds
  • Improved performances on some complex ETL logic
  • Worked with QA and development team as well as business team in order to setup and perform test cases for UAT and SIT.
  • Led a team and performed tasks regarding data analysis, data cleansing and data quality management
  • Participated in project reviews with Confidential architecture team in order to ensure compliance with the standards. Took part in sessions with different bank’s departments feeding central warehouse system (wholesale/retail credit data warehouse) in order to define all interactions between different systems.
  • After lengthy sessions with business people, based on published use cases, created conceptual, logical and physical data model using Erwin. Maintained and published data dictionary on regular basis during project development.
  • Created sets of materialized and db views to help UI and BI people to simplify their communication with database.
  • Performed data analysis and data profiling tasks for the inbound feeds
  • Performed activities relating to data linage
  • Helped UI J2EE team with design and performance issues
  • Designed and created db triggers and packages to enforce business logic. Converted data from several legacy systems into new application.
  • WCDW is the main wholesale data warehouse application for Confidential with more than dozen incoming and outgoing feeds and 600+ tables. Worked on data model and ETL logic for the most critical feeds.
  • There were 20+ developers, 5 DBAs and 10 business people on the project at the time.
  • RDBMS was Oracle 9i RAC, Middleware was WebLogic with J2EE, ETL tool was Informatica, BI tools were Actuate and Cognos.

System Architect/Senior Developer - Consultant

Confidential

Responsibilities:

  • Designed and built Electronic Medical Record application for Family Physicians.
  • Design and built interfaces to and from MOH to send medical claims and to update existing from the MOH feedback
  • Design and built interfaces to MOH for Health Card validation
  • RDBMS was Oracle 9i on Windows XP

Data/Application Architect - Consultant

Confidential

Responsibilities:

  • Played following roles: Data Architect, System Architect, Application Architect, DBA, Application Administrator
  • Performed complete Application Portfolio Rationalization
  • Created data model for marketing data mart for in house built data warehouse application using Erwin and MS SQL
  • Created data model and led the team to create and implement Retail Stock Ledger (RSL) application as a part of Retek package. RSL consists of 6 separate subsystems. Team varied from 4-10 developers depending on the phase of project.
  • Created data model and led a team of 4-10 to create application extensions to Oracle Financials and Retek in Oracle Developer/2000 environment using Oracle AOL 10.6.
  • Designed and developed extensions to GL and AP modules in GUI environment to cover Confidential ’ needs dealing with more than 50,000 invoices weekly
  • Participated in creating architecture strategies
  • Created mapping (source-to-target) and defined interfaces for data conversion from Oracle Financials and Retek to SAP. Built the logic to extract data from the existing databases and created shell scripts to ftp data to the new environment. On SAP side used IDoc as utility to load data into new system.
  • Created interfaces for data conversion from Oracle Financials and Retek to SAP
  • Led a team and performed tasks regarding data analysis, data cleansing and data quality management
  • Participated in many session defining fit/gap analysis
  • . Performed requirements reviews and coding exercises and reviews.
  • Performed data analysis and data profiling tasks for the inbound feeds
  • Led a team to upgrade Oracle Financials 10.7 to e-Business Suite 11i (11.5.9) along with upgrading extended portion of in-house-built Oracle Financials application on 9i (9.2.0.3) version of Oracle DB
  • Involved in planning and estimating architecture activities
  • Designed, supervised, and developed various EDI modules between Oracle Financials and Retek for: Invoice matching, Purchase Orders Acknowledgments (POA), Advance Shipment Notice (ASN). For the period of less than one year fully implemented all mentioned EDI modules saving company millions of dollars in receiving at the store level and keying/validating invoices. On monthly basis up to 150,000 invoices processed through EDI.
  • Created many PL/SQL scripts for data migration
  • Defined contract deliverables, through the identification of significant milestones and expected results with weekly status reporting
  • Created extension to Cash Management module of Oracle Financials application regarding capturing manual checks and automatically reconciling all checks based on data received from the bank on monthly basis
  • Led a team and worked on migrating Oracle Financials application to Oracle 8.05 and Retek application to Oracle 8.06
  • Designed and created module called ‘Purchasing Tool’ - to help buyers to do buying based on the allocated budget (Open to Buy), as a part of Retek. Used Erwin 4.1.
  • Created architecture models utilizing James Martin, top down approach and Zachman Framework
  • Played a role of MS SQL Server DBA on the project for Confidential online
  • Performed system integration testing for Y2K between Retek and Oracle Financials
  • In addition I designed and implemented QA and QC processes for RSL.
  • Completed functional analysis, implemented and created extensions to Oracle FA application and designed and implemented changes to AR.
  • Led a team in upgrading Oracle Financials application along with all created extensions and modifications to AOL 10.7 on RDBMS 7.3.3 to be Y2K compliant
  • Conducted GAP and functional analysis for various processes for GL and AP
  • Development has done in Oracle Developer/2000 environment on the client side and Pro*C and stored procedures on the server side. Client environment was Windows 95/98 and HP/Unix was on a server side, with Oracle RDBMS 7.3.4. Used Erwin 4.1

Hire Now