| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCell: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLECandidate's Name
Production/Application Support AnalystSUMMARYPerformance oriented Production Support /Data Analyst/DB Deployments with proven success in developing multiple projects for Financial, banking, health Care, E-commerce industries. Over ten years of hands-on experience in Database Production Support /Database Deployments for various applications and Supporting for Implementing the for-performance changes/tuning as for dbas on very large databases.PROFESSIONAL PROFILEHaving Over 14+ years of IT-experience in various roles like Production/Application Support/Deployment Activities, Data Analyst, DB Deployments/ Release Activates, DB Testing.10 + years of experience with Oracle 8i, 9i, 10g, 11g R1, 11g R2,12c working as Oracle Production Support/Application Support, Data Analyst and Supporting for DB Deployments, Supporting for developers for back-end modules, such as packages, functions, procedures triggers, object types, views, materialized views, and snapshots for multitier business applications, both Data Warehouses and OLTP systems.Having Good Application Production Support Experience with OFSAA (Oracle Financial Services Analytical Applications) In Wells Fargo and even lower (IFT/UAT) Environments a as well.Having Good Application Production Support Experience for NON-Financial - Regulatory Reports -Global Regulatory Reporting Services in Bank of America.Having Good Support Experience with Autosys Jobs which are scheduled for daily, Monthly, and making sure those to complete it as schedule and Monitor those Jobs in OFSAA and make sure all the tasks are completed for those Scheduled Jobs.Having Good Support Experience with IT2-Treasury Application for Payments/Wires from Different Banks and Tracks incoming and outgoing funds across all bank accounts, providing real-time visibility into cash positions.Having Good Experience in Executing/Monitoring the OFSAA Jobs through OFSAA UI and Making sure all the Tasks are completed the Co-corresponding Job In the production as wells in the Lower (IFT/UAT) Environments.Experience in managing OLTP databases in a 24X7 production support for Different Databases and different Environments to handle large volume of data.Extensively used the Splunk to Monitor the Java/.Net based Applications for Alert and Logs.Responsible for monitoring and supporting L2 for the EONE-ORRS Jobs On 24 * 7 basis which are Scheduled in the Autosys for Daily, Monthly, Reg-run in Production Environment.Extensively Supported Release/Deployment Activities like using GitHub, Jenkins, CI/CD Pipelines, CloudBees and Creating Change Requests for Production Env releases and Bug Fixes.Extensively Supported for ETL -Tools Like DataStage, Informatica and Data flow Jobs which are scheduled in the Autosys from Upstream systems files Processing to our system and finding the logs and root Cause Analysis If at all any ETL Job Failes.Activities like using GitHub, Jenkins, CI/CD Pipelines, CloudBees and Creating Change Requests for Production Env releases and Bug Fixes.Having Good Experience for Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions for Failures and closing the PTs in PAC2000 and Incidents in Service now.Having Good Application Support Experience with Decision tool and Payment Plan Application in the Wells Fargo Bank in the Ecar Project.Having good Experience in Validating the Data in production systems and loading those data in lower Environments like IFT/UAT/MOCK and PROD-FIX and validating the Data as for requirements.Having 5 + years of Good Experience in Production support for GTR-Rates Application Databases and supporting the Different Databases in Different Projects.Interaction With dbas Performance Tuning - Database and OS and Explain plan, Execution plan, plan table, hints, SQL tuning, Index tuning, AWR, ASH, SQL Profiles, and tkprof.Good Experience in Different Software Development life cycles (SDLCs) like waterfall, Agile.Experience in Support for Migration from Development Environment to SAT/INTG/QA/PSE AND PROD.Having good Production Support Experience in Different projects and Troubleshooting the Issues by finding the root cause of the issues.Experience in managing OLTP databases in a 24X7 production support for Different Databases and different Environments to handle large volume of data.Having Good support Experience in work Environment with Different Technologies Like Java, J2ee, .Net, and Mainframe.Extensive usage of Autosys Tool for scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.Experience using SQL*Navigator and TOAD for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.Involved in Writing Red hat Linux/Unix Shell Scripts for backups and batch/job scheduling and understanding the Perl scripts for batch jobs and extract reports.Experience in supporting the various production issues addressed by the users from the client side and providing them with the required solutions.Extensive experience in working with end users and documentation of business processes.TECHNICAL SKILLSOracle Tools: SQL*PLUS, TOAD, ORACLE, SQL Developer, PL/SQL Developer, Putty, Erwin, SOAP, Oxygen Editor, Oracle APEXOracle Utilities: Export/Import, Data Pump, SQL*LOADERLanguages: C, C++, HTML, Shell Scripting, Perl script, bash, SQL, PL/SQL, T-SQL, COBOL, JCL, CICS, Java, J2EE.Databases: MS Access, MS, VISIO, MS AZURE, Oracle 12c/11g/10g/9i, Vector wise, SQL Microsoft SQL Server 2012 and 2014, Teradata.Cloud Platform: Cloud AWS, Terraform, Gitlab, Build practiceMicrosoft Tools: MS- Visio, MS-Office, Autosys, ITIL, ITRS-Geneos, SPLUNK, AppDynamics, BMC-Remedy, Dynatrace.Internet/Other Tools: XML, HTTP, microservice, XSL, JavaScript, swagger, Fpmls, CSS, JQUERY, CCAR, TFS, IBM BPM, Tortoise SVN, Ultra Edit, ISO 8583 message standards, ISO20022 compliance, HP-ALM.Operating System: UNIX, Red Hat Linux, AIX, Solaris, Windows 9x/XP, MVS.ETL and Reporting TOOLS: Informatica, Autosys, SSIS, SSRS, Data Stage, cogons, Crystal Reports-2013, OBIEE, ODI, Essbase, Tableau, Business ObjectWORK EXPERIENCETIAA, Charlotte, NC June-23 to Still Date.Project: - GCST-IT2-Treasury Application.Position: Production Support Analyst/Application Support Analyst.Responsible for monitoring and supporting the IT2-Treasury Application Jobs On 24 * 7 basis which are Scheduled in the IT2-Treasury Portal for Daily, Monthly, Quarterly Jobs and Reports.Responsible for monitoring and supporting as L1 for the IT2-Treasury Jobs On 24 * 7 basis which are Scheduled in the IT2 Portal and monitoring the Upstream Jobs in Autosys for Daily, Monthly in Production Environment.Monitoring the Upstream Data Availability/Files in the Autosys Jobs are running or not as for Schedules and SLAs in the IT2-Portal and finding the logs/exceptions in the Unix portal servers and providing the basis root Cause Analysis and creating ServiceNow Tickets and created the Incidents in the ServiceNow, PBIs.Extensively used Splunk to Monitor the IT2- Treasury Application Job Failure Alerts and Applications Alerts and to View the Errors in the logs.Extensively Supported for ETL -DataStage tool and Data flow Jobs which are scheduled in the Autosys from Upstream systems files Processing to our system and finding the logs and root Cause Analysis If at all any Autosys/DataStage job Failes.Extensively Supported for Data flow from the Upstream (From where the data feed) system to Treasury Application and how the data flow and how the payments/wires will Populate and send the responses/Acks to those systems back.sand which are scheduled in the Autosys from Upstream systems files Processing to our system and finding the logs and root Cause Analysis If at all any Autosys/DataStage job Failes.Extensively used the Splunk to Monitor all systems, applications, hosts, data ingestion, Applications health and Health.Extensively used the Splunk to Capture Autosys Job Failures and to Provide the Job Failure Alerts/Incidents and Error Message for the Job Failure and Logs.Responsible for monitoring and supporting the IT2-Treasury Application for Payment Processing and Wire Transfers from Different Banks to Treasury Application through SWIFT/ Axletree Process.Responsible for monitoring and supporting the IT2-Treasury Application-Jobs for Payment Processing for Inbound (MT940, MT101) and Outbound Messages through Sterling Integrator -SI and SWIFT Processing.Responsible for monitoring and supporting the IT2-Treasury Application-Autosys Jobs for Payment Processing from Different systems like People soft, Murex, Nuveen, Frontier files and processing those files In Treasury system and sending the Ack/Outbound Messages to those Systems.Extensively Supported Release/Deployment Activities like using GitHub, Jenkins, CI/CD Pipelines, CloudBees and Creating Change Requests for Production Env releases and Executing the Deployment plan in the Production Environment.Environment: Production support, IT2-Application Support, Autosys, Sterling Integrator, snowflake, MQFTs, SPLUNK, Java, Service now, ISO 8583 message standards, Linux/Unix, DataStage, shell script.Bank of America, Charlotte, NC Sep-22-June-23.Project: - NFRR (NON-Financial - Regulatory Reports)-GRRS (Global Regulatory Reporting Services).Position: Production Support Analyst / Application Support Analyst for GRRS.Responsible for monitoring and Supporting the GRRS Reports On 24 * 7 basis which are Scheduled in the GRRS Portal for Daily, Monthly, Quarterly reports as for SLAs.Responsible for monitoring and supporting L1 for the GRRS Jobs On 24 * 7 basis which are Scheduled in the GRRS Portal and monitoring the Upstream Jobs in ITRS-Geneos and Autosys for Daily, Monthly in Production Environment.Monitoring the Upstream Data Availability-Snapshots in the ZinGo and making sure GRDS Jobs are running or not as for Schedules and SLAs in the ITRS and finding the logs/exceptions in the Unix portal servers and providing the basis root Cause Analysis and creating PAPA Tickets GRDS Team and created the Incidents in the BMC Remedy, PBIs, PKEs.Extensively used Splunk to Monitor the GRRS Application Job Failure Alerts and Applications Alerts and to View the Errors in the logs.Extensively used the Splunk to Monitor all systems, applications, hosts, data ingestion, Applications health and Health.Extensively used the Splunk to Capture Autosys Job Failures and to Provide the Job Failure Alerts/Incidents and Error Message for the Job Failure and Logs.Extensively Supported Release/Deployment Activities by Creating Change Requests for Production Env releases and Executing the deployment steps in the Production Env.Environment: Production support, GRRS-Application Support, Autosys, ITRS-Geneos, SPLUNK, Java, J2ee, AppDynamics, Dynatrace, BMC-Remedy, Autosys, ISO 8583 message standards, PAPA, Linux/Unix, shell script.Wells Fargo, Charlotte, NC Jan-19-Aug-22.Project: - EONE- (Enterprise ONE)-EONE-ORRS/RDR.Position: Production support/ Application Support Analyst for EONEBAU/RDR Team.Responsible for monitoring and providing application (OFSAA) support for eOne Project (EONE-ORRS/RDR-GLODS/DEX) for Data Mart Application to Generate Regulatory Reports.Responsible for monitoring the up and running of the databases / scheduled Autosys-Jobs in different environments like IFT/UAT/MOCK and Production for OFSAA (Oracle Financial Services Analytical Applications) and providing support for all the lower lane Test cycles and databases along with OFSAA Environment Validations.Responsible for monitoring and Supporting the EONE-ORRS Jobs On 24 * 7 basis which are Scheduled in the Autosys for Daily, Monthly, Reg-run in Production Environment and making sure all the Batchs/tasks are completed for each Job in the OFSAA(Oracle Financial Services Analytical Applications) UI and Monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues using Break glass(by Creating the Problem Ticket (PT)/Incidents in the PAC2000,service now ), Change Request(CR) and Work Order(WO).Extensively Keeping the Autosys Jobs On-Hold/OFF-HOLD/ON-ICE/OFF-ICE/Kill/Terminate as for the Dependency of the Job and Requirement of the Jobs.Extensively Supporting for the Lower Environments (IFT1,2,3,4,5/UAT1,2,3,4, 5) for Test cycles and Executing Autosys Jobs and Providing the Test cycle support and providing the solutions for Completion of the test cycle.Interacting with DEX (Data Exchange) Team, developers, Release Co-Ordinators, Test Co-Ordinators for test cycle Execution as for the plan/time and number of SORS Decided and working accordingly for completion of the test cycle.Extensively Using the Autosys Commands in Linux for Execution of the JobsResponsible and Supported for Developer for Creation of Database Design and Oracle database PL/SQL) Objects like Tables, views, Materialized Views, Sequences, Indexes, Procedures, Functions and Packages etc.Work closely with performance DBA Team for long running Jobs and as for the dbas Suggestion Implement the Performance changes like Gather stats for tables which are stale or adding Profiles or Hints or Indexes.Having Good Experience for Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions for Failures and closing the PTs in PAC2000.Provide data analysis and support and work in tandem with the dev team to support a set of data intensive applications.Works closely with ETL development team members and supports the ETL (Informatica, Ab Initio) Jobs and Support for Regulatory Reports generation using Lombard too.Extensively used Splunk to Monitor the eone-Application Job Failure Alerts and Applications Alerts and to View the Errors in the logs.Extensively used the Splunk to Monitor all systems, applications, hosts, data ingestion, Applications health and Health.Extensively used the Splunk to Capture Autosys Job Failures and to Provide the Job Failure Alerts/Incidents and Error Message for the Job Failure and Logs.Environment: Oracle 12c, OFSAA, OFSAA-Application support, ORACLE SQL Developer, Production support, SPLUNK, AppDynamics, Dynatrace, Autosys, Java, J2ee, PAC2000, ServiceNow, HP ALM (Application Lifecycle Management), Oracle Exadata, Batch Process, Linux/Unix, shell script.Advance Auto Parts (AAP), Roanoke, VA Aug-18-Dec-18.Project: - EC- (Enterprise Catalog)-Innovation Garage-Related Item Products.Position: Application/Production Support Analyst.Supported for Enterprise Catalog-Innovation Garage Related/Similar Item(link) Changes Application for Advance auto parts (AAP), Car Quest, NAC (Brakes, Batteries, Air filters) Products.Extensively Supported for Java Developers for Creation/calling of Different Java Services (using Oracle Database (tables) objects to develop Related Items and view Job changes for Advance Auto Parts Requirement (AAP).Extensively Supported for the Oracle Database Objects as for new requirements of the Related Items changes and View Job Package changes (Links) for AAP.Responsible for monitoring the up and running of the databases/scheduled corn-Jobs in different environments like INTG/QA/UAT for supporting the Enterprise Catalog Application.Responsible for monitoring and Supporting Enterprise Catalog Application Batch Jobs On 24 * 7 basis which are Scheduled in the Linux corn and monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues.Extensively Supported for creation of the Related Item table in different environments and loaded the data from AAP- Raleigh, NC Database (for Data setup) using Replication Tool Symmetric DS.Extensively working as Oracle 12c for developing the oracle Database Objects in development and qa Environment.Creating and supporting the Database for oracle 11g and oracle 12c.Coordinating and Providing the Support required for Front End Java Developers from backend.Monitoring the db Exceptions in t_sys_error table for QA/Staging/UAT Environment and Fixing the Exceptions which occurred on QA/ET/UAT Databases by identifying root cause of the Exceptions.Monitoring the Daily EC- corn Jobs and Monitoring the Data Load for all the EC-Systems.Created the Validations Scripts for EC- (Enterprise Catalog)-Innovation Garage Application and Created the code walkthrough and Unit Test Plan Documents.Environment: Oracle 11g, Oracle 12c, ORACLE SQL developer, Production support, PAC2000, Symmetric DS, WinSCP, MS Access, JIRA, Batch Process, Linux/Unix, shell script, Java, Java Services, Swagger, HTML.Wells Fargo, Charlotte, NC Mar-18-July-2018.Project: - ECaR- (Enterprise Collections and Recovery)- Decision tool and Payment Plan Application.Position: Production/Application Support Analyst.Responsible for monitoring the up and running of the databases / scheduled Autosys-Jobs in different environments like IFT/UAT/MOCK and Production for ECaR Application and providing support for all the lower lane databases.Responsible for monitoring and supporting the ECaR- (Enterprise Collections and Recovery) Jobs On 24 * 7 basis which are Scheduled in the Autosys for Daily-in Production Environment and making sure all the batches are completed and monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues.Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions for Failures and closing the PTs in PAC2000.Extensively Keeping the Autosys Jobs On-Hold/OFF-HOLD/ON-ICE/OFF-ICE/Kill/Terminate as for the Dependency of the Job and Requirement of the Jobs.Extensively Supporting for the Lower Environments (dev/QA/UAT) for Test cycles and Executing Autosys Jobs and Providing the Test cycle support and providing the solutions for Completion of the test cycle.Worked extensively Supported for developers for creation of tables, Dependency DDL and DML scripts, Constraints, Indexes, stored procedures, functions, and packages as for the Business Logic of the Decision tool and Payment Plan Application as for the Technical Design TD.Extensively Supported for Payment Plan application for Different Accounts like Cards, Retail Services, PLL-FDE, PLL-SHAW.extensively Supported for Batch Jobs for cards, Retail Services, PLL FDE and Shaw Accounts with payment plan for Generation of Non-Monetary (NM) Transactions.extensively Supported for Batch Job for Cards and Retailer Accounts for Cancelling or Completing a payment plan.Monitoring the db Exceptions in t_sys_error table for QA/ET/UAT Environment and Fixing the Exceptions which occurred on QA/ET/UAT Databases by identifying root cause of the Exceptions.Monitoring the Night Offs Jobs and Validating NM Transactions (APRV/REMOVE/CANCEL) Trans for Batch Process.Monitoring the tran_upld table to see all the NM Transactions are getting generated as for requirement for Different Accounts of the Wells Fargo.Monitoring the Daily Ecar- cron Jobs and Monitoring the Data Load for all the Ecar-Systems.Created the Validations Scripts for Decision tool and Payment Plan Application and created the TD, code walkthrough and Unit Test Plan Documents.Finding the db Exceptions in all environments (QA/UAT/PROD) by querying Exceptions table and finding the root cause forInteracting with client Management and product management for Data fixes and schedules for ALM release to production databases.Writing the sqls for Data fixes and implementing the sqls through dbas and production databases.Environment:Oracle 11g/12c, SQL Developer, Production support, Autosys, PAC2000, HP ALM (Application Lifecycle Management), SVN, Oracle Exadata, Batch Process, ISO 8583 message standards, Java, Linux/Unix, shell script.Xerox Corporation, Rochester, NY Jan-2017-Feb-2018.Project: - FT GLOBALPosition: Production Support Analyst/Data AnalystResponsible for monitoring the up and running of the databases in different environments like TEST/INT/UAT and Production for FT GLOBAL Application and providing support for all the lower lane databases.Responsible for monitoring and Supporting the FT GLOBAL Application Jobs On 24 * 7 basis which are Scheduled in the Autosys for Daily-in Production Environment and making sure all the batches are completed and monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues.Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions for Failures and closing the PTs in PAC2000.Extensively Supporting for the Lower Environments (dev/QA/UAT) for Test cycles and Executing Autosys Jobs and Providing the Test cycle support and providing the solutions.Finding the db Exceptions in all environments (TEST/UAT/PROD) by querying Exceptions table and finding the root cause for Exceptions and Providing the solutions for Issues.Interacting with client Management and product management for Data fixes and schedules for ALM release to production databases.Writing the SQLs for Data fixes and implementing the SQLs through dbas and production databases.Extensively Supported and created the External tables, Tables and Stage tables in the development Environment for Different DMO system Like Countries Argentina, CITG and all.Extensively Supported for creation The Procedures for Reading the External Tables and Loading the Data into Stage Tables.Worked extensively on creating tables, External Tables, Indexes, Views, stored procedures, functions, and packages as for the Business Logic of the FT-GLOBAL DMO-systems and application.Fixing the Exceptions which occurred on QA/prod Databases by identifying root cause of the Exceptions.Monitoring the Daily corn Jobs and Monitoring the Data Load for all the DMO-Systems.Supported and Coordinated with ETL (Informatica and Vector wise) Team for Data Extraction as part of End of the Day Report Generation Process in the Tableau.Environment: Oracle 11g, Oracle 12c, SQL Developer, Toad, Autosys, Informatica, Vector wise, Production support, Erwin, Putty, Tableau, MS Access, TFS, Linux/Unix, shell script, Java, Auto sys, clear Quest Defect Tracking, my Jira.DTCC, GTR Rates, NYC/NJ April-2012-Dec-2016.Position: Production Support Analyst/ DB Deployments.Extensively created the tables, views and Indexes in the development Environment for US Datacenter, Netherland Datacenter and Singapore Data center.Supported for Development for the PL/SQL Objects like Stored Procedures, Packages, and Functions for Rates applications based on the different regulators (CFTC, ESMA, HKMA, JFSA, ASIC, MAS) of the clients which supports for Dodd Frank rules.Having 5 + years of Good Experience in production support for GTR-Rates Application Databases and supporting the Rates lower environment Databases as well.Providing the production support for GTR-Rates Databases and fixing the Defects, Bugs, dB-exceptions and providing the root cause analysis and providing the solutions for defects.Fixing the Exceptions which occurred on pse/prod Databases by identifying root cause of the Exceptions.Extensive usage of Autosys Tool for scheduling the Extract Jobs and monitoring the jobs which are scheduled and running.Monitoring the scheduled Jobs in the Autosys and Identifying for the Job Delays and Issue for root cause Report Generation.Monitoring the Extract and ETL jobs in the Autosys and Estimating the Daily Reports generationCoordinated with ETL(Informatica) Team for Data Extraction as part of End of the Day Report Generation process.Extensively worked for GTR Rates Database Migrations from Dev to QA/PSE/PROD According to scheduled Dates.Working with entire Rates team members and collecting the db changes which are planned for qa and higher environments as for releases.Extensively worked for all the Datacenter (USDS, NLDC and SGDC) Migrations for Rates by creating the Arps Accordingly with client requirement and schedules.Working closely with dba and scm team and deploying (through scm) the db changes to different environments like qa/pse and prod and validating the required db changes present or not.Worked for Emergency db changes (OEMRS and EMRS) for different environments like pse and prod and deployed the changes through dbas.Finding the db Exceptions in all environments (qa/pse/prod) by querying Exceptions table and finding the root cause for Exceptions.Finding the Failed/Exceptional trades in the log files by connecting the Linux servers and identifying the failed trades for root cause.Environment: Oracle 11g, Oracle 12c, SQL Developer, Toad, Informatica, DataStage, Mainframe, Production support, Erwin, Putty, Autosys, SQL plus, TFS, COBOL, OBIEE, MS Access, Linux/Unix, Perl script, shell script, Java, java scripts,XML, SOAP, Oxygen editor, clear Quest Defect Tracking, my Jira.Department of Public Welfare, PACSES, Harrisburg, PA. (Sept-11- Mar-2012)PACSES- Pennsylvania Automated Child Support Enforcement System(Through Deloitte)Position: Production Support Analyst / Data Analyst.Responsible for monitoring the up and running of the databases in different environments like QA/INT/UAT and Production for PACSES Application and providing support for all the lower lane databases.Responsible for monitoring and Supporting the PACSES Mainframe batch Jobs On 24 * 7 basis which are Scheduled in the Daily-in Production Environment and making sure all the batches are completed and monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues.Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions.Extensively Supporting for the Lower Environments (INT/QA/UAT) for Test cycles and Executing Autosys Jobs and Providing the Test cycle support and providing the solutions.Monitoring the scheduled Jobs/batches Jobs in the cron Unix Environment and Identifying for the Job Delays and Generating the Daily Reports.Finding the db Exceptions in all environments (QA/UAT/PROD) by querying Exceptions table and finding the root cause for Exceptions and Providing the solutions for Issues.Writing the sqls for Data fixes and implementing the sqls through dbas and production databases.Involved extensive interaction with the users to determine their requirements.Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R).Created, Monitored, and implemented the solutions as required in a Service Request (SRs).Created the Control Files to load the data (Mainframe Systems) from flat files (Mainframe files) to open systems Using SQL LODER.Having Good Experience of using External Tables as a file to read the Mainframe flat files.Having Good Experience of Generating the Explain plan and execution plan for tuning the top SQLs and reduce the cost.Supported for the PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support and Enhancements or changes in the Existing Open systems Application.Supported for the developers for creating tables, Indexes, Views, stored procedures, functions, triggers, and packages As for the Business Logic of the application.Written the SQL Queries As for the data Request from the client and Open System Developers.Environment: Oracle 11g, SQL Developer, Toad, Putty, Erwin, Autosys, ODI, UNIX, Linux, Mainframe, Informatica, SSIS, Crystal Reports, OBIEE, Cognos, SQL plus, PL/SQL Developer, Autosys, clear case, mainframes, Java, .NET, Oracle Enterprise Manager (OEM).U.S. Department of commerce (DOC), Washington, DC (Sept-10- Aug-11)(www.MBDA.gov)Position: Production Support Analyst / Data Analyst.Responsible for monitoring the up and running of the databases in different environments like QA/INT/UAT and Production for MBDA Application and providing support for all the lower lane databases.Responsible for monitoring and Supporting the MBDA Jobs On 24 * 7 basis which are Scheduled in the Daily-in Production Environment and making sure all the batches are completed and monitoring the logs/exceptions and providing the e solutions and root Cause Analysis for fixing the Issues.Supporting the Netcool Notifications when Job Failures and Immediately Acknowledging them and finding the root Cause Analysis and providing the solutions.Extensively Supporting for the Lower Environments (TEST/UAT) for Test cycles and Executing Autosys Jobs and Providing the Test cycle support and providing the solutions.Monitoring the scheduled Jobs in the cron jobs and Identifying for the Job Delays and Generating the Daily Reports.Finding the db Exceptions in all environments (TEST/UAT/PROD) by querying Exceptions table and finding the root cause for Exceptions and Providing the solutions for Issues.Writing the sqls for Data fixes and implementing the sqls through dbas and production databases.Involved extensive interaction with the users to determine their requirements.Having Good Experience of using External Tables as a file to read the Mainframe flat files.Having Good Experience of Generating the Explain plan and execution plan for tuning the top SQLs and reduce the cost.Supported for the PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support and Enhancements or changes in the Existing Open systems Application. |
