Current Role: Application Support Production (SRE) @ JP Morgan Chase, Houston.

Summary:

·Over 18 years of hands on experience in all stages of Software Development Life Cycle

·Expertise in design, development, test and deployment of database applications using Oracle Technologies.

·Worked as Production Applications Support/SRE that involves working on automation processes of various modules

·Performed database application design, development, analysis, customization using Oracle Forms, Reports, PL/SQL programs for the Military Modernization Applications Development Software team.

·Expert level programming skills in Developer 2000, Forms 6i, 4.5, Reports 6i, 2.5, BI Publisher, Oracle Designer 2000, Designer 6i, Oracle databases 8i/9i/10g/11g database, SQL, SQL*Plus, PL/SQL, SQL developer, TOAD and PL/SQL Developer.

·Expert in writing Database objects like Stored Procedures, Functions and Packages.

·Worked on USPS Project as a Systems Software Developer

·Good working knowledge as a junior DBA.

·Excellent interpersonal and communication skills. To

·Worked as a Sr. Systems Specialist for the (DSCA) Defense Security Cooperation Agency for DEFENSE.

·Worked as a Senior Oracle Developer for Defense Enterprise Accounting Management System (DEAMS) for US Air Force

·Worked as Senior Software Engineer for one of the world’s largest Oracle Human Resources implementations, Military Personnel Data System (MILPDS) for United States Air Force (USAF).

Degrees, Certifications & Hobbies:

Master of Science in Mathematics, India

oCertified in Comp TIA Security +, January 2013

oCertified in ITIL-V3, foundation level, Sep 2012

oOracle SOA Suite 11g (Build Composite Applications Ed 3 LVC){BPEL process}

President of Indian Association in San Antonio (community of 3000+)

Technical Snapshot:

Programming Language

SQL, PL/SQL, COBOL, Java, Visual Basic, Python

OS & framework

Linux/Unix, Microsoft Office, Windows 95/98/2000/NT/Windows7, Oracle 7.x/8.0/8i/9i/10g/11g

Tools

Developer/2000 (Forms 4.5, Reports 2.5), Developer 6i, SQL*Plus, PL/SQL Developer/ SQL Developer, Designer/2000/6i,

Test Configuration Management

Test Director 8.0, Quality Center 10.0, PVCS Version Manager 7.5.1, StarTeam, VMWare, Service Now

Other skills

ERP: Oracle HRMS 11i/R12, BI Publisher, BPEL Process development, Splunk, Aaas, Evolven

Experience Snapshot:

JP Morgan Chase

Mar 2018 - Present

Position : SRE - Application Support, Production

Working on Multiple Applications that are based on SRE Model

oCREDITMART, GAUSS Marginal Price, GAUSS Portal, GAUSS Risk Manager, BASEL, ANCHOR, CALC, SELM, OWL, PALTO, MOMA, ESCHER, PMT

oSupported all the above applications on ON-CALL support basis 24/7 including weekend support

oResponding to P1/P2 user requests and automated alerts

oCreation of incident tickets and reach alerts, as per process outlined by Command center

oCreation, maintenance and Monitoring of SLA’s, SLO’s and error budgets

oProactively working on Automation of Release processes

oParticipated in various Releases every Friday on various tasks that includes deployments, YAML drops, ad-hoc requirements, wfs updates, BPL processes

oWorked on Certification updates/renewals using AAAS process

oWorked on Autosys job, automation process.

oWorked on various Schema’s in remediating the accounts as per need

oSME with BASEL application and EOM processing on both CORE/GAUSS Basel runs

oAutomation Resiliency process, and execution which remains manual and moving into Automation process eventually

oWorked on High Availability Tests for BASEL and GAUSS.

oWorked on generating Alerts thru Evolven Configuration tools on various applications.

oDual reporting responsibility to AD and command center to ensure consistency across SRE teams

Accenture Federal Services(AFS)

July 2011 – Feb 2017

Role: Systems Software Developer Staff

Worked as Production Support Analyst & as a developer. Worked on Data Warehouse and ETL process

oWorked for Whole Loan Conduit and Structured Transactions Portfolio and supporting following applications

PE (Pricing and Committing)

STTS (Structured Transactions Trading System)

IRIS Bond Admin

MBS Tax

SFMD

REMIC Tax

IRIS SC Applications

oWorked in Repository Configuration/using Transformation, creating Informatica Mappings, Mapplets Sessions, worklets, workflows, Processing tasks using Informatica Designer/workflow Manager to move data from multiple source systems into targets.

oSupport all Structured Transactions applications by trouble shooting customers urgent requests.

oInvestigate and troubleshoot on all problems in Daily/End of Month/Transmissions/Alerts in Structured Transactions Portfolio

oMonitor/ alert and correct routine and complex technical issues using EMM alerts and Autosys Job alerts

oBeing part of Tier-2 STT Ongoing Production support, this requires analysis and restoration.

oLog, Monitor and Report all the Incident Tickets, Problem Tickets and Change Tickets via Remedy Tool

oCo-ordinate with Tier-3 STT Development team and Business users in implementing and testing all the technology mandatory software upgradations

oDocumenting and creating the knowledge articles for the frequently occurring issues

oCreate Problem tickets for every unique issue and co-ordinate with Tier 3 Development team in for the root cause and work around for every identified problem ticket

oCo-ordinate with Tier 3 development team by actively participating in reviewing the production implementation plan for each production release and executing them meticulously

oFacilitate application business users by placing appropriate access requests and following up on the necessary approvals and enabling business users to gain appropriate access to required applications using my services tool

oCreating Technology Contingency plan and co-ordinate with various Business and Technology stake holders for necessary approvals and maintain the same in Cloud Force

oCo-ordinate with Tier 3 Development team, Business team and Technology stake holders in creation and maintenance of the service level agreement document for all the applications in the Structured Transaction Portfolio

Worked for client Defense Enterprise Accounting Management System (DEAMS) US Air Force & Defense Security Cooperation Agency (DSCA)

oWorked on 11i ERP Oracle Financials and as part of that Analyzed, designed, tested and resolved bugs in the DEAMS application in various modules like AP, AR, GL, PO and PA

oWorked on workflow issue for example, created a new Hold Code for SF1081 which initiates an alert to the invoice preparer, when an attachment is added to release the New hold code and without an attachment to send the Notification

oCreated and updated numerous Technical Design Documents

oRe-built the entire Enable/Disable process that updates the Flexfield values instead of updating the CCID (Code combination id’s) which fixed the process. Added DFF value segments/value sets

oWorked on XML Publisher reports like Voucher Control Log

oResolved several issues with Transaction code setups, also created numerous configuration Documents related to these transaction codes.

oWorked on creation of new concurrent programs, DFFs and value sets per new business requirements.

oOpened Oracle SR’s, applied patches to fix the data.

oHelped the testers in all phases by providing the queries and also to set up records for testing purposes in Test and Pre-Prod instances

Environment & tools: Unix/Linux, BOXI (scheduling and running Reports), MS SQL Server 2012, SQL, Sybase Central 15.1, Autosys (Job Scheduling), Gems Tool (Viewing the Messages in the queues), IEOPS, WebLogic admin

United States Air Force, Randolph AFB, Texas

Nov 1998 to May 2011

Role: Sr. Software Engineer

Involved in the Air Force Personnel Data System modernization program

Responsibilities include but not limited to:

oAnalyzed, designed, developed, tested, implemented and documented numerous modules including separations and retirements section.

oServed as a Bundle Team Lead for automatic actions and suspense routines.

oTrained/mentored new employees about how the Military Personnel Data System operates.

oImplemented and maintained automated procedures & applied patches as needed.

oDesigned and developed numerous packages, procedures and libraries in PL/SQL, to convert, validate and insert data into the HR tables.

oGenerated DDL using Designer 2000(Designer 6i) that in turn uses a repository to store design information including data models, modules, module structure and logic that can be run to create tables, columns, constraints and other database objects.

oWrote test plans and validated test scripts and performed manual/automated testing all thru UAT environment

oExtensively used Database Design Transformer and the Application Design Transformer to convert the captured information during the requirement analysis into logical database structure and software module design.

oDeveloped sub-driver, driver packages and customized Oracle's .PLL'S.

oDeveloped wrappers for validating the data.

oInvolved in design and development of value sets, descriptive flex fields, messages etc.

oCreated Oracle alters to run the suspense routines or automatic actions.

oImplemented cascading dependencies to reduce coding.

oDeveloped menus, functions, task flows etc.

oDeveloped Custom reports and registered in HR as concurrent programs.

oExtensively used API's provided by Oracle HR.

Environment: Oracle 8i/9i/10g/11g, Forms 6i Oracle application (HRMS) 10.7/11i/R12 testing environment, Windows NT/ UNIX

+1-210-***-****

ade1hf@r.postjobfree.com

Austin/Houston Texas

Contact this candidate