Swathika Dharani

Designed and implemented query conversion from DB2 to SQL in the database (Client: QVC, Allianz, ANZ)

 Proficiently executed Data Definition Language (DDL) and Data Manipulation Language (DML) Queries in Oracle.

 Utilized Informatica PowerCenter tools, including Designer, Workflow Manager, Workflow Monitor, Mapplet Designer, and

Mapping Designer, implementing various transformations such as Source Qualifier, Filter, Sorter, Expression, Union, Joiner, and

Update Strategy.

 Extensive experience in ETL processes involving extraction, transformation, and loading of data from diverse source systems such as Oracle and flat files.

 Implemented data decommissioning using MongoDB and Cap360.

 Created the report for the Informatica CDC and RCDC workflow’s performance.

 Prepared design documents, ETL specifications and migration documents.

 Hands-on experience with Jenkins deployment and source code repository using Bitbucket.

 Designed and developed interactive dashboards in Power BI, focusing on data modeling, visualization, ETL processes, and performance optimization.

 Analyzed complex datasets and generated comprehensive reports, allocating efforts toward understanding business needs, creating interactive visualizations, and ensuring data accuracy through thorough validation processes.

 Contributed to data migration using AQT, MongoDB, Informatica PowerCenter, Python, GIT, ServiceNow, Postman, PowerShell,

IBM Data Studio, and Dynatrace.

 Utilized JIRA Ticket Tracking Tool for effective project management.

 Created Change request in change Management, incident management using ServiceNow.

 Collaborated with cross-functional teams, playing a key role in troubleshooting and process improvement.

 Automated recurring reports using reusable templates and DAX functions, focusing on efficient design and custom calculations to enhance reporting accuracy and efficiency.

 Applied Agile methodology extensively, contributing to efficient project delivery and adaptability.

Designed and implemented query conversion from DB2 to SQL in the database (Client: QVC, Allianz, ANZ)

 Proficiently executed Data Definition Language (DDL) and Data Manipulation Language (DML) Queries in Oracle.

 Utilized Informatica PowerCenter tools, including Designer, Workflow Manager, Workflow Monitor, Mapplet Designer, and

Mapping Designer, implementing various transformations such as Source Qualifier, Filter, Sorter, Expression, Union, Joiner, and

Update Strategy.

 Extensive experience in ETL processes involving extraction, transformation, and loading of data from diverse source systems such as Oracle and flat files.

 Implemented data decommissioning using MongoDB and Cap360.

 Created the report for the Informatica CDC and RCDC workflow’s performance.

 Prepared design documents, ETL specifications and migration documents.

 Hands-on experience with Jenkins deployment and source code repository using Bitbucket.

 Designed and developed interactive dashboards in Power BI, focusing on data modeling, visualization, ETL processes, and performance optimization.

 Analyzed complex datasets and generated comprehensive reports, allocating efforts toward understanding business needs, creating interactive visualizations, and ensuring data accuracy through thorough validation processes.

 Contributed to data migration using AQT, MongoDB, Informatica PowerCenter, Python, GIT, ServiceNow, Postman, PowerShell,

IBM Data Studio, and Dynatrace.

 Utilized JIRA Ticket Tracking Tool for effective project management.

 Created Change request in change Management, incident management using ServiceNow.

 Collaborated with cross-functional teams, playing a key role in troubleshooting and process improvement.

 Automated recurring reports using reusable templates and DAX functions, focusing on efficient design and custom calculations to enhance reporting accuracy and efficiency.

 Applied Agile methodology extensively, contributing to efficient project delivery and adaptability.

B.E Computer Science