SUMMARY

• I am a highly technical consultant looking for challenging full time permanent placement. I am looking to start winding down my consulting career with the hope of finding an organization that would be a great fit for me.
• I have worked with agile as well as traditional waterfall project approaches. In addition to the traditional project engagement approaches, I pride myself in having the ability and initiative to work directly with business units in regards to rapid prototyping functional requirements to ensure solutions meet the desire business need.
• My extensive consulting background has allowed me to be creative and adaptive to varying business conditions.
• Solid understanding of designing performance centric data warehouses in support of Business Intelligence functionalities. My architectural background is supplemented by a solid programming background which also includes heavy java and Object Oriented Design and Development. Also, I have over 20years of experience with Oracle databases from a developer, DBA and tuning perspective.
• Advance experience using ERWin and PowerDesigner data modeling tools to set up data model management processes and data model change management processes. This includes leading data modeling teams, setting up and maintaining naming standards, data modeling automation to eliminate some of the tedious steps needed to create data models.
• Creating effective data model comparison processes to automated DDL generation and data retention. Effective management of both logical and physical models to respectively present ER - Diagrams to both business and technical teams.
• Over 20 years of experience utilizing industry standards in the analysisdesign, implementation, and tuning of Oracle and object-oriented technologies. In-depth experience and a Data Architect, Solutions Architect, DBA, Oracle & Java Developer, providing skills sets that complement each other allowing me to obtain a broad understanding across project disciplines.
• Ability to manage every aspect of project from Requirements and Specifications, Design, Development, Implementation to post project analysis; Supplemental experience with Java as a developer. ORM design; J2EE experience;
• Designed Data Modeling process management routines involving low level source (OLTP) to target ( Data warehouse staging) structure creation, Automation of Data Modeling change management processes ( data model compares to generated necessary models in DEV, QA, and Production;
• Elimination of manual DDL creation and maintenance; Data model repository creation and maintenance; Design and creation of custom/complex data encryption / data masking routines to move sensitive data from production to testing and development environments, using java. Designed and implemented custom multi-thread high performance database frameworks in java;

TECHNICAL SKILLS

Operating Systems: Windows, Unix (Sun Solaris), Linux, AIX

Databases: Oracle7.x,-12c (Exadata); Netezza, Some Informix, MS SQL Server, MS-AccessDB2;

Data modeling: (Conceptual, Logical, Physical) PowerDesigner, ERWin

Database tools: Oracle OEM;Oracle-Grid; RMAN; Oracle Streams (CDC); Oracle Spot-Light from Quest; Oracle Resource Manager; Oracle- Developer 2000, Designer 2000, Discover 2000, Stored ProceduresSQL, PL/SQL, TriggersOther ODBC and JDBC; Object to relational conversion routines

Big Data: Hadoop - Hortonworks and MapR; HDFS; Hive, PIG, Scoop, MapReduce

Languages/Tools: Java IDEs (Jbuilder4,JDeveloper,Java Workshop), J2EE - Java Beans, JSP, Servlets, EJBs, J2EE; RMI,JNDI, JDBC,SQLJ; Javascript; Python; Oracle PHP, Oracle APEX; Angular, C++ (C++ Builder,Visual C++), Visual Basic, MS-Access; Oracle Express; Business Objects,Tableau; Oracle Forms, Oracle Reports, Toad, Aginity for Netezza, HTML, XML; Distributed Programming Using java sockets and RMI; AutoSys; Hibernate; ORM Mapping

Web/App Servers: WebLogic; Oracle10g Application Server (TOPLink), ;

Methodologies: Agile, Data warehousing Agile, Kimbal, Data Vault Data Management; TOGAF Architectural Methodology; Dimensional Modeling; Transactional 3NF Modeling, Ration Rose RUP; Object-oriented analysis and design, UML, N-tier client server;

Specialties: Database server and application performance tuning; SQL performance tuning; Distributed Programming using java; Enterprise Java Beans, Distributive programming using java (RMI) and C++; Tuning of design of CMP and BMP J2EE architectures; ORM (Object Relational Mapping)

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Architect

Responsibilities:

• Responsible for Oracle Exadata platform performance improvements;
• Responsible for tactical and strategic performance improvements of inflight migration of DB2 applications to Oracle Exadata appliance;
• Lead efforts in coordination with DBAs on Parallelism strategies and Parallel Server performance tuning
• Lead Oracle Resource Manager design, configuration, monitoring and modifications
• Created standard guidelines for proper running of stats for various use cases;
• Assisted in the creation of guidelines for usage of zonemaps
• Created guidelines for Resource Manager Configuration
• Included complex configurations that addresses parallelism, Service Management, and Resource Management across various Exadata Frames.

Confidential

Contractor Senior Data Architect / Exadata Architect

Responsibilities:

• Responsible for Dimensional Modeling for new initiatives within the ATLAS project.
• Responsible for all data modeling and data structure conversion issues for the project move from Netezza to Oracle Exadata 12c.
• Heavy use of PowerDesigner to produce data models and implementation of referential constraints in Oracle Exadata.
• Heavy use of PowerDesigner to manage data structure change management in both Netezza and Oracle 12c during the migration and parallel implementation phase of the ATLAS migration project.
• Heavy analysis of the existing Netezza ATLAS project data structures and usage to determine proper data structure design for the platform in Oracle Exadata. Heavy use of partitioning strategies and HCC compression to house 30 terabytes of Global Liquidity data.
• Evaluation of Angular as a Machine Learning solution to write evolving data quality rules.

Confidential

Contractor Senior Data Architect

Responsibilities:

• Responsible for Dimensional Modeling for enterprise strategic reporting initiatives within the Compliance Department leading entire team of ETL developers, business analysts and subject matter experts; Worked closely with BA and business partners to define, understand & realize business requirements for mandated federal reporting requirements.
• This included business analysis, conceptual modeling, logical modeling, physical modeling, & producing implementation ddl scripts; Participated in source to target mappings with BA/Developers; Designed and wrote complex ETL PL/SQL code from source to target structures; Implemented view structures with creative logic to compensate for additional last minute reporting requirements prior to production releases. Implementation of Data Model Management processes;
• Coordinated data model management using centralized data model repository; Setup data model comparison processes to generate change script including data retention of existing data; Effectively coordinated movement of physical data models from DEV to QA to UAT to Production, given that these environments are almost always at differing levels of the development cycle.
• Created automated processes to automatically generate cloned copies of source structures to data mart staging areas. This included using PL/SQL code and java to read Oracle Data Dictionary of source schema structures and build target table structures automatically and then reverse engineering the created target structures into our modeling tool; This process eliminated critical time spent manually creation simple landing zone structures.
• This process allowed developers to quickly start coding against structures in a high pressure fast pace environment. Wrote Risk Rating logic that incorporated an evolving machine learning logic using constants stored in the database that were adjusted as a result of the ratings percentage of correctness over time.