Resume

Sign in

Project Sql Server

Location:
Carrollton, Texas, United States
Posted:
February 08, 2018

Contact this candidate

PROFESSIONAL SUMMARY

Thirteen plus (**+) years’ experience with Microsoft .NET technology stack in the areas of Software Development & Implementation, Execution & Project Planning of Windows and Web Applications using Visual Studio .NET.

Thorough understanding of the Software Development Life Cycle (SDLC) with proficiency in mapping client / business requirements, application design, development, integration & testing and troubleshooting for complex information systems management, documentation.

Worked in different domains like: IT consulting, Insurance, Gaming and loyalty cards, Transportation, Airline Cargo, Healthcare, Telecom Billing and Non-Profit domains.

Experience in working with WCF, WPF, LINQ to SQL, ADO.Net, Entity Framework, ORM, Model View Controller Framework (MVC), ASP.Net and WinForms.

Experience in designing and developing applications in distributed environments.

Experience in designing and developing SharePoint Sites, Web parts and integrating with other web applications for the Intranet and Internet based websites.

Lead, Coached and mentored 8 member-team at Span Systems teams during the various project phases, training & guiding team members and enabling knowledge sharing among the team.

Experience in writing T-SQL Queries, creating Stored Procedures, Triggers, and using Normalization Techniques, Views, Joins and Indexes. Experienced in generation of various reports using SQL Reporting Services.

Experience with building data extract, transform and load (ETL) using SSIS/DTS packages.

Participated in full life-cycle development using (OOP) Object Oriented Programming concepts.

Experience with building databases using Code First Migrations using Entity Framework.

Proficient in working with applications based on 3-Tier Architecture and n-Tier Architecture.

Involved in utilizing Team Foundation Server (TFS), GIT, SVN for Version Control.

Skilled in Agile (Scrum) development methodology, as a Scrum Master delivered 5 successful medium size web and desktop projects for Cancer Institute NSW.

Skilled in configuration and use of various tools for faster code development, debugging and testing. Tools like ReSharper, SQL Profiler, Fiddler, etc.

Experienced with various technical aspects like product documentation, software design, coding of modules, monitoring critical paths & taking appropriate actions.

Experienced in coding with different browsers Edge, IE, Firefox, Chrome, Safari and Opera.

Experienced in custom building content management system (CMS) using Umbraco.

Experienced in servicing components inside .Net based customer relationship management (CRM) systems.

TECHNICAL EXPERIENCE

Languages

C#, HTML, CSS, LESS, Bootstrap, ASP.NET, MVC, Web API, LINQ, Entity Framework, WCF.

JavaScript Framework

Angular JS, Node JS, Knockout JS, React JS, Ember JS, Typescript, Karma, Chai, Jasmine, Protractor, NPM, Grunt, Bower

Other Microsoft Tools

Visual C++, Visual Basic, SharePoint, Office2010, Office 2013.

IDE

Visual Studio (2015, 2013, 2012, 2010), WebStorm, SublimeText, BIDS, Notepad++

Source Control

VSS, CVS, Team Foundation Server (TFS), SVN (Tortoise), SourceTree.

CMS

Umbraco, Dot Net Nuke (DNN).

Tools

ReSharper, SpecFlow, Cucumber, NUnit, Microsoft Testing Framework, Redgate Tools

Estimation

Function points, Story Points, Scrum Planning Poker (Agile), Story Boarding.

Databases

SQL Server (2014, 2012, 2008 R2), Oracle, TSQL, PLSQL.

Operating System

Windows (10,8.1,8,7), Windows Server, Windows NT, UNIX.

Database Tools Used

Reporting Services, SQL Server Integration Services.

PROFESSIONAL EXPERIENCE

Upventur (ORMG) Mar17’ – Jan’18

Senior .Net Developer

Project1: Developed website from scratch using Umbraco, Various JavaScript and Umbraco plugins, C#, ASP.Net MVC, SQL Server for Upventur, a social start up for people seeking outdoor adventures such as hiking, rafting, snowboarding, much more.

(https://beta.upventur.com)

Organised Umbraco web development tasks in the Sprints of 2 weeks duration.

Participated actively in stand ups with the team members to understand the status, work through the issues if any, measure and adjust the development work and testing work speed.

Created various document types in Umbraco for use in the website.

Developed ASP.net MVC C# based User Login functionality that works with Facebook Open Graph API, Google API, Instagram API

Worked Extensively with Umbraco Examine Search API using C# code set up for searching capability throughout the website on various categories of searches and return the search results.

Created member C# form for capturing profile related member details such as DOB, Telephone number, interests, activities, Facebook permissions.

Installed and Integrated CK editor (ver4.7.3) for use of editing Rich Text content throughout the website.

Developed C# serverside code to work with Facebook OG interface (version 2.9, 2.10) to push and pull posts from Facebook.

Installed and configured TeaCommerce Shopping Cart as Umbraco plugin to the website.

Customized Shopping cart using Asp.net MVC, used controller methods to communicate with the cart features, adding / removing products from the shopping cart.

Developed C# Web API methods to handle submission of files such as images, videos into website using file upload functionality and store and retrieve these images through media gallery.

Developed database using Code First Migrations in Entity Framework to create Tables, relationships between tables and Stored Procedures

Created tables, stored procedures in SQL Database for use with Frontend UI data displayed or flowing via forms or UI

Created responsive frontend views Bootstrap MVC C#, CSHTML/Razor, HTML, jQuery, Angular 2.0 and JavaScript functional views to work with Asp.net MVC controllers for seamless flow of information between views, controller, Umbraco Web API and SQL Server database.

BenefitMall Sept16’ - Jan’17

Senior Developer

Project1: Designed created and maintained components for insurance website Employer Focus (https://ese.benefitmall.com)

Broke down Epics into smaller user stories for the Sprints and performed velocity assessment.

Participated in daily stand ups, Sprint planning, review and retrospective analysis.

Incorporated retrospective feedback into upcoming Sprints to make the Sprints more effective and efficient.

Developed N-tier Architecture having Presentation Layer, Business Logic Layer, Data Access Layer using C#

Worked with technologies C#, LINQ, Entity Framework and data models that push/pull data to/from database as part of the middle tier.

Created responsive Frontend web pages (Views) using C#, CSHTML/Razor, HTML, jQuery, Angular 2.0 and JavaScript.

Created ASP.Net MVC Razor views to the front end web pages as the functionality demanded.

Created new features to the website that enhanced the Contributions and made the interaction more robust and compliant with existing standards.

Implemented new pages and or controls and added jQuery functions that helped with awards entry like adding new architectural practices, key consultants etc.

Optimized the graphic content with jQuery and find tuned the control HTML events, animations on the site.

Created and deployed XML Web Services (WCF) using ASP.NET and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Designed and Implemented the data layer changes using Entity Framework objects like DBContext, Data mappers, for manipulating, retrieving, storing and displaying data from SQL Server.

Created new SQL stored procedures as necessary for pulling data from different tables to be shown on the web pages.

Created Entity Framework Scripts to perform Code First Migrations to push the changes on to existing Database.

Resolved Merge Conflicts during Code First Migrations when present.

Deployed the application parts to IIS 7.0 Web server, Applications Server and Database

Project 2: Developed and finetuned components in BMAS Application (Data setup and maintenance application for Employer Focus)

Created new user stories as per user requirements given in the functional specification document, adding features to the existing Product Backlog.

Prioritised Product backlog in consultation with Applications Manager and the development team.

Worked with business users to put in a foundation and architecture for the portal (front-end, middle-tier, backend).

entry on requirements given to create new functionality and windows forms.

Designed the tables and Entity relationships in the database.

Royal Institute of British Architects Sept’14 - Jun’16

Lead Web Developer

Project 1: Designed and created http://awards.architecture.com/ site for RIBA.

Chose scrum (Agile) Framework to execute the project as per client needs to deliver project features in quick succession.

Guided the project team members through scrum methodology.

Created User stories, assessed, completion checked and reviewed user stories jointly with product owner with scrum Templates from Visual Studio.

Carried out planning poker assessment of user stories for complexity with development team.

Performed Product Backlog creation and complexity assessment.

Broke down Product Backlog into Sprints and performed velocity assessment.

Conducted daily stand ups, Sprint planning, review and retrospective analysis.

Incorporated retrospective feedback into upcoming Sprints to make the Sprints more effective and efficient.

Worked with technologies C#, LINQ, Entity Framework and data models that push/pull data to/from database as part of the middle tier.

Created responsive Frontend web pages (Views) using C#, CSHTML/Razor, HTML, jQuery, Angular 2.0 and JavaScript.

Added new features to the website that enhanced the awards entry and made the interaction more robust and compliant with current standards on SQL.

Integrated SQL Server 2014 as the backend database to capture the relevant data to and from web site.

Implemented new pages and or controls and added jQuery functions that helped with awards entry like adding new architectural practices, key consultants etc.

Optimized the graphic content with jQuery and find tuned the control HTML events, animations on the site.

Tracked the completion of sprints using TFS and the charting mechanisms for measuring product back log burn out, speed of sprints (number of backlog items cleared in a sprint) etc.

Configured TFS as the source control for saving developer code changes, managing various and release builds.

Prioritised the broken TFS builds, got them fixed by the team member responsible so that there is a quick turnaround for other team members to continue their work.

Created Unit and Integration test strategy, deployment plans to respective environments, to enable end to end sprint cycle tests and their successful release to respective environments.

Created Entity Framework Scripts to perform Code First Migrations to push the changes on to existing Database.

Resolved Merge Conflicts during Code First Migrations when present.

The finished website was hosted on IIS 7.0 Web server in Production and Database in Backend Servers hosting SQL Server 2014.

Setup security as per the ASP.net Windows Authentication between web server and database server.

Performed database administration and added pdf engine to convert the received data from site users into pdf format for further processing by the RIBA Awards judges.

Project 2: Designed The RIBA International Awards Features within RIBA Awards site

Developed user stories as per requirements.

Created Product Backlog for features to be added.

Assessed User Stories for complexity.

Prioritised the Product backlog in consultation with Project Manager and the development team.

Worked with business users to put in a foundation and architecture for the portal (front-end, middle-tier, backend).

Implemented the membership provider and customised it to the needs of the international awards entry on requirements given to create new functionality and web pages.

Designed the tables and Entity relationships in the database.

Project 3: Ongoing maintenance of other RIBA websites.

Architecture.com (Contensis is the CMS used here), Membership.Architecture.com, CPD updates weekly using SSIS package upload into SQL Server.

Environment: CSHTML, C# 4.0, ASP.Net MVC 4, LINQ, SQL Server 2014, IIS 7, Team Foundation Server (TFS)2012, LINQ, jQuery, AJAX, Angular JS, JavaScript, HTML, CSS, Entity Framework.

BDML Connect (part of Markerstudy Group) Jun’14 - Sept’14

Senior Web Developer

Project 1: MasterQuote Car and Home Insurance Websites – masterquote.co.uk, AQuote Van and Bike Insurance Websites – aquotebike.com, aquote.co.uk.

Developed and designed the Business layer/Data Layer using C#, LINQ, Entity Framework and SQL Server.

Responsible for document deliverables, including Design Specifications, Site Architecture Map, Test Plans, as well as for conducting usability testing using ASP.Net.

Used custom built Business Layer Functionalities for the middle-tier ages at one go using ASP.Net.

Designed and developed custom built pages for the database layer/calls and server settings separately to incorporate them into any ASP.Net environment using C#5.0 and ASP.Net.

Designed and developed the website pages and HTML templates provided by HTML graphics design company.

Created web pages to view the statements/invoices using ASP.NET, JavaScript, jQuery, JSON.

Enhanced the car and home insurance quote journeys by use of adding dynamic jQuery controls.

Improved the interaction to be more robust and compliant with current standards across different browsers.

Added LINQ to Entity Framework components to modernize data access and improved the performance by 3 times more than the older ADO used in the websites.

Created Entity Framework Scripts to perform Code First Migrations to push the changes on to existing Database.

Resolved Merge Conflicts during Code First Migrations when present.

Re-defined Data models to better suit search features as per Google Search needs.

Implemented new controls and added jQuery functions that helped with address search, job search and post code search for the customer.

Environment: CSHTML, C# 4.0, ASP.Net MVC 3, LINQ, SQL Server 2012, IIS 7, Team Foundation Server (TFS)2012, LINQ, jQuery, AJAX, JavaScript, HTML, CSS, Entity Framework.

Project 2: Petwise Broker Portal

Laid out the foundation and architecture for the portal (front-end, middle-tier, backend)

Implemented the LESS file for use with CSS on all the pages.

Implemented the Simple membership provider and customised it to the needs of the Petwise Broker Portal (Roles and Login needs).

Used Ajax and JavaScript extensively in the Web UI. The UI made Ajax calls to the business tier.

Incorporated LINQ to Entity Framework Layer as Data Layer in the website project

Created Entity Framework Scripts to perform Code First Migrations to push the changes on to existing Database.

Written LINQ to Entity SQL queries to manipulate data to and from the portal into database.

Resolved Merge Conflicts during Code First Migrations when present.

Tested and prepared Technical documentation for the application modules.

Configured IIS to run application under set user windows Identity account.

Environment: CSHTML, C# 4.0, ASP.Net MVC 4, LINQ, SQL Server 2012, IIS 7, Team Foundation Server (TFS)2012, LINQ, jQuery, AJAX, JavaScript, HTML, CSS, LESS, Entity Framework.

Cancer Institute NSW Oct’06 – May’14

Senior Scrum master / Developer

Developed a strong understanding of various business processes and IT projects in the organisation.

Designed, Developed, Tested and rolled out website for the organisation in a timely organised Agile/Scrum methodology.

Provided full support for Microsoft based websites (ASP.Net, ASP.Net MVC, SharePoint, WinForms Applications, WPF Applications, Silverlight, DNN, Umbraco).

Assisted external consultant with application architecture, system design and database design.

Used tools for quality control of IT processes to track and measure defects in code.

Resolved business issues with web and Windows applications.

Worked on SQL Reporting Services to extract custom business based reports from SQL Server Databases for various Website Projects.

Performed requirement Analysis as per business user requirements.

Deployed and promoted the released version of the program code into production environment as per change management system of the IT Department.

Project 1: Re-design of bsnsw.org.au and csp.nsw.gov.au Jan’12 - Jul’13

Brought together the two business owners to rebuild the websites for Breast Screening and Cervical Screening, one website for each division which provided information to public and the services available.

Captured User Stories with use of Story Boarding along with product owner team.

Setup basic Umbraco website project in Visual Studio 2012.

Setup Test Projects in Visual Studio 2012 for internal component testing needs of the both the websites.

Added ASP.Net MVC Website Pages to work with Umbraco.

Use of Surface Controllers to code custom pages in Umbraco.

Setup Custom page rendering using Hijacking Umbraco Routes using routing via templates.

Setup WebAPI Services for the various website needs to pull custom data from other service API’s.

Designed and developed custom user controls into Umbraco using Macros.

Combined the functionality between the two websites for developing common Umbraco modules.

Separated the websites and page functionality where needed.

Designed and developed the website pages.

Integrated HTML templates provided by HTML graphics design company.

Environment: Umbraco, CSHTML, C# 4.0, ASP.Net MVC 3, LINQ, SQL Server 2012, IIS 7, Team Foundation Server (TFS)2010, LINQ, jQuery, AJAX, JavaScript, HTML, CSS, Entity Framework.

Other websites and Projects worked on: cancerInstitute.org.au, eviq.org.au, Cherel.org (Umbraco), Cherel DMS, Canrefer.org.au, ICanQuit.com.au, cancernotifications.cancerinstitute.org.au, mesothelioma-australia.com

Span Systems (Currently Evry India), Bangalore Jan’01 - Jun’04

Technical Lead

Project: Managed Care Interface (MCIF) Aug’01 - May’02

Developed one of the modules for interfacing, UNIX based systems with providing data to Oracle/ Informatica server.

Managed the offshore team of developers. Single point contact between on-site client project manager and offshore team.

On-site User acceptance and Implementation. Weekly status reporting of the project to the Senior Management.

Environnent : UNIX, C, Shell Scripts, Informatica, Oracle, AS400, XML, DTD

Other Projects worked on: Sybase Qualification of iEnterprise Server, Customer Order Invoice Processing System (COIP), Jenzabar CX Product

Cambridge Technology Partners, Bangalore May’98 - Dec’00

Senior Consultant / Business Analyst / Lead Developer

Project: Cargo Revenue Accounting System (CRAS) Jan’00 - Jul’00

Contributed to scope, design, development, testing, rollout to production and documentation.

Designed and developed the proration logic and tested it under actual working environment.

Received special recognition from Air Mauritius executive team for delivering this project within an aggressive timeline of 5 months. Considering there were several business rules (defined by IATA) to be honoured before computing the revenue for inter-airline billing based on complex proration logic, this project was extremely technically-challenging.

Environment: Visual Basic 6.0, OOD, SQL Server 7.0, Seagate Crystal Reports.

Other Projects:

Carrier Control Process (CCP) - The project consisted of processing and organizing telecom billing data, coming on various media like CD, Tape, EDI etc.,

Customer Care Management Solution - The system consisted of integrating the Vantive (CRM Package) with the existing Kenan Arbor Billing system.

Axis for AXIAL, UK - The project involved the development of application for handling functions viz, parts pricing, storage transportation and billing and invoicing.

Voice Mail System (Internal Project) - The project involved the development of Voice Mail System for the Bangalore Office.

EDUCATION

Masters of Business Administration, Australia

Bachelor of Engineering (Computer Science), India

AWARDS AND RECOGNITION

Recognised by RIBA Digital Transformations Team delivering the award project and RIBA Awards website in the given time and budget.

Purple Jersey Award - Cancer Institute NSW (October 2012)

Team Excellence Award by Cancer Institute NSW for Canrefer Project (Jan 2012).

Recognised by Air Mauritius executive management for good technical design (reviewed by consultants from Microsoft) of technically complex airline billing project.

PERSONAL DETALS

Present Location: Carrollton TX 75010

Email: ac4d8m@r.postjobfree.com

Phone: 972-***-****

References available on request.



Contact this candidate