SUMMARY:

• Around EIGHT years of experience in Data - Analysis, Design, Development, Testing, Debugging.
• Worked on various domains such as corporate banking, Investment banking, Risk Attribution, Market data analysis in various capacities such as business analyst, Data Architect, Data Modeler / Designer, Application developer.
• Extensively worked Based on application requirement, define database logical/physical layout and capacity planning, Database growth monitoring space management.
• Fully implemented Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act stress testing (DFAST) process for L5/L6 Schedules.
• Create design documents, program specification and other documentary artifacts like data model, Data Dictionary, Process flow, Data Flow diagram etc.
• Extensively worked in application development using Oracle 11g/10g/9i, Oracle SQL Developer, SQL, PL/SQL, and UNIX Shell Scripting.
• Extensively worked on Backend Programming using PL/SQL Stored Procedures, Functions, Analytical Functions, Packages, Anonymous Blocks, Database triggers for Oracle 11g/10g/9i.
• Good working Knowledge of Data Acquisition, Data Integration and Data Loading.
• Well Experienced in Tuning SQL Queries by Creating Indexes, Optimizers, and Hints and analyzing the Explain Plan, STA, SPM, AWR, Performance tuning of SQL and PL/SQL using HINTS, BULK-COLLECT, Global Temporary tables,, Table Partitioning, Indexes and Join Optimization.
• Extensive experience with SQL*Loader tool with both direct and indirect load methodologies.
• Good Understanding of Data modelling Concepts.
• Excellent knowledge in developing UNIX Shell Scripts for process automation.
• Exposed to varied environments in the areas of application development with emphasis on all stages of Software Development Life Cycle (SDLC).
• Worked on Build Management, release management and maintain issue tracker. Phase out issue, bug resolution.
• Excellent written, organizational and verbal communication skills.
• Expert in understanding of business procedures and ability to work as an individual and as a part of a team.
• A focus upon quality, involved in identifying best practices, technologies, tools, procedures & standards.
• ITIL certified with distinction.
• Expert knowledge on batch scheduler such as Control-M, Autosys - JIL.

TECHNICAL SKILLS:

Programming Skills: SQL and PL/SQL.

Operating System: Windows 98/2000, Windows 2000, ME, NT, 2003 (server), XP, Vista, UNIX, Linux, Ubuntu.

Database: Oracle 9i, 10g, 11g.

Mapping Tools: Informatica 8.6.0 and 9.1.0, SH30 Building Box.

Reporting Tools: WebOSA.

Scheduling Tools: Control - M Scheduler, Autosys.

PROFESSIONAL EXPERIENCE:Senior Consultant

Confidential, Boston, MA

Responsibilities:

• Primary worked on the Agency, Enhance custody, Global treasury repos and FXBook. IBM's Algo RTCE platform has been chosen to perform the calculations of the stressed scenarios for FX/GT business line. Risk Matrix has been used retrieve market price for each security. The credit exposures and marked to market values will be computed for a set of customized stress scenarios created for CCST. The netting rules and collaterals are applied in the aggregation process. The output is then aggregated across the sec finance business lines for above mentioned reporting.
• Involved in providing Functional specification Document.
• Working as part of agile project.
• Understanding business requirement, helping team creates stories for each requirement and assigning each stories to developer and keep track of it as a lead.
• Handled On-shore and Off-shore both team.
• Provide extensive feasible solution to the team in a planning meeting.
• Tuned SQL queries to enhance performance, using the method Explain Plan and Tkprof.
• Written an excellent documentation about the process flow.

Environment: Oracle PL/SQL, UNIX, Autosys JIL Scripts, Data Warehousing Concepts.

Confidential

Security Finance

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Wrote UNIX Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Extensively used Autosys schedulers to automate the execution of PL/SQL blocks embedded in UNIX shell scripts.
• Having excellent knowledge of creating ESP (Enterprise Servicing Platform) components, developing IRD reports as well as generating ECF/OCF checks.
• Worked in team by using AGILE Methodology, Waterfall Methodology and Spiral Methodology.

Environment: PL/SQL, UNIX, Autosys, Informatica, Data Warehousing Concepts, ESP

Confidential

Senior Software Engineer

Responsibilities:

• Mainly working to develop and enhance the applications as per the customer’s requirements.
• Working as developing Oracle objects such as Cursors, Views, Exceptions, Stored Procedures and Functions, Triggers etc.
• Identify the each trade flow in case if not flowing properly, need to maintain trade information as well as market-to-market information and generate reports every day and send it to the business.

Environment: PL/SQL, UNIX, Control - M Scheduler, Informatica.

Confidential

Software Engineer

Responsibilities:

• Working as a DEV/QA in CFS (Customer Financial System) application, which is mainly based on Informatica and Control-M Scheduler tool.
• Working as a DEV/QA of Shipments applications, is based on Oracle PL/SQL blocks.
• Working as a DEV/QA in GAR BW application, which is based on SAP BW.
• Mainly working to develop and enhance the applications as per the customer’s requirements.

Environment: PL/SQL, UNIX, Control - M Scheduler, Informatica, SAP BW and Oracle developer, Building Blocks like SH30, IN13, OS15, DW11, IN14, OS36.