Business Analyst Project Manager Sql Server .Net
Resume:
CHIRAG GANDHI
******.**@*****.***
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