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 Citigroup 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:

Work Experience:

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,

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.

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.

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.