RESUME | malm

Ratnayake Bandara Malmeewala

3312 Lady Slipper Crt Mississauga ON L5N 6A9

Tel: 647-409-7381

rmalmeewala@gmail.com

SUMMARY

Major Involvement in large scale global Information Technology projects in various domains for mission critical enterprise level applications in distributed computing environment
Extensive Experience in Application Software Design, Development in n-tier component based applications using Core Java and J2EE technologies with Special emphasis on OOA/OOD/OOP
Presentation of UML diagrams (Actors, Use Cases, Classes) for team collaboration
Java Frameworks Spring( MVC, AoP, IoC ), Spring Batch, Hibernate (ORM), Struts 2(MVC )
Usage of Apache, Tomcat and J2EE Application severs – GlassFish, WebLogic, WebSphere
Web Application Development in Servlet, JSP, JSF, JDBC, XML, XSTL, JAXP, JAXB, XHTML/HTML5, CSS, PHP, JavaScript, jQuery, AJAX
Excellent knowledge in Web Services JAX-WS and JAX-RS
Wide Usage of IDEs ( Eclipse, NetBeans ) and Build tools ( Ant, Maven )
Database Design, Development, Maintenance, and Modeling in Sybase, DB2, Informix, MySQL and Oracle.
Hands on Experience in Database design/development/modeling tools such as ERWIN, DBArtisan, Rapid SQL, TOAD, Sybase database designer etc., and SQL variants such as T-SQL, PL/SQL and ANSI standard specifications.
Excellent Knowledge and Experience in Data warehousing, OLTP, Stored-procedures, triggers, indexing requirements for fast data retrievals in large databases.
Different flavours of UNIX Operating Systems such as Sun Solaris, IBM-AIX, HP-HUX and Fedora/Red Hat Linux Enterprise System
Extensive Hands on development Experience in Perl, Unix Shell Scripting, sed, awk utilities
Experience in Windows Servers(NT/20xx), XP, Win-7 clients
Wide Exposure in job scheduling tools such as AutoSys, Crontab, and Mastero
Knowledge and Experience in Source Code Control systems -- Perforce, CVS, RCS, and SVN

PROFESSIONAL EXPERIENCE

Senior Consultant/Developer CIBC (Wholesale Banking) Toronto

Dynamic Foreign Currency Conversion

Enhanced Java Applications to Extract & Transform Data from multiple internal data Sources ( CIBC Enterprise Trading System, ATM Sytems feeds etc. ) connected to Enterprise Oracle databases. Finally Loaded data into Sybase MIS Database ( Enteprise Data Reporting System )
Enhanced the Sybase/Oracle stored procedures to meet the current requirement of the Dynamic Foreign Currency Conversions at ATM
Verify the Accuracy of Data with documented Test (Integration & Regration) cases

Environment: Red Hat Linux servers, AutoSys Scheduler, JIL, Sybase, Oracle PL/SQL, TOAD, Perl, Unix Shell scripting, Core Java, Eclipse, J2EE, Spring, Hibernate, Oracle WebLogic Server, IBM MQ, Servlets, JSP, JSF, JDBC, SOAP, HTML, CSS, XML, SAX, DOM, Web-Services, SVN Source Code Control system

Senior Consultant/Developer CGI Halifax (Contract Basis)

Employee Trade Processing Applications (Deutsche Bank) Aug 2013 - Feb 2014

Analyzed and Enhanced the existed Java Distributed Applications launched in WebLogic Server for Employee Trade Processing. Required Data extracted from external vender feeds, and connected with internal oracle databases for application data validation.
Interacted with internally developed web services to have a seamless data flow across various Control Room Applications in the firm.
Facilitated Applications to communicate in real-time across the firm through Application middleware queues (IBM MQ) .

Environment: Red Hat Linux servers, Netcool, AutoSys Scheduler, JIL, Sybase, Oracle PL/SQL, TOAD, DBartisan, Erwin Data Modeller, Perl, Unix Shell scripting, Core Java, Eclipse, J2EE, Spring, Hibernate, Oracle WebLogic Server, MQ, Apache, Tomcat, Servlets, JSP, FreeMarker Templates(FTL), JSF, JDBC, SOAP, XHTML, XML, SAX, DOM, Web-Services, SVN Source Code Control system, CollabNet (TeamForge), Scrum Agile Environment

Senior Consultant/Developer (Contract Basis) March 2013 – June 2013

TCS Canada

OTC Derivative Processing (Morgan Stanley, Montreal)

Analyzed Issues and Provided Solutions/Enhancements to Java/XML/MQ Applications used in OTC Derivative Processing Area.
Enhanced Applications with Messages originated from various upstream front-office booking systems with different Asset Classes in different formats to a Unified format in order to be used by various downstream Applications in a consistent DWML internal format of the firm
Enhanced Legacy DB2/Sybase Stored Procedures to suit the new OTC Derivative Processing Requirements
Debugged the ongoing production issues and provided the required emergency solutions to keep the production downtime to a minimum level

Environment: Red Hat Linux servers, Putty, X-Window, Netcool, AutoSys Scheduler, JIL, Sybase, DB2, SQL, DBartisan, Erwin Data Modeller, Perl, Unix Shell scripting, Core Java, J2EE, Eclipse, Spring, Hibernate, IBM WebSphere MQ, Apache, Tomcat, Servlets, JSP, JSF, JDBC, SOAP, XHTML, XML, SAX, DOM, PERFORCE Source Code Control system, JIRA issue/bug tracker, VCS, Service Now.

Senior Consultant/Developer (Contract Basis) Nov 2012 – Feb 2013

Xylo Technologies

Mayo Clinic, Rochester MN

Work Area Reference – Space Allocation Charges

Analyzed the existed Applications/Database layout in Space Allocation Charges of Mayo Clinic for Budgeting purpose with respect to GL Post Accounting Units for Various charge types such as Real Estate, Depreciation, and Occupancy across all Mayo Clinic Campuses. Designed and Documented the New Applications and the New Database layout to implement to accommodate the new requirements and functionalities. Adopted New Algorithms and Calculations to process the space charges for the newly Implemented System. Implemented the new Process to suit the Firm’s current needs by restructuring the legacy database tables and Applications to gain the required speed and maintainability.
Developed stored procedures and triggers. Created New Tables, views and indexes to accommodate the functionality, Security, and for fast data retrievals respectively.
Lay out the Plans for Testing and Developed test tools in Perl, Unix Korn shell Scripts, awk and sed in order to test large data volumes for Accuracy Tests

Environment:Sybase ASE 15.5, Rapid SQL 7.7, SunOS 5.10, UNIX Shell scripting, Perl, Java, J2EE, IBM Web Sphere RAD, JDK 1.5, JDBC, , HTML, JavaScript, CSS, JQuery, AJAX, JUnit, MS Office Applications MS Visio.

Senior Consultant/Developer, Accenture Inc., Mississauga Oct 2010 – Sep 2012

Corporate Actions & Dividend Projections (Morgan Stanley)

Designed and Developed Java Applications to extract ‘corporate actions’ from XML data feeds provided by external Vendors across the globe as per the vendor specific formats through middleware queues ( IBM WebSphere MQ) .
Most recent Corporate Action Updates uniquely Identified and Updated the target ‘Enterprise Database’ in real-time for firm-wide usage upon validation.
Created Perl/Unix shell wrapper scripts to automate and integrate these firm-wide mission critical applications using VCS clustered hosts.
Enhanced the Java multi-threaded Real-Time ‘vendor data listener’ server process to receive very large amount of Global Dividend Announcements declared by external vendors through IBM WebSphere MQ messages in XML formats defined by vendor rules and standards.
Mapped and processed them as per the business logics and requirements and made available in database tables instantly by inserting/updating the required records. Information used for Dividend Projections.
Communicated to other server processors using in-house developed Publisher/Subscriber Queues.
Modified the Linux Stock Server Process developed in C++/Java using various data structures and algorithms to calculate and project future dividends for traders based on the current patterns.
Made these streams available to traders by developing Servlet/JSP web applications.
Developed and Implemented a Generic Netcool alerting mechanism to notify the support teams during critical server issues.
Server Processes implemented in VCS clustering system to kick in the backup servers to minimize production downtime.
Developed stored procedures and web-services to access ‘Corporate Actions’ and ‘Dividend Projection’ information for downstream users and applications.
Developed Perl/Unix shell scripts and Java Applications to generate various client reports demanded by the rapid changes in the business

Environment: Red Hat Linux servers, Putty, Exceed X-Window, Netcool, AutoSys Scheduler, JIL, Sybase, DB2, SQL, DBartisan, Erwin Data Modeller, Perl, Unix Shell scripting, Core Java, Eclipse, J2EE, Spring, IBM WebSphere MQ, Apache, Tomcat, Servlets, JSP, JSF, JDBC, SOAP, XHTML, XML, SAX, DOM Design Patterns, PERFORCE Source Code Control system, JIRA issue/bug tracker, VCS

Senior Developer, Gate Master Inc., Halifax, NS Sep 2009 - Oct 2010

Consumer Reporting Agency - Web Applications

Maintained the company web applications for landlords to check the credit scores of their clients by accessing the credit bureaus.
Designed and developed on-line Web based tenant content Insurance Application. Integrated with the firm’s web-applications and databases. Designed, modelled, and implemented required database schema changes, Stored Procedures, and Triggers etc.
Implemented the QA and test plans for new developments.

Environment: Linux/Windows servers/XP clients, Unix Shell scripting, Firebird, MySQL, Apache, Core Java, Tomcat, JSP, JSF, PHP, GWT, AJAX, jQuery, XML, XHTML, JavaScript, Eclipse, CVS Source Code Control system, Sprint, Scrum Agile Environment

Senior Consultant/Developer,

NTT Data (Keane Canada Inc.,) Halifax, NS (Morgan Stanley) Oct 2003 – Sep 2009

Project 1: Legal Compliance/AML (Morgan Stanley)

Carried out Development, Integration, Automation, and Production Support for Actimize Intelligence Models. Automation scripts developed for AML applications to be executed on windows servers with associated Informatica ETLs processed in a networked Linux servers
Developed Unix Shell/Perl scripts to extract raw-data from various sources and loaded to target fact tables of DB2/Sybase Databases. Developed generic looping mechanism to process the data as and when available from the source providers
JSP/Servlet web-applications developed for end-users to alert the issues.
DB2/Sybase data-loading scripts developed generically for daily, weekly and monthly job Cycles to process in a robust manner with least manual intervention
Batch job Cycles scheduled, implemented and maintained using Autosys JIL language as per the business needs with the proper load distribution on Linux/Windows Hosts
Processed alerts made available to business users through Java web applications and archived periodically to IBM On-Demand servers
Rewarded with the Highest consultant award named Keane Pin for outstanding commitment for the client’s success on various projects in this engagement

Project 2: Firm Risk Management (Morgan Stanley)

Enhanced Firm-Risk Applications to work in an accurate and robust manner using the PVM software in a distributed environment for credit simulations using numerous logics and data structures in Perl, C/C++ and Java. Developed Sybase Stored Procs to make these Data available for these Applications
Monitored, Identified, Resolved Sybase Database related issues to avoid the server wide and database level outages. SQL Query optimizing done by properly identifying the required indexes and updating statistics properly. Developed various database reporting for potential credit exposure applications using embedded SQL shell/Perl scripts
Debugged the Application programs used in the firm and provided the emergency solutions whenever required to keep the production downtime minimum
Analysed Application failures due to data errors in External data feeds and escalated to Data suppliers with identified errors. Developed the required Perl/ Java tools to identify errors. provided the required 2nd level support on 24x7 basis

Environment and Tools:WIN Servers Networked with cluster of Linux servers. Putty, Exceed X-Window Emulation, AutoSys JIL, Sybase, DB2, DBartisan, PVM, Perl, Unix Shell scripting, C, C++, Java, Eclipse, J2EE, Informatica Power Center, Actimize, IBM On-demand, MQ Series, Apache, Tomcat, Servlets, JSP, JSF, XHTML, PERFORCE Source Code Control system

Primus Canada Inc. Toronto ON Feb 2001 – Feb 2003

Senior Developer

Enhancement of existing Customer Care and Billing System

Development

Analyzed Business Requirements and carried out required Development work and the Database Designs for the given Enhancements.
Facilitate customers to view their Bills on-Line. Data Extracted from the existing Billing System and Loaded to the Web Server. Automated the Process using Java, Unix Shell scripts including C, Perl, Awk Utilities and Informix-4GL/SQL Programs.
Card Processing change requests sent to AT&T switch and received the confirmation of requested Changes. Automated the Process using Perl scripts. Generated Mail Messages to Report Requests, Confirmations and Errors. Created Stored Procedures & Triggers in Informix database to optimize the performance.
Application Program Development and Database Changes are done as per the needs. Recommended and Implemented the system changes to optimize performance
Development work done rapidly to meet the competitive marketing requirement changes in the industry, Enhancements done in several database driven Perl and ESQL/C Programs used in the firm
Credit Rating and Collection Program Changes are done in the existing On-Line Transaction Processing Environment
Tested Application Programs against various test cases for accuracy, prior to user acceptance.

Production Support

Environment: WIN 98 Clients with Windows NT/Novell servers Networked with HP-UX Unix systems.

INFORMIX-4GL/SQL, On-Line Dynamic Server, SPL, Oracle PL/SQL, Oracle Forms & Reports, C, C++, Java, JSP, J2EE, Perl, awk, Unix (Korn) Shell scripts, ESQL/C, FTP, TCP/IP, Telnet, ODBC, Exceed X-Window Emulation, HTML, MySQL, MS-Office Products, RCS

North American Leisure Group (Contract with CNC Global) Nov 98 – April 99

Sunquest Vacation, Alba Tours. Toronto ON

Development of Applications for Yield Management

Analyzed the Business Requirement. Designed and Developed New Databases (Logically & Physically) for Data warehousing for Yield Management System.
Analysed an Automated Process to Extract, Transform & Load Data into these databases with the most recent data pertaining to Yield Management, from main Air-Line Reservation System on weekly basis. Perl, Awk and Unix Shell scripts along with Informix 4GL/SQL Programs and HPL was used to implement above ETL Tools
Error Handling are well implemented in the Programs and Failure of Job dependent Programs are Analysed and coded in such a way to Generate E-Mails to Job Responsible Recipients to take necessary actions
Analysed & Developed Application Programs to produce complex Yield Management Reports in three Commercial Management Units Located in Toronto, Vancouver and San Jose, Reports are fully parameter driven Management Decision Making Tool for Travel Wholesalers on their custom requirements.
Database tables indexed and triggered in order to run applications in an Optimum Level.
Applications are supplemented with Unix (Korn) Shell scripts to automate the Process flow to have seamless operation
Tested the Entire-Application for Data accuracy for various documented test cases
Provided the required Technical Details, Documents, Training and Support for Technical and End Users of the Application

Environment : WIN95 Clients with NT SERVER Networked with SUN E10000 (UNIX) Systems INFORMIX-4GL/SQL/SPL, On-Line Dynamic Server, HPL, X-Window System, HCL Exceed, MS Office Products, perl, awk, C, C++, FTP, Telnet, TCP/IP, ODBC, RCS source code control system

Maxium Financial Services Inc. (Contract with ISG) Aug 97 – Oct 98

Toronto ON

Development of Application for Asset/Lease Management

Analyzed/Developed Asset Management System for CIBC in an OLTP/ Batch Processing Environment. Application included Complex Parameter driven Reporting system. Implemented using Informix-4GL/SQL along with AIX Unix and awk scripts
Designed and Developed Leasing System for CIBC, Analysed the new business rules and Enhanced the above applications to fulfill their new user requirements
Database backup and restoration fully automated using Embedded SQL Scripts.
Complex ad-hoc SQL queries performed for Management Requirements

Environment :WIN95 Clients with NT SERVER Networked with IBM RS/6000 (AIX) Systems

INFORMIX-4GL/SQL, On-Line Dynamic Server, FTP, TCP/IP, Telnet, C, perl, awk, ODBC,

Unix Shell Scripts, MS Office Products, Crystal Reports, SQL Server 7.0, T-SQL, VB 5

Shoppers Drug Mart (On a Contract Basis with ISG) June 96- July 97

Toronto ON,

Development of Store-Financial System

Analyzed, Designed and Developed Sales Productivity and Marginal Reports for the Corporate Offices Located in Toronto. Deigned and Implemented above Database for Data warehousing intended for Budgeted and Projected Sales.
System Implemented Using Informix-4GL/SQL and Stored Procedures. Reports produced from the Data Extracted & loaded from Regional offices across the country.
Made available to Query/View these reports to the various user groups with relevant Grant Permissions of the organization structure
Optimized the performance with applying the required database triggers and indexes
Testing performed on these reports with documented Test Cases along with Complex SQL Queries
Various Front-end Applications are connected using ODBC to the main Informix Databases. Maintained & Enhanced Power Builder Front-end Store-Financial application.

Environment: WIN 95 Clients with Novell Server Networked with HP-UX Unix systems.

INFORMIX-4GL/SQL, SPL, On-Line Dynamic Server, C, C++, Perl, awk, Unix (Korn) Shell scripts, ESQL/C, FTP, TCP/IP, Telnet, Exceed X-Window Terminal Emulation, HTML, MS-Office Products, RCS source code control system, Power Builder 5

Logibro Inc. April 95 – April 96

Toronto ON

Development of Application software

Leisure Travel Industry & Internal Office

Various Enhancement work done for the LOGITOURS Travel Information System used by Travel Wholesales in the Industry. Sales Reports on Regional Geographical area Level developed and Added to the above application
Developed an On-Line Application for wholesale Flight Allocations in Air-Tansat to do their Flight allocations in bulk.
Designed & Developed Database/Application programs for On-Line Time Sheet System for Office Employees. Sun-Unix Mail messaging GUI interface used within the Application to communicate among respective subordinates/Supervisors on the issues to be resolved effectively in a Team environment.
Application also included Resource Allocation as well as Management Reporting tool for Managerial staff to make effective decisions on their on going Projects.

Environment : Sun Unix Systems networked with X-window Workstations, FTP, Telnet, C, Motif Xlib, Xt, awk, Shell scripts, INFORMIX-4GL/SQL, Internally developed Source-Code Control System

Brown & Company Ltd., Colombo July 92 – June 94

(On a Contract Basis with IBM SriLanka)

Development of Accounts Payable Module for Integrated Management Accounting System
Designed and Developed the required Database/Applications for Accounts Payable Module
Data pulled into new Unix System from IBM MVS Mainframe system with a proprietary application used by this client previously.
Prior to user acceptance, testing done for Data Accuracy on both Systems in parallel with the documented test cases including Complex SQL queries.
Developed Application Programs to Interface with General Ledger Module
Provided the Support for Basic AIX Administration, Operating System Maintenance

Environment:IBM RS/6000 (AIX) systems with Text Terminals, IBM MVS system, C, INFORMIX-4GL/SQL, SPL, awk, Unix Korn Shell Scripts

EDUCATION & TRAINING/COURSES/WORKSHOPS

BTech in Electrical Engineering, REC Warangal (Kakatiya University) AP India

IBM DB2 Administration for Linux Unix and Windows – IBM Canada
IBM DB2 Database Programming -- IBM Canada
INFORMATICA Power Center 7 Developer -- INFORMATICA Inc
Apache Web server College of Continuing Education -- Dalhousie University Halifax

OPERATING SYSTEMS

Linux/UNIX ( Red Hat, Fedora, Sun Solaris, HP-UX, AIX), X-Window System, NT/20XX Servers and Windows 95/98/XP,

PROGRAMMING LANUAGES & TOOLS

Java , C/C++, Perl, PHP, Python, Servlets, JSP, JIL, MQSeries, Unix/Linux shell/awk/sed/grep, 4GL, Visual Basic, Crystal Reports, Power Builder, JCreator, Eclipse, NetBeans, OOA/OOD/OOP, UML

J2EE Technologies

Servlets, Struts, Spring, EJB, JDBC, Java Beans, Hibernate, JMS, JAXB, MQ Series, Web Services, JNDI, Design Patterns.

Web Technologies

Servlet, JSP, AJAX, JQuery, JavaScript, GWT, XHTML, HTML5, PHP, CGI, XML, XSL, XSLT, XML Schema, SAX, DTD, DOM.

App/Web Servers

IBM WebSphere 5.1, Apache/Tomcat, GlassFish

RDBMS & SQL Variants

Sybase, IBM-DB2, Informix, Oracle, MySQL, Firebird, MS-SQL Server, MS-Access,

PL/SQL, TSQL, ESQL/C

Methodologies and Compliances

CMM Level 5 Methodologies and Best Practices in Enterprise Applications which adhere to SOX Compliances, Scrum Agile Methodologies

REFERENCES

Available upon request

Major Involvement in large scale global Information Technology projects in various domains for mission critical enterprise level applications in distributed computing environment

Extensive Experience in Application Software Design, Development in n-tier component based applications using Core Java and J2EE technologies with Special emphasis on OOA/OOD/OOP

Presentation of UML diagrams (Actors, Use Cases, Classes) for team collaboration

Java Frameworks Spring( MVC, AoP, IoC ), Spring Batch, Hibernate (ORM), Struts 2(MVC )

Usage of Apache, Tomcat and J2EE Application severs – GlassFish, WebLogic, WebSphere

Web Application Development in Servlet, JSP, JSF, JDBC, XML, XSTL, JAXP, JAXB, XHTML/HTML5, CSS, PHP, JavaScript, jQuery, AJAX

Excellent knowledge in Web Services JAX-WS and JAX-RS

Wide Usage of IDEs ( Eclipse, NetBeans ) and Build tools ( Ant, Maven )

Database Design, Development, Maintenance, and Modeling in Sybase, DB2, Informix, MySQL and Oracle.

Hands on Experience in Database design/development/modeling tools such as ERWIN, DBArtisan, Rapid SQL, TOAD, Sybase database designer etc., and SQL variants such as T-SQL, PL/SQL and ANSI standard specifications.

Excellent Knowledge and Experience in Data warehousing, OLTP, Stored-procedures, triggers, indexing requirements for fast data retrievals in large databases.

Different flavours of UNIX Operating Systems such as Sun Solaris, IBM-AIX, HP-HUX and Fedora/Red Hat Linux Enterprise System

Extensive Hands on development Experience in Perl, Unix Shell Scripting, sed, awk utilities

Experience in Windows Servers(NT/20xx), XP, Win-7 clients

Wide Exposure in job scheduling tools such as AutoSys, Crontab, and Mastero

Enhanced Java Applications to Extract & Transform Data from multiple internal data Sources ( CIBC Enterprise Trading System, ATM Sytems feeds etc. ) connected to Enterprise Oracle databases. Finally Loaded data into Sybase MIS Database ( Enteprise Data Reporting System )

Enhanced the Sybase/Oracle stored procedures to meet the current requirement of the Dynamic Foreign Currency Conversions at ATM

Analyzed and Enhanced the existed Java Distributed Applications launched in WebLogic Server for Employee Trade Processing. Required Data extracted from external vender feeds, and connected with internal oracle databases for application data validation.

Interacted with internally developed web services to have a seamless data flow across various Control Room Applications in the firm.

Analyzed Issues and Provided Solutions/Enhancements to Java/XML/MQ Applications used in OTC Derivative Processing Area.

Enhanced Applications with Messages originated from various upstream front-office booking systems with different Asset Classes in different formats to a Unified format in order to be used by various downstream Applications in a consistent DWML internal format of the firm

Enhanced Legacy DB2/Sybase Stored Procedures to suit the new OTC Derivative Processing Requirements

Developed stored procedures and triggers. Created New Tables, views and indexes to accommodate the functionality, Security, and for fast data retrievals respectively.

Designed and Developed Java Applications to extract ‘corporate actions’ from XML data feeds provided by external Vendors across the globe as per the vendor specific formats through middleware queues ( IBM WebSphere MQ) .

Most recent Corporate Action Updates uniquely Identified and Updated the target ‘Enterprise Database’ in real-time for firm-wide usage upon validation.

Created Perl/Unix shell wrapper scripts to automate and integrate these firm-wide mission critical applications using VCS clustered hosts.

Enhanced the Java multi-threaded Real-Time ‘vendor data listener’ server process to receive very large amount of Global Dividend Announcements declared by external vendors through IBM WebSphere MQ messages in XML formats defined by vendor rules and standards.

Mapped and processed them as per the business logics and requirements and made available in database tables instantly by inserting/updating the required records. Information used for Dividend Projections.

Communicated to other server processors using in-house developed Publisher/Subscriber Queues.

Modified the Linux Stock Server Process developed in C++/Java using various data structures and algorithms to calculate and project future dividends for traders based on the current patterns.

Made these streams available to traders by developing Servlet/JSP web applications.

Developed and Implemented a Generic Netcool alerting mechanism to notify the support teams during critical server issues.

Server Processes implemented in VCS clustering system to kick in the backup servers to minimize production downtime.

Developed stored procedures and web-services to access ‘Corporate Actions’ and ‘Dividend Projection’ information for downstream users and applications.

Maintained the company web applications for landlords to check the credit scores of their clients by accessing the credit bureaus.

Designed and developed on-line Web based tenant content Insurance Application. Integrated with the firm’s web-applications and databases. Designed, modelled, and implemented required database schema changes, Stored Procedures, and Triggers etc.

Carried out Development, Integration, Automation, and Production Support for Actimize Intelligence Models. Automation scripts developed for AML applications to be executed on windows servers with associated Informatica ETLs processed in a networked Linux servers

Developed Unix Shell/Perl scripts to extract raw-data from various sources and loaded to target fact tables of DB2/Sybase Databases. Developed generic looping mechanism to process the data as and when available from the source providers

JSP/Servlet web-applications developed for end-users to alert the issues.

DB2/Sybase data-loading scripts developed generically for daily, weekly and monthly job Cycles to process in a robust manner with least manual intervention

Batch job Cycles scheduled, implemented and maintained using Autosys JIL language as per the business needs with the proper load distribution on Linux/Windows Hosts

Processed alerts made available to business users through Java web applications and archived periodically to IBM On-Demand servers

Enhanced Firm-Risk Applications to work in an accurate and robust manner using the PVM software in a distributed environment for credit simulations using numerous logics and data structures in Perl, C/C++ and Java. Developed Sybase Stored Procs to make these Data available for these Applications

Debugged the Application programs used in the firm and provided the emergency solutions whenever required to keep the production downtime minimum

Analyzed Business Requirements and carried out required Development work and the Database Designs for the given Enhancements.

Facilitate customers to view their Bills on-Line. Data Extracted from the existing Billing System and Loaded to the Web Server. Automated the Process using Java, Unix Shell scripts including C, Perl, Awk Utilities and Informix-4GL/SQL Programs.

Application Program Development and Database Changes are done as per the needs. Recommended and Implemented the system changes to optimize performance

Development work done rapidly to meet the competitive marketing requirement changes in the industry, Enhancements done in several database driven Perl and ESQL/C Programs used in the firm

Credit Rating and Collection Program Changes are done in the existing On-Line Transaction Processing Environment

Analyzed the Business Requirement. Designed and Developed New Databases (Logically & Physically) for Data warehousing for Yield Management System.

Error Handling are well implemented in the Programs and Failure of Job dependent Programs are Analysed and coded in such a way to Generate E-Mails to Job Responsible Recipients to take necessary actions

Analysed & Developed Application Programs to produce complex Yield Management Reports in three Commercial Management Units Located in Toronto, Vancouver and San Jose, Reports are fully parameter driven Management Decision Making Tool for Travel Wholesalers on their custom requirements.

Database tables indexed and triggered in order to run applications in an Optimum Level.

Applications are supplemented with Unix (Korn) Shell scripts to automate the Process flow to have seamless operation

Tested the Entire-Application for Data accuracy for various documented test cases

Analyzed/Developed Asset Management System for CIBC in an OLTP/ Batch Processing Environment. Application included Complex Parameter driven Reporting system. Implemented using Informix-4GL/SQL along with AIX Unix and awk scripts

Designed and Developed Leasing System for CIBC, Analysed the new business rules and Enhanced the above applications to fulfill their new user requirements

Database backup and restoration fully automated using Embedded SQL Scripts.

Analyzed, Designed and Developed Sales Productivity and Marginal Reports for the Corporate Offices Located in Toronto. Deigned and Implemented above Database for Data warehousing intended for Budgeted and Projected Sales.

System Implemented Using Informix-4GL/SQL and Stored Procedures. Reports produced from the Data Extracted & loaded from Regional offices across the country.

Made available to Query/View these reports to the various user groups with relevant Grant Permissions of the organization structure

Optimized the performance with applying the required database triggers and indexes

Testing performed on these reports with documented Test Cases along with Complex SQL Queries

Various Front-end Applications are connected using ODBC to the main Informix Databases. Maintained & Enhanced Power Builder Front-end Store-Financial application.

Environment: WIN 95 Clients with Novell Server Networked with HP-UX Unix systems.

Various Enhancement work done for the LOGITOURS Travel Information System used by Travel Wholesales in the Industry. Sales Reports on Regional Geographical area Level developed and Added to the above application

Developed an On-Line Application for wholesale Flight Allocations in Air-Tansat to do their Flight allocations in bulk.

Designed & Developed Database/Application programs for On-Line Time Sheet System for Office Employees. Sun-Unix Mail messaging GUI interface used within the Application to communicate among respective subordinates/Supervisors on the issues to be resolved effectively in a Team environment.

Development of Accounts Payable Module for Integrated Management Accounting System

Designed and Developed the required Database/Applications for Accounts Payable Module

Data pulled into new Unix System from IBM MVS Mainframe system with a proprietary application used by this client previously.

Prior to user acceptance, testing done for Data Accuracy on both Systems in parallel with the documented test cases including Complex SQL queries.

Developed Application Programs to Interface with General Ledger Module

BTech in Electrical Engineering, REC Warangal (Kakatiya University) AP India

IBM DB2 Administration for Linux Unix and Windows – IBM Canada

IBM DB2 Database Programming -- IBM Canada

INFORMATICA Power Center 7 Developer -- INFORMATICA Inc