Sql Server Management

[pic]

Ravikiran Villambakkam Chakravarthy

**** * **** & Country Blvd. ***********@*****.***

Ellicott City, Maryland, USA - 21043 Ph (Cell): 443-254-

2262

SUMMARY:

I am a Solutions Architect and a Microsoft Certified Professional with

Public Trust Security Clearance and 15+ years of hands on global IT

experience. I have been extensively involved in Architecting and developing

web based solutions, database technology solutions, product development and

software process improvement projects for turnaround and high-growth

organizations. My functional experience scales across software services,

management consulting, and federal government, financial and healthcare

domains. I have been recognized for excellent leadership and out of the box

thinking in all facets of project life cycle by utilizing exemplary

communication and interpersonal skills in coordinating partnerships between

business and technology groups.

EDUCATION QUALIFICATION:

Master of Science - Information Technology from University of Maryland

University College GPA: 4.0

KEY STRENGTHS:

. 1 year of Solution Architecture experience developing the

technical vision for major initiatives, translating that vision

into an executable technical plan or roadmap, and leading the

technical implementation through deployment(s).

. Over 15 years of extensive experience in designing, developing,

testing and support of various software applications with an

exposure to different platforms and software systems.

. Over 15 years of development experience with Microsoft SQL Server

2000/2005/2008, MS Access, Oracle 8i/9i/10g/11g, T-SQL, PL/SQL,

Stored Procedures, functions, triggers and Dynamic SQL, SQL jobs, DTS,

SSIS, SSRS as well as Windows Forms, Web forms, Visual Studio 6.0/

2000/2005/2010, Visual Source Safe, Team Foundation Server, Visual

Basic (VB), VB.NET, C#, WPF, MVC 3.0 +, ASP, ASP.NET, ADO.NET, VB

Scripts, Razor, Java Scripts, MS Office Automation using VBA.

. Over 10 years of experience in database design, query optimization,

backend performance tuning, process improvements using SQL Server

2000/2005/2008, Oracle 8i/9i/10g/11g.

. Over 10 years of experience in developing and implementing ETL

processes to migrate data between different databases to form data

marts and data warehouses. I have also designed and implemented ETL

processes for data conversions between different systems.

. Microsoft Certified Professional with over 10 years of expertise

in Developing and Implementing Web Applications with Microsoft

Visual C# .NET, Visual Basic.NET, Microsoft Visual Studio .NET,

including legacy ASP.NET, JavaScript, XML/XSLT, WPF, MVC 3.0+,

web development toolsets, SharePoint and Dynamic CRM.

. More than 10 years of experience with Crystal Reports, Business

Objects and SQL Server Reporting Services (SSRS).

. Partnered with Clients to define and analyze complex needs and

business requirements and determine programming design to meet

necessary specifications. Made recommendations for most efficient

solutions to meet Clients' parameters.

. Architected, designed and developed technical solutions to enable

various interfaces/ services for Client systems using ASP.NET, VB.NET,

C# and SQL Server.

. 10 years of experience in leading teams of developers on larger

projects. Championed overall software development processes,

releases, testing and support. Lead and mentored team of 15

software engineers.

. 7 years of Implementation experience of Agile Development workflow for

many projects.

. Created and Implemented code review process.

. Created and implemented production release process.

. Lead and supported 15 large software development products and over 100

projects from start to finish.

. Experience setting up Development, QA, and Production environments.

. Highly adaptable in quickly changing technical environments with

very strong organizational and Analytical systems.

Technical Summary

Operating Systems Windows NT/95/98/2000/2003/2007, UNIX, Linux

Languages SQL, Visual Basic, C#, C++

.NET Applications ASP.NET, C#. NET 2.0/3.5/4.0, HTML, XML, MVC 3.0,

WCF, WPF

.NET FrameWork Framework 1.1/2.0/3.5/4.0

.NET Modeling Enterprise Architect

CRM Dynamic CRM, Salesforce Service Cloud, Force.com

Database/Data Access MSSQLServer2000/2005/2008, SSIS, SSRS,

Oracle 8i/10g/11g

Database Design/Modeling Tools Erwin, SQL Server Diagrams, ER Assistant

Database Administration Replication, mirroring, backup and

recovery - SQL Server, Oracle

Web/ Application Servers IIS

Web development SharePoint, Dynamic CRM, Visual Studio.NET

Scripting Languages Shell Script, VBScript, JavaScript,

JQuery, AJAX

View Engine Razor, Web form

GUI Tools Visual Studio.NET 2003/2005/2008/2010

MS Packages MS Office 2000/ 2007 (Excel, Word,

PowerPoint, Access, Project)

Configuration Library Microsoft Visual SourceSafe VSS,

Team Foundation Sever TFS

PROFESSIONAL EXPERIENCE:

COMPANY : Business Integra

POSITION : Solutions Architect

CLIENT : U.S. Small Business Administration (SBA)

DURATION : Dec 2013 till date

Responsibilities:

. Developing the technical vision for major initiatives, translating

that vision into an executable technical plan or roadmap, and leading

the technical implementation through deployment(s).

. The role works closely with Product Management, Enterprise

Architecture, UX, Development, and Production Operations to align the

vision and resulting solution with broader product, technical, and

organizational roadmaps.

. Translate functional and non-functional requirements into design

within enterprise context

. Design systems solutions for OCIO and its stakeholders

. Design enterprise solutions for integration and implementation of

projects into the SBA Architecture

. Review requirement specifications and business process artifacts for

proposed solution implementation

. Work closely with business analysts, subject matter experts and

development teams to design, develop, test, implement, and support

solutions

. Review and conduct technical research on integration and methodologies

to ensure that the process is fully functional when completed

. Provide recommendations of existing information processing systems and

emerging technology trends to match them with current and future

business needs

. Participate in meetings with both technology and business teams to

facilitate the understanding, clarification, and implementation of

requirements

. Develop architectural diagrams to illustrate architectural

complexities and interactions

. Acts as the subject matter expert for multiple portfolios of moderate

complexity and serves as the system architecture authority within that

scope

. Define complex technology-based business solutions within scope of

project

. Identify and evaluate technical architecture models utilizing

knowledge of industry and technical trends

. Review design documents prior to development to ensure adherence to

prescribed guidelines

. Advise management regarding IT vision and strategy, teclmology

innovations and enterprise architecture services

. Provide production problem diagnosis and technical strategy and

processes support to project team

. Lead system design activities or reviews system designs to assure that

applications solutions will exhibit expected levels of performance,

security, scalability, maintainability, appropriate reusability and

reliability upon deployment

. Lead technology and product general assessments and detailed

evaluations

. Prepare IT vision and strategy work products, technology and product

analysis, white papers, and responses to management queries on

technology and product related topics

. Participate in system solution definition for projects, as needed, to

ensure business requirements are satisfied

. Work with business stakeholders to develop Business Architecture

Roadmaps containing tactical and strategic initiatives to reach target

business capabilities

. Design solutions based on business requirements that align with

Architecture policies and standards

. Collaborate with stakeholders and conducts stakeholder reviews of

architecture roadmaps and designs

. Participate within Enterprise Architecture in policy and standards

definition and evolution as well as project pipeline management

Development and Architectural Initiatives:

. Architected and implemented a custom Master Data Management solution

at SBA using .NET, ASP.NET, MS Share Point, Visual Basic, VB.NET, C#,

MVC 4.0, Razor, and SQL Server 2005/2008.

. Created Asset Inventory software solution to hold Erwin models.

. Implemented Salesforce Service Cloud for SBA Executive Secretariat

Correspondence management system.

. Developing business process workflows and Use cases for Salesforce to

implement various CRM solutions that will replace the old Dynamic CRM

applications.

. Performed analysis on various endpoint management tools and

implemented IBM Tivoli Endpoint manager for automatic delivery of

updates, patches, security upgrades, and software applications.

. Developed SBA Data Management Policy and Standard Operating Procedures

(SOP) to implement Executive Order 13642, "Making Open and Machine

Readable the New Default for Government Information", and OMB

Memorandum M-13-13 "Open data Policy - Managing Information as an

Asset". Engaged System owners, data owners, and business owners from

various Agency offices to develop an Open Data charter, SOP and Data

management policy manual. Piloted various Agency Offices for data

publication of SBA data assets.

. Developed a Systems Development Methodology Guide, process manual and

various templates and artifacts to standardize the systems development

process at SBA.

. Prepared a comparative and cost analysis for a technical solution to

host SBA software tools and email services on the cloud. Performed

product comparison and implemented technical solution for Email as a

Service with Microsoft Office 365 at SBA.

. Delivered Management documentation and Technical Storage architecture

solution.

. Lead the technical implementation by organizing the development

efforts of systems solutions, and helping to recommend which

technologies to use.

. Involved with development projects at the time of inception, starting

with Functional Analysis (FA) in developing the initial requirements,

and remaining involved throughout the balance of the project, and

working very closely with developers to ensure proper implementation.

. Project management support for custom development.

COMPANY : NCO FINANCIAL SYSTEMS, INC.

PROJECTS : Attorney Network, AGENCY Network, NextGen, CRS and

FACS

POSITION : Senior Programmer Analyst

DURATION : Sep 2006 to Dec 2013

Report to VP - Information Technology

Attorney Network and Agency Net

Description: Attorney network and Agency Net Management systems are debt

recovery and collection agency services provided via web portals. I lead

the IT team that is the custodian of attorney network and agency net soft

ware products. We provide IT support on a daily basis to our clients and

banks.

CRS and FACS

Description: CRS and FACS are feature-rich, enterprise debt recovery IT

solutions, built from the ground up to provide operational, analytical and

collaborative functionality. I lead the IT team specializing in ASP.NET,

VB.NET, WCF and C #, MVC 3.0, Razor. We provided IT services to the US

Government, various banks like Bank of America, American Express, Chase

Bank, etc for debt collection.

Responsibilities:

. Redesigned, developed and supported the backend databases of the

Attorney network, Agency Net, NextGen, CRS and FACS management system

to cater to changing and growing business needs.

. Developed a large number of custom financial debt collection softwares

namely NCOTrack, FACSComparator, SoundBite, ERIntegrator, EFIntegrator

to name a few using .NET, ASP.NET, Visual Basic, VB.NET, C#, MVC 3.0,

Razor, SQL Server 2005/2008, Oracle 10g/11g. I also developed a number

of custom softwares for various banks like Bank of America, American

Express and Chase Bank to interface with NCO's debt collection

softwares.

. Extensively used EDI translation for various conversion projects using

.NET, SQL Server between NCO and hundred's of clients.

. Used Selenium for web automation testing, LoadRunner for load testing,

NUnit for unit testing and Resharper for code debugging, code re-

factoring and code navigation

. Extensively worked on database and query optimization in SQL Server

using various tools like Profiler, index tuning wizard. Also have done

a lot of database application optimizations.

. Advised user departments in computer applications, capabilities,

alternative programming approaches, and limitations to resolve

specific problems and/or make changes to programs

. Lead development, system integration, data conversions, and testing

activities with external customers.

. Specialized in driving software development using Agile methodology

(Scrum and XP). Coached and mentored product owners, development team

and Scrum Masters.

. Coordinated and worked with teams in Philippines, China and Barbados

to drive web development activities. Also involved extensively in

conversion from ASP to ASP.NET and redesign of various web

applications using ASP.NET and ASP.

. Managed and created SOW for project opportunities using vendors from

Approved Supplier List. Good experience managing vendors working in

different geographical areas and time zones.

. Used ITIL framework and ITSM using ServiceNow for Change management

and Incident management.

. Architected, designed and developed various processes through Software

Development Life Cycle (SDLC).

. Extensively involved in change of features or feature enhancements in

the projects listed above using SQL Server, ASP.NET, Visual Basic, C#,

VB.NET, Razor, .

. Worked with internal/external customers to understand and drive

system/software requirements, specifications and end user experiences.

. Developed and implemented ETL processes to migrate data between

EForwardEase and ERecoverEase databases to form data marts and data

warehouses to be used by NextGen. I have also designed and implemented

ETL processes for data conversions between different systems.

. Developed a number of payment processing web services for our clients

to consume in their applications. I have also used WCF for this. These

WCF services are consumed by the client applications.

. Acted as a subject matter expert for the Products.

. Ensured IT solutions preserved architectural integrity and consistency

with approved standards and strategies

. Provided expertise and leadership to architect solutions that provided

appropriate levels of performance, scalability, reliability, and cost

efficiency

. Performed Code reviews and directed developers to implement policies

and procedures for ensuring the security and integrity of internally

developed applications

. Recommended and/or implemented changes to existing applications in

order to increase efficiency, minimize operating expense, or improve

accuracy and timeliness of application.

. Prioritized defects and assigned to the specific resource.

. Coordinated and delivered web projects by leading the offshore team in

India, Philippines and Barbados.

. Maintained communication about the project with the upper management

and stakeholders and addressed deviation from the project schedule.

Environment:

VB.NET, ASP.NET, XML, Java Scripts and Visual Basic, SQL-Server 2005/2008,

Crystal Reports, CSS, IIS, TFS, VS.NET, MVC 3.0, Razor, SQL Reporting

Services, Oracle 10g, Oracle 11g, HP Quality Center, Track IT, ITIL Service

Now, MS Foundation Server, UML

COMPANY : FOUNDING ADVISORS, INC

TITLE : Medical Verification System/ Medical Site

Review

POSITION : LEAD INFORMATION SYSTEMS DEVELOPER

DURATION : 2003 to 2006

Description: I was involved in analysis, design, development and testing of

various healthcare softwares namely MVS, MSR, and HEDIS healthcare

softwares right from its inception using VB.NET, ASP.NET 2.0, SQL Server

2000/2005, VBA, Crystal Reports, Business Objects, SSIS and SSRS. I was

also extensively involved in client interactions and delivering the

products.

Report to Director - Information Technology

Responsibilities:

. Architected, designed and developed Health care verification software

called MVS that is being used by 90% of the health care industry for

patient data verification. The focal areas of development included

acquisition and verification tools, addition of web based document

parsing to document management, Automation of Report Generation,

Automated fax sending and receiving capabilities, Automation of

scanning and email generation. I single handedly developed the entire

MVS portal, backend processes and various document management

executables using ASP.NET, VB.NET, C#, SQL Server, Crystal Reports and

SSIS.

. Worked with external customers to document business and functional

requirements.

. Architected, Designed and Developed Medical Verification Software that

was intelligent enough to learn the system and continually modify

operational processes to maximize efficiency through the concept of

Task Manager.

. Architected HEDIS (auditing software) to help rate various health

plans and hospitals across US. Also developed and implemented all the

business logic for all the 72 measures that were required to rating

hospitals and Insurance companies through extensive T-SQL programming.

. Lead development activities across different geographical areas and

time zones. (India, Philippines)

. Lead a team of 10 web developers and mentored engineers during

development phases.

. Extensively involved in designing databases, optimizing processes and

developing high quality software.

. Developed and maintained a management dashboard to represent the

performance of the process. Crystal reports were employed to display

various management reports. Castelle fax server was used to send and

receive faxes. Used Visual Source Safe for integration and security.

. Used Microsoft .NET for website development, Microsoft SQL Server for

Content storage, Microsoft Commerce Server for content profiling and

web analytics, Microsoft Word for content authoring and publishing.

Environment:

VB.NET, ASP.NET, Java Scripts and Visual Basic 6.0, SQL-Server, Crystal

Reports, SQL Server Integration Service (SSIS), SQL Server Reporting

Service (SSRS), VSS, CSS, IIS, VS.NET.

Company : SYSTEM LOGIC SOLUTIONS LTD., INDIA (HELIOS AND

MATHESON)

Client : BPL, India

Project : Financial Accounting System

Duration : 2000 to 2001

Position : SOFTWARE ENGINEER

Responsibilities:

. Designed and developed Financial Accounting System software to handle

budgetary control and service compensation modules for our client BPL,

India. I was involved in designing tables, developing stored

procedures, triggers, sql jobs, DTS packages using MS SQL Server

. Designed ER diagrams, built tables, optimized queries, stored

procedures using SQL Server/ Oracle and built management reports using

Crystal Reports.

. Lead a team of developers and mentored engineers during development

and testing phases.

Environment: Visual Basic 6.0, ASP, VBA, Oracle 8i, SQL-Server (7.0).

IDEAL INFOTECH, INDIA 1998 to 2000

SOFTWARE ENGINEER

Computerization of operations

o Developed front end using Visual Basic, ASP to computerize

operations of various departments such as Planning, Production,

Inspection, Stores, Marketing and Final Analysis modules of the

Company.

o Extensively developed and gained expertise in database

programming and administration using Oracle 7i/8i

o Extensively designed, developed and implemented front end GUIs

using Visual Basic.

. Pool-Pro Software: The software keeps track of the user-details,

billing information and duration of play for player of the Pool-Pro

software.

o The software was developed in Visual Basic and used many Active-

X component,

o Designed databases, integrity constraints, relations and

developed triggers.

o Extensively optimized queries and stored procedures.

. Excel and Word Automation for Volvo: This project aimed at updating

the data stored in a remote server to an excel sheet and transferring

data modified in the excel sheet to the remote server with Visual

Basic as the interface.

o Implemented Excel automation to display the data from the remote

server to the spreadsheet. It also provided user interactive

interfaces.

o Implemented Word automation for transferring document

information.

Environment: Visual Basic 6.0, Oracle 7i, SQL-Server (7.0), VBA.

Contact this candidate