Sql Server Software Engineer

Sathik Basha Dowlath Khan

Phone: 832-***-****

Email: ***************@*****.***

SUMMARY

• Over 11 years of experience in designing and building large scale, distributed n-tier (UI, business layer, data access layer) web systems leveraging .NET technologies.

• Hands on web-based application development experience using C#,ASP.NET, MVC, ADO.NET, SQL server, Oracle, AJAX, JOSN, LINQ, WCF, Web API, XML, JavaScript, JQuery, Angular JS 1.x and NoSQL to develop both client and server side functionalities.

• Designed, programmed, and deployed enterprise web application with distributed components & web services using various system level architectures.

• Strong understanding of SQL server, stored procedures, triggers, database object creation etc.

• Strong Familiarity with design patterns and development best practices (MVC, Coding Standards).

• Strong Object Oriented Analysis and Design (OOAD) skills.

• Experience in performance analysis and tuning in web applications (App dynamics and Profiler).

• Worked with Dependency Injection/IoC frameworks like castle Windsor.

• Good exposure to version control tools like TFS, SVN, Red Get Source control and Git Hub.

• Experience with software development life cycle (SDLC) and project methodologies such as agile, waterfall.

• Proficient in creating Use Cases, Sequence Diagrams and Class Diagrams.

• Proven experience in project and team leading with zero defect delivery.

• Exposure to various facets of Shipping Freight Forwarding, Medical office, Revenue Accounting and Airport operations in Airline Industry.

• Excellent communication skills, strong organizational skills and excellent interpersonal skills.

• Writing scalable, reliable, concise, high quality code.

• Strong ability to work independently and cooperate as a flexible, reliable, hardworking and quick learning team player.

TECHNICAL SKILLS

Programming Languages : C#, VB.NET, Visual Basic 6.0, VBA, C Web Technology : HTML, DHTML, CSS, Javascript, JQuery, XML MS Technology : Dot Net Framework, ASP. NET, ADO. NET, LINQ, MVC, WCF, WebAPI, ADO.NET, LINQ, N-tier Application Architecture, AJAX, JSON Tools/IDE Program : Visual Studio 2015, SQL Server Management studio, Oracle SQL developer, Toad Oracle.

Databases : SQL Server (2008, 2005), MS Access, MySQL 5.0, Oracle 11g NoSQL : Firebase, APTO

Performance : Dynatrace, App Dynamics and Developer tools Versioning Tools : TFS, SVN, Red Get Source control and Git Hub, Operating Systems : Microsoft Windows.

Mobile App development : AngularJs 1.x, Cordova

WORK EXPERIENCE

United Airlines (Houston, TX) Oct 2015 – Present

Senior Software Engineer

Project : Electronic Time and Attendance (eTA)

Employer : Infosys Ltd.

Location : Houston, TX, USA

Environment : NET Framework 4.5, C#, ASP .NET,MVC, Angular js 1.x, Web forms, Web Service, Entity Framework, JQuery, Bootstrap CSS framework, LINQ, SQL Server 2012, Oracle 11g,Toad 12.8,SQL Server

Team Size : 15

eTA is an all-inclusive Electronic Time and Attendance system. It is currently being utilized by Tech Ops, Material Services, Chelsea and Airport Services. The initial deployment was June 2001 and is currently in all domestic stations. eTA is constructed as an airline specific application. It currently interfaces with the Payroll System. Qualifications are jobs the employee has training and/or experience to work as determined by their management staff. Employee qualifications are part of the day trade application, shift bid application, overtime application, Staff Manager and drive operational manpower sheets. Key features include an employee portal for self-service options such as day and shift trades, signing up for overtime and reviewing timecards, schedules and accruals. There is also a web based administrative portal that allows for complete system management. Employee punches are accepted via a biometric clocking system to prevent fraudulent and costly “Buddy Swiping”. eTA also tracks attendance points, Family Medical Leave usage, vacation accruals and usage and sick time hours. Employee web portal to manage employee crew sheets and balances while applying all applicable business (Union) rules for processing pay transactions to the Payroll System. Responsibilities:

Working with the Product analysts and Business analysts to gather the product requirement for new enhancement.

Application design – to come up with a design that is secured, maintainable and scalable, also document the design.

Performance analysis and fixes to ensure the services execute within slated SLA

Release management and Production Support

Participate in defect resolution / root cause analysis of the reported incidents for early resolution.

Review QA acceptance of incidents item and deploy the code in production. After business user approval

Smoke test in production should verify defects fixes.

Participate in Sprint meetings, conducted every 2 weeks for development estimation planning.

Participate in daily scrum meetings and obtain daily status. United Airlines (Houston, TX) Oct 2013 to Sep 2015 Senior Software Engineer

Project : Revenue Accounting System for Consolidated Airlines . Employer : Infosys Ltd.

Location : Houston, TX, USA

Environment : C#.Net. Oracle, Visual Studio 2010, NET Framework 4.5, MVC, Web forms, Web Service, JQuery, Bootstrap CSS framework, LINQ, SQL Server 2012, Oracle 11g, Toad 12.8

Team Size : 15

Revenue Accounting System for Consolidated Airlines (RASCAL) involves the development of a sales-based accounting system to enable coupon level usage tracking, coupon level accounting adjustments, and accurate reporting of open coupons reconciling back to the Air Traffic Liability. Additional objectives are the enhancements of system processes to create efficiency in sales migration, sales validations, station sales summary, refunds processing, and sales audit. This is an end-to-end application development project involving requirements elaboration, design, build, testing, implementation and support. The project involves multiple iterations during which various items in the scope would be accomplished. Responsibilities:

Working with the Product analysts and Business analysts to gather the product requirement.

Application design – to come up with a design that is secured, maintainable and scalable, also document the design.

Performance analysis and fixes to ensure the services execute within slated SLA

Release management and Production Support

Elsevier (Chennai, Tamil Nadu, India) Jan 2012 to Sep 2013 Project : SimOffice [https://www.youtube.com/watch?v=AuBWd5jkXcQ] Employer : Infosys Ltd.

Role : Technology Analyst

Technologies : VS 2010, ASP.NET 2.0, C#.NET 3.5, WCF, Ajax, ADO.NET 2.0, MS SQL Server 2008, CSS, HTML, JavaScript, IIS 6.0, S#arp Architecture, Nhibernate, Spring, JSON and jQuery. Team Size : 12

SimChart is an academic nursing product acquired by Elsevier. The Linked Data Repository (LDR) is an “online” component that supports Elsevier’s Linked Data effort which is a part of the overall Smart Content Initiative in Elsevier. The LDR can be thought of as a “metadata service for smart content” and contains XML documents called Satellites. It’s an XML document that contains journal articles, book sections and patient handouts. Both these product are integrated with WCF. Responsibilities

• Understanding the existing systems thoroughly and documenting the system as is for business user understanding.

• Application Design – Involves creation of various documents like Configuration management, High level Design, Framework design.

• Improved the Performance of slow loading pages by invoking DB calls in parallel

• Developed JQuery scripts which keeps the session active if user is active and logs off the user if inactive for certain period of time.

• Release management and Production Support

• Created innovative tool to port the session across DB which reduced the team’s effort.

[JSON viewer]

Elsevier (Chennai, Tamil Nadu, India) Jul 2011 to Sep 2011 Project : LDR integration with SimChart

Employer : Infosys Ltd.

Role : Technology Analyst

Technologies : Visual Studio.NET 2010, ASP.NET 2.0, C#.NET 3.5, WCF, Ajax, ADO.NET 2.0, MS SQL Server 2008, CSS, HTML, JavaScript, IIS 6.0, S#arp Architecture, Nhibernate, Spring, JSON and jQuery. Team Size : 5

SimChart is an academic nursing product acquired by Elsevier. The Linked Data Repository (LDR) is an

“online” component that supports Elsevier’s Linked Data effort which is a part of the overall Smart Content Initiative in Elsevier. The LDR can be thought of as a “metadata service for smart content” and contains XML documents called Satellites. It’s an XML document that contains journal articles, book sections and patient handouts. Both these product are integrated with WCF. Responsibilities:

• Design of the Object modeling and session management framework.

• Development of Web Application using MVC, jQuery and WCF.

• Setting up of rule sets for the code analysis, to make sure developers are following project level coding standards.

• Deployment and Testing.

• Release management and Production Support

Elsevier (Chennai, Tamil Nadu, India) May 2010 to Dec 2011 Project : SimChart [https://www.youtube.com/watch?v=dPbMHyVtbn4] Employer : Infosys Ltd.

Role : Senior System Engineer

Technologies : Visual Studio.NET 2010, ASP.NET 2.0, C#.NET 3.5, Ajax, MS SQL Server 2008, CSS, HTML, JavaScript, IIS 6.0, S#arp Architecture, Nhibernate, Spring, JSON and jQuery. Team Size : 10

SimChart is an academic nursing product acquired by Elsevier. The product is based around the functionality of an Electronic Health Record system and is designed to train nursing students on medical documentation procedures. Students should be able to login into the product and complete the scenario that is being assigned to them and chart them accordingly. The instructor then views the student filled information and grades them along with comments which he believes will improve the learning ability of the student.

Responsibilities:

Requirement Analysis and Impact Analysis.

• Design of various components and preparing high level and low level design documents.

• Development of Application - involves coding/programing

Created innovative tool to port the session across DB which reduced the team’s effort.

• Unit Testing

James Mackintosh & Co Pvt Ltd (Chennai, Tamil Nadu, India) Jan 2009 to 28-Apr-2010 Project : P & I (Protection & Indemnity) Application Employer : eBMS Solution Private Limited.

Role : Senior Software Developer

Technologies : ASP.NET, C# 3.5, VBA, HTML, Java Script, AJAX, SQL Server 2005, IIS 5.0 Team Size : 4

This Application Project provides optimized solution to James Mackintosh works as P&I correspondents and communicate with club who give cover for a particular vessel or cargo to the consignor or the vessel and get information regarding a new matter from their principals, they advise accordingly as on whose behalf they need to work with correspond.

Responsibilities:

Specification, designing, coding and implementation.

Involved in knowledge transfer to end-users.

Direct communication with the client through e-mail and over phone.

Configured and deployed application in various environments.

Attended SRS meeting at client place.

Shipping Agency Application (Chennai, Tamil Nadu, India) Apr 2006 to May 2009 Employer : eBMS Solution Private Limited.

Clients :

Goodrich Maritime Private Limited

Romav Shipping Solution(U.K)

IAL Shipping Solution (Dubai)

Ceekay Shipping Services LLC (Dubai)

Role : Senior Software Engineer

Technologies : ASP.NET, C# 2.0, HTML, Java Script, AJAX, SQL Server 2005, IIS 5.0 Team Size : 10

Shipping Agency Application Project was customized and delivered to the above clients. Provides optimized solution to Shipping Agencies (Represent one or more Lines) to have a better control over their business around the globe. It has control over its Sales and Marketing, Operations – both at offices and ports, Documentation and Accounts departments. This application will give all required information to the management as MIS reports

Responsibilities:

Requirement Elaboration

High Level/Detailed Design

Development of Application - involves coding and programing

Unit and Integration Testing.

Shipping Freight Forwarding (Chennai, Tamil Nadu, India) Apr 2006 till May 2009 Employer : eBMS Solution Private Limited.

Clients :

Aquarius Maritime Pvt. Ltd

James Mackintosh & Co. Private Limited.

Role : Software Engineer

Technologies : ASP.NET, C# 2.0, HTML, Java Script, AJAX, SQL Server 2005, IIS 5.0 Team Size : 10

Shipping Freight Forwarding Application Project was customized and delivered to the above clients. Provides optimized solution to Freight Forwarders (Brokers) to have a better control over their business around the globe. It has control over its Marketing and Pricing, Operations – both at offices and ports, Documentation and Accounts departments. This application will give all required information to the management as MIS reports.

Responsibilities:

Requirements Analysis

High Level/Detailed Design

Development of Application - involves coding and programing

Self Unit Testing and Integration Testing

EDUCATION

Bachelors of Engineering in Computer Sciences and Engineering in 2005 Anna University, Chennai, India.

Contact this candidate