Trushal Bhopatrao

Dedicated and enthusiastic professional with 12+ years of experience in ETL testing and application production support within the banking and finance sector. Proficient in key tools such as Informatica, WhereScape, Oracle, Teradata, Scheduling tools and Unix Shell Scripting. Adept in both Waterfall and Agile methodologies, I excel in project management and ensuring top-notch ETL production support outcomes. As a customer-focused team player, I consistently strive to achieve optimal satisfaction levels through effective collaboration. My expertise includes data extraction, migration, transformation, and loading into data warehouses, utilizing Informatica Power Center to handle various sources like flat files, XML, COBOL and RDBMS tables. I thrive in fast-paced, deadline-driven environments, leveraging quiet moments to enhance productivity and team development. With a strong work ethic and a commitment to exceeding organizational expectations, I maintain an organized, detail-oriented approach to all tasks. A quick learner with strong analytical and interpersonal skills, I adeptly tackle challenges and resolve issues professionally. 

Senior Associate Projects, Teachers Insurance (TIAA) | Cognizant 

Charlotte, NC                                                                                                                               Feb 2024 - Present 

• Application Production Support: Conducted diligent monitoring of production jobs, batch processes, performing initial analysis of failures to facilitate swift resolutions and minimize downtime.
• Incident & Change Management: Led incident management, problem management, and change management processes, ensuring seamless coordination between teams to address and resolve production issues promptly.
• Technical Troubleshooting: Responded to user issues by troubleshooting technical problems for Autosys, Database, ETL and UNIX, ensuring the continuous operation of systems and minimizing disruption to business processes.
• Cross-Technology Collaboration: Worked together with teams from Informatica, WhereScape, Greenplum, Oracle, Unix systems, and Autosys scheduler administrators to check and move code between different environments.
• Documentation Maintenance: Created clear technical documents, like guides for production and support services, runbooks, etc. to help share knowledge and make sure operations run smoothly and consistently.
• Deployment Validation: I carefully checked and confirmed that everything worked properly after moving to new technology setups. I made sure everything was running smoothly during all the migration processes and created reports showing the results after the deployments.

Manager, MUFG Union Bank | Capgemini Americas 

Columbia, SC                                                                                                                                Mar 2020 – Feb 2024 

• Production Job Monitoring: Monitored job execution across ELT and ETL tools, UNIX servers, GP, Oracle DB, and Autosys schedulers, ensuring optimal performance and swift issue resolution.
• Incident Management & Ticket Handling: Successfully managed production-related incident, change, and problem tickets, ensuring timely resolutions and minimal disruption to operations.
• Annual BCP/DR Test: Efficiently managed all applications BCP/DR testing including from planning, co-ordination, execution and sign off, ensuring timely execution and adherence to operational standards.
• Test Lead for Migration Projects: Led the Tidal to Autosys migration project from inception to production deployment, ensuring seamless transition and minimal impact on business operations.
• Complex Scenario Resolution: Skillfully resolved complex issues while coordinating with source system owners, ensuring smooth day-to-day ETL processes and operations.
• Automation Initiatives: Developed automation scripts to streamline daily batch monitoring and shift coverage, minimizing manual effort and increasing operational efficiency.
• Requirement Gathering & Documentation: Conducted thorough requirement gathering sessions and created detailed understanding documents, ensuring clarity and alignment with project goals.
• Cross-Technology Collaboration: Worked together with teams using tools like Informatica, WhereScape, Greenplum, Oracle, and Unix systems. This helped ensure that code moved smoothly between different environments.
• Deployment Validation & Post-Migration Support: Performed deployment validation and prepared comprehensive post-deployment results, ensuring all migrations met quality standards.
• Knowledge Portal Management: Regularly updated and synchronized knowledge portals and project documentation, promoting best practices and information sharing within the team.
• Real-Time Issue Resolution: Addressed real-time production issues in lower environments during post-deployment support, ensuring minimal downtime and disruption.
• Transmission Onboarding: Successfully executed the transmission onboarding process for external trading partners and internal setups, enhancing data exchange capabilities and improving partner relationships.
• Team Development & Mentorship: Conducted regular staff meetings to discuss progress and areas for improvement, coaching and mentoring team members to enhance their job performance. 
• Knowledge Management: Regularly updated and synchronized knowledge portals and sites for technologies and projects, ensuring that documentation remained current and accessible for team members.

Associate Consultant, MUFG Union Bank| Tata Consultancy Services Pvt Ltd

Pune, MH                                                                                                                                     Dec 2011 – Mar 2020 

• Data Warehouse Design & Development: Designed and developed robust data warehouse objects utilizing Informatica, ensuring optimal data integration and retrieval processes for improved reporting and analytics.
• ETL Framework Enhancement: Enhanced the existing ETL framework shell script, making it more generic and adaptable, which significantly improved efficiency in data processing and reduced maintenance efforts.
• Automation and Shift Coverage Minimization: Implemented automation solutions to minimize shift coverage for DEV/QA/SIT/PROD loads, streamlining processes and enhancing overall operational efficiency.
• Automation and Optimization Initiatives: Led various automation and optimization efforts for the project, including the design, coding, testing, implementation, and support of UNIX reusable components, enhancing operational efficiency and reducing manual effort.
• Environment Management: Collaborated with Informatica, WhereScape, Greenplum, Oracle, Unix systems, and Autosys scheduler administrators to facilitate seamless code migrations across different environments, ensuring consistency and reliability.
• Job Execution Monitoring: Oversaw job executions in testing environments according to project specifications and business user requirements, while monitoring production job execution across ELT and ETL tools, UNIX servers, Greenplum, and Oracle databases.
• Technical Review & Audit Coordination: Coordinated with the enterprise business continuity team to conduct technical reviews and audits of mission-critical applications, documenting findings and addressing any identified vulnerabilities.
• Test Scenario Development: Developed comprehensive test scenarios for validating the accuracy of data within various applications, contributing to the overall quality assurance process.
• Stakeholder Collaboration: Collaborated with stakeholders to ensure a complete understanding of project goals and objectives, fostering a cooperative working environment.
• PII Object Inventory Maintenance: Successfully maintained the Personally Identifiable Information (PII) object inventory by identifying and analyzing delta objects, reporting findings to the respective application teams to ensure compliance and data integrity.

Technical Guidance & Mentorship: Provided technical guidance and support to junior staff members, fostering a collaborative learning environment and enhancing team capabilities.

Bachelor of Engineering - Information Technology

JSPM's Rajarshi Shahu College of Engineering