SUMMARY:

• Over 12 years of experience in Analysis, Design, Development, Production Support and Enhancements of existing systems built on .NET Framework / Windows DNA architecture.
• Strong Experience with SQL Server Management Studio and SQL Server Reporting Services.
• Excellent experience in designing/maintaining Microsoft SQL Server 7, 2000, 2005, 2008 and 2012 .
• Excellent experience in using SQL 2000/2005/2008/2012, including schemas, stored procedures and DTS packages, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Solid experience with Visual Studio.NET, VB.NET, C#. NET, ASP.NET, WCF/WWF, Web Services, AJAX, ADO.NET, VB 6.0, ASP, ADO, COM+, Visual InterDev 6.0, VB Script, Java Script, XML, XSLT, ActiveX.
• Excellent knowledge in Test Driven Development methodologies.
• Started adopting AGILE, SCRUM methodologies in recent projects.
• Strong experience in data design and working with relational databases.
• Experienced working with customers to provide complex business solutions using appropriate applications and communicates respectfully with clients, senior technical staff, and management.
• Strong experience in maintaining development and QA servers.
• Excellent experience in Developing Applications using Multi Threading.
• Excellent experience developing .NET Windows Communication Foundation Services, Web Services.
• Expertise in SSRS, MySQL, Derby, Oracle.
• Expertise in DB back - up and restore, performance/query/index optimization and DB security.
• Experience using an automated flowcharting tool such as MS Visio.
• Strong Experience with Business Intelligence reporting tools.
• Sincere, enthusiastic, hardworking with excellent communication and interpersonal skills and appetite to learn new skills
• Involved in complete life cycle of the project and experience in interacting with end users right from collecting requirements to Production Support
• Ability to take and give directions and instructions and provide assistance through completion of tasks
• Strong people management, analytical, inter-personal, communication & written skills.
• Excellent team player with problem-solving and trouble-shooting capabilities.

TECHNICAL SKILLS:

Operating Systems: Windows 10/Windows 7/Vista/Windows XP/2000/NT

Languages: ASP.NET, C#.NET, VB.NET, Visual Basic (6.0/5.0), ASP, SQL, PL/SQL

Databases/Technologies: MS-SQL Server, Oracle, MS Access

Front End Tools: Visual Studio, .NET Framework, Visual Studio.Net, MS Visio, Microsoft Front Page, MTS, XML Spy, TIDAL Software.

Reporting Tool: SQL Reporting Services, Crystal Reports

Scripting Languages: VB Script, JavaScript, HTML, DHTML, XML/XSLT

Web Technologies: ASP, ASP.NET

Middle Ware: WCF, Web Services, COM, COM +, DCOM, MSMQ

Web Servers: IIS 7.5

Configuration Management: Team Foundation Server (TFS), Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential

Information Technology Specialist

Responsibilities:

• Clients are able to pay for their children's health insurance premiums and healthcare for workers with disabilities medical premiums.
• Medical bills for clients that are injured from criminal action are repaid to the State through court ordered restitution.
• Trust funds for children are accounted for and managed.
• Services provided to deceased clients are recovered.
• Manage annual license renewal fees for adult family homes, boarding homes, and nursing homes.
• Manage annual license renewal fees for child care homes and facilities.
• Account for provider overpayments, ensuring continuation of funding for medical assistance clients.
• Upgraded and installed 113 jobs with 220 packages and 8 console applications.
• Installed 327 SSRS SQL reports
• Database migration: 10 databases (migrated from SQL 2000 to SQL Server 2008R2).

Confidential

Responsibilities:

• Involved in Core team meetings for creating system architecture diagrams, Use case diagrams, Sequence Diagrams, Class Diagrams, and Activity Diagrams.
• Using Agile development Scrum methodology
• Validations and translation logic by following SOLID design principles.
• Implemented SQL Server SSIS data migration packages
• Developing new SQL Server Reporting Services Reports
• Work on continuous system enhancements and new features requested by customers.
• Worked on database performance issues by optimizing SQL Queries, Analyzing Index Fragmentation usage.
• Used SQL Server profiler and activity monitoring for production database performance troubleshooting.
• Migrated almost 100 SQL reports from SQL server 2000 to SQL server 2008.

Environment: .NET framework 4.0/3.5, WCF, Web Services, Windows Services, Visual Studio 2008/2010/2012, SQL Server 2005/2008, ASP.NET, C#.NET, VB.NET, SSIS, SQL Reporting Services, ASP.NET MVC 3.0, JQuery, Java Script, XML/XSLT, WSE 2/3, Windows 2000/Vista/7, HTML/DHTML, ASP, COM/DCOM, MS Visio, TFS, TIDAL Software. Employer: State of Washington Department of Licensing

Confidential

Information Technology Specialist

Responsibilities:

• Redesign existing Driver letters process using windows communication foundation (WCF). Implemented separation of Drivers business functions and Driver letters validations and translation logic by following SOLID design principles.
• Used Microsoft Entity Framework Data Access technology
• Playing as a technical lead/application lead for three years long project.
• Involved in Core team meetings for creating system architecture diagrams, Use case diagrams, Sequence Diagrams, Class Diagrams, and Activity Diagrams.
• Using Agile development Scrum methodology
• Implemented SQL Server SSIS data migration packages
• Developing new SQL Server Reporting Services Reports
• Migrated Crystal reports into SQL Server Reporting Services
• Implemented Federal/State legislation requirements.
• Work on continuous system enhancements and new features requested by customers.
• Support Driver letters applications for various units of Drivers division.
• Worked on database performance issues by optimizing SQL Queries, Analyzing Index Fragmentation usage.
• Used SQL Server profiler and activity monitoring for production database performance troubleshooting.
• Involved in Design/Development of DOLLI application
• Used Microsoft Unity design patterns to implement Dependency Inversion Control principle
• Used TDD (Test Driven Development) approach
• Used Agile methodology
• Playing as a technical lead/application lead since November 2005.
• In 2009 - we rewritten the complete UCC system using windows communication foundation (WCF), VB.Net and ASP.NET from Classic ASP and VB6. Implemented separation of UCC business functions, validations and translation logic by following SOLID design principles.
• Used Microsoft Entity Framework Data Access technology
• Involved in Core team meetings for creating system architecture diagrams, Use case diagrams, Sequence Diagrams, Class Diagrams, and Activity Diagrams.
• Implemented SQL Server SSIS data migration packages
• Developing new SQL Server Reporting Services Reports
• Migrated Crystal reports into SQL Server Reporting Services
• Implemented Federal/State legislation requirements.
• Work on continuous system enhancements and new features requested by customers.
• Worked on database performance issues by optimizing SQL Queries, Analyzing Index Fragmentation usage.
• Used SQL Server profiler and activity monitoring for production database performance troubleshooting.

Environment: .NET framework 4.0/3.5/2.0, WCF, Web Services, Windows Services, Visual Studio 2008/2010/2012, SQL Server 2005/2008, ASP.NET, C#.NET, VB.NET, SSIS, SQL Reporting Services, ASP.NET MVC 3.0, JQuery, Java Script, XML/XSLT, WSE 2/3, Windows 2000/Vista/7, HTML/DHTML, ASP, COM/DCOM, MS Visio, TFS, TIDAL Software. INFOSMART TECHNOLOGIES, INC

Software Engineer

Confidential, CA

Responsibilities:

• Involved in all aspects of SDLC.
• Involved in analysis, design, development and testing COM components.
• Involved in analysis, design, development of Database and created Database Objects like tables, views, indexes, triggers, stored procedures.
• Extensively used JavaScript for front-end validations.
• Involved in developing the web pages using ASP.
• Written lengthy and critical stored procedures in SQL 2000.
• Extensively used XSLT for styling the web pages.
• Involved in Unit testing, Integration testing and System testing and documented the test results.

Environment: Windows 2000, Visual Basic 6.0, ASP, ActiveX, COM/DCOM, SQL Server 2000, IIS 5.0, JavaScript, VBScript, CSS, HTML, XML, XSLT.

Confidential , TX

Software Engineer

Responsibilities:

• Involved in gathering the requirements for both system and the end user for developing the use cases and Documented the requirements gathered from the Administrators
• Involved in analysis, design of Middle tier COM Components and back-end data base objects.
• Involved in Analysis and Design of Database and created Database objects like Tables, Views, and Indexes etc., maintaining the referential integrity rules.
• Extensively used JavaScript on front-end validations of web applications.
• Involved in Server side programming with VBScript and ASP for generating and populating the Dynamic fields on pages.
• Involved in developing and testing SQL Stored procedures and performance monitoring through the SQL Profiler
• Involved in the creation of Test Cases for Unit and Integration Testing, User testing and execute test specifications and test Cases, track bugs/issues, and report results.
• Involved in developing and testing COM Components (ActiveX DLLs) that will basically verify the modifications in questionnaire from time to time and provide corresponding answers.

Environment: Windows 2000, Visual Basic 6.0, ActiveX, ADO, COM/DCOM, SQL Server 2000, IIS 5.0, ASP, JavaScript, VBScript, HTML, XML, MS XML Parser, SSDB Grid, SSDB Combo, Mask Edit Control, Date Control, Tree View Control, and Microsoft Windows Common Controls.

Confidential

Programmer Analyst

Responsibilities:

• Involved in gathering the requirements from end users and prepared the requirement documentation.
• Involved in analysis, design of the system and prepared functional and design specifications.
• Involved in analysis, design of COM components and developed object oriented COM dll's using COM technology.
• Involved in writing lengthy and critical stored procedures.
• Improved the performance of application by monitoring through SQL profiler and conducting WAS (Web application stress test tool) stress test tool.
• Involved in Unit testing, Integration testing and documented the bugs, fixes and results.

Environment: Windows 2000, Visual Basic 5.0, ActiveX, ADO, COM/DCOM, ORACLE7.x,SQL Server 2000, IIS 5.0, ASP, JavaScript, VBScript, HTML, DHTML, XML, MS XML Parser, SQL.