Sql Server Business Developer .Net Oracle Engineer

Name of the Candidate Sangameswar

E-Mail ******.***@*****.***

Mobile# 214-***-****

Work Experience Summary:

I have extensive information technology experiences spanning 9 years in various areas of Systems Analysis and Software Development. I have successfully managed large-scale, long-term projects as well as small projects with short durations.

The following bullet items summarize my areas of expertise:

Exposure to full application development lifecycle (Plan, Requirements Gathering & Analysis, Design, Development, Test, and Deploy).

Extensive experience in developing Intranet applications using .NET Framework 2.0/3.0/3.5, C#, ASP.NET 2.0/3.0/3.5, VB.NET, Visual Basic 6.0 (VB 6.0), Classic ASP(Active Server Pages), IIS, VB Script, UML .NET Remoting and Web Services.

Hands on experience in developing three tier/N-Tier architectures and implementing Object Oriented Programming (OOPS) Concepts including Inheritance, Abstraction and Polymorphism and Design Patterns.

Experience in developing applications with Agile/ Scrum methodologies.

Extensive experience in web page designing with Cascading Style Sheets (CSS), HTML, DHTML, JavaScript, AJAX, JQuery and VBScript.

Good knowledge of design patterns such as MVC/MVP.

Expertise in .Net technologies with Object Oriented Analyzed Development (OOAD) & development of Web and Win forms applications.

Experience in implementing SOA architecture with web services and creating, consuming and publishing XML Web Services (SOAP, WSDL) and Windows Services using .NET.

Good working experience with ADO.Net objects and Database Connectivity API’s (ADO.Net) in Web applications and Win form applications.

Worked on window services for IBM Web-sphere MQ, interfaces for Bio-Metric Systems, sending real time alerts and sending reports on schedule.

Prolific working knowledge in SQL Server store procedure, functions, triggers, Views and database related tasks.

Strong knowledge working with SQL Server DTS, SSIS Packages.

Built complex reports using Crystal Reports and SQL Server Reporting Services (SSRS).

Very good at writing Oracle pl/sql, stored procedure, functions, triggers, Views, SQL loader.

Prolific working knowledge in XML, XAML, XSL and XSLT.

Actively work with customers to analyze business needs, gather and document business and system requirements.

Strong knowledge in ERP System Design, Development, Implementation.

Experience in building and deploying Point-Of-Sales (Commercials) systems for Billabong, IV-Play, Peace Angels, etc.

Methodical work habits, with the ability to clarify business logic requirements, turn them into clear and definitive algorithmic descriptions that business users can understand and approve, and implement those in code.

Involved in Project Planning, Analysis, System Design and development activities for various industries like Telco, Manufacturing, Automobile, Construction, Hotel and Tourism, Banking, Government Organizations, Customs Department.

Technical Skills:

Languages: C#.Net, VB.Net, C, C++, Java, Visual Basic 6.0, PL/SQL, Objective C.

Web Technologies: ASP.NET, Classic ASP, HTML, AJAX, Web-Services (SOAP),WCF, LINQ, ADO.NET Entity Services, ASP.NET MVC, ASP.NET 4.0, ASP.NET 3.5,WPF, Silverlight 4.0.

Internet Markup languages: HTML, DHTML, CSS, and XML.

Scripting Languages: VBScript, JavaScript, JQuery.

Web Servers: Internet Information Server (IIS), Personal Web Server

Web Development Tools: Visual Studio.NET 2003/2005/2008/2010, Expression Blend, Visual Interdev 6.0, Front Page.

Databases: MS SQL Server 2000/2005/2008, Oracle 8.0/9i/10g, DB2, MS Access, MySQL.

Operating Systems: Dos, Windows95/NT/98/2000/XP/Vista/7.

Design Tools: Microsoft Visio.

Code Management Tools: Visual Source Safe (VSS), SVN, TFS.

Tools: SSIS, SSRS, Crystal Reports, Xcelsius, Jacada Winfuse and Workspace.

ERP: In-depth knowledge in SAP CRM Sales, Service, IC WebClient and ISA functionalities.

Mobile: Knowledge of Objectve C with Cocoa Touch for i-phone development.

Experience:

• Frontier Communications (Verizon North Central), W.Airfield Dr, TX 75361

• July 2010 – till date

.NET Lead

Frontier Communications Corporation (NYSE: FTR) offers voice, High-Speed Internet, satellite video, wireless Internet data access, data security solutions, bundled offerings, specialized bundles for small businesses and home offices, and advanced business communications Access Solutions for medium and large businesses in 27 states.

Responsibilities:

Provide day to day guidance and oversight of all web software development activities, definition of our best practices, methodologies, and implementation of third party tools.

Lead the migration teams for the Revenue Assurance web tools. The migration involved moving from Verizon to Frontier Communications.

Involved in detail design and prepared flow diagram/sequence diagrams using Visio for Revenue Assurance Data layer/ Business layer code which are used for the analysis and to improve quality/performance of the application.

Lead the implementation effort to integrate all Revenue Assurance tools under one umbrella. This enabled us to have single console for all the Revenue Assurance Tools.

To implement new architectural guidelines for business applications. Create tools to generate solutions, projects, and source code to act as the baseline for our standardized architecture. Conducted ongoing training classes on architecture and design. This included in person training.

To coordinate with Single Sign-on team, Load balancing team, DBA team, Network Administrators for the smooth maintenance of the applications.

Load testing on the Revenue Assurance Notification server to test capability and durability for the maximum users by using Customize Dot Net clients and Performance monitor.

Developed automated processes for downloading contents/feeds from various sources and make them available on the web portals on a daily basis. This is developed using Windows Services, VB Script, SSIS, Batch Jobs, Crontabs on Linux servers and SHH2. .

Responsible for writing the stored procedures, triggers, functions and views on both Oracle and SQL Server databases for different applications in Revenue Assurance tools.

We have about 12 applications and 8 tools to manage with a team of 6 which includes .NET developers, Oracle DBA, Systems Admin and a networking team.

We use Visual Source Safe 6.0 for configuration management.

Environment:

ASP.NET, Winforms, C#, VB.NET, T-SQL, SQL server 2005, PL/SQL, Oracle 10g, ADO.NET, VB Script, JavaScript, CSS, XML Spy, IIS-6.0, VSS-6.0, IBM Web-Sphere MQ, SSH2, Visio 2003, Xcelsius, UNIX, Linux.

• Verizon, Grapevine, TX 75061

• November 2009 – June 2010

.NET Developer

Verizon is a Pioneer in telecommunications and broadband services. The company's wire-line business provides local telephone, long-distance, and Internet access services to residential and small to midsized businesses in 28 states and Washington DC. It has about 40 million voice access lines in operation and it serves about 8 million broadband Internet customers. Verizon Business provides communications and information technology (IT) services to global business and government clients.

The Data Reconciliation Tool (DRT) was built in reaction to an audit finding which detected a large disparity in billed and provisioned DSL lines. Originally DRT compiled essential DSL Production data and then ran a series of audits to check the integrity of the Verizon DSL inventory – ensuring that every DSL line was properly registered in both Provisioning and Billing (both internal and external).

Responsibilities:

GUI (ASP.NET) – meant for the use of workers who executed manual fixes to the various problems. The work done in DRT creates a history which can be used to audit individual fixes. The history also supports a broad spectrum of reports to provide productivity metrics.

Initially the various batch processes used to fix groups of similar problems did updates to the DRT queues via a variety of back-end scrubs. Automated these processes into an ‘automation group’ and APIs were created to allow these processes to update DRT queues – removing targeted work from the workers and then posting the results of the automation processes to DRT for reporting and/or returning failed process items for manual work.

Additionally DRT reporting and metrics were extended to cover business requirements and to compensate for various experiences. The reporting was extended to measure productivity at a center as well as an individual level. Financial reporting was added to provide hard dollar metrics of the work value.

Designed Web portal where user can modify different feeds. This is developed using ASP.Net, C#, XML, JQuery, AJAX control toolkit, HTML, CSS, Javascript, SQL Server 2005, Oracle 10g.

Built the Data Access layer for the application as part of migration from SQL Server 2005 to Oracle 10g.

Developed middle proxy layer using ASP.Net 3.5, C#, XML, Caching and WCF Restful services to provide data/contents to various widgets.

Re-coded all the GUI pages for Oracle platform both for Web and Winform desktop applications.

Winforms are mostly used to build the wrapper for Moneta Application(Subex Revenue Assurance Tool) for the purpose of Single Sign On(SSO)

Written stored procedures, triggers in SQL SERVER and Oracle 10g.

Involved in the process of migrating the data from SQL server 2005 to Oracle 10g platform. This includes tasks like identifying issues in pre and post migration.

Implemented Bulk Data Processing (Uploading to Database and processing the data) from the DAT/flat files.

Added new feature to show complete details, history information and order history of the customer account, which pulls information from more than one system.

Created Dashboard using X-Celsius (Seagate Business Objects) for Graphical presentation of the reports to Management.

Responsible for Post Production Support of the tool.

Environment:

ASP.NET, Winforms, C#, VB.NET, T-SQL, SQL server 2005, PL/SQL, Oracle 10g, ADO.NET, AJAX, JavaScript, CSS, XML Spy, IIS-6.0, VSS-6.0, Xcelsius, SSH2, Visio 2003, VSS 2005.

• Jacada, Atlanta, GA 30328

• August 2009- October 2009

.NET Developer

Jacada (NASDAQ: JCDA) is a leading provider of unified desktop and process optimization software solutions for the customer service and support market.

Jacada unified service desktop solutions simplify and automate customer service processes – bridging disconnected systems into a single, intelligent workspace, without requiring modification or replacement of existing systems. Contact centers worldwide are using award-winning Jacada unified desktop solutions to automate complex processes, improve customer satisfaction and loyalty, reduce operational costs, and enforce and monitor compliance with regulatory policies and procedures.

COX, Best Buy, Permanent General Assurance Company, etc. are its clients.

Responsibilities:

To develop CSR based application for Permanent General Assurance Company.

Responsible for developing the solution using Jacada’s WinFuse, HostFuse and WorkSpace tools.

Develope Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Expose and consume Web Services through HostFuse and WorkSpace for AS400 environment.

Responsible for DEV & UAT environments for the build.

To train the users on the developed environment.

Responsible for Post and Pre-Production Support.

Involved in the functional and technical designs for new enhancements.

Use Tortoise SVN for configuration management.

Environment:

WinFuse, HostFuse, WorkSpace, C#, Eclipse, WebLogic, AJAX, WebSphere, Winforms.

• Verizon, Irving, TX 75038

• December 2008 – August 2009

.NET Developer

BQT-DTV is the team which looks into the Order Management of Direct-TV (GUI), Bundle Qualification and One Bill (to have both DTV & Verizon Telco/Wireless bills in a single bill as DTV is separate entity from Verizon.)

Responsibilities:

Worked as a lead developer for the project. Worked closely with all the business users/managers, gathered and analyzed all necessary requirements by involving in discussion sessions and identified effective uses of technology to meet their business needs.

Used N-tier architecture for presentation layer, the Business, Enterprise Layer and Data Access Layer and were coded in C#.

Involved in the coding, code review and unit testing of programs for the application development and bug fixes.

Exposed and consumed Web Services. Worked on ASP.Net, HTML, and JavaScript to develop web application for the Verizon BQT-DTV team.

Used .Net, SQL Server 2005, Web-sphere MQ, to develop backend work flow architecture.

Implemented Windows services for retrieving the data from IBM Web-sphere Messaging Queues.

Enhanced the windows service to comply Batch Processes running at different time stamps.

Written stored procedures, triggers in SQL SERVER and Oracle 10g. SQL server was used as reporting server.

Designed a batch process to upload files in XML, CSV, Tab separated format to load to Oracle database using SQL Loader.

Used XSLT to transform the data from XML to pre-formatted text documents for data processing.

Designed a test client using Winform for testing the web-services input and output XML.

Implemented SFTP between DTV and Verizon Environments using SSH2.

Used Visio for Basic and Cross Functional Flowcharts.

Used Visual Source Safe 6.0 for configuration management.

Used CMIS for Build Management Process.

Worked as a Core Team Member/Module Lead/On-shore member handling offshore team of size 5-8.

Environment:

ASP.NET, Winforms, C#, VB.NET, T-SQL, SQL server 2005, PL/SQL, Oracle 10g, ADO.NET, AJAX, JavaScript, CSS, XML Spy, IIS-6.0, VSS-6.0, IBM Web-Sphere MQ, SSH2, Visio 2003.

• Verizon, Irving, TX 75038

• May 2008 – November 2008

.NET Developer

Verizon is one of the major companies in the telecom industries, providing long-distance, and High Speed Internet services to all kinds of Customers like residential, small and general businesses. Verizon Business also provides communication and information technology (IT) services to global business and government clients. Verizon provides rich User Interface for Bill Pay, Registration and Bill view and many other applications offered by them

Responsibilities:

My Business Account (Migration/Federation of General Business & Wireless Customers)

Involved in the federation of VZT (General Business) and VZW (My Business) domains.

Worked in IR (Issue Request) Team in dealing the issues for VZ.com.

Worked & implemented GB Regadmin tool (Windows forms using WPF) for solving the IR’s using CMIS Web Enterprise used for Verizon Intranet use.

Implemented Web User Controls, middle tier components, Windows Services and Web Services.

Worked on some enhancements for the My Account, E-Registration, and Bill View modules in C# and ASP.net.

Was responsible for the entire database related activities for the project. Creation and optimization of store procedures, functions, views and triggers were written for certain database tasks.

Implemented Email Notification Application in the Process of federation with VZT and VZW domains.

Implemented Batch Programs which sends Emails to the particular Users periodically.

Setting up and deployment of ASP.net web application on to development and production servers.

Involved in Unit testing and functional testing.

Created the directory structure in UNIX and maintained the files in the UNIX.

Worked on XSL and HTML templates for PNP application and batch e-mail notifications.

Involved in Production Support for the Applications My Account & Registration of VZT (Verizon Telecom).

Configured IBM DB2 settings for the My Account & Registration Applications.

Worked with IBM MQ for intercommunication between different Platforms.

Involved in Application level production support for Consumer My Verizon site.

Involved in Database Migration effort from 8i to 10 g of Oracle.

Designed a test client using Winform for testing the web-services input and output XML.

Involved in migration of Code from Visual Source Safe to Team Foundation Sever.

Worked as a Core Team Member/Module Lead – led team of 5 members/On-shore to guide offshore team.

Environment:

ASP.NET, Winforms, C#, VB.NET, T-SQL, SQL server 2005, PL/SQL, Oracle 8i, Oracle 10g, ADO.NET, JavaScript, CSS, XML Spy, IIS-6.0, VSS-6.0, TFS, AJAX, Windows-XP, Visio 2003.

• Sotravic Limitee, Mauritius

• November 2006 – December 2007

.NET Developer

This project is to automate the day-to-day activities of the company and its construction sites. It includes Plant management, recruiting, termination, leave management, Finance and Payroll management. This system also generates reports for auditing and Income tax calculations.

Responsibilities:

Developed Client/Server application and 3-Tier application to keep track of tasks such as file maintenance, Ticketing, Report generation, delivery schedules of the Plant Equipment.

COM port communication was done for interfacing with the Digitizer (Electronic Weigh Bridge), which was used to weight the trucks.

Performed business and system analysis, designed in UML the structure of three-tier solution, defined the hierarchy of classes to incorporate the business logic.

To improve the performance a copy of the data was saved on the local computer in MS Access for quick report generation and a copy of the data is saved in the SQL server located in the Head Office.

Extensive use of crystal reports for generating various reports depending on the user requirement.

Developed stored procedures for MS SQL Server 2000.

Coordinate with the QA Team for Unit Testing and Integration Testing of different modules.

Maintained the application, added new features and generated new reports.

Responsible for developing and integration of Payroll & Accounting Package.

Designed reports for auditing, income tax calculations and payroll using Crystal reports.

Environment:

Winforms, C#, ADO.NET, SQL Server 2000, Microsoft Office 2003, Windows 2003, Crystal Reports, XML, JavaScript.

• Billabong Group of Companies, Mauritius

• November 2006 – January 2007

.NET Developer

Sports wear and Casual Cloth Manufacturer.

As Dot Net/SQL Server programmer designed and developed a Reporting Tool in Microsoft SQL server 2000. I was also involved in developing Automation 2005, an automation tool that automates the daily activities of the company.

Responsibilities:

Involved in requirement gathering, feasibility and analysis.

Designed and developed a Meta data driven reporting tool to generate reports, similar to Analysis services cubes, to compare with the existing reporting tool for Quality Assurance Team.

Used SQL Server 2000 authentication to authenticate the user and table level permissions are maintained using the SQL server 2000 user permissions.

Involved in coordinating with team members to discuss and implement different methods to improve the project performance and securities.

Involved in creating technical and user documentation.

Involved Used VSS for Version control and for source code check-in.

Responsible for designing complex MIS reports using Crystal Reports.

Performed the Unit Testing, Functional testing, Integration testing and System testing.

Modified existing code for code reusability and also to improve the performance.

Extensively used Microsoft Visio 2003 for creating technical documentation.

Environment:

C#, Winforms, ASP.Net, JavaScript, XML, HTML, ADO .Net, SQL Server 2000, Microsoft Office 2003, Windows 2003, IIS 5.1

• Coralia Mont Choisy Hotel, Mauritius

• January 2006 – October 2006

Software Engineer

This is 3 star hotel located in the North of the island.

Developed and Implemented Hotel Reservation and Mini-Bar/Restaurant System.

Responsibilities:

• Involved in the requirements gathering of the system.

• Compiled the gathered information into Functional Requirements.

• Responsible for developing the Mini-Bar/Restaurant System.

• Performed the Unit Testing, Functional testing, Integration testing and System testing.

• Involved Used VSS for Version control and for source code check-in.

• Involved in the database design of the system.

• Used Crystal Reports for generating different reports like Bills, Invoice, Occupancy, etc.,

• Involved in Post-Production support.

Environment:

VB 6.0, ADO, SQL Server 2000, Microsoft Office 2003, Windows 2003, Crystal Reports 8.5, Help Scribble, VBScript, ASP, IIS 5.0, VS InterDev.

• South East Asian Bank Ltd., Mauritius

• June 2005 – January 2006

Software Engineer

2008 - Acquisition by the British American Investment Co. (Mtius) Ltd

Change of name to Bramer Banking Corporation Ltd.

Developed and Implemented Payroll and Attendance System.

Responsibilities:

Developed Client/Server application (Centralized Payroll and Attendance System).

COM port communication was done for interfacing with the Biometric Clock Card, which is used to record attendance of Employees.

Performed business and system analysis, designed in UML the structure of three-tier solution, defined the hierarchy of classes to incorporate the business logic.

Extensive use of crystal reports for generating various reports depending on the user requirement.

Developed stored procedures for MS SQL Server 2000.

Designed reports for Salaries to Bank, monthly payroll returns both by Employee and Employer and taking out performance reports of employees from the Time sheets using Crystal reports.

Developed a module for Electronic filing of Employee & Employers returns to Revenue Authorities on monthly and yearly basis.

ASP.NET was used for Overtime and Leave approvals module.

Involved in Post-Production support.

Environment:

Winforms, C#, ADO.NET, SQL Server 2000, Microsoft Office 2003, Windows 2003, Crystal Reports, VBScript, ASP.NET, IIS 5.x, VS InterDev.

• Business Parks Mauritius Ltd., Mauritius

• December 2003 – June 2005

Software Engineer

In early 2001, the Government of the Republic of Mauritius set up Business Parks of Mauritius (BPML) to spearhead the development of business parks in Mauritius.

In November 2001, BPML incorporated a subsidiary company, BPML Freeport Services Ltd (BFSL) to develop and provide logistics and ancillary telecommunications facilities and services to operators trading under the Freeport, EPZ, Suspended Duty/Bonded regimes and to local enterprises.

Built and maintained Warehouse Management System for Customs Department of Mauritius.

Responsibilities:

Developed Client/Server application.

Involved in business and system analysis, designed in UML the structure of three-tier solution, defined the hierarchy of classes to incorporate the business logic.

Responsible for developing automatic picking module of pallets in Warehouse.

Wrote a module to generate and print Bar-coded pallet Id’s for the put-away module.

Responsible for building the shipment details module.

Developed a customer billing module for storing of pallets and parking of imported cars.

This system generates an out put file in excel which will be used by Sun Accounting system by the Accounts department.

Responsible for Post-Production Support of the System.

Environment:

Winforms, C#, ADO.NET, SQL Server 2000, Microsoft Office 2003, Windows 2003, Crystal Reports, VS Flex Grid, VS Print for some complex Accounting reports.

• Department of Horticulture, India

• April 2002 – November 2003

Software Engineer

Department of Horticulture is one of the State Govt. owned body responsible for introducing Micro Irrigation Projects and Israeli way of cultivation in Andhra Pradesh, India.

Responsibilities:

Developed a system to computerize the “Area and Production of Major Horticulture Crops of Andhra Pradesh (Progressive Farmers Project)”, whose data will be use full for designing the Action Plan for the Department.

Responsible for information gathering and composing them into functional requirements for the application development for the developers.

Responsible for designing and proposing the new software’s useful for the Department.

Built systems using VB 6.0.

Involved in Database Designs of different Applications using Oracle 8.0, SQL Server 7.3 and MS-Access 2000 as the back-end.

Responsible for the integration of modules.

Used Crystal Reports for generating MIS Reports of the Department.

Responsible for training end-users.

Responsible for helping Finance department for preparing the Action Plan for the Year.

Used to give training on MS-Word, MS-Excel and Power-Point to the department personal through HTI (Horticulture Training Institute).

Involved in preparing the Horticulture Departments Micro Irrigation Project and AEZ presentation (Power-Point) for Chief Ministers trip to Israel with the help of McKenzie Consultants.

Developed Billing System software for Commercial Nursery.

Involved in the development of Payroll System for the entire Department.

Proposed and outlined a project for Bio Technology Centre of Horticulture Department.

Environment:

VB 6.0, ORACLE 8.0, Crystal Reports, MS-Access, SQL Server.

Education and Affiliations:

Formal Education:

Masters of Computer Applications from Bharathidasan University, TamilNadu, INDIA.

Contact this candidate