Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Saipavan Myana

Saipavan Myana

Hyderabad, Telangana

Summary

I have 6.1 years of experience in cloud computing and data warehousing, with expertise in tools and technologies such as IICS Cloud Data Integration, Informatica PowerCenter 10.6, Informatica BDM 10.6, AWS Glue, Python, Unix, Oracle, SQL, CDB2, and Aurora databases. I possess a strong understanding of warehousing concepts, including Star Schema, Snowflake Schema, dimensions, and fact tables.

I have extensively worked with Informatica/IDMC client tools, including CDI, CAI, Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager, and Informatica Workflow Manager. I have hands-on experience with Oracle, CDB2, Hive, Aurora, and SQL databases, leveraging Unix as the backend.

I have implemented both simple and complex business logic through various transformations, such as Filter, Sorter, Aggregator, Lookup, Expression, Router, Update Strategy, Joiner, and Normalizer. I have expertise in managing slowly changing dimensions (SCD) and have applied Type I, Type II, and Type III strategies to maintain historical and incremental data.

In addition, I have basic knowledge of UNIX and scheduling tools like CONTRPL-M and ESP, with a clear understanding of non-simultaneous dependencies across different functional areas. I’ve handled ad-hoc requests, including order processing in the Test Environment, and contributed to the testing of new IICS features while introducing best practices to improve performance. I have also supported the application team by addressing platform-related issues and creating automated processes to reduce manual work.

Regular interactions with clients have helped me understand their business requirements, enabling me to provide tailored and efficient solutions

Overview

6
6
years of professional experience
1
1
Certification

Work History

IICS Developer

Cognizant
Hyderabad
11.2022 - Current

Project : TRUIST Financial Corporation

  • Truist Financial Corporation is an American bank holding company headquartered in Charlotte, North Carolina
  • The company was formed in December 2019 as the result of the merger of BB&T and SunTrust banks
  • They offer consumer and commercial banking, and securities, this project is set up to collect the data from different source systems according to different subject areas, process the data with required business validation, and provide the data as files to EDW every week
  • All credit/debit transaction data flows through different data arts in the enterprise Datawarehouse
  • As a part of EDO ANALYTICS DATA PLATFORM Roles & Responsibilities: Understanding the requirement of the Data Platform team and supported in various developmental activities
  • Worked on python script preparation for automation of IICS precodereview tool
  • Developed GUI script in python for the precodereview tool Worked on developing the precodereview tool for analysing the coding standards of IICS objects
  • Worked on creating mappings, task flows, mapping tasks for the automation purpose and enhancement purpose, worked on to provide technical or platform support for different sets of applications such as SFDC, PDAPP, Client360, digital, DRM and martech
  • Platform support includes new feature testing of IICS components adding new/best practices to the developers to improve the performance and supporting the IICS platform related issues to the application team and creating the automated process or tools for application team to reduce manual works.

ETL Developer

Accenture
Hyderabad
01.2019 - 10.2022
  • Cisco is one of the Global Market Leaders in the manufacturing of network equipment
  • Cisco maintains its own Data Warehouse
  • All the customers perform transactions, and the data is stored in oracle database which is OLTP data
  • Roles & Responsibilities: Understanding the Business and scope requirements from Customer completely
  • Carrying out development and deployment activities for the History and Incremental codes in Dev instances
  • Understanding the Client Requirements and summarizing this release scope based on the functionality of the project
  • Writing Unit test cases on the related scenarios to be tested such as Count, attribute checks, performance, functional, business logic checks and so on
  • Carrying sanity checks for the code migrated during the deployment and then loading the History and Incremental data
  • Validation of the History data for all the new tables populated to the 3NF tables as per the flow
  • Comparing and validating the old code and flow with the new code
  • Providing IT validations sign-off for both the history and incremental data for QA end.

Education

Graduated - EEE

Vaagdevi Engineering College
Warangal
04-2017

Skills

  • ETL Tools: IICS CDI, CAI, Informatica Power Center 1053, Informatica BDM 1053,1056, Spark and AWS Glue
  • Database: Oracle 11g/12C, MS SQL Server, PostgreSQL, snowflake and CDB2
  • Operating System: Windows, UNIX
  • Programming: SQL, Python

Certification

  • Snow Pro Core certification, 2024, 2026
  • IICS CDI AND CAI Participation Implementation certification

Timeline

IICS Developer

Cognizant
11.2022 - Current

ETL Developer

Accenture
01.2019 - 10.2022

Graduated - EEE

Vaagdevi Engineering College
Saipavan Myana