Swaminathan Subramanian
Seattle,WA
Summary
Over 16 years of IT experience working on ETL Architecture design, System Analysis, Application Design, Development, Testing, Implementation, Maintenance and Supporting for an Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store (ODS), Data Warehouse (DW)/Data Mart (DM), using Informatica ETL tool. Designed canonical and integrative data views, strategic roadmaps, and the best practice standards and performance metrics for data architecture as well as migrated data from legacy systems to new solutions or processes and identified opportunities for data reuse and migration Adept at managing projects with teams of 14 members, managing multiple projects, ensuring delivery across geographical locations and managing projects from inception to closure.
Overview
15
15
years of professional experience
3
3
Certification
Work History
Manager
Bright Horizons Family Solutions Inc
09.2019 - Current
- Worked collaboratively with other architects in building enterprise data architecture to provide scalable, reliable, secure and high-quality data solutions as well as recommended and implemented appropriate data platforms and structures across the various application domains
- Support the Data Quality Program, including the creation and execution of DQ queries using Informatica IDQ and JIRA, management of DQ exceptions, and support of a DQ Scorecard
- Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Source to Target Mapping, Functional/Technical Specifications, SAD, ETL Design Documents, Development, Testing and Support Activities
- Created Salesforce connection, Implemented Salesforce business process with Informatica data Integration
- Assist the EVP/Chief Information Office with various department related activities
- Created Oracle Functions/Stored Procedures to implement complex business logic for good performance and extensively used Informatica Stored Procedure transformation
- Gathered and analyzed business requirements and designed database architecture for reporting or analytics as required as well as prepared accurate and complete documentation for data design and data-flow work
- Designed canonical and integrative data views, strategic roadmaps, and the best practice standards and performance metrics for data architecture as well as migrated data from legacy systems to new solutions or processes and identified opportunities for data reuse and migration
Manager
Grand Circle Corporation Inc
02.2018 - 06.2019
- Designing ETL Architecture framework for new project using Informatica ETL Tool, Oracle, UNIX and ERWIN, Active Batch Scheduler
- Worked collaboratively with other architects in building enterprise data architecture to provide scalable, reliable, secure and high-quality data solutions as well as recommended and implemented appropriate data platforms and structures across the various application domains
- SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by partitions, creating Explain Plan, SQL hints for query and indexing
- Extracted the raw data from Salesforce/MC to staging tables using Informatica Cloud
- Involved in designing and developing Database schemas like Star schema, Snow flake schema, Dimensional Modeling using ERWIN/VISIO
- Extensively Implemented Error Handling Concepts, Testing, Code Debugging and Performance Monitoring and Tuning
- Expertise in RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows
- Closely worked with other IT team member’s business partner’s data steward’s stakeholders steering committee members and executive sponsors for all the Data Quality and Data Governance related activities
- Created Oracle Functions/Stored Procedures to implement complex business logic for good performance and extensively used Informatica Stored Procedure transformation
- Automated the entire processes using UNIX shell scripts.
Solution Architect
Fresenius Medical Care Inc
04.2015 - 02.2018
- Involved in Designing ETL Architecture framework using Informatica ETL Tool, Oracle, Exadata, UNIX and ERWIN/VISIO, Autosys/Informatica Scheduler
- Conceptual, Logical & Physical Data Model designing for large scale projects
- Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Source to Target Mapping, Functional/Technical Specifications, SAD, ETL Design Documents, Development, Testing and Support Activities
- Experience with the healthcare data ICD 9 & 10
- Experienced with CMS XML data submission process and feedback load process to DW
- Analyzed, inspected and laid the framework for Claims Process Engine
- SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by partitions, creating Explain Plan, SQL hints for query and indexing
- Involved in designing and developing Database schemas like Star schema, Snow flake schema, Dimensional Modeling using ERWIN/VISIO
- Expertise in RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows
- Closely worked with other IT team member’s business partner’s data steward’s stakeholders steering committee members and executive sponsors for all the Data Quality and Data Governance related activities
- Created Oracle Functions/Stored Procedures to implement complex business logic for good performance and extensively used Informatica Stored Procedure transformation.
Data Warehouse Architect
Sunovion Pharmaceuticals
02.2015 - 04.2015
- Staged Data from legacy Proclaim IMS system into Master Tables
- Involved in designing and development of ETL code for the Aggregate Spend project using Informatica, Oracle, UNIX and ERWIN/VISIO
- Developed the audit activity for all the cloud mappings
- Used T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
- Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, Functional/Technical Specifications, ETL Design Documents, ETL Development
- Created IICS data assessment, data synchronization and data replication tasks using IOD application
- Performed Inserts/Updates and Deletes into a Veeva application (SFDC objects, Accounts/Address etc.) using both Informatica power center and Informatica cloud application
- Extracted the Salesforce data using Informatica Cloud and loaded it into Oracle DB
Team Manager
Credit Suisse
05.2011 - 01.2015
- Creation and maintenance of ETL & Data Architecture for the Credit Risk Insight system and provided technical leadership to team by designing the ETL solution
- The Key factors that need to be assessed are Default probability, Credit exposure and Recovery rate
- The exposure calculation and aggregation (including potential exposure calculation, netting and collateral/CDV offset) are done on daily basis
- Performing Client Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL architecture documents (HLD & LLD), ETL Designs & Development, Testing and Support Activities
- Created IICS data assessment, data synchronization and data replication tasks using IOD application
- Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy
- Designing High level & Low Level design documents according to project requirements
Sr. Software Engineer
OCBC Bank
12.2010 - 04.2011
- OCBC is Singapore's longest established local bank, with a rich heritage that can be traced as far back as 1912
- Fire Upgrade project is the regulatory engine for Loans & limits
- Responsibilities:
- Client Liaison, Analysis, Designing, Development and Support new project requirements
- Involved in conducting complete business requirement gathering and converting URS to Functional & Technical documents
- Engaging in client meeting and identify the Business/Technical gaps in the system or process and providing future focused solutions
- Expertise in Teradata FSLDM Concepts and Involved in Logical Data Model and Physical Data Model design and architecture
- Experienced in defining Roadmap, providing Solutions, Data Architecting, Modeling, Designing and Developing Database, Data warehouse/Data Mart and Business Intelligence Applications
- Designed and Developed Oracle PL/SQL Stored Procedure for efficient customized data loading, retrieval and implement complex business logic for good performance
- Created Materialized views for summary tables for better query performance
- Involved in writing UNIX shell scripts to automate the business process and also provided End-user training and support.
Business Intelligence, ETL Consultant/Lead
Bayer Inc
10.2009 - 12.2010
- ABBI (A Better, Bayer is a global enterprise with core competencies in the fields of health care, nutrition and high-tech materials
- This system is fed by different sources like IMS, WKH, Veeva, Oracle HR, Salesforce etc
- Responsibilities:
- Experienced in defining Roadmap, providing Solutions, Architecting, Modeling, Designing and Developing Database, Data warehouse and Business Intelligence Applications
- Management to forecast their markets accurately identifies the factors that most impact involved in all phases of SDLC from requirement, design, development and testing
- Each segment's profitability
- Warehouse is supposed to assist in defining strategy for extensively involved in requirement analysis and created ETL mapping design document
- Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin
- Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc
- And used transformation language likes transformation expression, constants, system variables, data format strings
- Design Data Architecture and Dimensional Data Modeling for new projects
- Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.
Informatica Consultant/Lead
Woolworths Sydney, NSW
01.2009 - 06.2009
- Project: EDW (Enterprise Data Warehouse, Woolworths Limited is a leading player in the retailing industry in Australia with their head office in Sydney
- EDW Provides reports like high stock value list, item below re-order level, stores ledger and sub ledger, items above maximum level, cost of center wise/work order wise material consumption, list of non-moving and moving items
- Responsibilities:
- Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications
- Production Support, ETL Executions using web methods scheduler, Performing Root Cause Analysis on Critical batch jobs failure, Defect Tracking and bug reporting, UAT Data & production Implementation support
- Designed the mappings and sessions to extract Real-Time data from different systems
- Created Simulation mappings, sessions and workflows for processing error records while loading into Informatica
- Written UNIX shell scripts to process the Real time extracted staging files
- Write complex SQL Queries/Stored Procedures for Functional, Regression, Integration testing, User Acceptance Testing.
Informatica Developer
General Electricals, GE, MAX
12.2006 - 12.2008
- GE Commercial Finance, headquartered in Norwalk, Conn., GE Commercial Finance is part of GE Capital - General Electric's financing unit
- GE CFS MAX is the Marketing Solutions ARM for GE US & Europe based Customers
- This MAX system is designed for the Marketing system of the organization
- It reports the historical data stored in various databases like Oracle, Mainframe, XML files and Flat Files etc
- Responsibilities:
- Developed ETL mappings, transformations using Informatica power center
- Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression
- Used various stored procedures in the mappings
- Preparation of Test Plans, Test Cases/Scripts, SIT/UAT Testing, Reporting, Client Presentation and Post Production Support Activities
- Development Reports using Business Objects reporting solutions
- Worked on the server manager to run several sessions and batches concurrently and sequentially.
Education
Master of Science - Computer Applications
Madurai Kamaraj University
India09.2021
Bachelor of Science - Computer Applications
Madras University
India08.2006
Skills
- ETL Tools: IDMC/IICS, Informatica MDM On-prem & Cloud, Informatica PC 10x, IDQ 10x, Power Exchange
- Data Governance: Informatica AXON, CDQ
- Business Intelligence: Business Objects, Tableau and PowerBI, Qlik Sense
- Cloud Technologies: Azure Blob, Azure VM, Active Directory, Synapse, App services, Salesforce, CDP
- RDBMS: Sql Server, Oracle, Teradata, Netezza, Exadata, Sybase
- Data Modelling: Lucid, Erwin, Microsoft Visio
- Big Data: Hadoop, HDFC, Hive, Python
- Tools: Toad, DMAmp, PL/SQL Developer, SQL Assistant, Rapid SQL 8x, Putty, WinSCP, Autosys, Remedy, Quality Centre, Control-M, JIRA, Azure ADO
- Languages SQL, PL/SQL, Perl, Python, UNIX Shell Scripting, PL/SQL
- Operating Systems Windows, UNIX/LINUX, Sun OS
Accomplishments
- Experience in Data Modeling techniques like Dimensional Data modeling, Star/Snowflake/Hybrid Schema modeling and Conceptual/Logical/Physical data modeling using Erwin/Visio tools
- Build data quality assessments and measurement of critical data utilized strategic systems and processes
- Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems
- Experience in developing Transformations, Mapplets and Mappings using Informatica Designer to implement business logic
- Experience in integration of various data sources like Oracle, Teradata, Exadata, Netezza, Sybase, flat files, JSON, XML, Share Networks, Web services, CDC (Change Data Capture) and Informatica Data Replication (IDR)
- Experience in IDQ of developing plans for Analysis, standardization, Matching and merge, Address doctor, consolidating data from different components
- Extensive Experience in requirement engineering for large, complex programs
- Have been involved in business requirements for diverse areas of the applications
- Have worked with business stakeholders and SMEs in defining the scope of large programs, process flows, interface specifications, ETL Mappings, Report design and data model design
- Clear understanding of data modeling practices, data quality concepts, project management process, data profiling, data visualization, data governance, data security and backups, data replication/ETL, data integration and data warehousing, metadata, data mining and segmentation techniques
- Expert knowledge of development of SOAP and REST API’s
- Hands-on expertise with Azure Cloud, IDMC, IDQ, MDM and Salesforce
- Expertise in MDM strategy proposal, road map and planning with phased implementation leveraging best practices and strong focus in data quality for measurable return on investment
- Performed project Initiation and Project Planning, Managed project budgets, schedule, dependencies and risks
- Have managed stakeholders' meetings and status reports
- Develop best practices, standards, and methodologies to assist in the implementation and execution of Data Governance
- Data profiling, fuzzy search, fuzzy match, Match and merge sizing and performance tuning on millions of records from various data sources, for trusted golden records creation
- Experienced as a Data Architecture in designing and implementing Data Mart / Data Warehouse applications
Certification
Six Sigma Green Belt Certified
Timeline
Manager
Bright Horizons Family Solutions Inc
09.2019 - Current
Manager
Grand Circle Corporation Inc
02.2018 - 06.2019
Solution Architect
Fresenius Medical Care Inc
04.2015 - 02.2018
Data Warehouse Architect
Sunovion Pharmaceuticals
02.2015 - 04.2015
Team Manager
Credit Suisse
05.2011 - 01.2015
Sr. Software Engineer
OCBC Bank
12.2010 - 04.2011
Business Intelligence, ETL Consultant/Lead
Bayer Inc
10.2009 - 12.2010
Informatica Consultant/Lead
Woolworths Sydney, NSW
01.2009 - 06.2009
Informatica Developer
General Electricals, GE, MAX
12.2006 - 12.2008
Master of Science - Computer Applications
Madurai Kamaraj University
Bachelor of Science - Computer Applications
Madras University
Similar Profiles
Stacey ReynoldsStacey Reynolds
Preschool Teacher at Bright Horizons Family SolutionsPreschool Teacher at Bright Horizons Family Solutions
Yesenia AlasYesenia Alas
Primary School Teacher at Bright Horizons Family Solutions LLCPrimary School Teacher at Bright Horizons Family Solutions LLC
Nicole NoelNicole Noel
Regional Manager at Bright Horizons Family SolutionsRegional Manager at Bright Horizons Family Solutions
Kaylie BabineKaylie Babine
Lead Preschool Teacher at Bright Horizons Family Solutions LLCLead Preschool Teacher at Bright Horizons Family Solutions LLC
Prince AminuPrince Aminu
Industrial Assessment Researcher at Sensors, Energy, and Automation LabIndustrial Assessment Researcher at Sensors, Energy, and Automation Lab