Sql Server Data
Resume:
Qazi Farhan Ahmed
***************@*****.***
ca.linkedin.com/in/farhanqazi
SUMMARY
I am an experienced software development professional with over 10+ years programming experience. For more than a decade have dedicated my career to the development using C# and VB.Net, web and Windows applications. Hands on experience on Visual Studio (2005, 2008, 2010, 2012), ASP.Net, C#, VB 6, VB.Net, MVC, JavaScript, HTML, CSS, XML, SQL Server (2000, 2005, 2008, 2012), Transact-SQL, LINQ, and among an assortment of frameworks and methodologies, have provided complex designs and scalable applications for a variety of private sector organizations.
Possesses previous senior development and team lead experiences coupled with a mature and professional attitude. With good interpersonal skills and team oriented approach enjoyed a successful career in producing a strong collaborative work environment. Has good experience in documentation of user, functional and technical requirements.
OBJECTIVE
Ready to accept challenges to optimize your business through latest technologies and my 10+ year’s strong programing experience.
Important Technologies used in Companies
Technology
Worked in Company
1
SSRS
(BMO Financials Dec 2015 – June 2016)
(KEOUS Solutions Inc. Dec 2014 – Nov 2015)
2
SSIS
(McKesson Feb 2011 - May2012)
(BMO Financials Dec 2015 - May 2016)
3
SQL Server 2008
(McKesson Feb 2011 - May2012)
(BSE Canada May 2014 – Nov 2014)
(BMO Financials Dec 2015 - May 2016)
4
SQL Server 2010
(Scotia Bank Sep 2013 – Dec 2013)
5
SQL Server 2012
(Scotia Bank Sep 2013 – Dec 2013)
(KEOUS Solutions Inc. Dec 2014 – Nov 2015)
6
SQL Server 2014
(Supra ITS Canada Dec 2013 – May 2014)
7
VBA.Excel
(McKesson Feb 2011 - May2012)
8
SVN
(BSE Canada)
9
JIRA
(Teradata Aug 2012 – July 2013)
10
TFS
(Teradata Canada Aug 2012 – July 2013)
11
SSRS
(BMO Financials Dec 2015 - May 2016)
12
Server Builds
(BMO Financials Dec 2015 - May 2016)
KEY SKILLS AND COMPETENCIES
1.Can quickly understand the relationships between the different parts of a business.
2.Building close relationships with key business stakeholders.
3.Detail-oriented and focused on data accuracy.
4.Experience of using database software such as SQL, MS-SQL, Teradata and MS Access.
5.Putting together a list of practical solutions for BI problems.
6.Advising clients on how to maximise their investment in technology.
7.Microsoft business intelligence suite experience.
8.Able to juggle multiple priorities at the same time.
9.Thinking creatively to come up with new solutions.
10.Experienced in managing local or off shore teams of developers.
11.A Solution Inventor, mostly love to work out of the limits and create new solution for best performance of the application. Got “Invention Disclosure (2005, 2007)”, a Teradata nationwide award for an invention or idea which could bring worth for the business. (Primary inventor of SQL intelligent performance enhancer for main database engine/layer)
a.http://www.patentbuddy.com/Inventor/Patents/Qazi/Farhan/7585777
SKILLS MATRIX
Technology
Years
Technology
Years
Data Design/Implementation
14
Classic ASP
11
C#/VB.Net
5
HTML5 / CSS / DHTML / Ajax
8
ASP.NET
5
MS Enterprise Library (code library)
1
SQL Server
10
JavaScript / VBScript
8
Agile (Scrum) methodology
1+
SSRS, SSIS
3
.Net2.0,3.5,4.0,4.5
4
Teradata / DB2 / Oracle databases
8
Visual Basic 6.0
8
IIS / Web Development
11
MVC 4 / NHibernate 4.0 QueryOver
2
NHibernate - QueryOver
0.8
PROFESSIONAL EXPERIENCE AND ACCOMPLISHMENTS
BMO Dec 2015 – May2016
Software Developer
Working on loan to individuals and commercial credit application management. Maintained and created various reports in SSRS and ETL packages in SSIS. Participating in designing a new application using MVC/AngularJs.
Responsibilities:
Making sure that reports are delivered accurately and on time.
Participating in team planning sessions.
Providing data and analysis in support of the company's initiatives and projects.
Building strong working relationships with cross functional teams.
Looking at industry trends and competitor data.
Optimizing data for scale and performance.
Developing various reports using SSRS and SQL Server 2008 R2.
Performance testing and improving old stored procedures and SQLs.
Working on ETL packages using SSIS SQL BI and transforming data from Oracle to SQL Server.
Building the packages for different severs (IIS, Web and App) for UAT and QAT.
Writing stored procedures and tuning existing SQLs.
Building and deployment web, reports and SSIS packages to test servers (QAT, UAT)
Builds for different versions / TFS branching, merging / database backups restore etc.
Environment:
Visual Studio 2013, C#, SQL Server 2008, R2 T-SQL, TFS, SSIS, SSRS
KEOUS Solutions Inc. http://www.keous.com/ Dec 2014 – Nov 2015
Software Developer
Worked on MVC 4/C# financial application. Developed many SSRS reports using SQL Server 2014. The project is designed for various school boards in Ontario.
Responsibilities:
Coming up with analysis that is cogent and timely.
Managing the timely flow of business intelligence information to senior managers and users.
Using the very latest data mining and data analysis methods.
Developed various reports using SSRS and SQL Server using NHibernate with QueryOver. The front end is in AngularJs with HTML/Web API
The reports designed were for Stock, Purchasing, Payroll, Inventories, G/L, A/R, A/P etc.
Work on SQL server 2008 for T-SQL, databases and view.
Created SSRS reports in Visual Studio 2013.
Worked on NHibernate 4.5, and its API QueryOver, ICriteria to extract data for reports.
Implement code, test and check with team Spain and Florida for updates.
Application setup creation and deployment.
Performance testing and improving old functions.
Used TFS for the source control over cloud.
Environment:
Visual Studio 2013, C#, SQL Server 2012, T-SQL, TFS, NHibernate (ORM)
Building Software Envelop (BSE) Canada May 2014 – Nov 2014
Sr. Software Developer
Migration of VB 6 code to C# (Engineering drawing software for wooden/metal windows and doors)
SSRS development. Gather client requirement and documentation. Was involved in writing, tuning and optimizing T-SQL queries. Developed WinForms application for machine bar-code scanning and modifying/displaying live production data on the big TV/Monitor with auto-size window and fonts using C#. Complete user friendly and works on user settings and profile.
Responsibilities:
Converted VB6 project to C# (16,000 lines), created application using Winforms.
Migration of old reports to SSRS and fixing third party reports to work.
Extracted data from XML using XQuery and XDocument and LINQ to XML.
MS Enterprise Library to build data classes rapidly.
COM Interoperability modules and memory leak problems in recently migrated VB6 to C# application.
Work on SQL server 2008 for T-SQL, databases and view.
Implement code, test and check with team Spain and Florida for updates.
Application setup creation and deployment.
Performance testing and improving old functions.
Create appropriate development documentation, e-g. Installation instructions and SQL scripts.
Writing technical documents e-g. Technical Design documents and user guides etc.
Used SVN subversion for the source control over cloud.
Migrated old SQL 2000 application to SQL 2010.
Environment:
Visual Studio 2013, C#, SQL Server 2008 T-SQL, SVN, XML Spy
Supra ITS Canada Dec 2013 – May 2014
Sr. Developer / Analyst (Permanent)
Developed and maintained various auto survey applications for some major automotive industry using C#, ASP.Net with Webforms 3.5. Participate in the identification and application of the best practices of the UX department. Code review and supervision of the work of junior developers. Involved in designing an application from scratch using C#.Net (VS 2010). Main task to get client requirements, off shore team management etc. Code review and supervision of the work of junior developers. Estimated different task and divide into sub-tasks for all team members. Client was out of budget. Whole team got laid off.
Responsibilities:
Recommending solutions for creating more revenue and reducing costs.
Finding the root cause of a problem and then ensuring that it is resolved through the most appropriate solutions.
Responding quickly to client requirements.
Working with the design, test and product teams to produce solutions.
Providing high level strategic, analytical direction and vision.
Ability to explain complex technical issues in a way that non-technical people may understand.
Researching best practice in data analysis, presentation and management techniques.
Quickly and correctly identifying underlying areas of concern.
Prioritizing tasks in accordance with corporate goals.
Converting data into business intelligence.
Managed a team of developers in India from Toronto. (3:30am EST till 11am EST).
Check every day new and existing tasks statuses and manage among team members.
Check user requirements and specification on daily basis.
Implemented code, test and check with team India for status and review their work and code.
Manage code checked in from Indian team, send inquiries to clients and help to resolve issues.
Team meetings with client and team India.
Proposed architecture and design optimizations.
Test performance of webforms and improved T-SQL.
Wrote backend data provider classes using NHibernate LINQ queries.
Developed several stored procedures for complex SQL queries in SQL Server 2014.
Environment:
Visual Studio 2013, C#, SQL Server 2010,14, T-SQL, Team Foundation Server, AngularJs.
Scotia Bank (for Tech Mahindra) Sep 2013 – Dec 2013
Sr. Programmer / Analyst (Contract)
Work in Business Intelligence Department with their senior business analysts to gather requirements. Created prototypes in C# and tuned the data conversion process. Designing application using VB.Net (VS 2010), SQL Server 2005, wrote unit tests, stored procedures, MVC, C#/ASP.Net, Web forms designs, JavaScript, CSS, VBA Excel programing etc. Completed an HR application using VB.Net and SQL Server for all employees in every department.
Responsibilities:
.Net Development for the bank internal application using VB.Net, C# and SQL Server.
Developed interactive employee tree with complete record and profile of each individual working/not working at Scotiabank.
Maintained and customized fraud history finder for specific individual at branch level using VB.Net.
SQL tuning for HR related issues on production server in some nightly batches used to take 8 hours before tuning, after tuning taking 10-20 minutes.
Worked closely with business analysts in gathering requirements and report designs.
Environment:
Visual Studio 2010, VB.Net, SQL Server 2012, T-SQL, VSS Server
Abacus (for Teradata Canada) Aug 2012 – July 2013
Sr. Software Engineer (Contract)
Worked as Sr. Software Engineer in huge team and agile (SCRUM) environment. Contributed in different activities with different clients to ensure that the project deliverables are delivered on time and in high quality. Main activities were application design, implementation, documentation, analyzing problems, database design, system architecture, writing & tuning SQLs, JavaScript functions, Report writing, writing unit testing etc. Elaborated test plans, continuing integration, and unit and integration tests. Participated in the identification and implementation of the best development practices.
Responsibilities:
Worked in Agile environment with large team in Toronto and small team in China remotely.
Worked with other team members and contractors to help increase their kMay 2016ledge and ability within the organization.
Meeting with BA team for new/change requirements.
Created new web forms, web pages using ASP and created modified or tuned existing data base architecture.
Used SVN subversion for the source control and management for the code project
Implemented new modules and created their unit test procedures.
Worked closely with quality assurance (QA) in removing/fixing application bugs.
VBA Excel sheet programming.
Performance testing and improving old functions.
Research new technologies with prototype and implementing.
Trained new team members, lunch and learns.
Automated backup creation of source control.
Automated server code refresh on different machines from VSS.
Performance monitoring of web pages using WAPT
Performance testing for SQLs on large data using SQL profiler.
Wrote complex SQL queries, stored procedures and views.
Report writing using different reporting tools. (Active, Crystal, customized CVS export)
Implemented AJAX on webpages for asynchronous processing, DHTML, JavaScript and JQuery.
Wrote technical documents e-g. High Level Design Documents, Technical Design documents etc.
Performed peer code reviews and providing feedback on areas that need improvement
Attended the regular technical group meetings and shared information
Tested the individual modules using NUnit system
Environment:
lVisual Studio 2010, VB.Net, JQuery, Teradata SQLs, SVN Server, Reports, JIRA
McKesson Canada Feb 2011 - May2012
Programmer Analyst (Contract)
Worked as a member of software development team working for healthcare organizations. Participate in different phases of the SDLC including: analysis and preparation of design documents pertaining to client requirements, development and testing, attend daily Scrum meetings in an agile methodology of work. Estimated different task and sub-projects before every task started. Completed a risk management application for FDA, USA. A very critical application for collecting patient’s report every day from via digital fax imaging and sent to physicians and hospitals within hours after processing. Successfully completed using 70% T-SQL and 30% C# with 80% improvement in efficiency.
Responsibilities:
Setup and maintain database, data capture forms, business automation, reports for clinical trials, studies.
Develop and maintain tools for reimbursement assistance, market analysis, patient services, pharmaceutical and product distribution programs.
Created new webpages, web forms in C#.
Understood, simplified and implemented business logic in healthcare application.
Created/modified SSIS packages for different clients to send data packets or transform to different reports and other databases.
Preparing daily reports for doctors, patients and hospitals by extracting data using set of stored procedures.
Used TFS for the source control and management for the code project
Weekly meetings with other departments to share data and different reports availability.
Maintained/created web services to gather or send data daily or weekly to other healthcare institutions over USA and Canada.
Data analysis for monthly and daily reports.
Implement new and fixing existing web service problems for sending faxes over internet.
Writing SQL queries, stored procedures, views.
Report writing using Crystal reporting tool.
Implement Ajax, DHTML and JavaScript and JQuery.
Writing Technical Design documents. Create appropriate development documentation.
Migrated an old application from SQL 2005 to SQL 2010.
Environment:
Visual Studio 2008, Visual Studio 2010, ASP.Net, C#, JQuery, BPM, SQL Server 2008, Team Foundation Server, Crystal Reports 2008
Department of Energy, Government of Alberta June 2010 - December 2010
Systems Analyst (Contract)
Worked as a member of software development huge team working for Govt. of Alberta, Energy Department. Participated in development and modification of application written in C# using SQL Server 2008 and was used to collect revenue for Govt. from vendors in energy sector.
Responsibilities:
Maintenance of Windows application using C#.net, VB.Net
Extensively used T-SQL queries, created stored procedures and views using SQL Server 2005
Technical document writing
Writing stored procedures, data classes and UI forms.
Test the application.
Managed SharePoint 2007 List, Documents and sites.
Cosmetic developments in SharePoint 2007 for sites.
Managed existing web services in project.
Environment:
MS Visual Studio 2005, SQL Server 2005, 2008, .Net Framework 3.5, SharePoint 2007
CAA South Central Ontario April 2010 – June 2010
Web Developer (Contract)
Developed many in house projects like Safety Audit for CAA facilities, Garage database development, Performance Management for agents etc. using SQL server and web development tools.
Responsibilities:
Maintenance of ingoing in house web sites.
Collect the requirements of requests.
Setting up the database.
Writing stored procedures, data classes and UI forms.
Test the application and deploy it to the server.
Environment:
MS Visual Studio 2005, MS Visual Studio 2008, C#, VB.Net, SQL Server 2005, SQL Server 2008
Private Projects. Feb 2009 – April 2010
IT Consultant (freelance)
Projects: Contest Management System, Web-based Loyalty Management System. (Content Management
System) etc.
NCR / Teradata
July 2000 – Jan 2009
Senior Programmer / Analyst (6 years) (Permanent)
Main Projects:
Demand Chain Management System (DCM)
Six month client support at LCBO. Resolved bugs, customization, and executed their production process.
Responsibilities:
Meeting with BA team for new modifications.
Converted VB6 dlls into VB.Net dlls. (18,000 lines of code)
Analyze designs technically (GUI/DB).
Implementing code and unit testing,
Bug fixing, creation of Oracle SQLs and database tables.
Support for QA team.
Improving old functions (for performance and new look).
Research new technologies with prototype and implementing.
Trained new team members.
Automated server code refresh on different machines from VSS
Performance monitoring using WAPT
Implement support for disable users using JAWS
Optimized old & slow SQLs for improving performance.
Writing SQL queries, stored procedures, views.
Report writing using different reporting tools. (Active, Crystal)
Web Server setup and maintenance using IIS
Working directly with customers / stakeholders – internal and external
Complete technical design documentation about every module.
Source Code Control (VSS, SVN)
Writing installation scripts using InstallShield Express
Environment:
ASP.Net, VB.Net, C#, HTML, VB 6, ASP classic, DHTML, IIS, JavaScript, Ajax, NUnit, Toad, Oracle SQL, WinForms.
Trained Users: Trained several users in USA Office for our forecasting software (Note: Stirling
Douglas Group Inc. was merged into Teradata/NCR)
ACADEMIC & PROFESSIONAL QUALIFICATIONS
May 2013
Masters in Software
University of Liverpool, UK
Engineering (MIT-SE)
Completed from University of Liverpool, England (Distant Learning
Program)
02/2005
NCR / Teradata
Certification
Java Course
Mississauga, Canada
08/2002
NCR / Teradata
Certification
SQL Specialist
Mississauga, Canada
04/2001
NCR / Teradata
Certification
Terada database
Mississauga, Canada
7/1999
Microsoft
Karachi, Pakistan
Certification
MCSD certification with SQL Server 6.5 and Visual Basic 5.0
3/1993
University of Karachi
Karachi, Pakistan
Bachelor's Degree
Completed in Pakistan before getting immigration to Canada
2/1992
Petroman Institute
Karachi, Pakistan
College Diploma
Petroman a semi Govt. Institute in Pakistan providing 2 years diploma in 4
Computer modules with major Software Engineering and Databases.
Contact this candidate