SUMMARY

• Over 8 years of strong experience in Application/Production support, SQL, PL/SQL development, Data warehouse and ETL
• Have driven 24/7 application support and development projects built using SQL, PLSQL, Unix, Autosys, Feedhub, Sql server, Oracle Forms, C# .NET, XML, Database/Application Performance optimization, Database/Application disaster Recovery Plan and Testing
• Incident/Problem management: Experience in troubleshooting production issues and find root cause through analysis of incidents, problems and provide workaround, continuous improvements, permanent solutions
• Experience in analyzing client’s business requirements and processes through document analysis, workshops and workflow analysis
• Experience in software development methodology and Quality Process. Worked in projects adhering to phases of Agile Methodology of software development life cycle, which includes system study, analysis, design, development, testing and implementation
• Experience in creating effective test data and development through test cases to ensure successful execution of the data

TECHNICAL SKILLS

Databases: Oracle 11g/12C, Microsoft Sql server

Programming: SQL, UNIX, PL/SQL, Python, C#, XML

Cloud computing service: Google cloud platform

Database Components: Cursors, Stored Procedures and Packages

IDE: SQL developer, TOAD, Visual Studio 2008, Jupyter notebook

Bug tracking tool: Confidential rational Clear quest

Ticketing tools: ServiceNow, BMC Remedy

Version control tools: Microsoft TFS, Confidential rational Clear case

Operating systems: Windows, Confidential AIX

Job scheduling tools: Autosys

PROFESSIONAL EXPERIENCE

Application support analyst

Confidential

Responsibilities:

• Experience in 24/7 application support/development role, providing technical and business support for users of Confidential applications and timely resolutions to technical issues
• Identified and resolved medium to highly complex production problems for support of applications across 11 currency processing centers. Created change records, owned, maintained and supported Confidential ’s critical windows - based applications
• Participated in application releases, from development, testing and deployment into production
• Reduced the number of tickets by almost 75% within a year. This was done by prioritizing bug fixes, providing solutions to long pending performance issues, partnering with appropriate development and production support teams.
• Shell scripting in Linux OS (with cron setup) / batch scripting to automate certain processes and provide extra application checks/emails (Continuous Improvement)
• Major role in migrating a number of applications to Confidential Cloud by setting up Autosys jobs and Feedhub (Secure Transport) file transfers.
• Initiate bridges for major/important incidents with clients like TD, NBC, HSBC and vendors/internal teams, acted as liaison between users and infrastructure teams like DBA, windows, UNIX teams in case of application performance issues
• Successful FeedHub transfers, created/updated Autosys jobs using JIL scripts
• Trace DB, Unix and application logs, raised problems to relevant technology and business teams
• Developed and maintained technical support documentation and created knowledge management system. Delivered effective and sustainable knowledge to users

Senior application support analyst

Confidential

Responsibilities:

• Met SLA’s of various applications on the production support and UAT environments while maintaining focus on high quality deliverable's
• Developed custom solutions for application limitations, business needs, recommended best practices and implemented ideas and solutions successfully
• Monitored and fixed user service requests and infrastructure incidents in 40 production servers spread across NA, Europe and Asia Pacific on a daily basis via ticket tracking tool BMC Remedy
• Created knowledge articles of every functionality of the application by recording live KT sessions for education of end users, internal application teams and other vendors
• Created and scheduled change tickets for production, DEV, test environments in co-ordination with the release manager before major releases, database refresh, application disaster recovery activities
• Wrote technical design documents (solution specifications), techno-functional requirement documents and Root Cause Analysis (RCA) documents
• Collaborated with business users, solution owners, internal resources, vendors for resolving complex application/production problems on own merit to improve transparency and ensured uninterrupted service
• Developed, documented, and executed many Standard Operating Procedures which decreased the team’s overall resolution time by 20 percent
• Analyzed logs in Confidential AIX servers and fixed batch job failures by on time without any escalation that helped the site users to plan warehouse orders without any delay
• Connected to AIX machines via PUTTY to execute batch jobs, manage directory permissions, create ksh (korn shell) and .sql files, start/stop application processes

Application developer

Confidential

Responsibilities:

• Developed application software for 8 major releases and 15+ patches as part of the application development team
• Developed close to 60+ new medium to complex modules that were approved and deployed into production helping business users save on time, effort and money. Also involved in minor and major enhancements of the application
• Developed and tested Oracle Stored Procedures, Functions, Packages, Collections, Triggers, Views
• Checked out and checked in code into Confidential Rational Clear Case 9.0 for deployment after development in the DEV environment
• Created Rollback scripts for application releases in case the deployment had to be rolled back
• Lead the effort to completely automate several functionalities of the application which resulted in eliminating human errors as there was zero intervention from the business users
• Resolved more than 50 existing medium to complex bugs that lead to the decrease in incidents year on year
• Created many Problem reports and Change requests for bugs and new changes in Confidential rational Clear quest once the RCA documents and solutions were in place.
• Performed debugging, unit level testing of components, query tuning in oracle SQL and PL/SQL