SUMMARY:

• A senior Cloud DevOps Developer and Architect with 20+ years of experience in working in IT.
• Worked with Oracle e - Business Suite, OBIEE, BI Publisher, OBIA, ODI, Microsoft Azure and Amazon Web Services (AWS) Cloud environments.
• Implemented DevOps and DevOps Automation tasks using Ansible, Puppet, Chef, PowerShell, Jenkins, GIT, Docker, Agile, Sprint, Python scripting, Ruby on Rails scripting, and other tools.
• Performed Oracle Database and Cloud Administrator, and Team Lead and Manager experience.
• Designed and architected Cloud SaaS, Paas and IaaS Models, Infrastructure as Code (IAC), and implemented Planning and Budgeting Cloud Service (PBCS), Cloud Migration Strategies, and Applications and Database Consolidations, along with Cloud Instance Creations and Orchestrations.
• I have a broad range of technical expertise coupled with highly effective communication skills.

PROFESSIONAL EXPERIENCE:

DevOps, Cloud Engineer & DBA

Confidential, Chicago, IL

Responsibilities:

• Worked with Oracle BI Cloud Service (BICS) and OBIEE.
• Worked with DevOps and DevOps Automation tasks using Ansible, Puppet, Chef, PowerShell, Jenkins, GIT, Docker, Agile, Sprint, Python scripting, Ruby on Rails scripting and other tools.
• Worked with Oracle Cloud, MS-Azure and AWS.
• Worked as an Oracle OCI-C, AWS and MS-Azure Cloud Engineer and Database Administrator.
• Developed IAC scripts and worked with REST APIs, and Linux; all for the Plan, Code, Build, Test, Release, Deploy, Operate and Monitor DevOps Life-Cycle phases.
• Worked with Oracle Cloud Infrastructure Classic (OCI-C), managed VM instances’ orchestrations, and their associated Storage and Networking resources, OCI-C MyServices, Dashboard, and the environment Consoles.
• Worked with Representational State Transfer (REST) API to create Cloud Instance VM and resources from the Compute Classic Web Console.
• Setup Secured Shell (SSH) authentications in Cloud and in MobaXterm for secured Server access.
• Worked with F5 IP Load Balancing layers 4 and 7, and Network routing with the Oracle Corporation team regarding the public and private networking and connections for the entire environment.
• Performed Oracle RAC Database Administration and Performance activities on several of the DB Instances, including working with the OEM Cloud Control 13c.
• Applied Oracle Patches to the DB Instances. Opened SR ticket with Oracle, FTPd some of the log files to them for review due to security and privilege issues between the Oracle Patch and the environment, and worked with them in applying the patches both via the Cloud’s Web User Interface, and also manually via the command prompt.
• Worked with Oracle RMAN scripts for nightly, weekly and monthly backups.

Confidential, Chicago, IL

Senior Oracle DBA & Cloud Engineer

Responsibilities:

• Implemented Oracle Business Intelligence Systems, and customized Data Warehouses using OBIEE, OBIA and ODI.
• Developed OBIEE Analysis, Dashboards, KPIs, and BI Publisher reports, and customized the OBIEE RPD meta data repository in the Physical, Data Mapping and Modeling and Presentation Layers, and developed ODI interfaces.
• Performed Oracle EBS administrative tasks that included creating users, groups, roles, profile options via LDAP and EBS, managing the Oracle Fusion Middleware and WebLogic environment, managing the Oracle Database daily, weekly and monthly tasks from maintenance to backups to performance tuning to cloning to patching, managing security, managing OAM, Identity Manager, OID & SOA, managing workflows, creating and managing Key and Descriptive Flexfields, and Executing the MD-120 tasks that developers fill out for us DBAs to execute in the TEST, UAT, PRE-PROD and PROD environments, to implement their programs.
• Team led both Onshore and Offshore teams in the USA and India.
• Received official Oracle University on Oracle Cloud Infrastructure Classic (OCI-C). n Microsoft Azure Cloud Administration and PowerShell.
• Got trained also on AWS Cloud and DevOps in the areas of Ansible, Ansible Tower Dashboard Interface, Jenkins, GitHub, Docker, REST APIs, Agile, Sprint, Python scripting, Ruby on Rails scripting, and other tools.
• Developed IAC DevOps scripts for Plan, Code, Build, Test, Release, Deploy, Operate and Monitor DevOps Life-Cycle phases with other developers.
• Worked with AWS EC2, CloudFormation, CodeDeploy, CodePipeline, ElastiCache, CloudFront, Serverless Architecture with Lambda, CloudWatch, EC2 Clusters, Network Configurations, VPC, Public and Private Subnets, IAM Security.
• Performed Data Modeling and Architecture Tasks using AWS RedShift.
• Performed DBA activities as an Azure SQL Database Administrator for one of the clients that I was supporting.
• Performed DevOps tasks using Ansible, Ansible Tower Dashboard Interface, PowerShell, Jenkins, GitHub, Docker, Selenium, and REST APIs.
• Performed analysis, PBCS, built PowerPoint Decks, and worked hands-on on the implementation and deployment of the customers’ environments, platform and software applications on Microsoft Azure and Oracle Cloud environments covering the SaaS, PaaS and IaaS aspects of it.
• Provided analysis on implementing the Security and Privacy, Storage, Recovery, API, Scheduler and Automation Services for the Cloud environments.
• Created and managed VM instances, Storage and SSH authentication and Networking resources’ orchestrations.
• Worked with F5 IP Load Balancing layers 4 and 7, and Network routing for Private and Public networks and connections for the entire environment.
• Worked with OCI-C MyServices, Dashboard, and the environment Consoles, REST APIs to create and manage instances, and Computer Classic Web Console.
• Setup Secured Shell (SSH) authentications in Cloud and in PUTTY and MobaXterm for secured Server access.
• Worked with Oracle RMAN scripts for nightly, weekly and monthly backups.
• Performed Administration tasks using Oracle Real Application Clusters that ran on Grid Infrastructure and Clusterware, and Oracle Enterprise Manager 12c for Oracle Database 11g and Oracle e-Business Suite R12 (EBS).
• Worked on planning Backup and Recovery strategies and testing using Oracle RMAN and Data Guard (both physical and standby).
• Managed and maintained the Oracle Database Instances.
• Applied Oracle Patches to the DB Instances. Worked with Oracle Service Request tickets.
• Worked on Oracle Cloud Administration.
• Worked on Linux Shell scripting with other Admins for nightly job processes.
• Performed OEM and Weblogic administration tasks in managing the OBIEE environment and the Weblogic Groups, Roles and Users' privileges.
• Performed Administration tasks in the Oracle Data Integrator environment and deployments.
• Managed and Administered the Oracle Business Intelligence Applications (OBIA).
• Used PVCS for source code and files’ version control.

Confidential, Chicago, IL

Senior Oracle Consultant

Responsibilities:

• Performed SQL Tuning and Oracle Database Administration tasks.
• Worked on Administration tasks in the Development and Testing environments for the Oracle Database and the Oracle Applications environment.
• Used PVCS for source code and files’ version control.

Confidential, Deerfield, IL

Senior Oracle Lead

Responsibilities:

• Performed Oracle EBS administrative tasks that included creating users, groups, roles, profile options via LDAP and EBS, managing the Oracle Fusion Middleware and WebLogic environment, managing the Oracle Database daily, weekly and monthly tasks from maintenance to backups to performance tuning to cloning to patching, managing security, managing OAM, Identity Manager, OID & SOA, managing workflows, creating and managing Key and Descriptive Flexfields, and Executing the MD-120 tasks that developers fill out for us DBAs to execute in the TEST, UAT, PRE-PROD and PROD environments, to implement their programs.
• Also performed Database and System partitioning on an Operating System and Database levels.
• Worked with Oracle Automatic Storage Management (ASM) and Oracle Backups.
• Engaged the BI and DB Teams regarding performance tuning and improvement, and implemented the environment changes in the areas of Ragged Hierarchies, DB Partitioning, Query Tuning, and Indexes, and Database Administration tasks.
• Installed and configured Oracle DB 11g R12, OBIEE 11.1.1.7, ODI 11.1.1.7 and Oracle BI Apps 11.1.1.7.1 on a test Virtual Machine.
• Developed the Installation and Configuration Guide document for the OBIA tools.
• Worked on performance tuning on SQL and PL/SQL programs, and environment tuning using OEM, Automatic Workload Repository (AWR), AWR and In-Memory Statistics, Active Session History (ASH), and Oracle Performance Hub, along with Partitioning.
• EBS Administration in the DEV and TEST environments between different Responsibilities for certain Functional requirements.
• Worked on Linux Shell scripting with other Admins for nightly job processes.
• Used PVCS for source code and files’ version control.

Confidential, Long Island City, NY

Oracle BI and DB Administration Consultant

Responsibilities:

• This was a position with State and Local with NYCSCA, which is under the Department of .
• Responsible for System and Oracle Database Administration for Oracle Discoverer and OBIEE.
• Administered and Maintained all of the Oracle Discoverer Environments for DEVs, UAT, TEST and PROD using the Oracle Discoverer Administrator tool, Client, Discoverer Plus and Viewer, covering the EUL, Business Areas, Responsibilities, Folders, Reports’ Maintenance, and Reports’ Migrations within the Oracle EBS 11i Environment.
• Performed Oracle EBS administrative tasks for several environments in support of the EBS and Discoverer, along with the environment’s database programs, security and access.
• For a period of five months, I was the sole Oracle Discoverer and OBIEE Administrator and Developer for all of the Environments, Reports and Dashboards due to emergency reasons that kept my co-worker out of the country. I maintained all of the environments of DEVs (DEV1, 2 and 3), UAT, TEST and PROD efficiently and successfully, and developed new reports, and modified existing reports based on SCA’s formal standards and procedures of Users’ requests and Managers’ Approvals.
• Undergone Discoverer Business Areas’ remapping from the old Oracle Materialized Views that were querying off of the old Sybase Database via Database Links, to new Oracle Tables. This required refreshing of the Business Areas and recreation of many of the existing Joins that were already in place that got either corrupted or dropped, since much of the Materialized Views’ columns were case sensitive and were enclosed in double quotes, and the new Oracle tables weren’t. The IT department’s new policy required that all of the Oracle tables’ columns to be created without being enclosed in double quotes. The remapping also required modifications for the SQL-Based Business Areas’ Folders and their joins.
• Administered and Maintained OBIEE 10g’s Services, BI Server, iBot and Scheduler, BI Publisher, and the OBIEE Repository.
• Successfully installed and configured OBIEE 11g for Testing, and developed two detailed documents that gave analysis and details on the differences and the advantages and disadvantages between OBIEE 11g, OBIEE 10g and Crystal Reports.
• Worked with Oracle Forms and Reports to investigate reports and data conversions into Oracle OBIEE.
• Used PVCS for version control for all of the Program, Request, and Documentation files.
• Worked on Linux Shell scripting with other Admins for nightly job processes.
• Performed SQL Tuning for SQL and PL/SQL Programs, and environment performance using OEM, Automatic Workload Repository (AWR), AWR and In-Memory Statistics, Active Session History (ASH), and Oracle Performance Hub.
• Performed Cache Management and Tuning on the OBIEE 10g Environments.
• Performed Turning and Cache Management on the Oracle BI Publisher Environments.
• Worked on performance tuning on SQL and PL/SQL programs, and also on Table Partitioning.
• Developed an OBIEE Manual for the End Users.
• Developed Oracle PL/SQL and Oracle SQL Programs against the Oracle EBS 11i Tables that also covered working with and developing Materialized Views, Views, and DB-Links that connected to the Sybase System.
• Taught in a formal class room setting End Users and Managers on how to use Oracle Business Intelligence Enterprise Edition 10g, using the book and labs that I developed for the company.
• Conducted one-on-one on Oracle BI Publisher and OBIEE to two workmates.
• Worked on Customizations in EBS DEV, and performed Administration work between Responsibilities for certain Functional requirements.
• Used PVCS for source code and files’ version control.