Post Job Free

Resume

Sign in

Software Developer Sql Server

Location:
East Lansing, MI
Posted:
May 18, 2020

Contact this candidate

Resume:

Summary

* ***** ** ********** ** Software Development Life Cycle (SDLC) implementation: requirements gathering, development, design, testing, deployment and maintenance.

Expert knowledge of Enterprise Application, Service Oriented Architecture development using .NET framework in the areas of performance, security, scalability and extensibility.

Experienced in writing complex Stored Procedures, Queries and Views using SQL Server and Oracle.

Extensive experience working with international teams to develop, share and improve testing strategies.

Participate in requirements gathering and scope estimation meetings.

Ensure code and design meets specifications, quality standard, and is maintainable

Maintained professional and technical knowledge by attending educational workshops, review professional publications.

Excellent team player and ability to manage multiple tasks in a pressured environment.

Ability to identify and resolve issues on a time sensitive basis.

Technical Skill Set

Language

C, C++, Java, Net2008/2010(C#, VB, ASP.NET3.5/4.0, ADO.NET),

HTML/HTML 5, CSS/CSS3, XML, XHTML, PHP, SQL, Java Script, jQuery,

VB Script, AJAX, MVC5, Bootstrap 3, Bootstrap 4, Angular

Databases

Oracle 11g/10g/9i, SQL SERVER 2014/2016/2017/2019, MySQL,

Sybase (SQL Anywhere), DB2, Teradata, SQL Navigator, Toad.

Operating Systems

UNIX, Windows NT / 2000 / 2003/XP/Vista/Windows 7, Linux

Browser tools

Firefox, IE, Safari, Google Chrome

Modeling Techniques

UML, ER Diagrams (Microsoft Visio, Rational Rose)

Packages / Tools

MS-Office, Adobe, Subversion (SVN), Team Foundation Server,

Dream Weaver, Apache Tomcat, IIS, Eclipse, Entity Framework

Microsoft Visual Studio 2008/2010/2013/2017/2019, Net beans, Photoshop,

CVS (Concurrent Versions System), Apache Ant, Crystal Reports, Atlassian JIRA,

SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS),

SQL Server Analysis Services(SSAS)

Professional Summary:

State of Michigan Department of Technology, Management and Budget (SOM-DTMB)

Software Developer (Contractor) October 2014-Present

Lansing, MI

Michigan National Guard State Tuition Assistance Program (MING-STAP)

Responsibilities:

Develop and deploy the Michigan National Guard State Tuition Assistance Program (MING-STAP) website that allows Army National Guard and Air National Guard to access and submit the required documentation to the appropriate agencies and personnel for tuition assistance.

Used MVC5, Bootstrap, CSS3, HTML5, JQuery to perform dynamic Web Form designs, validations in the front end (View).

Developing JavaScript to make Ajax calls with JSON data to pass the data from View to Controller or to fetch the data from Controller to View.

Developed Service Reference using WCF in Controller to communicate with Data Access Layer (DAL) to fetch or insert information into SQL SERVER 2014.

Developed tables, Stored Procedures in SQL SERVER 2014 to store the information, retrieve information.

Developed Selenium Test Cases to perform Integration Testing.

Environment: ASP.NET 4.5, C#, MVC 5, HTML 5, CSS3, JavaScript, jQuery, Bootstrap 3, Selenium, Microsoft Visual Studio, .Net framework 4.5, ADO.NET, SQL SERVER 2012, Subversion, Agile Scrum Methodology, Rest(HttpGET,HttpPost), JSON, WebApi, Ajax, Subversion (SVN) ),SQL Server Reporting Services(SSRS),IIS,COM

Michigan Integrated Veterans Environment of Technology (MIVET)

Responsibilities:

Develop and deploy MIVET Portal that allows both Veteran Homes at Grand Rapids and Marquette Michigan to combine the activities happening in their respective Homes under one Website

Designed the website to support the Features which include Volunteer Registration, Infection Control, Cemetery Planning, Document Repository, Policies and Procedures, Lost and found, Pharmacy tracking, HR Personnel etc.

Environment: ASP.NET 4.5, C#, MVC 5, HTML 5, CSS3, JavaScript, jQuery, Windows Service, Bootstrap 4, Selenium, Microsoft Visual Studio, .Net framework 4.5, ADO.NET, SQL SERVER 2014, Subversion, Agile Scrum Methodology, Rest(HttpGET,HttpPost), JSON, WebApi, Ajax, Subversion (SVN),SQL Server Reporting Services(SSRS),IIS,COM

HBO Latin America Software Developer (Contractor) Feb 2014-Sep 2014

Miami, FL

PASEO Admin Tool

Responsibilities:

PASEO is HBO channel network providing services to Latin Countries via affiliates like Cable Onda, Mega Cable, DirecTV etc.

Developed administration tool for PASEO where new affiliates are incorporated for HBO Latin America

Front end of the site is developed using Bootstrap, HTML 5, CSS, JavaScript, jQuery

Involved in creating stored procedures that involves channel data, affiliate data using SQL Server 2010

Created Business Access Layer, Data Access Layer and used LINQ to retrieve data from SQL Server 2008.

New Affiliate is added in three options: by URL, by file upload or manual.

Developed C# code to parse and retrieve XML data contained in URL, file upload and validate them against Schema created to ensure data is well formed XML

Populating Grid View with Affiliates which can be deactivated by Admin depending on the requirement.

Development of (Test Driven Development-TDD) Unit Testing, Integration Testing (test cases).

Developed front end UI (User Interface) for the PUMA website to display the history/logs of website using MVC5 (Model View Controller)

Participated in Agile Scrum methodology to plan Tasks, Sprint deliverables, requirements breakdown etc.

Environment: ASP.NET 4.5, C#, HTML5, CSS, JavaScript, jQuery, Bootstrap, MVC, Microsoft Visual Studio 2013, .Net framework 4.5, ADO.NET Entity Framework, SQL SERVER 2010, Subversion, Agile Scrum Methodology, Test Driven Development-TDD

United Airlines Software Developer (Contractor) Sep 2012-Jan 2014

Houston, TX

Marketing Insight Project

Responsibilities:

Reports provide sales with the ability analyze and respond to corporate customer experiences including but not limited to service events, on-time data, upgrades and membership; augmenting the customer relationship, understanding customer values and addressing extraordinary events expeditiously.

Generating Excel reports by populating a Grid view for Macros defined inside Teradata database using ASP.NET, C#.

The excel reports contain Customer details, Baggage details, Corporation details, Mileage Plus frequent flyer program.

Designing Macros inside Teradata database that holds multiple SQL statements

Redesigning front end of the Marketing Insight UI using HTML, CSS, JavaScript, JQuery, Ajax.

Used WCF to communicate between DAL and other business components.

Developed Data and Fault Contracts using WCF.

Debugging and fixing the errors inside Marketing Insight web pages.

Environment: ASP.NET 4.0, C#, Teradata, HTML, CSS3, JavaScript, jQuery, WCF, Microsoft Excel, Microsoft Visual Studio 2010, .Net framework 4.0.

Universal Air Travel Plan (UATP)

UATP is the low-cost payment network privately owned by the world's airlines. A modern payment system with connectivity to over 95% of all ASK's, UATP is the preferred form of payment for corporate travel in large international companies and small local companies worldwide.

Responsibilities:

Developed C# code for generation of Statement Detail and Statement Summary PDF report documents using PDF sharp web service.

Converted PDF files to text files using PDF stripper to extract information from PDF documents.

Parsing through PDF documents and extracting the content of PDF documents using C#.

Populating web forms with data from Stored Procedures developed in SQL Server 2008.

Developed PDF and Excel reports for UATP using Crystal Reports.

Environment: ASP.NET 4.0, Microsoft Visual Studio 2010, C#, PDF Sharp, PDF Stripper, HTML, CSS, JQuery, JavaScript, Microsoft SQL Server 2008, Crystal Reports.

Carnival Cruise Lines Software Developer (Contractor) Feb 2012-Aug 2012

Miami, Florida

Bon Voyage Ticket Manager

Responsibilities:

The application belongs to the front-end tier, built in .Net Framework 4.0. The Database is in SQL Server 2000 or 2005 (based on ship).

The application makes use of Crystal Reports 11.0 to preview the tickets and send them to the printer.

Developed webpage layouts for Bon Voyage Ticket Manager website using ASP.NET 4.0, VB.NET, HTML, JavaScript

Created Business Logic Layer & Data Access Layers to implement the MVC architecture.

Supported the application on a nightly basis by running OPCON Job to dispatch dining files from Unix to the ship incase if the dining reports are not received by the cruise by restarting the Populate Ticket Web Service, unlocking databases in case if the Bon Voyage Ticket Manager is down

Environment: ASP.NET 4.0, VB.NET, HTML, JavaScript, Ajax, SQL Server 2005/2000, MVC, crystal reports, Microsoft Visual Studio 2010, .Net framework 4.0

Innovative Solutions Group Software Developer June 2010–Jan 2012

Arlington, VA

USDA (United States Department of Agriculture) is our client

Flaming Gorge Development project (E permitting)

Responsibilities:

Flaming Gorge is a National Recreation Area close to Utah.

Designed Print Ticket layout forms for Outfitters, Shuttle trip and High-Country reservoir permits using ASP.NET, VB.NET, HTML

Created backend database to contain details regarding User permits, User profile information, Guides Information, Administrator information using SQL ANYWHERE.

Involved in Designing of security for WCF End Points and designing WCF based Service, Data, Fault and Message Contracts.

Created stored procedures for the designing reports like Shuttle report, Trip Summary.

Used Subversion as version control software to upload, download latest project information.

Environment: ASP.NET 4.0, VB.NET, SQL Anywhere (SYBASE), HTML, Subversion, JavaScript, WCF, Microsoft Visual Studio 2010, .Net framework 4.0

Mobile Computing (Field Data Automation (FDA-MC))

Responsibilities:

Worked on Mobile Computing which deals with conducting field implementation of a mobile computing device and software package to support Ranger District field processes.

Designed electronic forms for field data capture and retrieval and decision support capability.

Designed GPS code that retrieves GPS (Latitude and Longitude coordinates) that are used by Forest Services to know whereabouts of location and to conduct surveys.

Designed Camera code using Screen Capture Methods that are used by Forest Services to take pictures of areas while conducting surveys.

Designed database schema, tables and stored procedures using SYBASE SQL Anywhere.

Environment: ASP.NET 4.0, C#, SQL ANYWHERE (SYBASE), HTML, CSS, JavaScript, Microsoft Visual Studio 2010, .Net framework 4.0

Education:

Master of Science (M.S) in Information Systems

George Mason University, VA

Bachelor of Science (B.S) in Computer Science

Jawaharlal Nehru Technological University, India



Contact this candidate