SUMMARY

Developer with expertise in Microsoft technologies - VBA, VSTO, VB, C#/VB.Net, ASP.NET, ASP Classic and Oracle. 6+ years of software development which includes applications for the web and windows based environment. Thorough knowledge of the Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Implementation, QA and Maintenance).

• Developed applications for Finance and Pharmaceutical industries.
• Solid development experience in .NET Web Applications, .NET Windows Applications 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.
• Integrated third-party tools with Excel using APIs (IBM Lotus Domino, PDFCreator & Adobe Acrobat Distiller).
• Two Years hands-on experience with additional languages including XML, HTML, JavaScript, VBScript . Working knowledge of AJAX.NET.
• Understanding of AGILE & SCRUM methodologies.
• Experienced using databases such as Oracle 9i/10g and Ms Access.
• Experience in development of PL/SQL in Oracle 10g (Stored Procedures, Triggers).
• Experience in ADO.NET components such as Data Grids, Data List, Datasets, Data Tables.
• Automated Windows tasks using AutoIt v3.
• SourceControlwithVSS.
• Experience in designing UI by implementing CSS.
• Flexible and adaptable across multiple development technologies and methodologies.
• Experience in working with testing team to resolve bugs and other issues.
• Adept at learning new technologies and quickly acclimating in a new environment
• Demonstrated ability to quickly and accurately gather customer requirements, translate them into specifications, and develop code in a Rapid Application Development (RAD) environment

Technical Competence Summary:

Languages:ASP (classic), ASP.NET, C#.NET/VB.NET, VBA, VB 6.0, JavaScript, VBScript, C++, XML, HTML, AutoIT v3

Concepts:OOP, Web Development, Windows Services, .NET 1.1/2.0/3.x, AGILE, SCRUM

Databases:Oracle 9i/10g, Ms Access, SQL Server

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

Tools:Visual Studio.Net 2003/2005/2008, VSS, TOAD.

Employer : Confidential, (Jan 07 - Till Date)

PROJECT

Client : Confidential
Duration : Jun-09 to Current
Department : Risk Treasury (NY)

Responsibilities:

• Interaction with Front-Office (Traders), and understanding requirements.
• Understanding current reports and building a solution which is easy to maintain, scalable and robust.
• Design and develop Excel Tool for Risk & P & L Reports.
• Interpolation of data from several systems, parsing and loading of feed files (csv & excel).
• Data archiving and Generating Report for Risk Change day-over-day (DELTA)
• Also assisted a trader to develop Forecast reports based on Balancesheets.

Technology:

• Office 2003 - Excel VBA (Front-End), Ms Access (Back-End)

PROJECT
Client : Confidential
Duration : Jan-07 to May-09
Role : Sr. Developer/ Analyst
Department : Business Intelligence

Achievements:

• Saved 1 man-year (brought down 8 work-hours to 15 min process) by automating Cash Log Reports in Excel VBA.
• Increased system efficiency by adding DB Load Status based scheduling functionality to CorVu BI Tool using C#.NET Windows Service - ensuring Daily Reports are delivered on time to the management group
• Increased Teams productivity & efficiency by Implementing Mail Drafter utility for IBM Lotus Notes in Excel VBA using IBM Lotus Domino API.
• Instrumental in Office 2007 migration (MACRO/Add-ins Compatibility); code migration from VBA to VSTO (OBA).
• Built Custom Defined Excel Worksheet Functions (BI_ReportDate and Unique Ranking).
• Created Office Add-ins in C#.NET (VSTO) with New Ribbion UI for automation of regular day to day task at our Team.
• Design and Development of Wholesaler Segmentation Dashboard in Ms Access & Excel VBA. Individual Dashboards were made for different levels (Division, Territory and Wholesaler) and was exported as PDFs (using PDFCreator API) for distribution.
• Done complex Excel Reports and Data Analysis using PivotTables & Excel Functions (Vlookups/Hlookups, Slope, Index, Match, etc)
• Cater to Adhoc Report request by fetching & analyzing data from the ORACLE WhareHouse using SQL and CorVu/Toad Tools.

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.

Technology:

• Excel VBA , C#.NET, CorVu BI Tool, Oracle 10g, Ms Access

Employer : Confidential, (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/ Achievements:

• Development and Maintenance of Timesheet Application in ASP Classic (Presentation and Data Access Layer) and VB6 (Business Logic Layer)with Oracle 10g. Did a performance tuning on main page using AJAX & XML (used JavaScript, XPath Query), 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 (WebForms) with Oracle 10g
• Synced separate Timesheet applications database using Triggers in Oracle PL/SQL.
• 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 (WebForms) with Oracle 10g. Provided Content Searching within the Documents using Windows Index Server.
• Optimised Web Application performance by moving BLL from ASP.NET to Oracle's Stored Procedures(PL/SQL).
• 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, MS Access

Employer : Confidential, (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/ Achievements:

• 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).
• Worked on In-House Java Tool for data validation and collaboration hosted on Citrix Application Server.
• Build data collation tool in VB6 (WinForms), which provided feed for the ETL process for Oracle Database.
• Loaded final data into Database using Oracle SQL Loader.

Technology:

• Excel VBA , VB6, Oracle 9i

Qualifications:

• MCA
• BS (IT)

Certifications:

• People-Ware Certified ASP.Net Developer.