.net/database Developer Resume
CaliforniA
SUMMARY
- 8+ Years background in diverse facets of .NET/Database development, encompassing analysis, design, development, and execution of business applications.
- Experienced in all aspects of Software Development Life - Cycle (SDLC) and QA Life Cycle.
- Good experience and knowledge on SCRUM (Agile) framework.
- Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.
- Developed solutions as part of technical activities like Proof of Concept Build and Demonstration.
- Developed server-side software solutions by studying information needs, conferring with other users and studying system’s flow, data usage and work processes and following software development life cycle.
- Familiarity in the following areas:ASP.NET Identity Management, single sign-on, directory schema, namespace, resource provisioning, role-based access Control, user lifecycle.
- Strong working knowledge understanding and experience in C#, ASP.Net, .Net Framework, MVC, WCF, WPF, JavaScript, J-Query, HTML5, CSS3, XML, Angular JS.
- Effective leadership skills with good written, verbal communication and presentation skills. Self-motivated with result-oriented approach.
- Documented and demonstrated solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear codes, prepare and install solutions by determining and designing system specifications, and programming.
- Improved operations by conducting system analysis, recommended changes in policies and procedures, developed web pages and web reports.
- Determined operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions.
- Expert in Implementation of ASP.NET technologies and Database Management.
- Strong knowledge and familiarity of SQL Server 2008/2008R2 and Visual Studio 2012, 2014.
- Worked on SSIS application to migrate data from legacy databases to proposed database, to archive the data from active to archive database and to import data from various file formats to database, worked on various kinds of SSRS reports.
- Experience in developing Stored Procedures, Functions and Triggers for the implementation of data integrity using SQL, T-SQL, ORACLE.
- Worked on creating SharePoint Sites, sub sites, lists, libraries, forms and workflows.
- Created forms and workflows to automate the change request process using SharePoint designer and InfoPath forms.
- Experience working with and willing to carry out the skills in Artificial Intelligence - Machine Learning.
- Facilitated sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.
- Educated and reinforce scrum methodology and agile framework to team members and key stakeholders.
- Planned and monitored project budget/spending.
- Tracked and managed product backlog, burndown metrics, velocity, and task breakdown.
TECHNICAL SKILLS
Programming Languages: C, C++, C# and VB
Scripting Languages: Java Script, VB script, AJAX, XML, JQuery
Web Servers: IIS 8.0/7.0/6.0/5.0
.NET Technologies & Framework: ASP.NET, MVC, ADO.NET, LINQ, WCF, WPF, Entity Framework, Angular JS, Web API, REST API
Artificial Intelligence - Machine Learning: Azure Cognitive Services (LUIS - Language Understanding Intelligent Service), Bot Framework, QnA Maker
Markup Languages: XML, XAML, HTML5, XSL, XSLT, CSS3, Bootstrap
Databases: SQL Server 2016/2012/2008/2005/2000/7/6.5 , MS-Access 2000, Oracle 10g
Testing Frameworks: NUnit
Operating Systems: Windows NT/95/98/2000/XP/Vista, Unix
Development Tools: Visual Studio 2015/2013/2012/2010/2008/2005/2003 , .NET Framework (4.6/4.5/4.0/3.5/3.0/2.0/1.1/1.0 ), Visual Source Safe (VSS), SSRS, TFS (Team Foundation Server) 2008/2010/2012/2013
Code Analysis Tools: FxCop, ESLint, HTMLHint, CSSLint
Build and Deployment Automation: TeamCity, Octopus Deploy
Other tools: Erwin, MS Visio, MS office 2010
Development Practices, Cultural Philosophies: DevOps
PROFESSIONAL EXPERIENCE
Confidential
.Net/Database Developer
Responsibilities:
- Analyzing various system requirements, data flow charts, and system design.
- Involved in Design and Implementation phases of software development lifecycle.
- Used Multithreading to monitor objects.
- Migrated WinForms desktop application to an ASP.NET MVC to achieve separation of concerns.
- Developed custom controls to enable reusability.
- Displayed data in tabular form based on the criteria selected using Data Grid control.
- Used JQuery and JavaScript for Client Side Validation.
- Created Custom Validation Attributes for validation rules that are specific to business.
- Used ADO.NET to interact with Oracle database. Used .NET Framework Data Provider for Oracle, worked with Oracle data types and their mappings to the OracleDataReader.
- Extensively wrote and used stored procedures and database triggers.
- Performed Unit Testing using NUnit Test and Integration Testing and Regression Testing.
- Used GIT for Version Control and Continuous Integration.
- Troubleshooting, Change Request, and Production support by doing bug fix and making enhancements in the applications.
- Followed Devops procedures for automated deployment. Used Jenkins to build and deploy the code from GIT to Test and Production Servers.
Environment: C#, ASP.NET, Oracle SQL Developer, Visual Studio Professional 2019, GIT (Version Control and Continuous Integration), Jenkins.
Confidential, California
.Net/Database Developer
Responsibilities:
- Analyzing various system requirements, data flow charts, and system design.
- Involved in Design and Implementation phases of agile software development lifecycle.
- Implemented ASP.NET MVC design pattern for developing the web application.
- Created Repositories as DAL using Database First approach using Entity Framework.
- Analyzed Database Models and determined Data Relationships and created a Relational Database Model.
- Created Complex Stored Procedures to support Business Rules Engine.
- Created User-Defined Functions for all computational operations in the system.
- Created theUser Accounts and Profiles, assigned permissionsusing Active Directory.
- Implemented a C# library project that would accessAD Active Directoryto authenticate users.
- Used MVC5, HTML5, CSS3 and jQuery to create pages and views. Used Layouts and Partial Views for code reuse and consistent look and feel of web pages.
- Used Areas to partition the application into smaller units to make it more manageable.
- Created Custom Validation Attributes for validation rules that are specific to business.
- Used Bootstrap to make web pages responsive.
- Designed and Developed User Administration modules to allow DPR Internal users to create and configure business rules and workflows in the system ensuring the security of data and files.
- Implemented Business Rule engine that validates various business process with configurable business rules.
- Performed unit testing of the application using NUnit Test.
- Used TFS for Version Control and Continuous Integration.
- Followed Devops procedures for automated deployment. Used Jenkins to build and deploy the code from TFS to Test and Production Servers.
Environment: C#, ASP.NET MVC5, HTML5, jQuery, CSS3, Twitter Bootstrap, Entity Framework 6.2, SQL Server 2012, Visual Studio 2015, TFS (Version Control and Continuous Integration), Jenkins, JIRA (Bug Tracking).
Confidential
.Net Developer
Responsibilities:
- Integrated web chat into MyKomatsu application using Azure Bot Service, built a web chat inside the application.
- Used the backchannel mechanism to exchange information between client and bot.
- Customized web chat component by enabling speech capabilities and styling.
- Designed Rich Cards in JSON format to accommodate representation of data in response to user’s prompt or request.
- Identified use case scenarios and implemented various conversational patterns for Bot chat in MyKomatsu application.
- Integrated FAQs into Bot using QnA Maker which is used to build, train and publish a simple question and answer bot based on FAQ structured document.
- Used LUIS, a machine learning-based service to build natural language understanding into bot. Created custom models and continuously trained the model to improve the language understanding.
- Stored data captured from web chat (such as Chat history, Rating and Feedback from user) in Azure Cosmos DB.
- Stored all non-relational data in Azure Storage using Blobs and tables.
- Used Azure App Service for hosting the web application as a Website with Azure SQL Database and REST API in Azure.
- Implementation of Office 365 and Azure Active Directory for single sign-on, authentication, authorization and Azure Role-based Access Control (RBAC).
Environment: .NET Framework 4.5, Visual Studio 2015, Microsoft Azure, Microsoft Azure (Cognitive Services), LUIS (Language Understanding Intelligent Service), Bot Framework, Microsoft Azure QnA Maker.
Confidential
Software Engineer
Responsibilities:
- Designed web pages using HTML 5 in ASP.NET MVC 5 Application.
- Created template JS files with JQuery, JavaScript for all client-side operations and implemented Module pattern approach, which was then implemented for all business submodules. Performed code analysis using ESLint to identify errors or problems in the code pattern.
- Defined a relational database model for the new application. Performed data migration from legacy database (Paradox) to SQL database.
- Created pseudo service layer with database operations for each business module. Used ASP.NET Entity Framework Reverse POCO generator for generating entities. Used Unit of Work and Repository Pattern for all business operations. Used LINQTOSQL for querying the data.
- Developed reports using SSRS and Deployed SSRS solution on premise for creating, publishing and managing reports that are viewed/accessed by right users in different ways (Through Reporting Web Portal in web browser and Report Viewer in Web Application). Also installed Report Builder for users to build custom reports with SQL Server as data source.
- Used Build Management tool called TeamCity to automate build each time a check-in happens in TFS and used “Octopus Deploy” which is a deployment automation system to automate software release into Testing (QA), Staging (UAT) and Production environment.
- Sharepoint Portal Maintenance: Used SharePoint for various purposes of project management and created lists, collections and site contents such as Document Management, Bug or Issue Tracking, Burn Charts, Action Items List. Created comprehensive dashboard on SharePoint portal for client. Developed and modified SharePoint privileges to site contents in compliance with all standard operating procedures for users in different departments.
- Project Management: Followed Agile Methodology to ensure optimal time utilization. Participated in Sprint Planning Standups. Led Sprint Reviews and Daily Scrum Meetings to touch base with whole team, track the progress and closely identify any risk ahead of time.
Environment: .NET Framework 4.5, Visual Studio 2015, SQL Management Studio 2016 Enterprise Edition, C#, Java Script, JQuery, IIS 8.0, TFS, MS Visio 2013.
Confidential
Software Engineer
Responsibilities:
- Gathered requirements and designed a workflow for all the phases of lien servicing. Created Use Case Diagrams and Activity Diagrams for the application using Microsoft Visio 2013.
- Designed and implemented an ASP.NET MVC application using .NET Framework 4.5.
- Developed pages using HTML 5, Bootstrap, CSS, and Typescript in application framework Angular JS. Wrote WEB API for driving JSON based RESTful clients and handle browser routing.
- Implemented Single Sign-on (SSO) and LDAP to partner DFL services and applications with third party websites.
- Extensively used Angular Routing to provide easy navigation in the application.
- Used XML based procedures for ADO.NET objects to facilitate importing of XML datasets into SQL Server 2012 database.
- Wrote complex SQL queries, stored procedures and user defined functions using TSQL.
- Designed RDLC files to generate reports inside the application.
- Managed team with 10 developers and 1 technical lead. Created weekly burn charts.
- Hosted the application on Internet Information Services (IIS 8.5) on the production servers.
- Involved in Troubleshooting, Change Request, and Production Support by doing Bug Fix and making enhancements in the application.
- Used Microsoft Team Foundation Server for version control, Database server project and individual task status.
Environment: .NET Framework 4.5, Visual Studio 2012, SQL Management Studio 2012, C#, Java Script, Angular JS, JSON, Fiddler, IIS 8.0, TFS, MS Visio 2013.
Confidential
Software Engineer
Responsibilities:
- Gathered requirements and designed a workflow.
- Designed and implemented an ASP.NET, MVC application using Entity Framework and .NET Framework 4.5.
- Developed pages using HTML, JQuery and wrote WEB API for driving JSON based RESTful clients and handle browser routing.
- Created Restful service and an adapter to contact Calabrio system.
- Used Entity Framework Reverse POCO Generator for generating code first POCO (Plain Old CLR Object) classes, configuration mappings and DBContext.
- Used Repository Pattern and Unit of Work to facilitate importing and extracting datasets from SQL Server 2012 database.
- Managed team of five developers. Created weekly burn charts.
- Hosted the application on Internet Information Services (IIS 8.5) on the production servers.
- Involved in troubleshooting, addressing Change requests and making enhancements in the application.
- Used Microsoft Team Foundation Server for version control, Database server project and individual task status.
Environment: .NET Framework 4.5, Visual Studio 2012, SQL Management Studio 2012, C#, Java Script, JQuery, JSON, Fiddler, IIS 8.0, TFS, MS Visio 2013.
Confidential
.Net Developer
Responsibilities:
- Designed and implemented application using .NET Framework 4.0.
- As a Developer, involved in portal UI design using WPF, C#.
- Developed features like custom paging, sorting in Data Grids with Up/Down Key Stroke.
- Development of new features and Maintenance (Bug Fixes) and wrote stored procedures in SQL Server 2012.
- Used XML based procedures for ADO.NET objects to facilitate importing of XML datasets into SQL Server 2012 database.
- Created Work Flow Diagrams for the applications using Microsoft Visio 2013.
- Created Windows Service Applications using .NET Framework 4.5, development tool Visual Studio 2012, Java Script, C# and installed the services in Windows 8.1 and involved in Maintenance of the services.
- Deployment of the applications on the production servers.
- Involved in troubleshooting, Change request, and Production support by doing bug-fix and making enhancements in the application.
- Worked on Microsoft Team Foundation Server for version control, Database server project and individual task status.
Environment: .NET Framework 4.0/4.5, Visual Studio 2012, SQL Management Studio 2012, C#, Java Script, WPF, LINQ, TFS, MS Visio 2013.
Confidential
Graduate Assistant
Responsibilities:
- Study and Analysis of Requirements
- Designed ER Diagrams and UML Diagrams using Argo UML.
- Designed a Relational Database.
- Created a Data Dictionary which involved analysis of Object Requirements and their corresponding Attribute Requirements.
- Developed Database which includes tables.
- Tuning SQL Queries.
- Designed web forms using HTML and CSS
- Exporting and Importing of data. Updating and retrieving from database using PL/SQL.
- Analyzing and validating database objects.
Environment: Argo UML, SQL, PL/SQL, HTML, CSS, Windows 8.
