Sql Server Developer
Resume:
Tarek Basta
*******@*****.***
Professional Profile
More than seventeen years of progressive experience in building quality standard client server distributed n-tier business applications and providing data analysis and technical support. Worked in all phases of project lifecycle (SDLC) including analysis, design, implementation, testing and deployment. Proficient in hi-performance RDBMS design (modeling, normalization) and SQL Development (procedures, functions, views, linked servers, federations, SSIS/ETL, SSRS) in MSSQL, MySQL and IBM DB2. Experienced in inheritance, data Abstraction designing and modular design development and code reuse in C#, VB.NET. Knowledgeable in legacy programming in VB6, and VBA MS Access. Dedicated and supportive team player with strong technical aptitude, problem-solving skills, flair for design and keen desire for ongoing learning. Dependable, accurate and self-motivated with ability to work well under pressure. Proven ability to meet project deadlines against aggressive schedules.
Expertise & Technical Summary
Application Development:
VB6, VBA (Access & Excel), VBScript, C#, VB.Net, ASP.NET, ADO.Net, DAO, OLEDB, OOP, T-SQL, XML, Windows PowerShell, Command Batch files, Knowledge in Python
Web Development:
HTML/DHTML, MS FrontPage
Database & Tools:
MS SQL Server 2016/2014/2012/2008 R2 (ETL/SSIS, SSRS), MySQL, MS Access, Merant Progress, Access Reports, Crystal Reports, Toad Database Developer Tools, Microsoft Power BI
Software & Tools:
Infor Syteline, MS Office, MS Visio (UML, Flowcharts), Virtual Terminal Server, Seagull Bartender, EMC PixTools, telerik, Team Foundation Server (TFS), Source Control Management (MKS), Visual Source Safe (VSS), Toad Data Modeler (logical & Physical Data Modelling), Jira
Environment:
SQL Server 2012/2008 R2/2005, MS Windows 7/10, MS Visual Studio .NET 2008/2005, MS Visual Studio 6, MS Office, ERP Data Warehousing, IBM DB2, IBM PCOMM
Work History
Senior VB Developer (Contract)
June 2018 – December 2018
… TD Bank (CB&W Technology Solution), Toronto, Ontario
Migrated Microsoft Access/Excel applications from 2010 to 2016. Configured ODBC connections for DB2 & Microsoft SQL Servers. Implement application remediation and code rewriting to overcome incompatibility issues while migrating from Windows 7/Office 2010 to Windows 10/Office 2016 environment.
Environment: Windows 7/10, Microsoft Office 2010/2016, Microsoft SQL Server 2012, MS Visual Studio 2017
Lead Senior Database Architect/Developer (Contract)
January 2018 – May 2018
… Defence Research and Development Canada (Canadian Armed Forces), North York, Ontario
Created the logical and physical data modeling for the AnthroMaster (Anthropology) database and SSIS packages to ported the Canadian, USA and Australian armies’ statistical body measures from csv flat files to database. Created dynamic stored procedures to calculate all statistical requirements for any given numerical data column in any table. Converted the PCA tool from C++ to VB.Net/ADO.Net (Winform) and expanded on its functionalities. The PCA tool is a desktop application that analyses data and creates graphical statistic modules in two and three dimensions. Created R scripts and Refactored and upgraded existing ones as of business requirements. Used Jira to track project development and UAT.
Environment: MS SQL Server 2016, C#, Microsoft Access (VBA), Microsoft Excel (VBA), RStudio (R Script software editor), R, MS Visual Studio 2017, Jira
Lead Database/VB Developer (Contract)
April 2017 – December 2017
… CIBC Banking and Financial Service (Portfolio Management), Toronto, Ontario
Migrated the Microsoft Access TO Financial Application from 2007 to 2016 and moved the database to SQL Server; recreated all conceptual, logical and physical models. Refactored and ported hardcoded Access sql queries to tsql views, stored procedures and user-defined functions. Refactored VBA and modified code to consume SQL Server ported database. Redesigned user interface and simplified application navigation process. Designed and created new reports. Created SSIS packages to address business requirements. Created visualization reports using Tableau.
Environment: MS Windows 7, MS Office 2010 (Access & Excel VBA), MS SQL Server 2012, SSRS, Tableau, SharePoint, Tableau 10
Lead Senior VB Developer Analyst (Contract)
August 2016 – February 2017
… GoEasy Ltd., Mississauga, Ontario
Provided Architectural design for sales data (csv/ xlsx) and created SSIS/ETL packages for importing flat data structures and mapped them to SQL Server tables. Migrated and refactored Microsoft Access VBA and Excel applications and tools from 2007 to 2016. Added custom fit modules as of business needs. Created and refactored SQL Server stored procedures, User Defined Functions, views, queries and SSRS Reports to improve performance. Created daily, weekly and monthly reports with all required documentation. Streamlined Microsoft Excel macros, VBA, data import, and export ETL from SQL Server. Investigated and fixed data integrity issues. Created Windows PowerShell Scripts as required.
Environment: MS Windows 7, MS Office 2013 (Access VBA), Ms SQL Server 2012, RSSS ODBC, Microsoft Power BI, Windows PowerShell Scripting
Lead VB Developer Consultant (Contract)
September 2014 – May 2016
… Royal & Sun Alliance Insurance (National Operation), Mississauga, Ontario
Conducted data architecture and developed conceptual and logical data modeling. Designed and coded the Work Distribution and Performance Reporting Tool (DaRT) that eliminated the need for one fulltime employ to distribute, monitor and report on processing for an insurance conversion project. DaRT tool provided a real-time team/individual performance reporting and enabled visual boards and enhanced coaching. DaRT is a Microsoft VB.Net Winform application.
Designed, built and implemented and automated a process for commercial policy renewals (HAT) realizing a three folds’ increase in productivity when processing over 3,500 commercial policy renewals: That year it took three people three weeks to complete 3,000 renewals for a single client that would take nine people three weeks to do manually. With additional PCs and system ids, team should have the capability to realize nine folds’ increase in productivity. HAT is a Screen Scraping application that consumes IBM PCOMM API to communicate with Mainframe host sessions and IBM DB2 databases. HAT has been developed utilizing Microsoft Excel VBA and Macros capabilities.
Environment: MS Windows 7, MS Office 2013 (Access & Excel VBA), IBM DB2, IBM PCOMM, Ms SQL Server 2008R2, OS/400, MS Visual Studio 2013
Lead Senior VB Developer (Contract)
June 2013 – May 2014
…Bank of Montreal (Delivery Office, P&C PO), Toronto, Ontario
Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for the Ordering Automation Application (AOA). Coded, unit tested and debugged the AOA in Microsoft Excel VBA from start to end. Provided second tier technical support to AOA users. The application is to automate filling web-forms for three Mortgage Appraisal Vendors (Brookfield, National Wide Appraisal and Solidifi). Participated in coding, testing and fixing bugs in FCT Ordering System (ASP.Net web application to register mortgages on the First Canadian Title portal). Bullet Proofed client and server side code and security settings against SQL Injection. Completed the Garnishment web application (asp.net, C#/VB.Net, ADO.Net). Administered the SQL Server and granted access levels as per the user privileges.
Environment: MS Windows 7, MS Office 2010 (Access & Excel VBA), MS SQL Server 2008 R2, MS Visual Studio 2010, Team Foundation, Visual Source Safe (VSS), Hummingbird
Senior VB Developer (Contract)
November 2012 – April 2013
…Salumatics Inc., Mississauga, Ontario
Maintained the Microsoft Access VBA Thiinc applications (Medical Documents Scanning Applications). Created and streamlined Stored Procedures and SSIS packages. Created and scheduled new SQL Server Jobs to automate manual processes using T-SQL. Wrote technical specifications documents and created flowcharts and data models for undocumented parts of the applications. Suggested required steps to convert VB6/ADO applications to VB.NET/ADO.Net. Refactored existing code for better performance. Coded new VB.NET and C# abstract and interface classes and modules to convert and merge single and multipage tiff images to pdf files and to extract specific pages from pdf files and convert them to tiff images using EMC PixTools.
Environment: MS Windows 7, MS Office 2007, MS SQL Server 2008 R2, MS VB6, MS Visual Studio 2010, PixTools 8.4, Visual Source Safe (VSS)
Senior VB Developer
October 2010 – October 2012
…Planet Energy (ON) Corp., Mississauga, Ontario
Company’s sole VBA Access and Excel Developer. Took full responsibility of all VB, Reports and SQL Server T-SQL (tables, views, Triggers, stored procedures and user defined functions) coding development and unit testing. Created the USA Energy Billing System Database and application (Microsoft Access/SQL Server backend) Participated in design and requirement gathering discussions and produced design/functional artifacts and technical specifications.
Dramatically improved Canada Billing System performance by replacing linked tables and embedded queries with T-SQL (server side) Stored Procedures and user defined functions.
Streamlined Canada Market Billing Application functionalities and refactored most of the code.
Redesigned screens to meet usability standards.
Environment: MS Windows 7, MS Office 2007, MS SQL Server 2008 R2, MySQL Server 5. MS Visual Studio 2008, MS Visual Source Safe (VSS)
Database Developer (Contract)
May 2009 – March 2010
…MDA Corporation (Space Missions Department), Brampton, Ontario
Migrated the Space Missions databases from SQL Server 2005 to SQL Server 2008 R2. Fixed and enhanced TSQL stored procedures and user defined functions. Refactored and modified VB.Net/C#/ASP.Net/ADO.Net applications as required by Mobile Servicing System Program. Administered the Engineering SQL Server Databases. Provided Canadian Space Agency and NASA with status reports on monthly basis utilizing SQL Server Reporting Service (SSRS). Created the Microsoft Access Space Viewer App.
Environment: MS Windows XP, MS Windows Server 2008, MS SQL Server 2005, MS SQL Server 2008, MS Visual Studio 2005/2003 (VB.NET, C#, ASP.NET), MS Office 2003, MS Visual Source Safe (VSS)
Developer Analyst
September 2007 – March 2009
…Nutech Systems Inc., Mississauga, Ontario
Gathered and analyzed business requirements, wrote technical specifications, evaluated alternative design approaches, and designed technical processes to meet business needs. Customized and enhanced dcGlu ERP interface programs for Infor Symix/Syteline. Created all required SQL Server database tables and views and stored procedures required for data collection solutions, custom software and add-on modules to meet approved Software Requirements Documents utilizing C#, VB.NET, VB6, MS SQL Server T-SQL Scripting Language and Merant Progress. Converted clock-in and out DcGlu modules from VB6 to VB.NET. Provided technical support to USA company clients and held GoToMeetings sessions to go through technical issues. Created the Toyota Selective Label Printing application (VB.Net Winform). Migrated SQL Server 2005 to SQL Server 2008R2.
Environment: MS Windows XP, MS Windows Server 2003, MS SQL Server 2005, MS Visual Studio 2005 (C#, VB.NET), MS Visual Basic 6, Merant Progress, Infor Syteline 7/6, MS Office 2007, Seagull Bartender, Visual Source Safe (VSS).
Customer Service Agent
January – August 2007
…Siemens Business Services Canada Inc., Mississauga, Ontario
Provided global-wide customer service to 3Com consumers. Responded and investigated customers' requests via telephone and email. Created RMA for defective under warranty or contract network devices. Assessed and escalated customers' calls to third line Technical Support agents.
Technical Systems Analyst
January 2000 – November 2005
…Royal Bank (RBC), Toronto, Ontario
Collaborated across Information Technology to assess research and analyze business, technical and system needs. Carried pager and provided rotating production technical support. Resolved business issues and recommended technology solutions. Provided application support and development services to the insurance service Center. Developed VB6, VBA MS Access, VB.NET, C, C++ MFC business applications integrated with DB2 and MS SQL Server T-SQL Scripts and Crystal Reports. Took major role in converting legacy application to VB.NET and applying object-oriented principles such as inheritance, encapsulation and polymorphism.
Environment: MS Windows XP/2000/NT, MS Windows 2003/2000 Servers, Visual Studio 6 (VB6, C MS Visual Studio 2003 (C#, VB.NET), MS Office 2003/2000, MS SQL Server 2000, Pervasive, Crystal Reports, MKS source control management
Education
Computer Programming Diploma 3.4 GPA (Graduated with Honors)
…Seneca College, Toronto, Ontario
Systems Analysis, Design, and Object Oriented Programming using C, C++, VB, and Java. Database Design & Structured Query Language.
Computer Networking and Technical Support Diploma 3.3 GPA
…Seneca College, Toronto, Ontario
PC Hardware setup, troubleshooting and maintenance. Operating Systems and software installation. Helpdesk and technical support principals. Network administration using Windows NT
Bachelor of Veterinary Medicine Science (B.V.M.Sc.)
…University of Sharqqia, Egypt, Sharqqia
Considered by the University of Toronto (Comparative Education Service) to be comparable in academic level to Bachelor of Science degree from a reputable Canadian University.
Part-time Studies
…Ryerson University, Toronto, Ontario
Designing and Implementing Databases with MS SQL Server Enterprise Edition
ASP.NET 3.5 web programming with C# 2008
Part-time Studies
…George Brown College, Toronto, Ontario
MS Visual Basic .Net 2005 Programming
MS C# 2005 Programming
Contact this candidate