| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email:EMAIL AVAILABLEEMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLE, PHONE NUMBER AVAILABLELinkedIn: https://LINKEDIN LINK AVAILABLESkype ID: Candidate's Name
SUMMARYOver 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 UMLWorked 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 SKILLSApplication ServersMicrosoft Internet Information Server (IIS),Oracle Application ServerDatabasesOracle 8i/9i/10g/11g/12C, Microsoft SQL Server 2000 / 2008 R2, IBM DB2 UDBv 8.2 / v9.7 / DB2 BLU, MongoDB, PostgreSQL and Sybase.Cloud TechnologyAzure Data Cloud, Azure Data Factory, Azure Data Explorer, Azure SQL, Azure Synapse Analytics, Python and SparkLanguagesOracle PL/SQL, C, C++, Pascal, COBOL and Java.ApplicationsOracle Developer 2000 / 9i / 10g, Visual Basic 6.0, Visual C++ Version 6.0.ETL ToolsInformatica 10.1.1 (PowerCenter), SSISDatabase Design ToolsComputer Associates ERwin, MagicDraw, Lucidchart, Draw.io, Microsoft Visio, Oracle SQL Developer Data Modeler 3.1 and Sybase PowerDesigner 9.5.Database Migration ToolsIBM Migration Tool Kit (MTK), Oracle Migration Work Bench.Data Integration ToolsOracle Golden Gate 10.4., Oracle Data Integrator (ODI) 12cBusiness Intelligence ToolsOracle Business Intelligence Enterprise Edition (OBIEE), Tableau Desktop 2018.2, SSRS and Power BISoftware Tool AutomationMicrosoft Office 365, Microsoft Office 2010 and Star Office.Version Control ToolsIBM Rational Clear Case, Borland Star Team, SVN, Smart CVS.OSMS-DOS, SCO - UNIX, Redhat Linux, Windows, Sun Solaris 8.CertificationOracle 10g Certified Professional (OCP).Education Qualification:Master of Computer Applications - University of Madras - 2002Employer Details:Employer Name : Global Point Inc.Designation : Senior ConsultantDuration : 12/29/2023 - CurrentClient Name : KPI Partners, Seattle WADuration : 01/02/2024 CurrentResponsibilities:Analyzing and Translating Business needs into long-term solution Data ModelsEvaluating existing Data SystemsWorking with the development team to create conceptual, logical, physical data models and data flowsDeveloping best practices for data coding to ensure consistency within the systemReviewing modifications of existing systems for cross-compatibilityImplementing data strategies and developing physical data modelsUpdating and optimizing local and metadata modelsEvaluating implemented data systems for variances, discrepancies, and efficiencyTroubleshooting and optimizing Data SystemsSkills Used: Erwin, Microsoft Office 365, Visio, Microsoft SQL Server DatabasesEmployer Name : LTIMindtree LimitedDesignation : Associate PrincipalDuration : 11/30/2022 10/04/2023Client Name : Citigroup Technology, Inc, Irving TXDuration : 11/30/2022 10/04/2023Responsibilities: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 ConsultantDuration : 03/19/2018 11/29/2022Client Name : Daimler Truck North America, Portland ORDuration : 03/19/2018 11/29/2022Responsibilities: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 requirementsDevelop, implement and maintain a metadata solution and associated processesEnsure highest levels of data accessibility, security, and quality in the environmentProvide advanced technical, systems development and OA services to solve complex business needs including written detailed technical specifications for developers, use cases, and test plansInteract with management and Sr. management on special projects and Proof of Concept developmentSkills 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. CorporationDesignation : Project ManagerDuration : 07/29/2016 03/09/2018Client Name : Bank of New York Mellon, New York City NYDuration : 07/29/2016 03/09/2018Responsibilities: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 ConsultantDuration : 04/08/2013 07/27/2016Client Name : American Express, New York City NYDuration : 01/15/2016 07/27/2016Responsibilities:Lead for Development TeamData Modeling and Process ModelingResponsible for Planning and Scheduling of resources / deliverables.Monitor the project status.Create Weekly and Monthly Status Reports.Generate different quality metrics.Coordination with OffshorePlan the deliverables for newsprint iteration.Client Name : JP Morgan Chase, New York City NY, Jersey City NJ, Chicago ILDuration : 04/08/2013 12/31/2015Responsibilities: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 supportSkills 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 LimitedOffshore Location : Chennai, Tamil Nadu, IndiaDesignation : Lead ConsultantDuration : 04/24/2008 04/05/2013Domain: Banking, Insurance and Financial ServicesClient Names: Bank of America, CitiBank NA and AIGDomain: Air TransportationClient Names: United Airlines, American Airlines and Hewlett Packard EnterpriseDomain: Oil and GasClient Names: Marathon OilDomain: Retail and Supply ChainClient Names: 7-Eleven and Carrefour S.A. FranceDomain: Telecom BillingClient Names: Telstra AustraliaEmployer Name : Polaris Software Lab Limited,Offshore Location : Chennai, Tamil Nadu, IndiaDesignation : Team LeadDuration : 11/25/2004 04/23/2008Domain: Banking and Financial ServicesClient Names: CitiBank NA and Banco Santander, S.A. SpainResponsibilities: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, IndiaDesignation : Senior ProgrammerDuration : 03/05/2004 11/24/2004Domain: Retail and Supply ChainClient Name: The Brick Ltd., CanadaResponsibilities: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. |
