Amyn Lalani Email & Phone Number

Mississauga, On, Ca

Toronto, Canada Area

Toronto

Toronto, Canada Area

Toronto, Canada Area

Responsibilities============Provide support for Audit and Assurance Services, End User Computing Analysis, Data Assurance and Data Migration initiatives.Key Projects=======SoX compliance Testing.• Responsible for completing stages of an audit including planning, execution, reporting and findings follow-up.• Oversee and execute IT audits, control and resource allocation and processes to ensure audits are completed in accordance with established standards and within prescribed time and scope parameters.• Work with Internal Audit Management to improve the audit process to ensure audits are performed efficiently and delivered to standards.End User Computing:Completed enhancements to an End User Computing file analysis application. The application provided functionality for creating data maps, data sinks and formula analysis. Development was done using VB.Net and SpreadsheetGear.Data Management and Transformation:Created data mapping for transformation of capital health assets from multiple data sources to a single database during an application conversion for a Provincial Health Care provider. Developed ETL Informatica scripts to facilitate transformation of asset and preventative maintenance information. Data Assurance:Provide data assurance for phased data conversion implementation and for the synchronization processes post conversion.

Toronto, Canada Area

Responsibilities============- Responsible for the delivery of application changes in support of CIBC Wealth Management businesses and customers.- Delivered solutions in support of business strategies through in-house system development.- Analysis and Development completed within Application Delivery usually incorporated Enterprise Delivery Methodologies to ensure that development work was coordinated with all other tasks to deliver quality solutions to business needs.Development Environment===================- Korn Shell scripts on UNIX AIX Sun Version 10.- Sybase T-Sql on SYBASE 15- Data Transformation Services (DTS)Main projects==========- Participated in eliciting requirements from business stakeholders to incorporate multi-currency holdings in accounts. Performed systems analysis and created design documentation based on business requirements.- Elicited business requirements and performed script analysis in conjunction with a technology consultant for the design and development of a data driven approach for calculating effective registered account fees and tax amounts.- Implemented secure file transfer based on centralized Feed hub design for 500 Mid-Office reports and data feeds. Responsible for analysis, design, development, testing and application support. Created matrix consisting of report and data files and their associated scripts and destinations. Grouped scripts into bundles for phased release. Incorporated korn shell and DTS script changes for using centralized file transfer directories. Created generic korn shell script for scheduled transfer of files from Mid-Office to the Feedhub server.- Facilitated the analysis, conversion and testing of Mid-office reporting scripts for an upgrade to UNIX AIX Sun Version 10 and Sybase version 15. Script changes included cursor enhancements to overcome side effects and performance issues.

Responsibilities============- Provided Business Analysis, Project Development and Project Management for a Defined Contribution Record Keeping System managing mutual fund investments for employees of large corporate clients. Assets regulated on Insurance, Mutual Fund Dealers Assoc (MFDA) or Defined Benefits platform.- Performed complex application enhancements, application and data migration and business platform strategy changes. The focus through all these experiences were in using a systematic approach and best practices to provide brilliant service to clients.Development Environment===================- ORACLE 10g, SYBASE 15, Pl-Sql Developer, T-Sql- UNIX Korn Shell scripting, Crystal Reports, CA Visual Objects, JavaMain projects==========- Performed data mapping and transformation of data from DB2 to ORACLE pertaining to financial and tax information during a database and application migration. Determined accuracy and completeness of translated data and resolved data issues during execution of processes in the new system.- Transaction Audit: Developed processes for the reporting of account detail and financial activity required by the Transaction Review and Analysis Program resulting in tighter audit controls being put in place to detect and analyze money-laundering activity.- Fund Accounting: Increased efficiencies for the Investment Control Group by automating loading of fund and stock fund distributions, daily rate of per-share income, underlying fund prices and NAV. Automated email alerts to business users.- Canadian Tax Reporting: Responsible for design documentation, business walkthroughs, project planning, code development and test coordination with QA. Streamled reconciliation processes, provided additional controls for accurate financial reporting and timely distribution of tax slips and electronic media. Resulted in greater efficiencies in Operations Reporting.

Toronto, Canada Area

Development Environment ===================- DB2, UNIX Korn Shell scripting, Jetform Reports, Visual C++, C, Cobol, CICSMain projects==========- Application conversion and enhancement. Created design documentation for customization of an existing 401K Record keeping application for the Canadian Defined Contribution platform. Completed batch development for Cash and Cheque Redemption, Foreign Fund Rebalancing and Mgmt Fee Rebate.- Tax Application: Participated in Joint Application Design (JAD) sessions in conjunction with Business Analysts to elicit and analyze tax reporting requirements for the initial year of tax reporting. Created design specification based on a data driven metadata approach. Point of contact and subject matter expert for tax issues, providing and managing a timeline for resolution.- Middle Tier Synchronization. Responsible for synchronization of account details and transaction data from a DB2 source database to a middle tier SYBASE database using T-SQL and INFOPUMP ETL scripts. Resulted in successful initial data transfer and daily account maintenance for 30,000 plus accounts.- Payroll Processing: Analyzed client payroll requirements. Created payroll rule base on a normalized set of relational database tables. Created payroll administration screens and UNIX batch scripts for client payroll processing, transaction posting and internal user and external client reporting. Created client on-boarding documentation, making it effective for new clients to set up a strong customer relationship with Fidelity’s Retirement Services and allowing existing clients to adjust or expand their relationship.- Participant Statements: Provided enhancements for the Statement creation process. The logic processed all applicable account holders, applying validation checks and gathered data on their financial assets and transactions. Data was merged with pre-defined Jetform templates and used by Adobe Central Output Server to create PCL files for printing.

Bachelor Of Science, Computer Mathematics And Management Information Systems

Education record