Sql Server .Net
Resume:
Syed Razvi
https://www.linkedin.com/in/syed-razvi-5305b680/
EXPERIENCE SUMMARY
Team Lead and Senior Web and Application Developer with 20 years of significant experience in Information Technology including 15 years of experience focusing on Web based and CLIENT/SERVER based custom development applications in .NET and Java technologies in Design, Development and Implementation of Internet and Intranet using C#, ASP.NET, VB.NET, ADO.NET, Windows Forms, Web Services, Visual Basic 6.0, ASP, Java, C++ and MS SQL Server.
14 years of experience in Object Oriented Programming with C#, VB.NET, C++ and Java.
12 years of experience with .NET frameworks 1.1/2.0/3.0/3.5/4.0/4.5/4.6.1/4.6.2 Visual Studio .NET 2003/2005/2008/2010/2012/2013.
5 Years Java experience.
5 Years AngularJS 1,x/2.0/4.0 with HTML5 and CSS3
8 years Agile methodologies
10 documentation and Visio presentation.
Expertise in Web Development with HTML, DHTML, VBScript, JavaScript, ASP and ASP.NET, Ajax, JQuery, JSON, XML, XSLT, CSS, MVC4/5, SOAP and RESTful.
Good experience working on ASP to ASP.Net migration projects.
Strong SQL Server skills especially SQL, DDL, DML, Stored Procedure, Triggers, export/ import, Enterprise Manager, SQL Query Analyzer, SQL Profiler, SSIS, SQL Reporting Service and data warehousing.
Exposure to other RDBMS such as Oracle with the ability to write complex queries/ stored procedures/ functions/ triggers/ cursors
Numerous web services written or created SOA using WCF Framework.
Programming experience in all versions of .Net (Web forms using C#, VB.Net and ASP.NET using .Net) including .Net frameworks, AJAX, ASP.Net MVC, XML Technologies, JavaScript, Web Services (SOAP), caching, remoting and application logging.
TECHNICAL SKILLS
Languages
C++, C#, VB.NET, Classic ASP, VB6
Web Technologies
Java Script, Telluric controls, XML, HTML5, Kendo UIs, KnockoutJS, AJAX, JQuery, XHTML and ASP.NET, AngularJS 1.x, 2,4, CSS3
Web Services
SOAP, WSDL, UDDI, RESTful
Frameworks
MS Frameworks 1.1/2.0/3.5/4.0, Struts 1.2, Hibernate and Spring.Net
Database
Oracle 11g /10g/9i, SQL Server 2000/2005/2008 R2
IDE
Visual Studio 2003/2005/2008/2010/2013/2015, NetBeans 7x, Eclipse, NetBeans
Web/Application Servers
Apache Tomcat 5.0/7.0, IIS 6/7. Windows 2003/2010/2016 Servers 32 /64 bits
Other Tools & Methodologies
MS-Office, MS Visio, SQL*Plus, TOAD, Teradata SQL assistance, SVN, Agile, Waterfall, Iterative and Incremental, Factory and MVC3/4
Operating Systems
Windows NT/ 2000/ XP/Windows 7, Window Server 2003/2016 and Windows 10
Reports
SQL Server 2005/2017 Reports and Crystal Reports
EDUCATION
Master of Computer Applications, India, 1997
CERTIFICATION/TRAINING
MCSD, MCP, ASP, Java, HTML - 2002
PROFESSIONAL EXPERIENCE
Date: 8/3/2015 – Present
Client: SCDOR (South Carolina Department of Revenue)
https://dor.sc.gov/
Title: Architect/Lead/Senior .Net Software Engineer
Environment: AngularJS 1.0/2.0/4.0, HTML5, CSS3,VB. VB.NET, C#, SQL server 2008/2014, Entity Framework 6.0, Visual Studio 2010 / 2013, Windows Server 2003/2014, JQuery,Agile, COM, VB, XML, XSLT, Visio 2013, TSQL, SSIS package, SSDT (SQL Server Data Tool), ALTOVA XMLSpy, JavaScript, DCOM and Windows 10.
Responsibilities
Creating WCF Restful services with JSON/AngularJS for Intranet sites of the Government departments.
Creating and updating the pre-existing intranet sites with the help of HTML5, CSS3 and AngularJS for SharePoint 2017.
Used MVVM pattern with AngularJS 2.
By using AngularJS 2.0 fetching the data for ASP.NET from SQL server database and display with the help of ng-repeat of AngularJS.
Using HTML5 and AngularJS for Validation.
Documenting the projects and its architecture and presenting with the help of Visio.
Responsible and part of TFS migration team, working with Infrastructure and DBAs team in order to migrate TFS 2010 to TFS 2017.
Upgrading TFS 2010 from Windows 2008 Server to Windows 2016 server, including SQL server 2016.
Using Agile methodologies, since communicating with several managers and administrators.
Converting pre-existing UI pages using HTML5, DHTML, XHTML, DOM, CSS3, JavaScript, jQuery, Ajax for old and new SharePoint sites.
Upgrading and making changes in Legacy system and making use of COM and DCOM objects and components, in order to fix the broken applications.
Re-written as well the Legacy system but still COM components are used, simultaneously making and changes in pre-existing COM objects with the help of C++ and making use of those in with C# code.
Involved in front-end development utilizing Java Script frameworks such as AngularJS, Node JS and jQuery as well as front end technologies HTML5, CSS3, Ajax.
Developed code to call the web service/APIs to fetch the data and populate on the UI using jQuery/AJAX.
Worked with AngularJS MVC framework including authoring complex directives, services, controllers and filters; working with animations, routing and states.
Involved in complete SDLC - Requirement Analysis, Development, System and Integration Testing.
Pre-existing application are fully loaded with Web Services consumption from third party.
Proposed and got approval from management to go for WEB API application, so that application don’t need to use SOAP.
Created non-SOAP-based HTTP Services on top of existing WCF message pipeline.
Keep modifying pre-existing Schema and XSLTs for multiple requirements, like Epay system for agency, SC1040, federal schema, Sales Tax XML schema.
Debugging and fixing Microsoft CRM, adding, modifying and updating controls and fixing JavaScript code as per requirement.
Pre-existing web module upgraded with new .Net frameworks, Entity framework and MVC5.
Making use of RESTful and SOAP services to communicate with other systems, as AJAX played a role to get data from the server by using GET method.
Working with multiple managers and coordinators because working with multiple modules.
Dealing with sensitive information since client is Government agency and dealing with personal information, like all Individual and business taxes, modified schemas as per requirement.
Converted and updated the Legacy systems, converted from VB6 to .Net, as well as updated the VB6 programs so that it should be able to run on Windows 10 operating system.
Performing ETL and writing, debugging and Fixing .Net C#, VB.NET code with MVC pattern as well as writing Windows Services for multiple projects.
Performed ETL (Extract, Transformed, Load) Used SSDT(SQL Server Data Tool) and Created SSIS Package and deployed on SQL Server 2014 for Vehicle Guide for State of South Carolina, data source are .Txt and Excel files generated by Vendor Penton company and sent it to SCDOR, in order to use the data and apply South Carolina business rules and sent it back to Penton vendor so that they can generate the .pdfs and Vehicle Books or Vehicle Guides and make it available to users across the state, written Stored procedures and created Views in order to apply Department of Revenue South Carolina’s business rules.
Performed ETL (Extract, Transformed, Load) Used SSDT (SQL Server Data Tool) and Created SSIS package and deployed on SQL Server 2014 and generated SQL Server Reports and published on SharePoint 2013 for SchoolIndex project. The main data source Excel and .csv files generated by the users of State department. Need to make use of those files, read it and insert the data into the SQL Server database with the help of SSIS package.
Designed and provided the solution for EDI (electronic Data Interchange) in the form of XML files over http and ftp protocol.
Dealing with sensitive Data related with State and Federal Revenue department.
Dealing with third party and consuming flat files as main Data source and developing interface in C# with framework 4.0.
Due to Legacy system need to deal with different frameworks and consuming, modifying COM objects.
Interacting with five different Business Analysts to provide the Technical solution for new requirement.
Concurrently working with three different requirements and all of them are related with Business Taxes for South Carolina State.
Creating and converting DTS packages to SSIS packages.
Writing and executing stored procedures in SQL Server 2008 \ 2014.
Configuring and hosting internal web sites on II7.0 Server.
Creating and deploying web services.
Generating XML Files for State and Federal Tax Returns.
Created Beer and Wine Applications for Business Tax Returns.
Created and deployed Windows Services with C#
Making use of REST and SOAP web services to deal with third party payment and Credit Card payment methods.
Developed an interface to communicate with Mainframe Database.
Nine Windows services developed in C# and VB.NET communicating with Main Frame Database thru REST and SOAP web services on INTRANET.
Writing SQL Scripts and executing to update SQL Server Database whenever needed.
Date: 07/14 - 06/15 (12 Months)
Company: www.thda.org Nashville, TN
www.gov.tn
Title: .Net Lead
Environment: VB. VB.NET, C#, SQL server 2012, Oracle 10g, TSQL, Entity Framework 6.0, Visual Studio 2012/2013, BizTalk 2010, Windows Server 2003,Agile, JQuery, Telerik Controls including Kendo Grids and Charts, JavaScript, KnockoutJS, AngularJs,Adaptive Server and LINQ
Responsibilities
Managed server side and client side data migration from Sybase to SQL Server with "Sybase OLE DB Provider" and "Sybase ADO.NET Provider".
Debugged VB.NET code and leading three other internal developers.
Created and Modified rig stored procedures in SQL Server 2012 to communicate with Data Services.
Created User Interface in HTML5, CSS3, JavaScript and SQL server to interact with users.
Modifications in Microsoft CRM by fixing JavaScript code.
Involved in complete SDLC - Requirement Analysis, Development, System,
Razor pages updated with AngularJs and communicated with SQL Server 2008/2014.
Modified Datasets whenever and wherever required and publishing back to Data Services.
Managed Hibernate and .Net frameworks to work with different versions of Applications.
Most of the work going on with ASP.NET web technologies.
Created SSIS packages to update SQL Server 2008 database with PeopleSoft data. These SSIS packages run as SQL Job.
Managed VBA application.
Wrote stored procedures and set as SQL Job.
Consumed and modified the Web Methods and contracts written in Java, C# and VB.NET.
Managed and modified the data services along with Web Services written in Java, C# and VB.NET.
Modified and wrote new code for an existing application in C#, VB.NET, JSON and Telerik controls.
Followed MVC pattern for an internal application which includes C#, Telerik control particularly Kendo grid controls with SQL Server 2012.
Debugged CRM for internal users and used BizTalk Server for document transformation.
Utilized TFS for version control and publishing the sites.
Managed and developed both applications written in Windows and Web technologies.
Date: 03/14 - 06/14 (04 Months)
Company: www.att.com Oakton, VA
Title: Senior .Net Developer
Environment: SQL server 2012, Oracle 10g, Entity Framework 6.0, Knockout, Visual Studio 2013, JQuery, Telerik Controls including Kendo Grids and Charts, JavaScript and LINQ
Responsibilities
Worked with new development as well as pre-existing code with MVC pattern.
Created Views, Partial Views in ASP.NET MVC4 application with Razor engine and bind with Kendo UI controls and HTML5.
Made use of Kendo Dropdown and Grid and binding with View Model and communicating with SQL server 2012 database which sitting behind the WCF services or using WCF services to communicate with SQL server Database.
Developed PowerPoint utility to transfer the Google slides data and generate PowerPoint programmatically.
Generate the Telerik or Kendo Charts using Oracle and SQL server Database.
Captured the 15-minute interval data from live database and display in Kendo Grid and generate charts to compare the reading and data.
Created View Model, Models and Controllers.
Created ADO.NET Entity Data Model and updating existing edmx.
Used jQuery and JavaScript as well as C# to manipulate Kendo Grid and business logic.
Created Lambda expressions for writing LINQ query expressions for Controllers and Views.
Date: 12/13 - 03/14 (04 Months)
Company: www.sos.ms.gov Jackson, MS
Title: Senior .Net Developer
Environment: SQL server 2012, Entity Framework 6.0,Agile, Visual Studio 2013, Knockout, JQuery, Telerik Controls, Kendo Grids, JavaScript and LINQ
Responsibilities
Created Views, Partial Views in ASP.NET MVC4 application with Razor engine and bonded with Kendo UI Grid and DropdownList controls.
Used Kendo Dropdown and Grid and binding with View Model and communicating with SQL server 2012 database which sitting behind the WCF services or using WCF services to communicate with SQL server Database.
Created View Model, Models and Controllers.
Created ADO.NET Entity Data Model and updating existing edmx.
Attended daily SCRUM and Sprint meetings.
Used jQuery and JavaScript as well as C# to manipulate Kendo Grid and business logic.
Created Lambda Expressions for writing LINQ query expressions for Controllers and Views.
Used Spring frameworks and invoked RESTFul services.
Date: 12/12 - 11/13 (12 Months)
Company: FedEx, Memphis, TN
Title: Technical Lead-Senior .Net Developer
Environment: Visual Studio 2010/2012, ASP.NET, C#, VB.NET, MVC3/4, Frameworks 1.1/2.0/3.5/4, Entity Framework, Java, VB Script, SQL Server 2005, DB2, BizTalk Server 2010,Agile, Apache Tomcat Server, Adaptive Server, Sybase 12.0, Sybase ADO.NET, MS Access., Oracle 10g, TSQL, SSIS and WSSO
Responsibilities
Communicated with PowerBuilder application and making use of Sybase data.
Responsible for Analysis, design, coding, writing application software, data manipulation, testing and implementation, technical and user documentation. Component and testing of all application code owned by the Packaging Services Department including Maintenance (production support), enhancement and development work since multiple managers have multiple requirements.
Involved in complete SDLC - Requirement Analysis, Development, System and Integration Testing and implementation.
Migrated Number of DTS packages from Java Environment to SQL server 2005 and schedule them.
Migrated Sybase and Oracle 10.x data to SQL Server 2008, used Toad Tools.
Created DLLs with C#, VB.NET and Entity Frameworks.
Upgraded Packaging module with HTML5, CSS3, JQuery and Oracle database.
Used VB.Net and C# to communicate with database SQL Server 2005 and vbScript for DTS.
Maintained .Net code and Database SQL server 2005 on all three servers.
Created Stored Procedures and Functions in SQL server 2005 and as well as in Oracle 10g using TOAD tool and communicated with new and pre-existing .Net code in order to achieve the desired results.
Generated labels using pre-existing COM components later making use of VSTO and highlighted the required fields and amounts in the application.
Solved the compatibility issues since Websites are running under different version of .Net Frameworks. Framework 1.1/2.0/3.5 and 4.0 used.
Created and maintained the SQL Server Reports and Crystal Reports.
Created SSIS packages and scheduled them on SQL server 2005.
Imported Excel sheets as a data into SQL server Database thru .Net applications.
Converted existing ASP.NET module to MVC pattern module.
Created, modified and maintained SQL Jobs on SQL Server 2005.
Used Business intelligence tool for SSIS, SSRS.
Consumed Java written web services communicating with Oracle database.
After going through the pre-existing code, it suggests that there should be a relationship between Iterations and increments development, because modified Waterfall model and agile software development patterns were used and it shows that complete requirements were not gathered in the beginning of the development because of continuous involvement of customers so that requirements were and are keep on changing. The main purpose of this requirement is to quick response to the customers to fix the defects and continuous development on new requirement suggested by customers and users.
Developed Intranet Desktop application with the help of frameworks 2.0 and 4.0
System. Threading and Task classes used to achieve the goal of this module.
Utilized frameworks used for Multithreading purpose for Winform Application.
Published and maintained sites before and after modifications are made.
Created number of SSIS packages and used as an ETL since data sources are Flat files, Excel and Informix.
Created control flows and Extract data from different external data sources including flat files, flow that data through several transformations namely sorting, filtering and merging with other data and converting data types and finally store the result in SQL database and make it available for SQL Server and Crystal reports.
Created staging tables from SSIS.
Added a destination data source to a data flow, connected it to incoming data and selected the destination table.
Created new table also as per required with right columns.
Created Windows Services and Schedule them.
Used Teradata SQL Assistance/Web Edition to communicate with other databases for fetching the records at regular interval, created SSIS packages and schedule them so that required database gets updated on time.
Used OLAP to discover previous or lost relationship with present data item and has been used for generating Excel, Crystal and SQL Reports along with Grid view reports.
Created Views, partial views and controllers to achieve the required results.
Used Kendo UI or Telerik controls and generate reports.
Wrote servlets and created JSP with NetBeans IDE and tested at Apache Tomcat Server 7.0.
Date: 03/11 - 08/12 (18 Months)
Company: FTB Memphis, TN
www.firsthorizon.com
Title: Senior .Net Developer
Environment: Mainframe, Windows server 2003, Sybase 12.0, Agile, SQL server 2008, ASP.NET, C#, VB.NET, Visual Studio 2010, J2EE, JSP, TSQL, Vb6, BizTalk Server 2010, VbScript, ARGO and Soap UI tools
Responsibilities
Migrated required data from Sybase and DB2 to SQL server 2008.
Communicated with multiple departments to develop new applications in VB.NET/C# and fix the issues with pre-existing .net applications.
Consumed web services using XML and SOAP.
Developed UI using ASP.NET, JavaScript, HTML and AJAX.
Wrote and created tables and stored procedures in SQL server database to communicate and accomplished .Net modules.
Involved in complete SDLC - Requirement Analysis, Development, System Integration and implementation,
Wrote and created .NET dlls and functions to generate Xml files to communicate with Main Frame Database and bring the correct result sets.
Developed internal .NET module for Mobile Application so that Authorized users should be able to change the Entitlements.
Entitlements are stored in the Main Frame database but it should be able to change those records along with SQL server database records thru ASP.Net User Interface by generating XML files thru .Net application.
Wrote .NET application to copy Image files from one location to another location but need to get the path from SQL server 2008 database. Join multiple tables and columns to achieve the desirable results.
Managed and published ASP.NET applications on windows 2003 server with 2.0 and 3.5 frameworks along with IIS 6.0.
Created tables for ARGO database to insert the data thru the ARGO procedural language.
Developed from pre-existing Native code to managed code for Mobile Application.
Written the code to call the web services in native code and managed code for mobile application.
Oracle and DB2 database migrated to SQL Server 2008, using Toad tool.
Developed Native code with MFC for mobile application.
For mobile application, Native code was in C++ and managed code in C#. Because of quick result we used C# but both the languages used to create classes, Component Object Model (COM) and interfaces.
Wrote functions and procedures to complete the Teller transactions.
Date: 07/10 - 02/11 (08 Months)
Company: CST, Urbandale - Iowa
Title: .Net Solution Architect
Environment: VBA, VB Script, Visual Studio 2008 MS Access 2003,TSQL, VB.NET, C# and SQL server 2005 and Oracle
Responsibilities
Converted and modified the legacy system from VB6 and classic ASP to .Net technologies.
Led team of four members and all of them were from Java Technologies, worked as mentor for them as well.
Divided the project into logical parts and then several different parts sometime need to communicate. Typical communication is sending some status changes.
Wrote VB.NET and C# code to determine the location of the customer for GIS and try to collect the data and determine where to project the data on screen.
Migrated the whole system from VBA and Classic ASP to .Net Technologies.
Developed Payroll system for client in Classic ASP, AJAX, JQuery, and PHP with SQL server 2005.
Developed Web services in VB.NET and Java 1.2 for UPS (United Postal Services).
Developed TaskSchedular Module in WinForm in VB.NET for Client.
Wrote VB.NET code to communicate with Weblog reporter.
Worked as a Mentor since programmers were not aware with required technologies.
Wrote Web Services in Java and at the same time consumed the web services from other vendors or service providers.
Involved in complete SDLC - Requirement Analysis, Development, System Integration, Testing and implementation.
Utilized GDI and .Net framework 2.0 for GIS.
Used Google Map API V3.0 along with JavaScript and .Net code to integrate in our site.
Developed Pre-existing Customer Service Application in VBA with SQL 2005.
Debugged VBA code and modifications accordingly.
SSIS and DTS were sitting on two different servers and invoking by VBA methods at certain time.
Wrote VB script code to communicate with UPS web services for Shipping Module.
Generated reports for individual employee on monthly basis and showing graph.
Date: 01/09 - 06/10 (18 Months)
Company: EZ financial billing System Jackson MS
Title: Senior .Net (Lead)
Environment: CISCS/COBOL/DB2/and JCL,Visual Studio 2005/2008, WCF, JQuery, SQL server 2005, C#, Java, Oracle 10g, VbScript, Vb.Net,TSQL, JavaScript, SilverLights, DotNet Frameworks 2.0/3.5. Apache and Windows 2003 servers
Responsibilities
Stored procedures and packages written in Oracle 10g and SQL2005.
Communicated with mobile application and developed an application in C# and VB.Net.
BMS maps to ASP.NET / WinForms via XML.
Exec CICS proprocessors.
Managed Runtime services within .Net Framework.
Utilized NetCobol for .Net fully integrated with Visual Studio and Interoperability with other .Net Language.
Create and Generate EXCEL reports along with other office applications, making use of VSTO so that VSTO can uses COM WRAPPER to communicate Office via managed API.
Developed test drive Java Swing and ASP.NET with MVC pattern used for intranet based system to update and edit the comment system with Java, C#, jQuery, Ajax and Nhibernate.
Developed Test-Driven with ASP.Net C#.
Designed and validated GUI end with Unit testing.
Wrote Business logic, design and implemented SQL 2005 database.
Wrote WCF services whenever required and hosted side-by-side with ASP.NET.
Used Struts with JSP.
Logged-in module developed with Struts.
Used controllers, to keep track of what our users are doing while they are logged in by using http Session State and we were attaching files too.
Used action filters as well as file manipulation of Controllers. Input from the browser, the controller takes the appropriate action. Each action interacts with a model and determines which view or other controller to send the response to.
Involved in complete SDLC - Requirement Analysis, Development, System and Integration Testing and implemented services using SOAP and REST.
Used Agile methodology and 20% work done with Mainframe's Cobol and CICS and used third party NeoKicks.
Used action filters as an alternative to HTTP Post by using Authorized attribute to restrict access so only users who are logged in can use it.
Instructed jQuery to make our HTTP POST call to the controller by performing Ajax call.
Used repository pattern that insulates data access code by creating a layer of classes to translate back to application code. By configuring Fluent NHibernate we mapped the database to class.
Connected to the database with Session Factory Session Factory used after map some classes to the database.
Integrated MVC controllers by setting up the NHibernate session and handling the database transaction.
Used N-tier architecture.
Used css heavily for look and feel.
Used Silver light controls to represent data in Data Grid and Grid View.
Developed Web parts for Single sing-on service for Share point portal 2003.
Managed billing transactions and information were taking place across the intranet and TCP/IP protocol used securely WF worked fine with this environment.
Consumed WCF with Winforms along with ADO.NET Data Entity Model.
Wrote WCF services to have Atomic Transaction.
Created and managed database and implementation with WCF and service consumed by Winform Application with C#.
Responsible for programmatically opening and saving document in document Library.
Added contents to existing document libraries and list.
Customized Share Point pages in websites.
Used Agile methodology to make the transition from CICS/COBOL to NetCobol for .Net.
Used SharePoint portal for day to day activities or enable enterprise to develop an intelligent portal that seamlessly connects users, teams and knowledge so that people can take an advantage of relevant information across the entire network.
Date: 08/08 - 01/09 (06 Months)
Company: Gate Gourmet: Memphis, TN
Title: Senior .Net Developer
Environment: VS2005/2008, SQL server 2005, C#, VB.NET, Java, TSQL, Oracle 10g, JavaScript, Vb.Net, VbScript, .Net Frameworks 2.0/3.5
Responsibilities
Involved in complete life cycle of this project.
Stored procedures and packages written in Oracle and SQL server 2005.
Used SQL server and ORACLE 10g databases across the whole Network with Windows 2003 server.
Developed UI in Java Swing as well in ASP.NET with C#.
Developed and modified UI according the client requirement in ASP.NET as well as in Java Swing.
Hosted Java 1.4 module on WebLogic 8.1 server as we were communication with Oracle 10g database.
Used Oracle database connection ODBC and .net framework libraries.
Used JDBC, ODBC and ADO.NET to connect to oracle 10g database.
Wrote LDAP authentication classes and methods to access users from Active Directory in .net Framework 1.1.
Prepared technical documents and then design UI layer, Data Layer and then design and implement database.
Responsible for different types of database connection procedures have been documented and put it on intranet site.
Managed the Native code and managed code.
Coded Java to link to as an unmanaged code but it was very time consuming.
Used shared database for application development.
Debugged and fixed done in Pre-existing Java code.
Communicated with the client in identifying task for the onsite and offshore teams.
Handed the activities between offsite and onsite.
Analyzed problem analysis and resolution.
Validated has been written separately and used it wherever and whenever needed.
Application is used to import flat files and insert into Database. Once file imported then send it to the PDA version PIB5000 that is Barcode scanner and stored it as a flat file database and then upload it back to the Database and from there it had to go back as a flat file to SAP.
All flat files are parsed and then inserted into the database; if data is already present then it should discard it, before doing so it is going prompt the user.
Designed and implemented database with DAL layer to communicate with database.
Created multiple User Controls as per requirement of the project.
Used NUnit testing tool for testing classes and method.
Built Business Logic and Data Access Components.
Responsible for data transfer between the business data and the user controls is carried over by WPF data binding so, the business code never needs to access the application user interface controls and their properties explicitly.
In the application directory created Web.config file and add the configuration code so that WCF infrastructure uses the information to construct an end point for client applications to communicate with.
Date: 10/07 - 09/08 (12 Months)
Company: FedEx World Headquarters, Memphis, TN
Title: Senior .Net Developer
Environment: Visual Studio 2005-2008, Vb6, VbScript, .Net Frameworks 2.0, IIS 6.0, C#, VB.NET, TSQL, SQL server 2000/2005,ASP.Net
Responsibilities
Performed data modeling with SQL Server 2005's Visual Data Modeling tools.
Managed Sybase database has very much in-compatibility with SQL server 2000.
Ran Sybase on SQL anywhere server of windows.
Managed interactive SQL tool of Sybase 10 is used to connect to SQL server.
The main problem with NULL and non-NULL as it is not supporting in Sybase to bit data types.
Faced problem with data types for Identity Column in Sybase is numeric(x,0) whereas in SQL server Tinyint, smallint, int, decimal(x,0) or numeric(x,0).
Wrote stored procedures that used for reconciliation, Letter generation and Auditing Modules.
Main focus on Internal Health System of FedEx which is present in Oracle 9i (PL/SQL) and Sybase.
Wrote Business logic in C# and UI designed in ASP.NET as well in Win form.
Developed VSTO application with C# in order to communicate with office applications.
Designed UI part in ASP.NET 2.0.
Designed and implemented Letter Generator Module on Web as well as on Client
Contact this candidate