Sql Server,.Net

Location:

Houston, TX

Posted:

June 28, 2017

Contact this candidate

Resume:

Navneet Tiwari

**** ***** **

Houston Texas *****

Mob: +1-516-***-****

E-mail: ****************@**********.***

******@*****.***

NAVNEET TIWARI

Navneet Tiwari is a Senior Developer with more than 10 years of IT industry experience focused on .NET and Microsoft technologies. His technical skills encompass software development life cycle (SDLC) process from requirement gathering, system analysis and design to development and testing of enterprise solutions. Navneet has work experience in trade market he works for NASDAQ-OMX and Samba Capital. He has extensive knowledge of Stock markets (Order Book, Trade handling, etc). He lies in developing and delivering enterprise solutions using .Net Frameworks 4.5/4.0/3.5/2.0/1.1, Visual Studio.Net 2015/2012/2010/2008/2005/2003, Entity Framework 6/5, TFS, ASP.NET MVC 5/4, ASP.Net Web Forms, C#, AngularJS, Web API,NUnit, PL/SQL, AJAX, Web Services (SOAP, WSDL),ADO.NET, Entity Framework 6.0/5.0, LINQ, C#, JQuery, JSON, Ajax, CSS 3, HTML 5, Bootstrap, WCF, Web Services, LINQ, MSMQ, XML/XSL/XSLT IIS Server 7.0/6.0, MS SQL Server 2005/2008/2000/2012 database design including tables, views, stored procedures, functions, triggers and indexes, SQL Server Reporting Services (SSRS), XML, Windows Server 2008 R2/2003, Oracle 9i/10g..He has successfully managed the projects in various business domains like Banking, Education, Health Care, Airline, Finance (Stock Market). Has implemented Integration between multiple Systems/Platforms in Dot Net using SOA Architecture with good experience in designing and developing RESTful Services using Web API and WCF. He has experience in implementing Single Sign on using ADFS.He has excellent inter-personal and communication skills. He has Implemented Single sign-on using ADFS.

CERTIFICATIONS:

Microsoft® .NET Framework - Application Development Foundation.

Microsoft .NET Framework 3.5, ASP.NET Application Development.

TECHNICAL SKILLS:

Languages: C#, VB.NET.

Web Technology: ASP.NET, XML, XSL, AJAX, CSS, ASP.net MVC 3/4/5, WCF, Web Services and LINQ.

Scripting Languages: JavaScript, Jquery and AngularJS,

GUI: Visual Studio 2015/12/10/08/05/03.

UI Design CSS, CSS3, Bootstrap, HTML, HTML5 and XSLT.

ORM Entity Framework and iBATIS.

Databases: SQL Server 2014/08//05/00, Oracle 10g.

Tools/Technologies: WCF, Web Form, SQL Server Reporting, HTML, Team Foundation Server (TFS), Source Safe, SVN.

Web Servers: IIS 5.0/IIS 7.0.

Versioning Tools GitHub, Team Foundation Server 2015/10 and SVN.

Methodologies: SCRUM, Agile, Waterfall.

Reporting SSRS.

Operating Systems: Windows (various versions).

PROFESSIONAL EXPERIENCE

Programmer Analyst, McDermott, Houston, TX 02/16–Present

Quantum

Quantum is platform for currency trading, hedging and commission. Quantum is interacting with other system to get oil related data. Quantum calculates employee commission based on trade. Quantum has major module trading hedging and commission.

Responsibilities:

●Designing textual and graphical content including product illustrations for the website.

●Responsible for analyzing, designing, programming creating tables, temporary tables, indexes, primary keys, foreign keys, complex SQL Queries, stored procedures, functions, views, triggers using SQL Server 2014.

●Involved in creating complex store procedure for report creation.

●Used Log4net to writes logging events to the Windows Event Log. Technical and functional support to the team member.

●Used AngularJS in web pages to call services.

●Used IOC container for Dependency Injection. Implemented Service module to exchange data with Web API.

●Created REST Web API.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#

Environment: .Net Framework 4.6, C# 6.0, Web API, MVC 5, Visual Studio 2015, Entity Framework 6.0, TFS 2015, LINQ, SQL Server 2014,jQuery, Angular JavaScript,jqGrid, JSON, AJAX.

Programmer Analyst, United Airlines, Houston, TX 05/16–02/16

Common Service Layer

CSL (Common service layer) is common platform for the ecommerce web, mobile, Contact Centre and other channels like kiosk check in and airport operations.CSL has different services for PNR retrieval, Payment, Flight search flight status flight booking operations which interact with HP Share systems give calls to Google ITA for flight availability.United.com is ecommerce web application where thousands of transaction is happening hourly.

Responsibilities:

Develop e-commerce product interact with customer.

Worked with e-commerce databases to develop shopping cart manager.

Designing textual and graphical content including product illustrations for the website.

Interacted with client to analyses business requirement and prepared Class Diagram & Design Documents, and involved in ongoing discussion with client team.

●Involved in creating complex store procedure for report creation.

●Responsible for writing and reading XML files, Serialization of XML.

●Used Log4net to writes logging events to the Windows Event Log. Technical and functional support to the team member.

●Used AngularJS in web pages to call services.

●Used IOC container for Dependency Injection. Implemented Service module to exchange data with Web API.

●Created REST Web API.

Scrum retrospective, to achieve innovation, creative solutions, and motivation.

Created POC for implementation of framework.

Involved in creating and designing the database Conceptual and logical model to integrate as part of the system.

Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#

Used Design patterns. Participated in desk check, code reviews, internal and external reviews of technical design documents.

Involved in the design, development, coding and implementation of the solution. Each view was developed using MVC 5 (RAZOR engine), also worked on Partial Views, controller actions, Business and Data Layer.

Environment: .Net Framework 4.6, C# 6.0, Web API, MVC 5, Visual Studio 2015, Entity Framework 6.0, TFS 2015, LINQ, SQL Server 2014,jQuery, Angular JavaScript,jqGrid, JSON, AJAX.

Sr. Programmer Analyst, PriceWaterhouseCoopers, Columbia, SC 06/15–04/16

Talent Exchange

Talent Exchange is job portal design for pwc thousands of applicants are depending placement cell. This project is an attempt to minimize the problems of an applicant to find a correct job in organisation. Freelancer can create their profile and start finding current opening match to their skills. All current opening match to freelancer skill will displayed on his dashboard freelancer can show his interest in current opening. Manager can create roles and invite freelancer for current opening.Freelacer and managers can search on multiple filters.Sovren is used for parsing and searching of resumes. Managers can create pricing event for role and invite freelancers to participate in pricing event. This is C2C application.

Responsibilities:

Architect the application module, including the backend and UI layers.

Worked with e-commerce databases to develop shopping cart manager for pricing Event.

Designing textual and graphical content including product illustrations for the website.

Interacted with client to analyse business requirement and prepared Class Diagram & Design Documents, and involved in ongoing discussion with client team.

Provide technical guidance and assistance to development teams.

Held regular team meetings and solved problems.

Inspired team to see big picture of project.

Managing junior resource assign task to them

Designed and implemented Service-Oriented Architecture solutions.

Worked as technical lead Involved in Architect, design and development of web based solutions using Microsoft technologies.

●Created complex Store procedures.

●Used Entity Framework 6.0 to manipulate and display data. Used Web services API to facilitate data exchange across applications.

●Used AngularJS in web pages to create responsive pages.

●Used JavaScript for client-side validations.

●Created REST Web API.

●Developed UI using Angular JS which reads the data from Web API and displays in UI.

●Responsible for writing and reading XML files, Serialization of XML.

●Used Log4net to writes logging events to the Windows Event Log. Technical and functional support to the team member

Scrum retrospective, to achieve innovation, creative solutions, and motivation.

Created POC for implementation of framework.

Also performed the responsibilities of Scrum Master, with two different teams and four projects.

Involved in creating and designing the database Conceptual and logical model to integrate as part of the system.

Developed data access layer using Entity Framework 6.0 for communicating with database.

Created JavaScript functions, Razor Views, View Models classes, Controllers and Action methods into the ASP.NET MVC 5front end project.

Used IOC container for Dependency Injection.

Used Factory and Singleton patterns. Participated in desk check, code reviews, internal and external reviews of technical design documents.

Environment: .Net Framework 4.6, C# 6.0, Web API, Angular JavaScript, HTML, CSS, JavaScript, JQuery, MVC 5, Visual Studio 2015, Entity Framework 6, GitHub, LINQ, SQL Server 2014.

Project Lead, PSB Research, Washington DC 10/13 – 05/15 11/13–06/15

ADLAB

ADLAB is developed to know whether advertisement should be air or not. Each advertisement is given some score based on survey conducted on group of peoples. Based on score of advertisement it is decided it should be air or not. Each Advertisement is consists of six pillar education, emotion, knowledge, perception, behaviour and Advocacy. Each pillar has set of specific questions on which score is calculated with this score each advertisement is compared with another advertisement in our database and rank is given to advertisement based on rank Adlab advise Advertisement should be air or not.

Responsibilities:

Worked as technical lead Involved in Architect, design and development of web based solutions using Microsoft technologies.

Held regular team meetings and solved problems.

Inspired team to see big picture of project.

Managing junior resource assign task to them

Trained and mentored junior programmers in programming methodologies and best practices.

Created Application forms (Views) and other UI components using ASP.NET MVC Razor Engine and JQuery

Created reusable HTML helper UI elements. Used Unity framework for dependency injection.

Involved in designing and developing WCF Services with C#.NET.

Wrote controller code in C#.NET to access UI values and passed it to middleware.

Responsible for analyzing, designing, programming creating tables, temporary tables, indexes, primary keys, foreign keys, complex SQL Queries, stored procedures, functions, views, triggers using SQL Server 2005 and 2008.

Establishing communication with web services through AJAX calls with jQuery and using JSON as data exchange format

Used LINQ to manipulate and store the data.

Used JQuery & JavaScript for client-side validations and rich user interface.

Coded the SOA architecture using WCF by creating and implementing using Web services.

Responsible for writing and reading XML files, Serialization of XML.

Used Linq to SQL data context. Used Json.Net to Serialize and De-serialize objects and messages

Used Factory and Singleton patterns. Participated in desk check, code reviews, internal and external reviews of technical design documents.

Used Log4net to writes logging events .Technical and functional support to the team member

Implement Single Sign on through ADFS.

Environment: .Net Framework 4.0, C# 4.0, MVC 5.0/4.0 Visual Studio 2012/2010/15, WCF ASP.NET, XML, HTML, LINQ, AJAX, JavaScript, Jquery, JSON, Single Sign on through ADFS, SQL Server 2008.

Module Lead, Mercer, Canada 05/11 – 10/13

Pension Data Management

Pension Data Management is developed for effective data management for its clients. Pension Data Management is single application for all clients. In Pension Data Management Client Admins can define individual business rule depend upon their requirements to execute input files. Business rules for each client got executed as per schedule defined by admins.

Responsibilities:

Involved in developing WCF Services and Web Applications with C#.NET, ASP.NET, JavaScript and AJAX in client-side.

Created a technical design document based on business and functional requirement document and reviewed the document with clients. Created the Proof of concept.

Used TFS for version control and source control of the software, JIRA is used as bug tracking and project management tools.

Used JavaScript and Jquery for client side coding for better performance.

Coordinated with release teams for the successful deployment of the application.

Did the bug fixing. Scheduled the application run in window scheduler.

Repeater and Data Reader for binding data from database to the various web forms in ADO.Net.

Created PL/SQL scripts.

Responsible for developing Oracle PL/SQL packages.

Defined best practices and standards for SQL programming of stored procedures, functions and triggers.

Created WCF Services to interact with informatica.

Environment:.Net Framework 4.0, C# 4.0, Visual Studio 2012/2010, WCF ASP.NET, XML, LINQ, SQL Server 2008.

Lead Programmer Analyst, HCL Tech 09/09 – 05/11

Client: TRW Automotive

HSE (Health Safety Environment)

HSE is developed for environment related project run by TRW. TRW’s environmental programs focus on three areas: addressing past environmental impacts, reducing current environmental impacts, and preventing future environmental intrusions. The application keep track records of various environment related project run in different countries cost spending on each project. Based on project monthly, quarterly and yearly report is generated in excel include project cost, project manager performance, project risk.

Responsibilities:

Involved in developing WCF Services and Web Applications with C#.NET, ASP.NET, JavaScript and AJAX in client-side.

Responsible for analyzing, designing, programming creating tables, temporary tables, indexes, primary keys, foreign keys, complex SQL Queries, stored procedures.

Responsible for development and maintenance of intranet Web applications, get data and reports using ASP.NET, C#, SQL Server 2005.

Defined best practices and standards for SQL programming of stored procedures, functions and triggers.

Created PL/SQL scripts.

Responsible for developing Oracle PL/SQL packages

Responsible for Writing and reading XML files, Serialization of XML.

Deployed ASP.Net Web Site on IIS web server using web deployment project.

Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid.

Data Grid and Data Reader for binding data from database to the various web forms in ADO.Net.

Implement Single Sign on through ADFS.

Provided production support.

Environment:.Net Framework 2.0, C#2.0, Visual Studio 2008, WCF ASP.NET, XML, LINQ, SQL Server 2008, Webfocus, ColdFusion

Programmer Analyst, HCL Technologies

Client: Microsoft Redmond 04/09– 08/09

MSN FUSE

MSN Fuse is a distributed light weight network monitoring mechanism that has been integrated into Composition Framework. With Fuse instrumentation, network activities are collected and persisted into a data repository. This persisted data is further processed and presented through web portal as reports and dashboard views to end users. Distributed systems built with Fuse are guaranteed that failure notifications never fail.

Responsibilities:

Responsible for Analyzing, designing, programming creating tables, temporary tables, indexes, primary keys, foreign keys, complex SQL Queries, stored procedures, functions, views, triggers using SQL Server 2005

Responsible for development and maintenance of intranet Web applications, get data and reports using ASP.NET, C#, SQL Server 2005.

Deployed ASP.Net Web Site on IIS web server using web deployment project.

Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid, Data List, Data

Data Grid and Data Reader for binding data from database to the various web forms in ADO.Net.

Involve in Design Web Pages.

Environment: C# 2.0, Visual Studio 2008, Framework 2.0, LINQ, Web Services, SQL Server 2005.

Programmer Analyst, HCL Technologies 05/08 – 04/09

Client: Samba Bank

Samba Capital for Samba Bank

SAMBA Financial Group (SAMBA) is a Saudi Arabian Company with its head office in Riyadh. It is one of the leading banks and has leadership position in its customer service in Kingdom of Saudi Arabia and the Middle East.

SAMBA has a set of brokerage systems which consists of:

SAMBA Tadawul – Order management system for the local brokerage business.

SAMBA Direct – Pershing based front office solution used for the international market.

IBS – Book-keeping system for international brokerage

GCC Brokerage – Proprietary web-enabled application used to access market data from the GCC stock exchanges.

Responsibilities:

Involved in writing C# components.

Responsible for Writing and reading XML files, Serialization of XML.

Provided production support.

Environment: C# 2.0, ADO.net, Visual Studio 2008, .Net Framework 2.0.

NextGen, SWEDEN for NASDAQ-OMX 11/07 – 04/08

NextGen is a technology framework being developed by NASDAQ-OMX Technology to support the development of advanced trading, clearing and transaction management systems for both large and small exchanges and clearing houses. NextGen is a complete central system solution of exchange. It is constructed using a building block concept, whereby a defined set of functionality is combined into a building block. Each building block is a software application that can be deployed standalone or together with other building block.

NASDAQ-OMX is a leading expert in the exchange industry. OMX focuses on assisting its customers with the implementation of efficient securities transactions. OMX has two offerings: the Nordic Exchange and the global technology operations, and is organized in three business areas. OMX has been listed since 1987 and its share is today traded on the Nordic Exchange in Stockholm, Helsinki, Copenhagen and Iceland.

Responsibilities:

Involved in writing C# components. Freezing the requirement specs and also involved in functional spec preparation.

Implementing business logic. Responsible for Writing and reading XML files, Serialization of XML.

Provided production support.

Environment: C# 2.0, Visual Studio2008 .Net Framework 2.0.

Programmer Analyst, HCL Technologies 01/07 – 11/07

eSchoolData (http://nexgen.eschooldata.com/)

eSchoolData represents the next generation of Student Management System. The powerful functionality of eSchoolData stems from its native data-gathering, data analysis and data reporting capabilities that link and integrate all data into centralized database, providing information output at the student, parent, teachers, classroom, school, district and state levels.

The core of eSchoolData is a centralized database that makes data available to any person who is authorized to view it while restricting access to all others. Some users may be permitted to view information, some have authorities to edit or change the records.

Responsibilities:

Responsible for development and maintenance of intranet Web applications, get data and reportsusingASP.NET, C#, SQL Server 2005.

Deployed ASP.Net Web Site on IIS web server using web deployment project.

Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid, Data List, Data

Data Grid and Data Reader for binding data from database to the various web forms in ADO.Net.

Involve in Design Web Pages.

Provided production support.

Environment: C# 2.0, Visual Studio 2005, Framework 2.0, Web Services. SQL Server 2005.

Programmer Analyst, Go4Solutions for Go4Solutions. 05/05 – 12/06

MediSoft

This is an intranet Application. Organization has its own medical section for its currently working staff. Record related to each/every medical for example to whom it is issued, who referred, who advice, what is status of medical stock, weather referred to hospital, type of disease for itself or for spouse etc. after completing entry report will generated. This is very good and very user-friendly software most of the information is generated automatically after entry of related information.

Responsibilities:

Extensively used Data Adapter, Data Set, Data Table, Data View, Data Grid, and Data List.

Data Grid and Data Reader for binding data from database to the various web forms in ADO.Net.

Involve in Design Web Pages.

Involved in analysis and development of the Project.

Environment: C# 2.0, Visual Studio 2003, Framework1.1, Web Services. SQL Server 2000.

EDUCATION:

Master in Computer Application from Jamia Millia Islamia University, India.

Bachelor in Science from Jamia Millia Islamia University, India.

Contact this candidate