Sql Developer Resume Profile
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.