Supply Chain Data Architect
Resume:
RAJESH SRINIVASAGAM
Email:ad5dx9@r.postjobfree.com
ad5dx9@r.postjobfree.com
Phone: 201-***-****, 551-***-****
LinkedIn: https://www.linkedin.com/in/rajeshsrinivasagam/
Skype ID: rajesh.srinivasagam
SUMMARY
●Over 19 years of extensive experience as a Data Architect / Data Modeler 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 GlobalTransaction 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 PowerDesigner. Data vault modeling using WhereScape 3D for Azure Data Cloud, NoSQL Data Assets like MongoDB, Canonical Data Model using MagicDraw UML
●Worked extensively on forward and reverse engineering of Data Models. Created DDL scripts for implementing Data Modeling changes. Created ERwin and Sybase PowerDesigner 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, SSIS, Azure Data Factory and ETL Process.
●Expertise in use of DM Tools ERWin, Oracle SQL Developer Data Modeler and Sybase PowerDesigner.
●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, MongoDB, 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, MagicDraw, Lucidchart, Draw.io, Microsoft Visio, Oracle SQL Developer Data Modeler 3.1 and Sybase PowerDesigner 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, SSRS and Power BI
Software Tool Automation
Microsoft Office 365, 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
Employer Details:
Employer Name : Global Point Inc.
Designation : Senior Consultant
Duration : 12/29/2023 - Current
Client Name : KPI Partners, Seattle WA
Duration : 01/02/2024 – Current
Responsibilities:
●Analyzing and Translating Business needs into long-term solution Data Models
●Evaluating existing Data Systems
●Working with the development team to create conceptual, logical, physical data models and data flows
●Developing best practices for data coding to ensure consistency within the system
●Reviewing modifications of existing systems for cross-compatibility
●Implementing data strategies and developing physical data models
●Updating and optimizing local and metadata models
●Evaluating implemented data systems for variances, discrepancies, and efficiency
●Troubleshooting and optimizing Data Systems
Skills Used: Erwin, Microsoft Office 365, Visio, Microsoft SQL Server Databases
Employer Name : LTIMindtree Limited
Designation : Associate Principal
Duration : 11/30/2022 – 10/04/2023
Client Name : Citigroup Technology, Inc, Irving TX
Duration : 11/30/2022 – 10/04/2023
Responsibilities:
●Develop Conceptual, Logical and Physical Data Model by leveraging existing models, and following enterprise modeling guidelines.
●Conduct working sessions with Project Team and Business Analyst to define / review Data Models.
●Review alignment between Data Models, Subject Area and support testing of Physical Data Models, and baseline Data Definition Language (DDL) generation.
●Provide knowledge on Personal Banking Wealth Management related subject areas and, understanding of Data Modeling Industry Standards, Data Modeling Leading Practices, and Data Modeling tools.
●Support the development of Data Modeling Change Management process, and Data Governance tools.
Skills Used: Magic Draw, Erwin, Microsoft Office 365, Visio.
Employer Name : Global Point Inc.
Designation : Senior Consultant
Duration : 03/19/2018 – 11/29/2022
Client Name : Daimler Truck North America, Portland OR
Duration : 03/19/2018 – 11/29/2022
Responsibilities:
●Performed extensive Data Profiling on IMS, SQL Server and Oracle Data Sources.
●Worked on initial Data Load and Data Engineering setup related activities to Extract, Transfer and Load Data from IMS, SQL Server and Oracle data sources using INFORMATICA, Oracle PL/SQL Stored Procedures, DB2 BLU SQL/PL Stored Procedures, SSIS, Azure Data Bricks, Azure Synapses and Azure Data Factory.
●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 and Physical Data Model for various data sources from IMS, DB2 BLU, MongoDB and various data file formats.
●Design, implement, and manage operation of a Data Lake and related services.
●Designed and implemented Data Vault Model for Telematics Data streamed from loT device embedded Trucks into Azure Data Cloud using WhereScape 3D.
●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, SSIS, SSRS, Oracle 12c, Informatica 10.1.1, WhereSpace 3D, Erwin, Hackolade, Lucidchart, DB2 mainframe, DB2 BLU, MongoDB, HP Quality Center 10.0/9.0,Azure Data Cloud, Azure Data Factory, Azure Data Explorer, Azure SQL, Azure Synapse Analytics, Azure Data Bricks, Snowflake, Python, Spark, CA, Power BI, Workload Automation ESP.
Employer Name : Cognizant Technology Solutions U.S. Corporation
Designation : Project Manager
Duration : 07/29/2016 – 03/09/2018
Client Name : Bank of New York Mellon, New York City NY
Duration : 07/29/2016 – 03/09/2018
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.
Employer Name : MphasiS Corporation U.S.
Designation : Lead Consultant
Duration : 04/08/2013 – 07/27/2016
Client Name : American Express, New York City NY
Duration : 01/15/2016 – 07/27/2016
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
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, SSRS, 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: Oil and Gas
Client Names: Marathon Oil
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
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 PowerDesigner 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 PowerDesigner 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
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