Post Job Free

Resume

Sign in

Sql Server Web Services

Location:
Cincinnati, OH
Posted:
May 25, 2017

Contact this candidate

Resume:

PANKTI PATEL

Phone: 848-***-****

Email: ac0hqm@r.postjobfree.com

SUMMARY

Expertise in design and development of web applications/Windows with .NET framework using ASP.NET, VB.NET, C#.NET, ADO.NET, XML, Web Services.

Extensive experience in ASP.NET 1.1/2.0/3.5/4.0, WinForms, WebForms.

Experience in Episys in RepGen Programming.

Experienced in ADO.NET, Visual Basic, ASP, VBScript, JavaScript, ActiveX, HTML, DHTML, XML, XSL, IIS, Visual Interdev with good proficiency in Web-enabled applications.

Experience with Web development mark-up and scripting languages such as HTML, XML, XSLT, JavaScript, CSS

Experience in developing applications using ASP.NET MVC, ASP.NET Web Forms, LINQ and Windows Communication Foundation (WCF)

Experience in web technologies like AngularJS, AJAX, HTML, DHTML, CSS, JSON, JavaScript, JQuery

Experience in Object Oriented Analysis and Design (OOAD) using UML Methodology including Use Case diagrams, Class diagrams, interaction diagrams, State diagrams and deployment diagrams.

Involved in all the stages of Software Development Life Cycle (SDLC) including Requirements Analysis and Design, implementation, integration and testing, deployment, user training and support.

Excellent Experience in using scripting languages like Java Script and AJAX (Asynchronous java Script and XML).

Excellent Experience in databases like Microsoft SQL Server and Oracle.

Experienced in database development using Oracle, SQL Server, MySQL, PL/SQL.

Experience in generating Reports using Crystal Reports 10.0/ 11.0.

Experience in generating Reports using SQL Server Reporting Service (SSRS).

Experience in responding multiple requests at the same time using multithreading.

Experience in software development using various Software development methodologies including those confirming to CMMI standards.

Experience in working in onsite/offshore model and as Module lead, Team lead and Tech Lead.

Experience in Services, Financial, Enterprise, Travel, Healthcare, and Manufacturing domains.

Result oriented with an outstanding record of delivering projects on time.

Involved in Database Design including writing stored procedures.

Excellent communication, presentation and problem solving skills, with strong leadership and motivational qualities.

Worked on a single sign-on (SS0) Project to facilitate a user's ability to access multiple applications through a single session.

TECHNICAL SKILLS

.NET Technologies

Microsoft .Net Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, C#, ASP.NET, VB.NET, ADO.NET, Web Services, Windows Services, Multi-Threading, .NET Remoting and WCF, MVC, WPF

Languages

C#, C, C++, VISUAL BASIC 6.0, Java, J2EE, JSP, SQL, PL/SQL, Shell Scripting, Action Script, XML, XSL, XSLT, UML

Web

ASP, HTML, DHTML, XML, VBScript, JavaScript, AJAX, Atlas, Web Services, AngularJS, JQuery

Reporting Tools:

Crystal Reports, SQL Seerver Reporting Services 2000, 2005, 2008, 2012 (SSRS).

Application Server:

IIS 5.0,6.0,7.0, Apache Tomcat, MS Commerce Server

Tools and IDE’s:

Visual Studio.NET, Macromedia Dreamveawer MX, Flash MX, MS VISIO

Operating Systems:

Windows, Window Server, UNIX.

Database:

MS SQL Server 2000/ 2005/ 2008/ 2012, Oracle 8i, 9i, 10g, Access

Others:

BizTalk Server 2004, SharePoint, MQ Series, MSMQ, MS Dynamics CRM

PROFESSIONAL EXPERIENCE

.Net Software Developer, Thinkware Inc., Cincinnati, OH, October 2016 to Till Date

ThinkWare is the leading provider of software for the Professional Employer Organization (PEO) and Administrative Services Organization (ASO) industry.

Responsibilities:

Fix issues or enhance functionality on solutions with one or more of ASP.NET, MVC, HTML, CSS, JavaScript, .NET/C#, AJAX, Angular JS, SQL Server

Participate in an Agile Development Methodology

Responsible for quality of applications

Worked on Telerik Extensions for ASP.NET MVC

Apply experience and vision to create innovative solutions while simplifying and optimizing processes and operations

Create WCF services for data exchange

For front end development actively used ASP.Net, CSS, JavaScript, AJAX control and Telerik Controls

Used MS Team Foundation Server to maintain and versioning the code

Environment: Visual Studio 2013, ASP.NET 4.5, C#, MVC, HTML, Web Form, VS.NET, IIS, CSS, AJAX, Java Script, JQuery, Angular JS, Telerik Controls, Windows Services, WPF, SQL Server 2012, SSRS, TFS

Sr. Programmer, Macy’s Systems & Technology, Cincinnati, OH, March 2015 to Sep 2015

Macy’s is one of the nation’s premier retailers. Macy’s operates more than 800 Macy’s department stores and furniture galleries and also operates Bloomingdale’s stores as well as distinctive online shopping at macys.com and bloomingdales.com. Primary responsibilities involve conversion of more than 200 reports from Micro strategy TO SSRS 2012 report servers, creating, deploying and maintaining reports.

Responsibilities:

Analyzing and creating business intelligence reports, matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports in SSRS according to business requirements using complex formulas.

Development of custom scripts and stored procedures for data import and manipulation in Oracle Pl/SQL.

Extensively working with Dynamic SQL, Composite data types and Global Temporary Tables.

Developing PL/SQL Packages, Procedures, Functions, Views, Triggers, Cursors, scripts accordance with Business Requirements for loading data into SSRS Reports.

Consolidating existing Micro Strategy reports to SSRS reports without losing the functionality.

Generated multi parameterized reports in MS SSRS allowing users the ability to make selections before executing reports; thus making them user friendly.

Designed and developed a full-scale reporting solution using Oracle and MS SSRS.

Created and implemented a reporting suite of over 200 reports while also customizing many reports to meet individual client needs.

Involve in the complete life cycle of the project, from planning stage and pushing the codes to production.

Creating parameterized reports using Charts, Cross-Tab and Sub-report types.

Configure and train users to use Reporting Services.

Responsible to support the issues with reports on the enterprise environments like development, test and production.

Develop logical and physical database models.

Create joins and sub-queries for complex queries involving multiple tables.

Manage documents on SharePoint portal.

Participate in team meetings, conferences and problem solving discussions.

Environment: ASP.NET 4.5, C#, HTML, Web Form, VS.NET, IIS, SQL Server 2012, SSRS, Oracle 11g, Micro strategy, Oracle SQL Developer, Microsoft Visual Studio

Lead Application Developer, Messer Construction, Cincinnati, OH, Mar 2014 to Jan 2015

Responsible to create, enhance and maintain prototype and production-level object-oriented applications throughout software development lifecycle; including requirement gathering, design, modeling, coding, implementation, testing, documentation and maintenance. Develop, maintain and responsible for all stages of SDLC for applications such as yard costing application which is an inclusive process for managing and coding yard charges each month. Analyze business, functional, and technical requirements to make sure applications meet expectations.

Responsibilities:

Involve in all the phases of Software Development Life Cycle (SDLC) from Software Requirements Analysis Phase to Design, Development, Testing, Integration, Implementation (UAT & production) and Maintenance.

Designing Web-based ASP.NET applications linked to firm-wide SQL databases.

Creating custom site pages, lists, views and master pages and adding ASP, Silverlight controls.

Using HTML, JavaScript, JQuery and AJAX for developing Controls and web forms in Software.

Define documented business requirements by working directly with end users.

Working with Ajax enabled WCF services using C# and ASP.Net.

Extensively using Grid Views with sorting, paging, implement template columns for custom nested Grid Views, dynamic generation of rows, user input inside template columns. Use Edit Item-Templates and Footer Templates extensively for editing and adding rows.

Create standard CSS file to make fields look similar across the application.

Using Dataset, Data View and Data Adapter to manipulate and display data.

Create complex Stored Procedures, Triggers, Views and Functions using SQL Server.

Design and review Oracle Forms application architecture; analyze software development process.

Using AJAX in different ways to avoid full page post-back and make the application more users interactive.

Using Grid views, Repeater controls, and Validation controls extensively during development.

Develop different kind of reports with different level of complexity reports, sub reports, charts, matrix reports, linked reports using SSRS.

Facilitate problem solving and collaboration

Work on exporting reports to Excel from Gridviews and Ultrawebgrids.

Responsible for Deployment of Application on Test and Production Server

Move the business logic and complex mathematical calculations from UI layer to SQL Server.

Design Custom classes for Data Validations, exceptional handling and logging.

Environment: ASP.NET 4.5, C#, HTML, Web Form, VS.NET, IIS, CSS, AJAX, Java Script, JQuery, XML, XSLT, Web Services, WCF, SOAP, SOA, SQL Server 2012, SSRS

Application Developer, Wright-Patt Credit Union, Dayton, OH, Apr 2009 to Jan 2014

Responsible to develop, program and provide support for new and existing applications for members, employees that include the online banking platform, online applications, mobile applications, intranet, and other key applications and programs. Lead as well as responsible for online banking bill payment application. Worked on daily, weekly, monthly and ad-hoc reports from the data warehouse made available via the intranet and from the core system and made available via the Episys for use by all departments and levels of managements. Developing interfaces to Symitar for .Net/C# environment. Provide 24/7, on call, remote support for critical systems uptime. Worked on RepGen programming for Episys.

Responsibilities:

Responsible for development of all production corporate applications, internal and external.

Provide more immersive user experience by leveraging better UI techniques including ASP.NET controls, AJAX, JavaScript, JQuery, MVC, HTML

Acted as lead developer for online banking BillPay application. Responsible for to fix all issues, enhancement and daily bill pay process on online banking.

Successfully refactored BillPay agent job using .Net, C#, SQL Server and Symitar Services.

Responsible to discuss, understand and determine business requirements and provide possible solutions.

Routine handling of support requests for enhancements, bug fixes, and production maintenance.

Experience in design and provide daily, weekly, monthly and ad-hoc reports from the data warehouse SSRS.

Used XML and XSLT for Transferring Data.

Worked on application development using ASP.NET MVC 3.0/4.0 Framework.

Using, coding and re-coding RepGen reports that will allow other products to interface with Symitar bank host systems

Developed different themes, CSS files and utility modules to maintain the web sites.

Acted as lead for migration of all SSRS Reports from SQL Server 2005 to SQL Server 2008.

Responsible to provide support for all online Banking application issues as well as lead for several online Banking applications.

Custom and use Web Services to implement authentication and security.

Providing the core concepts and devised the framework.

Modeling the flow of data and devised the development plan.

Providing complete support and enhance to the web application using PHP and MySQL.

Used VSS, SVN, TFS for Source Control and version management.

Environment: ASP.NET 1.1/2.0/3.5/4.0/4.5, C#, VB.NET, MVC Framework, HTML, Web Form/Win Form, VS.NET, IIS, CSS, AJAX, Java Script, JQuery, XML, XSLT, Web Services, WCF, SOAP, SOA, SQL Server 2000/2005/2008/2012, SSRS, SSIS, DotNetNuke, SiteFinity, Symitar, RepGen, Episys, Windows Servers, SVN, PHP, PHPMyAdmin, MySQL, Drupal, VSS, TFS

Sr. Software Developer, Excellence in Motivation, Dayton, OH, Dec 2007 to Feb 2009

EIM (Excellence in Motivation) is a software development company which develops web applications for its various clients. Developed applications that streamline business processes. Work with existing legacy applications to convert, extend and enhance functionality. Developed application for client which provides functionality to claim different products by sales representatives and get rewards based on program, promotion in their prepaid card. It also supports to create different promotions with different features. The application also provides functionality to program admin of creating a recommended configuration and extract files and reports in XML format. Involved in all phases of Software Development Life Cycle (SDLC).

Responsibilities:

Developed ASP.NET pages using C# .NET as server code and IIS as the web server.

Web Application Design including flow of information and making a decision of various forms, controls and data objects to be used for aesthetic and efficient performance.

Used XML Web Services to retrieve the relevant information from various sources. XML and SOAP was used to exchange the information over the network.

Involved in development of 3-tier Architecture.

Worked on development of to create promotion as per business requirement and provide online gift awards based on eligibility.

Using T-SQL, created stored procedures, functions, views for accessing and managing data.

Created various reports using SQL Server Reporting Services 2005 (SSRS).

Used editable Data Grid controls to display and edit the requested information.

Created DLLs to implement business logic and to integrate the application.

Ease of maintenance was assured with consistent use of web.config file.

Designed and developed necessary database connection classes.

Implemented state management using session, query string, cookies and view state.

Extensive use of ADO.NET objects like Data Sets, Data Tables, Data Reader, Command and Connection objects, Data Grid, Data list and Repeater objects.

Created client and server side validation using JavaScript and ASP.NET input validations controls.

Maintained the state of session objects, created dynamic menu, used session management.

Thoroughly unit tested various modules of the system and fixed the bugs.

Handle the collection request.

Maintenance and support for the products as per the client’s requests.

Used MS Visual Source Safe for Source Control and version management.

Developed routines to create XML configuration file programmatically.

Environment: ASP.NET, C#, Web Forms, ADO.NET, XML, Web Services, SQL Server 2005, IIS Admin, VS.NET 2005, OOP, OOAD, CSS. SQL Server Reporting Services (SSRS), Java Script, Share Point, Windows Servers, Active Directory

EDUCATION:

Master of Computer Applications, S.P. University, India

Bachelor in Computer Science, S.P. University, India

REFERENCES:

Provided upon request.



Contact this candidate