Candidates About

 

Alf Baez

Summary

·         Exceptionally qualified, innovative and hands on IT professional, with over 16 years of demonstrated experience in planning, developing, creating, managing, supporting, and streamlining robust IT architectures and infrastructures for a number of global, prestigious companies. Including defining roadmaps, budgets, staff, infrastructure, facilities. Along with overseeing the implementation of multiple plans in parallel, at the same time ensuring high performance and availability for maximizing business.

·         Highly experienced in leading and managing diverse multi-cultural teams of 25+ people seated across the globe in stressful 24/7 environments, prioritizing deliverables, and optimizing resource utilization across projects to accomplish targeted goals, assuring Service Level Agreements (SLA), are fulfilled as expected and managing RFPs (Response for Proposals) and POCs (Purchase Orders Compliance)

·         Strong experience in designing and developing and deploying distributed computing Big Data applications using Open Source frameworks like Apache Spark, Spring ETL, and Kafka on AWS Cloud

·         Strong experience managing with hands on designing, engineering, implementations of Open Source Big Data technologies projects, such as Hadoop Spark, Scala, NoSQL (Cassandra, MongoDB) Business Intelligence Enterprise (and distributed) environments with Enterprise Insight Analytics (IBM’s i2) and Oracle BI and Spatial, IBM Isri, for national and global Governments and private entities

·         Strong experience in designing, capacity planning and Migration implementing to the Cloud (private and secure), and VLDB (very large database systems, from several Terabytes to few petabyte) using Cassandra, HDFS Spark, Oracle 12c, Exadata, Oracle Exalogic, PostgreSQL, Greenplum DCAs, IBM DB2 aid with ETL tools such Oracle Golden Gate, Sqoop, flume, Kafka, Attunity. To support early fraud, Anti-Money Laundering (AML BSA) and Counter Terrorism applications and systems to support decision making officials and their agencies in real-time with support of their Patriot Officer and BAM+, and strong experience managing the integrating Oracle JD Edwards EntepriseOne

·         Highly experienced with hands on Data Architect in capacity planning, implementation and management of critical mixed environments configured for HA/Replication with active-active(GoldenGate multi-master), active-standby options implementing Oracle’s Advance technologies DataGuard, 9i-12c Real Application Cluster (RAC), with Multitenant Option: Container and Pluggable databases (12c CDB and PDB on Exadata 5.x), Automatic Storage Manager (ASM), GoldenGate with encryption TDE TSE, Golden Gate Veridata, Exadata v2, RMAN with Split mirror backups and WebLogic (10g-12c) OEM 10g-13c, with strong exposure to other tool and products (DBV OID/OVD, OUD) Oracle EBS 12 R2; Oracle Text (11g-12c), IBM's i2 Enterprise Insight Analysis

·         Strong experienced in Cloudera and Oracle Cloud Services, public and private for federal (DBaaS, SaaS, DaaS, PaaS, IaaS), Oracle and PostgreSQL on AWS (RDS; Redshift) projects. Capacity, planning, and implementation of many of the SOA components: BPEL, Human Workflow, Business Rules, Mediator, Oracle Service Bus, Oracle JCA, Oracle Cloud Adapters, Oracle Enterprise Scheduler, Oracle BAM, Oracle A, Oracle MFT along with Oracle Fusion Middleware (Weblogic)

·         Highly experienced in Application assessment, capacity planning, performance tuning, response time improvement and identification of bottlenecks at different levels of infrastructure (front-end, middleware, back-end, network, bandwidth connectivity, storage growth, CPU, Memory, and maintenance of datacenters)

·         Experienced in modeling and designing online transaction processing (OLTP), data decision support (DDS), warehouses (DW) database systems, and extract/transform/load (ETL) processes. Experienced integration of external financial data systems such Broadridge, MarkIT, Reuters, and Bloomberg

·         Highly experienced in software development life cycle (SDLC) methodologies Agile Scrum and UML (CA ERWin) modeling schemas, database procedures supporting enterprise application such as Curam which is globally recognized within the government federal agencies in several countries

 

 

 

 

 

 

Technical Skills

 

BIG DATA/Cloud/RDBMS/Apps: Oracle Cloud Service SOA modules and components: BPEL, Human Workflow, Business Rules, Mediator, Oracle Service Bus, Oracle JCA, Oracle Cloud Adapters, Oracle B2B-Health Level 7, Oracle Enterprise Scheduler, Oracle BAM, Oracle API Manager Cloud Services, Oracle MFT, Oracle 8i-12c, Oracle TimesTen(in memory db), SQL Server, PostgreSQL 8/9, Greenplum DCA 4, Oracle Grid Control, Grid Infrastructure, WebLogic 11c-13c, Oracle EBS (11i-12), EnterpriseDB (Advance server and plus), DB2, My SQL, NoSQL open source projects Cassandra, Hadoop, Apache Spark, MongoDB, and Greenplum.

Tools: Oracle SQL Developer, Oracle Discoverer DS, OEM 11g-13c, RMAN, Erwin, Toad, MS-Visio Crystal Reports, SQL*Loader, JDeveloper; Secure CRT, TOAD, Putty; Informatica, DataJunction, MS Project, GoldenGate, GoldenGate Monitor, GoldenGate Studio, Exadata, SharePlex, IBM BDW 8.2, Spectrum, PgAdmin, PgCluster TOAD for PostgreSQL 8/9, PgPool, SlonyI, Bucardo

Programming Languages: Scala, SQL, PL/SQL, T-SQL, Shell Scripts, PERL, PHP, Java, JavaScript, C, C++, Ruby on Rails

Operating Systems: UNIX (Sun Solaris 9-11.x, IBM AIX 5.x -7.x, HP-UX 11i v3), Linux (Red Hat 5.x-6.x, SuSe), MS Server, MS Windows NT Server, MS-Exchange Server

Storage/Mainframe/Machine Vendors: 3PAR, EMC, Hitachi, IBM Subsystems, IBM Banking Data Warehouse, IBM System z (zEC12, z196), EMC, Exadata, Exalogic, GreenPlum DCA

 

Experience:

 

World Fuel Server, Inc. – Global, HQ in Miami, FL    06/2017 – 06-Present

Sr. VP Data Architect & Big Data Modeler

 

WFS is multi-national with over 30 billion of review a year. World Fuel Services Corporation is a Fortune 100 company that is based in Miami, Florida. It provides marketing and financing of aviation, marine and ground transportation fuel products and related services to commercial and corporate aircraft, petroleum distributors and ships at more than 3,500 locations around the world.

 

Sr. VP Data Architect & Big Data Modeler with direct hands on, technical Adviser for the Executive stakeholder’s board and on site, off-shore personnel.

 

·         Sr. Data Architect responsible for designing and architecting plans for migrating several legacy RDBMS and EBS applications to NoSQL and Big-Data/Cloud (AWS) environments. This included designing and implementing several model plans for Oracle and Cassandra aid with Erwin, DBSchema to create the application workflows and Conceptual models to Conceptual Mappings to logical data to physical organization to physical models and lastly generating the CQLs. Performed the de-normalization to achieve better read with less IOPs (more in memory with less in place commits) with data re-organization (structured data) back to 2^nd and even 1s normal form (un-structured data).  ETL performed with the aid of apache tools Sqoop, Flume, Kafka, sprint API.

·         Sr. Tech Lead/Architect responsible for the designing and planning the migration of several traditional RDBMS (Oracle, PostgreSQL, among other) to NoSQL and Big-Data/Cloud AWS, Oracle Cloud. This included the deploying on 100% Agile and distributed computing Big Data applications using Open Source frameworks like Apache Spark, Spring ETL, and Kafka on AWS Cloud (AWS Common Services).

·         Sr Data Architect for designing and implementing several model plans for Oracle and Cassandra aid with Erwin, DBSchema/KDM to create the application workflows and Conceptual models to Conceptual Mappings to logical data to physical organization to physical models and lastly generating the CQLs. Performed the de-normalization to achieve better read with less IOPs (more in memory with less in place commits) with data re-organization (structured data) back to 2^nd and even 1s normal form (un-structured data).  ETL performed with the aid of apache tools Sqoop, Flume, Kafka

·         Sr. Tech Lead responsible for the design and architect and implemented several RDDs, DataSets, and DataFrames, in Spark (Apache DHFS) technology and extracted data from data warehouse to the Spark RDDs, transformed data back and forth between RDDs and DataFrames using Scala language integrated Queries APIs.

·         Sr. Tech Lead responsible for planning and implementing Oracle OEM 13c and the integration of several modules, plug-ins, and customs scripts to monitor the entire enterprise; Storage, Database, OS level metrics and so on, Admin groups: Dev, QA, Production, setup and customize several alert and rules to go out a certain time to email inboxes and phones sms to responsible individuals

·         Sr Data Architect responsible for designing the architecture for many of APEX, SOA mobile Applications and deployment in Tablets and mobile phones and responsible for planning and implementation and administration of source code control and standards utilizing Oracle Portal’s CMS and guidance of other team members in their development and testing efforts

 

Environment: OLTP and DSS system databases sized from several TBs up to few PB running on Cassandra, HDFS, Spark with Scala, PostgreSQL, Oracle 11g-12c, Exadata 5.x; EMC Clariion, Veritas, Oracle AMS, Oracle RAC, Grid Infrastructure, WebLogic 12c (Exalogic Elastic Cloud x6-2), Eclipse with Android SDK IBM System z (zEC12, z196), IBM’s Unisys Private Cloud Storage management, and AWS Private Cloud.

 

Federal Military Agency (via Sierra Tech) – Multi-State MO, IL, DC, FL, and   NY    04/2016 – 06-2017

Sr. Data Architect/Sr. Technical Lead Implementation Specialist

 

Multi-year engagement in progress details will be disclosed as permitted by Federal/Military Agency’s NDA

 

Sr. Data Architect – Technical Lead with direct hands on, technical Adviser for the Executive stakeholder’s board and DBA/Development in-house and third parties’ teams.

 

·         Sr. Data Architect responsible for the designing and architecting the planning for the migration of several legacy RDBMS and EBS applications to NoSQL and Big-Data/Cloud (AWS) environments. This included designing and implementing several model plans for Oracle and Cassandra aid with Erwin, DBSchema to create the application workflows and Conceptual models to Conceptual Mappings to logical data to physical organization to physical models and lastly generating the CQLs. Performed the de-normalization to achieve better read with less IOPs (more in memory with less in place commits) with data re-organization (structured data) back to 2^nd and even 1s normal form (un-structured data).  ETL performed with the aid of apache tools Sqoop, Flume, Kafka, sprint API.

·         Sr. Tech Lead responsible for supporting ACS for the Air Mobility Command (AMC) Global Decision Support Systems (GDSS) Planning and Implementation project on High Availability solutions with Oracle 12c, GoldenGate 12c bi-directional (Active-Active) in multi-master replication architecture and using Veridata for conflict detection and resolution (CDR) and Oracle Golden Gate’s Monitor part of Fusion Middleware and SOA suite to manage and monitor the entire replication environment around the globe

·         Sr. Tech Lead responsible for the designing and architecting the planning for the migration of several traditional RDBMS to NoSQL and Big-Data/Cloud environments. This included designing and implementing several model plans for Oracle and Cassandra aid with Erwin, DBSchema/KDM to create the application workflows and Conceptual models to Conceptual Mappings to logical data to physical organization to physical models and lastly generating the CQLs. Performed the de-normalization to achieve better read with less IOPs (more in memory with less in place commits) with data re-organization (structured data) back to 2^nd and even 1s normal form (un-structured data).  ETL performed with the aid of apache tools Sqoop, Flume, Kafka

·         Sr. Tech Lead responsible for the design and architect and implemented several RDDs, DataSets, and DataFrames, in Spark (Apache DHFS) technology and extracted data from data warehouse to the Spark RDDs, transformed data back and fort between RDDs and DataFrames using Scala language integrated Queries APIs.

·         Sr. Tech Lead Involved in the evaluation and piloting implementation of IBM's i2 Enterprise Insight Analysis (voice, video, ASCII data) for a global scale to near real-time reporting and pro-actively recognizing potential terror threads inside and outside perimeter of US interest locations and migration from Task Force Phoenix to i2 EIA

·         Sr. Tech Lead responsible for planning and implementing Oracle OEM 13c and the integration of several modules, plug-ins, and customs scripts to monitor the entire enterprise; Storage, Database, OS level metrics and so on, Admin groups: Dev, QA, Production, setup and customize several alert and rules to go out a certain time to email inboxes and phones sms to responsible individuals

·         Sr Data Architect responsible for designing the architecture for many of APEX, SOA mobile Applications and deployment in Tablets and mobile phones and responsible for planning and implementation and administration of source code control and standards utilizing Oracle Portal’s CMS and guidance of other team members in their development and testing efforts

·         Lead architect responsible for the planning, implementation and management of several components of the SOA suite in HA/Clustered environment. This included installing, configuring WLS domains, load balancing, performance tuning, deploying, troubleshooting and maintaining of WebLogic servers along with the monitoring for performance for short and long terms capacity planning

·         Lead for PostgreSQL Greenplum assessing, planning, and implementation big data projects. With direct hands on as technical lead responsible for planning and implementation of PostgreSQL GreenPlum installations, creating databases on demand for several teams such as Dev, QAs, EUT. Used ora2pg utility as part migration conversation process and use sqoop and flume for the ETL and ingesting data process to several Greenplum/HD big data projects.

·         Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several databases and managing users, and creating secure connections.

·         Supporting assessment, design and implementation of replication tools such Oracle Golden Gate, Attunity to support several Anti-Money Laundering (AML) and Counter Terrorism applications and systems to support decision making officials and their agencies to the minute and or real-time.

 

Environment: OLTP and DSS system databases sized from several TBs up few PBs running on Cassandra, HDFS, Spark with Scala, PostgreSQL, Oracle 11g-12c, Exadata 5.x; EMC Clariion, Veritas, Oracle AMS, Oracle RAC, Grid Infrastructure, WebLogic 12c (Exalogic Elastic Cloud x6-2), Eclipse with Android SDK IBM System z (zEC12, z196), IBM’s Unisys Private Cloud Storage management, and AWS Private Cloud.

 

Federal and State Local Agency (via MSys) – Multi-State MN, DC, FL, and   NY    01/2015 – 03/2016

Sr. Data Architect - Implementation Specialist

 

Sr. Data Architect – Technical Lead with direct hands on and Adviser for the Executive stakeholders and DBA/Developers in-house and third parties’ teams and personnel

 

·         Sr. Technical Lead, for the Oracle Cloud Integration project which included the capacity, planning, an implementation of many of the SOA modules, providing lead development and architectural guidance for all in-house teams as well.

·         Sr. Technical Lead, designed, planned, and implemented Oracle’s GoldenGate in several configurations such as unidirectional, bi-directional (Active-Active), and cascade. Along with Oracle’s Veridata to monitor and detect conflict and perform resolution, to migrate and replicate several 100s of databases in heterogeneous environments to Oracle Exadata 12c with Container and Pluggable (CDB/PDB on Exadata 5.x) options part of the State’s ACA, MNSure, SSIS, and Curam, project initiatives such the migration of 200+ (spread out the Minnesota State’s counties) databases running on windows 2008 R2 to oracle 12c with CBD and CPD.

·         Sr. Technical Lead and application DBA responsible for the implementation and management of the Curam data model and preparing the solution for operations. Tasks: included from creating core Curam application schemas and components on the back end core supporting database on Oracle 11g and 12c, along with day to day DBA tasks such as Create schema users and fine tuning recommendations for better performance.

·         Implemented GoldenGate with Transparent Data Encryption (DTE), and Tablespace Encryption (TSE) and other advanced data security technologies and products.

·         Involved in designing and developing Amazon EC2, Amazon S3, Amazon SimpleDB, Amazon RDS, Amazon Elastic Load Balancing, and other services of the AWS infrastructure and created AWS Multi-Factor Authentication (MFA) for instance RDP/SSH logon, worked with teams to lock down security groups.

·         Setup specific IAM profiles per group utilizing newly released APIs for controlling resources within AWS based on group or user and AWS data backup (snapshot, AMI creation) techniques, along with data-at-rest security within AWS.

·         Implemented Oracle Golden Gate’s Director middleware to manage and monitor the entire replication environment.

·         DB Lead Architect Consultant responsible for the design and implementation of 11gR2 to 12c migration for all corporate databases for both RAC and non-RAC environments.

·         Sr. Technical Lead responsible for day to day activities and overall architecture of database infrastructure environment: capacity planning, and integration of several database and components to be managed with Oracle OEM 11g/12c

·         Sr. Technical Lead responsible for day-to-day advance support for the High Availability Environments: multi-node RAC and DR (Disaster Recovery) Site systems utilizing Oracle’s physical and Logical Standby Databases (Data Guard) strategies and other enterprise applications such Oracle ESB 12 R2

·         Sr. Technical Lead with hands on planned and implemented the Java CapTrans-TDC project using GoldenGate 12c: Transactional Data Capture WLS (Weblogic Server) Java Messaging Service (JMS/Java Adapter) VAM message capture

·         Sr. Technical Lead, providing assistance to the development, architecture, and release teams, providing architectural design recommendations, driving standards and naming conventions as per Agency’s requirements for effective Greenplum transition to production operations.

·         Planned and implemented Oracle CMS to incorporate internal CMS administrative program accounting transactions and responsible for administration of source code control and standards utilizing DEC CMS and guidance of other team members in their development and testing efforts.

·         Designed and implemented data migration and replication strategies to maintain several mix databases environments to Greenplum using Attunity replicate for Pivotal.

·         Implemented Nagios for over systems monitoring. Also tune minimum OS (Linux RedHat/SuSe) kernel parameters for better overall performance.

·         Responsible with hands on day-to-day PostgreSQL db operations such as planning and implementation of PostgreSQL GreenPlum installations, creating databases on demand for the application teams and others such as Dev, QAs, EUT.

·         Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several databases and managing users, and creating secure connections, as well.

·         As part of the Big data project, managed and admin Greenplum (PostgreSQL) databases (Masters/Segments) using open source and Pivotal/Greenplum utilities such as PgAdmin III and using cli (command line interface) such as pgstart pgstop, pgssh, etc.

·         Designed and implemented the MongoDB schema and Wrote services to store and retrieve user data from the MongoDB for the application on devices, Used Mongoose API in order to access the MongoDB from NodeJS

 

Environment: OLTP and DSS system databases sized from 100Gs up to over 35 TBs running on 11gR2 windows and 12c on Oracle Linux Exadata 5.x; EMC Clariion, Veritas, Oracle AMS, Oracle RAC, Grid Infrastructure, WebLogic 12c, IBM, (Exalogic Elastic Cloud x6-2), System z (zEC12, z196), Unisys Storage management. Spark with Scala, Eclipse with Android SDK, AWS C2, Cassandra, Hadoop, AWS Private Cloud S3, RDS.

 

Federal Agency – Confidential (via Oracle ACS/Sierra Tech), Washington D.C       03/2013 – 12/2014

Sr. Data Architect - Technical Lead

 

Sr. Technical Lead and Data Architect with direct hands on and executive Adviser for the stakeholders of the Affordable Care Act (ACA) project Board, ACA is a United States federal statute signed into law by President Barack Obama on March 23, 2010

 

·         Sr. Technical Lead and Data Architect with hands on and executive advisor for the several project state holders and C level, responsible for the design, implementation, and capacity planning of database systems for the ACA project utilizing Oracle’s newest and advance technologies for both RAC and non-RAC environments, single node RAC, and oracle restart, RMAN, ASM, Grid Infrastructure (GI), OEM 12c, GoldenGate, and WebLogic 12c.

·         Sr Technical Lead and Data Architect responsible for designing the architecture for many of APEX, SOA mobile Application to be deployed in Tablets and mobile phones.

·         Sr. Technical Lead responsible for the implementation of RMAN with Split mirror backups for several multi-terabyte database systems, this required the implementation of Grid Infrastructure, single node RAC environments, oracle restart, and Oracle ASM interacting with Veritas and Netbackups environment

·         Sr. Technical Lead responsible for day to day activities and overall architecture of database infrastructure environment: capacity planning, configuration and integration of several database and components to be managed with Oracle OEM 11g/12c

·         Sr. Technical Lead responsible for day-to-day advance support for the High Availability Environments: multi-node RAC and DR (Disaster Recovery) Site systems utilizing Oracle’s physical and Logical Standby Databases (Data Guard) strategies.

·         Sr. Technical Lead and application DBA responsible for the implementation and management of the Curam data model and preparing the solution for operations. Tasks: included from creating core Curam application schemas and components on the back end core supporting database on Oracle 11g, along with day to day DBA tasks such as Create schema users and fine tuning recommendations for better performance.

·         Lead Implementation project on High Availability solutions with Oracle 10g, 11g, and 12c-utilizing Oracle’s physical and Logical Standby Databases (Data Guard) strategies and Oracle’s GoldenGate bi-directional (Active-Active) configuration and using Veridata to monitor conflict and perform resolution and Oracle Golden Gate’s Director middleware to manage then entire replication environment.

·         Sr. Technical Lead with hands on planned and implemented the Java CapTrans-TDC project using GoldenGate 12c: Transactional Data Capture WLS (Weblogic Server) Java Messaging Service (JMS/Java Adapter) VAM message capture

·         Responsible for the built of several databases in ACA’s QA & DEV environments via cloning using Oracle RMAN duplicate utility features. Perform several logical database refresh using Datapump and Transportable Tablespaces tools for development and testing database.

·         Responsible for identifying regressed SQL statement and suggesting appropriate solutions using SQL Tuning Advisor.

·         Responsible for the planning and assessment of VLDBs in the several TBs, Backups and migration using BCVs mirroring technique and storage technologies

·         Assisted various teams on the Migration Oracle 11g/12c to LOZ (zLinux systems)

·         Assisted the Lead Greenplum 4.0 Implementation for full racks with DCA v1.

·         Assisted the Lead designed and implementation of High Availability, Backup/Restore, and Disaster Recovery of the Greenplum environments.

·         Lead Designing and implementing databases for OLPT and data warehouse (start schemas with big fact tables and dimensions)

·         Managed day-to-day db operations such creating and managing users, and secure connections.

·         As part of the Big data project, managed and admin Greenplum (PostgreSQL) databases (Masters/Segments) using open source and Pivotal/Greenplum utilities such as PgAdmin III and using cli (command line interface) such as pgstart pgstop, pgssh, etc;

·         Implemented Nagios for over systems monitoring. Also tune minimum sys/os(Linux RedHat/SuSe) kernel parameters for better overall performance.

·         Responsible for all documentation procedures of daily operations for the organization’s DBA run book, which integrated into the corporate’s infrastructure run book with detailed instruction on how to procedure and how to contact key staff members, Technical lead, vendors, managers, executives, etc.

 

Environment: OLTP and DSS system databases sized from 100Gs up to over 35 TBs running on 10gR2, 11gR2, Solaris 9/10, Red Hat 5/6; EMC Clariion, Veritas, Unisys, Greenplum DCA 4.0 full-rack, Oracle AMS, Oracle RAC, Grid Infrastructure, WebLogic 12c, IBM System z (zEC12, z196), Unisys Storage management.

 

New York – Law Enforcement (via URimagination) New York, NY 09/2012 – 02/2013

Sr. Data Architect - Technical Lead Consultant

 

A DB Architect Principal Technical Lead Consultant and Adviser for the DBA/Developers in-house personnel

 

·         DB Lead Architect Consultant responsible for the design and implementation of 10gR2 to 11gR2 migration for all corporate databases for both RAC and non-RAC environments.

·         Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several database and components to be managed with

·         Conducted Database and SQL Performance Tuning in oracle RAC environment using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

·         Responsible for all corporate oracle databases running on Windows / UNIX (HP-US, Sun Solaris, - IBM AIX 5L) /Linux (RedHat)

·         Lead Implementation project on High Availability solutions with Oracle 10g to 11g migration, Physical and Logical Standby Databases (Data Guard)

·         Built QA & DEV environments via cloning using Oracle RMAN duplicate utility features. Perform several logical database refresh using Datapump and Transportable Tablespaces tools for development and testing database.

·         Responsible for identifying regressed SQL statements and solutions using SQL Tuning Advisor.

·         Responsible for advising developers how to code optimal with SQL and PL/SQL.

·         Responsible for performance tuning of PL/SQL with the help of Oracle tools set.

 

Environment: OLTP and DSS system DBs sized from 150Gs up to 50 TBs running on 10gR2, 11gR2, Windows, Solaris 9/10, Red Hat; EMC Clariion

 

Sumitomo Mitsui Banking Corporation (SBMC)

(Via URimagination, Vyvoa Consulting, LLP), NYC, NY                                           6/2012 – 09/2012

Sr. Data Architect - Technical Lead

 

A DB Architect Principal Technical Lead for the Oracle Enterprise Manager 12c Implementation Project.

 

·         Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several database and components to be managed with OEM 12c: vendor’s products and technologies: Oracle9i/10g/11g, GoldenGate bi-directional (Active-Active), MS-SQL Sever (2005/2008/2010), Oracle Times-Ten, NoSQL open source projects Greenplum, WebLogic (10/11/12c) OEM 11g/12c

·         Assist SMBC with installation, configuration and testing of OEM 12c

·         Create rules specific to SMBC requirements on Oracle Enterprise Manager 12c (OEM 12c) for SLA’s requirements

·         Assisted with the design OEM 12c architecture and deployment plan.

·         Assisted in validating and preparing your server for installation.

·         Assisted with the install and configuration of SOA/WLS BI/Reports Publishing Server Management pack.

·         Assisted with the design for Oracle Provisioning and Patch Automation Pack Oracle Configuration Management Pack.

·         Assisted with the install and configuration of base monitoring for web center portal and enterprise content.

Environment: OLTP and DSS system DBs sized from 150Gs up to 50 TBs running on 10gR2, 11gR2, PostgreSQL, Greenplum DCA 4.0 full-rack, EnterpriseDB, Oracle Exadata x2/3, Solaris 9/10, Red Hat; EMC Clariion X3 M80, Hitachi AMS, 500, 2100, 2300, Cisco, Greenplum

 

Bank of America Merrill Lynch (via URimagination), NYC, NY                  12/2006 – 05/2012

Sr. Lead Data Architect / Sr. DB Manager Principal Consultant

Global Wealth and Investment Management (GWIM)

 

As Sr. Technical Lead/ Data Architect with direct hands on, I actively participated in DB/middleware/application tuning, performance capacity assessments and implementation of recommended enhancements for BoA’s Online Brokerage portal, a web-base transactional system generating over $100 million in annual revenues.  As a result of our improvements, BoA’s Brokerage portal, moved from 300^th position to the top 24 for response time and top 9 for availability on industry benchmark charts. Further more the global cash deposit rate increased by 80% globally for entire organization.

 

·         Managed and led geographically and culturally diverse team (7 database administrators, 9 developers and several other support engineers based in London, Bangalore, Romania, Istanbul)

·         Coordinated efforts between in-house and outsourced teams, data center managers (New Jersey, Chicago, Santa Clara) and major vendors (Oracle, Sun, several other hosting providers such as Savvis, SunGuard)

·         Tracked projects with MS Project and provided status reporting to management; implemented process and policy changes to enforce proper application change control.

·         Led regular global team and stakeholder meetings to discuss and prioritize necessary enhancements to database environment and resolve issues such as security and proper use of database accounts and data by implementing separation of duties.

·         Technical Lead for a big-data project team for the migration of several databases from Oracle OLTPs/DWHs to Greenplum DCAs this included Lead responsible for the migration and conversion of several enterprise databases running on Oracle to PostgreSQL using ora2pg utility along with admin tools such PGAdmin

·<span style="font:7pt 'Times