Post Job Free

Resume

Sign in

Sql Server Crystal Reports

Location:
Austin, TX
Posted:
February 23, 2016

Contact this candidate

Resume:

Professional Summary:

* ***** ** ******** *********** experience in .NET platform with comprehensive skills in all the phases of SDLC including planning, analysis, design, development, testing and support.

Extensive experience in DMV, Manufacturing and Healthcare domains.

Strong hands on experience on the Microsoft .NET Framework 4.0/3.5/3.0/2.0 developing Web Applications using ASP.NET, ASP.NET MVC, C#, VB.NET, ADO.NET, IIS 7.0/6.0, AJAX, JavaScript, jQuery, HTML, XHTML, XML, XSLT.

Extensive experience in applying Object Oriented Analysis and Design (OOAD) to develop N-Tier applications following SOLID principles.

Experience in creating complex Stored Procedures, Functions, triggers, cursors, tables and views in SQL Server and Oracle.

Expertise in developing and consuming SOAP and REST based WCF services and Web Services.

Experience in developing reports using SSRS.

Proven ability to work independently and as a part of a team with an ability to deliver within short deadlines. Ability to rapidly adapt to new concepts and apply them effectively; innovative problem solving skills.

Technical Skills:

Programming Languages

C#.NET, VB.NET, C, C++, T-SQL, PL/SQL, Java

Internet Technologies

ASP.NET MVC, Web Forms, WCF(SOAP/REST), AJAX, Web Services, IIS

Scripts & Mark-up

HTML/XHTML, JavaScript, jQuery, XML, XSLT, CSS, VBScript

Databases

MS SQL Server, Oracle, MS Access

Database Concepts

ADO.NET, LINQ, .NET Entity Framework, NHibernate

Source Control

MS Team Foundation Server (TFS), Visual Source Safe (VSS), Perforce

Reporting Tools

SSRS, Crystal Reports

Testing/Debugging

NUnit, SoapUI, Firebug, FireCookie, Fiddler, Firefox/Chrome developer tools

Professional Experience:

New Indy Container Board Oct 2014 – Till date

Programmer Analyst

Webmethods Replacement

Responsibilities:

Study the existing programs and analyze the impact.

Design & Code Trims to MESA Interface

Design & Code Customers to MESA Interface

Design & Code Bill Of Lading Interface

Design & Code CASS Interface

Design & Code Order Reconciliation Report

Design & Code Vendor Extract to MESA

Created an FTP module to send and receive files from MESA and other systems

Coordinate with users to Test all possible Test Scenarios.

Proactively worked on job monitoring stuff. Informed respective business in-case job failures/abends and provided permanent resolutions.

Responsible for upgrading the changes like error handling from timely basis.

Created Documentation so that client support team can manage the ongoing support.

Environment:

Visual Studio 2013, SQL server 2012, TFS, Visio 2003.

optStudio Interface

Responsibilities:

Study the existing programs and analyze the impact.

Design & Code Customers to optStudio Interface

Design & Code Orders to optStudio Interface

Design & Code Trims to optStudio Interface

Coordinate with users to Test all possible Test Scenarios.

Proactively worked on job monitoring stuff. Informed respective business in-case job failures/abends and provided permanent resolutions.

Responsible for upgrading the changes like error handling from timely basis.

Created Documentation so that client support team can manage the ongoing support.

Environment:

Visual Studio 2010, SQL server 2008 R2, TFS, Visio 2003.

Software Labs Ltd, Rose Hill, Mauritius Jun 2006 – Dec 2010

Role: Software Engineer

Projects/Accomplishments:

Billabong Group of Companies, Mauritius

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.

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.

Environment:

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

South East Asian Bank Ltd., Mauritius

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.

Coralia Mont Choisy Hotel, Mauritius

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.

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, etc.,

Provided Post-Production support.

Environment:

VB 6.0, ADO, SQL Server 2000, Microsoft Visio 2003, Windows 2003, Crystal Reports 8.5, Help Scribble, VS InterDev.

Education and Affiliations:

Formal Education:

Bachelor of Engineering, Andhra University, A.P, INDIA.

Certifications:

MCTS: .NET Framework 3.5, ASP.NET Applications



Contact this candidate