Subramanian Chokkalingam

Technologically savvy and focused Business Data Professional with strong background around 11.5 years of experience in designing, developing, and maintaining data integrations, analytics, and Business Intelligent solutions. Effective in developing and optimizing data systems to meet customer needs. Seeking a challenging opportunity where I can utilize my expertise and contribute to the success of bridging data and business.

Data Integration: Extensive experience in designing, developing, and implementing data integration solutions using industry-leading tools such as Informatica PowerCenter and IBM InfoSphere DataStage. Proficient in ETL (Extract, Transform, Load) processes, data mapping, data profiling, and data quality management.

Database Management: Strong understanding of database concepts and hands-on experience with various database systems such as Oracle, SQL Server, Teradata, and Snowflake. Skilled in writing complex SQL queries, optimizing database performance, and ensuring data integrity.

Scripting and Programming: Proficient in scripting languages like shell scripting to automate data integration tasks and workflows. Learn Python and R-programming as part of my PG course and have started developing custom integration coding using them.

Data Warehousing: Knowledge of data warehousing principles and best practices. Experience in designing and developing dimensional data models (star and snowflake schemas), creating ETL workflows, and implementing data governance policies.

Data Analysis: Ability to analyze complex data sets, identify patterns, and derive actionable insights. Good Exposure to using data analysis tools such as Excel, Tableau, and Power BI to create meaningful visualizations and reports.

Communication and Collaboration: Strong interpersonal and communication skills, with the ability to effectively collaborate with cross-functional teams, stakeholders, and business users. Experience in gathering requirements, conducting workshops, and providing technical guidance.

• Working with LOBs to understand the requirements and convert them into technical specification and implementation
• Design and Develop Informatica mappings, and data pipelines using different transformations to extract, transform, and load data into ODS, Salesforce, and Snowflake
• Design API-led integrations using Mulesoft Anypoint Platform
• Create Interface Agreement Documents, Unit Testing & Solution Documents for each Data flow
• Manage the Data Integration team in reviewing the code and documents
• Work on Snowflake data management and migration of oracle database to Snowflake
• Performing POC in IICS and Mulesoft for Veeva CRM to Vault CRM migration and leading this migration activity from Data Integration side.
• Performing Data Loads as part of Plan of Action on quarter/Ad-hoc basis
• Enhancing existing process, both inbound and outbound
• Working on Change Requests and Incidents, ensuring that they are delivered on time with high quality
• Develop high data quality pipelines by enforcing quality rules at all the end-points

➢ ETL/Middleware Tools: Informatica Power Center 9.1 & 9.6.1 & 10 versions, Informatica Intelligent Cloud Services (IICS), IBM Datastage, MuleSoft 4 Anypoint API Platform
➢ Databases/Datawarehouse: Microsoft SQL Server 2008, 2016 and Oracle SQL developer, Teradata, Snowflake Cloud Datawarehouse.
➢ Languages: PL/SQL, UNIX, Shell, Python, R programming
➢ Issue Tracker: JIRA-Atlassian & ServiceNow.
➢ Project Lifecycle: Waterfall, AGILE-Development.
➢ Cloud Services: AWS Services, Microsoft Azure DevOps
➢ CRM Tools: Salesforce, Veeva
➢ Reporting Tools: Tableau, OBIEE, and Power BI