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
*******@*****.***
Austin/Houston Texas