SUMMARY

• Over 9 years of diversified experience in development of Databases and Web-based Applications
• Experienced in working with SQL Server 2000/2005/2008 and Oracle 9i/10G databases
• Experience in using ERWIN and VISIO data modeling tools
• Experienced in Business Intelligence Technologies using SQL Server Business Intelligence Development Studio 2008/2005, SSIS (SQL Server Integration Services 2005/2008), SSRS (SQL Server Reporting Services 2008/2005/2000), Report Builder 2005/2008, Dundas .Net Charting, Gauge and Maps both in SSRS reporting services and .Net implementation, Crystal Enterprise Embedded Server 10/9, Crystal Enterprise Server 10, Crystal Reports 10/9/8 and Visual Studio 2005/2005 for BI
• Over 4 years of Microsoft Dynamic CRM v4.0/3.0/1.2 customization EXPECIALLY integrating with CRM for Members design for various clients utilizing Microsoft Technologies like .Net Framework, C#, JavaScript, Web Services, SQL Server 2000/2005, BI Tools (DTS, SSIS, SSRS), Crystal Enterprise Server and Crystal Reports..
• Extensive experience in creating Tables, Stored Procedures, Functions, Triggers and Packages using T-SQL and PL/SQL
• Expertise in creating Indexes and Query Optimization techniques to optimize the performance
• Experience in migration from Microsoft ACCESS to SQL Server databases
• Extensive Knowledge in design and development of Web based applications
• Good knowledge of Object Oriented Programming and .NET Framework 1.1/2.0/3.5
• Experience in designing, coding and testing of software applications using ASP.NET, C#.NET, ADO.NET, technologies and Java Script, CSS, XML
• Extensive Experience in Web Technologies JavaScript, ASP, HTML, CSS and XML
• Experience in using Issue Tracking Systems like SCRUM Master, JIRA System, Visual Source Safe, TFS and SVN Tortoise Version Control.
• Experience in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Development, and Testing
• Ability to work in tight schedules and efficient in time management
• Highly motivated team player with excellent interpersonal, technical and communication skills

Experience

Sr. Programmer Analyst for Confidential, Washington, DC November2008 to till-date

Sr. Application Developer for Confidential, Columbia, Maryland
February2004 to November2008

Programmer Analyst for Confidential, Memphis, TN
April2003 to February2004

Software Engineer for Confidential, San Jose, California July2001 to April2003

Software Programmer for Confidential, Hyderabad, Andhra Pradesh INDIA October1999 to July2001

Software Programmer for Confidential, Bangalore INDIA July1998 to October1999

Education Qualifications
Post Graduate Diploma in Computer Applications
Bachelor of Engineering in Mechanical

Expertise in:
SQL Server, Oracle and MS Access
SQL, PL/SQL, Stored Procedures, Views, Functions, DTS and Replication
Business Intelligent Studio Tools (SSIS, SSRS and SSAS)
Crystal Enterprise Server, Crystal Reports
Dundas Charts/Maps/Gauge for dashboard design and reporting
SQL Server Profiler
Database Engine Tuning Advisor
Visual Studio.Net (2003/2005/2008)
MS Shear Point 2007
Team Foundation Server (TFS), Visual Source Safe (VSS) and SVN Tortoise
ASP.Net, C#, VB.Net and XML
J Script and VB Script

Functional Exposure

Confidential
ISIS (Integrated Student and Information System)
ISIS is an integrated student and Information System used to track, process and response about their applicant, prospects and or web inquiry requests. Collecting data from various sources partnering web sites like Emark and Hobsons. Working closely with SAIS functional users to gather information from Admissions, usually Flat Files/Excel files from the Content Management Server and process into ISIS database (SQL Server 2008) using SSIS Packages. Once the Applicant or Prospect info is available in ISIS, The admissions Group will take necessary steps on the Student Applicant Record and inform their status via one of the communication groups (Letter/Emails) setup in ISIS. Build technical specifications that accurately reflect the SAIS business processes, these technical specifications will be coded, tested and ultimately promoted for enterprise level use. I am responsible for Transforming data into ISIS, and design Models for end-user to access necessary reports and to develop Ad-hoc reports and Report models using SSRS and converting existing Crystal Reports to SSRS for the offices of Admissions, Financial Aid, Billing and Registration based on data extracted from the ISIS system. These reports include standard, statistical, ad-hoc, condensed or detailed types and will be used by Senior Management to support high-level strategic decisions.
And also supporting SAIS online applications (OLA) that interface with the ISIS system via web services, In addition with I also work with SSET(Student Systems and Educational Technology) Team counterparts to design and maintain the ISIS system throughout JHU

• Analysis, design, implementation of database for ISIS Application, Transform data into ISIS, and design Report Models for various modules available in ISIS Application and Generate Ad-hoc Results, SQL Reports for ISIS Application Users.
• Support and customization for On-line application portal for ISIS Application using .net, C# and web services
• Design and implementing various SSIS Packages and Report Models files with respect to ISIS modules involved in using Business Intelligent Studio Tools.
• Writing SQL Stored Procedures, Functions to utilize in SQL Reporting Services
• Designed no. of SQL Views to implement Report Models in Visual Studio 2005
• Converted existing Crystal Reports (rpt) to SQL Reports (rdl) and integration to ISIS Application for User Access
• Setting up automated Email Subscription to Reports through Report Manager.

Environment
SQL Server, SQL, PL/SQL, Stored Procedures, Views, Functions, DTS, Replication,
Business Intelligent Studio Tools (SSIS, SSRS and SSAS), Visual Studio.Net , ASP.Net, C#, VB.Net, XML, J Script, VB Script, Crystal Enterprise Server, Crystal Reports, SQL Server Profiler, Database Engine Tuning Advisor, MS Shear Point, JIRA Administrator and SVN Tortoise

Confidential,Columbia, MD USA
CRM for Members

Protech specializes in developing enterprise systems for the Association Industry based on MSCRM platform. The product is totally a browser based solution developed with Microsoft .NET Technologies including XML Web Services which could glean standards. It includes Membership Management (Dues Billing, lists, Committees), Meetings Management (Event & conference organization, registrations, activities), Subscriptions, Orders (product invoicing, inventory), exhibitor management, Advertising etc. All these products support all the business functions of an association

• Customizing CRM for Members database and user interface according to client specific need
• Involved in Analysis and Database design for CRM for Members
• Imports and Converts legacy data into CRM for Member database using Business Intelligence Studio2005, SSIS (ETL) and DTS Packages
• Writing Upgrade SQL Scripts for 1.2 to 3.0 CRM for Members
• Creating stored procedures, functions, cursors and triggers for the use of development cycle
• Design and development of user interface for Membership Invoice, Lists and Committees,
• Import Legacy data into CRM History Store Module and developed Custom Interface which will allow them to view past transitional data at any point of time
• Converting existing Crystal Reports (rpt) to SQL Reports (rdl)
• Design and Development of drill down reports, complex dash board charts and cross tab reports.
• Generated Client Specific SSRS/ Crystal Reports and maintaining Security, Email Subscriptions through Report Server Management
• Automatic email response to the customers regarding their orders or member registrations or dues renewals or subscriptions using Report Server Management
• Administrative Task involved for SQL Reporting Server and Crystal Enterprise Server10
• Packaged and Released Software Versions for CRM for Members using Install shield X, maintaining version control through TFS (Microsoft Team Foundation Server 2005) and Visual Source Safe Control Tool

Environment
Microsoft CRM, SQL Server, SQL, PL/SQL, Stored Procedures, Views, Functions, DTS, Replication,
Business Intelligent Studio Tools (SSIS, SSRS and SSAS), Visual Studio.Net , ASP.Net, C#, VB.Net, XML, J Script, VB Script, Dundas Charts/Maps/Gauges, Crystal Enterprise Server, Crystal Reports, SQL Server Profiler, Database Engine Tuning Advisor, MS Shear Point, Scrum master, TFS and VSS

Confidential, Memphis, TN USA
NFIRS (New York Fire Incident Reporting Service)

The rescue control software utilized a user friendly graphical user interface (GUI) designed using Microsoft Visual .NET. The client operates on multiple (98/ME/NT/2000 and XP) windows based operating systems. The windows environment provides a familiar look and feel to the system including such features such as pull down menus, online help, scroll bars, cut and paste, and point and click operation while also allowing for keyboard interaction for those who prefer the keyboard to the mouse. The simplicity of screen layouts provides a user friendly presentation of data in easy to read formats.
Rescue control is comprised of a variety of modules all working together to provide a fully integrated NFIRS, decision support, and station and unit management system. The flow of data follows actual procedures followed by department throughout the US. Because of this system can be learned quickly and used by a variety of personal including firefighters, supervisors, administrators and fire inspectors. In addition to providing user friendly access and presentation of data, pre-coded data fields are used to speed the data entry process. NFIRS rules and codes have been preloaded so that the user community need not be familiar with NFIRS specifications. NSS strives (through customization if necessary) to meet all various state reporting requirements.

Environment
SQL Server, SQL, PL/SQL, Stored Procedures, Views, Functions, DTS, Replication,
Visual Studio.Net , ASP.Net, C#, VB.Net, XML, J Script, VB Script, Crystal Enterprise Server, Crystal Reports, SQL Server Profiler, Database Engine Tuning Advisor

Confidential, CA, USA
Southern Bank of the West

Bank of the West now serves over 3 million households and businesses in hundreds of communities in 19 Western and Midwestern states. It provides a full range of commercial & individual banking products and services. The bank primarily engages in generating deposits and originating loans. My responsibilities in this bank were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various bank databases in both development and production environment.

• Collected and managed data information including its branches, employees, subsidiaries, partners and stock holders
• Designed and implemented SQL Server 2000 databases for mission-critical business applications by using Microsoft .NET N-tier Enterprise Application Architecture
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications
• Created logical and physical database design, data structures, and implemented large databases using Erwin
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Generated the weekly, monthly, and quarterly report by using Crystal Report

Environment
SQL Server, SQL, PL/SQL, Stored Procedures, Views, Functions, DTS, Crystal Enterprise Server and Crystal Reports

Confidential, Hyderabad INDIA
Lanco Global Systems
This project was developed for the wireless antenna manufacturing division. It deals with customer enquiries related with the current products, rate quotes and their complaints for the products used by them. It has different distributed modules like marketing area module, customer complain addressing, QA section, Material Inward section and Manufacturing section. This system has auto emailing feature. This system involves the entries related to the Product master, Customer master, Rate updates, Customer complaints and suggestions, marketing details, returned material inward, QA remarks, Manufacturing remarks for any repair and categorization. It automatically generates reports and mails and sends it to the marketing personnel and to the customers.

• Contributed towards gaining and analyzing client requirements
• Used Cascaded Style Sheets for all ASP.Net pages
• Generated stored procedures in MS SQL Server
• Extensive use of User controls and Custom Web controls using ASP.NET, C#, VB.NET
• Implemented Validations Controls for client-side validation
• Generated reports using Crystal Reports
• Documentation for all code modules
• Involved in Unit testing for the application

Environment
SQL Server, SQL, PL/SQL, Stored Procedures, Views, Functions, DTS, ASP.NET, C#, VB.NET, ADO.NET Crystal Enterprise Server and Crystal Reports

Confidential, Bangalore INDIA
SellyGlobaly, INDIA
This application helps in placing online orders, Product and Marketing information, review real time status of the Orders, and receive Service information and Reservations. The module takes care of all Invoice related functionality like Creating Detailed Invoices, Backorder Processing, Track Sales personal Volume for any period, Tracks payment, Customer statement, Credits, Refunds and Returns Etc. Users can also search for the Dealer based on ZIP code and Product.

• Developed Business Layer Components using ASP.NET, C#, VB.NET
• Implemented Data Access Layer Components using ADO.NET
• Implemented Role based Security model
• Built business layer modules, custom & user controls like Evaluation controls
• worked with various custom validation controls
• Developed Data Access modules using C#. NET
• Created XML files using dataset of ADO.NET
• Extensively worked with Web Forms and Web Services in ASP.NET
• Involved in the Designing UML diagrams using Visio
• Managed templates and Cascaded Style Sheets using XML and XSL
• Interacted with end-users in gathering feedback and implemented new features and enhancements.

Environment
VB.NET, C#, Visual Studio .Net 2000, ASP.Net 1.0, HTML, CSS, SQL Server 2000