SUMMARY:

• 14+ years of total IT experience as Business Data Analyst, Solution Modelling (Technical Analyst), Oracle PL/SQL Developer, Trade Support Analyst, Data warehousing, Data Modeling, SQL Tuning, analysis and design of business application, technical support on various versions of Oracle (9i,10g,11g) on mid range and higher end platforms Unix systems and MS SQL Server 2000 on Windows 2000.
• Expertise in variety of Applications/Domain including Retail, Product, Financial Services (Investment Banking), Finance, Insurance, Retail, Knowledge management, Facility/Customer Management System, Government projects.
• The response process includes compiling all requested documentation, analyzing the results to identify potential issues, escalating potential risk issues to the appropriate coverage areas and providing input on potential corrective action plans designed to address issues that were identified.
• Worked on various stages of SDLC on Client/Server, Multi - tired and Web-based Applications.
• Was involved in Comprehensive Capital Analysis and Review (CCAR)
• Extensive experience in Business Analysis, System Analysis, Application Design, Data Modeling, Development, Implementation, Testing and Users for Data warehouse and Database applications.
• Involved in writing of scripts for complete data load, updates and refresh cycles (ETL) into Data warehouse (Business Objects (DI)) involving steps for data cleaning, transformations using SQL Loader, ETL and PL SQL scripts.
• Involved in Data Modeling using Star Schema, Snow-Flake Schema, Dimensional Schema, EAGLE Schema
• Extensively involved in installation, performance analysis, tuning, implementing backup and recovery strategy for application and database.
• Actively involved in analysis, design and development of business application using various tools of oracle.
• Expertise in writing Unit, System & Regression test cases, providing Technical on Call support and Production Support.
• Extensive Experience on End-To-End implementation of Database and Strong understanding of Oracle concepts, ETL, Data modeling experience using Normalization, Business Process Analysis.
• Strong Experience in Database architecture design, Experience in working with scheduling tools like Control-M.
• Strong experience in Designing the Batch jobs for Nightly(EOD) and Intraday Run
• Lead and Mentor mid-size database development team. Lead experience with offshore and onshore team.

TECHNICAL SKILLS:

LANGUAGES: SQL, PL/SQL, HTML, ASP, XML

DBMS: MS Access

RDBMS: Oracle 9i, 10g, 11g, 13g, SQL Server 7.0 / 2000, MYSQL, SYBASE ASE

UTILITIES: SQL*Loader, PL/SQL, TCP/IP, SQLPlus, FTP, Telnet, RDP

GUI: VB 5.0, Amarta

Tools: MS - Office, TOAD, SQL-Navigator, BO Data Integrator v11, Cognos Reporting & Decision stream v7, IBM Mainframes, Clear Case, Peregrine, Informatica

VERSION CONTROL: Microsoft Visual SourceSafe, SVN, CVS

OS: Windows, Linux, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Production Support Analyst

Responsibilities:

• Expand and modify computer systems to serve new purposes and improve workflow.
• Analyze user requirements, procedures, and problems to improve existing systems and review computer system capabilities, workflow, and scheduling limitations.
• Perform business process analysis and work with business users to gather and analyze system requirements.
• Establish service level agreements aligned with client expectations, standards and best practices.
• Perform requirement analysis and system design for online transaction processing applications, covering workflow/process modeling, data modeling, user interface design, background processing, and integration testing.
• Write unit, system and regression test cases.
• Created stored procedures, functions, and packages in high-level technical and functional design documentation.
• Configure pre-production, testing and development environments.
• Provide support for global equity derivatives applications.
• Analyze business process to identify needs and provide end-to-end application support.
• Develop database strategies with exception handling capabilities.
• Create test plans, and support PL/SQL testing and performance tuning.
• Create and schedule batch jobs using Control-m.
• Collect, analyze and produce metrics on process data for Key Performance Indicators (KPI).
• Conduct post-mortems of incidents and ensure business requirements are implemented part of incident, problem and change management programs.
• Provide data and quality analysis to development teams and IT on product quality.
• Review and analyze service requests.
• Review existing platform monitoring and recommend system improvements.
• Perform root cause analysis of system failures.
• Apply ITIL best practice service context within a real-time distributed environment.
• Full Understanding of Service Management, Incident Management and Problem Management
• Finance Investment banking knowledge focused onCompliance, AML and Regulatory Reporting (Realtime /EOD for TR / PTR)
• Gathering, reviewing, investigating and analyzing trade data, responding to Regulatory inquiries from the major Regulators (e.g. CFTC, BaFin, FinCEN, FINRA, DoD Frank, BundesBank, FedReserve, NYDFS, Bank of Israel, Bank of England, HKMA)
• The response process includes compiling all requested documentation, analyzing the results to identify potential issues, escalating potential risk issues to the appropriate coverage areas and providing input on potential corrective action plans designed to address identified issues.
• Gathering, reviewing, investigating and responding to Internal Auditors for AML and AFC Audits.
• Was involved in creating Audit reports for Internal Auditors / Major Regulators / Compliance team
• Work with Compliance on responding to regulatory inquiries and on regulatory examinations
• Worked on Strategic Projects to streamline Monitoring using ITRS for Production Environments of Multiple Applications

Environment: Oracle 13g, ITRS Geneos, DAP, SQL Server, Unix, Linux, Wintel, Perl / Shell scripting, VBA, Spotfire, SAS, Java, Informatica, Qlikview, Cognos, ControlM, ServiceNow, Enterprise Jira, DTCC, UnaVista, Tableau, dWeb