Detail-oriented, organized, and meticulous employee.
Developed and maintained ETL jobs using IBM DataStage to facilitate data integration and migration.
Created and optimized SQL scripts for data transformation and reporting.
Designed data marts in Teradata to support business analytics and reporting needs.
Analyzed source data structures and collaborated with team members to understand DWH architecture and data flows.
Technologies & Tools: IBM DataStage, Teradata, SQL
Developed SQL scripts in SQL Server Management Studio(SSMS) and BigQuery (GCP) for data extraction and transformation.
Scheduled and managed automated jobs in SSMS to support Power BI data refresh workflows.
Designed and implemented ETL processes using SSIS to support reporting and analytics.
Automated recurring reports to improve efficiency and reduce manual effort.
Created interactive dashboards in Power BI, tailored to business requirements for enhanced data visualization.
Technologies & Tools: SQL Server Management Studio (SSMS), BigQuery (Google Cloud Platform - GCP), Power BI, SQL Server Integration Services (SSIS), Windows Task Scheduler
Worked on an ETL project involving data migration, reporting, file management, and new/modified data flows, within an Agile team setup. Actively participated in sprint ceremonies (planning, reviews, daily stand-ups) to ensure iterative delivery and continuous improvement.
Participated in all phases of the testing lifecycle, including strategy definition, planning, estimation, test case design, execution, defect management, documentation, and post-deployment support.
Collaborated closely with developers, analysts, and stakeholders to ensure data quality and seamless integration into the group-level reporting infrastructure.
Conducted functional and data validation tests to verify the integrity, accuracy, and completeness of the migrated datasets.
Managed data files and transfer processes across environments using WIN SCP and Oracle Data Integrator (ODI).
Reported and tracked defects and tasks using HP ALM and JIRA.
Technologies & Tools: Oracle PL/SQL, TOAD, HP ALM, JIRA, WIN SCP, Oracle Data Integrator (ODI).
Developed and maintained Oracle SQL scripts using TOAD to support card system operations and reporting.
Debugged and optimized PL/SQL procedures and functions to ensure system accuracy and performance.
Generated and delivered regulatory reports to VISA, Mastercard, and the National Bank in line with compliance requirements.
Produced monthly credit card statements, ensuring accuracy, timely delivery, and adherence to internal standards.
Monitored the daily operations of the card system, ensuring business continuity and minimal downtime.
Provided Level 2 support for incidents escalated by Helpdesk, Call Center, Branches, Operations, and Compliance departments.
Offered technical and functional support for internal card programs and campaigns.
Executed testing cycles in dedicated environments, validated fixes for reported issues, and supported production deployments to ensure seamless go-lives.
Collaborated with external vendors to troubleshoot and resolve system-related incidents.
Maintained accurate tracking and documentation of card system issues and resolutions.
Ensured adherence to internal IT support procedures, service standards, and audit requirements.
Technologies & Tools: Technologies & Tools: Oracle SQL, TOAD, Java, NetBeans, DB2, Windows Task Scheduler