Vidya Chand Gupta

Accomplished AVP with a proven track record at Citicorp Services India Pvt. Ltd., specializing in leading cross-functional teams and executing complex migrations such as Oracle 11g to Oracle 19C. Expert in Informatica Power Centre and Agile methodologies, I excel in operational management and strategic planning, ensuring project delivery within set timelines and budgets.

Date of Birth: 02/01/81

• English
• Hindi

Database Migration from 11g to 19c, Application migration from Solaris to Linux along with handling EOVS and VA issues, Citicorp Services India Pvt. Ltd, RHEL 7.0, SQL, PL/SQL, Sql Developer, Tectia, 04/19/21 - Present, Oracle, UNIX, ServiceNow, Gathering & identifying business requirements while managing business processes., Working as an SM for DB migration were assigning tasks and creation of Jira, assisting in writing user stories as per requirements., Collaborating with BA, Cross Functional Teams during the QA testing phase., Working on various EOVS and VA related issues as per company standards. Data transfer (ETL) among various databases, Ocwen-PHH Financial Corporation, RHEL 4.0/5.5, ETL tools like Informatica, Talend, Job Automation Scheduler tools like Tidal, Control-M, StoneBranch, 04/01/17 - Present, Informatica Power Centre 10.2(ETL), Tidal (TES), Control-M, MS SQL SERVER, Oracle, UNIX, ServiceNow, Gathering & identifying business requirements while managing business processes, managing ETL Creation, Automation of Scheduler Jobs and System Design Data Warehousing components and various work automations., Collaborating with BA, Cross Functional Teams and Data Stewards during the QA testing phase., Acting as a Production Support Specialist for a DW-BI projects using Informatica / PL-SQL / Control-M/Tidal/StoneBranch in Windows and Linux environments., Following BI change control and continue the integration process for improvements to the production system. Data transfer (ETL) among various databases., Ocwen Federal Bank, RHEL 4.0/5.5, SQL, PL/SQL, Perl, Toad, Putty, 12/01/09 - Present, Developing automated data transfer modules using SQL Loader and Perl; SQL Loader scripts to load data from flat files into the database using External tables., Working on stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Monitoring of daily routine production jobs., Ocwen Federal Bank, SQL, PL/SQL, Perl, Toad, SQL Loader, 06/01/12 - Present Stage5 Daily Download process including EOM., Ocwen Federal Bank, SQL, PL/SQL, Perl, Toad, SQL Loader, 07/01/09 - Present

• Acted as the primary technical liaison between senior leadership, clients, and cross-functional teams, translating complex technical requirements into actionable plans.
• Facilitated regular executive briefings and technical presentations, ensuring stakeholders were consistently informed and engaged throughout project lifecycles.
• Drove alignment across multiple teams, cultivating strong relationships and ensuring seamless collaboration on mission-critical initiatives.
• Defined and executed long-term technical roadmaps aligned with business priorities, driving strategic growth and operational excellence.
• Fostered a culture of continuous innovation, encouraging teams to experiment with new tools and approaches that improved system performance by 25%.
• Proactively identified and mitigated security risks, safeguarding applications and infrastructure against potential vulnerabilities.
• Managed multimillion-dollar budgets for technical projects, ensuring optimal cost allocation, resource utilization, and ROI.
• Negotiated contracts and managed third-party vendor relationships, securing cost-effective agreements while ensuring high-quality service delivery.

• Production/ Application development
• ETL Development/ Support
• Technical Support/ Troubleshooting
• Root Cause Analysis
• Process Automation & Transformation
• Disaster Recovery/ Business Continuity
• Coding & Programming
• Client / Stakeholder Management
• Techno-functional Operations
• Team Building & Leadership