Post Job Free
Sign in

Sql Server .Net

Location:
Sugar Land, TX
Posted:
June 01, 2017

Contact this candidate

Resume:

Ramesh Jeyagopalan

PROFESSIONAL SUMMARY:

** + years of experience in project management, leading offshore/in-house team, analysis, development, testing and maintenance of detailed software modules, web based applications and Database Applications such as Client/Server Technology, Banking applications using his expertise in VB.Net, ASP.NET, C#, ADO.Net, ASP, PHP, VB, VML, XML, JSP, Servlets, JavaScript, VB Script, Angular JS, Bootstrap, HTML5, DHTML, CSS, MS SQL Server, Oracle, MS Access, MySQL, Cold Fusion, Crystal Reports, SSRS, Dream weaver and Photoshop.

Expert on Database Design, Backup, Restore, Data Integration, DTS (Data Transformation Services) and creating Database objects (tables, indexes, triggers, views, and stored procedures).

Specialization in Creative Web Page Designing using Front End tools like Adobe Photoshop, Dream weaver MX, Flash MX, CSS, HTML, DHTML and JavaScript.

Expertise in application software analysis, architecture, design, development, implementation and quality assurance.

Expert knowledge of Object Oriented Programming and enterprise application development technologies using .NET framework in the areas of performance, security, scalability and extensibility.

Extensive knowledge on .NET Framework Security3

Working knowledge of Web logic, Java, J2EE Architecture, EJB.

Excellent communication and interpersonal skills, fast learner and good teamwork proficiency.

Highly organized with the ability to manage multiple projects and meet deadlines.

Industry experience Oil & Energy, Government, Insurance, and Banking.

Gained strong confidence from clients.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and leadership qualities to lead a Team.

Good Exposure in Migration, Implementation and End user training.

Excel in listening to customer needs, articulating product benefits and creating solutions that provide value to the customer

Build and maintain enduring customer relationships to generate repeat business

TECHNICAL SKILLS:

Operating systems: Windows 7/NT/XP/2000/ 98/95, UNIX

Web Technologies: .Net Framework, ASP.Net, ASP, ADO.Net, VML, XML, XSL, HTML5, DHTML, CSS, Servlets, JSP, J2EE, EJB, and SharePoint

Scripting: Java Script, VB Script, Angular JS, Bootstrap, JASON

Tools: MS Visual Studio.Net 2013, 2010 / 2008 / 2005, Dev Express, MS XNA Game 4.0, MS Visual Interdev, AJAX, Adobe Photoshop, Macromedia Dream weaver MX, Flash MX, UltraDev, Telerik, Infragistics NetAdvantage, Statistica 8, MS CRM, Sharepoint 2007, Lotus Notes, Sharp Shooter, Hadoop and Altova

Languages: C#, VB.Net, VB 6.0, C, C++, PL/SQL, Java and COBOL

Databases: MS SQL Server 2014/2012/2008/2005/2003/2000/7.0,Compact Edition, PostgreSQL, MS Access 2000,

Teradata, ORACLE 7.3/8.0/10g/11g,MySQL WB 5.2

Certification: Certified Hadoop Developer.

PROFESSIONAL EXPERIENCE

DISA Global Solutions Jun 16 - Present

Sr. Solution Architect

DisaWorks: DisaWorks is a Web Application which is being used by external and internal users. It helps to collect and process back ground checking data, alcohol testing data, etc. And test results deliver to all clients periodically.

Responsibilities:

Redesigning the application existing application to UX

Added new REST based API methods using .Net WebAPI and implemented the underlying business logic using the CQRS pattern. Swagger was used to design and document the API methods.

Coordinate with business team, Offshore Team and Internal team for estimating and assigning tasks.

Creating mockup and communicating with Business Team as well as Offshore Team

Working as mentor to follow the standards and deliver tasks on weekly basis.

Implemented error handling and logging of errors in SQL server stored procedures in a standardized manner, thereby helping troubleshooting efforts.

Added unit and integration testing to the existing codebase using xUnit library.

Technologies Used: SQL Server 2014, C#, Visual Studio 2014, Ember.JS, Node.JS, Web API, GIT, ASP.MVC, SSIS, RedGate and ReSharper

DISYS Feb 16 – May 16

ExxonMobil, The Woodlands, TX

Architect / Consultant

Global Physical Access Management (GPAM): GPAM is Web Application. The purpose is to replace Lenel system by adopting GENETC system. Before completely replace, Facility Supervisors will have to configure facility details and clean up unnecessary detail.

Responsibilities:

Gathering the requirements from the Business Team.

Analyzing & Designing the architecture of the application

Developing Models, Views and Controllers using ASP.MVC and AngularJS

Designing Layouts using Bootstrap

Consuming REST API web service to Read and Write Data.

Creating Stored Procedures for CRUD.

Technologies Used: SQL Server 2014, C#, Visual Studio 2013, TFS, ASP.MVC, AngularJS, Bootstrap, REST API, HTML5, SSIS, JavaScript and ReSharper

Baker Hughes Inc., Houston, TX Nov 14 – Dec 15

Architect / Team Lead

EDM Integration with CTX: Designed interface API to communicate both CTX and Landmark Software (Profile). Interface application helps to retrieve data from CTX and store on EDM database. And vice versa.

Responsibilities:

Gather the requirements from the Business Team.

Developing interface application to integrate with EDM database

Efficiently handled Landmark software and tools to do data mapping.

Documented the application structure, plan and requirements

Designed and Developed UI by using Winforms

Used GIT as central repositories

Modified & fixed issues on reports using Sharp Shooter

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2012, SQL Server CE 4.0, C#, ReSharper, SharpShooter, Visual Studio 2013, MS XNA Game 4.0, Dev Express 14.1.5, Citrix, TFS, GIT, Landmark EDM Database, Landmark EDM applications PROFILE, COMPASS, QUICKWELLS

CTX – Completion Architect: CTX is a software application that provides engineers with a suite of collaborative tools for the design, implementation, analysis, maintenance, decommissioning, reporting and data archiving of oil well construction. CTX is also highly collaborative, encouraging users to share projects and lessons learned. All project documents and resources can be stored within a centralized database repository or a local repository.

Responsibilities:

Gather the requirements from the Business Team.

Coordinated with offshore Development and Testing Team.

Developed Parts Catalog module to Separate Parts from existing database.

Documented the application structure, plan and requirements

Coordinating with offshore team for fixing issues and enhancements.

Designed and Developed UI by using Winforms

Used GIT as central repositories

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2012, SQL Server CE 4.0, C#, ReSharper, Visual Studio 2013, MS XNA Game 4.0, Dev Express 14.1.5, Citrix and TFS, GIT, Landmark EDM Database, Landmark EDM applications PROFILE, QUICKWELLS

S & R Professionals. 2013-2014

Software Consultant

Kinder Morgan, Houston, TX

Project-G&A Forecasting System: G&A allows users the ability to enter and modify Forecast data for KMI and KMP General & Administrative (G&A) expenses. It will archive Forecast data on a weekly basis and provide the ability to analyze Forecast balances against Actual, Budget and other Forecast balances, period over period and year over year through reports that present summarized data that may be drilled to more detailed results.

Responsibilities:

Gather the requirements from the Business Team.

Worked with Essbase team to understand application and to get Essbase data to generate Forecast report

Documented the application structure, plan and requirements

Designed the architecture of the application.

Designed and Developed UI by using Winforms

Developed complex stored procedures with dynamic columns for forecasting data by using T-SQL

Developed and modified SSIS packages for Data Transformation to pull values from Lawson database

Developed triggers to update the user details on Inserting, Updating and Deleting records for audit trial

Used TFS as central repositories

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2008 R2, SSIS, SSRS, Oracle 9i, PL-SQL, C#, ADO.Net, Visual Studio 2012, .Net 4.0, Infragistics Controls, JIRA, Citrix and TFS

Project-Sales Tax Report: Sales Tax is windows based application which uses to extract data from Excel to SQL server and provides full facility for users to search records and exports excel files in desire format.

Responsibilities:

Designed and Developed complex SSIS package to extract excel files to store 5 years of Invoice Data.

Designed and developed winforms to filter/search data.

Created SSRS reports to find the Tax Details by using given criteria.

Deployed application on Production, Stating and QA environments

Maintaining, Supporting the application

Involving on End User Training.

Technologies Used: SQL Server 2008, SSIS, SSRS, Crystal Reports, Oracle 9i, C#, ADO.Net, Infragistics Controls, Visual Studio 2012, .Net 4.0, JIRA, Citrix and TFS

Project-CARS (Comprehensive Activity Request System): CARS is windows based budgeting system application. Users would request budget for New and Ongoing project. Once the request is reviewed, it will be approved or rejected. Once request is approved/rejected, data will be moved to Lawson which third party application.

Responsibilities:

Interacted with Business team on gathering information and mockup designs for enhancements.

Designed and developed new winforms.

Fixed issues on existing winforms/stored procedures.

Implemented Roll based security for existing/new screens

Coordinated with Team members to improve application performance on UI.

Deployed the application on QA & Staging environments.

Coordinated with DBA and Project Manager to move the changes to Production.

Involved on end user Training.

Technologies Used: SQL Server 2008, SSIS, SSRS, Crystal Reports, Oracle 9i, PL-SQL, C#, ADO.Net, Infragistics Controls, Visual Studio 2008, JIRA, Citrix and TFS

Triad Resources Inc. 2012-2013

Software Consultant

Spark Energy, Houston, TX

Worked on multiple projects (Customerweb, Atlas, C2C, Focus, KPI, Power Supply)

Project-Customerweb (www.sparkenergy.com): Customerweb is spark energy website where customers can enroll and select their products by entering zip codes. Existing customers can view their usages, billing, payments details. This website pure developed with ASP.Net MVC. Scrum and Agile methodology followed. Entity Framework is used for all data modal.

Responsibilities:

Gather the requirements from the Business Team.

Designed and Developed web forms.

Developed Data Access and Business Access Layer

Developed complex stored procedures by using T-SQL

Modifying Stored Procedure to increase the performance of the application with SQL Server 2008

Developed triggers to update the user details on Inserting, Updating and Deleting records.

Developed common views to call on multiple stored procedures

Efficiently working to improve the application performance.

Used TFS as central repositories

Involved in code review

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2008, C#, VB.Net,ASP.Net, ADO.Net, LINQ, WPF, Visual Studio 2010, .Net 4.0,MS Build, JQuery, Java Script, Infragistics Controls, SandCastle and TFS

CDC Inc. 2008-2013

Software Consultant

Kinder Morgan, Houston, TX

Project-Customer Service Request: CSR is windows based application. It helps Customers/Agents to create service request for using pipelines. Customers/Agent will select pipelines and enter necessary details like contract period, delivery point, receiving point, etc. System will do auto calculate rates for given contract period, delivery and receiving points before submitting their requests. Once request is submitted confirmation message will be sent through email and request will be sent to authorize person to get approval/rejection.

Responsibilities:

Involved on designing architecture of the application.

Working with Business team on gathering information and mockup designs.

Designed and Developed UI by using Win forms.

Developed Data Access and Business Access Layer

Developed complex stored procedures by using T-SQL

Used TFS as central repositories

Implementing projects to various environments including UAT.

Working with users on Improvements of the application.

Technologies Used: SQL Server 2008, PL-SQL, C#, VB.Net, ADO.Net, Visual Studio 2010 & 2008 .Net 4.0, Infragistics Controls, JIRA, Citrix and TFS

Spark Energy, Houston, TX

Project -Atlas: Atlas is an interface application which is developed with Winforms. It pulls data from various databases and generates CSV files which will be input files for other application.

Responsibilities:

Gather the requirements from the Business Team.

Documented the application structure, plan and requirements

Designed the architecture of the application.

Designed and Developed UI by using Winforms

Developed Data Access and Business Access Layer

Developed complex stored procedures by using T-SQL

Developed and modified SSIS packages for Data Transformation.

Developed triggers to update the user details on Inserting, Updating and Deleting records.

Used TFS as central repositories

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2008, PL-SQL, C#, VB.Net, ADO.Net, LINQ, WPF, Visual Studio 2010, .Net 4.0,MS Build, Infragistics Controls, SandCastle and TFS

Project-KPI: KPI is a windows application. It gives the accuracy status of (ERCOT, NIMO, ConEd, etc) i.e. how many transactions had happened, processed transaction and current status of the transaction. UI gives the status in graphical representation.

Responsibilities:

Gather the requirements from the Business Team.

Documented the application structure, plan and requirements

Designed the architecture of the application.

Designed and Developed UI by using Winforms with C#

Developed Data Access and Business Access Layer

Developed complex stored procedures by using T-SQL

Developed SSIS package for data transformation

Involved in code review

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2008, PL-SQL, C#, VB.Net, ADO.Net, LINQ, Visual Studio 2010, .Net 4.0, Infragistics Controls and TFS

Power Supply: Power Supply is a windows application which is developed with Winforms, C#, Visual Studio 2008, Sql Server 2008. This application grabs data from various databases and generates forecast report for various market with calculated values. This is an Excel report which produces graphical representation and summary data by using interop. Business Team will calculate the Hedges by using generated reports

Responsibilities:

Gather requirements from the Business Team.

Documented the application structure, plan and requirements

Designed and Developed UI by using Winforms

Developed Data Access and Business Access Layer

Developed complex stored procedures by using T-SQL

Developed common views to call on multiple stored procedures

Developed SSIS package for data transformation and it is scheduled on daily basis as job.

Used VSS as central repositories

Developed Technical and User Documentation.

Documented Test Plans and Implementing the application

Technologies Used: SQL Server 2008, Oracle 11g, ADO.Net, VB.Net, C#, Visual Studio 2008, MS Access, Excel, Infragistics Controls, .Net 3.5, SSIS and VSS

Project-C2C (Customer to Cash): Modifying existing application by fixing problems and by developing enhancements in an effort to operate with excellence at Spark. To date there are numerous architectural and transactional problems that need to be addressed to accommodate customer growth. This intranet application was developed with ASP.Net MVC. Scrum and Agile methodology followed. Entity Framework is used for all data modal.

Responsibilities:

Gather the requirements from the Business Team.

Documented the application structure, plan and requirements

Developed Data Access and Business Access Layer by using VB.net

Designed and developed the ASP.NET web forms for web-framework system

Designed User Controls by using C#

Developed complex stored procedures to increase the performance of the application with SQL Server 2008

Developed triggers to update the user details on Inserting, Updating and Deleting records.

Developed common views to call on multiple stored procedures

Efficiently working to improve the application performance.

Used VSS, TFS and CVS as central repositories

Involved in code review

Developed Technical and User Documentation.

Documented Test Plans

Implementing the application and giving training for the users.

Technologies Used: SQL Server 2008, C#, VB.Net, ASP.Net, ADO.Net, LINQ, FairPoint, Visual Studio 2008, .Net 3.5, SharePoint 2007, Infragistics Controls, MS CRM, SSRS, SSIS, MS Build, MS Access, JQuery, JavaScript, SandCastle, MS Excel, TFS and CVS

South Western Energy, Houston, TX

Field land is an intranet application. It is an N-tire application. This application uses to store the well details to get the natural gas. Users were using spread sheets and get calls about the wells. This application replaces the paper work and stores the contact details, site complaints and Payment options. By using live link objects the files are being attached for the required wells. All the reports are generated in SSRS.

Responsibilities:

Gather the requirements from the Business Team.

Documented the application structure, plan and requirements

Designed the architecture of the application.

Fix the deadline dates for all the modules.

Co-ordinate with team members and allot the work for all the team members.

Developed Data Access and Business Access Layer

Designed and developed the ASP.NET web forms for web-framework system

Developed many web User Controls advanced search user control, Attachment User Control, Notes User Control and Contacts User Controls

Developed complex stored procedures to increase the performance of the application with SQL Server 2008

Developed triggers to update the user details on Inserting, Updating and Deleting records.

Developed common views to call on multiple stored procedures

Efficiently working to improve the application performance.

Used VSS as central repository

Involved in code review

Developed Technical and User Documentation.

Documented Test Plans

Implementing the application and giving training for the users.

Technologies Used: SQL Server 2008, C#, VB.Net, ADO.Net, AJAX, Visual Studio 2008, .Net 3.0, SharePoint 2007, JQuery, JavaScript, Telerik Controls, Live link Object and VSS.

ExxonMobil, Houston, TX Oct 08 – Jun 09

BEAST is an integrated system consisting of several unique application modules and data sources.

Each of the following modules corresponds to a tab on the web user interface:

Notifications: Automates the assignment and notification of tasks related to loading a new server, reloading a server, retiring a server, adding or removing a disk array. Notifies the right teams at the right time to perform the right tasks.

Tasks: A task list of all notification tasks.

Servers: Automates the collection and reporting of Upstream and Downstream server data from multiple data sources.

Responsibilities:

Designed and Developed Workflow Diagram which will describe the workflow process steps. This diagram will look like the Visio diagram.

Discussing, Planning with the customers before implement the changes

Implemented the Website security based on the User’s privileges.

Designed and developed the ASP.NET web forms and web user controls for web-framework system

Developed complex stored procedures to increase the performance of the application with SQL Server 2005

Involved in Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Used TFS as central repository

Used Sharepoint site for Search, Create and Upload Documents for verification and Team Meetings.

Involved in code review

Involving and testing with the customers after implemented

Designed Technical and User Documentation.

Technologies Used: SQL Server 2005, VB.Net, ADO.Net,ASP.Net, AJAX, Visual Studio 2008, .Net 3.0, C#, VML, MS Enterprise Library, Web Services, Infragistics Vol 3.0, JavaScript, SharePoint, SSRS, TFS (Team Foundation Server)

Penson Financial Services Inc, Dallas, TX Sep 08 – Oct 08

Business Analyst / Team Lead

PFS is a leading independent execution, clearing, settlement and technology firm servicing the global financial services industry. Handling multiple own products which were developed by FileNet and third party tool developed by .Net. Enhancing own product to share the Third part tools DB by using web services.

Responsibilities:

Gathering the functionality from the Business Team.

Once gathered create project specification to get approval from the Business Team

Discussed, Planned with the customers before implement the changes.

Interacted Offshore team on sharing Business and Technical knowledge

Designed and Deployed Sharepoint site to co-ordinate with offshore team and Business Team.

Used Sharepoint site for Search, Create and Upload Documents for verification and Team Meetings.

Coordinating with off shore team to complete the task within deadline date.

Implemented the Website security based on the User’s privileges.

Implementing project on Client’s site

Find tuned the stored procedures to increase the performance of the application with SQL Server 2005

Involved in Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Created the Technical Documentation

Involved in code review

Involving and testing with the customers after implemented

Technologies Used: SQL Server 2005, VB.Net, ADO.Net,ASP.Net, JavaScript AJAX, C#, Visual Studio 2005, FileNet, Web Services, Oracle 10g, SharePoint, SSRS, VSS

ExxonMobil, Houston, Tx January 08 – Aug 08

Sr. Programmer Analyst

The Salary Survey Application is an N-Tier application developed for design the salary for ExxonMobil employees. This application is used to grab market salaries and compare with the ExxonMobil employees. The Advancement Guide Module produces a Curve Design Graph for Exxon Mobil employees. It is developed by Statisca tool and is used to determine the amount of raise an employee receives. The market salary details will be in different format. These files will be loaded in Exxon database in desired format by using extensible mapping schema.

Responsibilities:

Responsible for the analysis, Design & Development of local data management modules by using Top-Down Design programming methodology

Discussing, Planning with the customers before implement the changes

Developed Web Services

Designed and Developed the winforms with Infragistics tools

Designed and Developed User controls for Salary Reference details and Selection Criteria details

Developed complex stored procedures to increase the performance of the application with SQL Server 2005

Generated Graphical Reports with Statistica

Involved in Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Used Visual Sources Safe as central repository

Involved in code review

Involving and testing with the customers after implemented

Created Technical and User Documentation

Technologies Used: SQL Server 2005, VB.Net, C#, ADO.Net, Visual Studio 2005, MS Enterprise Library, Web Services Service Factory, NUnit, Infragistics Vol 3.0, Statistica 8, VSS

Salem Associates Incorporated 2000-2007

Software Consultant

Principal Financial Group, Des Moines, IA

Sr. Programmer Analyst

Backup Admin is an intranet application which allows the user to browse from their Blackberry information from 2000 servers within the Principal Financial Network. Built security measures for administrators to create/set and view user parameters. This application is a 3 tier application

Responsibilities:

Responsible for analysis, Design & Development of local data management modules by using Top-Down Design programming methodology

Implemented .NET Framework Security - Role-Based Security module using Form-Based Authentication and URL Authorization

Used Sharepoint site for Search, Create and Upload Documents for verification and Team Meetings.

Designed and developed the ASP.NET web forms and web user controls for web-framework system

Developed complex stored procedures, triggers and functions with SQL Server 2005

Responsible for Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Used Crystal Report integrated with .NET and generated reports as per modules

Used Visual Sources Safe as central repository

Created Technical and User Documentation

Technologies Used: SQL Server 2005, SQL Reporting Services (SSRS), C#, VB.Net, ADO.Net, ASP.Net, VSS, XML, CSS, Crystal Reports 11.0, JavaScript, NUnit, SharePoint, Oracle 10g, Web Services

Wells Fargo Home Mortgage, Des Moines, IA

Sr. Programmer Analyst

Non Escrow Application is an intranet application which allows the users (Customers/Wells Fargo Employees) to evaluate the loans. This is an N-Tier application.

Responsibilities:

Analysis, Design & Development are done by using Top-Down Design programming methodology

Developed complex stored procedures to increase the performance of the application with SQL Server 2003

Designed and developed the ASP.NET web forms and web user controls for web-framework system

Responsible for Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Generating reports used by Crystal Reports as per modules

Used Clear Case as central repository

Created Technical and User Documentation

Technologies Used: SQL Server 2003, VB.Net, ADO.Net, ASP.Net, JavaScript, C# Clear Case 6.0, XML, Crystal Reports

NBA,

System Architect/ Sr. Programmer Analyst

This project was developed to increase efficiencies within the NBA’s MRS as Sales System. The application helps the sales staff to create, maintain, book, and send sale orders on various media (Print, Internet, TV, and Radio)..

This application is N-Tier

Responsibilities:

Developed new web services

Responsible for analysis, Design & Development of local data management modules

Designed and developed the winforms

Responsible for analysis, design & development of Web Services architecture

Interacted Offshore team on sharing Business and Technical knowledge

Interacted offshore Testing team on QA & UAT environments

Interacted with offshore team to set up QA & Staging environments.

Developed UI Pages using Infragistic NetAdvantage

Developed triggers, functions and complex stored procedures to increase the performance of the application

Responsible for Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Used Crystal Report integrated with .NET and generated reports as per modules

Used Visual Sources Safe as central repository

Created Technical and User Documentation

Technologies Used: SQL Server 2000, C#, VB.Net, ADO.Net, Winforms, Microsoft Visual Studio 2003, XML, Web Services, Crystal Reports 11.0, Infragistic NetAdvantage 2.0

Briggs Corporation, Des Moines,

Sr. Programmer Analyst

Briggs Corporation is a major provider of paper forms in the health care industry. Briggs E-Forms project is a web portal application for Briggs clients.

Responsibilities:

Responsible for analysis, Design & Development of local data management modules

Designed and developed the web-forms with ASP.NET

Developed complex stored procedures to increase the performance of the application

Responsible for Data-driven testing, Integration testing, Stress testing, Load testing and N-Unit Testing

Used Visual Sources Safe as central repository

Created Technical and User Documentation

Technologies Used: SQL Server 2000, VB.Net, ASP.NET, JavaScript, Microsoft Visual Studio 2003, Telerik Control, VSS

Department of Elders Affairs,

Sr. Programmer Analyst

Seamless PC is an N-tier Rich client Application built using .Net Technologies. This project allows the Department of Elder Affairs agents to use personal electronic devices such as Laptop or Tablet to collect the information of elder clients, synchronize and upload it into the Real Database using its online/offline features. In this application data synchronization was done in XML format using its Data Adapter components. This entire application was developed in Visual Studio.net environment and SQL server 2000 was used as database.

Responsible for the development of design artifacts such as class, activity, state, and sequence diagrams.

Implemented Data Access Layer adapter components using ADO.NET techniques Designed and developed the rich user interface using VB.net.

Developed business layer components using C# implemented the form and Application level Security.

Developed-reporting components used for report generation using Crystal Reports.

Developed various rich client interface screens using windows forms, also developed various windows user controls.

Performed debugging and unit testing of the modules in Visual Studio .Net Environment.

Technologies Used: SQL Server 2000, C#, VB.Net, ASP.NET, ADO.Net, Microsoft Visual Studio 2003, XML, Web Services, Diffgram, Tortoise, JavaScript, Active Reports, Crystal Reports 9.0

ANE Technologies, Des Moines,

Sr. Programmer Analyst

This application is built to



Contact this candidate