We provide IT Staff Augmentation Services!

Technical Support Analyst Resume

3.00/5 (Submit Your Rating)

Germantown, MD

SUMMARY:

  • Around 12+ years of experience in analysis, client interaction, design and development of client/server, web based and n - tier application. Expert in developing web applications, windows services and web services in Microsoft Visual Studio .Net IDE using, VC++,Pro C*,C#,VB.NET, ASP.NET, MVC, WCF, Web API and SQL Server, SSIS, Oracle 10g.
  • Extensive experience in design &development of N-tier architecture web applications with ASP.NET MVC. Experience with Service Oriented Architecture (SOA).
  • Around 12+ years of extensive experience in business and systems analysis roles identifying problems and/or opportunities and defining solutions through direct involvement in all facets of the software development project lifecycle and thorough experience in client interaction
  • Created UML Diagrams using User & Functional needs, process/data modeling, business/process flows, Workflow Charts, Use Cases, Data Flow Diagrams in MS Visio, prepared informal/formal benchmarking & reporting Dashboard.
  • Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
  • Proficient in developing and maintaining various PLSQL/Database objects like packages, functions,stored procedures, triggers, tables, Views, Materialized views, Indexes, Sequences, partitions, etc.,
  • Extensive experience in SQL Server Database design, SSIS, Database maintenance, developing T-SQL queries, stored procedures and triggers using SQL Server2008, 2012.
  • Good working knowledge in designing Use Case, Class, Sequence, Collaboration, State, Component, Deployment, Activity diagrams using UML
  • Experience in developing Responsive Design using Bootstrap.
  • Experience with Code Review and Code Refactor using tools like ReSharper.
  • Have worked with different SDLC methodologies like Waterfall and Agile(TDD, SCRUM)
  • Adept in using Oracle Tools like SQL Developer, SQL* Plus, Toad, SQL Loader, Data Loader, SQL navigator.
  • Strong analytical skills with proficiency in debugging and problem solving.
  • Coordinated with other teams and led offshore teams to delegate tasks and get updates for the smooth delivery of the project.
  • Handled client standup calls to update them with the progress and report any issues and get clarifications.
  • Avid self-starter, quick-learner with good analytical skills, capable of performing with minimal supervision. An excellent team player with exceptional communication, interpersonal and trouble-shooting capabilities.

TECHNICAL SKILLS:

Languages& Frameworks: C# 4.0/5.0, ASP.NET,VB.NET, .Net Framework 3.5/4.0/4.5, T-SQL

Web Technology: ASP.NET, MVC, ASP, AJAX,XML, JSON, jQuery, JavaScript, HTML, CSS, Web API, Web Services, WCF, ADO.Net, XML, AngularJS

Development Environments: Visual Studio 2013, SQL Server Management Studio

Web Servers: IIS6.0/7.0

Databases: SQL Server2008 R2/2012, Oracle 10g

Automation Test Framework: MS Test

Processes and Methodologies: SDLC, Waterfall, Agile Scrum

Version Tools: Team Foundation Server, Visual Source Safe (VSS), Subversion (SVN)

Utility Tools: Fiddler, Re Sharper, NuGet, SoapUI

PROFESSIONAL EXPERIENCE:

Confidential, Germantown, MD

Technical Support Analyst

Responsibilities:

  • Used agile process and Pair programming for project development.
  • Analyzes requirements and design solutions to meet business requirements. Provides design proposals following best practices considering data, business and service layers for all system changes.
  • To prepare flowcharts and diagrams to illustrate sequence of steps, program must follow and to describe logical operations involved as part of functional documentation using Enterprise Architect (UML tool).
  • To provide technical design and performance changes to handle millions of data involved on the Financial Processing Management System (FPMS)
  • Financial System: VECTOR will interface with an external financial system through daily data file exchanges using the Conduent Secure File Transfer Protocol (SFTP) drop box.
  • To identify bottlenecks and bugs, and devise solutions to problem areas.
  • Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQLs thorough out the projects.
  • Involved in complex data migration and integrating 3rd Parties Library in the current system.
  • Specialist to maintain and enhance the ETC (Electronic Toll Collection) system that is installed on several thousand tolling lanes across. America and which, along with the back office systems, processes more than half of all electronic tolls in the US using C, Pro*C, Oracle/10g on Unix, and C++ on Visual Studio/Windows
  • Extensively used Linux/UNIX shell scripting for file manipulations and automated jobs on the server.
  • Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
  • Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
  • Tuned Report performance by exploiting the Oracle's built-in functions and rewriting SQL statements.
  • Worked closely with end-users and team members to understand business requirements that drive the analysis.
  • Test case/data preparation, execution and verification of the test results.
  • Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.

Environment: Pro*C, VC++, Oracle Database10g, Linux/UNIX, TOAD, SQL*Developer, SVN, Rational ClearCase, PL/SQL, .Net Framework 4.5

Confidential, Jersey City, NJ

Sr. Software Developer

Responsibilities:

  • Estimated timeframe for development, testing and deployment against BRD and successfully delivered on time.
  • Involved in full SDLC, Analysis, Design, Implementation, Testing, Troubleshooting and Deployment of applications targeting MVC4 and .Net Framework 4.5 in VS 2013.
  • Involved in design and development of N-Tier architecture application using MVC Framework, C#, JQuery in Visual Studio 2013
  • Involved in Front-End development using MVC Framework, JQuery, AJAX, and HTML
  • HTML, CSS, Javascript, JQuery, Angular JS, and Bootstrap for developing rich presentation layer.
  • Well exposed to various libraries and 3rd party framework/tools like Highchart, Ajax Library.
  • Involved in design and development of View, Controller, and Model.
  • Implemented ASP.NET MVC Custom Filters (Action filters, Exception filters)
  • Accountable for writing Unit Test and Integration Test using MS Test and practiced TDD (Test Driven Development)
  • Developed stored procedures, views and triggers in SQL SERVER for data manipulation and for retrieving data from SQL Server database.
  • Involved in documentation, maintenance and enhancements of the system.

Environment: ASP.NET, C#.NET, .NET 4.5, MSSQL 2012,MVC 4, MS Unit Test, HTML, CSS, ASP, BootStrap, Javascript, jQuery, NuGet Package, AngularJS .

Confidential, Tulsa, OK

Sr. Software Developer

Responsibilities:

  • Estimated timeframe for development, testing and deployment against BRD and successfully delivered on time.
  • Involved in full SDLC, Analysis, Design, Implementation, Testing, Troubleshooting and Deployment of applications targeting MVC4 and .Net Framework 4.5 in VS 2013.
  • Involved in design and development of N-Tier architecture application using MVC Framework, C#, JQuery in Visual Studio 2013
  • Involved in Front-End development using MVC Framework, JQuery, AJAX, and HTML
  • Implemented Client side functions using Kendo UI components.
  • Involved in design and development of View, Controller, and Model.
  • Implemented ASP.NET MVC Custom Filters (Action filters, Exception filters)
  • Accountable for writing Unit Test and Integration Test using MS Test and practiced TDD (Test Driven Development)
  • Involved in developing Responsive Design for the Agency portal.
  • Developed stored procedures, views and triggers in SQL SERVER for data manipulation and for retrieving data from SQL Server database.
  • Accountable for Code Refactor, Code Review, Code Quality Assurance. Responsible for Production and On-call support on a rotation bases.
  • Applied Agile (SCRUM) practices to daily development including: Daily Scrums, Sprint Retrospectives, Sprint Planning, Sprint Demonstrations, Product Backlog/Story Estimation, Test-Driven Development.
  • Involved in documentation, maintenance and enhancements of the system.
  • Loading pay load data from third parties system to our system using SSIS.

Environment: ASP.NET, C#.NET, .NET 4.5, MS SQL 2012,SSIS, WCF, MVC 4/5, Web API, MS Unit Test, HTML, CSS, Kendo UI, ASP, BootStrap, Javascript, jQuery, NuGet Package, AngularJS .

Confidential

System Analyst

Responsibilities:

  • Involved in analysis (previously documented), design and development of application using Agile Methodology.
  • Interacted with developers and team members to understand the business process.
  • Used AJAX for partial post back to the server.
  • Implemented MVC 3 for UI design and created several partial views for reusability and easy maintenance of the system.
  • Used Data Adapters, Datasets and Command & Connection Objects of ADO.NET to manipulate data.
  • Developed the integration suite using the .Net framework and implemented the format conversion logic in C# as code behind.
  • Using AWS S3 to uploaded candidate transcript and examiner will do their marking on the assignment of course work.
  • Developed the web-based UI in ASP.Net and also used various web controls and CSS for styling and also applied jQuery and Javascript.
  • Worked with ASP.NET web forms, and state management. Used JavaScript for validations and customizations of the front-end screens and controls.
  • Objects oriented programming (OOPS) concepts inheritances, generics, interfacing were widely used for code reusability.
  • Wrote triggers and Stored procedure using PL-SQL.
  • Involved in Normalization of the database and created queries to interact with the database.
  • Integrated Data Access and Exception Handling application blocks for database management and error handling.
  • Involved in integration testing of different modules.
  • Provided full documentation of the system. Involved in the maintenance and enhancements of the system.

Environment: ASP.NET, C#.NET, .NET 4.0, Oracle 10g, WCF, MVC 3, jQuery, HTML, CSS, AJAX, LINQ.

Confidential, Colorado

Senior Software Engineer

Responsibilities:

  • Senior Software Engineer for the complete application.
  • Responsible for gathering requirements from customer support teams/business analyst and convert them into technical specifications.
  • Implemented MVC 2 for UI design and created several partial views for reusability and easy maintenance of the system.
  • Involved in database designing and writing complex stored procedures, functions, views.
  • Client side-validation was carried out using AJAX Control Toolkit and validators provided by ASP.Net
  • Implemented custom role providers and membership providers.
  • Generated various diagrams using MS Visio.
  • Designed different components using C# language for the web application, built on 3-tier architecture with extensive use of object oriented programming techniques
  • Implementing EDI formatting file from various preferred TPA.
  • Worked in migration from legacy system (FoxPro) to Premia collaborator is our Health Insurance product.
  • Batch processing for provider and broker payment.
  • Creating package for month end process to generating bill’s for Group, user, provider and broker.
  • Developed reports using oracle form for the various module.
  • Provider training to new user in Confidential to work on Premia collaborator.
  • Wrote PL-SQL queries with Joins on multiple tables, Stored Procedures, Indexes using T-SQLin Oracle Server.
  • Handling Medicare instruction and coverable while doing insurance quotations for groups or individual.
  • Worked on claim process along with 3rd Parties tool.
  • Developed ACH payment to Confidential based on the customer account details
  • Developed the screens using AJAX.Net for partial post back to improve the responsiveness.
  • Customized the data access module using ADO.NET, to handle the entire transaction with the database.
  • Extensively used CSS and Implemented Master pages for consistent look for web pages.
  • Involved in implementing .NET security with form based authentication, assigning roles and role based authorization using Web.config.
  • ADO.Net is used for Data Access and using Transactions to commit or rollback the transaction

Environment: ASP.NET, C#.NET,VB.NET, MVC 2, WCF, AJAX, Oracle, XML, Window/ Web Services.

Confidential, New York

Developer

Responsibilities:

  • Understanding the client requirements by studying requirement specification and functional document.
  • Involve in providing details on prototype preparation and development estimations.
  • Write code and unit test the enhancements done to the system.
  • Create and modify database objects (table, package) needed for the enhancements.
  • Modify use case diagrams and create activity diagrams as part of functional documentation using Enterprise Architect (UML tool).
  • Do peer review to maintain the quality of the application.

Environment: ASP.NET, C#, .Net 2.0 framework, Visual Studio 2005, Java script, MSSQL Server 2005, XML, Windows 2000 Server.

Confidential, PC

Developer

Responsibilities:

  • Understanding the client requirements by studying requirement specification and functional document.
  • Involve in providing details on prototype preparation and development estimations.
  • Write code and unit test the enhancements done to the system.
  • Create and modify database objects (table, package) needed for the enhancements.
  • Modify use case diagrams and create activity diagrams as part of functional documentation using Enterprise Architect (UML tool).
  • Implement client and server side validation to restrict bad data from reaching the database.
  • Implement an effective error handling mechanism that will log the error, send out a mail to the developers and show a friendly error message to the users.
  • Build a common error page to display to users, in case of any error in the application. Log the application usage.
  • Resolve bugs and implement enhancements

Environment: ASP.NET, C#, .Net 1.1 framework, Visual Studio 2003, Java script, MSSQL Server 2000, XML, Windows 2000 Server.

Confidential, New York

Developer

Responsibilities:

  • Understanding the client requirements by studying requirement specification and functional document.
  • Involve in providing details on prototype preparation and development estimations.
  • Write code and unit test the enhancements done to the system.
  • Create and modify database objects (table, package) needed for the enhancements.
  • Implement an effective error handling mechanism that will log the error, send out a mail to the developers and show a friendly error message to the user
  • Build a common error page to display to users, in case of any error in the application.
  • Admin section with links to various government sites to guide the users in the contract agencies.
  • Resolve bugs and implement enhancements.

Environment: ASP.NET, C#, .Net 1.1 framework, Visual Studio 2003, Java script, MSSQL Server 2000, XML, Windows 2000 Server.

We'd love your feedback!