Post Job Free

Resume

Sign in

Sql Server Manager .Net Developer Business Management

Location:
Houston, TX, 77019
Posted:
September 10, 2010

Contact this candidate

Resume:

Jatin Verma

Houston, TX ablakj@r.postjobfree.com,Ph: 281-***-****

Summary:

1. Over 7+ years of experience in total Software application development

life cycle involving gathering Requirements, Analysis, Specification,

Design, Development, Integration, Data Conversions, Installations,

Maintenance and Reporting.

2. Worked for Fortune 100 Companies like GE.

3. Experience in Finance, Real Estate, Insurance, and Healthcare.

4. Experience with web applications using VB.NET, C#, ADO.NET, ASP.NET,

IIS 6.0, HTML, XHTML, XML, XSLT, CSS, Java Script, AJAX, WCF/WPF.

5. Experience in Web Services and Crystal reports.

6. Excellent experience in developing both Web Forms & Win Forms

applications using Visual Studio.NET, ASP.NET, ADO.NET, C# & VB.NET

technologies.

. Strong understanding and experience of object oriented concepts, .Net

framework.

. Configuring the Asp.net application in IIS server 6.0

7. Sound knowledge of RDBMS concepts and experience in ER Diagrams,

Views, Stored Procedures, Functions and Triggers, Indexes, Temporary

Tables, SQL, T-SQL and PL/SQL using SQL Server 2000/2005/2008.

8. Excellent Experience in creating DTS and SSIS packages.

9. Experience in MySQL.

10. Experience in SharePoint 2007,Visual Source Safe.

11. Experience in MS Office 2010

12. Exposure to Data Warehousing Fundamentals, Data Modeling.

13. Exposure to Business Objects XiR2 - Designer

14. Exposure to Visual Basic 6.0

15. Worked on SQL Migration from 2000 to 2008

16. Experience in Data Conversion.

17. Expertise in SQL, PL/SQL.

18. Experienced in project planning, analysis, design, implementation and

versatile team player with good Communication and writing skills. Good

at prioritizing the tasks and commitment to complete them.

19. Excellent communication and strong interpersonal skills with ability

to interact with end-users, managers and technical personnel.

20. Worked on OLTP (Online Transaction Processing) applications.

21. Proficiency in Batch Files and FTP processes.

Professional Certifications, Trainings & Conferences:

. Microsoft Certified Solution Developer for .NET (MCAD)

. Microsoft SQL Server 2008 - Database Development.

. Six Sigma Green Belt certified.

Technical Skills:

Programming Languages C#. Net, VB.net, VB, ADO.NET, CLR, CLS, CTS,.NET

& Technologies Framework,Interop COM, Web Services, ActiveX,

PL/SQL, SQL

Protocols HTTP, SMTP

Databases MySQL,SQL Server 2000,SQL Server 2008,DTS

Packages, SSIS, SSRS

Operating Systems Windows 2003/xp/2000/NT/98/95

Software/IDE Visual Studio 6, Visual Studio. Net 2003

Web Technologies ASP.NET, JavaScript, HTML, XHTML, Xml, WCF/WPF,

MOSS, Silverlight, VSS

Web Servers IIS 6.0

Class Libraries . Net Base Class Libraries (FCL) & Microsoft

Foundation Classes (MFC), Application Blocks

(Enterprise Library Configuration)

Unit Testing Nunit

Reporting Tools Crystal Reports v7.0/8.0

Designing Ms Visio.

Professional Experience:

Client GE Commercial Finance, Houston, TX

Project Title GFAST

Duration March 09 - till date

Role Sr. Developer

Tools MS Visual Studio 2005 - VB.NET, C#. NET, ADO.NET, ASP.NET, XML, HTML,

XHTML, CSS, IIS, Web Services, Javascript, Sharepoint,

Silverlight, WCF/WPF

MS .NET Framework

SQL server 2008 - SQL Queries, Stored Procedures,

Functions, Views, SSIS, SSRS.

Description

Gemsa Financial and surveillance tracking system called, as GFAST is a

financial tracking tool. This tool helps the users to key in the financial

information sent by the borrowers and process the same.

GFAST was developed VB.NET as front end and SQL server 2000 as database.

GFAST also requires basic and fundamental data from AS400 system. Data is

extracted from AS400 System using Informatica and is further utilized by

GFAST application.

Responsibilities

. Interacting with Business Users and Business Analysts to gather

requirements.

. Website Development and Tools Development for Business Users using Web

Development Tools MS Visual Studio 2005 (VB.NET, C#. NET, ADO.NET).

. Web Page Designing using HTML.

. Deploying website on IIS Server.

. CSS for User Interface Uniformity through out Application.

. Implemented Template columns for Custom Nested Grid views.

. Used HTML, Javascript, WCF, WPF and AJAX through out Application.

. Used Enhanced Web technologies Like Silverlight while Website

Creation. Used Advanced Features of silverlight to add animation,

Video's in website.

. Implemented Features of .NET such as Repeaters, Calendar Controls,

Validation Controls, Security using Window's Authentication.

. Used SharePoint for File resource Management.

. Designing and creating database using SQL server Management Studio of

SQL server 2008

. Creating and modifying the stored procedures using SQL server

Management Studio of SQL server 2008.Creating SSIS packages and

creating reports using SSRS for client.

. Creating and scheduling the jobs using SQL server Management Studio of

SQL server 2008

. Creating Batch files and FTP processes using DOS.

. Performance tuning at Database Level.

. Preparing design documents and test specifications

. Managing, coordinating, planning and executing project.

. Reporting status to the client.

Client GE Commercial Finance, Houston, TX

Project Title GEMSA - IFAST

Duration Jan 07 - March 09

Role Team Lead/Developer for .NET And SQL Server 2000 2008

Tools MS Visual Studio 2005 - VB.NET, C#. NET, ADO.NET, ASP.NET, XML,

XHTML, CSS, IIS, Web Services, Sharepoint, Silverlight,

WCF, WPF

MS .NET Framework 3.0

MySQL

SQL Server 2000/2008- Enterprise manager, Query Analyzer,

SQL Queries, Stored Procedures, Functions, Views, DTS,

SSIS, SSRS,

Description

GEMSA Loan Services, joint venture of GE and CBRE is one of the largest

service providers of commercial mortgages. GEMSA has achieved the highest

primary service ratings from both Fitch and S&P.

GEMSA has data extraction process from legacy systems using Informatica,

SQL DTS Packages. The data is extracted, organized and integrated through

Informatica and is further used for Reporting, Building Dashboards to

predict variances and also help in decision-making and Performance

Management to analyze the performance of operations.

GEMSA loan services developed application for Insurance department. To make

sure that Insurance limits are compliance with Loan agreements, Users are

required to run adhoc reports, and receive exception reports. Data

extraction process is designed and executed through Informatica. Business

objects is used for creating and publishing the reports

Responsibilities

. Interacting with Business Users and Business Analysts to gather

requirements.

. Lead the Technical Team during Development phases.

. Website Development and Tools Development for Business Users using Web

Development Tools MS Visual Studio 2005 (VB.NET, C#. NET, ADO.NET,

ASP.NET).

. Web Page Designing using HTML.

. Deploying website on IIS Server.

. CSS for User Interface Uniformity through out Application.

. Implemented Template columns for Custom Nested Grid views.

. Used HTML, Javascript, WCF, WPF and AJAX through out Application.

. Worked on Web User Control Pages.

. Implemented Features of .NET such as Repeaters, Calendar Controls,

Validation Controls, Security using Window's Authentication.

. Used Enhanced Web technologies Like Silverlight while Website

Creation. Used Advanced Features of silverlight to add animation,

Video's in website.

. Developing MENU and TABS using DHTML Menu and DHTML Tabs.

. Letters generation Process through .NET Mail Merge.

. Used SharePoint for File resource Management.

. Use MySQL Queries to retrieve data in Application.

. Designing and creating database using SQL server Enterprise Manager of

SQL server 2000

. Creating and modifying the stored procedures using SQL server

Enterprise Manager of SQL server 2000

. Creating and scheduling the jobs using SQL server Enterprise Manager

of SQL server 2000.

. Performance tuning at Database Level.

. Preparing design documents and test specifications

. Managing, coordinating, planning and executing project.

. Reporting status to the client.

. Building SQL queries in Query Analyzer.

Client Arxime GmbH - USA

Project Title Cosmetic Studio

Duration Feb 06- Dec 06

Role Developer

Tools MS Visual Studio 2005 - VB.NET, C#. NET, ADO.NET, ASP.NET

MySQL Bugzilla

SQL Server 2000 - Enterprise manager, Query Analyzer, DTS

Packages

Description: Cosmetic studio is windows based health care Product. It is a

turnkey solution to manage the daily business. It includes contact

management, product and inventory management and sales management modules.

Responsibilities:

. Developed the User Security Manager Component which is for

authenticate and authorization of logged in user to access the

resource.

. Developed the Contact management module using C#. Net.

. Use MySQL Queries to retrieve data in Application.

. Implemented the business logic using C#. Net and Sql Server 2000.

. Created the screens for the maintain patients details.

. Created the screens for the disease, doctor who is giving the

treatment information, the duration of the treatment the detail

information, about earlier treatment taken by the patient and the

status of that treatment etc.

Client GE Real Estate, Dallas

Project Title ATLAS

Duration Jan 05- Jan 06

Role Developer

Tools MS Visual Studio 2005 - VB, VB.NET, C#. NET, ADO.NET, ASP.NET

MySQL Bugzilla

SQL Server 2000 - Enterprise manager, Query Analyzer, DTS Packages

Description

GE Real Estate has developed application ATLAS for Insurance department. To

make sure that Insurance limits are compliance with Loan agreements, Users

are required to run adhoc reports, and receive exception reports. Data

extraction process is designed and executed through Informatica. Business

objects is used for creating and publishing the reports

Responsibilities

. Interacting with Business Users and Business Analysts to gather

requirements.

. Website Development and Tools Development for Business Users using Web

Development Tools MS Visual Studio 2005 (VB.NET, C#. NET,ADO.NET).

. Deploying website on IIS Server.

. CSS for User Interface Uniformity through out Application.

. Implemented Template columns for Custom Nested Grid views.

. Used HTML, Javascript and AJAX through out Application.

. Worked on Web User Control Pages.

. Developing MENU and TABS using DHTML Menu and DHTML Tabs.

. Implemented Features of .NET such as Repeaters, Calendar Controls,

Validation Controls, Security using Window's Authentication.

. Migration from VB to VB.NET.

. Use MySQL Queries to retrieve data in Application.

. Designing and creating database using SQL server Enterprise Manager of

SQL server 2000

. Creating and modifying the stored procedures using SQL server

Enterprise Manager of SQL server 2000

. Creating and scheduling the jobs using SQL server Enterprise Manager

of SQL server 2000. Building SQL queries in Query Analyzer.

. Preparing design documents and test specifications

. Managing, coordinating, planning and executing project.

. Reporting status to the client.

Client Techdata, Clearwater, FL

Duration July 03 - Dec 04

Role Developer

Tools MS Visual Studio 2005 - VB.NET, C#. NET, ADO.NET, ASP.NET

MS .NET Framework 3.0

SQL Server 2000 - Enterprise manager, Query Analyzer, DTS

Packages

Nunit - Unit Testing

Description

Tech Data is a leading global provider of IT products, logistics management

and other value-added services. Ranked 110th on the FORTUNE 500 in the year

2005, the company and its subsidiaries serve more than 90,000 technology

resellers in the United States, Canada, the Caribbean, Latin America,

Europe and the Middle East. Tech Data's extensive service offering includes

pre- and post-sale training and technical support, financing options and

configuration services as well as a full range of electronic commerce

solutions.

With growing needs of business requirements and to meet the recent

technology changes, TechData is in process of releasing new version of

application (i.e. from Intouch 7 to InTouch 8i). This application mainly

designed for the resellers who will buy products from techdata. They can

search products, Add to basket and order for the products. They can see the

latest price of the product through online check which used one web service

to check the price from SAP.

In parallel to this, TechData will continue to add new features in existing

version for business requirements.

Responsibilities:

. Involved in full software lifecycle including analysis, design,

development, and implementation.

. Design and Development of Web Pages with Asp.net in VB. Net.

. Database connectivity using ADO.NET Used Microsoft Application Blocks

for data access.

. Creation and design of Tables, creating Stored Procedures.

. Worked on user controls using VB.NET.

. Development of Business Entities.

. Integration of Existing Web Services to exchange the data in Xml

format.

. Configured Cruise Control for daily builds from VSS along with

automated unit testing

. Developed Unit Test Cases Using NUnit.

. Implemented Web Services in the application.

. Designing and creating database using SQL server Enterprise Manager of

SQL server 2000

. Creating and modifying the stored procedures using SQL server

Enterprise Manager of SQL server 2000

. Creating and scheduling the jobs using SQL server Enterprise Manager

of SQL server 2000. Building SQL queries in Query Analyzer.



Contact this candidate