MOHHAMAD FAREED KHAN

Education Email: Master of Computer Applications (MCA)--2008 Mobile: (717)-674-4523

Certification

Microsoft certified (MCTS) for Developing ASP.NET for c#.net with .NET Framework 3.5

Summary:

·  11+ Years of Experience in Analysis, Design, Development, Integration and Maintenance of N-Tier Enterprise Web and Windows Forms Applications.

·  Good Functional and technical experience in Auditing, Partnership, HealthCare & e-commerce Domain.

·  Strong in the complete Software Development Life Cycle (SDLC) including Requirements gathering, Design, Coding, Testing and Implementation.

·  Experienced in developing Web & Windows applications using .NetFramework, ASP.Net Web Forms, Win Forms, C#, VB.net, XML, HTML, CSS, XML, Telerik, AJAX, JavaScript, JQuery and IIS.

·  Extensive Working Experience in creating dynamic SSIS packages, using containers & variables, configuring the packages, and scheduling the packages.

·  Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) and Crystal Reports.

·  Extensive experience in interaction with customers, client and business/functional analyst for gathering the business requirements and functional specifications and converting them to technical requirements, applying OOAD concepts, Design Patterns and Test Driven Development (TDD).

·  Experience in Creating, Consuming and Publishing WCF and Web Services.

·  Experience in design and development of 3 Tier, N-tier distributed architecture.

·  Experience in using Factory, Abstract Factory and Singleton design pattern.

·  Working experience in Web services & Data feeds.

·  Experience in creating use case diagrams, class diagrams, activity diagrams, sequence diagrams, page flow diagrams using UML technologies.

·  Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server.

·  Expert on developing Stored Procedures, Triggers, Functions and Views in SQL server.

·  Expert in writing T-SQL statements for creating Tables, Indexes, Views and Constraints.

·  Knowledge in WCF, MVC, LINQ, Entity Framework, Web API

·  Good knowledge in the SharePoint, Microsoft Azure, Microsoft PowerShell.

·  Experience in managing the onsite offshore model of development.

·  Experience in the source control software packages like Microsoft Visual Source Safe (VSS), Team foundation Server (TFS) and Tortoise SVN.

·  Experience performing Unit and Integration Testing in the Development, System Integration Testing (SIT), User Acceptance Testing (UAT) including Bug Reporting and Fixing.

·  Ability to work on strenuous team/single projects and meet deadlines.

·  Ability to work on multiple projects at same time.

·  Excellent communication skills, strong organization and interpersonal skills and a very good team player, capable of working independently with minimal supervision and perform as part of a team.

Ernst & Young, Secaucus NJ

Role: Senior .Net Developer Duration: Since Feb 2016

Project: US gT&E Reporting

Responsibilities:

·  Impact cross environmental in-depth analysis of new requirements.

·  Analyzed User requirements, compared between the old and the new requirements, document the results, and communicate gaps and possible issues to the relevant groups.

·  Created Modelling project at Design phase which includes class diagram, activity diagram, etc.

·  Created joins and relationship according to the data model Schema.

·  Created Solution Design Document SDD.

·  Responsible for Development, Integration and Deployment.

·  Developed the front end using ASP.Net, C# & JQuery

·  Created dynamic SSIS packages to load data from different sources & database.

·  Created SSRS Reports and deployment them in Reporting Server.

·  Worked on Performance Tuning of SSIS packages & Jobs.

·  Wrote application level code to interact with the backend databases.

·  Created stored procedures, functions & Views for SSIS & SSRS.

·  Data analysis of different sources for Time & Expense data.

·  Developed batch files to run jobs in Control-M to load the data from EDW into the database.

·  Implemented unit testing of Frontend, Jobs & Reports.

·  Proactive participant in Functional & Technical call & meetings with Business Team, BA & Technical Team.

Environment: .NET Framework 4.5, C#, VS 2015, SSIS, SSRS, SQL Server 2012/2014, IIS 7.0, TFS, Infragistic.

Ernst & Young, Secaucus NJ

Role: Senior .Net Developer Duration: Oct 2015 –June 2017

Project: Finance Reporting Service (FRS)

Responsibilities:

·  In Depth analysis and Impact analysis of new business system.

·  Reviewing and updating design document and use cases.

·  Responsible for Development, Integration and Deployment.

·  Worked extensively on Fiscal year change requirements in Reports.

·  Developed & updated Crystal reports.

·  Worked on Windows Services which create the Excel using Crystal Reports in every 5 secs.

·  Wrote and modified the stored procedures, Views, Functions.

·  Developed N-Tier Architecture which involves UI, Data Access, Business and Database Tiers.

·  Worked on Master Pages, partial pages, and HTML helpers.

·  Developed filters to modify the data and also to clubbed in expression or directives

Environment: .NET Framework 4.0, VB.Net, Server 2012, Crystal Report, Windows Application, SSIS, TFS, VS 2010, SQL Server 2012.

Ernst & Young, Secaucus NJ

Role : Senior .Net Developer Duration: Sep 2014 –Feb2016

Project : gBillers

Responsibilities:

·  Responsible for Development, Integration and Deployment.

·  Worked in ASP.Net using C#, AJAX, JQuery.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation

·  Extensively worked in Crystal reports changes for Report.

·  Prepared functional specifications & design documents.

·  Performed Unit Testing and deployment.

·  Worked on Windows Services to generate Excel, PDF files.

·  Used Service Now for SLA ticket solution.

Environment:.NET Framework 4.0, Win forms, ASP.Net, WCF, C#, VS 2010, TFS, SQL Server 2008, XML, Crystal Reports 8 & 9,

Ernst & Young, Pune India

Role : Senior .Net Developer Duration: June 2013 –Aug2014

Project : Partnership Tax Allocation System (PTAS)

Responsibilities:

·  Responsible for analysis, design, implementation, management

·  Developed Partnership sharing ration module using ASP.Net .0, C#, Entity Framework, JQuery, AJAX, SQL Server.

·  Design Tables Schema, Stored Procedure, Triggers, View & function in SQL Server 2008.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation

·  Interaction with Client on requirement gathering and development demo from Team.

·  Review and modify programs to ensure technical accuracy, security and reliability of applications.

·  Perform code review, bug fix and code migration.

·  Experience in Unit testing, Build and integration testing for the interfaces.

·  Creating the Technical Design Documents.

·  Analyze functional and business needs to implement the same into a functional application.

Environment : .NET Framework 4.0, C#, ASP.Net .0, SQL Server 2008, VS 2010, JavaScript, Infragistics Library & TFS.

Ernst & Young, Pune India

Role: .Senior .Net Developer Duration: Feb 2013 –June2013

Project: Audit Analytic Module (AAM3.7)

Responsibilities:

·  Worked on new Business requirement to develop the module Account Payable.

·  Developed Windows application using .Net Framework 3.5, VS2010, C#, SQL Server.

·  Worked in Integration and Deployment of application.

·  Analyzing, reviewing and updating design document and use cases.

·  Developed complex stored procedures and complex SQL queries using SQL Server 2008.

·  Experience in coding of Business Logic Layer and Data Access Layer using c#.

· 

Environment: .Net Framework 3.5, Windows Forms, C#, VS 2010, SQL Server IIS, TFS.

Ernst & Young, Pune India

Role : Senior .Net Developer Duration: Feb 2012 –Jan2013

Project : Global Core Load (GCL 5.0) Remediation

Responsibilities:

·  Worked in exclusively in remediation of existing Windows application to migrate in newer technologies.

·  Remediated several Audit applications like Workpacks, TASDatabook, ARIS, etc.which are part of GCL5.0.

·  Implemented Custom Error handlers, Custom Exceptions, Custom Error Pages.

·  Worked in Bug fixes and new third party libraries consumption

·  Implemented unit testing for all applications.

·  UsedStyle sheets and Master Pages for achieving uniformity throughout the application

·  Developed Tables, Triggers, Views, stored procedures using the Sql server database

·  Experience in testing and fixing the issues occurred in the testing process

Environment: .Net Framework 3.0, c#, SQL Server 2005/2008, VS 2008, VSS

Idhasoft Ltd

Role : Senior .Net Developer Duration: Mar 2011 –Dec2011

Project : CASAS

Responsibilities:

·  Worked in module development in Business Requirements.

·  Interaction with Client to gather requirements and Change requests.

·  Converted the requirements using analysis in Design & Technical documents.

·  Developed the module in Sitefinity Telerik using Content Management System.

·  Developed web application using ASP.Net 2.5, C#, SQL Server 2005.

·  Design Table, Stored Procedure, Triggers & functions in SQL Server Database.

·  Extensively used JavaScript for client side validations.

·  Experience in Unit testing of modules and bug fixing.

Environment: .Net Framework 2.5, C#.Net, ASP.NET 2.5, SQL Server 2005, VS 2005, ADO.NET, VSS,IIS and Sitefinity.

SRM Techsol, Lucknow, India

Role : Senior .Net Developer Duration: Sep 2010 –Mar 2011

Project : OneNorthPoint

Responsibilities:

·  Responsible for analysis, design, implementation, management

·  Developed Real Estate modules using ASP.Net 2.0, C#, JavaScript, SQL Server.

·  Designed Tables Schema, Stored Procedure, Triggers, View & function in SQL Server 2008.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation

·  Interaction with Client on requirement gathering and development demo from Team.

·  Review and modify programs to ensure technical accuracy, security and reliability of applications.

·  Perform code review, bug fix and code migration.

·  Experience in Unit testing, Build and integration testing for the interfaces.

·  Creating the Technical Design Documents.

·  Analyze functional and business needs to implement the same into a functional application.

Environment : .NET Framework 2.0, C#, ASP.Net 2.0, SQL Server 2005, VS 2008, JavaScript, SVN.

Esoft Technologies LTd, India

Role : Team Lead /Senior .Net Developer Duration: Jan 2010 –Sep 2010

Project : MyLifeAssistant

Responsibilities:

·  Responsible for analysis, design, implementation, management

·  Developed Web & Windows application using ASP.Net .0, C#, JavaScript, SQL Server.

·  Designed Tables Schema, Stored Procedure, Triggers, View & function in SQL Server 2008.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation

·  Interaction with Client on requirement gathering and converted into technical document.

·  Regular schedule for developed module.

·  Review and modify programs to ensure technical accuracy, security and reliability of applications.

·  Perform code review, bug fix and code migration.

·  Experience in Unit testing, Build and integration testing for the interfaces.

·  Creating the Technical Design Documents.

·  Analyze functional and business needs to implement the same into a functional application.

Environment : .NET Framework 2.0, C#, ASP.Net 2.0, SQL Server 2005, VS 2008, JavaScript, VSS.

Esoft Technologies Ltd, India

Role : Senior .Net Developer Duration: Jan 2010 –Sep 2010

Project : Video Downloader

Responsibilities:

·  Responsible for analysis, design, implementation, management.

·  Created Windows based utility for downloading Videos from different sources.

·  Was rewarded for the best product development in the company.

·  Utility to Search videos files from specified websites through keywords.

·  Downloaded the video files (esp. flv files) from video sharing websites like youtube.com, google.com, video.com, dailymotion.com and many more.

·  Designed Tables Schema, Stored Procedure, Triggers, View & function in SQL Server 2008.

·  Interaction with Client on requirement gathering and development demo from Team.

·  Perform code review, bug fix and code migration.

·  Experience in Unit testing, Build and integration testing for the interfaces.

·  Creating the Technical Design Documents.

·  Analyze functional and business needs to implement the same into a functional application.

Environment: .NET Framework 2.0, C#, .Net 2.0, SQL Server 2005, VS 2008, VSS.

Esoft Technologies Ltd, India

Role : .Net Developer Duration: Feb 2008 –Jan 2010

Project : EarthDivas

Responsibilities:

·  Responsible for analysis, design, implementation.

·  Developed various e-commerce modules using ASP.Net 2.0, C#, JavaScript, SQL Server.

·  Designed Tables Schema, Stored Procedure, Triggers, View & function in SQL Server 2008.

·  Have used third party library of PDF generator to create dynamic products catalog.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation.

·  Performed bug fixes and code migration.

·  Performed Unit testing and Integration testing for the interfaces.

·  Creating the Technical Design Documents.

Environment : .NET Framework 2.0, C#, ASP.Net 2.0, SQL Server 2005, VS 2008, JavaScript, 3rd Party Libraries, VSS.

Web Weavers, India

Role : .Net Developer Duration: Sep 2007 –Feb 2008

Project : OnlineMeat Shop

Responsibilities:

·  Responsible for designing and implementation of assigned modules.

·  Developed various e-commerce modules using ASP.Net .0, C#, JavaScript, SQL Server.

·  Created web pages using HTML, CSS & JavaScript.

·  Created Master Pages and User Controls.

·  Created Tables Schema, Stored Procedure, function in SQL Server 2005.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation.

·  Performed code bug fix and code migration.

·  Experience in Unit testing and integration testing for the interfaces.

·  Created the Technical Design Documents.

Environment : .NET Framework 2.0, C#, ASP.Net 2.0, SQL Server 2005, VS 2005, JavaScript, VSS.

Web Weavers, India

Role : .Net Developer Duration: July 2006 –Sep 2007

Project : CDC Lab

Responsibilities:

·  Developed various Health Care modules using .Net 2.0, VB.Net, and SQL Server 2000.

·  Created windows forms with backend connectivity.

·  Designed Tables Schema, Stored Procedure and Functions in SQL Server 2000.

·  Implemented validations using built-in validation controls and used JavaScript for Client side validation

·  Performed code review, bug fix and code migration.

·  Experience in Unit testing, Build and integration testing for the interfaces.

Environment : .NET Framework 2.0, VB.Net, ASP.Net 2.0, SQL Server 2000, VS 2005, HTML, JavaScript.