Post Job Free

Resume

Sign in

Developer Sql Server

Location:
Chesterfield, MO
Posted:
August 04, 2019

Contact this candidate

Resume:

Sateesh Singirikonda

Location: Longmont, CO *****

Phone: 201-***-****

E-mail: ac9zmr@r.postjobfree.com

PROFESSIONAL PROFILE

•13 years of experience in analysis, design, development, integration, testing, and research and implementation of several business applications in IT industry.

•Excellent experience with application software relating to Sales & Distribution, Inventory management, Banking, Education and insurance.

•Worked on projects using the latest Microsoft technologies such as Visual Studio., C#, VB.NET, ASP.NET, MVC, SQL Server, Oracle and XML Web Services.

•Hands on experience in developing the AJAX enabled websites

•Adopted Microsoft Test Driven approach.

•Developed Windows Communication Foundation (WCF) Services.

•Implemented project in Agile Software Project Management methodologies.

•Experienced in graphical user interface design, database design and web application design.

•13 years of experience of expert level skill in designing and developing software solutions using ASP.NET, C#, VB.NET, ADO.NET, MVC Web services, IIS 8.0, HTML/DHTML/XML, Entity Framework Core, and RDBMS.

•Experienced in working with Design Patterns.

•Implemented REST services using ASP.Net Web API and C#.

•Extensive work experience in supporting existing Production Systems.

•Experience in Microsoft.Net includes understanding. Net Architecture and developing and deploying. NET applications and assemblies.

•Have solid Experience in developing Web Services and Remoting using C#. Net and C# implementing SOAP technology for communication and message definition in web services.

•Experience in AngularJS controllers, directives, components, factory and service resources, routings and events.

WORK EXPERIENCE

International Cruise & Excursions, Inc. (ICE), Scottsdale, AZ

July 2018 – Present

Role: Sr. Microsoft Full Stack Developer

Project: Resort Booking Queue Management

Resort Booking Queue Management is an online web application to manage the resort booking activities associated with all the resorts that get reserved and booked with ICE from all the customers.

Responsibilities:

•Primarily responsible for developing the web applications using C#, Angular, Web API and SQL server.

•Attending daily stand ups to keep the current status updated with the team.

•Participating in the sprint planning meetings to discuss the deliverables associated with each sprint.

•Attending the sprint retrospective meetings to review the all the activities and sprint outcome from previous sprint to get the implementation process outcome improved affectively.

•Developing the presentation logic using Angular, Type Script, HTML5 and CSS.

•Implemented the RESTful services using Web API to communicate the data back forth between UI and enterprise Resort admin database.

•Configured the Entity Framework Core to manage the database CRUD operations with the database.

•Implemented the Data Access Layer using Standard Library.

•Used Git source control to manage the source code.

•Wrote MS tests to do the Unit testing of my won code.

•Environment: C#, Web API, Angular 7, Typescript, .Net Core, Visual Studio 2017, Visual Studio Code, SQL Server 2016, HTML5, CSS, Bootstrap, MS tests, Git

Johnson & Johnson, West Chester, PA (Worked Remotely from Chandler, AZ)

September 2017 – June 2018

Role: Sr. Microsoft Full Stack Developer

Project: Electronic Purchase Order (EPOR)

EPOR is a web based application used by the hospitals and consultants to place the orders on line.

Responsibilities:

•Primarily responsible for developing the web applications using C# and VB.Net technologies.

•Replaced BizTalk Component to interact with DB2 with Windows services to provide integration between ePOR and enterprise ordering database system.

•Implemented the WCF services to provide the communication between mobile applications and ePOR database servers.

•Optimized the data loads using the best practices in SQL server.

•Implemented SSIS packages to host the master data in ePOR application.

•Implemented the SSRS reports for POD documents, generating error reports for the transactions that are didn’t go through and also for the accounting purposes.

•Developing Database Stored Procedures, Functions, Triggers, Views and Cursors.

•Developing packages using SQL Server Integration Services (SSIS) and Reports using SQL Server Reporting Server (SSRS).

•Developing User Interfaces, Business Components, Data Access Layer, Web Services, Windows Services, Windows Communication Foundation (WCF) Services.

•Configuring Test Server and Production Servers.

•Worked on Java Scripts.

•Implemented REST API with ASP.Net Web API mainly to share the master data across the applications.

•Involved in Migrating code to the production and test servers, production support and bug fixing.

•Involved in batch programming using flat files, csv and XML files.

•Developed T-SQL to do bulk updates using XML.

•Environment: Windows server 2008, C#,VB.Net,Team Foundation Server (TFS), Visual Studio 2015/2013/2008/2005, SSRS, SSIS, Entity Framework, MVC4, REST API, WEB API, ASP.Net4.0/3.5/2.0/1.1,C#4.0/3.5/2.0/1.1, 3.5/2.0/1.1, SQL Server 2008, WCF, ADO.Net, Java Script, JQuery,XML, N-UNIT, IIS, IMail, Microsoft Visio 2010

Blue Cross Blue Shield, Phoenix, AZ

July 2015 – August 2017

Role: Sr. Microsoft Full Stack Developer

Projects: CMP (Change My Plan), eSales, Balance & Controls

•CMP is a web application to allow the members and brokers to change their plans during the Open Enrollment.

•eSales is an online application tool to be used by the brokers and members to view plans, generate quotes and enroll into policy mainly for the prospects and members.

•Balance & Controls is a tool to keep track of all the insurance applications received from all the sources and provides statistics of the status of application at individual process level to identify the gaps of the applications processed vs non- processed and fix them.

Responsibilities:

•Primary used the C# language to develop WCF services and to write up models and controllers.

•Implemented WCF services to read and the data at both enterprise and application level databases.

•Used the Model View Controller (MVC) using C# architectural style to implement changes to both eSales and CMP applications.

•Implemented SSIS packages to work on the moving the data between multiple applications.

•Adopted the paired programming to implement the complex piece of logic such as working on the different plans available based on the customer personal information and geographic information.

•Adopted the paired programming to share the application knowledge with in the team to quickly come up to seed to deliver by working on the user stories together.

•Attending daily governance, grooming session’s meetings and code review meetings

•Attending change control board (CCB), sprint planning sessions.

•Attending Retrospective meetings and contributing to the team success by exchanging the thought process and experience.

•Attending the design review meetings and demonstrating the designs that are considered for implementation.

•Worked on documentation to pass the knowledge to peers.

•Optimized different processes to improve the performance of applications.

•Developing Windows Communication Foundation (WCF) Services, business components and data access repositories.

•Worked on Implementing UI.

•Implemented AngularJS Controllers to maintain each view data.

•Implemented Angular Service calls using Angular Factory.

•Making changes to the SQL server databases such as stored procedures, views, tables etc.

•Work with release manager to promote the changes to production.

•Writing Unit tests.

•Implemented calls to WEB API services using AJAX.

•Used JQuery for custom validation, displaying modal dialogues and to make calls to WEB API service layer along with AZAX.

•Design and developed user interfaces in MVC using Razor engine.

•Developed Services using ASP.Net Web API to allow both web and mobile clients to make use of the shared services.

•Environment: Windows Server 2008 R2, Team Foundation Server (TFS), Visual Studio 2015/2013/2012, SSRS, SSIS, MVC5, ASP.Net 4.0/3.5,C#4.0/3.5,WEB API, SQL Server 2008/2012/2014//2016, WCF, LINQ, Angular JS, Entity Framework Java Script, JQuery, N-UNIT, AJAX

Johnson & Johnson, West Chester, PA

October 2009 – May 2015

Role: Sr. Microsoft Full Stack Developer

Project: Electronic Purchase Order (EPOR)

EPOR is a web based application used by the hospitals and consultants to place the orders on line.

Responsibilities:

•Primarily responsible for developing the web applications using C# and VB.Net technologies.

•Implemented the WCF services to provide the communication between mobile applications and ePOR database servers.

•Adopted the paired programming to train the on boarding team members and for knowledge transfer activities.

•Optimized the data loads using the best practices in SQL server.

•Implemented SSIS packages to host the master data in ePOR application.

•Implemented windows services using C# to automate the processing of the order ack files, po completion files and to email the POD (Proof Of Delivery) documents.

•Implemented the SSRS reports for POD documents, generating error reports for the transactions that are didn’t go through and also for the accounting purposes.

•Gathering Functional Requirements and giving Technical Implementation.

•Developing Database Stored Procedures, Functions, Triggers, Views and Cursors.

•Developing packages using SQL Server Integration Services (SSIS) and Reports using SQL Server Reporting Server (SSRS).

•Developing User Interfaces, Business Components, Data Access Layer, Web Services, Windows Services, Windows Communication Foundation (WCF) Services.

•Worked on Java Scripts.

•Involved in Migrating code to the production and test servers, production support and bug fixing.

•Involved in batch programming using flat files, csv and XML files.

•Developed T-SQL to do bulk updates using XML.

•Environment: Windows server 2008, C#,VB.Net, Team Foundation Server (TFS), Visual Studio 2015/2013/2008/2005, SSRS, SSIS, Entity Framework, MVC4, REST API, WEB API, ASP.Net4.0/3.5/2.0/1.1,C#4.0/3.5/2.0/1.1, 3.5/2.0/1.1, SQL Server 2008, WCF, ADO.Net, Java Script, JQuery, XML, N-UNIT, IIS, IMail, Microsoft Visio 2010

Rohm and Haas, Philadelphia, PA

August 2008 – August 2009

Role: Senior Programmer Analyst

Project: Asset Utilization System

The asset utilization system is an analysis tool that offers the opportunity for process improvement by giving businesses a view into their production units and offering insight in ways to improve capacity without capital expense.

Responsibilities:

•Attending Scrums and Retrospective Meetings.

•Developing New Reports using SQL Server Reporting Services (SSRS), User Interfaces using Infragistics controls and Data Access Layer.

•Worked on Java Scripts and VB Scripts.

•Configuring Security for the application.

•Developed Graphical User Interface Implemented asynchronous operations, Windows Communication Foundation (WCF) Services, Web Services, Control-N jobs, and Remoting to implement communication with SAP system.

•Coordinating with Off-shore team to support bug fixing

•Environment: Windows, Team Foundation Server (TFS), Visual Studio.NET 2008,ASP.Net3.5, C #3.5,ASP, VB.Net 3.5, SQL Server 2005, ADO.Net, JavaScript, VB Script, XML, N-UNIT, N-Log, IIS, HTML, SQL Server Reporting Services (SSRS)

Kaplan Inc., New York, NY

March 2008 – August 2008

Role: Application Developer

Project: Nursing

Nursing is one of the core intranet applications being used in Kaplan Inc. Students attending courses such as GRE, GMAT, SAT, LSAT, etc. can log onto the application to give practice tests online. Application gives access to all the available tests for a student and gives both statistical and analytical data that helps the candidate where does he stand and how to excel in final tests

Responsibilities:

•Involved in analysis, design and development of the project, which is based on MVC (Model-View-Controller) Architecture.

•Developed server-side C#.Net code to access database using Native providers.

•Developed deployment procedures and deployed project on to IIS application server

•Used. Net framework for report generator module

•Developed pages with the controls that can dynamically render the client side code.

•Involved with the design of User interface, defined needed Data validations and wrote client side validation scripts using JavaScript.

•Developed Reports using SSRS and DTS Packages to automate the batch processing, Unit, System Test plans for the business analyst to test the application

•Environment: C#.Net 2.0, VB.Net, Net framework 2.0,Visual Studio.Net 2005,, XML, JavaScript, HTML, DHTML, CSS, Windows XP professional, PL/SQL, SQL Server 2005, Visual Source Safe, IIS 6.0.

Grange Insurance, Columbus, OH

December 2006 – February 2008

Role: Application Developer

Project: First Notice OF Loss (FNOL)

This project is used to report the claims by the agent through online. FNOL will save approximately four minutes of entry time for each claim entered by the agent. The quality of claims data has been improved by the use of policy administration system. The agent receives claim notice confirmation and the claim number within seconds rather than hours

Responsibilities:

•Designed and Developed application using VisualStudio.NET with C# as the code behind language

•Extensively working with Data Bound controls like Data Grid, Data Table, Data Reader, Data View and Dataset.

•Responsible for Authentication and Authorization of user

•Implemented Role based authentication.

•Have used the concepts such as Delegates, Events, and Multi-threading to make the performance of the application improved to the maximum extent.

•Responsible for Writing Stored procedures for acquiring the needed information based on search item criteria

•Deployed Web Services using WSDL and Web Service with SOAP to add more functionality

•Implemented Remoting using HTTP Channels class.

•Environment: Visual C#. Net, C++, ADO.NET, ASP.NET2.0, PL-SQL, SQL, Oracle 8i, XML Web Services, Windows API (Win32), Windows SDK, Windows 2000, IIS 5.0, HTML, Visual Studio, Visual Source Safe.

Satyam Computer Services Ltd, India

Client: British Petroleum

September 2004 – October 2006

Role:Application developer

Project: OASIS (Online Analysis Statistical Information System)

This project provides online information about oil and gas analyzers. The analyzers are highly complex instruments whose accuracy is critical to the operation of the sites advanced control system (ADCON). The OASIS system provides statistical information to help identify the suspect analysis readings. This means the faulty analyzers or bad lab data can be identified and rectified with the minimum delay.

Responsibilities:

•Developed GUI in Visual Studio. NET using ASP.NET to display the various reports about the analyzers information.

•Data and business Analysis: Involved in Interaction with some of the clients for gathering technical overview how the crude oil is processed

•ASP.Net using C# as a code-behind language and Incorporating JavaScript and Server-Side Control such as Data Grid, Data Reader, Dataset, Calendar for client-side validations.

•Extensively used features provided by SQL Server 2000 to create tables, stored procedures, queries, integrity constraints and rules.

•Deployed web-services using WSDL and SOAP to handle online transactions with central database, which reduces the time required performing data entry.

•Environment: Windows XP, Visual Studio. C#.Net, JavaScript, VB Script, Microsoft SQL Server 2000, ASP. Net, IIS 5.0, ADO.Net.

EDUCATION/STATUS

Bachelors in Computer Science & Engineering, Kuvempu University, Karnataka, 2001

INTERPERSONAL SKILLS

•Having strong management and lead skills.

•Always be part of the solution and not part of the problem.

•Excellent team player skills

•Ability to work under pressure without affecting the quality of the output.

•Understanding the client needs on timely basis and get tuned myself to fit the needs of environment.

•Excellent in identifying the road blocks and communicating it to the team.

•Very good at estimating the efforts for the small scale to large scale of work.

•Strong at troubleshooting issues and identifying solutions.

•Ability to work with every individual by maintaining the good rapport and step in their shoes to understand them in all aspects.

•Being a good listener, I am open to other’s ideas and respect every one’s thought process before I share my ideas on anything.

•Being open to the feedback from other team members and management, I can better understand myself about how others think of me and open to change to become better team player.



Contact this candidate