EXPERIENCE SUMMARY

• Confidential is very energetic and has excellent analytical, problem solving, communication and leadership skills. He has worked in Technology, Wireless, Medical, Energy, Finance, and Insurance industries, and has led multiple projects successfully in highly dynamic and demanding environments.
• As solution architect and Hands on person, he has expert sills in development, data modelling, application and data integration, Administration, related to Enterprise applications and Big Data analytics. He has valuable experience in infrastructure tuning and developing applications dat are scalable both in cloud and hybrid. He is instrumental in delivering multiple projects and developing products with AWS, NoSQL technologies like Cassandra, HBase and Hadoop echo system.
• He has good understanding of wide variety of databases such as Oracle, MySQL and Mongodb, and deep knowledge of internals in Clustering, Disaster recovery, Middleware, and E - Business suite. He has contributed chapters for Oracle DBA Fundamentals book, published by Tata-McGraw-Hill.
• He has worked at various capacities as Team Lead, Manager, Vice President and has very good leadership skills. He is a subject matter specialist and can collaborate on teams with a variety of technical and non-technical skill sets in successfully delivery of various projects.

PROFESSIONAL EXPERIENCE

Confidential, Houston

Bigdata Architect

Responsibilities:

• Evaluation and implementation of NoSQL database, Apache Cassandra, Hadoop clusters, Spark, and Kafka.
• Responsible for managing Cassandra cluster and migrating the database to Cassandra
• Carried out design and Data modelling needed for Cassandra
• Configuring and administration of Bigdata echo system and building data pipelines.
• Familiar with Hbase, Hive, Oozie, Zookeper and query engines like Drill, and Phoenix.
• Overseeing development team responsible for data ingestion and data quality.
• Migrating databases to AWS and familiar with Amazon cloud and Redshift.
• Maintenance of clusters and troubleshooting the log files using shell scripting.
• Automation using Ansible and shell scripts.
• Provide installation, configuration, maintenance and troubleshooting support for database application software both on premises and in the Cloud.
• Responsible for delivering of projects related to reference data including analysis, database design, development and maintaining information Architecture.
• Capacity planning and developing solutions for compression, Retention and Purging, Audit andsecurity compliance by coordinating with multiple cross teams.
• Developed framework for replication of data from upstream application coming in XML to database.
• Familiar with Agile process and Devop tools such as Jenkins, GitHub and automated steps using shell scripting and Python.
• Developed framework for replication of data from upstream application coming in XML to Oracle database.
• Responsible for Administrating and tuning of Oracle Exadata x5-2, OEM13c and Golden gate replication.
• Migrating databases to Exadata and upgrading to 12c.
• Responsible for data architecture and tuning of dataware house environments
• Responsible for administration and migration of data of Oracle and Mongo dB databases.
• Familiar with AWS components such as EC2, S3, RDS, ELB, Security Group, VPC, Subnet, Route table, EFS, Kinesis.

Lead Architect consultant

Confidential

Responsibilities:

• Responsible for Administrating and tuning of Orcle Exadata, OEM13c and Golden gate replication.
• Responsibe for tuning and supporting SQL Server databases.
• Migrating databases to Exadata and upgrading to 12c.
• Responsible for data architecture and tuning of dataware house environments.
• Migration of EBS environments from Solaris to Linux RAC environments on VM ware and Physical hosts of multiple production environments and responsible for capacity planning, Hardware sizing, Preparing Cutover plan, and implementing the projects successfully.
• Security upliftment at all levels and implementing Network DMZ, Unix Firewalls, EBS, RBAC, GRC, Data masking, Database VPD, File level encryption using GPG and PGP, Oracle Wallet Manager, openssl, XMLSEC for interfacing with Trading partners, single signon implementation using Oracle Access Manager autantication and authorization policies using OID.
• Implementation and administration of Fusion Middleware integration, Configuration of WebLogic 11g clusters, SOA composite development, BPM, OSB, Enterprise content management, configuring Apex, Single sign on (SSO) using OIM/OAD and handling the challenges with cloud computing related to Integration, security and performance.
• Implementation of Exadata, OBIEE, BI Apps, BI Publisher and BI Discoverer integration, ETL, Informatica, ODI, Dimensional Modeling and MDM.
• Troubleshooting and support of Golden gate replication.

Confidential, Houston

Architecting database solutions

Responsibilities:

• Seasoned Apps DBA and Team Lead for multiple E-Business suite implementation and upgrade projects (Oracle EBS 11.5.10 to 12.1.3 and 12.2) and Fusion middleware and carried out Global Implementation with SSL, PCP, Load Balancing, DMZ setup, iproducts and Multilanguage implementation.
• Administrating EBS 12.1.3 environment (Financial, HCM, and SCM) and auxiliary environments and setting up the DR environment.
• Proactively monitoring the complete stack of EBS, FMW and Oracle databases and alerting mechanism for the enterprise.
• Analyzed current architecture and proposed solutions to minimize EBS clone time and TEMPeffectively prepared scripts for having the EBS support environment to be available every day with automated nightly refresh from production.
• Managing sub systems associated with EBS like Vertex O-series, Apex SSO integration.
• Proactively monitoring databases and Troubleshooting Database issues using utilities like Hanganalyze, oradebug dumps (Heap dump, process state, error stack), stackx, OSwatcher, procwatcher, sqlt, awrsqlt, AWR, and SQL Plan Management.
• Automation of EBS clone scripts including SAN clones.
• Prepared scripts to monitor and tune concurrent jobs, workflows and OC4J settings.
• Providing support to Oracle UCM, Webcentre, oracle SSO, SOA cluster and BPM application and their databases including tuning, purging, restructuring and upgrading of the application.
• Generating wsdl and deploying services to integrate E-Business suite with other Financial products
• Creation and deployment of BPEL composite application having DB and Oracle Apps adapter.
• Clear understanding of SOAP, WSDL, XML, XSD, Business Rules, WLST, UDDI, WebLogic security architecture and implementation of policies.
• Implementing Web logic watches and notification to Monitor and alert Managed Server Logs for JVM issues.
• Upgrading of WebLogic, SOA and BPM application servers, and applying patches using smart update BSU.
• Deployment of weblogic jar, war and ejb files, and scripting of code migration and monitoring.
• Setup Health Check on a BIG-IP Load Balancer to Monitor E-Business Suite.
• Enhance corporate security standards and implement them at various levels including VPD, data Masking of the key tables in the databases, dbms encrypt, Wallet Manager.
• Providing secondary support to other database systems of SQL Server.

Confidential, Atlanta

Lead consultant

Responsibilities:

• Environment planning for Gold, Development, Configuration, Conversion, system Testing, Integration Testing and UAT serving multiple projects and releases including their refresh cycles.
• Performance tuning and troubleshooting of Exadata data loads for the dataware house environment.
• Responsible for leading and managing infrastructure projects related to Exadata x3-2 half rack implementation
• Prepared scripts and familiar with Exadata management of database nodes and storage servers using dcli, celcli.
• Carried out Capacity planning based on space, IOPS and throughput needs and working with SAN admins to have the SLAs met. Prepared scripts to generate capacity planning reports from Dictionary views.
• Prepared plan for E-Business suite 12.1.3 reimplementation from 11.5.10 and leading database team to carry out the implementation.
• Designed cloud solution to meet seamless integration between internal and External (for Mobile apps connection) access of analytics with LDAP for identification.
• Integration of Oracle quoting with salesforce.com with custom SSO using appsdatasource, SAML Tokens and custom coding.
• Implementing and managing Fusion middleware 11g (WebLogic, SOA, OSB, BAM and ODI servers) with High availability options
• Troubleshooting performance issues in Exadata and making sure the plans take advantage of cell offloading smart scans and other features.
• Leveraging ZFS pool to make snaps for long running patches on oracle apps to rollback point in time and ZFS compression to reduce backup space and time by 60%.
• Configuring XML Gateway with OTA in EBS and resolving issues related to trading partner firewall.
• Implementing Customer Data Hub (CDH) as Master data management (MDM) and cascading the information to hub systems using SOA
• Implementing Bi analytics Apps for Financials, HR and Sales Analytics using OBIE 11.1.1.5 and BI apps 7.9.6.3 with DAC 10.1.3.4 and Informatica 9.0.1 and Hot fix2
• Evaluating options to integrate salesforce.com for building sales analytics using universal adapter and FCS third party product.
• Created security policies and deployment scripts.
• Created Notifications and diagnostics in weblogic server monitoring for errors and other events.
• Performance tuning and troubleshooting of exadata for the datawarehouse environment.
• Implementing Oracle Secure Enterprise Search 11.1.2., Oracle Data integrator 11.1.1.5, OBIE Horizontal scalaing, EPM Hyperion Financial Close Management 11.1.2.2 (Close manager and Account Reconciliation manager) and Vertex 6.0, WellsFargo Adapter for payables
• Working with network team in implementing F5 Big IP with LTM and web accelerator for optimizing WAN traffic and SSL for EBS.
• Designed and implemented Datawarehouse environments and have experience on Exadata, OBIEE, Goldengate replication, ETL, Informatica, ODI, Dimensional Modeling and MDM

Confidential

Lead consultant

Responsibilities:

• Preparing cutover plan, and making sure all integration pieces are working with multiple iterations, and reducing the total down time of major upgrade of EBS
• Automated printers move from AIX to Linux pass through via Windows OS needed for Apps report printing, printer setups, Menus, responsibilities and other functionalities reducing the manual tasks needed during cutover.
• Tuning JVM, memory settings for garbage collection, and purging of SOA MDS repository for optimal performance
• Migrating Concurrent Manager from IBM AIX to Linux and configuring shared Application Tiers and resolving issues related to them and integrating OBIEE, Noetix Reports, Loftware printing, More4apps, and SOA.
• Reduced monthly refresh time from 18 hours to 2 hours and space usage from 18TB to 6TB for building 6 different environments (Dev, Test & Project environment each of 3 TB) by leveraging combination of ASM, EMC Snap clones and standby database, and intermediate database for post steps and automating using shell scripts.
• Scripting and automating Sysadmin tasks and DBA Tasks related to printer setups, Menus, responsibilities and other functionalities reducing the manual tasks needed during cutover.
• Configuring External servers with DMZ and resolving issues to support modules like isuppliers, iprocrurement, ireceivables.etc.
• Automation of print queue move from Linux to windows dat supports EBS.
• Tuning critical and mandatory Concurrent jobs such as DQM stage data, Geo name referencing workers, custom patches and Apps patches to reduce time for post upgrade steps from 14Hr to 3 Hrs.
• Leveraging technology advancements like pre-staging the Application Technology stack, Distributed AD, importing/exporting stats to minimize cutover time.
• Working with Datawarehouse Admin in tuning ETL jobs related to OBIEE BI Apps.
• Troubleshooting OAF personalization, installing weblogic server 11g, Deploying ADF application and integrating with E-Business suite.
• Automated printers move from AIX to Linux pass through via Windows OS needed for Apps report printing
• Resolving issues related to setups, configurations, patches, DR Testing and playing a key role in successful implementation of the project.
• Preparing and enhancing the cutover ocument with the steps needed for the upgrade.
• Environment planning and preparing the plan for patch deployment.
• Migrating Concurrent Manager from IBM AIX to Linux and configuring shared Application Tiers and resolving issues related to them.
• Configuring XML Gateway with OTA and resolving issues with Trading partners firewall issues.
• Customization of initialization variables and managing all database parameters using context file.
• Implemented 11g Active Dataguard and 10g Dataguard and carried out dry run for switchover and automated steps to monitor log gap and deletion of archive logs and tuning of network settings based on BDP.
• Reduced CAPEX by Converting VERITAS powerpath to Solaris mpxio, VERITAS File system to ASM and carried out dis conversion in the least amount of time.
• Reduced RACK space by server consolidation and zoning and making dis effort of migration of large databases to be accomplished in less TEMPthan an hour.
• Evaluated the options to improve backup operations and worked with Unix Team to create private LAN and server free backups to segregate backup traffic and Database Link traffic.
• Implemented 11g Gateway to establish connectivity between Oracle and AS400.
• Configured and installed 11g RAC with multiple interconnects for HA and Jumbo Frames for interconnects to improve cluster performance by 20%.
• Implemented security using TDE, AES, and FGA to meet security compliance and supported Federal auditing.
• Monitoring Databases using OSwatcher, Procwatcher, AWR, hanganalyze, systemstate dumps, cluster Health Monitor, racdiag, SQL Tuning advisor…etc
• Upgraded OEM from 10g to 11g and implemented E-Business suite Application Management packs.
• Responsible for managing multiple Oracle 10g & 11g RAC Databases (OLTP & Dataware House) on Sun Solaris 10 both Development and Production environments of sizes ranging from 200GB to 6TB with thousands of transactions per second.
• Upgraded multiple Databases (RAC and Non RAC) from 10g to 11.2.0.2 with planning, coordinating and implementing it by minimizing the risks and reducing downtime with transient logical standby.
• E-Business suite upgraded from11.5.10 to 12.1.3 and coordinating the efforts with Business Team.
• Optimizing Oracle Apps Upgrade process and reducing the upgrade window by 3 fold by Tuning, Staging, automating various tasks and accomplishing Database upgrade, Server Migration and Oracle Apps Upgrade.
• Environment planning, Impact analysis, creating process for patching and merging with Production changes, laying out process related to change control.
• Prepared Presentations for Technical Team and Functional Teams for R12 Upgrade showing the differences and new features in the stack.
• Automating tasks for custom patching, Apps patching on multi nodes, Cloning and configuration setups and sysadmin tasks.
• Maintain Databases and Oracle E-Business Suite up to date by applying quarterly PSU and CPU patches, upgrades related to weblogic server, ATG, Forms, JDK and family Product patches and cloning.
• Responsible for Creating custom reports using BI Publisher (XML Publisher) in E-business suite.
• Implemented SSL on Oracle Apps and split Concurrent manager and Web & Forms of E-Business suite and shared Application Tiers.