SUMMARY OF SKILLS:

• 13+ years of experience and expertise in all phases of software development life cycle (SDLC) including analysis, requirement engineering, architecture design, database design, development, enhancements and maintenance of standalone, Multi - tier, web-based, portals based object oriented enterprise applications.
• Experience in Data Warehouse Tabular Data Modeling and Business Intelligence using SSIS, SSAS, Star Schema, DAX, Power BI
• Strong working knowledge with OLTP and OLAP database system development.
• Experience with Visual Studio 2012, 2010, 2008, 2005, 2003, .NET Framework 1.1, 2.0, 3.5 and 4.0.
• Good experience in ADO.NET objects such as SQL Connection Object, SQL Command Object, Data Reader Object, Dataset Object and Data Adapter Object. Developed Stored Procedures, Triggers and development of Database Objects using PL/SQL,T-SQL in SQL Server
• Possess strong project planning and execution skills.
• Has good experience in Web Services WCF, SOAP.
• Has good experience in AJAX and Web parts.
• Worked on features such as Authentication & Authorization, Windows-based Authentication, Forms-based Authentication, Active Directory.
• Experience in analyzing and done Automations wherever applicable.
• Expertise in .Net Technologies with Object Oriented Analyzed Development (OOAD) & development of Web and Win Form applications and their implementation using polymorphism, inheritance and encapsulation.
• Worked on Interoperability, exposing .Net assemblies to COM application.
• Experience in architecture, design and development of .Net based Application framework in C#.
• Extensive experience in XML and XSL
• A fast learner with good communication and presentation skills, problem solving and troubleshooting capabilities.
• Capable of handling any new applications in very short time.
• Is analytical in approach, hardworking, committed and a good team leader

SKILLS SUMMARY:

Operating Systems: Microsoft Windows 2010/NT Server/10x/9x/3.x

Frameworks: Microsoft .NET Framework 4.x/3.x/2.0/1.x, Ajax

Languages: ASP.NET, VB.NET, C#, ADO.NET, VB 6.0, ASP, XML, XSL, XSD, Web Services, WCF, WPF, Java script, VBScript, AJAX, CSS, SOAP, WSDL, MVC4, MVVM, Silverlight, LINQ, SSIS, SSAS, DWH Star Schema, OLTP, OLAP, Entity Framework, SOA

Databases: SQL Server 2008/2005/2003 ,, DAX,Oracle 9i, MS Access

Tools: .Net - VS2010/ VS2008/ VS2005/ VS2003

Database - l Toad, SQL Profiler: Others - COM, COM+, VSS, SharePoint, TFS

Reporting Tools: Reports - Crystal Report XI, BO 6.0, SSRS, Power BI

Web Designing Tools : Photoshop, GIF Animator, Flash.

PROFESSIONAL EXPERIENCE:

EHS Data Warehouse

Confidential, TX

Responsibilities:

• Analyzing, Database designing, Implementation
• Created SSIS packages, and wrote stored procedures for ETL.
• Analyzing the data and Create Star Schema structure (Fact and Dimensions) and SSAS Tabular model Cube.
• De-normalized Star Schema Cube Design
• Written DAX queries for calculate measure fields.
• Writing batch files to trigger the process and for scheduling jobs.
• Coding PL/SQL procedure and functions.
• Created reports using Power BI and SSRS.
• Involved in gathering requirements, discussions with finance team. Also involved on working on estimates and confirming the same to the client.
• Providing support to production team.
• Performing code review for team members.

Technologies: MS Visual Studio 2012, SSIS, SSAS, Star Schema, Analysis Services Tabular Model, DAX, SQL Server 2012, Power BI, SSRS TFS, Oracle 9i

Emission Inventory Tracking

Confidential, TX, USA

• Analyzing, Database designing, Implementation
• Implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.
• Extensively used VB.NET to develop user interface screens.
• Written Complex Stored procedures in SQL to calculate the Emissions.
• Worked on performance tuning on Stored procedures.
• Writing batch files to trigger the process and for scheduling jobs.
• Developed partial post back validations to manipulate data on web pages using AJAX.
• Coding PL/SQL procedure and functions.
• Created reports using SSRS.
• Created SSIS packages, and wrote complex Stored procedures for ETL.
• Involved in gathering requirements, discussions with client for phase 2 activities. Also involved on working on estimates and confirming the same to the client.
• Providing support to production team.
• Performing code review for team members.

Technologies: MS VisualStudio.NET 2012, ASP.Net, C#, VB.Net, SSIS, SSRS, SQL Server 2012, TFS, Oracle 9i

I COST

Confidential, OR

• Analyzing, Database designing, Implementation
• Used MVVM (Model-View-View Model) Design Pattern to segregate Model, View Model and Views.
• Develop Silverlight UI components using MVVM pattern.
• Worked on WCF Services responsible for communicating and providing real time data from integrated server to Client Application
• Implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.
• Created SSIS packages, and wrote complex Stored procedures for ETL.
• Worked on performance tuning on Stored procedures.
• Writing batch files to trigger the process and for scheduling jobs.
• Developed partial post back validations to manipulate data on web pages using AJAX.
• Coding PL/SQL procedure and functions.
• Extensively used LINQ for querying data objects and in the Data Layer for entity Framework.
• Involved in gathering requirements, discussions with client for phase 2 activities. Also involved on working on estimates and confirming the same to the client.
• Providing support to production team.
• Performing code review for team members.

Technologies: MS VisualStudio.NET 2010, ASP.Net, C#, MVVM, MVC4, WCF, Silverlight, WPF, Ajax, Entity Framework, SSIS, SQL Server 2012, TFS

Mortgage Active Directory

Confidential, UT

• Analyzing, Database designing, Implementation
• Coding PL/SQL procedure and functions.
• Providing support to production team.
• Performing code review for team members.
• Developed secured Web services using .Net, C#, VB.Net, WCF.
• Implementing customer flow model for current application.
• Developed a utility in C# with windows services to find out redundant word files in servers and delete those to save storage resources. Wrote stored procedures in SQL Server for the automation of the system.
• Wrote stored procedures to handle data management and business logic in TSQL / SQL server.
• Wrote triggers in TSQL for data handling / updating.
• Actively participated in the testing and maintenance of the application.
• Managed project versions in Visual Source Safe.
• Implemented a Report Builder application and Win forms using C#.Net, VB.Net and SQL Server.
• Worked directly with end users to gather business requirements. Created the user guide and conducted user training sessions as part of the implementation.
• Wrote stored procedures as part of the implementation. Prepared the user guide and conducted training sessions.

Technologies: ASP.Net, XML, C#, WCF, SQL Server 2012, Java Script, Ajax, SOA

DIRECTWARE Admin Panel

Confidential, UT

• Lead offshore team of .NET and SQL developers.
• Analyzing, Database designing, Implementation
• Involved in designing of new web forms using ASP.NET 3.5.
• Coding PL/SQL procedure and functions.
• Providing support to production team.
• Performing code review for team members.
• Created web forms using AJAX.
• Created user controls.
• Analyzed and implemented changes to design of application for new phase of development
• Used multi layer architecture with separate Business Logic and Data Access Layers and Presentation Layers.
• Implemented user reentry through User Session and Application Page objects, deferred session state was built to store and retrieve session information of users
• Designed and developed Data Access Layer (DAL), Business Logic layer (BLL) and other components
• Developed secured Web services using .Net, C#, VB.Net, XML/SOAP, HTTPS/SSL.
• Fixing the defects reported by the onsite and QA testing team.
• Worked on all layers of 3-tier architecture.
• Played a key role in training and helping the team members in coping with the updating of the Framework.

Technologies: ASP.Net, C#, VB.Net, SQL Server 2005, VB, XML, XSL, JavaScript, AJAX

Monitoring Console

Confidential, TX

• Involved in Development, Testing and Code Review.
• Responsible for the project execution from Project initiation to Project Closure.
• Prepared test cases and done Integration testing of whole system
• Prepared technical as well as functional review of test cases, test plans, code, and stored procedure. Performed unit testing.
• Writing web services which is called by this application
• Extensively used AJAX controls, including Update Panels and Calendar Popup controls for better user navigation.
• Used ASP.NET validation controls such as RegularExpressionValidator and CustomValidator to validate the information provided by the user.
• Managed the code versions using Visual Source Safe.
• Design and development of various reports and components associated with it.
• Design and development of component.
• Involved in displaying results using charts, making Reports.
• Responsibilities included independently interacting with clients to understand their requirements and coordinating with the team.
• Created custom controls

Technologies: ASP.NET, C#, ADO.NET, Microsoft .NET 2.0, XML, XSL, SQL Server

E-Leader

Confidential

• Conceptualize the project in architecture and Design
• Managing team’s day to day activities
• Initiated project, Requirement gathering, Analyze, Planning, Coding and Testing.
• Design and development of various reports and components associated with it.
• Design and development of component.
• Developed user interface applications using winforms in ASP.Net.
• Involved in displaying results using charts, making Reports.
• Created automated enrollment reporting and analytics using ASP.Net and SQL Server
• Created a report library which has a collection of several hundreds of reports for different departments using ASP.Net, SQL Server with easily navigational links and search capabilities
• Wrote stored procedures in SQL Server as part of the enhancements
• Architectural rework of the shipping systems with AJAX functionalities
• Wrote web services for XML data transfers between applications in different platforms.
• Developed windows utilities and applications using Winforms.
• Developed COM interoperable components for integrating the servers with different applications
• Developed and integrated the report generation procedure with MS Office using COM components for printing requirements.
• Developed different kinds of reports like down time report, event reports, production reports etc.

Technologies: ASP.NET, VB.NET, Microsoft .NET 2.0, XML, XSL

Automation on Support activities

Confidential, TX

• Responsibilities included independently interacting with clients to understand their requirements and coordinating with the team.
• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.
• Worked on a page selection program in C#.Net and SQL Server which is used by analysts to create certificate documents. Worked on a charting tree application for the charting of documents or have pages added manually. Chart book maintenance program is used by authors to maintain the charting tree.
• Developed a utility in C# with windows services to find out redundant word files in servers and delete those to save storage resources. Wrote stored procedures in SQL Server for the automation of the system.
• Wrote stored procedures to handle data management and business logic in TSQL / SQL server.
• Wrote triggers in TSQL for data handling / updating.
• Actively participated in the testing and maintenance of the application.
• Managed project versions in Visual Source Safe.
• Implemented a Report Builder application and Win forms using C#.Net, VB.Net and SQL Server.
• Worked directly with end users to gather business requirements. Created the user guide and conducted user training sessions as part of the implementation.
• Wrote stored procedures as part of the implementation. Prepared the user guide and conducted training sessions.
• Build creation and Release.
• Followed complete SDLC for the project.
• Manual testing of the Unit and the Integrated Test cases

Technologies: C#, VB.NET, Microsoft .NET 1.1, VBScript, Oracle 9i, SQL Server 2005.

TELLUS

Confidential, Boston

• Responsibilities included independently interacting with clients to understand their requirements and coordinating with the team.
• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.
• Analyzed the existing database structure and reporting requirements for Checkpoint. Designed and presented a high level architecture diagram for the proposed changes and participated in identifying its outcome.
• Updated existing applications due to introduction of new line of business and removal of existing ones.
• Provided after implementation support for different applications.
• Took part in the production support, maintenance & enhancement of existing programs and the support of other systems like electronic in-house printing system and forms order entry system.
• Major contributor to process review, business objects administration and application enhancements. Troubleshot and resolved SQL errors.
• Created database applications, wrote and recompiled stored procedures, triggers and worked for obtaining better performance and resource usage.
• Developed utilities using C#.Net, VB.NET, VBA and Access that write and run queries, automate common tasks, check for data errors.

Technologies: ASP.NET, VB.NET, Java Script, MS SQL Server 2000, Crystal report

Composer 

Confidential

• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.
• Wrote stored procedures in TSQL / SQL Server 2005, for delivering and representing statistic data from the servers.
• Used triggers, views and indexes to obtain better database performance.
• Wrote formulas for calculating sizes and positions
• Performed Code reviews on the code written by the team and ensured that it was of high quality
• Providing technical help to the team by suggesting design patterns for Object Oriented design.
• Involved in writing classes.
• Involved in writing stored procedures.
• Testing application

Technologies: VB.NET, VBScript, MS Access

Watcher

Confidential

• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.
• Involved in writing classes.
• Involved in writing stored procedures.
• Testing application
• Providing production support for the application, fine tuning sql queries, remote debuging of the code. Regularly adding new methods to accommodate user requirements.

Technologies: C#, XML, MS Access

SmartDialer

Confidential

• Involved in Designing call flow and Coding
• Involved in writing classes.
• Involved in writing stored procedures.

Technologies: C#, XML, MS Access

Job Track System

Confidential

• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.

Technologies: VB.Net, SQL server

Service Booking System

Confidential

• Coding and Testing.
• Analyzing and logical solutions.
• Design and development of component.

Technologies: VB, SQL server