Kandaswamy
Kkanakaraj6@gmail.com
848-248-2906
Monmouth Junction, NJ 08852
Sr. Database Architect
31 years experience W2
1
Recommendation
Average rating
233
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
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
Architecture
2019
4
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
Regulatory Reporting
2006
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
Estimating
2008
2
JDBC
2006
2
Pages
2005
2
PL/SQL Developer
2021
2
Program Management
2008
2
QA
2005
2
Quality Assurance
2005
2
SQL Developer
2016
2
SQL Loader
2006
2
Sybase
1998
2
Accounting
2006
1
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