Rajesh Thacker

Spearheaded migration of Datastage Jobs to Informatica IICS for Finance, Sales, and Marketing, enhancing data integration efficiency across three complexity levels.

Developed automated Java scripts to streamline data uploading from Excel into Informatica, reducing manual effort and improving data ingestion processes.

Optimized Business Intelligence (BI) reports, significantly improving performance, usability, and accuracy to empower data-driven business decisions.

Managed end-to-end data validation and reporting for a critical UAE project, achieving successful deployment with zero defects and securing all required approvals.

Oversaw project delivery, resource quality, and client interactions for data-intensive projects, ensuring timely and high-quality outcomes from 2016 to 2024.

Gathered precise requirements from Business System Analysts, translating them into technical specifications for data solution development.

Developed, coded, and rigorously tested data solutions with Quality Assurance teams, ensuring high functional and system integrity.

Executed comprehensive testing of Datastage Jobs and mainframe files in integration environments, identifying and resolving critical data issues.

Authored detailed Run Books and ETL Migration documents, standardizing deployment processes and ensuring smooth production transitions.

Verified tested results on Production, ensuring data accuracy and system reliability post-deployment for various data applications.

Designed and implemented Event Engine Jobs for automated procedure execution, enhancing system efficiency during a critical Sybase to Teradata migration.

Collaborated with cross-functional teams to identify and map complex procedure chains for Event Engine integration, ensuring comprehensive migration coverage.

Coordinated with the Manila Team to develop and integrate Perl scripts for dependent procedures, ensuring seamless data flow and system functionality.

Managed daily development activities, providing technical guidance and resolving issues for a team of developers, maintaining project momentum and delivery.

Facilitated knowledge transfer and integration testing at a client site in France, ensuring smooth project onboarding and early issue resolution over one month.

Translated complex client business requirements into detailed technical designs and accurate effort estimations for data solutions.

Developed Bteq scripts and Datastage jobs to implement data transformation logic, directly addressing client requirements and improving data processing.

Conducted peer reviews of team members' technical objects, maintaining code quality and adherence to project standards, reducing potential errors.

Formulated comprehensive Project Execution Plans, providing strategic direction for project management and efficient delivery.

Developed robust Oracle Procedures and Functions to meet specific project requirements for the Meter Billing and Audit system.

Utilized SQL Loader to efficiently load large datasets into Oracle databases, optimizing data ingestion processes.

Conducted rigorous testing across various scenarios to ensure the accuracy and reliability of developed data solutions.

Generated and delivered detailed output reconciliation reports to service providers, verifying data consistency and system performance.

Developed and optimized SQL queries and PL/SQL scripts for robust database updates, ensuring data integrity and performance across multiple projects.

Designed and implemented user schemas, facilitating structured data management and access control within the database environment.

Translated intricate business rules into efficient database logic, enhancing system functionality and compliance.

Contributed as a key SQL developer on numerous projects, consistently delivering high-quality and reliable database solutions.