P SOBITHA

PROFILE SUMMARY :

• Skilled IICS developer with over 5 years of IT experience in all
stages of the software development life cycle (SDLC), including
business and data analysis, data mapping, data integration, data
visualization, unit testing and deployment
• Strong background in database development and possess ETL
skills for data warehousing using Informatica.
• Superior SQL skills for writing and interpreting complex SQL
statements.
• Proficient in SQL optimization, ETL debugging, and performance
tuning and optimization.
• Experienced in integrating various data sources with multiple
relational databases such as MySQL, Oracle, and flat files like csv,json into staging areas.
• Also experienced in integrating flat files into Dynamics CRM, data
warehouse, and data mart.
• Excel at implementing complex business rules through reusable
transformations, complex mapplets and mappings, as well as SQL
transformation.
• Excellent communication and presentation skills with strong
project management abilities. Valuable team player who excels
both independently and as part of a team.

Project 1:

Domain : Payments & Insurance

Client : Wells Fargo (Apr 2022 - Nov 2024)

Technologies : IICS, ORACLE

• Created mapping documents with detailed source to target transformation logic, Source data column information and target data column information.

• Created IICs connections using various cloud connectors in IICS administrators.

• Utilized Sequence Generator transformation to generate unique sequence numbers, ensuring data uniqueness and improving data analysis capabilities.

• Used Router transformation to direct data flows based on business rules and conditions, ensuring efficient data processing and minimizing errors.

• Demonstrated expertise in using Lookup transformation to perform data validation, data cleansing, and data standardization.

• Involved in creation of ETL and Datawarehouse standards documents – Naming standards, ETL Methodologies and strategies, Standard input file formats, data cleansing and preprocessing strategies.

• Handled configuration activities like setup run time environment and create connections, schedules, tasks, mappings, mapplets & components.

Project 2:

Domain : Dashboard Creation

Client : BMO USA (Feb 2019 - Mar 2022)

Technologies : IICS, ORACLE

• Designed and developed dashboards to provide real-time insights and analytics to stakeholders.

• Utilized Quicksight and PowerBI features such as data visualization, filtering, and drill-down capabilities to create intuitive and user-friendly dashboards.

• Worked with cross-functional teams to gather requirements and design dashboards that met business needs.

• Deployed and maintained dashboards on cloud-based platforms, ensuring data security and accessibility.

• Collaborated with stakeholders to iterate and refine dashboards based on feedback and changing business requirements.