SUMMARY:

• Application Support Senior Manager with 17 years of experience in Banking (Financial domain).
• Project planning/management/implementation.
• ITIL concept and policies, Incident, Problem, Change Management.
• Budget planning, analysis, tracking.
• ITRS Geneos, Robotic Process Automation (Automation Anywhere and Work Fusion)
• A project leader with expertise in the areas of web development, e - Commerce, Mobile Banking and Data Warehousing.
• Extensive experience in the Business Requirements Analysis, Application Design, Web applications.
• Customer needs analysis/support implementation of new application and enhancements. Wide-ranging experience in using different SDLC methodologies. Service Oriented Architectures (SOA) using TIBCO, Ab Initio, Web Services, and Web sphere ND/ XD, AIX / UNIX.
• Production and Development Support Alerting and Monitoring to ensure the stability and providing resolution for Production related issues. End to end monitoring tools evaluations - Work Fusion, Automation Anywhere, and RTView.

PROFESSIONAL EXPERIENCE:

Application Support Lead

Confidential, Scotiabank, New York

Environment: LINUX, HortonWorks, Hadoop, Attunity, Lore, TAMR, Oracle, MS SQL Server, Windows 2012, Python 3.4, Tableau, Elastic Search, Kibana, Netapp

Responsibilities:

• Built an Application Support Team organization (onsite and offshore model) for all US Applications for Confidential organization - Hired application support resources and SOW/contract for managed services.
• Handing POCs for Customer Data Initiative project on Big Data / Hadoop platform. Hands on experience in configuration, installation of various third party software e.g. Attunity, LORE, TAMR, Global ID, and Waterline.
• Actively engaged in monitoring and configuring of the e2e for CDI multiple layers - Data acquisition, data discovery, data resolution and data consumption layers.
• Engaged in automation of various manual tasks performed by Technical BA’s for Prime BSA application and also configured the alerting on SCOM.
• FINRA project onboarding - managing user entitlements in Discovery Accelerator tool.
• Handling the regulatory reporting platform migration from Wintel to AXIOM UNIX platform.
• Coordinated the change and release management processes for the US applications in the Confidential department.

Application Support Senior Manager

Confidential

Environment: J2EE, EJB, SWINGS, AJAX, MS SERVER 2008,Crystal Reports, Business Objects, Actuate, UNIX,AIX, Windows, HTTP, and Connect Direct 4.2.00, EDINT AS2, IBM MQ Series, i-Planet, Web Sphere ND and XD, TIBCO, RTView, AbInitio 3.2.1, Web Services, Oracle 10g, 11g, Golden Gate, Shareplex, ITRS, Microstrategy.

Responsibilities:

• Monitoring maturity (attained level-4 / level-6) using ITRS Geneos tool - automated manual tasks, built dashboards.
• Setting up alerts for 200+ Production & COB servers e.g. CPU, Memory, disk space, transactions and file level monitoring, e2e flows for transactional and complicated file flows and user authentications. Change, Release Management - automating manual deployments via uDeploy. Building a resiliency / High Availability (HA) model for Production & COB environments.
• Managing Incident & Problem Management for the all applications including franchise business critical applications. Well defined notifications templates around critical branches and SLA breaks.
• Incremental progress in automating manual work performed by L1 and L2 resources.
• Email alert reduction initiative (reduced emails from 120k to 33k).
• Production Support and Developer access to Production was reduced by 50% - reduction in emergency access taken by Production Support teams.
• FORT Testing to perform resiliency testing of multiple components.
• Cost efficiency: Sr. Project Manager for achieving cost saves against the P795 frame maintenance charges, 1000+ LPARs in scope for migration.
• Partnering with Development, testing teams to implement Continuous Integration/Continuous Delivery (CI/CD) - DevOps, using tools Bitbucket, Sonarcube, TFS, TeamCity, Jenkins.
• Onboarding Big Data infrastructure and resource planning to support in Non-production and production environments.
• Developing and implementing a minimum operating standards (MOS) and minimum development standards (MDS) for the applications supported.
• Leading team of full time employees and managed services (offshore) and near shore and ensuring cross-trained resources and following the Global follow the sun-model using horizontalization and shift-left support models.
• Serves as the senior escalation point for all electronic banking and dataware housing related issues and coordinate their timely resolution.
• Liaison with, and updates progress to, projects steering board/senior management, development and maintaining management dashboard.
• Resource planning, time estimation, scheduling, cost estimation, budgets, quality control, risk management, project modeling, risk analysis, profitability analysis and team management.
• Defining project hierarchies, project documentation, run books, implementation guidelines.
• Handling recruitment of resources, managing consultancy input within the defined budget.
• Handling change management for application code base installations and deployments.
• Service Strategy, Service Transition, Service Operation
• Service Delivery Management - ensuring Continuity of business, Capacity planning, Availability management, Strategic Planning, Fit-Gap Analysis, Service Level Agreements, Planning and scheduling, allocation of resources.
• Service Design Lead providing guidance upon the production/maintenance of information technology policies, architectures, and documents of the applications.
• Migration of MS SQL databases to Oracle 11g.
• Involved in setting up new customer connectivity on PROD (Connect: Direct), HTTP, HTTPS, AS2 (using EDIINT) and then perform end to end testing. Use of shell scripting to trigger jobs on UNIX environments.
• Payment Types: DFT, Batch Fund Transfer, Cheque, ACH/GIRO, Book Transfer, WorldLink, Payroll Cards, Obligatory Sale Payments, Fund transfers, SEPA, Faster Payments, Paybest, Direct Tax, ACH Credit, Indirect Tax.
• Responsible for monitoring and optimizing the performance of the database and offering assistance to developers in optimizing their applications, queries, etc.
• Troubleshoots with problems regarding the applications and Development tools.
• Plan growth and changes (capacity & scalability planning).
• Solving complex technical problems, assimilate information rapidly, and work under time constraints, automation of key Production Support activities, building utilities for transactions and file replays.
• Decommissioning the legacy application and migrating it to the new platforms.
• Project plan and execution of COB / Disaster Recovery Failovers.
• Project Plan and migration related to Datacenter migrations (from NYC to South West).
• Writing UNIX scripts, developing technology and business dashboards, autosys scheduling jobs.
• Designed, developed, implemented and tested the transition components for the different systems that need migration over a period of time - the In-sourcing projects, which is built using Ab Initio and TIBCO and the mobile & tablet integration project: front end built in Front Gap API on HTML5, CSS and Java script.
• Working closely with the Software Quality Program (SQP) Business Command Center (BCC) to ensure end-to-end payments tracking and escalating issues to Sr. Management if the issue is not resolved in stipulated time.
• Setting up HAWK Rules/alerts on TIBCO BW, EMS and TIBCO SERVERS for payments related failures.
• Managing the Risk & Controls portfolio for around 800+ resources.
• Strategizing a roadmap for Robotic Process Automation in Operations and Production Support areas.

Confidential

Environment: Oracle 8.1.7, MS SQL SERVER, XML, Crystal Reports, VC++, ATL, MFC, DCOM, VB, ASP, JavaScript, HTML, Entrust, Safex, Compress, HTTP, Connect direct 4.2.00 Build 021, EDINT AS2, IBM MQ Series

Responsibilities:

• Building EDI Maps: Developing complex EDI maps, the business logic written in metadata, using the Netik Interchange product.
• Developing SQL scripts to extract data from the eIW Datamart (Oracle) converting them to flat files and staging the data into MS SQL2000 database.
• Involved in Crystal Reports generation using Crystal Report (Developer Version) for the Audit Trail Requirements.
• Expertise in security/PKI concepts: Involved in designing/developing of application modules using Entrust (SMIME, Archive and PKCS#7), Safex, Compress, and EDIINT/AS2.
• Solid understanding of B2B - Electronic exchange/translation of data.
• Responsible for enhancement/development of UN/EDIFACT (PAYMUL, PAYMUL CRG, CONTROL, BANSTA, DEBMUL), ANSI X.12 (820, 831, 824, 997), SAP, IDOC, Statement (MT940, MT942), Custom formats (CP2E, CP2E Rejects, CP2E Accepts) maps using Netik Interchange tool.
• Expertise in connectivity mechanism: Involved in designing/developing of application modules using Https, FTP and Connect Direct, EDIINT AS2 connection.
• Have successfully managed Production support, which includes quick resolutions of problems.
• Enhancement in the existing system (Enrichment Screen Development using ASP, JavaScript, SQL 2000 and XML)
• Prepared functional and interface requirements documents for Citibank File Services and integration with CitiDirect Online Banking Application.
• Played a major role in the design, implementation & testing of: Real time online connectivity between CitiDirect. CFS and FED, Lockbox and Electronic Banking systems, Online Interfaces to SWIFT
• Have good understanding of SCM level 5 processes.
• Release Manager - responsible for reviewing of all the release made by the team that includes the documents provided, processes followed proof of testing and CI’s comparison.

Confidential

Team Member (Oracle Developer / Database Designer)

Environment: Oracle 8.1.7, Business Objects, BCA, SQL Loader

Responsibilities:

• Gathered the requirement from the client and translated the business details into Technical design.
• Created and managed Database.
• Used the technical document to design the database tables.
• Created database triggers for data security.
• Prepared Test Plans for various modules.
• Prepared user manual and technical support manual.
• Implementation support.
• Defined high standard Entity/Relationship and Design models
• Creating store procedures for the Asset/Liabilities report using the Flexcube Revelous product.
• Creating the reports for the Asset/Liabilities reports, based upon the extract dump received from Flexcube. Drill down reports for the user.
• Building cubes for the Data warehousing projects, ETL
• Installation of Business Objects, BCA
• Worked on SQL Loader and PL/SQL
• Monitored Tablespaces, Materialized Views and Analyzed Indexes on regular basis to enhance performance. Hands on experience on Flexcube Revelous installations and reporting tool.
• Tuning database queries and Performance Optimization using PL/SQL profiler, statistics includes CPU usage, block I/O, record I/O, and table scans. Used Query Optimizer, Tuning Advisors for Performance tuning and optimization of PL/SQL routines.