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