Senior Software Consultant Resume
CA
Summary
- 8+ years of professional experience in developing and administering .NET Framework applications.
- Proficient in C#, ASP.NET, ADO.NET, Web Services, WinForms and SQL Server with strong knowledge of object-oriented techniques and concepts.
- Capable of developing and maintaining application GUI using JavaScript, ExtJS and AJAX.
- Experience in database design and implementing RDBMS.
- Very strong in writing Stored Procedures, Functions, Views, T-SQL, and Triggers for SQL Server.
- Configuration and maintenance experience of .Net applications on IIS.
- Conversant with all phases of software development life cycle.
- Good knowledge and experience with ASP.Net 3.5/ 2.0/ 1.1 and SQL Server 2008/ 2005/ 2000.
- Direct client interaction experience for business process and requirements gathering.
- Experience with web applications in Finance, Employment and Sales.
- Strong written and oral communication skills, self-motivation, creativity and ability to adapt to new technologies and applications.
Education
- Bachelor of Engineering in Information Technology, University of Mumbai, India
Recognitions and Certifications
- Received Star of the Month Award at Quinnox Consultancy Services.
- Received Key Performer Award at AIG - SunAmerica
Skills Summary
Programming Languages
C#, VB.NET, T-SQL, VB 6
Platforms
Microsoft .NET Framework 3.5/ 2.0/ 1.1, ADO.NET, ASP.NET, WinForms, Web Services, Silverlight 2.0, MSMQ
Databases
MS-SQL Server 2008/ 2005/ 2000, Sybase 8.1.1, Oracle 10g
Web Technologies
ASP.NET 1.1, 2.0 & 3.5, Web Services, WCF, WinForms, LINQ,
HTML, CSS, ExtJS, JavaScript, AJAX, XML, XAML
Tools & Utilities
Visual Studio 2010/ 2008/ 2005/ 2003, Visual Basic 6.0, Team Foundation Server
Visual SourceSafe 6.0, SQL Server 2008/ 2005/ 2000, Oracle 10g, Sybase 8.1.1, IIS
Operating Systems
Windows 7/ 2000/ Server/ XP Professional/ NT/ 98/ 95
Professional Experience:
Client: Confidential,
Angeles, CA
Duration: Mar 10 till date
Project 3: “Enterprise Notifications System”
Role: Senior Software Consultant / Analyst
Environment: Visual Studio 2008, ASP.Net 3.5, Team Foundation Server 2010, C#, ExtJS, AJAX, JavaScript, SQL Server 2005, WCF, WinForms, MSMQ
It is a centralized notification system which is capable of sending Email alerts to advisors, clients, BackOffice users, support groups about various events occurring inside the systems of Advisor Group. Approval of an account opening request, completion of a daily file loading, weekly Pershing Open Order report etc are some examples of such events. The Batch applications which do not have a direct interface with the end-users, is also able to send notifications using ENS. One of its components is exposed to the web apps so that the web apps can retrieve and show the messages to the current user in the webpage. MSMQ is used for queuing and sending messages in the system.
Responsibilities:
- Create SQL Stored Procs to Post messages in the Service Broker Queues once the file loading is complete.
- Enhance ASP.NET ENS Client Service to retrieve messages from the Service Broker Queues.
- Setup ENS Agent Service to read messages from MSMQ and send out notifications.
- Expose C# Web Service to allow web apps to post messages on different events.
- Interact with business to develop new Notifications in the system.
- Setup Dev/QA environments.
- Troubleshoot issues and perform application maintenance.
- Create manuals and design, functional documents
- Use TFS 2010 for source code and version control.
Project 2: “MySubscriptions”
Role: Senior Software Consultant / Analyst
Environment: Visual Studio 2008, ASP.Net 3.5, Team Foundation Server 2010, C#, ExtJS, AJAX, JavaScript, SQL Server 2005, WCF, WinForms
Mysubscriptions allows users to subscribe/unsubscribe to Paid/Free services available on the V2020 Advisor Portal. It involves complex business rules, to allow users to subscribe to certain packages with available promotions. There are multiple batch jobs to take care of the users subscriptions, few of them are Auto Terminate enrollments on user termination, Billing file generation, Enrollment Pricing etc.
Responsibilities:
- Develop and enhance web pages using EXTJS.
- Create WCF using ASP.NET C#.
- Write Stored Procedures, Triggers and Functions in SQL 2005.
- Interact with business to define the business rules for the system.
- Develop Console Applications for daily/monthly batch jobs
- Setup Dev/ QA/ Demo environments for development and testing purpose.
- Troubleshoot production issues and perform application maintenance.
- Created Design, Functional and User Manual documents.
- Use TFS 2010 for source code and version control.
Project 1: “Advisor Portal”
Role: Senior Software Consultant / Analyst
Environment: Visual Studio 2008, ASP.Net 3.5, Team Foundation Server 2010, C#, ExtJS, AJAX, JavaScript, SQL Server 2005, WCF, WinForms, SSRS, RSA, TRIDION, SalesForce
Advisor Portal is a web based application, used by more than 5000 AIG advisors everyday to view commissions, log checks, manage their online profiles, raise tickets etc. Advisor Portal combines the features, tools and content from Legacy and home office websites into an integrated website providing with one source for home office interactions. Through Advisor Portal, one can browse other related applications, through internal SSOs. The publishing of the contents and Advisor updates to the site are taken care through a tool called Tridion. RSA authentication is implemented to ensure high-end security for the advisors.
Responsibilities:
- Setup Dev, QA, Staging and Demo application environments using IIS.
- Enhance application performance by tuning SQL queries.
- Develop web pages using EXTJS and AJAX technology.
- Use JAVASCRIPT to support EXTJS functionality.
- Manage content deployments using TRIDION.
- Implement Windows applications for loading data used in reporting.
- Use SSRS for generating PDF reports.
- Made necessary changes to the Portal for implementing Windows Authentication.
- Change/add WCF services in C# for bugs/enhancements.
- Integrate application with Host Checker device (JUNIPER) for better security.
- Enable Single Sign-Ons to third-party vendors like MorningStar, SalesForce, Pershing etc.
- Use PVCS and TFS for codebase and version maintenance.
- Analyze user login activity using RSA transactions.
Client: Confidential,
Duration: Feb 08 Jan 10
Project 5: “CopyDBWeb”
Role: Senior .Net Developer / Analyst
Environment: Visual Studio 2008, ASP.Net 3.5, C#, LINQ, ADO.Net, SQL Server 2005, JavaScript, Silverlight 2.0, Visual Source Safe, JIRA, DBArtisan
This is a web based application which helps automate the database migration from one application environment to another. The environments handled by the application are PRD, PREPRD, UAT, SYSTST, and DEV. The system provides user role entitlements and access rights on each and every registered data source, by which proper access control and auditing is ensured for all actions. The authorized user first registers the data sources, before database placing migration requests from one data source to another. It has rich UI controls, and uses Silverlight.
Responsibilities:
- Involved in gathering and analyzing business requirements.
- Developed web pages using C#.
- Defined logical database model, table structures, and the relationships between tables and data.
- Designed and developed database migration module to move data from one source to another.
- Created SILVERLIGHT Controls, which are effectively used in UI pages.
- Used SILVERLIGHT Navigation Framework
- Utilized LINQ to access the relational database.
- Wrote Stored Procedures, User Defined Functions, Views and T-SQL statements.
- Enhanced the performance of the application by fine tuning SQL queries and creating indexes.
- Set up the staging environment and configured the site on IIS 6.0 and Windows Server 2003.
- Used Visual Source Safe for the source code and version control.
- Created Design, Functional and User Manual documents.
- Performed trouble shooting and testing of the application.
Project 4: “JIRA Task Planner”
Role: Senior .Net Developer / Analyst
Environment: Visual Studio 2008, Excel VSTO, ASP.Net 3.5, C#, WCF, Visual Source Safe, JIRA, DBArtisan
In Nomura, JIRA is used as a central store for projects, resources and tasks. JIRA exposes web services, which are used by planners to fetch project and task information. This particular application assists project managers in Automating resources task allocation, forecast delivery dates, and assisting with task prioritization for each resource. It also tracks all tasks to completion. It also maintains leave data for resources, which are accounted for when the tasks are allocated. The application is developed in C# using Excel VSTO.
Responsibilities:
- Involved with gathering and analyzing business requirements.
- Developed user control using C#.
- Used web service to download data to Planner from JIRA.
- Utilized .Net Validation Controls.
- Consumed WCF service exposed by JIRA.
- Built the Data Access Layer by using the latest ADO.NET components.
- Used Visual Source Safe for the Source code and Version control.
- Created Design, Functional and User Manual documents
- Handled production troubleshooting and testing
Project 3: “xBorder”
Role: .Net Developer / Analyst
Environment: Visual Studio 2005, ASP.Net 2.0, C#, ASP 3.0, VB 6, MS SQL Server 2005, Visual Source Safe, JIRA, DBArtisan
This Web Application is a multi-regional workflow approval system enabling users to track and control the negotiation and execution of inter-company cross border agreements. The application has three subsystems; Web site, Checkpoint and Patroller. The website is developed in ASP 3.0. Checkpoint is used by Tax Administrators to allocate approvers to the agreement, upload documents, view Audits, and send Ad-hoc mails. Patroller subsystem sends out automatic mails to approvers and Tax Administrators about the Agreement status change. This subsystem was developed in C# in ASP.NET 2.0.
Responsibilities:
- Developed component to send out automatic mails from Checkpoint in ASP.NET, C#.
- Designed and analyzed change requests, prepared and confirmed the specifications and then performed the coding.
- Wrote Stored Procedures, User Defined Functions, Views and T-SQL statements.
- Used Visual Source Safe for the source code and version control.
- Worked on production troubleshooting and testing.
- Created the design and application manual documents
Project 2: “Scanned Invoice Management and Approval (SIMA)”
Role: .Net Developer / Analyst
Environment: Visual Studio 2008, ASP.Net 3.5, C#, ADO.Net, Silverlight 2.0, Oracle 10g, Visual Source Safe, JIRA, Autosys, DBArtisan
This system manages all the invoices and vendors of the client. The invoices are validated against the corresponding images scanned and later approved by the users. The documents are scanned by the users to the Outlook folder, from where the attachments are extracted by Email Extraction job and are stored. SIMA also uses the image viewer service to display the documents scanned on the browser. It is developed in C#.
Responsibilities:
- Assisted in gathering and analyzing business requirements.
- Defined logical database model, table structures, and relationship between tables and data.
- Developed the Email extraction job to Outlook mails using C#.
- Developed an Image Viewer service for the images on the browser using C#.
- Created complex SILVERLIGHT controls
- Wrote Stored Procedures, Triggers and T-SQL statements to access and update the database.
- Set up the staging environment and configured the site on IIS 6.0 and Windows Server 2003.
- Used Visual Source Safe for the source code and version control.
- Created Design, Functional and User Manual documents
- Assisted in trouble shooting and testing.
Project 1: “Lehman Invoice Approval and Management (LIAM)”
Role: .Net Developer / Analyst
Environment: Visual Studio 2005, ASP.Net 2.0, C#, ADO.Net, Web Services, Java Script, Crystal Reports 9.0, VB 6, Sybase 8.1.1, JIRA, Autosys, DBArtisan
This web application managed all the invoices and vendors at Lehman Brothers. The invoices were validated against the corresponding image scan and later approved by the users. Once approved, the payments were generated to the vendors. LIAM also gets daily feeds from various applications for updates within the organization. This was managed by the DTS Jobs deployed on SQL Server 2000.
Responsibilities:
- Designed and analyzed of change requests, prepared specifications and modified the code.
- Designed and developed Web pages in C#.
- Effectively developed and maintained application reports using Crystal Reports 9.0.
- Wrote Stored Procedures, User Defined Functions, Views and T-SQL statements.
- Set up the staging environment and configured the site on IIS 6.0 and Windows Server 2003.
- Used Visual Source Safe for source code and version control.
- Created Design, Functional and User Manual documents
- Performed trouble shooting and testing of the application.
Confidential,
Duration:Nov 05 to Feb 08
Project 2: “Shawtrust - Pathways”
Role: Software Programmer
Environment: Visual Studio 2005, ASP.Net 2.0, C#, ADO.Net, Web Services, Java Script, SQL Server 2005, Visual Source Safe
Shaw Trust is a national charity that provides training and work opportunities for people who are disadvantaged in the labor market due to disability, ill health or other social circumstances. Shaw Trust is the largest UK provider of employment services for disabled people. It sets an example, by providing jobs to disabled people in their own organization. The tool developed helps the organization in the process of conducting interviews and getting jobs for the disabled people.
Responsibilities:
- Assisted in gathering and analysis of business requirements.
- Developed web pages using C#.
- Designed and developed security module for users groups and rights.
- Utilized .Net Validation Controls
- Create Stored Procedures, User Defined Functions, Views and T-SQL statements.
- Used VSS for the source and version control.
- Trained clients using this application in the initial stage
- Created design, functional and user manual documents
- Assisted in the trouble shooting and testing of the application.
Project 1: “Richmond Events”
Role: Software Programmer
Environment: Visual Studio 2003, ASP.Net 1.1, C#, ADO.Net, SQL Server 2000, Visual Source Safe
Richmond organizes conference sessions, think-tanks and workshops. Richmond events are the most efficient and effective investment of time for buyers to find out about suppliers and to talk to them about their products and services. The software was developed to arrange the meetings between buyers and sellers. The tool allows an executive representing a company to interact with the clients and sell their products and services.
Responsibilities:
- Designed and analyzed change requests, prepared specifications and coded the enhancements.
- Developed Web pages in C#.
- Coded Stored Procedures, User Defined Functions, Views and T-SQL statements.
- Created installation, Functional and User Manual documents
- Used Visual Source Safe for the source code and version control.
- Performed the unit testing and integration testing with the ASP.NET Web Service.
- Tested performance and resolved issues.
- Preformed troubleshooting on production issues.
Confidential,
Duration:May 03 to Feb 05
Project 2: “Timesheet Management System”
Role: Software Engineer
Environment: Visual Studio 2003, ASP.Net 1.1, C#, ADO.Net, Web Services, WinForms, SQL Server 2000, Visual Basic, SVN
Web based timesheet management system allows the users to record their daily timesheet against one or multiple projects. Its online approval functionality completes the workflow by providing the project managers with a tool to approve the time entries by their team members.
Responsibilities:
- Maintain and Improve Timesheet Management System
- Design web pages in C#, and VB.NET
- Talk to Business users for Enhancements to TMS
- Use XML for Navigation Menu.
- Develop SQL Procs, Views and Functions to retrieve/insert/update/delete records.
- Use SVN for version control.
- Fix issues during QA and UAT phase.
- Setup the Dev site for development purpose
Project 1: “Payroll Management System”
Role: Software Engineer
Environment: Visual Studio 2003, ASP.Net 1.1, C#, ADO.Net, SQL Server 2000, Visual Source Safe
Payroll system can generate all the reports related to company, employee, attendance/leave, payroll. Management will get a clear view about the Payroll and Attendance of the Employees. All the processes are categorized, giving a very simple interface to the end user.
Responsibilities:
- Design and develop WINFORMS in C#, ASP.NET.
- Develop ADO.NET components for accessing database.
- Use SVN for version control.
- Develop and maintain SQL Procs, Views and Functions.
- Create deployment packages using MSI
- Develop customized User controls
- Use VB.NET WINDOWS SERVICES for receiving vendor files.
- Load data files from other systems using WINFORMS
