We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

5.00/5 (Submit Your Rating)

EXPERIENCE SUMMARY

  • 14 years of diverse work experience in system analysis, architecture, design, development and implementation of web and windows based software and products for Banking Finance, Manufacturing, Healthcare, Travel and Enterprise domains.
  • Expert level skills and experience in Software Architectures and Microsoft .Net technologies: .Net Framework, C , WPF, WCF, Silverlight, Win Forms, ASP.NET, JQuery and HTML5.
  • Hands on experience with OOAD, UML, Design Patterns and Application Architectures concepts.
  • Experience in all the stages of SDLC including Requirements, Analysis, Design, Development, Testing, Implementation, User Training and Support.
  • Proficient in Distributed Architectures and SOA using Web Services, WCF Services and Web API.
  • Expert in Database Design and writing T-SQL, Stored Procedures, Functions using SQL Server 2008/ 2012 Sybase 10 and exposure to PL/SQL, Stored Procedures using Oracle 11g.
  • Experience in Messaging Solution using MSMQ, IBM MQ Series and SQL Server Service Broker.
  • Expert in generating Reports using Crystal Reports and SQL Server Reporting Services 2008.
  • Experience in software development using various Software development methodologies including those confirming to CMMI Level 5 standards and Scrum.
  • Have knowledge of TOGAF 9.1, Cloud Computing using MS Azure and Mobile Technologies.
  • Experience working in onsite/ offshore model and as a Solution Arch, Tech lead and Team lead.
  • Microsoft Certified Solution Developer MCSD .

Technical Skills

  • Dot Net Technologies: .Net Framework 1.x to 4.5, C , ASP.NET, VB.NET, ADO.NET, Web/ Windows Services, WCF, WPF, WWF, Silverlight 5, LINQ, MVC5, MVVM
  • Web Mobile Technologies: HTML5, CSS3, XML, XAML, XSLT, JavaScript, JSON, JQuery, Node.js
  • Server Technologies: BizTalk Server 2004/ 2006, SharePoint Portal Server 2007/ 2010, IIS
  • Reporting Tools: Crystal Reports 8.0/ 10.0/ 11.0, SQL Reporting Services 2005/ 2008
  • RDBMS: MS SQL Server 2008/ 2012, SQL CE 3.5, Oracle 10g, Sybase 10
  • Application Programming: Visual Basic 6.0, Java 2.0
  • Operating Systems: Windows XP/ 7/ 8, Window Server 2003/ 2008
  • Methodologies: UML, Rational XDE, Rational RequisitePro, RUP, TOGAF 9.1
  • Cloud Computing Others: MS Azure, VS.NET 2010/ 2013, Infragistics Xceed Controls, NUnit, MS Visio, MS Project, MSMQ, IBM MQ, SSIS, SQL Server Service Broker

Work Experience

Confidential

Lead Developer/Architect

Responsibilities:

  • Created System architecture, Technical specs, Prototypes and Application framework design.
  • Managing and leading the team of three offshore developers of PwC India.
  • Worked with Business Stakeholders and Managers to get the business requirements of the projects.
  • Coding for the many web pages, complete database design and application support.

Environment: ASP.NET 4.5, C , HTML5, CSS 3, JQuery, Web API, SQL Server 2012 SQL Service Broker.

Confidential

Responsibilities:

  • Created various prototypes to decide the appropriate technologies to meet the business needs of work online offline mode using WPF, XBAP and Silverlight 4.0.
  • Created the complete architecture and coding for the application framework using XAML and WPF.
  • Implemented MVVM Architectural design pattern to develop this application.
  • Leading the team of six developers both on-shore and offshore of PwC India.
  • Worked with Technical and Analytical managers to get project direction and report on project status.
  • Worked with Business Analyst to make sure the system meeting the business needs of the project.
  • Provided technical assistance to other developers when needed.
  • DB design and coding for the many screens using WPF, Infragistics Ctrls, SQL CE and SQL Server.
  • Prepared a new system design to migrate to SQL Express from SQL CE 3.5 for better performance.

Environment: WPF, C 4.0, WCF, LINQ, XML, Infragistics Controls, SQL CE 3.5, SSIS and SQL Server 2008.

Confidential

Responsibilities:

  • GUI design and coding for a module DBF Converter based on various business rules.
  • Involved in Database Design, creating tables, views, stored procedures and functions in SQL Server.

Environment: ASP.NET 4.0, C 4.0, WCF, JavaScript, JQuery, LINQ, XML, Informatica and SQL Server 2008.

Confidential

Sr. Consultant

Responsibilities:

  • GUI design and coding for the various modules like Define Business, Concentration Report, Issue Level Report, Clean Trade, Trades with Exceptions, User Admin etc. using XAML and WPF.
  • Implemented Infragistics XamChart Controls to create Bar charts, Column Charts, Pie Charts etc. and Xceed DataGrid for WPF to create Data Grids in the above modules.
  • Created our own DataGrid User Control to implement merge cells in the Define Business module.
  • Used LINQ to object for querying large datasets or collection objects.
  • Coding to create a WCF based Web Service as Data Access Layer for interaction with oracle db.
  • Involved in Database Design, creating tables, views, stored procedures and functions in Oracle 11g.

Environment: WPF, C 3.0, WCF, LINQ, XML, Infragistics Charts, Xceed Grid, SAP BO and Oracle 11g.

Confidential

Sr. Consultant/ Tech Lead

Responsibilities:

  • Created Technical Design Specifications for the CSA Exposure and Debt Buy Backs Adjustments Services and their corresponding Reporting modules.
  • User interface design and Coding for the Adjustments related Reports using ASP.NET AJAX.
  • Coding to create a WCF based Web Services to create CSA and Debt Buy Back Adjustments.
  • Involved in Database design enhancements to support the new reports at the native currency level.
  • Code migration from VB 6 ASP to C 3.0, ASP.NET 3.5 AJAX etc. with the upgraded features.
  • Coding for the Unit Test Cases using the Visual Studio Test System of the MS Visual Studio.NET.

Environment: ASP.NET 3.5, C 3.0, AJAX, WCF, LINQ, JavaScript, XML, UML and SQL Server 2008.

Confidential

Sr. Consultant/ Tech Lead

Responsibilities:

  • Requirements gathering, specifications development and prototype designing.
  • Architected and coding for the Web Services required for this application.
  • Implemented security features and transactions in the Web Services.
  • User interface design and coding for the buying new securities module.
  • Used LINQ to XML and SQL for retrieving, inserting or updating the XML and SQL Server data.
  • Involved in Database design, creating Stored Procedures and User Defined Functions.

Environment: ASP.NET 3.5, C 3.0, AJAX, XML, XAML, LINQ, SQL Server 2008 and Sybase 10.

Confidential

Responsibilities:

  • Analysis and understanding of the Software Requirements Specification.
  • Architected and coding for the various enhancements in the Accounts Market Data Module.
  • Involved in the coding to implement some new transaction categories under Activities section.
  • Coding for the new Consolidated View features in PDetail and Unrealized G/L for DSP ML Clients.
  • Implemented AJAX controls to improve user experience and application performance.
  • Creating and executing the Test Cases and troubleshooting the application.

Environment: ASP.NET 2.0, C 2.0, AJAX, TallPDF.NET, ChartFX, XML, XSLT, JavaScript, Web Services, Sybase 10 and SQL Server 2005.

Confidential

Sr. Software Development Engineer/ Tech Lead

Responsibilities:

  • Analysis and understanding of the Software Requirements Specification
  • Leaded technically of the team size 5 and guiding the team for various technical and other issues.
  • Created Technical Design Specifications and coding for the various Interface Agents as Windows Services for Post Burn Processes.
  • Involved in database design, creating Stored Procedures and User Defined Functions.
  • Used AJAX to improve user experience and application performance in asp.net form based reports.
  • Created Consumed Web Services for fetching post burn data and updating the corresponding databases using Windows Services and MQ Series.
  • Coordinate with onsite/ offshore with the US development team on a regular basis.
  • Created, deployed msi installer packages and Production Supports.

Environment: WinForms 2.0, ASP.NET 2.0, C 2.0, AJAX, XML, XSLT, JavaScript, Web Services, Windows Services, Infragistics Ctrls, Log4Net, SQL Server 2005, Oracle 10g and IBM WebSphere MQ 6.0.

Confidential

Responsibilities:

  • Analysis and understanding of the Software Requirements Specification and existing code.
  • Migrations of the applications from ASP to ASP.Net using C .
  • Involved in coding, creating and executing the Test Cases.
  • Involved in understanding the business logic involved in the Project and interacting with the US development team on a regular basis as onsite/ offshore model.
  • Ensure timely deliveries and adherence to the quality plan drafted for the project.

Environment: WinForms 2.0, C 2.0, ASP.NET 2.0, XML, JavaScript, Web Services and SQL Server 2005.

Confidential

Software Specialist

Responsibilities:

  • Analysis and understanding of the Software Requirements Specification.
  • Leaded the module of the team size 4 and guiding the team for various technical and other issues.
  • Preparation of LLD, creating business rules and coding for AOD and Print Productions modules.
  • Designed and generated various reports using Crystal Reports.
  • Implemented multi-threading to handle huge print related work and to generate reports on-demand.
  • Created Tables, SQL Stored Procedures, Views, Jobs and User defined functions for AOD modules.
  • Used OpenXML and pagination in stored procs to handle high volume of data for best performance.

Environment: ASP.Net 1.1, C 1.1, XML, UML, .NET Remoting, JavaScript, Active Directory, NUnit, FxCop, Crystal Reports11.0, SQL Server 2005 and BizTalk Server 2004.

Confidential

Sr. Software Engineer

Responsibilities:

  • Leaded the module of the team size 2.
  • Designing, coding and testing for administrative functions of the reports.

Environment: ASP.Net 1.1, VB.NET, XML, Web Services, JavaScript, SQL Server 2000 and SQL Server 2000 Reporting Services.

We'd love your feedback!