Uploaded File
Kandaswamy
Kkanakaraj6@gmail.com
848-248-2906
Monmouth Junction, NJ 08852
Sr. Database Architect
30 years experience W2
1
Recommendation
Average rating
175
Profile views
Summary

  • Over 20 years of IT experience in the enterprise database ecosystem.
  • 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 processes for very large volume global data-warehouse.
  • Spark, Dataframe basics, and Python coding experience.
  • Involved in all Seven steps of a data migration project.
  • Commitment to quality from requirements through design, construction, testing, and installation.
  • Experienced in database architecture, Data Analysis, Data Integration, Data Profiling, Data Modelling data lineage, data governance and data-warehouse design.
  • Experienced in designing reconciliation between upstream and downstream systems.
  • Good knowledge of 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.
  • Well-versed in Ralph Kimball Data Warehouse Design.
  • Experience with Big Data ecosystem with processing engines Spark/Hive/Hadoop.
  • Architect, design and build scalable infrastructure and platform to collect and process very large amounts of data (structured and unstructured), including streaming real-time and complex system integrations.
  • Work in an IC Role as well as lead a team of designers as needed.

TECHNICAL SKILLS

Software: PL/SQL, UNIX, SQL, Erwin, Python, and Spark

Op. Systems: LINUX, Sun Solaris, HP-UNIX, NT

Databases: Oracle, Spark data frame, and Sybase

Internet: HTML, JAVA (working knowledge)

Project management tools: MS Office, MS Excel, MS Project, Visio

Experience
Sr. Database Architect
Healthcare
May 2020 - Jul 2021
  • Responsible for providing Database Solutions for Aetna’s ODS Datawarehouse.
  • To enhance and optimize the current state and to maintain LDM and PDM in Erwin software.
  • Responsible for developing data conversions, interfaces, complex reports/extracts, and workflow
  • Performance tuning and writing complex dynamic SQL and analytical queries.
  • Designing data structures and providing complete SDLC support and architecture design of database solutions in between each sprint.
  • Wrote application in Spark Python to move the enormous amount of data to HDFS system from Oracle. Mainly Audits and archivable data from Oracle tables to HDFS with a feedback loop to make sure the scooping has been successful
  • Wrote Spark python, using spark SQL to capture messages from different applications and transformed the messages using Oracle.
  • Wrote PL/SQL backend procedures for ETL process to load data into ODS from various source systems.
Data Conversion Data Warehousing Database Architect Erwin Data Modler ETL HDFS Oracle Performance Tuning Spark SQL Python SDLC OPTIM PL/SQL
Remove Skill
Datamodeler / Database Architect
Information Technology
Jan 2020 - Feb 2020
  • Responsible for managing the changes to the clients Logical Data Model and Physical Data Model resulting due to change requests.
  • Interacting with client SME and Finalising the changes to the Logical and Physical model in Powerdesigner.
  • Providing a design approach for moving the LDM, PDM, and CDM files into the repository and maintaining versioning in Powerdesigner 16.6 software.
  • Provide expert advice to write well-tuned SQL in the SAP Hana database.
Database Architect SQL SAP HANA SAP Powerdesigner
Remove Skill
Sr. Oracle PL/SQL Lead / Database Architect & Advisor
Information Technology
Oct 2016 - Nov 2019
Jersey City, NJ
  • 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 the current state and to maintain LDM and PDM in Erwin software.
  • Responsible for developing data conversions, interfaces, complex reports/extracts, and workflow
  • Performance tuning and writing complex dynamic SQL and 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 ODS from various source systems like SQL Server and Oracle.
  • Document the whole process flow in the Idera data modeling tool.
  • Involved in the continuous enhancements and fixing of production issues.
  • Managed Ab initio developers and provided minimal support during heavy workloads.
  • Creating plans, graphs, and processes in Ab initio for Real-time loads.
  • Lead role in data migration project resulting in moving Sybase application into Oracle SS&C Tech environment as a product of acquisition.
  • POC using Big Data ecosystem with processing engines Spark/Hive/Hadoop.
  • Migrated Ab Initio real-time graphs to Spark data frame and oracle stored procedure, thereby eliminating Ab Initio tool usage.

Environment: Oracle 11g, Oracle 12C, SQL, PL/SQL, SQL*plus, Windows 8, Linux, Unix, SQL Server, Ab Initio, JMS queues, Microsoft Excel, Access, PowerPoint and OBIEE

Ab Initio Big Data Data Conversion Data Migration Data Modeling Data Warehousing Database Architect Erwin Data Modler ETL Hadoop Hive Linux Microsoft Excel OBIEE Oracle Performance Tuning Spark SQL SQL Server Stored Procedure Windows 8 Windows UNIX SDLC Oracle 11i Oracle 12c JMS OPTIM PL/SQL
Remove Skill
Sr. Oracle PL/SQL Developer / Database Architect
Information Technology
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, Oracle 12C, SQL, PL/SQL, SQL*plus, Windows 8.

Data Marts Database Architect ETL Oracle Performance Tuning SQL SQL Developer SQL Server Windows Windows 8 SDLC Oracle 12c PL/SQL
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 the Oracle database, inputs to the database are via Informatica (ETL Tool) the final transformed data is fed to the 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 to draft 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 OPTIM
Remove Skill
References
Average Rating

1 recommendation
Senior Database Developer / Architect
Information Technology
May 2008 - Sep 2011

Supported and maintained Metlife's Back-office Brokerage reporting data warehouse. A Customer-centric Data warehouse was built to capture data snapshots for Trades, Positions, Balances, and corporate actions from all prime products. All data from prime transaction systems are synced up on a near real-time basis to provide the very latest and timely customer snapshot to support businesses 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 suit the new requirement.

  • Responsible for ETL Architecture and Data Integration, Data Quality, and Data Modeling of Data warehousing systems
  • Created batch jobs to load all incoming asset transactions and positions to oracle database using Unix Korn shell wrapper and PL/SQL.
  • Designed & 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 using oracle analytical functions in SQL and PL/SQL to perform complex business logic on tables containing millions of records.
  • Extensively used functions, procedures, triggers, and packages.
  • Designed partitioned tables and created indexes where necessary to improve performance.
  • Performance tuned SQL Queries using explain plan and AWR report.
  • Designed developed data mart and the ETL Process to populate data marts in PL/SQL.
  • Provide estimations for changes, Perform code reviews, attend a change management meeting
  • Provide UAT testing assistance, release management, and production support.
  • Analyzed the existing data model and maintained the data model for changes using ERWIN.
  • Involved in enhancement and support of Risk Web Application using Java, J2EE, and WebLogic.
  • Maintained system architecture diagram in Visio.
  • Involved in migrating existing Unix shell script to develop file loading feature using Python 2.6.
  • Performed DBA activities like maintaining roles, privileges, installing, and back up of the new database.

Environment: Oracle 10g & 11g, Java, Tibco, WebLogic, and Python

BEA WebLogic Data Integration Data Marts Data Modeling Data Warehousing DBA Erwin Data Modler ETL J2EE Java Oracle Python Shell Scripts SQL Stored Procedure System Architecture TIBCO Triggers UNIX PL/SQL
Remove Skill
Senior Database Developer - Project Manager
Information Technology
Oct 2006 - Mar 2008
Warren, NJ

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 models.

  • Design and develop oracle OLTP modules to capture trades and ETL Processes to load the Data warehouse for P & L reporting.
  • Designed and developed packages, procedures, functions, and Triggers in oracle to provide a 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 them 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.
  • Determining 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 a 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 a development environment.
  • Enforced database standards and naming conventions.
  • Worked closely with the Java developers in providing certain components as web services to other enterprise applications.

Environment: Oracle 10g, Java, Ab Initio, Tibco, and WebLogic.

Achievements:

  • Gained in-depth knowledge of US Capital markets and Trading practices.
  • Created an awk, Korn shell script to generate multi-environment Autosys JIL script.
  • Successfully developed and implemented phase II of GTPL and was involved in the 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.
Ab Initio BEA WebLogic Data Warehousing Database Backups DBA Erwin Data Modler ETL Java MS Visio OLTP Oracle Performance Tuning Project Management Release Management SDLC Shell Scripts SQL System Architecture TIBCO Triggers WebServices Korn Shell PL/SQL
Remove Skill
Senior Programmer/ Analyst
Information Technology
Jan 2005 - Jul 2006
Lawrenceville, NJ

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 Solution's proprietary process. With Albridge Wealth Reporting, advisors can view their entire book of business and produce reports in a single Web-based application.

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.

Environment: Oracle 9.2, Java, WebLogic on Sun Solaris platform, Shell scripts, and SQL Loader.

Technology component/design skills used:

  • Created batch jobs to load all incoming asset transactions and positions 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 objects, 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.
Java SQL Stored Procedure UNIX Sun SQL Loader Solaris Shell Scripts Oracle Korn Shell JDBC ETL Erwin Data Modler Data Warehousing Data Marts Data Integrity BEA WebLogic Application Development
Remove Skill
Senior Systems Analyst
Information Technology
Aug 2003 - Jan 2005
New York, NY

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.

Achievements:

  • Rewrote the Push Process that populates the Web site schema and achieved a significant increase in push time from 12hrs to less than two hours. Used Partitions and truncated the partitions and rebuild 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 a 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 a customized search. Created a small relational data mart for this special feature and designed dynamic queries using the dbms_sql package to deliver this feature.

Environment: Oracle 8i, Java, and WebLogic.

Java SAS SQL System Analysis Quality Assurance Pages Oracle 8 Oracle ETL Data Marts Data Cleansing BEA WebLogic
Remove Skill
Consultant / Developer
Information Technology
Dec 1992 - May 2003

Merrill Lynch, Hopewell (Consultant)
10/1/2002 – 5/31/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.

Capitalone (Consultant)
2/12/2002 – 7/27/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.

Merrill Lynch, Plainsboro, NJ (Consultant)
4/99 – 1/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

Chase Manhattan Mortgage Corporation, NJ.
1/99 - 4/99

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

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

NECA National Exchange Carrier Association, Morristown, NJ.
10/98 - 12/98

  • 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 a front-end tool and Oracle 7.3 as the database server.

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

Dow Jones & Co., Inc.
7/98 - 10/98

  • Re-engineered the Earnings and Dividend Management System. This system receives the incoming news wires, faxes, e-mails and presents them 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

Metlife, Bridgewater, NJ
11/96 - 7/98

Senior Programmer/ Analyst

  • Senior programmer for a 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 system is installed in Windows NT and Sybase 11.0.
  • Environment: UNIX, Powerbuilder 5.0, NT workstation, Sybase 11.0, Shell scripts

AT&T, NJ
9/95 - 11/96

Developer

  • 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 the PNDM system on the UNIX platform with Oracle 7.3 as the database server. This system provides the physical layout of all the devices in a hybrid of Fiber-optic and co-axial cable loops for telephone lines. Managed the integration of the system every day 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++

JOHNSON & JOHNSON Product Complaint System
5/95 - 9/95

  • 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, Data windows, Classes, DLLs, Stored Procedures, and Triggers.

Environment: Powerbuilder 3.0, Windows 3.1, and MS SQLServer 4.2

Software Development / Training Company (Nuware Systems, inc.)
1/95 - 4/95

  • 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.

BUILDING TECHNOLOGY LAB, NJ
12/92 - 12/94

Research Engineer

  • Developed a Model in C that can predict the flow of fluids in open channels.
  • 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 C++ Java Java Servlet JSP Oracle Shell Scripts Stored Procedure Triggers UNIX Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Engineering in Electrical and Electronics
Govt college of Engg, Salem, Affiliated to University of Madras
Certifications
Oracle 9i Database Certified Professional (OCP)
Sun Certified Programmer for Java 2 Platform 1.4
Skills
Oracle
2021
31
UNIX
2021
27
Java
2021
25
Shell Scripts
2015
25
PL/SQL
2021
23
SQL
2021
22
Stored Procedure
2019
22
Windows
2021
22
Database Design
2021
17
Triggers
2011
16
C
2003
13
C++
2003
13
Data Warehousing
2021
13
SDLC
2021
13
Korn Shell
2011
12
ETL
2021
11
Java Servlet
2003
11
JSP
2003
11
Data Marts
2016
10
OPTIM
2021
8
Oracle 11i
2021
8
Performance Tuning
2021
8
TIBCO
2011
8
BEA WebLogic
2011
7
Data Conversion
2021
7
Erwin Data Modler
2015
7
PowerBuilder
2002
7
Ab Initio
2019
6
Data Modeling
2019
6
Database Architect
2021
6
JMS
2021
6
Linux
2021
6
SQL Server
2021
6
DBA
2011
5
System Architecture
2011
5
MS Visio
2008
4
Oracle 12c
2019
4
Oracle 8
2005
4
Project Management
2008
4
Python
2021
4
Release Management
2008
4
Spark
2021
4
System Analysis
2005
4
Windows 8
2019
4
Big Data
2019
3
Data Analysis
2015
3
Data Cleansing
2005
3
Data Integration
2011
3
Data Migration
2019
3
Hadoop
2019
3
Hive
2019
3
J2EE
2011
3
Microsoft Excel
2019
3
OBIEE
2019
3
OLTP
2008
3
SAP
2020
3
SAS
2005
3
WebServices
2008
3
Application Development
2006
2
AutoSys
2002
2
Business Analysis
2008
2
Data Integrity
2006
2
Database Backups
2008
2
JDBC
2006
2
Pages
2005
2
PL/SQL Developer
2021
2
Quality Assurance
2005
2
SQL Developer
2016
2
SQL Loader
2006
2
Sybase
1998
2
Database Maintenance
2005
1
Fiber Optics
1996
1
HDFS
2021
1
Solaris
2006
1
Sun
2006
1
UAT
2008
1
Windows NT
1998
1
Data Governance
0
1
Data Profiling
0
1
Hadoop Architect
0
1
HP
0
1
HTML
0
1
MS Project
0
1
OOP
1995
1
Powerdesigner
2020
1
SAP HANA
2020
1
Windows 3.x
1995
1