Post Job Free

Resume

Sign in

Business Analyst Project Manager Sql Server .Net

Location:
Santa Ana, CA
Posted:
December 24, 2013

Contact this candidate

Resume:

CHIRAG GANDHI

acbuei@r.postjobfree.com

714-***-****

PROFESSIONAL SUMMARY

• 7+ years of IT experience in Analysis, Design, Development, Implementation and Testing of

Web Based, Client-Server and N-tier Architectures

• Strong background in web tier and middle tier development with object-oriented

programming experience with ASP.Net / C#, including experience designing &

implementing application architecture

• Experience with B2C & B2B high volume batch systems and high traffic websites

• Strong problem solving skills

• Technical expertise in Microsoft Technologies, such as .NET

Framework(2.0/3.0/3.5/4.0/4.5), ASP.NET, C#, Web Services, WCF, Window Service, IIS,

XML, XSL, XSLT, Visual Studio.Net 2012/2010/2008/2005, AJAX, ADO.Net, MVC

2.0/4.0

• Experience in Web technologies HTML, Java Script, JQuery, JSON, Web API.

• Strong background in data modeling and database design concepts

• Experience in database related work primarily creating complex Stored procedure, Views,

Triggers, Functions, using PL/SQL,T-SQL, Indexes and Performance Tuning in SQL Server

2005,Oracle 10g/RAC/11g

• Experience in utilizing the advance Oracle Queue.

• Experienced with Microsoft Application building blocks for .Net projects (Data Access,

Exception Handling, Reflection, Serialization, User Interface Process, Caching and

Configuration Management Application Blocks)

• Expertise knowledge on Object Oriented Programming (OOPS) Concepts including

Inheritance, Abstraction, Encapsulation and Polymorphism, good experience in Exception

Handling, Debugging and tracing by which the whole picture of application runtime can be

seen and analyzed more efficiently

• Experience in developing and consuming WCF RIA Services, REST, and SOAP

• Exclusively used ASP.NET Web Parts, Master Pages, User Controls, and Custom Controls

to design the Rich User Interactive WebPages

• Experience in ASP.NET (2.0/3.0/3.5/4.0) which allow programmers to build dynamic web

sites, web applications and web services, implemented .NET security features such as

Authentication & Authorization, Windows-based Authentication, and Forms-based

Authentication

• Experienced in utilizing the new integrated features of ASP .NET 3.5/3.0 versions like

Windows Communication Foundation (WCF), Language Integrated Query (LINQ)

• Experience in programming in AJAX using ASP.NET AJAX framework and control toolkit

with client call back features

• Experience in using the ORM model to query the database (Entity Framework)

• Experienced Crystal Reports for report generation, integration into .NET applications

• Experience using configuration Management Tools such as SVN, Visual Source Safe (VSS)

for version control

• Experienced in consuming the third party services

• Experienced in fine tuning the SQL Statement using explain plan, worked on table indexes

to make the query execution fast, Worked on ASP.NET Anthem

• Knowledge of MongoDB NoSQL Database

• Knowledge of Window Azure Cloud Service (Web Role, Worker Role, Table, Blob

Storage)

• Excellent Communications skills, good team player and have good analytical capabilities.

Good organizational skills, ability to handle multiple tasks and work independently as well

as in team

TECHNICAL SKILLS

MS .Net Technologies Microsoft .Net Framework, ASP.Net, C#.Net, ADO.Net,

MVC, Web Forms, Window Service, WCF

Web Technologies Web Services, SOAP, REST, AJAX, XML,XSLT,

HTML,CSS, JavaScript, JQuery, WCF, JSON, Web API

Programming Languages C#.Net, T-SQL

Frameworks MVC 4.0, ASP.Net 4.0/3.5/2.0

RDBMS SQL Server 2005, Oracle 10g / RAC/ 11g

Version Control Visual SourceSafe, SVN

Reporting Tools Crystal Reports

No SQL Database MongoDB

Cloud Platform Window Azure Cloud Service (Web Role, Worker Role,

Table, Blob Storage)

EDUCATION AND CERTIFICATION

• Master of Computer Applications (M.C.A.),Bhavnagar University, Bhavnagar, India (2006)

• Bachelor of Computer Applications (B.C.A.), South Gujarat University, Surat, India (2003)

• MCP Certified

WORK HISTORY

Company Veros Real Estate Solutions, Santa Ana, CA

Title Sr. Software Engineer

Duration January 2010 - Present

Customer Analytics Testing System(CATS), Sapphire,

Project

VRM, VeroSELECT

Customer Analytics Testing System(CATS)

Veros Analytics (VA) has embarked upon implementing the VV-NextGen initiative to regain

our coveted top performer perch. As we make improvements to our models and data, Veros is

inviting lenders/vendors to send us their test files so we can demonstrate to them our

improved product performance. Furthermore, vendors/lenders such as Southwest, AVMetrics,

Chase, etc. send us their test files on an on-going basis.

Customer Analytics Testing System (CATS) is developed to accomplishes this.

Environment: ASP.NET MVC 4.0, C#.NET, WCF services, Web API, Oracle 11g, Telerik,

J-Query, HTML, JavaScript, MongoDB, Entity Framework

Responsibilities:

• Closely worked with business analyst for requirement analysis

• Involved in complete Life Cycle including Analysis, Design, Development and Testing

• Involved in system architect

• Working on log module to log the error using the MongoDB database

• The application developed on the n tier architecture with ORM

• Developed and used WCF and Web API

• Involved in development of various methods of Business Layers

• Intensive use of Telerik Controls

• Created unit test case and other SDLC documents

Sapphire

Sapphire is a web-based enterprise platform for collateral valuation management in the

mortgage industry. The platform is available in a series of packaged editions; each supported

by a range of add-on options providing structured flexibility to manage valuation strategies

from beginning to end.

The core platform includes comprehensive order, review, reporting and administration

functions, which can be enhanced through the addition of powerful modules that enable

clients to select a feature set tailored to their specific business model.

From the UCDP Suite, encompassing PDF Extraction, UAD and UCDP Preview, UCDP

Hard Stop Override and Submission, to the dynamic Appraiser Panel Management and

Vendor Management & Optimization modules, Sapphire covers the gamut of essential

mortgage valuation needs without locking users into modules they don’t need.

The web-based platform provides rules-based ordering, routing, and reviewer queue

management to maximize the efficiency and consistency of internal valuation review teams.

Environment: ASP.NET 4.0, C#.NET, WCF services, Oracle 11g, Telerik, J-Query, HTML,

JavaScript, XML, XSLT, Window Service

Responsibilities:

• Closely worked with business analyst for requirement analysis

• Involved in complete Life Cycle including Analysis, Design, Development and Testing

• Involved in system architect

• The application developed on the 3 tier architecture

• Lead the team of 10 people in offshore

• Created proof of concept for implementing change management.

• Developed and used web services to enable effective communication between SOA

• Worked on window services to communicate with third party vendor

• Created Store Procedures in Oracle 11g Server for various database processes

• Implemented oracle advanced queues for maintaining ordering and servicing queues

• Worked on Oracle scheduled job

• Involved in development of various methods of Business Layers

• Developed own workflow engine in C# and Oracle 11g

• Developed own Rule Engine to process the order

• Developed notification system to send alert and notification

• Intensive use of Telerik Controls

• C# coding by leveraging new features like LINQ query, LAMBDA Expressions and

many more

• Transform XML using XSLT

• Created encryption and decryption code for User Info

• Created unit test case and other SDLC documents

VRM

VRM is web-based enterprise platform which centralizes and streamlines complex work

flows, communications and reports to deliver significant cost reductions, efficiency,

consistency and productivity. The platform's review management capabilities allow users to

automatically route, validate and manage valuations returned to the system to maximize

overall review quality, consistency and staff efficiency.

VRM features comprehensive tracking and audit trails for real-time and scheduled reporting

and provides access to pre-set, ad hoc and scheduled reporting. The ideal solution for

enterprise-level users with a need to fully automate the collateral valuation process and

related procedures, VRM is able to handle individual, portfolio and batch ordering in a

complete end-to-end solution.

VRM provides the most comprehensive review capabilities among its peers in the

marketplace. It can be easily integrated with a variety of supplemental products and systems,

including complex workflows and scoring analytics, and allows users to quickly implement

changes to maximize cost-efficiency, quality and compliance.

Environment: ASP.net 2.0, C#.NET, Oracle RAC/10g/11g, Web Service, XML, XSLT,

HTML, JavaScript, ASP.net AJAX

Responsibilities:

• Worked with business Analyst and Project manager to drive out requirements and

implemented an elegant solution to the task at hand

• Developed database-driven web application using 3-Tier architecture

• Worked on window services to communicate with third party vendor

• Developed and used web services to enable effective communication between SOA

• Monitor and coordinated the integration and testing efforts of multiple vendors

• Worked on XSLT to map the XML

• Developed a console app to load the data from excel spread sheet to the database using

SQL Loader

• Developed module to attached the company specific JavaScript to validate the property

level data

• Created User Control to make application code reusable and to give same look and feel to

the application

• Configured the Form-Authentication features

• Used Ajax Control Tool kit to run client side script, enhance rich web UI, validation and

showing div based Ajax extender

• Used Ajax to access the C# method

• Involved in development of various methods of Business Layers and Data Access Layers

in C#.NET and Oracle

• Implemented oracle advanced queues for maintaining VMA ordering and servicing

queues

• Created Store Procedures in Oracle 11g Server for various database processes

• Worked on Oracle scheduled job

• Fixed all the issues provided by the end users

VeroSELECT

VeroSELECT provides access to a full range of collateral risk solutions, including AVM

products, varying photo and condition reports, and more. An easy-to-implement solution,

VeroSELECT helps users dynamically implement risk and underwriting strategies while

simultaneously allowing an enterprise to monitor workflow, vendor communications and

adherence to internal and external policies.

Designed for use by mortgage industry participants who are ordering, managing or supplying

a variety of collateral valuation products, VeroSELECT allows users to manage multiple

vendors in a centralized system.

Environment: ASP.net 2.0, C#.NET, Oracle 9i/RAC/10g/11g, XML, XSLT, HTML,

JavaScript

Responsibilities:

• Worked on ASP.NET N-Tier based applications

• Extensively used the ASP.NET controls such as Grid View, Detail View and other

controls

• Worked on rule engine to route order to configured vendors based on cascading rule

• Developed class library to consume the web service from web application

• Developed scheduled report component to create and email the report on specified time

• Created database using Oracle that handles complex queries and requests from data

access layer components

• Created complex stored procedure, views, triggers and functions in Oracle

• Fine tuning the SQL Statement using explain plan, worked on table indexes to make the

query execution fast, Worked on ASP.NET Anthem

• Involved in different phases of testing

Company Nexvisionix, Mumbai, India

Title Software Engineer

Duration June 2007 – July 2009

Project Credit Risk Management

Credit Risk Management

Credit risk is the risk of loss due to a debtor's non-payment of a loan or other line of credit.

Reduce Collateral risk for the issuer (can be financial institutions) or investors who pay close

attention on market moves for making a fixed income investment and Measures potential

change in the value of issuer\investors positions due to market moves

Helps in making decision for Setting hedge fund (investment that reduce the risk in another

investment.) credit limits and margin terms (hedge funds are open to accredited investors

who can invest in certain types of higher risk investments, limited partnerships and angel

investor networks).

Close observation of loan (means a person or group) and marks as High surveillance Loan.

Secured by collateral with daily margining.

Environment: ASP.NET 2.0, C#.NET, Oracle 9i//10g, HTML, JavaScript

Responsibilities:

• Involved in the Architecture development team, which delivers multi tire

• Developed database-driven web application using 3-Tier architecture

• Created User Control in ASP.NET to make application code reusable and to give same

look and feel to the application

• Developed ad hoc report module in ASP.NET

• Developed Window Service to load the data from given excel to database using external

table in oracle

• Created Stored Procedures, Functions, Views and Triggers in Oracle

Company Udyog Software India Ltd., Mumbai, India

Title Software Programmer

Duration July 2006 – May 2007

Project Service Tax Package, UdyogRegistration

Service Tax Package

Web based product mainly used for service industry covered all the service tax related entries

and reports i.e. service tax available, service tax payable

Environment: ASP.NET 2.0, C#.NET, SQL Server 2005,Crystal Report, HTML, JavaScript

Responsibilities:

• Migrated legacy application built using Window Form in VB.NET to C# ASP.NET

• Created Stored Procedures, Functions, Views and Triggers in SQL Server

• Created the report using Crystal Report

• Deployed in Staging and Production Environment

• Unit Testing for UI

UdyogRegistration

Udyog registration is basically used to register and get register key of the product developed

by Udyog

Environment: ASP.NET 2.0, C#.NET, SQL Server 2005,Crystal Report, HTML, JavaScript



Contact this candidate