PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Designing, Development, Testing and Implementation as a Programmer/Analyst.
• Expertise in Database Programming Concepts using MS SQL Server 2000, SQL Server 2005, SQL Server 2008 and Oracle 9i, 10g.
• Expertise in Visual Studio .Net using C# and VB, ASP.net, technically strong in Visual Basic 6.0, VBA, JavaScript, VB Script, and database programming.
• Strong in RDBMS & data modeling concepts, and excellent knowledge of database design, writing complex business stored procedures, Cursors, SQL Queries, triggers, Functions in SQL Server.
• Extensively used SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS).
• Self starter and excellent team player with good writing, Communication and Techno Functional Skills.

Technical Skills:

Development Tools: Microsoft Visual Studio.Net, Microsoft Visual basic, XMLSPY 5.0
Languages: C, C++, VB Script, PHP and Java Script
Databases: MS SQL Server 2000, SQL Server 2005, SQL Server 2008, Oracle 10g, MS Access, SQL, PL/SQL
Reports: MS Access, Crystal Reports, SQL Server Reporting Services
Operating Systems: Win 2K, UNIX.

Education: Bachelor’s of Engineering in Electronics and Communication, Hyderabad, India

Training:

Visual Studio: Visual Basic.Net, Visual Basic, MS SQL, Visual C++, ADO.Net, ASP.net course
Java Programming: Applets, Servlets, Java Swing, RMI, CORBA, AWT Course
Oracle Applications [Tech]: Accounts, Inventory, Receivables, General Ledger, Payables.

Professional Experience:

Confidential,Reston, VA
Project: Call Accounting System:
Duration: July 2011 Dec 2011

Call Accounting System: This system analyzes the sales team performance on a daily basis by tracking the call systems.

Responsibilities:

• Responsible for analyzing existing system and designing the new system for reading the daily call accounting system files.
• Responsible for identifying various types of calls, like inbound calls, outbound calls, voice mails and transfer calls from the 3COM switch.
• Responsible for doing the data mapping between the source files (Legacy applications) and SQL Server database tables and designed a SSIS packages to read the data.
• Created a SSIS packages to read the daily calls files into the system and wrote complex stored procedures, functions and views to implement the business logic for the Call Accounting System.

Environment: SQL Server 2008R2, SSIS, 3COM, VB.net, MS Reporting Services, MS Access on Windows 2003.

Confidential, Mc Lean VA
Project: Project Server to Plan View Migration
Duration: Oct 2010 May 2011
Role: SQL Server/Oracle/SSRS Developer
Working on implementing Plan View application for,Confidential, involved in migration of SQL Server Reporting Services reports from Project Server to Plan View application. Project server reports are SQL Server 2005 based and Plan View is based on Oracle11 server.

Responsibilities:

• Responsible for creating SSIS packages for data migration from Project Server (SQL Server 2005) to Plan View application (Oracle).
• Wrote PL/SQL stored procedures for implementing business requirements of Plan view application (oracle).
• Used Ref Cursors in Stored Procedures for implementing base line schedules for projects.
• Created Weekly Project review report, Project Status Report, TS and IT Metrics Report and Base Line compliance reports using SQL Server Reporting Services based on Oracle 11i database.
• Done the unit testing of the reports and migrated the reports into Report manager.
• Extensively used T-SQL, PL/SQL, SSIS, SSRS, DML triggers.

Environment: SQL Server 2005, Oracle 11i, SSIS, SSRS, Project Server, Plan View on Windows 2003

Confidential, McLean, VA
Project: Delivery and Dispatch Time Tracker
Duration: Nov 08 Feb 10

Confidential, provides solutions for advanced application services focused on businesses communications needs using Voice over Internet Protocol (VOIP) technologies.

Delivery and Dispatch Time Tracker Application Responsibilities:

• Responsible for analysis of the existing Delivery and dispatch time tracker process and design develop a new system for the sales department.
• Responsible for gathering requirements from users and creating a design document.
• Created SSIS packages daily Delivery and Dispatch file processing, and overall control of task flow for the database processing needs.
• Responsible for designing a process for reading the daily Delivery and Dispatch data from user interface to the back end database using the SQL Server Integration Services (SSIS).
• Modified existing and develop new stored procedures for transferring data between database and user interfaces.
• Modified existing and develop tables for changing data needs.
• Create Table structures and wrote complex Stored Procedures, Views for data manipulation for Daily Reporting purpose.
• Responsible for creating daily, weekly and monthly reports for Delivery and Dispatch tracking system management team.
• Responsible for setting up email notification for the users if the delivery is pending for more than 72 hours, so the team can take up the quick action.
• Test all stored procedures, constraints, triggers and user interfaces to verify functionality.
• Assisted with peer code reviews and testing of development team\'s T-SQL code

Environment: SQL Server 2008, SSIS, VB, Stored Procedures, Views, Access 2003 on Windows 2003.

Confidential,Herndon VA MS
Project: Risk Transformation Facility (RTF)
Duration: Sept 2007 - June 2008

Worked on Risk Transformation Facility (RTF) project is to enhance Fannie Mae’s ability to Better serve the market through enabling Credit and interest rate risk management on a more diverse quality of whole single family loans, which are initially purchased for cash prior to securitization. This project includes integration of CMH Tool with existing systems and process and the ability to securitize into MBS. This application include information on commitments,
Deliveries and forward trades that are used to hedge Fannie Mae’s obligation to purchase loans from lenders.

Responsibilities

• Responsible for designing, developing and testing TAC outbound interface.
• Involved in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS)
• Responsible for designing transformations between CMH Pool data and Value Net system using SSIS.
• Designed SQL Server Integration Services (SSIS) packages to post CMH pool data in XML file format for evaluation to TAC URL, then TAC system validates the request and sends the response back to CMH synchronously.
• Implemented Object Oriented programming concepts (.Net) in SQL Server Integration Services for reading the data and creating the XML data output to TAC system

• Responsible for designing and building CMH table schema and their relationship, work table structures for Risk Transformation Facility project.
• Extensively used SQL Server Integration Services (SSIS) for extracting data from Fannie Mae data warehouse (Oracle) into CMH tables.
• Wrote complex SQL Stored Procedures, Views and Functions in extracting data from CMH databases for complex CMH data calculations before SSIS kicks in.
• Responsible for working with testing team in the fixing the bugs reported by the test team.
• Responsible for working with Clear case team in migrating the SQL objects (Tables, Views, Stored procedures, Functions, SSIS packages) from development environment to Test environment and then to Production.

Environment: SQL Server 2005, VB.Net, Oracle 10g, Access 2003 , T SQL, PL/SQL, Stored Procedures, Views, SQL Server Integration services (SSIS), SQL Reporting Services (SSRS), XML/XSL on Win 2003.

Confidential, Washington DC
DC Stars to School Net Transformation
Duration: March 2007 - July 2007

Responsibilities

• Responsible for developing Transformations between DC Stars and School Net application.
• Responsible for creating table structures, and loading data from Oracle to SQL Server through SQL Server DTS Packages, wrote custom VB Script in DTS packages.
• Responsible for developing complex transformations and loading data into Student Enrollment and Section Results from DC Star’s Oracle Database.
• Responsible for creating Work tables for School Net Application.
• Responsible for creating section results for each report cycle identified in the semester translate table and populated student marks for student marks table.
• Created Reports for section results.
• Responsible for creating design document for School Net Application.

Environment: SQL Server 2000, DTS packages, VB, SQL Reporting Services, Oracle 9, MS Access, Win 2003.

Confidential, Honolulu, HI
Blue Cross Blue Shield of Hawaii
Project: Medicare Part D
Duration: June 2005 December 2006

Worked for Confidential, in implementing Medicare Part D (Medicare Risk Enrollment Database Project) Enrollment/Disenrollment of the Member Plan and generation of various reports
I implemented this plan end to end and worked on numerous other projects.

Medicare Part D Project:

• Responsible for gathering the requirements from users for design and development of the MRED Enrollment and Disenrollment in Part D Plan.
• Responsible for creating SQL Server database Schema, Tables and Creating Indexes for Part D Plan based on the business requirement.
• Responsible for designing and coding of the Enrollment/Disenrollment screen and Part D forms and written various business procedures for data manipulations as per the business requirements.
• Used MS Access Reports for developing various Client specific reports like Batch Response, Weekly TRR, Monthly TRR, LIS Group Type, Enrollment of Member, Disenrollment, Death Reports on Weekly and Monthly Transaction Response files.
• Wrote complex Queries in SQL Server using T SQL, created Stored Procedures, Views, Cursors, and Functions for Medicare Part D project.
• Development of MS Access GUI’s to convert data from text files to formats for Reporting
• Wrote Complex SQL Scripts for creating 71 and 72 files to be sent to CMS and also read the files received from CMS to update HMSA database.
• Created ADO record set objects for accessing the data from the database when required.
• Create Linked tables in order to access data from Oracle data tables and also exported data into Excel Spread Sheets.
• Responsible for testing the Reports and fixing the bugs and also responsible for preparing the user document and training the end users.

Quest BI Project:

• Responsible for performance tuning of the Quest BI application, creating of Views, stored procedures, worktables
• Generated WK-CLM, WK-CLM-DET, WK-CLM-MSG, and WK-CLM-COND, WK-CLM-DIAG files by writing various views, stored procedures and functions for Quest BI team for generation of various reports.
• Responsible for performance tuning of long running Stored Procedures, Views and making recommendations to improve the performance.
• Responsible for creating BI output files for BI Team.
• Responsible for setting up Auto Reports to users based on the daily pending claims.

Quest and 65 CP Scanning Systems:

• Responsible for Maintenance of Quest and 65CP Claims, Scan EDI Database, aQScan, Qnxt application for processing of scanned claims.
• Responsible for Analyzing and Fixing the Quest Claims using SQL Server Scripts.
• Responsible for identifying the claims with no images and re inserting the image copy of the claim in image folder. Wrote a very Complex and logical stored procedure for identifying and alerting the users and IS if there is any missing image for the claim.
• Responsible for maintenance of traffic cop, this is a very complex stored procedure with cursors, which splits the claims based on the line of business Quest and 65CP.
• Worked extensively with Database Procedures, Functions, Cursors, Joins and Triggers using Oracle to apply business rules.
• Development of MS Access GUI’s to convert data from text files to formats for Reporting, Created macros in order to execute Queries and for reading files.
• Trouble shooting of clm97 report, for the claims, which failed to enter into Qnxt.

Environment: Qnxt 2.6, SQL Server 2000, Oracle 9i, Crystal Reports 9, Visual Basic 6, Scan optics, MS Excel, MS Access 2003, VB, Win 2003

Confidential, TROY, MI
Project: Global Parts Management Systems
Duration: January 2005 May 2005

Confidential, is an intranet-based application, developed for the purchase department of Delphi Energy & Chassis Division. The core objective of the GPMS is integration of 3 existing legacy applications the PRDB, PPAP, and PPCT, for global usage, running on the windows environment. I worked as an onsite coordinator / analyst for new enhancements to GPMS in the version 3.0

Responsibilities:

• Involved in the requirements gathering from the users for building the functional specification documents for GPMS version 3.0
• Detailed impact analysis on the new functionality on the existing version of the system
• Worked on DB extensions, several new DB components to support the version 3 enhancements.
• Developed ActiveX DLLs for implementing business logic.
• Designed and developed the COM object, which provides the interface for secured database access
• Performance tuning and optimization of the existing PL/SQL Stored Procedures, SQL Queries and views for better performance in some critical reports and transactions.
• Created Linked tables in MSAccess in order to access oracle database and exported the data to excel spread sheets as per requirements.
• Created Macros for excecuting sql queries and for reading files.
• Prepared Test Data for the UAT as per the specifications of the BRD
• Used SQL queries to access the database for Back-end Testing
• Worked extensively with Stored Procedures, Functions, Cursors, Joins and Triggers using PL/SQL to apply business rules.
• Executed a Test Cases Manually and also using Automation and reported the defects using Test Director.

Environment: Oracle 9i, Crystal Enterprise 9.0, JavaScript/VB Script, Test Director, Win Runner, Visual Source Safe and IIS 5.0 on Windows 2000 server.

Confidential,Atlanta, GA
Project: Event Management
Duration: July 2003 to December 2004

Participated in design and development of the event management module using VB.NET and ORACLE 9i; Project involves creation of various modules which would provide a user interface for customers to enroll for various Coca Cola Events and input and query data from and to database.
The .NET web application sends data to a middleware called Integrator using sockets, after fetching the data from database, the middleware integrator sends it back to the .NET web application and the Application displays the result to the Customers.

Responsibilities:

• Developed solutions for diverse programming scenarios in .Net, employing object oriented programming concepts such as encapsulation, inheritance, polymorphism and abstraction.
• Responsible for requirements gathering from the users for building the Design specification documents from Globus version 3.0
• Detailed impact analysis on the new functionality on the existing version of the system.
• Created and Deployed web services using ASP.Net Consumed web services from both windows forms and ASP.Net web applications.
• Created complex business components whose functionality is exposed as services in service oriented architecture, realized as XML web services implemented in VB.Net using the rich set of classes and interfaces provided by ASP.Net and .Net Framework Class Library.
• Documentation of all the UI, report and database components to be build.
• Performance tuning and optimization of the existing PL/SQL Stored Procedures and views for better performance in some critical reports and transactions.
• Design and development of new annual summary reports on member and Program data.
• Development of Test plans and test case scenarios for the applications.
• Created very complex Views, Stored Procedures, views, and functions for implementing the business logic and for updating the database tables.

Environment: Visual Studio. Net, ASP.Net, Oracle 9i, Crystal Report Application Server 9.0, and Windows 2000