Hetansh Shah Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

• Developed Python scripts and established preprocessing data pipelines to effectively preprocess data before loading it into Account Reconciliation Cloud Services.• Engineered a batch script to automate data loading processes and streamline the import-export of integration across environments, resulting in a minimum of one hour saved per integration.• Created test scripts to examine the integration and devised test scenarios to validate the integration process thoroughly.• Designed… Show more • Developed Python scripts and established preprocessing data pipelines to effectively preprocess data before loading it into Account Reconciliation Cloud Services.• Engineered a batch script to automate data loading processes and streamline the import-export of integration across environments, resulting in a minimum of one hour saved per integration.• Created test scripts to examine the integration and devised test scenarios to validate the integration process thoroughly.• Designed and implemented comprehensive integration solutions encompassing import formats, data rules and data mapping techniques to seamlessly integrate the data in system.• Investigated and recommend solutions to data load problems that occur across environment including production.• Managed vendor Service Requests for software issues, effectively communicating preferred solutions recommended by the vendor to the business.• Adhered to TD Technology delivery practices and standards, as well as project management disciplines. Show less

Waterloo, Ontario, Canada

• Designed and implemented SuiteScripts and SuiteFlows to enhance and optimize Procure-to-Pay (P2P), Order-to-Cash (O2C), and Financial Asset Management (FAM) operations within Oracle NetSuite, streamlining critical business processes.• Spearheaded the successful implementation of an Expense Report system, involving the modification of 3 SuiteScripts and creation of 2 SuiteFlows. Additionally, integrated 10 new fields to facilitate seamless linking of expense reports with… Show more • Designed and implemented SuiteScripts and SuiteFlows to enhance and optimize Procure-to-Pay (P2P), Order-to-Cash (O2C), and Financial Asset Management (FAM) operations within Oracle NetSuite, streamlining critical business processes.• Spearheaded the successful implementation of an Expense Report system, involving the modification of 3 SuiteScripts and creation of 2 SuiteFlows. Additionally, integrated 10 new fields to facilitate seamless linking of expense reports with employee bank details, ensuring efficient payment processing.• Collaborated in the refinement of NetSuite upgrade test cases for Record-to-Report (R2R), Procure-to- Pay (P2P), Order-to-Cash (O2C), and Administrative processes, simplifying the testing process and enhancing tester efficiency by ensuring intuitive navigation.• Executed the integration of Sales Order processes from Salesforce to NetSuite, enabling seamless creation and real-time updates of sales orders in alignment with Salesforce data.• Conducted post-sandbox refresh activities within the Development environment, meticulously mapping 7 distinct integrations and 10 schedule scripts to meet the predefined expectations of the Development environment.• Streamlined financial reporting by designing and implementing complex financial data models and custom reports in NetSuite, providing decision-makers with actionable insights.• Established role-specific security measures and access controls within NetSuite to fortify data security and ensure adherence to industry regulations, benefiting treasury, AR lead, and AP payables teams, among others. Show less

Waterloo, Ontario, Canada

• Created 20 innovative SuiteScripts tailored to enhance and customize Procure-to-Pay, Order-to-Cash, and Fixed Asset Management processes.• Collaborated with users to gather requirements and meticulously documented script modifications essential for updating the Procure-to-Pay (P2P) process.• Upgraded and optimized 14 scripts from SuiteScript 1.0 to 2.0, achieving a notable 15% performance improvement.• Designed test cases, conducted script testing, and verified… Show more • Created 20 innovative SuiteScripts tailored to enhance and customize Procure-to-Pay, Order-to-Cash, and Fixed Asset Management processes.• Collaborated with users to gather requirements and meticulously documented script modifications essential for updating the Procure-to-Pay (P2P) process.• Upgraded and optimized 14 scripts from SuiteScript 1.0 to 2.0, achieving a notable 15% performance improvement.• Designed test cases, conducted script testing, and verified workflow updates for transactions.• Addressed 13 process issues, delivered timely solutions to client queries, and conducted in-depth analysis of 30 scripts to identify and troubleshoot data discrepancies within transaction fields. Show less

Mumbai, Maharashtra, India

• Developed complex SQL queries and stored procedures to extract, transform, and load (ETL) large datasets from 10 diverse sources into a unified data warehouse.• Applied in-depth proficiency in Informatica IICS (CDI and CAI) to design, set up, and sustain data integration for 20 workflows, guaranteeing uninterrupted data flow throughout the organization.• Collaborated with cross-functional teams to define data requirements, create data models, and implement data governance practices… Show more • Developed complex SQL queries and stored procedures to extract, transform, and load (ETL) large datasets from 10 diverse sources into a unified data warehouse.• Applied in-depth proficiency in Informatica IICS (CDI and CAI) to design, set up, and sustain data integration for 20 workflows, guaranteeing uninterrupted data flow throughout the organization.• Collaborated with cross-functional teams to define data requirements, create data models, and implement data governance practices, ensuring data quality and consistency.• Created real-time data streaming solutions using technologies like Apache Kafka, providing instant access to critical business data.• Demonstrated proficiency in Informatica PowerCenter and Power Exchange to design, develop, and implement ETL processes, enhancing data extraction, transformation, and loading efficiency.• Deployed and managed cloud-based data storage solutions, including Amazon S3 and Azure Data Lake, optimizing data storage and retrieval performance.• Leveraged advanced SQL expertise to seamlessly query and manipulate data within enterprise data warehouses, enabling comprehensive data analysis and streamlined reporting processes.• Provided mentorship to incoming team members during the project initiation phase, catalyzing growth and enabling contributions to the project's accomplishment. Show less

Mumbai, Maharashtra, India

Mumbai, Maharashtra, India

• Collaborated with the development team to design, code, test, and debug Android applications under the guidance of senior developers.• Contributed to the development of feature-rich, native Android applications, encompassing elements such such as GPS tracking, push notifications, and data synchronization.• Worked closely with the QA team to identify, report, and troubleshoot software defects, resulting in a 25% reduction in application issues.• Participated in code reviews and… Show more • Collaborated with the development team to design, code, test, and debug Android applications under the guidance of senior developers.• Contributed to the development of feature-rich, native Android applications, encompassing elements such such as GPS tracking, push notifications, and data synchronization.• Worked closely with the QA team to identify, report, and troubleshoot software defects, resulting in a 25% reduction in application issues.• Participated in code reviews and version control, maintaining code quality and adhering to best practices for Android app development Show less

Master Of Applied Computing

Advance Computing Concepts, Advance System Programming, Advance Software Engineering, Advance Database Topics, Internet Applications/.

Be - Bachelor Of Engineering, Information Technology, 8.93

Diploma, Information Technology, 8.05

Education record