Home

Vinodh Kuppuswamy - ETL Informatica Developer

[email protected]

Location: Chandler, Arizona, USA

Relocation: Open

Visa: H1B

Vinodh Kuppuswamy ETL Informatica Developer +1 623-748-7478 [email protected] Chandler, AZ Open H1B https://www.linkedin.com/in/vinodhkuppuswamy/ Professional Summary: Over 15 years of IT industry experience, including 8+ years in the USA, 2+ years in Singapore, and 4+ years in India. Proficient in Requirement Analysis, Design, Development & Maintenance of Business Applications. Diverse domain expertise in Banking & Financial, Healthcare, Retail, and Automotive sectors. Specialized in Data Warehousing & ETL as a Data Warehouse specialist. Skilled in ETL tools: Informatica Power Center, Informatica Intelligence Cloud Services (IICS), Informatica IDQ, IBM Infosphere DataStage, SSIS, SAP BODS, and databases: Oracle, Teradata, DB2, SQL Server. Experienced in Snowflake Data Warehouse Architecture and migration from On-Premise SQL Server DB. Proficient in Python and Unix Shell scripting for batch automation and file management. Expertise in ETL techniques, Data Analytics, Data Modeling, Partitioning & Performance Tuning. Advanced SQL skills, creating complex queries with joins, sub-queries, and analytical functions. Worked with Teradata utilities, including Fast Export, Fast Load, Multi Load, and BTEQ. Collaborated effectively with Business Analysts, Development, QA, and Production Support teams. Familiarity with Big Data, Hadoop Framework, and related ecosystems (HIVE, Sqoop, Pig, HBase). Skilled in SQL activities, business rules validation, referential integrity validation, and ETL Audit Process. Experience in Data Center Migration and ETL conversion projects. Proficient in Oracle: SQL, PL/SQL, SQL Loader, stored procedures, triggers, indexes, and table partitions. Strong grasp of data modeling methodologies like Star and Snowflake Schemas. Agile/Scrum methodology experience. In-depth knowledge of Snowflake Architecture. Proficient in scheduling via TIDAL and Autosys for job management. Experienced project leader with root cause analysis skills and quick issue resolution. Excellent problem-solving, communication, and interpersonal skills. A dedicated professional with a tactical approach, adaptable to new technologies and concepts. Key Domain & Technical Knowledge: Domain: Banking & Financial, Healthcare, Retail and Automotive. Technical Skills: ETL Tools Informatica, Datastage, Microsoft SSIS, Oracle Data Integrator. RDBMS Oracle 9i/10g/11g, Teradata, DB2, MS SQL Server. Programming Languages SQL, UNIX Shell Scripting, PL/SQL, Python. Scheduling Tools TIDAL, Tivoli, Autosys, Control M Reports OBIEE, Crystal Reports, BO Reports, Tableau. Big Data EcoSystems Hadoop Framework, HDFS , Hive, Soop, HBase. Operating Systems UNIX, LINUX, MS Windows Servers & Clients. Tools / Apps Sharepoint, Visio, SVN, Fast Export, JIRA, Oracle Apps. Academic Qualification: Masters Engineering (M.E) in Computer Science from Sathyabama Deemed University, Chennai, India. Bachelor's Engineering (B.E) in Computer Science from Madras University, Chennai, India. Professional Awards: Received several Pat on Back awards for his excellent work as Lead/ Developer at Client locations in USA and Singapore. Got excellent Kudos and Appreciations from Customers for solutions and commitment on several occasions. Professional Experience: Bank of the West, Tempe, AZ Oct 2020 Till Date Sr. ETL Developer Project Name: Enterprise Data warehousing (EDW) Roles & Responsibilities: Collaborated closely with Business Users, SMEs, and Leads to gather and meticulously document intricate business requirements for the Bank of The West - Enterprise Data Warehouse (EDW) Team. Demonstrated comprehensive involvement across all ETL phases, including Extraction, Transformation, and Load, using Informatica. This encompassed in-depth requirements analysis, sophisticated design, intricate coding, exhaustive unit testing, and comprehensive technical documentation. Produced meticulously detailed Requirement Documents, Mapping Design Documents, and Gap Analysis Sheets to provide invaluable support to various line-of-business units, including Commercial Banking Group (CBG), National Finance Group (NFG), Master Data Management (MDM), Mortgages, Consumer Loans (ALS), and Deposits. Showcased advanced Informatica expertise by coding complex mappings using a wide array of transformations in Informatica Power Center Designer 10.5.2. Moreover, expertly managed reusable sessions, executed workflows with precision through Workflow Manager 10.5.2, Workflow Monitor 10.5.2, and deployed seamlessly using Repository Manager 10.5.2. Highlighted competence with Informatica Power Center transformations, including both connected and unconnected Lookups, Filters, Router, Joiner, Stored procedure Transformations, Sequence Generators, and Mapplets, emphasizing proficiency in optimizing data transformations. Exhibited adeptness in working with diverse databases such as Oracle 19c, SQL Server, Teradata, and various source system files (Mainframes VSam, XML, CSV, flat files). Expertly crafted intricate SQL Queries against databases to implement and fine-tune sophisticated business logic. Developed highly efficient UNIX shell and Python scripts for automating complex business processes, enabling seamless report generation, and managing file transfers proficiently using SFTP/FTP. Provided strategic guidance through industry best practices and invaluable recommendations to Business and IT stakeholders, facilitating informed decisions on system upgrades and legacy system management. Collaborated effectively with Finance, Compliance, and Risk Teams to provide indispensable support for General Ledger (GL) Analysis, Treasury operations, and intricate GL Reconciliations. Additionally, contributed expertise to audits, compliance activities, and the preparation of various regulatory reports. Led Root Cause Analysis (RCA) efforts to diagnose and resolve complex production issues, ensuring meticulous documentation of resolutions for future reference. Contributed to the establishment and maintenance of system architecture standards by creating clear and concise use cases, traceability matrices, and process flow diagrams. Demonstrated an unwavering commitment to ensuring compliance with banking processes and procedures, aligning all activities with the Bank's System Architecture standards. Leveraged extensive experience to lead development teams effectively within a Scrum/Agile methodology framework, contributing to the delivery of innovative solutions. Environment: Informatica power center 10.5.2, IICS, Python, SQL, PL/SQL, Unix Batch scripting, Oracle 19c,11g, 10g,SQLserver, Teradata, Hive, OBIEE, Tidal, JIRA, Hadoop Framework, HDFS, Mainframe VSAM, Microsoft Dynamics CRM, Red Hat LINUX 8.7, Windows 10 Bank Of the West, Tempe, AZ Feb 2019 Oct 2020 Sr. ETL Developer Project Name: BIDM DevOps - Customer Consent Consolidated Sales Data Repository / CRM CBG Data into EDW Roles & Responsibilities: Actively participated in all ETL phases (Extraction, Transformation, and Load) using Informatica 10.2, encompassing requirements analysis, design, coding, and unit testing for the BIDM DevOps Project. Collaborated closely with BI analysts, BI architects, and Data architects to comprehend business reporting and analytic requirements, and generated technical documentation, including data mapping and system specifications. Designed and implemented data solutions, incorporating data partitioning, data normalization, denormalization, data aggregations, BI solutions, and data lakes to bolster the data warehouse environment. Developed ETL Mappings within Informatica PowerCenter designer, leveraging a diverse range of transformations, including Connected and Unconnected Lookups, Filters, Routers, Joiners, Stored Procedure Transformations, Sequence Generators, and Mapplets. Additionally, created reusable sessions for enhanced efficiency. Undertook intricate data processing tasks such as the creation of staging, Operational Data Stores (ODS), dimension, and fact loads. Focused on performance tuning within the existing codebase to optimize load timing. Operated with various databases, including Oracle 12c, SQL Server, and a variety of source file formats such as VSam, XML, CSV, and flat files for source data import and loading into target systems. Developed complex SQL scripts tailored to retrieve data from databases in alignment with specific business logic. Led the design and review of critical interfaces, ensuring alignment with stakeholders' requirements and expectations. Conducted thorough code change validation and oversaw the deployment of components in both Non-Production and Production environments. Environment: Informatica power center 10.2, SQL, PL/SQL, Python, Unix Batch scripting, Oracle 11g, 10g, SQL server, Teradata, Hive, Mainframe VSAM, CRM Dynamics, BO, Tidal, JIRA, Red Hat LINUX 8.7, Windows 8 U.S. Bank Corp, San Francisco, CA Mar 2018 Jan 2019 ETL Specialist Project Name: Siebel CRM Replacement with Microsoft s Dynamics CRM system Roles & Responsibilities: Actively engaged in gathering requirements from Business Analysts and users. Led the analysis, design, and development efforts to replace the Siebel system with Microsoft Dynamics CRM for consumer banking projects. Prepared the ETL Design document and updated source-to-target details based on the Detailed Design Document. Designed and executed Informatica ETL mappings to extract data from Siebel and load it into the MSD CRM system as part of the migration process. Designed and implemented Informatica ETL mappings to extract data from various source systems and load it into CRM for ongoing data loads, covering Leads, Prospects, Customers, Financial Accounts, Alerts, Cases, Products, and Book of Business. Constructed a data model in SQL DB to facilitate one-time data synchronization between Siebel and Microsoft Dynamics CRM, covering areas such as Book of Business, Prospects, Campaigns, Leads, Referrals, Offer management, and Performance management. Developed complex queries and procedures in alignment with business requirements. Created ETL Mappings for the data synchronization process from Siebel to Microsoft Dynamics CRM, covering Leads, Prospects, Customers, Financial Accounts, Alerts, Cases, Products, and Book of Business. Played a pivotal role in creating test cases and test script documents, collaborating with Business for User Acceptance Testing (UAT). Focused on troubleshooting and fine-tuning ETL mappings, SQL queries, and promptly resolving any issues that arose during the process. Bank of the West, San Ramon, CA Mar 2016 Jan 2018 Sr. ETL Developer Project Name: Comprehensive Capital Adequacy and Review (CCAR) & IFRS 9 Implementation Roles & Responsibilities: Spearheaded the design, construction, and deployment of ETL pipelines for the implementation of CCAR & IFRS9. Developed ETL pipelines for diverse source systems, ensuring the timely delivery of CCAR reports to the Federal Reserve (FED) on a monthly and quarterly basis. Crafted intricate queries and procedures tailored to meet specific business requirements. Created and modified ETL objects, including the development of UNIX shell scripts. Designed ETL mappings based on intricate business logics, employing various transformations such as Source Qualifier, Lookup, Union, Router, Aggregator, Expression, Filter, Update Strategy, and Joiner. Collaborated in the creation of test cases and test script documents, closely coordinating with Business for User Acceptance Testing (UAT). Analyzed KDE documents and data mapping documents for CCAR. Specialized in troubleshooting and performance optimization of ETL mappings and SQL queries, promptly resolving any encountered issues. Developed Informatica ETL solutions for multiple source systems as per project requirements, facilitating the seamless loading of data from source to target and the generation of JSON output files sent to BNP Paribas Paris for their FED submission. Environment: Informatica power center 9.6.1, Oracle 12c/11g, Teradata, SQL DB, Microsoft Dynamics, Python, SQL, PL/SQL, Unix Shell Scripts, OBIEE, Tidal, JIRA, UNIX, Windows XP Mattel - American Girl, Madison, Middleton, WI Aug 2015 Mar 2016 Sr. ETL Consultant Project Name: POS Conversion Roles & Responsibilities: Actively worked in Analysis of Oracle Apps build on PL/SQL to understand the process flow for POS interface conversion to ETL. Designed, Developed, and integrated ETL Jobs in Enterprise Data Warehouse (EDW) and implemented in Production. Performed business and data analysis based on the functional specifications provided by the business users and managers. Implemented and maintained multiple ETL processes to synchronize data between different source systems and databases. Documented, tested, implemented, and provided ongoing support for Oracle and ETL applications. Interfaced with users, project managers to ensure that implemented solutions satisfied business requirements and were delivered in a timely manner. Environment: Informatica power center 9.5, SAP BODS, Oracle 11g, SQL, PL/SQL, Unix Shell Scripts, Oracle ERP, HP-LINUX, Windows XP Cognizant/Cigna, Bloomfield, CT (Offshore) Oct 2013 Jun 2015 Sr. ETL Consultant Roles & Responsibilities: Worked in Analysis, Design and Development of ETL Mappings for raw data loading and for building star schema using Informatica Power Center 9.5, Oracle 11g, Teradata and V2R14. Created different interfaces to load the data to Health e-view Data Mart, Clinical Service Mart from different sources (flat files, Oracle, SQL Server). Developed the Informatica Mappings by using an Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple target tables. Troubleshoots batches and sessions for daily, weekly and Monthly extracts from various data sources across all platforms to the target database. Responsible for the data validation testing in UAT, Production environment also extensively worked on Pre & Post production activities. Worked on creating PL/SQL Packages, Procedures for loading the data into Health-E View data mart which gives reports to the Customer reporting systems. Worked with multiple teams like Data Architect, DBA, QA Team and Business for UAT testing and finally with the Prod Ops team for the production code deployment. Environment: Informatica power center 9.5, IBM Infosphere, DataStage, Oracle 10g, Teradata R14, SQL Server 2008, SQL, PL/SQL, Unix Shell Scripts, Control-M, BO, HP-LINUX, Windows XP Polaris Financial Technology Ltd./ Citibank, Singapore (Onsite) Oct 2010 Jan 2013 Sr. ETL Developer Project Name: EMEA DWH Roles & Responsibilities: Worked in analysis, design and development of ETL Mappings for loading the customer base used for Credits, Cards & Retail banking for LATAM & EMEA countries using Informatica Power Center 8.6, Oracle 10g. Worked on Informatica Power Center 8.6 client tools - Mapping designer, Workflow, Monitor. Prepared technical specifications to develop ETL mappings to load data into various tables as per the business rules. Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner conforming to the business rules and documented. Deployed the mappings and scripts between various environments like the Development, QA and production. Environment: Informatica power center 8.6,Datastage 7.5.2/8.2, Oracle 10g, Teradata R14, SQL, PL/SQL, Unix Shell Scripts, Tivoli, HP-LINUX,UNIX, Windows XP Standard Chartered Bank, Chennai, India Sep 2009 Sep 2010 Sr. ETL Developer Project Name: Data Integration Hub (DIH) DWH Roles & Responsibilities: Worked in design and development of ETL Mappings for building the DIH (Data Integration Hub) using Informatica Power Center 8.5, Oracle 10g. Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner conforming to the business rules and documented. Created database partitions and Materialized Views and improved the performance. Developed on creating the mappings for extracting the Global consumer banking data from different source systems. Environment: Informatica power center 8.5, Datastage 7.5.1, Oracle 10g, DB2 9.5.1, SQL, PL/SQL, Unix Shell Scripts, Vertis, ILOG, UNIX, Windows XP Wise Men, Houston, TX Jun 2008 Dec 2008 ETL Consultant Roles & Responsibilities: Responsible for the daily ETL batch process to pull the data from different source systems and load into the staging tables. Developed complex ETL mapping based on the requirements. Created PL/SQL objects for generating weekly, monthly reports. Environment: Informatica 8.x, Oracle 10g, SQL, PL/SQL, Unix Shell Scripts, UNIX, Windows XP Thirdware Solution Limited, India/ FORD NA, USA (Offshore) Apr 2006 Apr 2008 Sr. ETL Developer Project Name: Financial @the Speed of Thought (F@ST) Roles & Responsibilities: Designed & developed ETL Mappings for various F@ST CPM & CVF subject areas using ETL tool. Worked in enhancement of the existing TPDB, ODS and TERADATA DWH systems. Worked in performance tuning for various ETL Mappings and PL/SQL scripts using TKPROF, EXPLAIN PLAN utilities. Utilized Teradata utilities FastLoad, Multi Load for loading the data into CPM DWH system. Performed unit, Integration, QA, UAT Testing. Also responsible for mapping, functional specification, Testing and Desk procedure tracker documentation. Environment: Informatica 8.x, Datastage 7.x, Teradata SQL Assistant, Toad, Oracle Data Integrator, Control-M, Oracle 9i, Teradata V2R5.1 / 6.1, SQL, PL/SQL, Unix Scripting, Windows XP, Unix Keywords: quality analyst business intelligence database information technology hewlett packard microsoft procedural language Arizona California Connecticut Texas Wisconsin