We provide IT Staff Augmentation Services!

Sr .net/sql/oracle Developer Resume

0/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Over 11 years of experience in all aspects of software development life cycle (SDLC) starting from requirement analysis through development and deployment
  • Worked in Airlines,Technology, Mortgage, Insurance, Title, Real Estate, Ecommerce, property management and the Telecom Company.
  • Experienced in Microsoft .NET Technologies in Framework 4.5/4.0/3.5/3.0/2.0 , C#, ASP.NET, ASP.NET MVC, HTML, HTML5, DHTML, CSS, CSS3, Bootstraps, JavaScript, JQUERY, Angular JS, AJAX (Tellerik controls and Ajax Controls tool kits), XML, XSL, Web Services, Windows Communication Foundation (WCF), Web API, ADO.NET, Linq, Entity Framework, IIS, TFS 2010/2012, Visual Studio, and Share Point
  • Expertise on developing Web Application and Windows Application using various Design Pattern and Models.
  • Worked extensively on Relational Databases using ORACLE, SQL server 2000/2005/2008 , 2008 R2, 2014 along with writing of complex Database Queries, Stored Procedures, functions, Triggers, Views and Cursors using PL/SQL and T/SQL
  • Experienced in Object Oriented Programming and Design (OOPD) using Inheritance, Polymorphism, Encapsulation and Abstraction.
  • Used SSIS for fast data transfers and data cleansing which helps in improving performance, and is reliable.
  • Created various reports using SSRS
  • Well acquainted with Class, Use Case, Interaction and State Diagrams of Unified Model Language (UML).
  • Advanced skills in configuring Security, Privacy and Permission settings at .NET and Database levels, as well as managing Active Directory server and synchronizing user profiles
  • Handled multiple projects and met tight deadlines.
  • Strong communication skills with Customers, onshore and offshore team members.
  • Learned new technologies in work as needed and delivered the product.

TECHNICAL SKILLS

Programming Languages: C#,JAVA, C, C++,PHP,Python

Scripting Languages: JavaScript, JQuery

Markup Languages: HTML,HTML5, XHTML, DHTML, XML

Web Technologies: ASP.NET 4.5/4.0/3.5/3.0/2.0 /1.1,VB Script, XML Web Services (SOAP), WCF, XML, XSL, CSS,CSS3, SSIS

Frameworks & Architecture: Win forms, Web based,ADO.NET

Databases: ORACLE, PL/SQL, MS SQL Server 2014/2008/R2/2005/2000, T - SQL

Reporting Tool: MS SQL Server Reporting Services (SSRS), Infragistics Excel and PDF Controls, MS Excel

Component Technology: .NET Assemblies, .NET Framework, Infragistics Web Controls, ADO.NET, Entity Framework, ASP.NET

Web/Application Servers: IIS 7.5/7/6/5.1

Testing Tool: NUnit 2.4.3

Version Control System: Team Foundation Server(TFS), Visual Source Safe, Subversion(SVN), Star Team

Operating Systems: Win 10/8/7/Windows XP/ 2008/2003/2000

IDEs: Visual Studio 2012/2010/2008/2005 , SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Oracle SQL Developer, TOAD, SQL Plus

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr .NET/SQL/Oracle Developer

Environment: .NET Framework 4.5/4.0, 3.5,3.0 C#, ASP.Net, MVC, ADO.NET, Entity Frameworks, LINQ, ORACLE 9i/10g/11g, PL/SQL, TOAD, SQL Developer, TSQL, SQL Server 2008/2005,JavaScript, JQUERY, Angular JS, AJAX, JSON, CSS, Bootstraps, XML, XSL, HTML, Web API, WCF, Web Services, SSIS, DTS packages, SQL Server Agents, IIS 7.5/7/6, TFS,TDD, FAST TRACK, Visual Studio, Agile

Responsibilities:

  • Confidential is the world’s leading airline and is focused on customer service and providing best traveling experience all around the world with 374destinations with world’s most comprehensive global route.
  • Worked in the Financial System projects like Ticketing System, Data Center Migration, Card System, ChargeBacks, Accertify, uSource, Sabrix, InterfaceBrokers, AP, Refunds, Fraud, and Application/Production/Customer supports.
  • Participated in Requirement Analysis and gathering by involving in daily, weekly, and monthly team meetings and client meetings following the Agile environment
  • Worked in different design patterns and architecture layers for separation of concern and Dependency Injection.
  • Created UI using HTML5, Bootstraps, and Views of MVC design pattern.
  • Implemented Controllers to transfer data between Views and Models.
  • Used authorizations, action, results, and exception filters.
  • ImplentedLINQfor quering, sorting, filtering the complex objects.
  • Angular & knockout JS validation were used to validate fields and provide custom error messages and custom error pages for handling errors.
  • Used Entity Framework to create Models.
  • Added security using Authentication and Authorization in ASP.NET pages
  • Did validations, error handlings, commit and rollback of transcation in the asp.net pages, stored procedures, and packages as required.
  • Developed Complex database objects like Stored Procedures, Functions, Packages, Cursors, Triggers, Sequences, DB Links using SQL and PL/SQL to manipule data into the database
  • Loaded Data into Oracle Tables using SQL Loader
  • Used SSIS to import & export data to/from FlatFile & CSV File from/to database and manipulated the datatype and length according to the requirements.
  • Created the .config file to update the server environments, location, and the connection strings.
  • Did PGP Encryption/Decryption for importing and exporting the file and did file archived using public & private keys.
  • Use a FTP task in a SSIS package to Send and receive file
  • Created SQL jobs to run the operations and schedule them.
  • Used Bootstrap for making control styles quickly.
  • End to End testing, Unit testing, debugging and problem solving
  • Provided support and troubleshoot various projects and system as required, fixed issues, optimized and enhanced the system.
  • Created various work request and change request using the FAST TRACK bench & TFS.

Confidential, Houston, TX

Sr. .NET Developer

Environment: .NET Framework 4.0/ 3.5, C#, ASP.Net, ASP.NET MVC 3/4, Razor, ADO.NET, Entity Framwork, LINQ, TSQL, SQL Server 2008/R2, JavaScript, AJAX, CSS, XML, HTML, HTML5, WCF, Web Services, SSIS, SSRS, SQL Server Agents, TFS 2010/2012, Sharepoint, VS 2008/ 2010/2012 , Agile, VisualCron Jobs, IIS 7.5/7/6

Responsibilities:

  • Stewart is a customer-focused, global title insurance and real estate services company which provides loan origination and servicing support; loan review services; loss mitigation; REO asset management; home and personal insurance services; tax-deferred exchanges; and technology to streamline the real estate process. Offering personalized service, industry expertise and customized solutions for virtually any type of real estate transaction, Stewart is the preferred real estate services provider.
  • Involved in daily 15 mins standup Meetings with all stake holders like team members, Analyst, Project Manager, DBAs, QAs, and Business users following the Agile environment. The sprint cycle was every two weeks and deployments on every other Wednesday night.
  • Team size was about 10 developers and worked individually or in Teams dependings upon the projects size.
  • Worked on multiple projects at the same time, mostly enhancements and supports to the existing projects.
  • Worked on the windows application project called LifeGuard which is used by company to review the loan request by bank customers and moved the data to the Pool Management, which is web based application.
  • Worked on enhancement of different projects like Loss Mitigation System, PSM Printing, NPS, Recrodation Management System, which were all Web based application.
  • Migrated the old asp application to MVC application.
  • Designed UI pages in MVC 3 using partial views and Razor Views.
  • Using MVC 3 implemented clean separation of layers like View, Controller and Model.
  • Used jQuery and java Scripts for validations and pop out windows.
  • Created and altered complex Stored Procedures, Views, Functions, Triggers using SQL server 2008 R2 to retrieve data from the database and manipulation of data into the database
  • Used Temp table and table variable, TVP for bulk data move, and created and replaced cursors.
  • Used SSIS to transfer data to and from FlatFiles/Excel/Database tables.
  • Created SQL and Visual Crons jobs to run the operations and schedule them.
  • Unit testing, debugging and problem solving.
  • Used Authentication and Authorization for security using config file.
  • Used SSRS for creating new and existing reports as the .rdl file and deploying them.
  • Created various work request and change request using TFS 2010/2012 and SharePoint.
  • Did application support like data fix,bugs tracking, and provided solutions to fix the problem.

Confidential, Houston, TX

Sr. .NET Developer

Environment: .NET Framework 4.0/ 3.5,3.0 C#, ASP.Net, MVC, ADO.NET, LINQ,TSQL, SQL Server 2008/2005, JavaScript,JQUERY, AJAX, JSON, CSS,, XML, XSL, HTML, Web Services, SSIS, SSRS,DTS packages, SQL Server Agents, TFS, FAST TRACK, VS 2005/2008/2010 , Agile, VSS, IIS 7.5/7/6

Responsibilities:

  • Continental Airlines was a major American airline that merged with Confidential . United Air Lines Inc., operating as Confidential, is a U.S. airline and the worlds largest airline with 86,852 employees and operating the second-largest fleet with 702 aircrafts.
  • Company has many financial system projects which I worked on Fuel Management System, Brainware, FAMEUA, FISCAL, Travel Card Management, WEB AP. Also, I involved in moving data and transcation from continental airlines to Confidential .
  • Participated in Requirement Analysis and requirements gathering by involving in daily, weekly, and monthly team meetings and client meetings following the Agile environment.
  • Worked in different design patterns like MVC( Model View Controller), 3 tier’s architecture like Presentation layer, Data Layer, and the Business Layer for separation of concern and Dependency Injection.
  • Involved in designing and developing the User Interface in ASP.NET and used custom controls using Asp.Net, HTML and CSS to achieve uniform template design for the entire application
  • Used various .NET server controls, JavaScript, and Ajax control Tool for creating ASP.NET web forms and pages.
  • Created user input validation using various validators and security in page using Authentication and Authorization in in ASP.NET pages
  • Experience in implementingerror handling, exception management, tracingandloggingfeatures
  • Used SSIS to import & export data to/from FlatFile & CSV File from/to database and manipulated the datatype and length according to the requirements.
  • Created the .config file to update the server environments, location, and the connection strings.
  • Use a FTP task in a SSIS package to Send and receive file
  • Created and altered complex Stored Procedures, Views, Functions, Triggers using SQL server 2005/2008 to retrieve data from the database and manipulation of data into the database
  • Used Temp table and table variable, created Cursors and replaced cursors.
  • Created jobs to run the operations and schedule them.
  • Migration of database between Servers, backup of database, imported and exported of tables and rows of the database table. Receiving and Sending data and information using XML web services
  • Unit testing, debugging and problem solving. Used TFS for repository and SSRS for reporting
  • Worked in the support team to fixed the ticket issued (production data fix), did major changes in the failed project and added system enhancement as assigned.
  • Created various work request and change request using the FAST TRACK bench and company customized form.

Confidential - Houston, TX

Sr. .NET Developer

Environment: .NET Framework 3.5, C#, ASP.Net, Web Services, ADO.NET, TSQL, SQL Server 2008/2005, JavaScript, AJAX, JSON,CSS, XML, HTML, Agile, Star Team, SSRS, IIS 7/6

Responsibilities:

  • HP is an American multinational information technology corporation that provides products, technologies, software, solutions and services to consumers, small- and medium-sized businesses (SMBs) and large enterprises, including customers in the government, health and education sectors
  • Project Vista is the migration of legacy web application to the .Net framework. Vista has the same workflow, functionality, design as the old application but it is more users friendly. The new application includes missing functionality and is more dynamic for any future changes
  • Participated in Requirement Analysis and requirements gathering in the Agile environment
  • Involved in designing and developing the User Interface in ASP.NET and used custom controls, HTML and CSS to achieve uniform template design for the entire application
  • Used various .NET server controls, JavaScript, and Ajax control Tool kits like Data grid, Update panel, calendar, cascading dropdown, Accordion, Drag Panel with extensive data binding
  • Created dynamic validation for fields in page, which can be added or removed from database or ADMIN role in ASP.NET page. Created security in page using Authentication and Authorization
  • Created dynamic tracking of change in fields value in ASP.NET form as required by the clients for security purpose. Used stored procedure, dataset, repeater and ADO.net to save and retrieve data from the database. Created and modified Stored Procedures, Views, Functions, Triggers using SQL server 2008 to retrieve data from the database and manipulation of data into the database
  • Migration of database between Servers, backup of database, imported and exported of tables and rows of the database table. Receiving and Sending data and information using XML web services
  • Created custom report and complex queries using TSQL queries. Worked with Onshore and Offshore teams, involved in weekly and monthly team meetings and client meetings
  • Unit testing, debugging and problem solving. Used Star Team for repository and SSRS for reporting

Confidential, Santa Ana, CA

.NET Developer

Environment: .NET Framework 4.0, C#, ASP.Net, Linq to SQL, WCF, ADO.NET,SQL Server 2008, JavaScript, AJAX, JSON, CSS,XML, HTML, NUnit, Agile Scrum, TFS, Telerik Controls

Responsibilities:

  • First American provides financial services through its Title Insurance and Services segment, title plant management services; title and other real property records and images; valuation products and services; home warranty products, banking, trust, and investment advisory services. First American serves homebuyers and sellers, real estate professionals, loan originators and servicers, commercial property professionals, homebuilders and others involved in residential and commercial property transactions with products and services specific to their needs
  • FAMOS is mainly focused for Employees of First American to ease their daily work activities. The goal of the project was to maintain the single page for the whole application, maintain all history and data of customers, automatic assigning of work and approving the customer for title and loan, maintaining security, creating reports with the help of web services and web application
  • Used Agile Scrum Methodology and Repository Pattern for the development of project. Participated in Requirement Analysis and requirements gathering. Involved in designing and developing the User Interface in ASP.NET and used Master Pages, Themes and CSS to achieve uniform template design for the entire application. Creating Web Forms and controls as the User Interface layer using ASP.NET
  • Used Linq to SQL queries and tables to retrieve data from the database. Used various .NET server controls and Telerik controls like Datagrid, Radgrid with extensive data binding to display, page and sort multiple records. Involved in creating various WCF services and deployed on the web using SOAP, endpoint and Basic Http binding and also consumed different Web Services using SOAP, UDDI and WSDL Protocols. Used third party software to create reports in PDF and EXCEL
  • Created Stored Procedures, Views, Functions, Triggers using SQL server 2008 to retrieve data from the database and manipulation of data into the database. Complete Database design process, which includes documentation and Database design stages till creating database and script using SQL, SSRS and SSIS. Used TFS(Team Foundation Server) for repository

Confidential, Bedford, TX

.NET Developer

Environment: .NET Framework 4.0/3.5, C#, ASP.Net, WCF, ADO.NET SQL Server 2008, JavaScript, CSS, XML, HTML, DHTML, TSQL, SSRS, SSIS, NUnit, SVN

Responsibilities:

  • Confidential Technologies Inc. sells auto, property, life and health insurance to more than 300,000 customers in Texas
  • The project is mainly focused on the customer and the different small clients of the Insurance Company. The project stores the information of the customer only after registration, which provides user with username and password. The client will have username and password as well but different roles and more authentication and privilege than the customer. Customer can choose different insurance policies of their choice and have options of paying bills online, edit their profile, policies
  • Used Agile Scrum Methodology and MVC Pattern for the development of the project. Participated in Requirement Analysis and requirements gathering. Developed UI forms for various modules using .Net controls. Creating Web Forms and controls as the User Interface layer using ASP.NET
  • Used stored procedures and ADO.NET to query SQL database. Designed and Developed User Controls (common functionalities throughout the Application) in .NET that are being used on multiple Pages in the Web Application. Used various .NET server controls like Datagrid with extensive data binding to display, page and sort multiple records. Involved in Creating and consuming WCF service
  • Created Complex queries, Stored Procedures, Views, Functions, Triggers using TSQL to retrieve data from the database and manipulation of data into the database. Complete Database design process, which includes documentation and Database design stages till creating the database and script using SQL, SSRS and SSIS. Used SVN for repository and SSRS for reporting

Confidential, Dallas, TX

Developer

Environment: C# 3.0/3.5, ASP.NET, ADO.NET, LINQ to SQL, Visual Studio 2005, Web Services, JavaScript, HTML, XML, IIS 6.0, MS SQL Server 2005, Visio, Visual Source Safe

Responsibilities:

  • Confidential is one of the largest retailer and distributer of over thousands of different type of batteries. The company offers batteries of various types in 50 states at various locations and via internet
  • The Ecommerce portal was mainly focused for the online customers. It contains product categorization, search, payment and so forth. Advance tracking and sales report were also provided via portal to the admin users. The project also replaced legacy application and enhanced the customer experience
  • Analyzed, Designed and developed the core modules. Created all the necessary tables. Used ADO.Net to access Databases. Developed UI WIN forms using C#.Net. Developed User Interface Web forms using ASP.Net and C#.Net for retrieving and manipulation of data in the database
  • Designed 3-tier architecture using C#.Net and ADO.Net. Used CSS for WEB forms
  • Designed the data access layer objects using UML for visualizing, specifying, constructing, and documenting the artifacts of both the layers. Developed and implemented different server controls and user controls to provide the rich user interface reusability
  • Used the intrinsic Cache Object to store frequently used items in the Servers memory for quick retrieval. Used JavaScript to perform client side validation. Used Ajax for partial page execution
  • Developed Web Services using WCF, XML, and SOAP for interoperable software applications
  • Designed group of software development methodologies by using agile software development
  • Worked with Microsoft Visual Source Safe for source control by creating a virtual library of computer files. Unit testing, debugging and problem solving. Design & develop customized reports using Crystal Reports

Confidential, Houston, TX

.NET Developer

Environment: Waterfall Methodology; Windows XP, ASP. Net 1.1, ADO.Net, Visual Studio 2003, JavaScript, XML, HTML, CSS, SQL server

Responsibilities:

  • This site is developed to maintain a group of properties. Only employees of this organization can access this site. This site has different levels of employees like corporate supervisors, supervisors; property managers etc. and privileges are assigned for these employment types. Employees will maintain information regarding applicants and their lease information, Properties, Residents etc.
  • Involved in developing web applications in Waterfall development environment. Involved in designing of secured 3-tier Dynamic Web application by using ASP.NET 1.1, HTML, and JavaScript
  • Developed User Controls and Custom Controls for search and my local components to make parts of application reusable. Programming business classes for Directory and My local components in the middle tier and .NET data access components
  • Extensively used ADO.NET and made use of data controls Datagrid Control throughout the application
  • Involved in designing the database; wrote and maintained complex SQL queries, Triggers, Indexes and the required Stored Procedures using SQL Server 2000. Accessing the data using XML web services to the application e.g. - user authentication, common method
  • Designed UML Diagrams like Use cases, interaction diagrams, State diagrams

Confidential

Developer

Environment: Windows 2000, IIS 5.0, .Net Framework 1.1, ASP.Net 1.1,Winforms, C#.Net, XML, CSS, Oracle 9i, VSS, Java Script, Visual Studio 2003.

Responsibilities:

  • Confidential provides internet and telecom facilities to the customers. The cyber has more than 100 computer systems that are used for accessing internet by the customers. The Time In - Time Out System provides solutions to monitor and measure the time taken by customers after login to the system and calculate the charges based on that. It also stores data and generates reports
  • Involved in the Analysis, design and architecture of the overall application. Implement business logic class library for Data Access Layer through Store procedure and Class structure
  • Implemented business logic as .NET Framework assemblies (C#). Involved in the system right from analysis and designing major objects including SQL Stored Procedures, .NET assemblies, Visual Studio solutions and projects. Developed required .NET Assemblies using C#, ASP.NET, ADO.NET
  • Performed the user screen validations using the DTD and schema in both VB and ASP.NET
  • Generated the reports for Application service provider (Weekly, monthly and yearly)

We'd love your feedback!