Uploaded File
add photo
Kandaswamy
Kkanakaraj6@gmail.com
848-248-2906
Monmouth Junction, NJ 08852
Senior PL/SQL Developer/Architect
28 years experience W2
1
Recommendation
Average rating
145
Profile views
Summary

  • Over 14 years of IT experience in enterprise database solution.

  • Strong in Oracle PL/SQL and is passionate about data and understanding data relationships

  • Strong in SQL Performance tuning, de-normalization techniques and designing flexible and scalable ETL process for very large volume global data-warehouse.

  • Commitment to quality from requirements through design, construction, testing, and installation.

  • Experienced in database architecture, Data Analysis, Data Integration, Data Profiling, Data Modelling and data-warehouse design.

  • Good knowledge in Java, J5EE, and BI Reporting tools such as SAP Business warehouse.

  • Worked in leading US Financial institutions such as Citi, Merrill Lynch, Capital One, Standard & Poor’s, Bank of New York and Albridge Wealth Management solutions.

TECHNICAL SKILLS

Software: PL/SQL, UNIX, SQL

Op. Systems: Sun Solaris, HP-UNIX, NT
Databases: Oracle, Sybase and MS Access
Internet: HTML, JAVA (working knowledge)
Project management tools: MS Office, MS Excel, MS Project, Visio

Certifications:

Oracle 9i Database Administrator Certified Professional (OCP)

Sun Certified Programmer for Java 2 Platform 1.4

Experience
Senior Oracle PL/SQL Lead
Information Technology
Oct 2016 - present
  • Responsible for providing Database Solutions for ODS Datawarehouse of Hedge Fund Services
  • Responsible for real-time loading of the Fund, account,class, series, holding and Nav information to enhance and optimize current state
  • Responsible for developing data conversions, interfaces, complex reports/extracts, and workflow
  • Performance tuning and writing complex dynamic SQL Analytical queries.
  • Designing data structures and providing complete SDLC support and architecture design of database solutions in between each sprint.
  • Writing PL/SQL backend procedures for ETL process to load data into ODS from various source systems like SQL Server and Oracle.
  • Document the whole process flow
  • Involved in the continuous enhancements and fixing of production issues.
  • Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
  • Managed Ab initio developers and provided minimal support during heavy work loads.
  • Creating plans, graphs and processes in Ab initio for Real-time loads.
  • Maintaining Java code to support JMS Queues.

Environment: Oracle 11g, SQL, PL/SQL, SQL*plus, Windows 8,Linux, Unix, SQL Server, Ab Initio, JMS queues.

Data Warehousing Java Oracle Oracle 11i PL/SQL UNIX PL/SQL Developer Performance Tuning SQL SQL Server ETL JMS Database Design Linux Data Conversion Windows
Remove Skill
Sr. Oracle PL/SQL Developer / Database Architect
Banking/Financial
May 2015 - Oct 2016
Jersey City, NJ
  • Responsible for enhancing Risk Correlation DataMart used for trade surveillance. This data mart is extracted out of various financial instrument’s transactions, position, settlement, fails and mark to market information.
  • Producing surveillance reports.
  • Analysis of upstream and downstream data.
  • Performance tuning and writing complex dynamic SQL.
  • Analytical queries.
  • Designing data structures and providing complete SDLC support and architecture design of database solutions in between each sprint.
  • Wrote PL/SQL backend procedures for ETL process to load data into Enrollment Datamart from various source systems like SQL Server and Oracle.
  • Document the whole process flow: PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.
  • Involved in the continuous enhancements and fixing of production issues. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.

Environment: Oracle 11g, SQL, PL/SQL, SQL*plus, Windows 8.

Database Architect Oracle Oracle 11i PL/SQL PL/SQL Developer Database Design Data Marts SQL SQL Server ETL Performance Tuning SQL Developer SDLC Windows
Remove Skill
Senior Database developer/Architect
Information Technology
Sep 2011 - Apr 2015

Maintaining and enhancing the PPM (Performance and Planning management) Application for the Finance and Planning Department. It is a Business Datawarehouse used for reporting on the financial performance of the entire operations. The Logic for transforming the data is in Oracle database, inputs to the database are via Informatica (ETL Tool) the final transformed data is fed to SAP Business warehouse for reporting.

Environment: Informatica 9.1 , Oracle 11g and SAP Business Warehouse.

Responsibilities:

  • Writing Complex SQL Queries, Dynamic SQL and Analytical function
  • Deploy business rules into PL/SQL code for data analysis, transformation, and cleansing.
  • Create tables, views, procedures and PL/SQL code and create wrapper unix shell scripts.
  • Support UAT test, production, user ad hoc request.
  • Query Optimization, Debugging, and Tuning for improving performance
  • Lead projects through all SDLC phases till deployment and work with the team to ensure timely delivery of project tasks.
  • Provide recommendations for new data warehouse mart design as well as improvements in current data warehouse
  • Work with Center of Excellence (COE) for finance and understand the financial reporting need (Key performance index) and help drafting business requirement document and Technical requirement documents.
  • Analyzed the existing data model and maintained the data model for changes using ERWIN.
PL/SQL SDLC Oracle SAP Data Analysis Data Warehousing Database Design Erwin Data Modler Oracle 11i SQL UNIX Shell Scripts
Remove Skill
References
Average Rating

1 recommendation
senior Programmer analyst
Banking/Financial
May 2008 - Sep 2011

As senior Programmer analyst supported and maintained Metlife’s Back office Brokerage reporting data warehouse. A Customer centric Data warehouse was built to capture data snapshot for Trades, Positions, Balances and corporate actions from all prime products. All data from prime transaction systems are synced up in near real time basis to provide very latest and timely customer’s snapshot to support business in their decision making process . This warehouse is used as a single reporting source for Customer’s AS-IS and AS-WAS Statements and Customer 360 view. Primary responsibility was to enhance the functionality of existing PL/SQL stored procedures and packages to suite the new requirement.

Environment: Oracle 10G & 11G, Java, Tibco and weblogic.

  • Created batch jobs to load all incoming asset transactions and position to oracle database using Korn shell and PL/SQL.
  • Design & develop database structures & ETL programs in PL/SQL to load data from financial data providers like DST and Pershing into staging tables, and conforming and loading the data into dimension and fact tables.
  • Wrote complex queries in SQL and PL/SQL to migrate the data warehouse to a new database server, integrating from two previous production servers into one.
  • Designed developed data mart and the ETL Process to populate it in PL/SQL.
SQL PL/SQL Oracle Java TIBCO Korn Shell Data Warehousing Data Marts Database Design Stored Procedure BEA WebLogic
Remove Skill
Senior Tech Specialist/ Technical Project Manager
Banking/Financial
Oct 2006 - Mar 2008

Worked as a senior technology specialist in GTPL (Global Transaction Profit and Loss) system.This back office system is developed to consolidate and replace four systems performing similar (P&L) calculations. It will function as the profit and loss calculation engine for all the trades generated by Citi Globally.This system was developed in multiple phases spanning over four years and uses offshore and on-shore resource model.

Environment: Oracle 10G, Java, Ab Initio, Tibco and weblogic.

  • Design and develop oracle OLTP modules to capture trades and ETL Process to load the Data warehouse for P & L reporting.
  • Designed and developed packages, procedures, functions and Triggers in oracle to provide quick response.
  • Provide expert advice to improve performance and proper choice of tools for developing a particular module.
  • Recommended Ab Initio over PL/SQL for an ETL process. Designed the graphs with the help of Ab Initio consultants and took it through the SDLC process using Off-shore consultants.
  • Perform code reviews/ mentor offshore development team.
  • Provide UAT testing assistance, release management and production support.
  • Heavily interacted with users in refining the requirements and worked closely with the Business analyst to come up with the Technical requirement document.
  • Produced system architecture diagram in Visio.
  • Determined appropriate data storage, archive, purge and backup strategies by collaborating with DBA and system Administrators through weekly Meetings.
  • Established standards and formulated scripts for sanity checks after major release.
  • Maintained multiple database schemas to conduct parallel testing of different phases of GTPL. Involves working with the release team and the development team to synch the database changes for different phases.
  • Provided impact analysis on existing procedure due to schema changes and estimating the amount of change required to incorporate the change.
  • Analyzed the existing data model and maintained the data model for phase 2 changes using ERWIN.
  • Provided performance tuning on existing OLTP queries in production as well as development environment.
  • Enforced database standards and naming convention.
  • Worked closely with the Java developers in providing certain components as web services to other enterprise application.

Achievements:

  • Gained in depth knowledge of US Capital markets and Trading practice.
  • Created an awk, korn shell script to generate multi environment Autosys JIL script.
  • Successfully developed and implemented the phase II of GTPL and involved in design of Phase III.

Technology component/design skills used:

  • Designed and mentored offshore team on creating and writing efficient PL/SQL code.
  • Developed PL/SQL functions, procedures, packages and triggers using 10 G new features.
  • Used Korn shell and PL/SQL procedures and packages for Batch data Loads.
PL/SQL Ab Initio OLTP UAT ETL Shell Scripts Korn Shell WebServices Erwin Data Modler Database Design Data Warehousing Oracle SQL Release Management SDLC Business Analysis MS Visio Project Management
Remove Skill
Senior Programmer/ Analyst
Information Technology
Jan 2005 - Jul 2006

Albridge Wealth Reporting is a Web-based portfolio accounting and performance reporting application that allows financial advisors to access and report on high quality client account information that has been normalized and reconciled using Albridge Solutions proprietary process. With Albridge Wealth Reporting, advisors can view their entire book of business and produce reports in a single Web-based application.

Environment: Oracle 9.2, Java, weblogic on Sun solaris platform, Shell scripts and Sql Loader.

Achievements:

  • Design & develop database structures & ETL programs in PL/SQL to load data from financial data providers like DST and Pershing into staging tables, and conforming and loading the data into dimension and fact tables.
  • Wrote complex queries in SQL and PL/SQL to migrate the data warehouse to a new database server, integrating from two previous production servers into one.
  • Designed developed insurance data mart and the ETL Process to populate it in PL/SQL.

Technology component/design skills used:

  • Created batch jobs to load all incoming asset transactions and position to oracle database using Korn shell, Awk, PL/SQL and SQL Loader.
  • Used Java and JDBC connection for running batch process that could be stopped and re- started by operations depending upon the load.
  • Involved in Query-tuning and optimization of the stored procedures and sql to enhance database performance.
  • Data Warehouse schema design and modeling.
  • Database object, such as large partitioned tables, indexes, and synonyms implementation.
  • Data integrity verification and database synchronization.
  • Database applications development based on PL/SQL, Packages, and Stored procedures.
  • ETL tools development based on PL/SQL and Unix Shell.
  • Requirement, specification and detail design for data warehouse and data mart.
  • Responsible for maintaining the physical database schema in ERWIN.
ETL PL/SQL SQL Korn Shell SQL Loader Shell Scripts Application Development Data Warehousing Data Marts Data Integrity Database Design Erwin Data Modler Oracle Stored Procedure Java JDBC UNIX BEA WebLogic
Remove Skill
Senior Systems Analyst
Information Technology
Aug 2003 - Jan 2005

Responsible for the maintenance of the Data warehouse ETL process written in PL/SQL used for generating the Data warehouse for NCLB (No Child Left Behind Act). The total database is 1.2 Tetra bytes in Size.

Environment: Oracle 8i, Java and weblogic.

Achievements:

  • Rewrote the Push Process that populates the Web site schema and achieved significant increase in push time from 12hrs to less than two hours. Used Partitions and truncated the partitions and rebuild of those partitions as opposed to truncating and indexing the whole fact table
  • Provided pre-checks before running pushes and generates so that the process does not fail in the middle of processing due to space issues.
  • Replaced existing Java based loader with one written in Oracle PL/Sql and SAS macros. SAS is used as data cleansing and QA environment as the DATA comes in from various states in the form of SAS datasets and flat files. Increased the performance multi-fold using bulk inserts and parallel processing using multiple calls from SAS.
  • Reduced the execution time of the Java Loader from several hours to less than one hour by writing the process in PL/ SQL. Provided multi-user capability and multi-file loading capability as a result users need not run the Loader manually for each file to be loaded.
  • Designed and implemented oracle packages and procedures to perform sorting and paging for the Java JSP pages in an efficient manner.
  • Enabled the Web interface to accept data in the form of java arrays which enabled the users in creating their own customized reports and saving them. Before this the Website was strictly a reporting site.
  • Created Advanced search capabilities on the website which enabled users to perform customized search. Created a small relational data mart for this special feature and designed dynamic queries using dbms_sql package to deliver this feature.
Oracle 8 Java SAS PL/SQL ETL SQL Oracle Database Design Data Warehousing Data Marts Data Cleansing Database Maintenance System Analysis
Remove Skill
Hopewell (Consultant)
Information Technology
Jan 2002 - May 2003

Responsible for the Back end Database changes for the EOWIN Application (Employee Stock options management) . The application takes care of Stock options for different companies. This database serves multiple applications using tools such as C++ and ASP.

Environment: Oracle 8i, C++ and ASP.

Oracle 8 C++
Remove Skill
Analysis Design and development
Banking/Financial
Feb 2002 - Jul 2002

Responsible for the Analysis Design and development of Baltrax system’s Balance Transfer with Fee module. The system is developed in Java/ JSP/Servlets and Oracle 8i.

Environment: UNIX, Powerbuilder 7.0, NT workstation, Oracle 8 i, Shell scripts, Control – M.

UNIX PowerBuilder Oracle 8 JSP Shell Scripts
Remove Skill
Independent consultant
Banking/Financial
Apr 1999 - Jan 2002

Hands-on technical leader responsible for entire life-cycle of the MSPA application which tracks various Merrill Lynch Marketing projects, maintains incoming invoices and payment of those invoices, in PowerBuilder, ASP with Oracle as database server on Sun Solaris operating system.

Environment: UNIX, Powerbuilder, Oracle 7.3/8 i, Korn Shell scripts, Autosys

UNIX PowerBuilder Oracle Korn Shell AutoSys Shell Scripts
Remove Skill
Senior developer of the PCFast system
Banking/Financial
Jan 1999 - Apr 1999

Senior developer of the PCFast system, which is a versatile financial management application that offers extensive analysis and manipulation of plan, trend, and forecast data. This application uses Powerbuilder 5.0.02 and uses Oracle 7.3 as database server.

Environment: UNIX, Powerbuilder 5.0.02, NT workstation, Oracle 7.3/8.0.1, Shell scripts

UNIX PowerBuilder Oracle Shell Scripts
Remove Skill
Designer
Information Technology
Oct 1998 - Dec 1998

Redesigned and developed the customer database management module. This module updates customer information when one customer exchange carrier acquires another exchange carrier. This system uses Powerbuilder 5.0.02 as front-end tool and Oracle 7.3 as database server.

Environment: UNIX, Powerbuilder, NT workstation, Oracle 7.3, Shell scripts

UNIX PowerBuilder Oracle Shell Scripts Database Design
Remove Skill
Engineer
Banking/Financial
Jul 1998 - Oct 1998

Re-engineered the Earnings and Dividend Management System. This system receives the incoming news wires, faxes, e-mails and presents it to the statisticians who further check the earnings release and enter it into the database. It provides various interfaces with the databases for statistical reports. Tasks included redesigning the user interface in Powerbuilder, developing shell scripts and C programs to push and pull data from news wires (e.g. : PR News wires) , redesigning database existing in Sybase system 11.0 and identifying necessary reusable processes written in C.

Environment: UNIX, Powerbuilder 5.0.02, NT workstation, Sybase 11.0, Shell scripts

UNIX PowerBuilder Sybase C Shell Scripts Database Design
Remove Skill
Senior Programmer/ Analyst
Insurance
Nov 1996 - Jul 1998

Senior programmer for Life insurance system that provides Metlife's sales representatives to access the information remotely and retrieve the necessary information for different insurance policies and quote the terms and conditions instantly. This sytsem is installed in Windows NT and Sybase 11.0.

Environment: UNIX, Powerbuilder 5.0, NT workstation, Sybase 11.0 , Shell scripts

Sybase UNIX PowerBuilder Windows NT Shell Scripts Windows
Remove Skill
Developer
Telecommunications
Sep 1995 - Nov 1996

Designed and developed the user interface for Announcement Management System which manages announcement phrases and places announcements on switching circuits used by the Telecommunication Industries. Developed pre-defined and ad hoc reports for this system in Powerbuilder 4.0 and Watcom SQL.

Managed the implementation and configuration of PNDM system on UNIX platform with Oracle 7.3 as database server. This system provides the physical layout of all the devices in a hybrid of Fiber-optic and co-axial cable loop for telephone lines. Managed the integration of the system everyday using shell scripts and Sublime. Implemented shell scripts that loaded test data in HP UNIX environment using Oracle 7.3. The front –end used C++ .

Environment: Powerbuilder, NT workstation, Watcom SQL, UNIX, Oracle 7.3, UNIX, C++

C++ UNIX Oracle Database Design PowerBuilder Shell Scripts SQL Fiber Optics
Remove Skill
Various
Chemicals/Pharmaceuticals
May 1995 - Sep 1995

This system manages the complaints on Ortho's products in accordance with FDA regulations. This system is designed for multiple users with proper security and auditing capabilities. Used OOPS concepts, VBXs, OLE, MDI, Datawindows, Classes, DLLs, Stored Procedures and Triggers.

Environment: Powerbuilder 3.0, Windows 3.1 and MS SQLServer 4.2

PowerBuilder Windows 3.x OOP
Remove Skill
Various
Information Technology
Jan 1995 - Apr 1995

Developed the Personnel Information System, which is used by consulting companies. It keeps track of employee records, like benefits, vacation, payroll, status, etc. Developed the system in Powerbuilder 3.0 and Sybase 10.

PowerBuilder Sybase
Remove Skill
Research Engineer
Manufacturing
Dec 1992 - Dec 1994
  • Developed a Model in C that can predict the flow of fluids in open channel.
  • Developed an experimental setup and used C program to read the input from the sensors to a file which can later be imported into excel for analysis of the experimental result.
C
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Electrical and Electronics
MADRAS UNIVERSITY
Certifications
Oracle 9i Database Administrator Certified Professional (OCP)
Sun Certified Programmer for Java 2 Platform 1.4
Skills
Database Design
2021
17
Oracle
2021
17
SQL
2021
14
PL/SQL
2021
13
Shell Scripts
2015
13
Data Warehousing
2021
12
UNIX
2021
12
Korn Shell
2011
9
ETL
2021
8
Data Marts
2016
7
PowerBuilder
2002
7
Windows
2021
7
Erwin Data Modler
2015
6
Java
2021
6
SDLC
2016
6
Oracle 11i
2021
5
BEA WebLogic
2011
4
Stored Procedure
2011
4
Data Analysis
2015
3
Data Conversion
2021
3
JMS
2021
3
Linux
2021
3
SAP
2015
3
TIBCO
2011
3
AutoSys
2002
2
Business Analysis
2008
2
C
1998
2
C++
2003
2
MS Visio
2008
2
Oracle 8
2005
2
PL/SQL Developer
2021
2
Project Management
2008
2
Release Management
2008
2
SQL Server
2021
2
Sybase
1998
2
System Analysis
2005
2
Ab Initio
2008
1
Application Development
2006
1
Data Cleansing
2005
1
Data Integrity
2006
1
Database Architect
2016
1
Database Maintenance
2005
1
Fiber Optics
1996
1
JDBC
2006
1
OLTP
2008
1
Performance Tuning
2021
1
SAS
2005
1
SQL Developer
2016
1
SQL Loader
2006
1
UAT
2008
1
WebServices
2008
1
Windows NT
1998
1
Data Integration
0
1
Data Modeling
0
1
Data Profiling
0
1
DBA
0
1
HP
0
1
HTML
0
1
JSP
2002
1
Microsoft Excel
0
1
MS Project
0
1
OOP
1995
1
Solaris
0
1
Sun
0
1
Windows 3.x
1995
1