Resume

Sign in

Sql Server .Net c#

Location:
Lombard, Illinois, United States
Posted:
March 02, 2018

Contact this candidate

Resume:

SUMMARY

Over * years’ working experience in full cycle software development in a dynamic collaborative environments working on multi-tiered web applications, web services, WCF services and client-server technologies.

More than 7 years of experience with RDBMS systems such as SQL Server, Oracle and Microsoft Access, methodologies like OOAD, object/data modeling.

Over 6 years’ experience in leading the development, migration testing, unit testing, integration testing and support phases of custom applications.

Worked with large amounts of data to find trends and areas for improvement

Database and web-server set up, configuration, designing database, normalization of database

Comprehensive grasp of development tools including CSS, XML, DHML, XSLT, C#, ASP.NET, VB.NET, ASP, Visual Basic 6.0, Web-parts, Win forms COM,HTML, Java Script, VB Script

Experience with writing Use Case specifications and developing Work Flow diagrams.

Worked cross-functionally with other internal departments such as Finance, Fulfillment, Development, Manufacturing and IT, as needed

Hands on experience in realization of complete software life cycle using OO techniques, design and development of Client-Server and distributed N-tier Web based applications, distributed systems and functional programming strong troubleshooting and problem-solving skills. SQL server admistration, tuning and optimization

Technical responsibilities include project lead, design and development of applications and databases, integration of different modules, unit/integration/system/regression testing, implementation into pre-production and production, understanding the architecture and network, documentation and software configuration management of enterprise-wide projects on Microsoft Web and Client/Server technologies.

Success in continuing professional development – received Industry Recognized Certifications in ASP.NET and C#

Participate in scrum, sprint planning, mentoring

Collaborating with product owners, external vendors, developers, and others in analyzing complex business requirements and breaking them down into measurable and implementable user stories

Adapting existing code to include unit or integration tests

Providing or facilitating software support to customers, both internal and external, as needed

Strong team player with excellent management, interpersonal, analytical and communication skills

Ability to work in a team environment and/or directly with client

Proficiency in technical design, analysis, debugging, profiling and developing applications and RESTful web services

Experience delivering results on Agile Projects

CERTIFICATIONS

Brain Bench Certified- Transcript ID# 6451377

ASP.NET: Scored higher than 95% of all previous test takers. Score 4.07

C# : Scored higher than 88% of all previous test takers. Score 3.85

Implementing a SQL Datawarehouse

EDUCATION

Master of Computer Applications at Manipal Institute of Technology, India

TECHNICAL SKILLS

Web Technologies: ASP.NET 3.5, ASP.NET 2.0,ASP.NET 1.0, VB.NET, C#, XML Web Services, Web forms, Win forms, Framework 1.x/2.0, Visual Studio 2010, 2012, Visual Basic 6.0, C, C++, HTML, DHTML, VBA, VB Script, SOAP, Anthem.net, Ajax, JavaScript, ASP, XML, and XSLT

Databases: SQL Server 2000, SQL Server 2005, SQL Server R2, MS-Access 2000, Oracle8i/9i, T-SQL, PL/SQL

Connectivity: ADO.NET, ActiveX, COM, ODBC

Web/Application Servers: IIS 5.x/6.0, MSMQ

Reporting: Crystal Reports, Oracle Reports 6i, Data Reports, Business Objects 5.0

OP System: Windows NT/2000/2003, Windows XP, UNIX

API/Protocols: HTTP, HTTPS, TCP/IP, SMTP, FTP

Tools: Visual Studio.NET, Oracle Forms 6i, InRule, Sync fusion, Visio, VSS, SVN, VS Team Explorer, Cruise Control.net, JIRA, TFS, MVC, Microsoft Project, Basecamp, Dropbox, Active Directory

PROFESSIONAL EXPERIENCE

Employer: Insurance Auto Auctions Nov 2009 – April 2014

Title: Senior Developer

Projects: Windows Services and applications for a SOA, Windows Services, Restful Services and database redesign for mobile applications, content management applications

Environment: ASP.NET,C#, MVC, VB.NET, SOA, Visual Studio 2005,DNN, Visual Studio 2010, Visual Studio 2012, ADO.NET, COM – Excel Interop, JavaScript, XML, XSLT, Visual Source Safe, SQL Server 2000/2005, Visio 2000, IIS 6.0, Cruise Control, Silver light, PGP, WinSCP, FileZilla, Notepad++, XMLNotepad, BaseCamp, GitHub, HTML5, ETL

Responsibilities:

Designed, developed, deployed and tested real time applications using SCRUM design pattern for iphone android and ipad applications used by business stakeholders. The IAA Buyer App for the tablet is a finalist in the Best Customer App category of the 2014 CITE Awards program which makes searching for vehicles on the auction block even easier for buyers

Re-design an existing comprehensive database to accommodate the mobile application related changes in distributed data system.

Implemented integrated payment processing systems using Bluepay

Close interaction with onsite, remote and offshore teams simultaneously to accomplish completion of projects in timely fashion

Designed, developed and deployed real time windows services and applications for clients like Geico, Farmers, Chrysler, AFC and All State

Designed and developed windows services to interact on a daily basis with salesforce CRM

Design, develop and deliver in-house automated reports sent out to the corporate leadership team regarding important financial milestones

Plan, design, and implement application database code objects, such as SQL jobs, stored procedures and views. Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Provide database coding to support business applications using SQL Server

Extensive experience in managing and developing applications using MS technologies

Enterprise application integration, utilizing analysis/design, internet/intranet development, database design and development, data migration and GUI.

Software Integration testing, recovery testing, inter-operability testing, migration testing, installation/backout testing.

Review and provide feedback to written proposals documenting requirements, functional design, and estimates.

Establishing and maintaining excellent business relationships

Requirements Gathering, Analysis, Design, Development and Testing

IT Development/Business Alignment

Usability and Quality Assurance

Ability to multi-task and keep project requirements organized and on-track.

Resolve questions and issues between Sales, Customers, Quality Assurance Team and the development team.

Client: Independent contractor for multiple clients including HR Plus Feb 2008 – Oct 2009

Title: Lead Developer

Projects: Web based real-time E-commerce applications for multi-cultured projects

Environment: ASP.NET 2.0, ASP.NET 3.5, C#, Web-parts, SOA, Visual Studio 2005, Web-forms, Win-forms, ADO.NET, COM – Excel Interop, JavaScript, XML, XSLT, Business Objects 5.0, Visual Source Safe, SQL Server 2000/2005/2008, Visio 2000, Ajax, IIS 6.0, Cruise Control, MS Project, Jira

Responsibilities:

Designed, developed and deployed real time web based applications in diversified work cultures, combining technical expertise with solid management and interpersonal skills.

Extensive experience in managing and developing applications using MS technologies including web parts, web services.

Enterprise application integration, utilizing analysis/design, internet/intranet development, database design and development, data migration and GUI.

Consulting, Enterprise Application Design and Development, Software Integration and testing, SOA

Review and provide feedback to written proposals documenting requirements, functional design, and estimates.

Establishing and maintaining excellent business relationships

Requirements Gathering, Analysis, Design, Development and Testing

IT Development/Business Alignment

Usability and Quality Assurance

Conduct project planning and project management activities.

Ability to multi-task and keep project requirements organized and on-track.

Assist in developing prototypes of application screens, panels, and reports.

Assist in test case preparation and reviews.

Resolve questions and issues between Sales, Customers, and the development team.

Title : Lead Developer

Client: BP AMOCO, Warrenville, IL Oct 2007 – Feb 2008

Projects: DOX, RFS, Daily Notes

Environment: ASP.NET 2.0, ASP.NET 3.5, C#, Web-parts, SOA, Visual Studio 2005, Web-forms, ADO.NET, COM – Excel Interop, JavaScript, XML, Business Objects 5.0, Visual Source Safe, SQL Server 2000, Visio, Ajax Extenders, IIS 6.0, Cruise Control

DOX is a web based application that tracks the changes of a trading agreement between counter parties regarding key credit, business and legal terms. This system is used to prioritize documentation work in progress; track documentation negotiation status; track specific actions requiring follow up action (pending action log report/tickler) and generate reports to senior management as well as credit and front office regarding key credit, business and legal terms

Daily Notes is a content management application. It leverages the features of ASP.NET 2.0 like web parts management, user authentication and personalization. In addition, the administration module allows the site administrator to extend the web sites in terms of providing a personalized dashboard that includes personalized reports customized to a particular user. This framework was first implemented for an internal portal of the clients trading floor.

RFS (Renewable Fuel System) consists of tools and reports that allows to generate weekly, monthly, quarterly and yearly reports that are sent to the EPA (Environment Protection Agency).

Responsibilities:

Developed the security module that enabled personalization of the web-parts

Designed a personalized dashboard for the user using web-parts

Developed role based customized navigation structure for a site using sitemap

Generated code that performed direct parsing and tokenizing of XML using XMLTextReader

Created custom data movement solutions tailored to the specialized needs of the organization by using stored procedures in SQL Server 2000

Generated reports that were exported to excel in a specified format using COM – Excel Interop

Designed the interface and the code behind that enabled the user to manually upload excel documents which were transferred to the SQL Server database

Database design, configuration, normalization and migration of large amounts of real time data using SQL Server 2005 and SSIS.

Used Visio to develop detailed DB Model diagrams, process flow diagrams and perform reverse engineering.

Conducted various reviews with business and technical groups to verify the user requirements with onsite and offshore technical teams

Improved the efficiency of data transfer by 60% by optimizing the business objects reports

Translated specifications and gathered user requirements using agile methodology

Client: Alcatel-Lucent, Lisle, IL May 2007 – Sept 2007

Title: Senior Software Developer

Project: Tools for Application Model Engineering (TAME)

Environment: ASP.NET 2.0, C#, Visual Studio 2005, ADO.NET, Web forms, Win forms, Oracle 9i, Web Services, JavaScript, XML, VB Script, Visual Source Safe, SQL Server 2005, Visio 2000, Sync fusion, IIS 6.0, Crystal Reports XI

TAME project is a global initiative to address problems currently being experienced in the LWS Engineering Configuration workspace. Engineering is continually being challenged to: deliver services more rapidly, reduce the cost and redundant data entry required to process orders, and provide a centralized tool set to eliminate the proliferation of locally maintained spreadsheet-based job aids. This application provides a primarily web-based front end to the system addressing this problem. The subsets of the solution are client applications well integrated into the web interface via Click Once. The Site Survey tasks along with a subset of the Specification Generation task are performed at customer sites using an un-tethered PDA.

Responsibilities:

Performed effective data processing by writing stored procedures for all Data Processing in Data Access layer using SQL Server 2005. Performed a nightly reference check against SITE’s snapshot of GPDB across the system’s orderable items to ensure all data is valid.

Designed and coded the admin tool that interacts with the corporate systems using C# and .NET

Improved performance by caching selected data structures

Utilized click once to allow user to automatically access the recent version of the application

Automated the report generation and allowed a set of predefined reports to be generated from data in SITE and the TAME database using Crystal Reports

Conducted various reviews with business and technical groups to verify technical design documents, team review meetings with onsite and offshore technical teams

Used Visio to develop detailed DB Model diagrams, process flow diagrams.

Database enhancements, normalization and migration of large amounts of real time data using SQL Server 2005 and SSIS.

Performed system testing, integration testing and regression testing using over 800 pre-set test cases

Conducted end user acceptance testing (UAT), process mapping and workflow diagramming

Successfully trained the end-user on the use of application

Client: International Association of HealthCare Central Service Materiel Management (IAHCSMM), Chicago, IL

Dec 2006 – May 2007

Title: Lead Developer

Project: HealthCare Service Management Tool

Environment: ASP.NET 2.0, C#, Anthem.NET, Visual Studio 2005, Web services, ADO.NET, Web Services, JavaScript, XML, Visual Source Safe, Oracle, Visio 2000, IIS 6.0, Crystal Reports XI

This is a web application that is coupled with an e-commerce website for information exchange. It provides member services in response to member identified needs and priorities; and represents Central Service Materiel Management in the professional community using ASP.Net 2.0 as the web interface and the SQL Server 2005 as the data layer. This application enables an authorized user to obtain information of a person belonging to particular category -- members, exhibitors, meetings, instructors and course, and to view membership details, courses taken, course performance details, instructor/roster information, active member administration and archived records. Archived records track the history of eligible members. The application handles online payment process by integrating with third party tools thus processing real time information.

Responsibilities:

Significantly increased the efficiency and performance of the organization by automating exhibitor, member, instructor, meeting and course information processing

Designed and coded the payment flow that integrated with third party tools like authorize.net using Web Services

Used Visio to develop detailed DB Model diagrams, process flow diagrams.

Created user-interfaces using cross-browser AJAX toolkit Anthem.NET, ASP.NET 2.0, JavaScript and CSS

Implemented and created SQL stored procedures and queries in Oracle

Designed ASP.NET web forms using ASP.NET user controls, dynamic ASP.NET server controls and Generic Html controls for the presentation layer using C# in the code behind

Deployed the project on the server using VS.NET web setup project

Automated the report generation using Crystal Reports XI to track the various tasks based on user requirements. Generated over 60 reports and sub reports

Translated specifications and gathered user requirements using agile methodology



Contact this candidate