Data Architect

RAJESH SRINIVASAGAM

Email:*****.********@*****.***

Phone: 609-***-****

Professional Summary:

Over 18 years of extensive experience as a Data Architect / Data Modeler / Business Analyst for Analysis, Design, Development, Implementation, Administration and Maintenance of Online Transaction, Business Intelligence / Data Warehouse /Data Mart requirement across Banking, Financial Service, Supply Chain and Retail domain.

Data Architect for designing Conceptual, Logical and Physical data model for BLU Lake, Integrated Regulatory Data Mart, CitiDirect (Citibank) Corporate Internet Banking (CIB) Payment System, CitiDirect Data Abstraction Layer (DAL) Framework, CitiDirect and Citibank File Services Data Integration, Citibank Global Transaction Services and Intellect Online - Liquidity Management System customization for Santander Bank and Investec.

Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.

Worked on many Data Migration Projects for Citibank, JP Morgan Chase, Telstra, The Brick Warehouse LP and Data Integration Project for Lloyds and TSB Customer DataMart Integration. Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tools ERwin, Oracle SQL Developer Data Modeler and Sybase Power Designer.

Worked extensively on forward and reverse engineering of Data Models. Created DDL scripts for implementing Data Modeling changes. Created ERwin and Sybase Power Designer reports in HTML for Online reference, RTF format for End User Data Base Design Documentation. Created ERwin Volumetric Report for Capacity Planning. Depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.

Worked in Production Support Project from both Onsite and Offshore.

Worked extensively in Oracle PL/SQL coding, Informatica ETL coding and ETL Process Implementation.

Expertise in SQL, PL/SQL, UNIX shell scripts, ETL Tool Informatica and ETL Process.

Expertise in use of DM Tools ERWin, Oracle SQL Developer Data Modeler and Sybase Power Designer.

Exposed to CMM and CMMI quality process and procedures.

Experience of over 11 years in Banking, Financial Services and Insurance, over 3 years in Air Transportation and 3 years in Retail and Supply Chain Management Domain.

TECHNICAL SKILLS

Application Servers

Microsoft Internet Information Server (IIS),

Oracle Application Server

Databases

Oracle 8i/9i/10g/11g/12C, Microsoft SQL Server 2000 / 2008 R2, IBM DB2 UDB

v 8.2 / v9.7 / DB2 BLU, PostgreSQL and Sybase.

Cloud Technology

Azure Data Cloud, Azure Data Factory, Azure Data Explorer, Azure SQL, Azure Synapse Analytics, Python and Spark

Languages

Oracle PL/SQL, C, C++, Pascal, COBOL and Java.

Applications

Oracle Developer 2000 / 9i / 10g, Visual Basic 6.0, Visual C++ Version 6.0.

ETL Tools

Informatica 10.1.1 (PowerCenter), SSIS

Database Design Tools

Computer Associates ERwin, Oracle SQL Developer Data Modeler 3.1 and Sybase Power Designer 9.5.

Database Migration Tools

IBM Migration Tool Kit (MTK), Oracle Migration Work Bench.

Data Integration Tools

Oracle Golden Gate 10.4., Oracle Data Integrator (ODI) 12c

Business Intelligence Tools

Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau Desktop 2018.2 and Power BI

Software Tool Automation

Microsoft Office 2010 and Star Office.

Version Control Tools

IBM Rational Clear Case, Borland Star Team, SVN, Smart CVS.

OS

MS-DOS, SCO - UNIX, Redhat Linux, Windows, Sun Solaris 8.

Certification

Oracle 10g Certified Professional (OCP).

Education Qualification:

Master of Computer Applications - University of Madras – 2002

Professional Expertise:

Client Name : Microsoft Corporation, Redmond, WA

Duration : 05/03/2021 – Current

Role : Data Architect

Responsibilities:

Data Analysis of downstream applications for Microsoft Power BI cube requirement

Prepare documents based on data analysis and new requirements

Create High Level Data Design Documents based on ETL / ELT / Application requirements and Mapping Document

Design of data model to meet business and BI requirement

Propose Architectural design changes to improve performance

Create Data Flow Diagram, ER diagram, Conceptual, Logical and Physical Data Model using ER Studio

Created Data Vault and Cube Model for Power BI

Work with internal and external customers to analyze data needs, gather and prepare document for data architecture requirements and capacity planning

Skills Used: Azure Data Cloud, Azure Data Bricks, Azure Data Factory, Azure Data Explorer, Azure Synapse Analytics, Azure Data Studio, Microsoft Power BI, SQL Server Management Studio, Microsoft SQL Server 2019, ER Studio, Python, Spark.

Client Name : Daimler Truck North America, Portland OR

Duration : 03/19/2018 – 04/30/2021

Role : Data Architect

Responsibilities:

Performed extensive Data Profiling on IMS data source and gathering requirement for BI and Other Reporting requirement.

Created High Level Documents, SLA, Traceability matrix, Application interface design, ETL Mapping Document, reporting specification for the new source and legacy systems.

Design of 3NF enterprise data model (EDW) to meet business demands and to meet enterprise needs and different source Data acquisition.

Worked with DBA team to ensure implementation of the databases for the physical data models intended for data marts.

Created required Primary Key and Indexes taking into consideration of DB2 Blu column-based architecture.

Propose Architectural design changes to improve data warehouse performance.

Created High level and detail design documents for above data mart projects containing process flows, mapping document, initial and delta load strategies, Surrogate key generation, Type I and Type II-dimension loading, Balance and control, Exception processing, Process Dependencies and scheduling.

Created Process Flow Diagram, Business Standards, ER diagram, Conceptual, Logical, Physical Data Model using ER Studio and Data Vault 2.0 Model using Where Space 3D, Cube Model for Tableau and Power BI Tools.

Design, implement, and manage operation of a Data Lake and related services

Actively work with internal and external customers to analyze business data needs, gather and document business and data architecture requirements

Develop, implement and maintain a metadata solution and associated processes

Ensure highest levels of data accessibility, security, and quality in the environment

Provide advanced technical, systems development and OA services to solve complex business needs including written detailed technical specifications for developers, use cases, and test plans

Interact with management and Sr. management on special projects and Proof of Concept development

Skills Used: MS SQL Server 2005, Snowflake, Oracle 12c, Informatica 10.1.1, ER Studio, Were Space 3D, DB2 mainframe, DB2 BLU, HP Quality Center 10.0/9.0, Azure Data Cloud, Azure Data Factory, Azure Data Explorer, Azure SQL, Tableau, Microsoft Power BI, Azure Synapse Analytics, Python, Spark, CA, Power BI, Workload Automation ESP.

Client Name : Bank of New York Mellon, New York City NY

Duration : 07/29/2016 – 03/09/2018

Role : Business Analyst / Data Architect / Data Engineer

Responsibilities:

Created and Implemented the Integrated Regulatory Data Mart for Credit Risk Reporting Application.

Provided high level Architectural Design for Data Governance to meet regulatory requirement in Financial Reporting.

Created Structure Oriented Architecture (SOA) framework for data flow management.

Created the mapping document, extracting and translation from JDE to Oracle for the engineering data.

Implemented Multi-Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows and Stored Procedure rule engine.

Skills Used: Oracle 11g/12c Database, Oracle Data Integrator (ODI) 12c, Oracle SQL Developer, SQL, PL/SQL Release 12.1.0.2.0, Pentaho, Oracle SQL Loader, Shell Script, Linux, Windows 10, Atlassian JIRA, GitHub, Serena PVCS, CA Workload Automation ESP and Autosys scheduler.

Client Name : American Express, New York City NY

Duration : 01/15/2016 – 07/27/2016

Role: Data Modeler / Process Modeler

Responsibilities:

Lead for Development Team

Data Modeling and Process Modeling

Responsible for Planning and Scheduling of resources / deliverables.

Monitor the project status.

Create Weekly and Monthly Status Reports.

Generate different quality metrics.

Coordination with Offshore

Plan the deliverables for newsprint iteration.

Client Name : JP Morgan Chase, New York City NY, Jersey City NJ, Chicago IL

Duration : 04/08/2013 – 12/31/2015

Role: Data Modeler / ETL Developer using Informatica

Responsibilities:

Designed and implemented a Data Transaction and Analytical Reporting design and process for highly complex banking application.

Designing Conceptual, Logical and Physical Data Models using Erwin Tool for OLTP and Data Warehousing Systems.

Represented Data Architecture team in Infrastructure, Technology and Services Management (ITSM) meetings.

Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.

Worked extensively in SQL, SQL Migration and SQL Tuning across Oracle, MS SQL Server Databases.

Expertise in SQL, PL/SQL, ETL Tool Informatica and ETL Process.

Expertise in UNIX shell script.

Extensive experience in Database Design, Development of Business Application using Database Design Tool, Oracle SQL Tuning, Oracle PL/SQL, T-SQL in MS SQL Server Database and Sybase Database, Oracle Databases, Oracle Developer 2000, MS SQL Server Database and Sybase Database.

Development and Coding of PL/SQL Programming and UNIX Shell Script.

Possess technical expertise in Oracle Golden Gate and Informatica.

Database Backups and Recovery.

Database and SQL Tuning.

Database refresh from Production to staging and Development databases.

Managing Production, QA and Development Databases on support

Skills Used: Oracle 11g, 10g and 9i, SQL Server 2000/2008, IBM DB2 UDB v9.7, Sun Solaris 9/10, Redhat Linux 4/5/6, HP UNIX 11.31, Windows Server 2003 / 2007, Unix Shell Script, Erwin, TOAD, ITIL standards, Oracle Golden Gate 10.4, Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica 9.5.1 (Power Center), SSIS, Autosys scheduler, Citrix, IBM Tivoli Storage Manager, TIBCO Frame Work, Star Team and Calibre RM.

Employer Name : Mphasis Limited,

Offshore Location : Chennai, Tamil Nadu, India

Designation : Lead Consultant

Duration : 04/24/2008 – 04/05/2013

Domain: Banking, Insurance and Financial Services

Client Names: Bank of America, Citibank NA and AIG

Domain: Air Transportation

Client Names: United Airlines, American Airlines and Hewlett Packard Enterprise

Domain: Retail and Supply Chain

Client Names: 7-Eleven and Carrefour S.A. France

Domain: Telecom Billing

Client Names: Telstra Australia

Employer Name : Polaris Software Lab Limited,

Offshore Location : Chennai, Tamil Nadu, India

Designation : Team Lead

Duration : 11/25/2004 – 04/23/2008

Domain: Banking and Financial Services

Client Names: Citibank NA and Banco Santander, S.A. Spain

Role: Data Modeler / ETL Developer using Oracle PL/SQL

Responsibilities:

Gathering detail requirement for Functional and Business specifications. Analyzing the requirement for designing and development.

Designing Conceptual, Logical and Physical Data Models using Sybase Power Designer Tool for OLTP and Data Warehousing Systems.

Strong understanding of the concept and life cycle of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.

Worked extensively in SQL, SQL Migration and SQL Tuning across Oracle, MS SQL Server Databases.

Expertise in SQL, PL/SQL and ETL Process.

Expertise in UNIX shell script.

Extensive experience in Database Design, Development of Business Application using Database Design Tool, Oracle SQL Tuning, Oracle PL/SQL, T-SQL in MS SQL Server Database, Oracle Databases and MS SQL Server Database.

Development and Coding of PL/SQL Programming and UNIX Shell Script.

Database Backups and Recovery.

Database Tuning.

SQL Tuning and Optimization.

Skills Used: Oracle 10g and 9i, SQL Server 2000, Visual Basic 6.0, Visual C++ Version 6.0, IBM DB2 UDB v8.2, Sun Solaris 8, Redhat Linux 4/5/6, HP UNIX 11.31, Windows Server 2003, Unix Shell Script, Sybase Power Designer 9.5, Erwin, TOAD, CMMI Standards Audit.

Employer Name : Kumaran Systems Private Limited,

Offshore Location : Chennai, Tamil Nadu, India

Designation : Senior Programmer

Duration : 03/05/2004 – 11/24/2004

Domain: Retail and Supply Chain

Client Name: The Brick Ltd., Canada

Role: Data Modeler / Oracle Developer

Responsibilities:

Gathering detail requirement for Functional and Business specifications. Analyzing the requirement for design and development of web application.

Designing Conceptual, Logical and Physical Data Models using ErWin Data Model Tool for web application.

Worked in SQL, PL/SQL, SQL Migration and Oracle Forms and Reports.

Worked in UNIX shell script.

Experience in Database Design, Development of Business Application using Database Design Tool, Oracle SQL Tuning, Oracle PL/SQL, Oracle Databases and Oracle Forms and Reports.

SQL Tuning in Oracle Database and Code Optimization.

Skills Used: Oracle 9i, Oracle Developer 9i, Oracle Application Server, Sun Solaris 8, Redhat Linux 4/5, HP UNIX 11.31, Windows Server 2003, Unix Shell Script, Erwin, TOAD, CMM standards.

Contact this candidate