We provide IT Staff Augmentation Services!

.net/sql Developer Resume

Trenton, NJ

PROFESSIONAL SUMMARY:

  • Software Developer, with over 7 years of experience in application and web development, seeks an opportunity to bring in creativity and innovation in your organization, thus facilitating collective progression of the business.
  • Gathered and analyzed the requirements, created the technical designs followed by development, testing and implementation and troubleshooting. Proficient in Software Development Life Cycle (SDLC) and AGILE methodologies of development process.
  • Experience in .net framework and technologies such ASP.net, C#, VB.net, ADO.net with .net framework 3.0, 3.5, 4.5.
  • Experience in client/server, intranet Web Application development using .net, Windows Communication Foundation (WCF), Entity Framework.
  • Experience in working with divergent technologies including IIS 6.0, HTML5, CSS, Classic ASP, VB6, ADO, VBScript, JavaScript and Ajax Toolkit, AngularJS.
  • Experience in XML technologies. Experience in LINQ.
  • Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
  • Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts and Batches.
  • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications. Worked Extensively on ETL process using SSIS package.
  • Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
  • Good understanding of design patterns such as MVC, Singleton pattern etc.
  • Experience in using SOAP UI for Web service testing.
  • Ensured that the product has been tested properly prior to its launch or distribution. Led the triage for root cause diagnosis and analysis.
  • Dedicated team player to ensure success of the project
  • Experience in working with large team distributed across the geographical locations.
  • Business and functional knowledge of financial and insurance domain.

TECHNICAL SKILLS:

Computer Languages: C#, ASP.NET, VB.Net, SQL, T-SQL,PL/SQL, XML, VB 6.0

Technologies: HTML, HTML5, VBScript, JavaScript, JQuery, CSS, AJAX, AngularJS

.Net Technologies: MVC, LINQ, C#, ADO.NET, Entity Framework, WCF, Web Services

RDBMS: MS SQL Server 2012/2008 R2/2005/2000, ORACLE 10g/11g, PL/SQL/ MS-Access/ OLE-DB/ DTS/ SSIS

Application & Products: BIDS Studio, SSIS, SSRS, Visual Studio, Microsoft Project, Visio, Access, MS Office, Crystal Reports 8.5/8.0, TOAD 8.0, CVS, Team Foundation Server.

PROFESSIONAL EXPERIENCE:

Confidential, Trenton NJ

.Net/SQL Developer

Responsibilities:

  • Involved in Requirements gathering and documentation, Design, Analysis, Development and Migration of the Desktop Based Application to Web Based Intranet Application.
  • Created UI Flowcharts and Wireframes based for all the existing and new features.
  • Developed the intranet based web application, and role based access to the various features of the application.
  • Developed Business Logic Layer & Data Access Layers to implement the MVC architecture. Used database first approach for Entity Framework for database connectivity and transactions.
  • Developed Logical and physical data model using ERWIN and mapped the data into database objects.
  • Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic. Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Assisted in quality assurance measures such as code reviews, test case creation and unit testing, integration testing for different modules.
  • Created and updated T-SQL stored procedures and structural changes to the databases like tables, indexes.
  • Handled Run Time Errors & Design Time Errors by implementing appropriate Error handlers in C#.Net.
  • Utilized Visual Studio Team Explorer (TFS) for source code control and change management.

Environment: Visual Studio 2012, C#.Net, MVC 4.0, T-SQL, jQuery, TFS, IIS 7.0, SSIS, SSRS, MS SQL Server 2008, C#, Visual studio 2008, MS Access, MS Excel.

Confidential, Secaucus NJ

.Net/ SQL BI Developer

Responsibilities:

  • Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
  • Involved in Requirements gathering, Design, Analysis, Development and Customization of the Application.
  • Developed the application using ASP.NET, C#.Net, AJAX, AngularJS JavaScript libraries.
  • Developed the intranet based web application, and role based access to the various features of the application.
  • Created views to restrict access to data in a table for security.
  • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
  • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
  • Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
  • Scheduled the monthly/weekly/daily reports to run automatically.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all
  • Experience handling WCF Services to look up and retrieve the data from Database.
  • Used Team Foundation Server (TFS) to maintain task and project progress.

Environment: Visual Studio 2012,C#.Net 4.5,Asp.net, SQL Server 2008, WCF Services, T-SQL, JavaScript, CSS,SSIS,SSRS, MS Access.

Confidential, Morristown NJ

.Net/ SQL Developer

Responsibilities:

  • Used .Net framework 4.0, n-tier architecture and Object Oriented Methodologies for application development.
  • Gathered requirements and generated functional specifications, technical specifications.
  • DevelopedASP.Netpages usingASP.NET 4.0web form controls, Custom user Controls,HTMLserver controls inC#.
  • Created and updated stored procedures for role based authentication for the web application.
  • Built SQL scripts to create Tables, Queries, Triggers and Stored Procedures.
  • Used Cascading Style Sheets, Master Pages, and Themes for a unified look and feel of the application.
  • Used AJAX Technologies to avoid flickering in web pages, used Ajax tool kit controls to enhance UI experience.
  • Effectively used jQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.
  • Generated different types of reports using SQL reporting services (SSRS).
  • Created WCF Service to look up and retrieve the data from database.
  • Assisted in quality assurance measures such as code reviews, test case creation and unit testing, integration testing for different modules.
  • Used Team Foundation Server (TFS) for source version control on a shared team environment.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Designing and building data load procedures using MS SQL Server.
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

Environment: Visual Studio 2010, .Net 4.0, C#, Asp.net, SQL Server 2008, WCF, Team Foundation Server, SSRS, T-SQL, CSS, IIS 6.0, SSIS, SSRS, T-SQL, Clear Quest

Confidential, PA

Dot Net Developer

Responsibilities:

  • Involved in Requirements Collection, Design, Analysis, Development and Customization of the Application.
  • Designed and developed components using C# and .Net framework classes. Developed Front End UI screens using Web Forms, Server Controls in ASP.Net.
  • Developed connectivity to RDBMS using ADO.NET datasets.
  • Involved in Extraction transformation and loading of data using SSIS for creating packages. Involved in report generation using SSRS.
  • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
  • Dealt with various SQL Server issues while creating tables and relation between the tables, adding, updating and deleting the data in the tables and also developed complex stored procedures, functions, packages using T-SQL.
  • Developed Web Service for retrieving product data (based on XML, WSDL, and SOAP). Involved in Testing Web Services using SOAP UI.

Environment: Visual Studio 2008, C#, ASP.NET 3.5, SSRS, ADO.NET, SQL Server 2008, T-SQL, Java Script, CSS, XML, IIS.

Confidential, Portland, OR

ASP.NET Programmer

Responsibilities:

  • Responsible for the analyzes of the requirements of the business, designing database tables
  • Developed and maintained the applications by utilizing ASP.NET, C#.Net.
  • Developed Web site administration and user management system.
  • Created and updated stored procedures for user authentication and profile management.
  • Responsible for the testing, fixing the bugs and troubleshooting the technical problems
  • Modified applications according to the users requirements
  • Responsible for the development of the template request modules and integrate them with the current applications
  • Train and helped other developers to resolve the technical problems.

Environment: ASP.NET 3.0, Web Service, C# .NET, MS SQL 2008, MS Visual SourceSafe.

Confidential

Software Engineer

Responsibilities:

  • Involved in development and maintenance of the company websites that comes under category e-Business Solution (solution to enhance business of BUPA UK).
  • Responsible to give offshore support to the websites used by BUPA.
  • Defect identification and resolving issues using Test Director/ HP Openview.
  • Involved in Process documentation.
  • Troubleshooting of problems faced by the client.

Environment: C#.NET, VB.Net, ASP.Net 3.0, SQL Server 2000, XML, AJAX, IIS 5.0

Confidential

Software Engineer

Responsibilities:

  • Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
  • Developed the web pages using ASP.NET, AJAX, HTML, and CSS for styling the Web pages.
  • Developed various reports such as billable/non-billable reports, grade wise report give details about employee’s productivity and availability.
  • Responsible for Database support, troubleshooting, planning and migration.
  • Responsible for creating and modifying already existing stored procedures, triggers, views, indexes using T-SQL.
  • Development of Released Resource Report.
  • Involved in Process documentation. Documented upgradation procedures from MySQL to SQL Server and Oracle to SQL Server
  • Conducted Backup Activities and ensured backup has latest code.

Environment: C#.NET, ASP.Net, SQL Server 2000, XML, AJAX, IIS 4.0

Confidential

Software Engineer

Responsibilities:

  • Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
  • Developed the web pages using ASP, AJAX, HTML, and CSS for styling the Web pages.
  • Involved in writing data access layers with C# and ADO.
  • Development of different reports to view employee feedback on response of issues logged.
  • Developed backend Database using SQL Server 2000.
  • Documented all the specifications and code for future .
  • Performed Unit, Integration and User Testing and documented the results.

Environment: ASP, SQL Server 2000, XML, AJAX, IIS 4.0

Confidential

Software Engineer

Responsibilities:

  • Client Requirement Analysis. Extensive client co-ordination.
  • Quality Assurance of the components before porting them to client.
  • Configuration Management of components. Bug tracking and issue resolving.
  • Responsible for analysis, coding, unit & system testing.
  • Responsible in the unit and system integration.
  • Involved in the coding, designing and implementation the system.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using T-SQL, scripts, stored procedures and views).
  • Writing and Executing Functional, Integration, Regression, System Test Cases.

Environment: Visual Basic 6.0, SQL Server 2000, XML, Windows 2000

Hire Now