Ehsan Ahmad Email & Phone Number

Toronto, On, Ca

Toronto, Canada Area

Responsibilities:Legacy Data Conversion/Migration, Data Mapping, Cleansing, wrangling, Transformations, Extractions, Loading ,Validations, Go-Live/Mock conversions and post live support.Tools Used: SSMS, SQL, DB Stored Procedures, Functions, Queries, SSIS, VBA, MS Excel, MS AccessMicrosoft SQL Server, Oracle, MS Access, CSV files, MS Excel, FoxPro DBF files- Work closely with Managers and interact with customers to perform various conversion tasks - Convert data from multiple data sources by using SQLs and software tools- Perform data wrangling steps including Data Discovery, Structuring, Cleansing, Transformation- Reconcile converted financial data to ensure conversion accuracy- Build/customize conversion programs or packages for each customer based on specific requirements- Document data mapping requirements/rules- Perform data validation tasks

Toronto, Canada Area

Tools/Databases Used: NeoLoad, TeamCity, SVN, PowerShell, Postman, JMeter, SoapUI, SSMS, SQL, TeamCity. Microsoft SQL Server, Oracle, MS Access and plain ASCII Text, delimited CSV files, MS ExcelResponsibilities: - Automated testing & continuous integrations- Load & Performance testing for web services including Restful APIs, SOAP- Code merging in SVN & software compilations in TeamCity for software releases- QA testing

Burlington, Canada Area

Tools Used: VB 6/.Net, XML, Crystal Report 11, JIRA, Perforce, Geo 911, IQ/RMSMicrosoft SQL Server, Oracle 9i, MS AccessResponsibilities: To develop, define, analyze and maintain sophisticated software applications. Key responsibilities include coding and testing programs; strong interpersonal skills to research analyze and fulfill user requirements. To collaborate with the QA team to develop unit testing processes and provide task estimation. Other duties include researching, designing, documenting, and modifying software specifications throughout the software development life cycle• To develop/modify VB Functions/Procedures for IQ/RMS • To collaborate with the QA team for unit testing • To create new MSI Install Script packages / Quick Patches for the IQRMS for clients and Field Reporting police officers • To document in the JIRA software about steps taken to resolve the trouble tickets to improve future versions and support

Toronto, Canada Area

Tools Used: VB.Net, ASP / ASP.Net, HTML, XML, Crystal Report, VB / Java Script, Excel, MS Word, ADO / ADO.Net / ODBC, Microsoft SQL Server, MS AccessResponsibilities: To develop a business software running on top of the financial QuickBooks in order to manage data in the hierarchical fashion. It includes CRM, POS, EDI, Sales and Inventory Management, Shipping, Invoicing and Web Services etc• Developed the GUI front end using VB 6 / VB.Net • Used ZPL programming Language for thermal printers• Used Advanced Com Port Forwarder Object for RF devices• Developed several inventory kiosk queries using VB.Net• Developed Data Synchronization Application using VB.Net Developed for EDI Application • Developed Web services using XML, ASP and HTML• Designed And developed reports using Crystal Report

Informage Software Pvt. Ltd (ISPL)(A subsidiary of Carrier Telephone Industries Pvt Limited (CT))Tools Used: Visual Basic 6, ASP, HTML, XML, ADO/ IBM Client Access ODBCSQL Server 7, Oracle, MS AccessResponsibilities: To develop a Computerized Fault Management System (CFMS) for Call centers. It includes Complaint Registrations and Rectification, ACD, ATMs, Console, etc• Involved in requirements gathering, system analysis and design• Developed data migration routines in VB 6.0 for Oracle• Developed the GUI front end using ASP• Designed Tables, Views, Backup plans and Optimization,

Carrier Telephone Industries Pvt Limited (CTI) Tools Used: ILE RPG, ILE COBOL, SEU, SDA, CLP, SQL/400 and RLU, IBM Client Access ODBC, OS/400 DB2/400. Responsibilities: To develop, define, analyze and maintain MRP (Matrial Requirement Planning) software applications for CTI - Manufacturer of Telecom devices (Multiplexers, SRAL, Distribution Cabs, Telephone Exchanges, Digital Devices, Cluster Controllers etc. • Developed the Front-End screens using SDA/400, Sub-Files • Developed CBL programs using ILE COBOL with Embedded SQL for BOM, Product Structures, Surplus, QA Inspection. Production Plans, Procurement,Workshop Orders, Perpetual Costing. • Developed Query/400 objects and PF, JLF & LF files and managed source in several SRCs and Object Data-Lib.

Tools Used: Foxpro, Novel, VB 4 , Lotus 123 Responsibilities: To design, develop and migrate the legacy software written in Foxpro and Lotus 123 to Windows based software application using the Visual Basic 4 and SQL Server in the Windows 3.11 workgroup environment

Mission: Worked with BCS students to help them gain a greater understanding of C++, SAD and OR subjectsCredit Hours:OOP with C++,(4 credit hours)SAD (Systems Analysis & design),(3 credit hours)OR (Operational Research) (3 credit hours)

Master Of Science, M.Sc Computer Sciences

MSc Computer Sciences

Certifications, Computer Programming, Specific Applications

Activities and Societies: • e-commerce, ASP and HTML, College of Advanced Technologies • Windows NT / Advanced Security, N C R • Microsoft.

Bachelor Of Science (B.Sc.), Physics/Double Math

B.Sc (Physiscs,Math)

F.Sc, Pre-Eng., A

Maric, Science, 1