Sql Developer Resume
Summary:
More than 10 years of experience in Software development especially in developing Web based, Internet/Intranet, Client-Server, Distributed Architecture applications in Microsoft technologies using Object Oriented Methodology.
- Involved in all the phases of the software design starting from analysis and creating requirement document and feasibility of the product to its completion.
- Experience in Product Development and Service Applications.
- Good Experience in .NET 2.0, 3.5 and 4.0 Framework (C#, VB.NET, ASP.NET, Web Services, ADO.NET, ADO.NET DATA Service, LINQ to SQL, AJAX, Remoting, Multithreading, Reflection, Delegates, WCF), VB 6.0 (COM, MTS), COM+, JQuery, JavaScript and JSON.
- Good Experience in developing report using Crystal Report 8.0/10, SQL Server Reporting(SSRS)
- Experience in Databases MS SQL Server 7/2000/2005/2008R2, Oracle and Ms Access.
- Experience in Windows NT, Windows 2000, Windows 2003, Windows 2008 R2, Windows XP and Windows 7.
- Experience in Version Control Tool like TFS
- Experiences in develop set up (installation kit) using WIX 2.0/3.0, Microsoft set up project.
- Experience in Designing object oriented applications using UML, Visio.
- Very strong Experience in Design Patterns like Creational, Structural & Behavioral patterns.
- Good Experience in Microsoft Enterprise Architecture, Patterns and Practices and SOA
- Good Knowledge in .NET/COM+
- Experience in manipulating XML, Converting Data between ADO.NET and XML and Proven Knowledge in DTD, Schema, XSL (XSLT, XPath, XQuery) and LINQ to query XML doc
- Good Experience in third party components(Telerik, Infragistics and ComponertArt) for ASP.Net Webforms
- Good Experience in Visual studio 2003, 2005, 2008 and 2010
- Good team player.
- Good Experience in LINQ and ADO.NET Data service.
- Good Experience in Java script.
- Good Experience in different Tools like N-unit, FxCop, Ants profiler, TFS
- Good Experience in IIS configurations.
- Good Experience in Release Management.
Operating Systems: Windows 7/XP/2000/2003/NT/98/95
Languages: C#, VB.NET, Windows Communication Foundation (WCF),
Visual Basic 6.0, Ado.Net, WinForms, Web Forms, .Net Controls,
WIN32 API, T-SQL.
Databases: MS SQL Server 2008R2/2005/2000/7.0, Oracle 9i, MS Access
Programming Environments: Visual Studio.NET 2003 /2005/2010, Visual Studio 6.0
Web Technologies: ASP.NET, WebServices, XML, XSL, CSV,XSD,XSLT,SOAP,WSDL, HTTP,XAML,DOM, DTD, XML Schemas, HTML,CSS, DHTML
Web Servers: IIS 7.0/6.0/5.0
Middleware: COM+/DCOM, .Net Remoting, Web Services, MTS, Active directory API.
Data Access: ADO.NET, ADO.
Scripting Languages: Java Script, JQuery
Reporting Tools: Crystal Reports 8.0,10.0, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).
Tools: Component One, NUnit, NAnt, FxCop, NDoc, Cruise Control, Microsoft Project, Ants profile, MSBuild.
Modeling: UML, Model-View-Controller (MVC), IOC, DI, Enterprise Architect
Version Control Tools: TFS.
Others: MS Project, MS Office, MS Excel 2000 & 2003.
Education:
- MCA (Master in Computer Application
Experience:
Confidential, June 2010 – till date
Project: iAPPS Product Suite
Description:
‘iAPPS’ is converted to a products suite by integrating all products as a single unit. It allows to login to all four products with a single login system and independent product license. User level permissions are implemented in product level as well as site level. Implemented file system sharing between shared sites which are created using our content management system with the help of DFS. Inter communication between these four products and shared sites are handled using SSO. We used Desaware to implement the product level license. We are enhancing all products by adding new features and tuning the performance with bulk load data testing. Converted all our products to Dotnet 4.0 and upgraded the database from SQL 2005 to SQL 2008.
Responsibilities:
Analyzing the new changes and requirement based on the current market.
Involved in database design.
Involved in coding and release process.
Key member of the product integration with other existing products.
R&D to achieve the required functionality
Actively participated in the agile management (SCRUM) i.e. planning project backlogs, 2 week sprints and daily stand up meetings to analyze the time frame and report the status of the project.
Involved in Unit Testing and Integration Testing of different modules
Actively involved release management.
Configuring site in SAAS environment using IIS.
Configuring database mirroring and log shipping.
Written WCF REST application to handle the help module of CMS product and it hosted in our demo site. All other implementations are calling this REST service to access the help of current viewing page.
Used Microsoft Enterprise Libraries for Exception handling, Caching, Logging, validation
Environment: .Net Framework 4.0, ASP.NET & C#, SQL-Server 2008, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, ADO.NET entity framework, Microsoft Enterprise Library, IIS7, XML, XSLT, XPath, Task Scheduler, WCF.
Confidential, January 2010 – May 2010
Project: Marketier Product [iAPPS Marketier]
Description:
iAPPS Marketier will provide a marketing lifecycle management tool that will include customer transaction analysis, email management, surveys and polls, event registration and issue tracking to measure campaign ROI and client satisfaction. Website content and user profiling will be leveraged to deliver targeted campaigns and stronger customers relationships. The email management features will provide comprehensive reporting capabilities including success rate, and recipient activity such as click-thrus and opt-outs. iAPPS Marketier will seamlessly integrate with leading CRMs such as Salesforce.com and leading ad banner engines such as Google.
Responsibilities:
Involved in database design.
Involved in coding and release process.
Key member of the product integration with other existing products.
R&D to achieve the required functionality
Actively participated in the agile management (SCRUM) i.e. planning project backlogs, 2 week sprints and daily stand up meetings to analyze the time frame and report the status of the project.
Involved in Unit Testing and Integration Testing of different framework Modules
Environment: .Net Framework 4.0, ASP.NET & C#, SQL-Server 2008, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, ADO.NET entity framework, Microsoft Enterprise Library, IIS7, XML, XSLT, XPath, Task Scheduler, WCF.
Confidential, March 2009 – December 2009
Project: eCommerce Product [iAPPS Commerce]
Description:
iAPPS Commerce makes the shopping experience intuitive, easy and fun for every customer, every time. When site visitors are able to browse product categories and effortlessly search for products by keyword, price, or other attributes, they have a more enjoyable experience, leading to greater customer loyalty. Prominently displayed promotions, sales, and featured products drive customers to the items you want them to see first. Visitors to your site are able to create their own user accounts, create Wish Lists, email product pages and even rate products on your site—with all of these elements coming together to brand their visit as personalized. Personalized experiences drive repeat visitation and build that customer loyalty you are striving for.
This commerce product is integrated with iAPPS content management and iAPPS Analytics.
Responsibilities:
Involved in database design.
Key member of the architecture team
Involved in coding and release process
Key member of the product integration with iAPPS CMS & Analytics
R&D to achieve the required functionality
Actively participated in the agile management (SCRUM) i.e. planning project backlogs, 2 week sprints and daily stand up meetings to analyze the time frame and report the status of the project.
Written WCF to calculate state tax and packing charges
Used UPS tracking webservice to track the delivery item status
Environment: .Net Framework 3.5, ASP.NET & C#, SQL-Server 2008, WCF, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, ADO.NET entity framework, Microsoft Enterprise Library, IIS7, XML, XSLT, XPath, Task Scheduler.
Confidential, February 2008 – December 2008
Project: Web Analytics Product [iAPPS Analyzer]
Technology: ASP.NET 4.0 & C#, SQL-Server 2008, Webservice, SSRS, ETL, SSIS, SSAS, MDX, IIS, XML.
Description:
Web Analytics product provides users the ability to manage, measure and optimize their web presence by recording detailed events and subsequently mine data within a web application for statistical analysis. Users will understand where their visitors are coming from, what content and products their viewers are most interested in, and how they navigate through a particular web application. Through user-definable web reports the product provides important insight into areas like visitor usage, content access, age of content, actions taken, and event triggers, and will report on both client- and server-side events. This product is a part of suite of products which is built on top of custom framework. SSRS is used for reporting purpose.
Responsibilities:
Involved in design of warehouse database and creation of ETL packages.
Key member of the architecture team
Involved in coding and release process
Key member of product integration with iAPPS CMS.
Providing technical guidance to the team comprising of mid to junior level developers
Developed Reports using SSRS.
Involved in developing Excel Add-Ins
Environment: .Net Framework 2.0, ASP.NET & C#, SQL-Server 2008, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, ADO.NET entity framework, Microsoft Enterprise Library, IIS7, XML, XSLT, XPath, Task Scheduler, Webservice, SSRS, ETL, SSIS, SSAS, MDX.
Confidential, Mar 2007 – January 2008
Project: Web Content Management System [iAPPS Content Management]
Description:
iAPPS Content Manager allows efficiently developing and maintaining Web site without technical assistance and provides powerful, feature-rich capabilities with an easy-to-use interface designed for business users, combined with complete integration capabilities and flexibility in deployment via hosted delivery. iAPPS Content Manager enables users to manage and deliver content to any web interface from virtually any source to ensure the right content is delivered at the right time, to the right audience. For business users, iAPPS Content Manager provides easy-to-use remote authoring enabling subject matter experts throughout the organization to quickly update and personalize content for their particular areas. For administrators, it provides centralized control and management over site structure and content, workflow, and user access rights. We have used webservice for publishing pages in Content Manager context. It is driven by the windows schedule task and execute in separate thread. SSO technology implemented for the purpose of single sign on facility for multiple sites. We have taken care about the SAAS environment hosting in this product.
Responsibilities:
Involved in database design.
Key member of the architecture team.
Involved in coding and release process.
Key member of SSO implementation.
R&D to achieve the required functionality
Written webservice for publishing page and RSS.
Created XSL, XSLT for data transform.
Written custom controls
Used third party tools such as Telerik controls for Rich Text editing.
Used third party tools such as ComponentArt for inline grid editing.
Written CLR to handle template uploaded to create page in CMS
Environment: .Net Framework 2.0, ASP.NET & C#, SQL-Server 2005, Webservice, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, Ndoc, ADO.NET entity framework, Microsoft Enterprise Library, IIS6, XML, XSLT, XPath, Task Scheduler.
Confidential, June 2006 – March 2007
Project: iAPPS Framework - Application Integration Platform (AIP)
Description:
iAPPS Framework is an Application Integration Platform (AIP) combining application business logic and object relationship management within single software architecture.
AIP wraps various pre-defined core components with custom development to provide a foundation for developing a middle layer component specific to “product / web application” being developed and front-end user interface. Inherent in AIP is license management, permission management and brokering between components.
iAPPS Framework is a set of common and prefabricated software building blocks that programmers can use, extend or customize for specific computing solutions either to develop a industrial strength product or custom web application. With iAPPS Framework, frameworks developers do not have to start from scratch each time they write an application. Frameworks are built from collection of objects so both the design and code of the framework may be reused. All framework blocks are implemented in SOA architecture, because of that developers can extend each provider for their custom implementation.
AIP is the foundation for product suites and custom applications.
Responsibilities:
Involved in database design.
Involved in coding and release process.
Key member of Cruise Control implementation with NAnt, Nunit, NDoc and FxCop
Used Fxcop tool to optimize the code standard.
Written Store procedures and user defined functions.
Environment: .Net Framework 2.0, ASP.NET & C#, SQL-Server 2005, Webservice, Single Sign On(SSO), Reflection, Delegates, TFS, Nunit, MbUnit, FxCop, NAnt, NDoc, CruiseControl, ADO.NET entity framework, Microsoft Enterprise Library, IIS6, XML, XSLT, XPath, Task Scheduler.
Confidential, April 2005 - May 2006
Project: BackOffice
Description:
This Software is designed to handle BackOffice operations in Hotels. This project includes Revenue Reports, Sales Ledger, Purchase Request & Approvals, Food Beverage & Tobacco Stock Ledger, Engineering & Other Stock Ledger, Fixed Assets, Purchase Ledger, Payroll & Personnel Management, Nominal Ledger and Management Reports. Key features: User setup for Reports (Revenue, P&L & Balance Sheet), Electronic Approvals for Purchase Request with Email & SMS alerts, Daily & Monthly FBT Costing, P&L with Budget & Forecast with last year comparison, Interface with Fidelio, Opera, IDS & Micros for PMS & POS details.
Environment: C#, Crystal Reports 8.0, SQL-Server 2000.