SUMMARY

• Around 5 Years of experience in Systems Analysis, Design, Development and Implementation in developing Web and Windows using N - tier Architecture involving all stages of Software Development Life Cycle SDLC.
• Extensive experience of designing and developing software applications with the C 4.0/3.5/3.0/2.0 . NET Framework 4.0/3.5/3.0/2.0 /1. x, ASP.NET 4.0/3.5/3.0/2.0 , ADO.NET, AJAX, LINQ, WCF, CSS, Web Services, SOAP, .NET Remoting.
• Experience in implementing several Design Patterns Singleton, Abstract Factory and Observer to standardize the application architecture.
• Excellent experience in Creating, Consuming and Publishing XML Web Services SOAP, WSDL, UDDI using .NET Framework and Solid understanding of Service Oriented Architectures.
• Utilized Unified Modeling Language UML technologies for a complete view of the application including class diagrams, sequence diagrams, activity diagrams.
• Responsible for designing Presentation Tier web pages using the concepts such as Master Pages, Themes, Skins, HTML, XML, CSS, Java Script, JQuery and Worked with ASP.NET Custom Controls.
• Extensive work experience on Web based and Windows applications using C, VB. NET, ASP. NET, ADO. NET, AJAX, JavaScript, VBScript, XML, CSS, HTML, Browser compatibility, DHTML Technologies, XSLT, XML, XHTML, Serialization, .Net Remoting, CSS, Reflection, Multithreading, N-Unit, State Management ASP.Net Caching.
• Experience in using Language-Integrated Query LINQ to Objects, LINQ to XML, and LINQ to SQL and retrieve data from different data sources.
• Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access databases like SQL Server 2008/2005/2000 , Oracle 11g/10g/9i.
• Extensive experience in relational database development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Cursors and Functions using T-SQL and PL/SQL in Microsoft SQL Server 2008/2005/2000 .
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2.
• Experience in SSIS, SSAS and SSRS of MS SQL Server 2008 tools.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services SSRS also expertise in working with Crystal Reports.
• Sound Experience and understanding of SSAS.

TECHNICAL SKILLS

Microsoft Technologies: .NET Framework 4.0/3.5/3.0/2.0 , ASP.NET 4.0/3.5/3.0/2.0 /1. 0, VS.NET 2010/2008/2005 , ADO.Net, WCF 4.0/3.0, Ajax, LINQ

Languages: C 4.0/3.5/3.0/2.0 , VB.Net, C, C++, JAVA, SQL, PL/SQL, T-SQL.

Scripting Languages: Java Script, JQuery, VB Script

Database: SQL Server 2008/2005/2000 , Oracle 11g/10g/9i, MS Access, MongoDB, DB2, MYSQL

Web Technologies: XML, XSLT, XPATH,XSL,IIS 7.5/7.0/6.0/5.0 , CSS, HTML, XHTML,SOAP, WSDL, UDDI,XML Web Services

Tools: Expression Blend 4.0/3.0/2.0, VSS 2005, TFS 2010/2008, SVN, N-Unit

Operating Systems: Windows 7, Windows Vista Premium, Windows Server 2003, Windows XP, Linux, Windows 2000

Modeling Tools: UML, Microsoft Visio

Reporting Tools: Crystal Reports 2008/10/9/8.5/8 , SSRS 2008/2005

Testing: Unit Testing, N-Unit Testing, SOAP UI web-service Testing

PROFESSIONAL EXPERIENCE

Confidential

.Net SQL Developer

Responsibilities:

• Designed and developed ASP.NET MVC application with integrated custom controls and user controls.
• Hands on experience in using asp.net Ajax, Jquery, Java Script and .net controls like chart control.
• Implemented technical use cases by designing and developing the appropriate web pages using C# code-behind.
• Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.
• Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.
• Implemented Business layer using Windows Communication Foundation (WCF).
• Complex store procedure, store procedure optimizing, functions, views etcetera heavily used and developed.
• Implemented service-oriented component (SOA) Layer using C#.net and WCF to decouple the UI with BL
• Hands on experience with Azure blob storage, SQL Database, App deployment, User access rights, basic firewall and load balancing.
• Used Git with Visual Team Services for version control. Also, we were using VSTS for bug tracking.
• Worked on Entity framework with backed DB as a Azure SQL database along with complex store procedure, queries and views.
• Experience in deploying applications and web services(API) on Azure App Service and managing it.
• Used ADO.NET for retrieving data from back end database Oracle, Database layer developed with table adapters.
• Developed REST API using Web API.
• Very good understanding of all the parts of Agile methodology like user stories, Scrum meetings, iteration etc.
• Responsible for writing the code in Microsoft Visual Studio.Net 2012 with ASP.Net using code behind C#.
• Complex store procedure, functions and views in SQL Server.
• Transferred all data into SQL Server from different data sources using SSIS/ETL.
• Developed link reports, sub reports, standalone reports with SSRS and integrated with ASP pages.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ).

Environment: VisualStudio2013, C#, ASP.NET MVC 4.5/4.0, Agile, WCF, Java Script, JQuery, XAML, TFS 2010, WCF, VB.NET, Azure, WCF REST, JSON, SOAP, IIS 7.0, AJAX, ADO.NET, LINQ, XML, Microsoft Enterprise Library, SQL Server Integration Services, N-Unit, SQL Server 2012 R2, Windows Server 20012 R2/2008, SSRS, SSIS. CSS, HTML, Ajax Extensions

Confidential

Software Database Developer

Responsibilities:

• Installation, Upgrade and Configuration of Oracle (8i, 9i, and 10g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 10g, 11g and worked on ASM.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings, Configuration, maintenance and tuning of Oracle 10gRAC.
• Created Database links to connect to remote databases and to be able to pull data, perform joins to manipulate the data.
• Created Stored Procedures, packages and Functions to validate data and to implement complex business rules.
• As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
• Created and implemented DBMS concepts along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Proficient in advance features for PL/SQL programming like Using cursor variables, Ref. cursors, arrays, nested tables and Dynamic SQL.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side. Writing scripts for backup and recovery, Import and export procedure.
• Written queries, stored procedures, and triggers in SQL Server Management Studio 2008 R2.
• Developed a file tracking tool using C#(.NET) and SQL for keeping the track of file upload and download activities into the database.
• Analyzed Ad hoc reports with SQL, daily and weekly report generation and maintenance procedures to create requirements and deliver to vendors.
• Knowledge in Extraction, Transforming and Loading (ETL). Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Created file management tool for copying and cleaning up the files for different clients using Microsoft C# and SQL.
• Excellent understanding of Linux OS and scripting language as Bash and Perl.
• Write Perl scripts to collect data from remote sources and transform raw dataset into readable and consumable format for the Onedata system using existing framework.

Environment: VS 2008, C#.NET, VB, ASP.NET, Java Script, HTML, XML, XSD, Crystal Reports, SOA, SQL Server 2005, SSRS, Oracle 10g/11g SQL, PL/SQL, MS Excel, MS Access, Web Services, CMS, Agile, Adobe PDF, IIS, SSL Certificates, Windows XP, Windows Server, CSS.

Confidential

.Net SQL Developer

Responsibilities:

• Handling Performance issues.
• Applying regular quarterly CPU patches and keeping the databases up to date with the Oracle security updates
• Creating health monitoring Unix shell scripts.
• Written shell script for Creating User profiles, roles.
• Working with the development team on DBA issues.
• Application issue trouble shooting,
• Involved in building the system architecture and design to understand how the system will work.
• Created and Implemented the System Design in to Real Model using PHP, CSS and JavaScript.
• Created and Implemented DBMS concepts such as Table creation, Data Insertion, Stored Procedures and Views in database using MYSQL and PhpMyAdmin.
• Analyzed and documented transaction data.

Environment: C#, VB.NET, ASP.NET 2.0, Visual Studio 2005, IIS, SQL Server 2005 Reporting Services, Classic ASP, Report Server 2000 and 2005, Oracle 10g and 9i, PL/SQL, XML, MYSQL, PhpMyAdmin, MS Access, ADO.NET, CSS, JavaScript, HTML, DHTML, VBScript.