Post Job Free

Resume

Sign in

Sql Server Project

Location:
Irving, TX
Posted:
February 18, 2018

Contact this candidate

Resume:

Ravikumar Ravinuthala

214-***-**** ac4ivj@r.postjobfree.com

Professional Summary

17+ years of experience in the field of Information Technology, experienced .NET C#, VB.net developer with in-depth practical knowledge of the technologies and techniques of scalable, robust, modular, component-based software design.

12+ years of hands on experience in ASP.NET, C#, VB.NET for design and development of “web & client server applications “ for web and win forms along with SQL Server and Oracle.

Good command over Oracle, SQL Server 2000/2005/2008 with experience of data modeling, Stored Procedures, Functions, Triggers and writing very complex SQL queries.

Knowledge of ORM tools like Entity Framework, nHibernate.

Proficient in JavaScript, jQuery with working experience on AngularJS.

Experience in Service Oriented Architecture, WCF and Web Services.

Excellent command on OOP concepts, C#, VB.Net, ASP.NET, WebAPI, AngularJS, Angular5, XML, ASP, Java Script, JQuery, MVC and SQL Server 2000/2005/2008.

Having Good exposure to new version of Visual Studio 2010, SQL Server 2008 and ASP.NET 4.0.

Very good experience ETL tools like Microsoft SQL Server Reporting Services, Integration Services and Analysis Services

Experience in development of multi-tier distributed web systems for e-commerce

Good Experience into SharePoint 2007/2010 Portals

Sound knowledge in Unified Modeling Language (UML).

Experience in analysis of software requirements, architecture design, coding, code review, design review, application deployment/migration and making recommendations to enhance existing system performance.

Experience in giving excellent production support to highly visible web applications.

Proven ability to determine priorities, schedule work, meet critical deadlines and through knowledge of SDLC.

Drive goals along with the team. Excellent team player.

Certifications

Microsoft Certified Professional in SQL Server 2000

Microsoft Certified Professional in VB 6.0

Brainbench Certified C Programmer

Education

Master of Business Administration - IGNOU, New Delhi, India, 2005

Master of Arts - Osmania University, Hyderabad, India, 1999

Diploma in Advanced Software Technology - CMC, Hyderabad, India, 1998

Post Graduate Diploma in Computer Applications - SARK systems, Hyderabad, India, 1997

Technical Skills

Languages

C#.NET 3.5/3.0/2.0/1.1, VB.Net, VB 6.0, C, C++, XML, XSLT, CSS

Web Technologies

ASP.NET, AJAX, SOAP, Web Services, HTML, DHTML, MVC, Classic ASP

Scripting Languages

Java Script, VB Script, JQuery, Angular JS, Angular5

Query Languages

T-SQL, PL-SQL, LINQ

Distributed Technologies

XML – Web Services, .Net Remoting, WCF, WebAPI

RDBMS

SQL Server 2000/2005/2008, Oracle, My SQL, SQLCE, MS Access

Development Tools

Visual Studio.NET 2010/2008/2005/2003, ADO.NET, Web 2.0

Version Control Tools

Microsoft Visual Source Safe, SVN, TFS

Process Tool

Microsoft VISIO, Eclipse

Web Servers

IIS 7.0, IIS 6.0, IIS 5.0

Operating Systems

Windows server 2008/2003, Windows 2000, Windows XP, Windows 7.0

Reporting Tools

SSRS

BI Tools

SSIS, SSAS

Project/Task Management

Microsoft Project Server 2010

3rd Party Tools

Infragistics, Telerik, Vimas Applets

Others

SharePoint 2007/2010, Smart Device applications for Pocket PC, Tablet PC

Project – Content Management System Jun 2015 – Current

Client: Dell, USA (Austin, TX)

Role: Senior Developer

Environment: Microsoft Visual Studio 2013, C.NET Framework 4.5, ASP.Net MVC, ASP.Net WebAPI, Java Script, Angular JS, JQuery, Elastic Search, Bootstrap, CSS 3.0, HTML5

Responsibilities:

Responsible for creation implementing various modules with in Content Studio using ASP.Net WebAPI, AngularJS with Elastic Search

Responsible for creating several background processes using Windows services for importing Rich Media content from 3rd party syndicators’ ftp sites and updating in Content Studio Elastic Search

Implementation of various tools such as Job Dashboard – to show the execution status of various back ground jobs along with logs; start stop services from the Dashboard, Elastic Search monitoring dashboard, Backup and Restore utility etc.,

Responsible for creating Composer utility to create page layouts on the fly with drag and drop features

Responsible for creating wysiwyg Experience utility to preview the page layouts created from Composer

Responsible for creating several custom directives and field level templates using AngularJS, Angular5

Responsible for creating all the required API methods using ASP.Net WebAPI

Project – Enterprise Project Management Jan 2013 – June 2015

Client: Verizon, USA (Dallas, TX)

Role: Senior Developer

Environment: Microsoft Visual Studio 2010, ASP.Net, C#.NET Framework 4.0, Java Script, AngularJS, SQL Server 2008 R2, SSIS, SSRS, MS Project 2010, Project Service Interface, Project Web Access

Responsibilities:

Responsible for implementation of various web sites for EPM Center of Excellence using ASP.Net with C#.net, Java Script and SQL Server 2008 R2 database

Implemented single page web sites with AngularJS library along with automated unit testing tools.

Responsible for creation of multiple loaders using MS Project Server Web Services (Project Service Interface - PSI) to build, update, delete and customize MS Projects on Enterprise Project Server

Implemented various reports using SQL Server SSRS for Project Managers thus enabling PMs to get up-to-date information on their project schedules and resource capacity allocations

Implemented several system and stakeholder dashboards with variety of graphs to provide latest system level metrics thus enabling PMs and top management make right decisions

Implemented several mission critical Compliance Reports which includes Project and Crew, Capacity and Schedule reports, Aggregate reports on Daily, Weekly and Monthly basis

Responsible for performance fine tuning of web sites, SQL Server stored procedures and PSI loaders

Responsible for creation of SQL Server Jobs with SSIS packages for data loading from different systems outside of EPM

Project – Web Service Output Comparison Utility (CMS Team) Aug 2012 – Jan 2013

Client: Dell, USA (Austin, TX)

Role: Senior Developer

Environment: Microsoft Visual Studio 2010, C#.NET Framework 4.0, SQL Server 2008 R2

Responsibilities:

Responsible for implementation of web service output comparison utility

Responsible for creation of web performance tests, load tests and their execution

Implementation of web test plugins with custom logic to create response output in the form of XML files

Implemented output comparison utility to compare output xml files and produce results with problematic file types

Project – Microsoft Business Solutions (MBS IT) Oct 2011 – Aug 2012

Client: Microsoft, USA (Fargo, ND)

Role: Senior Developer (MS Business Intelligence)

Environment: Microsoft SQL Server 2008 R2, SSIS, SSRS, SSAS, Microsoft Visual Studio 2010,C#,.NET Framework 4.0, SQL Server 2008 R2, SharePoint 2015, ASP.Net Web API

Responsibilities:

Execution of the SSIS packages and SQL jobs

Implementation of new requirements and bug fixes

Implementation of new dimensions/metrics in SSAS cube

Responsible for implementation of MS CorpSTS integration with SharePoint 2015 (This is implemented as a SharePoint feature in VS2010 with C#)

Responsible for implementation of Custom Claims provider with Claims augmentation

Implementation of ASP.net Web API to access user profiles from VOICE with product entitlements

Implementation of Single Sign-On between SharePoint and VOICE

Responsible for development and deployment of SharePoint features from Visual Studio.net

Project – Migration of Hindsite from PHP to ASP .Net Jun 2011 – Sep 2011

Client: Hitachi Consulting Corporation, USA

Role: Dev Lead

Environment: Microsoft Visual Studio 2010, C#, Framework 3.5, SQL Server 2008, Java Script, XML

Responsibilities:

Responsible for the migration of the Hindsite from PHP, MYSQL to ASP.Net with C#, SQL Server

Responsible for migration of Database from MYSQL to SQL Server 2008

Redesigned logic for generating MS Word, Excel document element creation from XML schemas

Simplified document element placeholder creation logic

Project - Business Reports using MSBI Jul 2010 – May 2011

Client: Christies, UK

Role: Dev Lead

Environment: Microsoft Visual Studio 2008, C#, SQL Server 2008 R2, SQL Server Reporting Services 2008.

Responsibilities:

Involved in Design and development of the reports using SSRS 2008.

Developed report models using SSRS 2008.

Developed complex stored procedures for reports.

Involved in the development of the hosting Application ASP.net with C# and the report viewer control.

Project - MyBusTickets.in Jul 2009 - Jun 2010

Client: Culligence, Hyderabad, India

Role: Dev Lead

Environment: Microsoft Visual Studio 2005, C#, .NET Framework 3.0, MVC 2.0, SQL Server 2005, Google Map API, SMS & Payment Gateway Integration.

Responsibilities:

Managed complete development life cycle from beginning to end

Involved in designing application architecture

Integrated payment gateways (ICICI Pay seal) for transactions

Implemented localization for the site

Implemented AJAX functionality to avoid page refreshes

Integrated Google maps to show the boarding points based on the city selected

Integrated 3rd party API to get operators and bus data

Integrated 3rd party SMS gateway

Project - AllOTC Drugs Sep 2008 – Mar 2009

Client: AllOTC Drugs, USA

Role: Dev Lead

Environment: Microsoft Visual Studio 2005, C#, .NET Framework 3.0, WCF, SQL Server 2005, UPS & Payment Gateway Integration.

Responsibilities:

Managed complete development life cycle from beginning to end

Involved in designing application architecture, preparing functional specifications

Integrated payment gateways (Google checkout) for ecommerce transactions

Implemented localization for the portal framework

Implemented AJAX functionality to avoid page refreshes

Integrated UPS services for shipment and order tracking

Project - Nexus eLearning Portal Dec 2007 – Aug 2008

Client: Topyx, USA

Role: Dev Lead

Environnent: Microsoft Visual Studio 2005, C#, .NET Framework 3.0, WCF, SQL Server 2005, UPS & Payment Gateway Integration, Moodle Integration.

Responsibilities:

Managed complete development life cycle from beginning to end

Involved in designing application architecture, preparing functional specifications

Customized Moodle to prepare and track calendar, assignments and quizzes

Designed and developed offline player to take the courses offline

Used third party web services for currency conversion and user location based on IP

Integrated payment gateways (Paypal) for ecommerce transactions

Implemented localization for the portal framework

Implemented AJAX functionality to avoid page refreshes

Used Assembla and SVN for project and source code management

Project - Cogent Knowledge Space (CKS)(version 2.6.1 and 2.6.2) Jan 2007 – Nov 2007

Client: Nortel, Noel Levitz, Amerisource Bergen, Community sites like Dog information space, Pinneast, workforce, EMHR

Role: Project Lead

Environnent: Microsoft Visual Studio 2005, C#, .NET Framework 2.0, SQL Server 2005, Google Checkout & Paypal.

Responsibilities:

Involved in designing new application architecture to make the product as web2.0 framework

Involved in preparing Business Requirements Document (BRD), preparing functional specifications

Assist the team of developers to migrate the product technology from .net 1.1 to 2.0

Involved in implementation of ASP.net enhanced features like webparts with drag and drop functionality with end user personalization

Implemented master pages

Integrated payment gateways (Paypal) for ecommerce transactions

Applied SSL certificates to client sites in a hosted environment

Involved in implementation of Google mini box for full text search features in the site

Integrated 123LogAnalyzer to show click tracking reports for clients

Implemented localization for the portal framework

Implemented AJAX functionality to avoid page refreshes

Project - Cogent Knowledge Space (CKS) (version 2.5.1 and 2.5.2) Jan 2006 – Nov 2006

Client: Mind Crossings, Farmers, Hunter Douglas, TiVo, Mott Community College

Role: Project Lead

Environnent: Microsoft Visual Studio 2005, C#, .NET Framework 2.0, SQL Server 2005.

Responsibilities:

Involved in designing and development of product portal framework

Involved in hosting product for different customers with SAAS model

Involved in hosting multiple customers on Network Load Balancing with Database clustering

Involved in updating live servers through remote desktop

Implemented ELMAH module for error tracking

Maintained various customer configurations with easy to manage XML and DB settings

Mentor team members to learn new .net technologies

Project - Cogent Knowledge Space (CKS) (version 2.0) Apr 2005 – Dec 2005

Client: Fidelity, T-Mobile, Teamm Pharmaceuticals

Role: Project Lead

Environnent: Microsoft Visual Studio 2005, C#, .NET Framework 2.0, SQL Server 2005.

Responsibilities:

Involved in design and development of CKS and migration of the development technology from Windows Sharepoint Services to ASP.net.

Created webparts in Windows Sharepoint Services

Involved in design and development of CKS (Sharepoint) portals for customers

Implemented role and privilege based authentications for users to access content

Involved in integration various third party tools like Infragistics and Telerik

Project - Learning Management System Oct 2004 – Mar 2005

Client: Wall Street Institute, USA

Role: Team Lead

Environnent: Microsoft Visual Studio 2003, VB.net, .NET Framework 1.1, SQL Server 2000, Voice Recording.

Responsibilities:

Evaluated and integrated Vimas voice recording applets in the application and integrated with flash based environment

Implemented push and pull mechanisms to send and receive student profiles in LMS system

Involved in implementation of elearning standards like SCROM and AICC

Project - Mobile Assessment Jun 2004 – Sep 2004

Client: Symbol Inc, USA

Role: Team Lead

Environnent: Microsoft Visual Studio 2003,VB.net, .NET Compact Framework 1.1, SQL Server 2005/SQLCE

Responsibilities:

Implemented mobile application which will download mobile assessments on user handhelds like PocketPC upon submission will synchronize with centralized database server

Integrated SQLCE database with SQL Server

Project - Content Editor Nov 2003 – May 2004

Client: Performance Impact, USA

Role: Team Lead

Environnent: Microsoft Visual Studio 2003, VB.net, .NET Framework 1.1

Responsibilities:

Developed ASP.net based editor with complete client side functionality with Java script

Integrated java script with flash by passing XMLs as inputs

Designed different content authoring page layouts which will be rendered in flash runtime engine

Rendered XML output using XSLT

Project - Real-time Performance Management System (RPM) Dec 2002 – Nov 2003

Client: Navowave Inc, USA

Role: Team Lead

Environnent: Microsoft Visual Studio 2003, VB.Net, .NET Framework 1.1

Responsibilities:

Developed ASP.net based web authoring and delivery portals

Implemented and integrated web services

Developed mobile and tablet PC applications

Developed signature control to capture digital signatures on pocket PC and tablet PCs

Project - Cadsys Document Management System (CDoc) Apr 2002 – Nov 2002

Client: APGenco, AP Secretariat

Role: Senior Developer

Environnent: VC++, XML, ASP, 3rd Party API

Responsibilities:

Developed conversion tool to convert images to PDF with search, hyper linking and zoning capabilities

Implemented search capability to search required documents based on metadata fields like title, keywords, date, description, location etc.

Project - Cadsys Online Integrated System (COINS) Jul 2001 – Mar 2002

Client: Apex Data Services (USA)

Role: Senior Developer

Environnent: Visual Basic 6.0 with Oracle 8.0

Responsibilities:

Implemented a desktop system to control and coordinate day-to-day activities of a GIS system

Implemented automation of MS-Office tools such as Word, Excel to generate reports in the desired format requested by client

Integrated existing logistics management system with this application for allocation and submission of work packages, process quality assurance etc.

Project - Asset Management System Jan 2001 – Jun 2001

Client: Apex Data Services (USA)

Role: Senior Developer

Environnent: VB6.0, ASP, Oracle 8.0

Responsibilities:

Developed few modules in ASP based system

Involved in technical discussions and database design

Involved in ongoing maintenance and support

Implemented encryption algorithms



Contact this candidate