SUMMARY:

• 13 years of experience in areas of Analysis, Design, Development, Testing, Implementation, Client interaction and project releases. Good Exposure to Risk compliance, Trade Surveillance (ETS), Media Telecommunication, Retail and Insurance Client/Server based Enterprise applications using high - end databases.
• Practical Experience with different software development Methodologies like Agile Methodology, Waterfall and V-model.
• Expertise in database design and development using Oracle 11g/10g/9i/8i, Web deployment using Oracle 9iAS, PL/SQL, Reports 10g/9i/6i and Forms 10g/9i/6i.
• Hands on Experience in using various Oracle Client tools such as Oracle SQL plus, SQL Developer, Pl/SQL Developer, Toad.
• Extensively worked on Actimize Visual Modeler 4.7, 4.9, 4.14,4.21 and Actimize Risk Case Manager/Designer 4.6, 5.1 and 5.7.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Extensive working knowledge in developing Packages, Stored Procedures, Functions and Database Triggers for developing applications.
• Expertise in writing Scripts for creating Tables, Constraints, views, triggers, materialized views, indexes, sequence generators, table spaces, partitions in Oracle DB
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility &TKProf.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Being an Actimize product specialist, have successfully developed and implemented numerous complex Actimize Trading and brokerage surveillance solutions for Global Control Room, Information Barrier Surveillance, Associate Investment Monitoring, region and country specific surveillance LOBs.
• Comfortable working with Testing, Debugging, and Deployment of Applications.
• Created Business Requirements, Functional Specs and User Interface Documentation.

TECHNICAL SKILLS:

Databases: Oracle 11g, 10g, 9i

Actimize Technologies: AIS 4.9, 4.14, 4.17, 4.21, RCM 5.1, 5.7

Tools / Utilities: Reports 10g/9i/6i, Forms 10g/9i/6i

GUI interface: TOAD, Oracle SQL/PLSQL Developer

Operating Systems: Win 2K/XP, UNIX, Linux, Sun Solaris

J2EE Application & Web Servers: Web Sphere, Tomcat, Web Services, JAX-WS

Web Designing Tools: HTML,XML,XSL

Version and issue controls: SVN, JIRA,GIT,HP QC

Scheduling API/Tools: Autosys,crontab

PROFESSIONAL EXPERIENCE:

Senior Actimize / Oracle Consultant

Confidential, New Jersey, NJ

Responsibilities:

• Responsible for the design and development in the Market Abuse Trading Surveillance (Fixed Income and Equities models), develop new custom models, integrate and support standard models and products delivered by Actimize.
• Being an Actimize product specialist, have successfully developed and implemented numerous complex Actimize Trading and brokerage surveillance solutions for Global Control Room, Information Barrier Surveillance, Associate Investment Monitoring, region and country specific surveillance LOBs.
• Developed new model and enhancements using Actimize Visual Modeler AIS 4.9, 4.13,4.14 and Actimize Risk Case Manager/Designer RCM 5.1 and 5.7
• As a Database Analyst, I was responsible for receiving incidents and requests from end-users, analyzing those and responding to end-users with the solutions.
• Have written various Oracle Procedures using Complex SQL queries to monitor suspicious trade activities between Business Units within BOA firms such as Employee trade, Mass journal Transfer, Fixed Income trades, Equity Trades, SWAP Trades etc.
• Have created various Custom Oracle Functions to meet business needs and better code reusability etc.
• Have written Oracle Packages to create logical Groups of code for different Line of Businesses
• Have Created Oracle Views and Oracle Materialized views using Complex queries to generate data for downstream applications.
• Have written Complex Queries using Oracle Built in Functions, Advanced Functions and various types of Joins to generate on demand reports for users and feeding them into Inquiry tool for further analysis of supervision team.
• Involved in Complex query tunings, which takes long time to process the request using oracle Explain Plan, Index, Hints to reduce the response time
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Preparing and reviewing functional requirement specification documents and technical specification documents
• Supporting QA team in defining, preparing and executing test cases and test plans
• Conducting User Acceptance Testing by coordinating with the Business Users and Business Analysts.

Environment: Oracle 11g, Actimize Visual Modeler AIS 4.17, 4.21, Actimize Risk Case Manager/Designer RCM 5.7, Autosys, IBM Web sphere, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN, JIRA.

Senior Actimize / Oracle Consultant

Confidential , New Jersey, NJ

Responsibilities:

• Implemented procedures for designing and infrastructure components including Hardware and PROD,DR solutions
• Provided technical assistance for code migrations in coordination with code deployment teams
• Building a Global Credit Underwriting solution on Actimize platform to support new merchant applications as well as exiting merchants with additional outlets.
• Develop new AIS models, heavy RCM development including Dashboards, DARTs, Web services, Alerts, Reporting, gathering business requirements and data mapping for Investment Banking clients.
• Developed new model and enhancements using Actimize Visual Modeler AIS 4.9, 4.13,4.14,4.17,4.21 and Actimize Risk Case Manager/Designer RCM 5.1 and 5.7
• Lead on-site and off-shore development; delivered projects according to the tight schedule.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures, Packages using Oracle SQL and PL/SQL languages.
• Worked on Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Global Temporary table spaces.
• Conduct meetings with the offshore team, internal business users and PMO reps during all phases.
• Lead performance tuning on-site for Financial Institutions.
• Created many solutions to improve Actimize products and performance
• Building pilots and demo software for a prove-of-concept for the top Financial Institutions
• Accept and validate merchant application feeds from boarding systems.
• Develop services to collect additional information related to merchant risk.
• Use automatic decision service for credit underwriting.
• Integrate with case Actimize management platform for alert review and investigation.

Environment: Oracle 11g, Actimize Visual Modeler AIS 4.17, 4.21, Actimize Risk Case Manager/Designer RCM 5.7, Autosys, IBM Web sphere, XSL,XML,Putty, SSH, Unix, Linux shell scripts,GIT.

Senior Actimize / Oracle Consultant

Confidential, New Jersey, NJ

Responsibilities:

• Responsible for the design and development in the Market Abuse Trading Surveillance (Fixed Income and Equities models), develop new custom models, integrate and support standard models and products delivered by Actimize.
• Being an Actimize product specialist, have successfully developed and implemented numerous complex Actimize Trading and brokerage surveillance solutions for Global Control Room, Information Barrier Surveillance, Associate Investment Monitoring, region and country specific surveillance LOBs.
• Developed new model and enhancements using Actimize Visual Modeler AIS 4.9, 4.13,4.14 and Actimize Risk Case Manager/Designer RCM 5.1 and 5.7
• As a Database Analyst, I was responsible for receiving incidents and requests from end-users, analyzing those and responding to end-users with the solutions.
• Have written various Oracle Procedures using Complex SQL queries to monitor suspicious trade activities between Business Units within BOA firms such as Employee trade, Mass journal Transfer, Fixed Income trades, Equity Trades, SWAP Trades etc.
• Have created various Custom Oracle Functions to meet business needs and better code reusability etc.
• Have written Oracle Packages to create logical Groups of code for different Line of Businesses
• Have Created Oracle Views and Oracle Materialized views using Complex queries to generate data for downstream applications.
• Have written Complex Queries using Oracle Built in Functions, Advanced Functions and various types of Joins to generate on demand reports for users and feeding them into Inquiry tool for further analysis of supervision team.
• Involved in Complex query tunings, which takes long time to process the request using oracle Explain Plan, Index, Hints to reduce the response time
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Preparing and reviewing functional requirement specification documents and technical specification documents
• Supporting QA team in defining, preparing and executing test cases and test plans
• Conducting User Acceptance Testing by coordinating with the Business Users and Business Analysts.

Environment: Oracle 11g, Actimize Visual Modeler AIS 4.17, 4.21, Actimize Risk Case Manager/Designer RCM 5.7, Autosys, IBM Web sphere, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN, JIRA.

Confidential, Washington, DC

Responsibilities:

• Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures, Functions and Packages using Oracle SQL and PL/SQL languages.
• Extensively worked in Oracle SQL Developer, PL/SQL Developer, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Performed SQL, PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL *Trace, TKProf and Auto trace.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Debugged various defects related to implementation of business logic

Environment: Oracle 11g, Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN, JIRA.

Associate Projects

Confidential, New Jersey, NJ

Responsibilities:

• Designed, developed and tested software using Agile Methodology.
• Worked in development, testing and production environment using packages, stored procedures, functions.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Worked on creating non-production instances using Export / Import utilities / Data pump Schema and User management.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections, Table Partitioning and Error Handling.
• Worked on Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Global Temporary table spaces.
• Successfully provided round the clock support to all the applications and proposed new ideas and solutions for improvising existing system.
• Developed UNIX Shell Scripts to execute procedures and publish the files.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Created Unit Test plans and involved in primary unit testing.
• Responsible for the development and maintenance of end-user documentation.

Environment: Oracle 11g, Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN, JIRA.

Associate Projects

Confidential, Arkansas, AR

Responsibilities:

• Gathered the business requirements from the client and translated the business details into technical design and specifications.
• Designed the application system structure and functional modules. Used the functional document to design application logical and physical structure.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL languages.
• Developed Packages, Procedures Functions and Database triggers using PL/SQL. PL/SQL query tuning using Explain Plan, optimizers, hints, Indexing strategies, cost measurement etc. Error review, log and restudy/recode of the system.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Debugged various defects related to implementation of business logic
• Interacted with client to gather the requirements and implement the same in the project
• Responsible for team member's assigned workflow details and for proper monitoring of tasks assigned.

Environment: Oracle 11g, Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN, JIRA.

enior Software Engineer

Confidential, Chennai, TN

Responsibilities:

• Actively involved during data migration and production support for more than 1500 offices of various head, Regional, divisional and branch offices.
• Developed new tool to migrate the insurance data from user Interface using Forms10g.
• Developed various new master /Transactional forms using Developer 2000
• Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Developed and optimized complex stored procedures, functions, triggers to handle complex Business rules and history data
• Tuning of the SQL queries, which takes long time to process the request using oracle Explain Plan, Hints to reduce the response time
• Developed various reports and interface form like Underwriting and accounts related reports using oracle Forms10g and Reports10g.
• Reports like Premium Summary, Claims outstanding, Settlement, Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.

Environment: Oracle 10g, Reports 10g/9i, Forms 10g/9i,Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts, SVN,HP QC.

Senior Software Engineer

Confidential

Responsibilities:

• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Use Collections like variable arrays, nested tables
• Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training, UAT and production environments.
• Created vital reports using Reports 9i, 10g as per the client’s requirements
• Perform all levels of data analysis, including data mappings, data feeds, data models, and data transformation.
• Fine-tuned the SQL queries by using index strategies and also optimization techniques.
• Carried out the Data migration activities which include getting the data from the customer, uploading the same into the database with corresponding validation and verification using PL/SQL and SQL Loader
• Support and maintenance of application Testing and bug fixing coordinating with other developers to ensure that daily builds are error free.

Environment: Oracle 10g, Reports 10g/9i, Forms 10g/9i,Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts,HP QC.

Software Engineer

Confidential

Responsibilities:

• Provided constant technical support for applications to ensure optimal durability and reliability - Investigated and resolved technical operational issues of the applications.
• Developed various new master /Transactional forms using Developer 2000
• Developed various reports and interface form like Underwriting and accounts related reports using oracle Forms10g and Reports10g.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Reports like Premium Summary, Claims outstanding, Settlement, Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
• Creating Back-end stored procedures, triggers and packages using PL/SQL
• Created vital reports using Reports 9i, 10g as per the client’s requirements
• Ensured assigned deliverables are on time and within the assigned budget
• Provided individuals with positive and development feedback and creating Performance Feedback Forms for team members
• Attended Weekly Conference Call meetings with clients/counterparts to discuss team tasks, staffing, issues and other concerns.

Environment: Oracle 10g, Reports 10g/9i, Forms 10g/9i,Autosys, XSL,XML,Putty, SSH, Unix, Linux shell scripts, HP QC.