Viswanathan Ananthanarayanan Email & Phone Number

Greater Toronto Area, Canada

Led and managed data transformation initiatives, ensuring alignment with Lines of Business (LOBs) strategies. Responsibilities included:Strategic Analysis & Design:Analyzed business needs and designed data solutions aligned with LOB goals.Full-Lifecycle Development: Oversaw the entire development process, from initial design to implementation and.

Toronto, Ontario, Canada

• Spearheaded Development & Implementation: Led the development, testing, and implementation of initiatives, ensuring they met both functional and non-functional application requirements.
• Collaborative Project Leadership: Chaired project and team meetings, fostering collaboration with team members and other departments. Provided development expertise, influencing timely delivery, design, and quality of.
• Project Ownership & Communication: Owned project development and delivery from roadmap definition to timelines. Collaborated with business stakeholders and data consumers to establish clear plans and ensure data.

Mississauga, Ontario, Canada

San Antonio, Texas, United States

• Proactively detected, troubleshot, and resolved all issues affecting asset management applications ensuring continuous system availability.
• Proven experience in incident identification, diagnosis, troubleshooting, resolution, and solution implementation
• Proactively built automated Fiserv APL Trade data recon process using python.
• Identified Trade outliers by creating custom Compliance Test cases and Workflows rules on Charles River Development Order Management System.
• Facilitated Application Database upgrades, Quarterly DR activities and system upgrades.
• Communicated and managed expectations of the senior management team and affected stakeholders during the planning and roll out of project releases.

San Antonio, Texas Area

• Lead a team of 25 developers and QA testers in the divestiture of USAA Investment Business worth over 80$B to Charles Schwab.
• Mapped and cleansed account and member data from custodians and transformed data to meet client standards.
• Designed and developed custom ETL batch jobs to generate supplemental member data file containing 1.4M account and member data.
• Developed ETL Datastage batch jobs to perform recon of supplemental and deconversion files and created Shell and Python scripts for automated file validation, file archive and SFTP.
• Improved performance of existing ETL processes and SQL queries resulting in 30% decrease in batch run time
• Facilitated End to End Investment Application Testing and worked on the retirement of the systems post divestiture.

Austin, Texas

• Designed and built the landing tables for data load from SAP and other external sources.
• Created automated ETL pipelines to load a variety of raw manufacturing data sources into EBI.
• Developed reusable ETL solutions for loading user-maintained Marketing and Product Hierarchy data into Teradata Tables.
• Re-engineered business critical Batch job pertaining to client’s Material Data load process, resulting in substantial decrease in batch run time by 60%.
• Designed and implemented incremental import of BOM (Bill of Material) data from ePLM into Teradata tables.
• Wrote complex TERADATA SQL queries and BTEQ scripts upon schema understanding for Data loading, extraction, and other needs and incorporated the queries in shell and BTEQ scripts for automated data extraction and.

San Antonio, Texas, United States

• Lead a team of ETL developers to successfully build a reusable ETL batch solution using IBM Datastage to restructure the Security Pricing process adhering to strict coding standards.
• Designed conceptual data model based on the requirement, interacted with business and end users to understand the business logics.
• Facilitated CRD Trading and compliance system upgrade and re-wrote ETL and Shell batch scripts in support of the upgrade.

Chennai Area, India

• Demonstrated hands-on experience in Production Support environment.
• Handled over 1000 nightly and intraday batch jobs, resolving any code snags or batch abends.
• Achieved 99.98% system availability by identifying and fixing outages within stipulated SLA's.
• Strong experience in Incident, Knowledge, Problem and change management process using ServiceNow and Service Manager.
• Facilitated 62% reduction in YoY user and member incident tickets.