Sql Server Management
Resume:
Devdatta Patil
410-***-**** / ********.*****@*****.***
Profile
Over 13 years of professional experience in IT industries . Extensive background in the full life-cycle
of software development processes including requirements gathering, designing, coding,
testing, debugging, deployment, maintenance and technical support. Proven ability to
successfully analyze, design and implement flexible solutions which supports frequent UI and
functionality changes.
Strengths include:
Web based solution designer and developer.
User interface design.
Application architect
ETL job, Data conversions, database migrations, application performance tuning.
3rd party system integration solution design and development
Database (stored procedures, functions, triggers, cursors and SQL tuning) development.
Extensive experience in application deployment and server configurations.
Offshore team co-ordination.
Technical Skills
Operating Systems : Windows NT/2000/2003/2008, Linux
Languages : ASP.NET, C#, ASP, Visual Basic, MS Access VBA, Excel VBA,
PL/SQL, T- SQL, Java Script, VB Script, HTML, CSS, XML,
DHTML.
Software/GUI : VB, COM+, DCOM, Window Scripting
Databases : Oracle 8/8i/9i/10g, MS-SQL Server7/2008, MySQL, MS-Access
97/2000/2008/2010
Version Control : Visual Source safe 6.0/2005, Subversion.
Tools : Visual Studio, Toad, Oracle SQL*Plus, Oracle SQL*Loader,
Eclipse, SQL Server Management Studio, SQL Server BIDS,
SSRS, SSMA, SoapUI
Middleware : IIS, JBoss 4.0
Education
Bachelor in Computer Science & Engineering, Amravati University
1|Page
Devdatta Patil
410-***-**** / ********.*****@*****.***
Advanced computer training, IBM-ACE
Professional Experience
Employer: Indisoft LLC, Columbia MD
Clients: Navigant Consulting, Washington DC Duration: (Sep 12 – Present)
Project: RxOffice® MortgageRx (Goldman Sachs, Aurora, Morgan Stanley)
Responsibilities:
• Responsible for technical design, programming and source code management.
• Implementing data import processes ( ETL) from the GS library and audit files to
RxOffice® MortgageRx auditing system.
• Performing on site system design and development, modifications and enhancements
using Microsoft Technologies such as ASP.NET, SQL Server T-SQL programming,
SSRS.
• Responsible for analysis and Co-ordination with Infrastructure team for implementing
business solutions.
• Implementing Mantis ticketing system for enhancements, modifications and bug tracking.
• Created and implemented shell scripts for monitoring, 24/7 support and daily health
check of the databases.
Environment: ASP.NET, IIS, Subversion, SQL Server 2008 R2, T-SQL, SSRS, Toad.
Employer: Indisoft LLC, Columbia MD
Clients: Navigant Consulting, Washington DC Duration: (Mar 11 – Present)
Project: Statement of Positions 03-3 (AIG)
Responsibilities:
• Implemented accounting audit system for AIG based on their own specific accounting
guidelines.
• Responsible for technical design, programming, customizations, installations,
maintenance, configurations management, SIT, UAT and production support.
• Implemented data import processes (ETL) from the various AIG systems to Navigant
auditing system.
• Designed and implemented reporting module and various library functions using Excel
VBA, MS Access VBA, SQL server 2008 advanced T-SQL.
• Responsible for implementing various processes to meet SSAE compliance such as
software development lifecycle ( SDLC) steps, Source code management, Mantis
ticketing system for enhancements, modifications and bug tracking.
• Implemented Visual Source Safe 2005 for the source code management.
• Responsible for moving client database from MS Access to MS SQL Server 2008 R2.
• Responsible for analysis and Co-ordination with Infrastructure team for implementing
business solutions.
Environment: IIS, Visual Source Safe 2005, SQL Server 2008 R2, T-SQL, Toad and MS-Access,
Excel VBA, SSMA, Mantis.
Employer: Indisoft LLC
2|Page
Devdatta Patil
410-***-**** / ********.*****@*****.***
Clients: Indisoft LLC Duration: (DEC 10 – MAR 11)
Project: HUD ARM Submission
Responsibilities:
• Responsible for designing solution to make RxOffice® CMS product capable of electronic
submission using web services to HUD's Housing Counseling System (HCS).
• Responsible for technical design, customizations, installations, maintenance,
configurations management, SIT, UAT and production support.
• Responsible for analysis and Co-ordination with Infrastructure team for implementing
business solutions.
• Programmed reporting module using ASP.NET and T-SQL advanced programming using
SQL Server 2008 R2.
Environment: ASP.NET, IIS, SQL Server 2008 R2, T-SQL, Toad, SoapUI.
Employer: Indisoft LLC
Clients: PROMMIS SOLUTIONS, ATLANTA GA Duration: (MAR 09 – NOV 10)
Project: RxOffice® Legal CMS
Responsibilities:
• Responsible for implementing RxOffice Legal web based case management system that
includes customizations, installations, maintenance, configurations management and
MySQL database administration.
• Responsible for technical design, programming, source code management, SIT, UAT, and
production support.
• Data migration from the existing legacy systems to MySQL server database.
• Developed data import processes (ETL jobs) from the Prommis Foreclosure and
Bankruptcy management system to RxOffice legal system.
• Database migration from MySQL server to SQL server 2008.
• Responsible for JBoss application server management and administration.
• Performed on site system design and development, modifications and enhancements
using Microsoft Technologies such as ASP.NET, SQL Server and T-SQL programming.
• Designed and implemented reporting module and various library functions using SQL
server 2008 advanced T-SQL.
• Responsible for implementing various processes to meet SAS70 compliance such as
software development lifecycle (SDLC) steps, Mantis ticketing system for enhancements,
modifications and bug tracking.
• Coordinated with offshore teams.
• Created and implemented shell scripts for monitoring, 24/7 support and daily databases
health check.
Environment: ASP.NET, Java, IIS, JBoss 4.0, Subversion, SQL Server 2008 R2, T-SQL, Toad,
MySQL, 2010, SSMA, Windows 2003, Linux, Mantis, SoapUI.
Employer: LandAmerica, Owings Mills, MD Duration: (Jul 06 – Mar 09)
Clients: Chase, Bank of America, Lehman Brothers, SunTrust, PHH Corporation
Project: BackInTheBlack®
Responsibilities:
3|Page
Devdatta Patil
410-***-**** / ********.*****@*****.***
• Involved in the design and coding of the web based loan servicing product
(BackInTheBlack®) for the mortgage industries.
• Implemented loan tracking, dynamic document generation and reporting modules using
ASP.NET, Visual Basic web-classes, Java Script.
• Implemented data exchange processes ( ETL) for the various client systems using
ASP.NET, Visual Basic, Oracle PL/SQL, SQL Loader.
• Implemented web-services to provide real time updates between BackInTheBlack® and
various clients’ third party systems.
• Perform on site system integration design and development using various technologies.
• Responsible for production support to the client various data exchange processes and
data conversion.
• Designed and programmed various PL/SQL packages as a library functions using Oracle
10g.
• Responsible for build, pre-prod and production releases and source code management.
• Responsible for analysis and Co-ordination with Infrastructure team for implementing
business solutions.
• Coordination with offshore teams.
• Created and implemented shell scripts for monitoring, 24/7 support and daily health
check of the databases.
Environment: ASP.NET, VB6.0, Oracle 9i/10g, PL/SQL, IIS, Visual Source Safe, Java scripts,
VB scripts, Toad, SoapUI and Win 2000/2003
Employer: MSTD Inc. Baltimore MD Duration: (Apr 01 – Jun 06)
Clients: Lehman Brothers, SunTrust, NetBank, PHH Corporation
Project: BackInTheBlack®
Responsibilities:
• Involved in the technical design and programming of the default loan servicing product
(BackInTheBlack®) to automate the various guidelines are being used in the mortgage
industries.
• Implemented data exchange processes (data import/export) between BackInTheBlack®
and various client systems using VB6.0 web classes and Oracle PL/SQL.
• Responsible for design and development of data and summary reports as per the client’s
requirements.
• Involved in technical design and programming for various modules to order credit reports
from the TransUnion and Net Present Value (NPV) reports using Visual Basic web
classes, ASP.NET and PL/SQL packages using Oracle 8i.
• Involved in technical design and programming for the dynamic document generation and
maintenance.
• Responsible for analysis and Co-ordination with Infrastructure team for implementing
business solutions.
• Coordination with offshore teams.
• Created and implemented shell scripts for monitoring, 24/7 support and daily health
check of the databases.
Environment: ASP.NET, VB6.0, Oracle 8/8i/9i/10g, SQL Server, PL/SQL, IIS, Visual Source
Safe, Java scripts, VB scripts, Toad
4|Page
Devdatta Patil
410-***-**** / ********.*****@*****.***
Employer: PRABHA InfoTech PUNE INDIA Duration: (Aug 00 – Dec 00)
Clients: Chopra Auto Parts.
Project: Inventory Control System
Responsibilities:
• Involved in the technical design and programming of the reporting module using Visual
Basic 6.0, SQL Server, MS Access 97 and Seagate Crystal Reports.
• Responsible for design and development of data and summary reports as per the client’s
requirements.
• Responsible for build, deployment and production support.
Environment: Microsoft Visual Basic 6.0, SQL Server 97, MS Access97, Seagate Crystal
Reports.
Employer: SVAR SOFT, PUNE INDIA Duration: (Jul 99 – Jul 00)
Project: Java code generation wizard
Responsibilities:
• Involved in the technical design and programming of the Java code generation wizard
using Visual Basic 6.0, SQL Server, MS Access.
• Responsible for design and development of data and summary reports as per the client’s
requirements.
• Responsible for build, deployment and production support.
Environment: Microsoft Visual Basic 5.0, SQL Server 97, Java
Employer: AMEY Worldwide (I) Group, PUNE INDIA Duration: (Jun 98 – Jul 99)
Project: Canada Immigration Process Automation
Responsibilities:
• Involved in the technical design and programming of the client registration and
management module using Visual Basic 6.0, SQL Server 6.0, Microsoft Access .
• Involved in the technical design, programming of reporting and dynamic forms generation
module using Microsoft Visual Basic 5.0, SQL Server, Microsoft Access and Seagate
Crystal Reports.
• Responsible for design and development of data and summary reports for higher
management.
• Responsible for build, deployment and production support.
Environment: Microsoft Visual Basic 5.0, SQL Server 6.0, Microsoft Access, Seagate
Crystal Reports.
5|Page
Contact this candidate