Vijayarajan_r

ABOUT ME

 Around 16 years of experience as a Software Engineer, Analyst, Module Leader, Project Leader, Data Modeler/Data Architect/Director/AVP, Managing Projects.

 Over 12 Years of experience as Data Modeler for Relational and Dimensional Databases of various size and scope.

 Lead and Managed the Data Warehouse Projects of Team size of 30.

 Managed Overseas Project with end-to-end responsibilities that included Project Life Cycle requirement analysis, designing, planning, implementation, management and communication to all team members, executive management and key client personnel.

 Proven ability to effectively define business requirements and manage multiple projects.

 Involved in Stock holders Management provided Monthly status and ensured the Smooth Delivery.

 Well experienced in Data Modeling both ER Model and Dimensional using Data Modeling tools Erwin, and Power Designer, Microsoft Visio.

 Very good experience in Complex SQL Query writing and procedures and Functions etc.

 Supporting development team with in Oracle - SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.

 Extensive experience in Oracle database, SQL, PL/SQL, TSQL, Packages Stored procedure, Functions, Triggers etc.

 Involved Oracle – Performance tuning techniques.

 Very good experience on databases like Oracle, SQL Server, Teradata MYSQL and DB2.

 Hands on experience in Data Migration Strategies and Techniques from Heterogeneous sources.

 Very good Knowledge on Master Data Management Techniques.

 Exposure to NOSQL databases like MongoDB, Hbase etc…

 Very good knowledge on Data and Predictive Analysis.

 Exposure to ETL tools Informatica, SSIS and OLAP tools SSAS and Cogno’s.

 Hands on experience in reporting tools Business Objects BOXI R3, Crystal Reports, and SSRS.

 Worked for Multinational Clients like Deutsche Bank USA, Penstock Products, Nomura Bank Japan, and SIDBI Mumbai, has domain expertise in Finance, Banking, Insurance, Risk domain. Has experience in both Client Server and web-based technologies.


 MCTS Certified – Microsoft SQL Server 2005

 Certified in TOGAF Architecture Framework

SKILLS