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.