SUMMARY

• AWS Solution Architect Associate Certified
• More TEMPthan 7 years of programming experience in Analysis, Design and Implementation of Business Applications using Oracle Database
• Profound knowledge in Oracle Internet Developer Suite (Oracle Forms and Report 10g).
• Hands on expertise databases using Oracle11g/10g, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Experienced in Oracle Hyperion Financial Management Infrastructure support. For e.g. Setting up users in Shared Services, Creating new application, performing application copies, load Metadata through Workspace, Monitor FDMEE load imports. Recycle of complete environment etc.
• Hands on experience in Oracle Database Administration tasks such as Monitoring of Tablespaces and sending weekly report to stakeholders, Perform query tuning and performance monitoring, Perform Export/Import of Database/Schema, Extracting AWR/ADDM reports for performance monitoring and troubleshooting
• Profound knowledge in developing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• Loaded Data into Oracle Tables using SQL Loader
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Installation, Configuration & Deployment ofOracle Internet Developer Suite 10g
• Proficient in deployment of Database related source code related changes.
• Performed and led Database Migrations for upgrading the DB server version
• Working experience on IP Switch MoveIT. Adding and Modifying users in MoveIT.
• Thorough knowledge and experience in maintenance of sites in WSFTP Pro software.
• Suggested client to implement CA Autosys Workload Automation tool and successfully implemented it in Development and Production environment. This resulted in Process Improvement.
• Result - Driven, Customer-Focused, Strong analytical and problem solving skills.
• Excellent team player wif strong communication and interpersonal skills.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX Shell script, Windows Batch script

Operating Systems: HP Unix, AIX,Windows NT/ 2012 Server, LINUX

Databases: Oracle 10g, 11g, 12c, AWS RDS, MS SQL 2012

Tools: Oracle IDS 10g, TOAD, SQL Plus, SQL Loader, Microsoft SQL Server Management Studio 2012, Oracle Hyperion Financial Management, Financial Data Management Enterprise Edition, AWS Console, AWS CLI

Reporting Tool: Oracle Reports 10g

SSH Tools: Putty, WinSCP, IP Switch WSFTP Pro

Other: MoveIT, CA Autosys Workload Automation, PGP Encryption, AWS (EC2, ELBs, S3, VPC etc)

Ticketing Tool: BMC Remedy - Incident Managemet, Change Management, Release Management

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Collaborate wif stakeholders and application team to identify the target database (AWS RDS/Aurora).
• Perform Proof of Concept for migrating on-prem Database to AWS.
• Migrate Database using AWS DMS.
• Post-migration activities for certain database objects dat can’t be migrated automatically.
• Document all dependencies & process to replicate for more apps.
• Worked wif application team to perform Smoke testing and complete UAT.

Confidential, Morris Plains, NJ

Oracle Hyperion Financial Management

Responsibilities:

• Extract and load miscellaneous data in HFM and Planning. Support Hyperion FDM to support business users during the monthly close process and updating FDM load templates as needed.
• Support global end users wif HFM and Hyperion Planning (including forms, grids, Smart View etc). Monitor FDMEE batch loads, consolidations and Batch job.
• Daily health check-up of servers. Raising Change requests and Managing end to end delivery of the Change request be it Hardware or Software for application servers.
• Troubleshoot high severity issues in Oracle Databases, lead the technical bridge and follow up till closure. Review of Root cause analysis/effort estimate for defect/change request/enhancement and Impact analysis/ Effort estimate for Change Control.
• Deployment of Database related source code related changes.
• Monitoring of Tablespaces and sending weekly report to stakeholders.
• Perform query tuning and performance monitoring, Perform Export/Import of Database/Schema. Extracting AWR/ADDM reports for performance monitoring and troubleshooting.
• Creating new application, performing application copies, load Metadata through Workspace, Monitor FDMEE load imports. Recycle of complete environment. Resolve Smart view, EPM Maestro issues.
• Created Shell Scripts/Windows batch scripts for invoking SQL scripts and scheduled them using crontab/Task Scheduler

Confidential, Morris Plains, NJ

Oracle Applications DBA

Responsibilities:

• Hands on experience in Oracle Database Administration tasks such as Monitoring of Tablespaces and sending weekly report to stakeholders.
• Performed query tuning and performance monitoring.
• Performed Export/Import of Database/Schema, Extracting AWR/ADDM reports for performance monitoring and troubleshooting
• Profound knowledge in developing and deploying Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• Loaded Data into Oracle Tables using SQL Loader.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Installation, Configuration & Deployment ofOracle databases.
• Proficient in deployment of Database related source code related changes.
• Performed and led Database Migrations for upgrading the DB server version.
• Prepared run books per the details provided by the client. Reviewed document developed or modified by peers. Deployment of Code in Production and QA.
• Daily checking Server Availability, Response time, Space and other critical items. Raising requests to carry out changes in Server Hardware and end to end management.

Confidential

Treasury Applications

Responsibilities:

• Troubleshoot issues wif Oracle Forms and Reports 10g. Deploy sql code as and when needed.
• Develop reports using SQL queries based on user requirements. Collaborate wif Server team and Physical DBA team during patching or any outages.
• Develop PL/SQL packages, procedure, functions to implement business logic.
• Monitoring Batch jobs in both Windows and Linux environment. Load Data into Oracle Tables using SQL Loader.
• Create Shell Scripts for invoking SQL scripts and scheduled them using crontab