CAREER SUMMARY:

• IT specialist with 12+ years of professional experience in desktop and web - based applications.
• Experience in IT production support for web systems and project monitoring using SolarWinds.
• Extensive knowledge of Client/Server and Web based applications using Visual Basic 6.0, ASP, VB.Net and ASP.Net.
• Expertise in SQL Server Development including writing Stored Procedures, User-Defined Functions, Triggers and proficiency in Joins and Indexes.
• Experience in writing complex SQL queries involving multiple table, inner and outer joins, temporary tables, table variables.
• Hands-on experience in debugging stored procedures to optimize performance.
• Used VB.Net, ASP.Net for GUI design and business logic implementation.
• Worked in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience in agile and waterfall methodologies. Also in driving and maintaining the scrums/ sprints.
• Good exposure of working on development and maintenance projects for large/small domestic & international clients and played a pivotal role in each of those projects.
• Proved leadership and motivational skills by leading a web based supply chain management project.

SKILL SET:

TECHNICAL:

Languages: Visual Basic6.0, with MTS/COM/COM+, ActiveX controls, ADO, ASP.Net with C# and vb, VB.net, HTML, ASP, LINQ, VBA Python.

Database: Oracle 8i/9i RDBMS, SQL Server 7.0/2005/2008/2012/2014 , Microsoft Access, Gupta SQL.

Reporting: Crystal Report 9.0, SSRS.

Operating Systems: Windows NT/2003/XP/Vista/7/10/2012, MS-DOS, UNIX

Tools: Microsoft Project, JIRA, Toad, RADAR 2.0, NetTerm, jbsql.

Version Control: Visual Source Safe, Team Foundation Server, Github.

FUNCTIONAL:

• Good experience of developing single and multi-user client-server applications in two-tier and multi-tier environment.
• Ability to conceptualize the business process into programmable object model.
• Ability to work in a team environment as well as in individual capacity.
• Good communication & interpersonal skills and ability to communicate with clients to analyze their computing requirements.
• Possess a good experience of leading small team of qualified software professionals and working on multiple projects with different responsibilities simultaneously. Experience of dealing with the clients.
• Good experience of KPAs of CMM Level5
• Function Point estimation
• Quality control and Assurance
• Self-motivated and hard-working Individual with good analytical skills and attitude to learn new things.

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential, Raleigh, North Carolina

Responsibilities:

• My role is to identify /resolve the problems in existing applications related to Health Hazards Control arena.
• Ensuring viability of existing data access, data structures, data manipulation, programming, testing and implement maintenance changes.
• Perform unit test configuration changes and bug fixes and keep system and user documentation current.
• Generate various statistical reports on need basis.
• Support of asbestos and lead-based credit, certify and permit processes in GUPTA SQL.

Software Consultant

Confidential, New York

Responsibilities:

• It includes solving user issues, system issues, analyzing windows logs from event viewer, maintaining VMWares and project monitoring via Solarwinds.
• Handling the daily, weekly and monthly back up operations using CA Arc serve.
• Problem analysis and escalation to server/network team (NY) and application team (Japan)
• Creation / deletion of user accounts in NetApp SAN, CISCO systems, HP On board and Securematrix
• Migrated vb6 projects to vb.net which involves SSRS, excel reporting and pdf reports.
• Worked on various accounting applications developed on VBA.
• Maintaining the loan application developed in MS-access forms, queries and reports.
• Converted FTP project to SFTP.
• Developed an app for getting the users permissions / rights over the network.
• Created and maintained asp.net pages for various applications of the company.

Confidential

Sr. Software Engineer

Responsibilities:

• Analyze and understand tax & business requirements and changed screens for new tax laws\modifications.
• Worked on database design, development of back-end objects and front end screens.
• Performed unit and system testing based on test plans, identification of problems and rectifying them.
• Used Visual Team Foundation server for version control, source control and daily progress report.
• Provided estimation of requirements and change requests.
• Work on daily production support incidents; troubleshoot/resolve problem tickets assigned.
• Involved in driving and maintaining the scrums/ sprints using JIRA.
• Used Web Services for communicating with other application and components.
• Installed software on windows 7, 64-bit machine and helped the peers.
• Developed and maintained clear and succinct documentation.
• Used AGILE methodology for better and faster execution.

Environment: Visual basic 6.0, ActiveX Exe, dlls, ActiveX controls, MS-Access, SQL server, .Net and web service.

Confidential

Sr. Software Consultant

Responsibilities:

• Analyze and execute change requests.
• Review and testing of changes made by other team members.
• Guiding team to set up the working environment and preparation of document for the same.

Environment: ASP, Visual basic 6.0, Java-Script and DB2 and deployed on COM+ server.

Confidential

Sr. Software Consultant

Responsibilities:

• Implemented CAR (CIVIL AVIATION REQUIREMENTS) given by DGCA in the existing project.
• Converted existing project into an independent product which can be used by other Airlines.
• Prepared project estimates and development & implementation schedule.
• Worked on the performance tuning of stored procedure and functions.
• Used Visual Team Foundation server for version control, source control, daily progress report & defect prevention.

Environment: -Visual basic 6.0, Asp.Net with C#, Excel reports and SQL Server.

Confidential

Sr. Software Engineer

Responsibilities:

• Involved in designing, coding, reporting, testing of budget pro-forma and printing of budget manual.
• Gathering of requirements from the functional designs, meetings, business analysts and department heads regarding Budget manuals.
• Used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database
• Written complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Created indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Imported data from text files and excel spread sheets into SQL Server 2005 database.
• Generated Sub-Reports, drill down reports and parameterized reports.
• Installed and configured .Net Framework3.5 and SQL Server 2008.

Environment: -ASP.Net, crystal report and SQL Server.

Freelancer

Confidential

Responsibilities:

• Independently implemented all phases of SDLC from requirement gathering, design, development, testing to deployment. The project is developed inVb.Net using WINFORMS, crystal report and Access, SQL server.
• Re-engineered the Doctor’s project of billing and prescription from VB, Access to ASP.net C#, and SQL Server. It takes care of new as well as existing patients, it displays previous history also. It is based on multi user functionality.
• Guided the people of The Dogma Soft on complete ERP project of ITI project.
• Reduced the latency in displaying the reports.
• Developed user defined fields (UDFs) / customized ERP for the billing system.
• Made few enhancements in the Post office saving project. Added functionality for PAN no, mobile and Email in screens as well as reports. The system is developed in VB 6.0, Access with 3-tier architecture.

Confidential

Team lead

Responsibilities:

• Developed the tool for converting old packages from DAO connectivity to ADO for MS-Access then SQL Server. Performed conversion of both the packages to SQL Server.
• Created UDF (User defined fields) to customize the products for new users.
• Developed ActiveX control to be used the project and other projects in the companies.

Environment: - Visual Basic 6.0, SQL Server2008 and MS-Access.

Confidential

Programmer Analyst

Responsibilities:

• Worked on front end screens and maintained back end stored procedures.
• Involved in migration from Oracle 8i to Oracle 9i on Unix Server.
• Created UNIX Shell Scripting for invoking SQL scripts.
• Generated Sub-Reports and Drill down reports.
• Documented Impact analysis and unit test plans for every enhancement and share it with client.
• Provide tasks estimations and ensure timely completion of the project tasks.
• Developed performance metrics and conducted performance appraisals. Preparation of various MIS reports (Project Status report, Defect Prevention Report, Monthly & Quarterly summary reports of Project performance.
• Division of work among the team members, conducting pre and post debrief sessions for all the modules. Provided coaching and feedback to team members. Provide subject matter expertise to improve the team’s skills.
• Conduct team meetings to ensure that there is constant flow of information and knowledge dissemination - issue resolution, knowledge updates.
• Communicated with Onsite coordinator in relation to project deliverables, timelines, weekly status reports, billing etc.
• Conducted compliance check for CMM Level 5.
• Imparted technical training to team and peers.
• Preparation of Knowledge sharing modules (as part of Confidential Knowledge Base)
• Designed the coding standard and Setup the development strategy and trained the team for the same.
• Responsible for management of projects, project scheduling, work-allocation, user-training, training of the Development team and documentation of all phases of software development life cycle as per the CMM Level 5 guidelines.
• Involved in the standardization process of software development strategy of the company and developed generalized modules for data access layer for the database applications, ActiveX controls for the reusability of user interface requirements, library of generic functions used with the user interface tier and creation of templates for business logic of the applications.
• Used Performance Monitor/Profiler to solve dead locks/long running queries.
• Used VisualSource Safe for version control, source control and reporting.
• Identified existing issues, found solutions, updates and project status to peers and management.

Environment: - Visual Basic 6.0 web classes, HTML, JavaScript, UNIX shell Script, Crystal Reports 9.0, Oracle8i/9i.