PROFESSIONAL SUMMARY

• Primary Skills C .Net VB.Net VB 6 SQL Server development using MS SQL 2005/2008 Oracle 10g/11g IBI Webfocus Business Intelligence Report Developer MS Access/Excel 2003/2007 and above. Around nine years of IT experience with seven years in .Net technology.
• Expertise in Requirement gathering and analysis customer facing customer relationships and developing successful applications in timely manner.
• Worked on ASP.Net C .Net VB.Net Application programming using MVC Architecture
• Hands on Experience in writing Complex Stored Procedures Nested Queries Views Triggers and Functions in T - SQL under SQL Server 2005/2008.
• Strong command on OOPs WCF WPF MVC ADO.Net MS Visual Studio 2013 Microsoft Visual Basic front end Environment COM/ DCOM.
• Worked under Waterfall and AGILE project methodologies and Test Driven Development TDD
• Experience in Data Analysis and Data Integration using SQL Server 2005/2008.
• Excellent understanding of the Business Requirements Analysis and Modeling UML writing the Design Documents and Unit Test Documents.
• Good understanding of Database Designing Data modeling Database Backup and Recovery.
• Worked with version control software Clearcase VSS and SVN for source control and Mercury Quality Center.
• Good experience in UNIX shell programming and Linux administrative tasks such as creating Directory structures and controlling access to them creating logins

TECHNICAL SKILLS

Languages C .Net VB.Net VB 6.0 MS Access/Excel VBA C Front End IDE MS Visual Studio 201 3 MS Visual Basic 6.0

Web Technologies ASP.Net XML JavaScript

Web App Server IIS 6.0 IIS 8.5 WCF Web Services AJAX

Data Access Technologies ADO.NET LINQ and EDM.

Backend/Databases SQL Server 2000/2005/2008 MS-Access 2000/2007 ORACLE 11g Web Tools XML HTML 5 DHTML Frameworks .Net Framework 3.0 3.5 4.0 4. 5 Reporting Tools MS SQL Server 2005/2008 SSRS Crystal Reports 9.0 VB Data Report BI Tools Webfocus Tableau Version Control Clearcase VSS 6.0 SVN Suits MS-Office MS Project VISIO

PROFESSIONAL EXPERIENCE

Sr .Net Developer Confidential

• Involved in implementation testing strategy and test case approvals
• Worked closely with technical lead project manager and application SME in project kick offs leading owning and directing application upgrade projects.
• Leading implementation plan walkthrough with all stake holders including business DBAs infrastructure security team
• Recently migrated one click application ToPCAT written in VB.NET from windows 2003 server to windows 2012 R2 server.
• Successfully configured IIS 8.5 on Windows 2012 R2 server updated WCF web services debugged and deployed the updated code
• Involved in updating Windows forms using VB.Net and SQL Server Stored procedures
• Involved in troubleshooting issues on back end including SQL server Sybase and DB2 databases
• Supported CMS/SMS application upgrade from VB 5 to VB 6
• Migrated CMS/SMS application from windows 2003 server to windows 2008 server
• Successfully handled issues related to Citrix server ODBC data connections multiple .NET frameworks
• Wrote batch files .bat to install and un-install .DLL files and .OCX controls to/from registry.
• Responsible for successfully running applications on upgraded servers and enhanced environment.
• Documentin Legendary Remediation Questionnaire LRQ .
• Handled applications in DEV SIT UAT and PROD environments. Involved in UAT testing and bug fixing.
• Facilitating development team from Tata Consulting Solutions TCS and coordinating their resources and infrastructure requirements.
• Coordinating and facilitating various entities involved in project such as code upgrade team windows upgrade team and security upgrade team
• Worked on issues related to code check-in check-out and promoting to higher streams using Clearcase.

Environment C VB.NET MVC WCF Web service ASP.NET AJAX MS SQL Server 2000/2008 SQL Server Reporting Services SSRS VB 6 Clearcase

Confidential

Sr. Programmer Analyst

• Involved in all phases of SDLC including interviewing customers for requirement gathering architecting solution and development and testing.
• Designed and developed ASP.NET application in C to create an online service application to enter bonus and opportunities data. This was very convenient for managers of the company as they could enter the bonus related data from anywhere with no time loss.
• Responsible for designing web applications using ASP.NET server controls using MVC architecture
• Coded the presentation layer using WPF and service layer using WCF technology.
• Used controls from ADO.NET to connect to database retrieve records and display on the webpage in
• Used JavaScript to carry out server side validation for faster web response to user actions.
• Used WCF Web services to communicate with the business layer objects
• Designed and developed ASP.Net in C application for airline data with Google Docs at the backend.
• Report development using Business Intelligence tool IBI Webfocus and SQL Server 2008.
• Designing development and maintenance of file processing application written in Excel 2010 VBA and VB 6 with backend in SQL Server 2005.
• Followed AGILE methodology for timely deliveries and fast development.
• Designed developed tested and maintaining Excel addin. This is a one stop application for many accounting needs. It gives all the information updated daily about current agencies of the company. It has number of inbuilt functions that came handy to accounting department in daily work.
• Designed and developed Windows desktop application to download files from FTP server and process them as per the requirements
• Designed and developed Excel application called Sales Builder for agency Data Reconciliation.
• Wrote several stored procedures created tables and views as a part of development of above applications.
• Designed and developed SSIS packages with data flows control flows and scrip tasks.

Environment C .Net VB.Net VB 6.0 ASP.Net Access/Excel 2010 VBA .Net Framework 3.5 Google Docs API SQL SERVER 2005 Bug Tracking system BugZilla

Confidential Sr .Net Developer

• Debugging Fixing and Deploying code in C .Net VB.Net and VB 6.0
• Designed and developed web forms using ASP.NET and C in MVC architecture.
• Deploying and scheduling Reports using SSRS and Crystal Reports 9 to generate all daily weekly monthly and quarterly Reports including current status.
• MS ACCESS/EXCEL VBA coding per the customer requirements.
• Involved in SQL SERVER database schema changes and writing complex stored procedure and function s using T-SQL on SQL Server 2008.
• Handled daily emerging CRs efficiently.
• Extensively used Stored procedures Triggers Views and Functions while working on SQL Server 2008
• Designed Developed and Deployed Crystal Reports and SQL Server SSRS per the latest customer modifications and new requirements.
• Have followed SDLC with workflow Development Unit Testing Development Testing Production Deployment.
• Designed and developed MS EXCEL VBA code to mass update Royalty related data in production environment. This was a big hit as for years together this time consuming job was done manually and has lot of resource dependency.
• Designed Developed MS ACCESS VBA code to manipulate data in IMS system with certain fixes in the current code per the latest business needs.

Environment C .Net VB.Net VB 6.0 Access/Excel 2007 VBA .Net Framework 4.0 SQL SERVER 2008 SSRS Crystal Reports 9 Bug Tracking system OnTime VSS SVN.

Confidential Sr. Technical Consultant ATSC Consultant

• Performed High level VB.Net C .Net and VB 6.0 Coding and Debugging in modules like Archive Access and Archive Utility.
• Programmed VBA code to check for externally linked files and do corresponding changes in all Plan spreadsheets automatically.
• Coded in JavaScript to write script to find Missing Files from the individual FBA s workstation to match with the central storage and gave a list of Missing Files along with their Network path. This program did very important job with correctness and efficiency saving FBA s time that were doing the same task manually for years.
• Handled Debugging and Resolving Daily issues in ASP.NET VB 6.0 Access/Excel VBA.
• Report building using SSRS and MS Access Reports.
• Worked with VB.Net in Windows application called Runtime for the ACT Archive Suit.
• Converted Excel 2003 Add-ins to be compatible for Excel 2007 format.
• Designed and developed Excel Add-in named VALTOOL in Visual Basic for Applications VBA for module ValTool in 6.1 versions of ACT Archive Application Suit.
• Provided users with Custom Forms in Excel 2007 VBA with components like Radio Buttons Check Boxes and Buttons to enable different functionalities which were part of Plan Spreadsheet manipulations.
• Migrated related client applications from MS Office 2003 to support MS Office 2007 format keeping back word compatibility with 2003 version.

Confidential Sr. Developer

Responsibilities

• Worked directly under IT department s Head Application Development Architect while being responsible for maintaining and supporting daily issues and enhancements in the very crucial system UAS .
• Responsible for Gathering Requirements Designing Implementing and Managing Rapid Application Development of applications like Dashboard Report .
• Experience in C programming to create Dashboard Report which is to merge Report Data from other related reports and show the analysis and Results in a Summary and Detail format using SQL Server SSIS and SSRS
• Interacted with Financial Analysts Tire Engineers and Budget Managers to get inputs to gather data on tire conditions and related research done over last 25 years.
• Done requirement gathering analysis Design and Development of five to six minor projects in C and Excel VBA.
• Designed and developed Excel add-in UAS to generate random variables for volatility Tire Conditions for efficient forecasting and arrive at an accurate value of Tire efficiency along with other Report Related Functionalities.
• Created Charts and displayed years of data in a graphical format for easy analysis of the conditions of Tire and all other sorts of Criteria
• Wrote DBMS views Triggers and multilevel queries in PL/SQL.
• Created Oracle Forms for the Database Front end of the Dashboard Reports
• Created and Run Oracle PL/SQL code in the form of Oracle Jobs.
• Connected to Oracle Database using Dynaset in Excel VBA.
• Created a Macro to send Completed Reports in the form of Email Attachments notifications were sent if there are issues with generating reports.
• Involved in developing ASP.Net pages on the data retrieval website.
• Satisfactorily achieved Daily support and Maintenance activities like checking UAS job list on Database server and Report Program Execution on Report Servers and Raising issues seen before it creates any big problem to the Analysts using the system in different Time zones.
• Support everyday issues and problems with the current system.

Environment C .Net VB 6.0 Excel 2003/2007 VBA VB.Net ASP.Net .Net Framework 3.0 PL/SQL ORACLE 11g Oracle Forms Oracle SQL Developer

Confidential Software Programmer Analyst

Responsibilities

• Reengineered existing applications in VB6.0 and T-SQL Stored Procedures. Used concepts on VB 6.0 Classes and Created DLLs to perform common tasks within related applications.
• Interacted with the Business Users to document the existing application.
• Wrote complex SQL queries views and Triggers in SQL Server 2000/2005 for the backend functionalities on different applications used all over the department.
• Worked with End Users to solve day to day issues and enhancements needed per the new changes in other related functionalities.
• Development of reports using SQL Server Reporting Services includes Database Designing Stored Procedures Triggers and User Defined Functions.
• Defined workflow to support life cycle of presentation unit and supporting production database or application problems.
• Designed Developed and Run SQL Server 2000 DTS packages to load sensitive data from different formats like .CSV .TXT .XLS .XLSX into the SQL Server.
• Interacted with DBAs working on Teradata database Oracle database and Hyperion.
• Re-design existing application and migrate to n-tier .Net based application.
• Design and develop User Interface usingASP.NET.
• Created Ad-hoc Reports with specifications to meet customer needs using MS SQL Server SSRS.
• Run Daily Analysis reports including Sales Reports MaRs reports Monthly Subscriber Count etc.
• Download raw unfiltered account and transferred to the MS SQL Server using DTS packages. This data was analyzed in order to identify trends process improvements and fraudulent activities.
• Improved departmental efficiency by analyzing and identifying inefficient manual processes which were then replaced by SQL Server Reporting tool and Excel applications.
• Use Case and Object Design activities were done with UML and source code was managed with Visual Source Safe VSS .

Environment VB 6.0 ADO MS Access/Excel VBA VB.NET ASP.NET .Net Framework 2.0 MS Visual Studio 2005 SQL Server 2000/2005 SSRS Oracle10g Teradata.

Confidential

Software Developer

Responsibilities

• Involved in developing COM objects using Visual Basic 6.0 in different layers viz. data access and business logic and used them in Windows Scripting objects and ASP pages.
• Worked on application development using Visual Basic 6.0with its Active-X control technology.
• Developed the user interface using ASP and HTML language.
• Used VB Script for client and server validation scripting.
• Customized the Stored Procedures and Database Triggers in T-SQL.
• Creating application schema as tables views and indexes.
• Planned and implemented various SQL queries for forms using T-SQL
• Involved in performance Tuning developed pre-defined and User-defined Exception handling.
• Written Triggers at various levels for cascading functionality cross checking and for referential integrity.
• Used Entity Relationship and Normalization techniques.
• Preparing program Screen Layouts from Functional requirement Specifications.

Environnent VB 6 ASP 2.0 COM HTML IIS 5.0 XML T-SQ L SQL Server 2000/2005.

Confidential

Lecturer/Programmer

• Acted as a Resource Person to train members of Mathematics Colloquium of University of Mumbai in SQL Server 2000.
• Gave undergrad and post grad level coaching to computer science and IT student in diverse subject areas like OS Data Communication UNIX DBMS/RDBMS Computer Graphics and Mobile Computing Programming languages like JAVA C Visual Basic 6.0web development languages like HTML VRML .
• Conducted and Assisted in Programming Practical sessions of C VB6 and T-SQL at the College.
• Worked with a team of developers to conceptualize and design the official website of Mithibai college Mumbai Technologies used are HTML XML ASP and VB Script.
• Orchestrated practical exams in University labs with the help of faculty members.
• Examiner and moderator for Department of Computer Science for more than 500 students in various years.