Business Analyst with IT Skills

Divesh Jaitle

Developer with Analyst Skill, possess strong development skills in Microsoft technologies – VB.NET/C#.Net, ASP.NET, VBA (Excel, Access) and Oracle. Have around 5.8 years of experience in software development and have developed applications and components for web and windows based environment. Good experience in full Software Development Life Cycle from Requirement Analysis, Design, Implementation, QA and Maintenance.

• Developed applications for Finance and Pharmaceutical domains

• Good development experience using ASP.NET, C#.NET / VB.NET with Microsoft Visual Studio .NET 2003/2005/2008

• Expertise in Visual Basic for Application (VBA) in Excel, Access, Outlook & PowerPoint and Visual Studio Tools for Office (VSTO) in Office 2007.

• Experienced using databases such as Oracle 9i/10g and Ms Access.

• Good development experience for .NET Web Applications, .NET Windows Applications

• Flexible and adaptable across multiple development technologies and methodologies

• Experienced in development of Stored Procedures.

• Experience in ADO.NET components such as Data Grids, Data List, Datasets, Data Tables

• Strong communication skills and experience in customer interaction in requirements gathering

• Conversant with additional languages like XML, HTML, JavaScript, VBScript.

• Automated Windows tasks using AutoIt v3.

• Working Knowledge in.NET Framework 3.x with Visual Studio 2008

• Experience in working with testing team to resolve bugs and other issues

• Proficient in learning new technologies and quickly adapting to new environment

• Have excellent communication and analytical skills

Certifications:

• People-Ware Certified ASP.Net Developer.

Qualifications:

• MCA from Sikkim Manipal University, Karnataka, India.

• BS (IT) from Sikkim Manipal University, Karnataka, India.

Technical Proficiency:

Languages : ASP.NET, C#.NET, VB.NET, VBA, JavaScript, VBScript, C++, XML, HTML, AutoIT v3

Concepts : OOPS, Web development, Windows Services, .NET 1.1/2.0/3.x

Operating Systems : Windows 2000/XP/2003 Server

Databases : Oracle 9i/10g, Ms Access

Framework : .NET Framework 1.1/2.0/3.x

Tools : Visual Studio.Net 2003/2005/2008, AJAX, VSS, TOAD, CorVu BI Tool.

Work Experience / Projects:

Employer : ebusinessware Inc.

Client : Prudential Financial (Annuities) – Shelton, CT (Jan 07 – Till Date)

Role : Sr. Developer/ Analyst

Department : Business Intelligence

Responsibilities:

 Meet with Internal clients to identify business needs and gather requirements.

 Provide / Suggest possible solutions for the business need.

 Design, Develop and Implement business solutions.

 Automate various business processes (and tedious tasks).

 Create and Distribute MIS Reports to the management group.

Achievements:

 Automated Cash Log Reports in Excel VBA: brought down 8 work-hours to 15 min process.

 Added functionality of scheduling queries based on Database load status (not time) to CorVu BI Tool using Autoit v3 – ensured Daily Reports are delivered on time to the management group

 Implemented Mail Drafter utility in Lotus Notes in Excel VBA– increased productivity, by reducing human error possibilities.

 Instrumental in Office 2007 migration (MACRO Compatibility).

 Created Office Add-ins in C#.NET (VSTO) for automation of regular day to day task used in our Team.

 Design and Development of Wholesaler Segmentation Dashboard in Ms Access & Excel VBA.

Technology:

 Excel VBA , C#.NET, AutoIT v3, CorVu BI Tool, Oracle 10g, Ms Access

Employer : MarketRx (India) Pvt. Ltd. (Aug-2004 to Jan-2007)

Designation : Software Analyst

Role : Involved in end-to-end process of solution development including: Requirement capturing from internal clients, Product/Application Design, Coding, QA, application Delivery and follow-ups.

Responsibilities:

 Development and Maintenance of Timesheet Application in ASP Classic and VB6 with Oracle 10g.Did a performance tuning on main page using AJAX & XML, which reduced page load time from 1.5 minutes to 6 seconds on Offshore.

 Development and Maintenance of Intranet & Issue Tracking Application in ASP.NET/C#.NET and VB6 with Oracle 10g

 Involved in Software Development Life Cycle of Resource Utilization System; Gathered requirements, Design and Implemented application in ASP.NET/VB.NET with Oracle 9i

 Design, Developed Data Collection and Analysis Tool in Excel VBA. The tool was designed to provide Dashboard Utility to the clients in four countries.

 Designed and Developed Online Library for Marketing Team in ASP.NET/C#.NET with Oracle 10g. Provided Content Searching within the Documents using Windows Index Server.

 I was In-house Trainer for Excel, VBA & MS Access for PS Team.

Technology:

 ASP.NET, C#.NET, VB.NET, ADO.NET, ASP Classic, VB6, Oracle 9i/10g, Excel VBA

Employer : ebusinessware (India) Pvt. Ltd. (May-2003 to Aug-2004)

(Formally Softkee Informatics Pvt. Ltd.)

Designation : Software Analyst

Description : Credit Dimensions is a vertical credit market community providing cutting edge technology for Credit-Risk Professionals. It is a multi-party collaboration between Credit Dimensions and key counter party data, credit data, analytics, and other information providers that will combine the value of hosting multiple vendor applications in a customizable Web Portal environment. The goal is to provide access to all institutional counter party hierarchy data, credit data, credit analytics and news in a unique, customizable, and web based interface.

Responsibilities:

 Data extraction and transformation from Oracle 9i Database for data distribution to the analyst team.

 QA of Data against using Excel VBA validation rules set in the SLA.

 Reporting work progress (Achieved percentage or Expected percentage of work done per analyst).

 Build data collation tool in VB6, which provided feed for the ETL process for Oracle Database.

Technology:

 Excel VBA , VB6, Oracle 9i

Contact this candidate