Summary:

• 13 years, 7 months experience in design, development, implementation and support of software applications in Financial Services, Corporate Banking, Leasing, Billing Systems (Oracle RMB), Business Activity Monitoring, General Insurance and Product Based Applications using Oracle and Java and related technologies.
• Data Migration (Conversion) Specialist for Billing project for Confidential for Oracle RM&B (Revenue Management and Billing for Banking) implementation.
• Proficient in Oracle, PL/SQL, SQL, Developer 2000 – Forms and Reports, UNIX, Shell Scripting, TOAD, SQL Navigator.
• Experience in Data Warehousing, Crystal Reports, Business Objects, Ab Initio.
• Experience in developing GUI using Oracle's developer suite tools.
• Extensive experience in writing stored procedures, triggers, functions, cursors, materialized views and packages.
• Extensive experience in SQL*Loader, SQL Query Optimization and Tuning, Collections, Global Temporary Tables.
• Experience in writing complex SQL Statements against large-scale databases using Analytical Functions.
• Experience in Data Migration, System Analysis, Development of Libraries, Back end Programming, Database Design, OLTP, Large databases and Schema Design.
• Experience in using UTL_FILE package procedures and functions.
• Experience in writing dynamic SQL contained procedures and packages.
• Experience in Web Technologies - Java/J2EE, JSP, JavaScript and Websphere.
• Experience in UNIX (Solaris, AIX), Shell Scripting and AWK programming.
• Good knowledge in Financial Domain – Corporate Billing Systems, Leasing (Retail Banking), Business Activity Monitoring (BAM), and General Insurance.
• Expertise in Analysis, Development, Deployment, Testing, Quality Assurance, Enhancement, Maintenance and Implementation of large and complex Oracle and Web based applications.
• Certification in Foundation Finance Program conducted by Oracle Financial Services Software (formerly i-flex Solutions) with Distinction.
• Strong analytical and problem solving abilities.

Technical Proficiency:

Languages:PL/SQL, C, Java Web Architecture:HTML, Oracle 9i Web toolkit – HTP, HTF, WSGL, WSGJSL, XML, Java, J2EE, JSP, JSF, Eclipse, Websphere, TomcatOperating Systems:Windows, Unix, AIX, SolarisDatabases:Oracle 9i, 11g, SQL, SQL * Loader, OLTP, Oracle Conversion ToolkitClient-Server:Relational Database Concepts, 2-tier, 3-tier ArchitectureIDE:Oracle RM& B, Developer 2000 – Forms, Reports, Designer 2000, TOAD, SQL Navigator, Oracle SQL DeveloperOther Software:Systar Business Bridge, PVCS, Microsoft VSS, IBM ClearCaseScripting:Unix Shell scripting, AWK programming, JavaScriptData Warehousing, ETL:Business Objects, Crystal Reports, Ab Initio

Domain Knowledge:

• Financial Industry – Corporate and Investment Banking, Financial Applications, Corporate Banking Billing Systems, Leasing, Business Activity Monitoring
• Insurance – General Insurance – Underwriting, Claims, Re-insurance

Work Experience:

Consultant Senior Analyst,
Confidential. June 2009 – May 2012

Project:Global Billing System – Phase 1, 2,3 Client:Confidential, Jersey City, NJ – 07310Product:Oracle RM&B (Revenue Management & Billing)Technology:Oracle 11g – SQL, PL/SQL, VAX/VMS, INGRES, SQL Server, IBM Clear Case, AIX, Shell Scripting, Websphere, Oracle Conversion Toolkit for RM&B, Ab Initio Data Profiler, Business Objects Crystal ReportsRole:Consultant Senior Analyst and Data Migration SpecialistDescription:
This project is the implementation of Oracle’s flagship product for Billing – RM&B (Revenue Management and Billing for Banking) - for Confidential’s Corporate customers in North America region (phase 1) and EMEA region (phase 2) – christened as GBS (Global Billing System). GBS will replace many individual billing systems that Confidential is currently using to bill their corporate customers, across different geographies. Currently the rollout is Phase 1 through Phase 3, in which Phase 1 and Phase 2 are live and Phase 3 for US Corporate Clients is underway. 
Responsibilities:

• Analyze data conversion business requirements. This involves discussions with Business (Product team), Operations and Technology.
• Design Interface Control Document (ICD) for Conversion.
• Design Detailed Technical Specifications for Conversion.
• Create rules for Ab Initio Data Profiling of legacy data and execute Data Profiling.
• Design and build complex validation scripts for Customer, Account, Pricing, Billing and Payment legacy data.
• Define rules for Extract, Transform and Load of legacy data.
• Developed algorithms for charge code consolidation and bundle consolidation of legacy Pricing data.
• SQL query optimization using Oracle optimization tools – Explain Plan, Hints, Plan Table, SQL Trace etc.
• Used SQL Loader to populate Conversion staging tables.
• Used Oracle Data Conversion Toolkit to map and transform staging data to RMB specific data set.
• Implemented Collections, Bulk Collect techniques for Conversion and invoice reconciliation.
• Used Export/Import utilities to load data from/to various across databases.
• Automated Conversion process using UNIX shell scripts to enable ‘one-click and run’ strategy where the Conversion process executes without manual intervention.
• Actively involved in Phase 1 and 2 cutover activities planning and implementation.
• Design conversion program components for Customer, Account, Pricing, Billing and Payments data.

Sr. Programmer / Analyst,
Confidential. Aug 2004 – May 2009Project:ConfidentialFile Exchange – Businesses Activity Monitoring (CFX BAM)Client:Confidential, Jersey City, NJTechnology:Oracle 10g, SQL, PL/SQL, Java, J2EE, JSP, JSF, Systar BusinessBridge, Oracle 10g, Eclipse, Websphere, Tomcat, IIS, IBM MQRole:Analyst, Senior Developer and QADescription:
Confidential is a project undertaken to provide an end-to-end, real-time or near real-time view into the Confidential’s GTS (Global Transaction Services) CFX payment process. Confidential’s GTS CFX is a customer service offering that provides a secure, cost-effective way to manage file-based payment and collection activity, which uses a variety of delivery channels to execute global transactions, accounts payable and accounts receivable. CFX supports straight through processing, automated delivery, transaction status information and bank statements. The goal of the BAM solution is to give users the means with which to proactively monitor the health of the payment process and to determine which customers and payment files are impacted by a delay in the process.
Responsibilities:

• Involved in requirement gathering, requirement definition, operations analysis, technical design and implementation.

• Develop data sources for BAM using various methods – Oracle database, XML, Flat files.
• Analysis of source data, involved in designing the data model, transformation of logical model into physical model.

• SQL performance tuning using Explain Plan and Plan Table.
• Develop dashboards components using BusinessBridge and front end component using JSP, JSF.
• Gather statistics for various data sources using Java, PL/SQL and SQL Loader.
• Involved in implementing cron jobs that populates Oracle data sources.
• Unit Testing, Regression Testing and QA.
• Configuration Management.
• Administer BAM solution using Admin tools.
• Involved in deployment of Web component and BusinessBridge component.

Project:Global Billing and Pricing System Client:Confidential, Jersey City, NJ - 07310Technology:Oracle 9i/10g – SQL, PL/SQL, VAX/VMS, INGRES, IBM ClearCase, Solaris, Shell Scripting, Websphere, AWK programmingRole:Senior Oracle PL/SQL Developer/Team LeaderDescription:
Confidential uses different billing systems to bill its corporate clients - these legacy systems span across different regions and used different technologies. The Global Billing and Pricing System (GBPS) bring various billing systems under one umbrella to make the billing centralized and thus reduce the cost. Phase 1 of this project deals with Corporate Customers of New York FI, London and Frankfurt branches. New York FI branch currently uses GTS Billing for its clients; London & Frankfurt use MBBS to bill their customers. I-flex Solutions (OFSS) along with SunTec implement SunTec's billing system called TBMS for Phase 1 and subsequent phases of this project. The process of billing corporate customers are complex because it involves various entities for computing monthly charges for a customer - such as Transaction Charges, Earnings Credit, FDIC, Hard Dollar/Soft Dollar rebates, Refunds, Adjustments etc.
Responsibilities:

• Data Migration-Involved in operations analysis, technical design and implementation.
• Involved in discussions with user groups and business for technical requirements for data migration and invoice reconciliation.
• Created and implemented PL/SQL packages, functions and scripts that involve complex logic for migrating data from legacy VMS/VAX/INGRES billing system to Oracle/Java based SunTec's TBMS billing system.
• Used SQL*Loader extensively for populating migration tables from external data sources.
• Implemented database triggers for auditing.
• Implemented Collections, Bulk Collect techniques and REF cursors for migration and invoice reconciliation.
• Implemented materialized views for generating pdf invoices.
• Used SQL query optimization techniques such as Explain Plan, Plan Table, Hints, SQL Trace, TKPROF, and Function Based Indexing.
• Used Export/Import utilities to load data from/to various databases
• Implemented Analytical Functions for data analysis during Data Migration and Invoice Reconciliation.
• Mapped Customers, Accounts, Invoices and Payments using business rules.
• Invoice Reconciliation - Comparison of legacy and TBMS invoices using customized programs.
• Outbound feeds validation - Create PL/SQL scripts for feed validations, and compare them with legacy data feeds.
• Automated Invoice Reconciliation and Migration process using UNIX shell scripting.
• Implemented AWK programming extensively for Reconciliation automation data manipulation.

Project:FastFinance Leasing Client:Confidential, Mt. Laurel, NJ, USA.Technology:Oracle 9i/10g Developer Suite – SQL, PL/SQL, HTP, HTF, WSGL, WSGJSL, HTML, JavaScript, Oracle Reports, Oracle Designer Role:Oracle PL/SQL & Web Developer/Team MemberDescription:
Fast Finance is an application that has been written in-house at Confidential, Mt. Laurel, NJ to support the Leasing Business. The application was used first for the Medical Equipment and currently the scope has been expanded to support the Business Technology Group that handles copiers and office equipment. There are plans to have Fast Finance support more businesses under the Confidential umbrella. 
Responsibilities:

• Developed GUI using Oracle Web Developer suite using SQL, PL/SQL, HTP, HTF, WSGSL, HTML and JavaScript.
• Developed FastFinance interfaces with Oracle Designer 2000 framework.
• Implemented Oracle DBMS Jobs in UNIX environment using Dynamic SQL.
• Developed and implemented SQL and PL/SQL query optimization techniques using Hints and Explain Plan.
• Implemented I/O files using UTL_FILE package.
• Implemented PL/SQL packages, procedures and functions for various business rules in leasing.
• Used collections (PL/SQL tables, v-array, Nested tables) for reading (bulk-collect) and updating of data.

• Implemented autonomous procedures for error logging.
• Involved in Technical implementation of Estimated Property Taxes and General Ledger for FastFinance Leasing.
• Designed and developed Minor Development Document (MDD) for various modules.
• Involved in System and Unit Testing.
• Involved in Code Review and peer review.
• Involved in the maintenance/support activity of this application, jobs and reports.

Sr. Programmer / Analyst, ICICI Infotech Ltd Feb 2003 – Aug 2004Project:PREMIA MaintenanceClient:ConfidentialTechnology:Windows 2000/Unix Server, Oracle 9i Application Server, Developer 2000 – Forms & Reports, PL/SQL, SQL.Role:Production Support/Maintenance Team LeaderDescription:
PREMIA is a software application customized for Insurance Companies. It runs on Client Server, Application Server (9iAS) and web portal. Maintenance related issues and bugs are logged into an Internal Support System, and allocated to team members for Issue Analysis. The analysis by members is pooled commonly into an Impact that involves rectification measures as construction or enhancement on the existing code, to be shipped back to the clients via FTP server. Issue Analysis, Debugging, Test case Review, Testing and Status update of the issues are done. 
Responsibilities:

• Analyze technical and functional implementation issues.
• Involved in interacting with clients and client implementation managers.
• Preparing Impact Analysis for the Issues to be fixed.
• Involved in assigning bugs to team members as well as fixing bugs.
• Designed and developed Forms using Oracle Developer 2000 suite.
• Designed complex multi block forms and Object libraries.
• Designed and developed Reports using Oracle Reports.
• Implemented complex matrix reports using Developer 2000 - Reports
• Implemented query optimization using SQL Trace, TKPROF and Plan Table.
• Implemented Function based Indexes for performance improvement.
• Designed and developed functional libraries and PLLs.
• Used PL/SQL packages and Collections (Index-by tables, Nested tables) for product migration.
• Used PVCS for configuration management.
• Implementation of ad-hoc PL/SQL scripts for defects fix.

Project:PREMIA CustomizationClient:Confidential.Technology:Oracle 9i Application Server (9iAS), Developer 2000 – Forms & Reports, PL/SQL, SQL, Windows 2000 / UNIX ServerRole:Oracle Developer/Team MemberDescription:
This project involves customization of the Insurance Product primarily catering to the needs of General Insurance Companies in the Middle East, Africa and Far East. Known as PREMIA, this product has mainly three modules – Underwriting, Reinsurance and Claims. The customization was done in all of these modules.
Responsibilities:

• Involved in database design and low-level design of various modules.
• Involved in designing and implementing core modules of the applications – Underwriting and Re Insurance.
• Implemented Base Reports for the product using Oracle Reports.
• Responsible for preparing Impact Analysis and Unit Test Cases.
• Involved in requirement gathering, requirement definition, operations analysis, technical design and implementation.
• Implemented PL/SQL packages, procedures and functions for underwriting and policy premium calculation.
• Designed and developed Forms using Oracle Developer 2000 suite.
• Designed complex multi block forms and Object libraries.
• Designed and developed Reports using Oracle Reports.
• Implemented complex matrix reports using Developer 2000 - Reports
• Implemented query optimization using SQL Trace, TKPROF and Plan Table.
• Implemented Function based Indexes for performance improvement.
• Designed and developed functional libraries and PLLs.
• Used PL/SQL packages and Collections (Index-by tables, Nested tables) for product migration.
• Implemented database triggers for auditing and integrity checks

Programmer/Analyst,
Confidential July 2002 – Jan 2003Project:University Management System (UMS)Client:Confidential.Technology:Oracle 9i Server in Sun Solaris Unix Server with Developer 2000 (Forms 6i, Reports 6i, and Graphics 6i) as Front End Tool, SQL, and PL/SQL – Web Enabled.Role:Oracle Developer/Team MemberDescription:
This Information System provides the complete automation of the entire University activities. It has four modules; viz. Administration, Academic, Examination and Finance. Examination module covers all aspects of examination right from application processing, conduct of examination, publication of results and preparation and issue of mark lists and certificates for students coming under the affiliated colleges of this University. This system uses ICR (Intelligent Character Recognizing System) to avoid manual data entry. Examination module covers examination for Affiliated Institutions, DDE (Directorate of Distance Education), Community College, M Phil., and PhD. Web Enabling is also provided. 
Responsibilities:

• Responsible for Technical Implementation of the Examination module.
• Involved in requirement gathering, requirement definition, operations analysis, technical design and implementation.
• Implemented PL/SQL packages, procedures and functions for underwriting and policy premium calculation.
• Designed and developed Forms using Oracle Developer 2000 suite.
• Designed complex multi block forms and Object libraries.
• Implemented Form level, Block Level, Item Level triggers and PL/SQL libraries. Also implemented property classes and visual attributes.
• Designed and developed Reports using Oracle Reports.
• Implemented complex matrix reports using Developer 2000 – Reports.
• Implemented query optimization using SQL Trace, TKPROF and Plan Table.
• Implemented Function based Indexes for performance improvement.
• Designed and developed functional libraries and PLLs.
• Used PL/SQL packages and Collections (Index-by tables, Nested tables) for product migration.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for performance improvement.
• Involved in creating Database Triggers on Source tables.
• Used VSS as configuration management tool

Programmer,
Confidential Feb 1998 – Feb 2002 
Designing, developing and implementing various projects in Oracle, PL/SQL, Developer 2000 (Forms & Reports), Windows & UNIX Server. Used shell scripting for various projects and involved in migrating character based Oracle applications to GUI based ones.

Educational Qualifications:

• Masters in Computer Applications
• Bachelor of Science (Physics)
• Post Graduate Diploma in Computer Applications