Project Sql Server

Padmaja Rallabandi

Cell: 412-***-****

***********@*******.***

EDUCATION OSMANIA UNIVERSITY, Hyderabad, INDIA

Masters in Electronics and Communications, May 2005

Concentration: Electronics and Communications

OSMANIA UNIVERSITY, Hyderabad, INDIA

Bachelors in Computer Science, April 2002

Concentration: Computers, Mathematics and Electronics

EXPERIENCE 7 years of overall IT experience in Software Development Life Cycle by using various

tools and technologies in different projects

3 years of experience in Healthcare industry in United Health Group and 4 years of

experience in Real estate, telecommunications and retail industries

7 years of experience in MS SQL Server 2005/2008 and Oracle using TSQL and PL/SQL

and in .NET technologies

TRAININGS AND Certificate in MS SQL Server 2008 from Riverhead Training Institute, Pittsburgh, PA

CERTIFICATIONS

Post Graduate Diploma in Computers from National Institute of Information Technology

(NIIT), INDIA

Microsoft Certified Professional Developer (MCPD) in 2 areas :

MCPD: Designing and Developing Windows Applications Using Microsoft .NET Framework

4.0

License E007-5428

September 2012 – Present

MCPD: Designing and Developing Web Applications Using Microsoft .NET Framework 4.0

License E007-5429

September 2012 – Present

Microsoft Certified Technical specialist (MCTS) in 6 areas:

MCTS: SQL Server® 2008, Implementation and Maintenance

License E011-2421

September 2012 – Present

MCTS: SharePoint® 2010, Application Development

License E010-1053

September 2012 – Present

MCTS: Accessing Data with Microsoft .NET Framework 4

License E006-8771

September 2012 – Present

MCTS: Web Applications Development with Microsoft .NET Framework 4

License D990-2464

September 2012 – Present

MCTS: Windows Communication Foundation Development with Microsoft .NET Framework

4

License D988-6707

September 2012 – Present

MCTS: Windows Applications Development with Microsoft .NET Framework 4

License D978-6963

August 2012 – Present

SKILLS

IT Databases: MS SQL Server 2008, Oracle, TSQL, PL/SQL, SSIS and SSRS

Database tools: MS SQL Management Studio, Toad, and SQL Navigator. Efficiency in

creating database objects and in writing stored procedures. Biztalk 2008

Languages: Visual Studio 2010/2008/2003, VB.NET, C#, ASP.NET, Crystal Reports,

Windows Services, Web Services, Javascript, Core Java, Visual Basic 6.0, C, C++, HTML,

DHTML, ASP, XML,MVC 2,MVC 3

Design tools: Unified Modeling language (UML), Rational Rose, MS Visio.

Change control tools: Visual Source Safe, Harvest Life Cycle, Mercury Test Management

tool

Operating systems: Microsoft Windows 2003, 2000, XP and Unix

Other skills: Internet Information Server (IIS), COM, COM+, Microsoft Transaction Server,

LDAP, and Share point 2007/2010

Office Management: MS Office 2003

BUSINESS HIPPA, FACETS 4.71, MACESS, Extensions and 3M Core Grouping Software, worked on

835 and 837 EDI file format.

CAREER I would like to use of my IT skills and subject matter expertise to leverage more challenging

INTERESTS work in development and business analysis tasks.

PROJECTS

Employer: Tate & Lyle, Hoffman Estates, IL

Project 1: Koog Weighbridge – NMI (UK) July2013- June 2014

Get readings from weighbridges be captured in a secure, read-only database for Koog and other Tate and Lyle

plants in the EUROPE.

.Role: Sr.Application developer plus SQL Developer

• Actively involved in interactions with business team to solidify the requirements and for approvals

• Worked on modifications and enhancements to stored procedures and business logic components.

• Worked on test and deployment of the changes in different environments before installing into production

• Written technical documentation, test cases documentation and implementation plan

• Performed design, code, test, debug, documentation and support of the application by adhering to

established specifications and policies

• Worked on technical research for implementing the logic.

• Point of contact for explanations and interpretations within area of expertise.

Software tools used: MS SQL Management Studio 2008, TSQL, Visual Studio 2010, C#, Win weigh tool, SSIS,

Biztalk services, SAP ECC 6.0 tool.

Employer: Tate & Lyle, Hoffman Estates, IL

Project 1: GrainReceiving ( USA) May2013-July 2013

When two trucks on the inbound and outbound scales simultaneously – currently this is confusing the Grain

Receiving system for same vendor. Enhanced the current process so that the user can monitor the system and

verify the RFID tags and weights of each truck and modify, if necessary.

.Role: Sr.Application developer plus SQL Developer

• Actively involved in interactions with business team to solidify the requirements and for approvals

• Worked on modifications and enhancements to stored procedures and business logic components.

• Worked on test and deployment of the changes in different environments before installing into production

• Written technical documentation, test cases documentation and implementation plan

• Performed design, code, test, debug, documentation and support of the application by adhering to

established specifications and policies

• Worked on technical research for implementing the logic.

• Point of contact for explanations and interpretations within area of expertise.

Software tools used: MS SQL Management Studio 2008, TSQL, Visual Studio 2010, C#, SSIS, Biztalk

services,SAP ECC 6.0 tool.

Employer: United Health Group Corporation, Pittsburgh, Pennsylvania

Project: CAMS File Phase III for United Health care Apr 2011- Mar 2013

(Community and State Ohio Medicaid Health Plan)

A phased approach was implemented to meet the requirements identified by Ohio Department of Jobs and

Family Services (ODJFS) associated with the submission of the CAMS file. Phase I resulted in the

generation of a Reconciliation file, Phase II incorporated an additional temporary process to supplement

the existing CAMS Extract until a CareOne Enhancement could be implemented. This BRD represents

Phase III of this approach. In Phase III, the existing CareOne CAMS Extract would be enhanced to

accurately reflect members associated with the required Care Management condition classifications, as

well as the number of high risk stratified cases.

Role: Business Analyst plus SQL Developer

• Actively involved in interactions with business team to gather/solidify the requirements and for approvals

• Worked on modifications and enhancements to stored procedures and business logic components

• Worked on test and deployment of the changes in different environments before installing into production

• Written technical documentation, test cases documentation and implementation plan

• Performed design, code, test, debug, documentation and support of the application by adhering to

established specifications and policies

• Worked on technical research for implementing the logic.

• Point of contact for explanations and interpretations within area of expertise.

Software tools used: MS SQL Management Studio 2005, TSQL, Visual Studio 2005, VB.NET, Facets 4.71 and

Harvest Code repository, SSIS and SSRS

Employer: United Health Group Corporation, Pittsburgh, Pennsylvania

Project: Pittsburgh MACESS Implementation Sep 2010 –

Mar 2011

In conjunction with the FirstSource/RMO paper claim submissions migration, the claims workflow process is

implemented by leveraging AmeriChoice’s core MACESS system. The MACESS implementation is to replace

current Pittsburgh Unison imaging (OnBase) and workflow (GetClaim) systems, by building imaging and workflow

functionality within the MACESS application. MACESS is a content-driven business process management solution,

enabling organizations to capture vital information as it enters the workplace and electronically distribute it through

user-defined workflows.

The goal of this project is to increase productivity of claims processing and to streamline the data capturing

process. In addition, claims workflow management is implemented which reduced costs and standardize

inbound/outbound processes.

Role: Analyst plus SQL Developer

• Worked on the task to Create doc-flow files in order to feed from FACETS to MACESS

• Actively involved in interaction with business team to gather the requirements and for approvals

• Implemented modifications and enhancements to stored procedures and business logic components

• Worked on test and deployment of the changes in different environments before installing in production

• Worked technical documentation, test cases documentation and implementation plan

Software tools used: MS SQL Management Studio 2005, TSQL, Visual Studio 2005, VB.NET, EXP MACESS,

FACETS 4.71, 3M Core Grouping Software and Harvest Code repository, SSIS packages, SSRS

Employer: United Health Group Corporation, Pittsburgh, Pennsylvania

Project: Production support for Extensions on Facets Mar 2009 – Present

Currently, Facets allows the use of extensions to provide additional functionality that the application cannot provide.

Facets allows timing events that can launch extensions and can be used to store additional data to a table,

update the Facets screen, and perform logic checks . These extensions were written in VB.Net front end and they

use MS SQL Server database as backend. These extensions perform some logic checks that Facets application

cannot perform. Extensions open and retrieve what logic should be used from a table based on the application that

launches extensions and based on the Line of Business. We have total 31 extensions and we launch them from

Claims Processing screens.

Role: Analyst plus SQL Developer

• Active participant in fixing HP Service Desk ad-hoc tickets upon request.

• Design, code, test, debug, document and support all types of applications consistent with

established specifications and gathered business requirements to deliver business value.

• Did Analysis and investigation.

• Provided explanations and interpretations within area of expertise.

Software used: MS SQL Management Studio 2005, TSQL,SSIS pacakages, Visual Studio 2005, VB.NET, EXP

MACESS, FACETS 4.71 and 3M Core Grouping Software and Harvest Code repository, Share point portal.

Employer: United Health Group Corporation, Pittsburgh, Pennsylvania

Project: iCES - Medical Claims for GLHP and Unison, iCes 4x, PA Integration Oct 2009– July2010

iCES is a third party product known as the Ingenix Claim Editing System; it is an open architecture claims editing

tool that provides rules-based edits to review professional claims for coding inaccuracies. The Clearing House is an

internal United Health Group’s product created by the United Health Care division that is based on iCES but has

proprietary enhancements that are not made available to anyone outside United Health Group.

This project provides an interface between River Valley, Unison and GLHP FACETS claim platforms to iCES CH for

AmeriChoice professional claims.

This will create a centralized rules repository to be the single source-of-truth editing tool for professional claim

reimbursement across AmeriChoice claims platforms in DIAMOND and FACETS. DIAMOND platform currently

utilizes the iCES CH for eight AmeriChoice Health Plans.

Role: Analyst plus SQL Developer

• Provided enhancements to some of the extensions in order to facilitate iCES claim processing screens

• Created new extension for iCES claim processing

• Actively involved in interactions with business team to gather the requirements and for approvals

• Worked on modifications and enhancements to stored procedures and business logic components

• Worked on test and deployment of the changes in different environments before installing in production

• Written technical documentation, test cases documentation and implementation plan

Software used: MS SQL Management Studio 2005, TSQL, Visual Studio 2005, VB.NET, FACETS 4.71 and 3M

Core Grouping Software and Harvest Code repository

Employer: Oxford Associates, Pittsburgh, Pennsylvania

Client: National Real Estate Information Services (NREIS), Pittsburgh, Pennsylvania

Project: Real TMS Web portal http://www.RealTMS.com Apr 2008 – Nov 2008

NREIS provides a comprehensive portfolio of real estate information products for commercial and residential

mortgage transactions. NREIS offers a Web-based transactional portal for customers and vendors allowing for

faster order requests, quicker turn times, and most convenient way to access to data through multiple modes of

product access via web, email, fax, phone, web service and https posts. These modules have high availability and

scalability with dynamic and customized rules engine. These modules also include integration with FedEx, UPS,

DHL services for all shipping and labeling services.

NREIS’ products and services include title insurance and property reports, real estate appraisals and alternative

valuation products, settlement and closing services, commercial real estate services, default and property

preservation services, and flood and tax certifications.

Role: Software consultant

• Involved in design and development of application modules in .NET environment using C#, Visual Studio

2008 and Infragistics controls. I used UML as a part of design.

• Developed and enhanced main customer's web application for lenders and integrated data exchange with

other applications.

• Developed and enhanced web part of application for B2B connection between lawyers and lenders

• Designed the Work-flow and rules engine using windows workflow foundation.

• Designed and developed the screens for Title products insurance, Settlement/Closing services and Vendor

and Escrow maintenance Visual Studio2008 and Infragistics controls.

• Generated Crystal Reports for Titles, Closing services and HUD.

• Designed database (Tables and Stored Procedures) according to the business requirements using MS SQL

2005.

• Implemented ‘.NET Remoting’ to separate the logical and physical layers into four layers.

• Implement Forms-Based Authentication in ASP.NET Application Using C# .NET and MVC 2

• Implemented Role based Security and Developed Security Layers in C#.Net for user Authentication.

• Enumerating and Managing the Resources in the Active Directory by C# Objects.

• Developed Business Layers in and Data Access Layers in C#.

Software tools used: Windows XP, .NET Framework 3.5, MS Visual Studio .NET 2008, ASP.NET, ADO.NET, XML,

C#, Web Forms, Crystal Reports, MS SQL Server 2005, Visual Source Safe 6.0 (VSS), PDF Merger, Right Fax

and .NET Web Services

Employer: Oxford Associates, Pittsburgh, Pennsylvania

Client: Verizon Communications, Pittsburgh

Project: One Bill Mar 2005 – Apr 2008

One-Bill project is Verizon’s retail market strategic initiative that enables customers to view Verizon Wireless

charges on their Verizon Communications landline bill. This is a muti-tier project and involved interactions with

several database servers and other third party systems. This is a data driven application that requires extraction of

data from different systems and publishing of data using sophisticated data grid concepts.

This product offers a collaborative effort between Verizon Communications (VZC ) and Verizon Wireless (VZW) to

reward customers who utilize Verizon's many products. I worked on development/enhancements/production

support on ONE-BILL project to provide a single bill for Verizon customers even though they avail different services

of Verizon viz., Verizon Landline, Verizon Wireless, and DirectTV. This system communicates to different services

in-order to generate One Bill to the customers. This system is used by all Verizon retailers through out USA.

This project has two main modules Enrollment/De-enrollment to One Bill, Reports generation

Enrollment module accepts customers BTN (Bill telephone number) or SSN as primary source to enroll for one bill

generation process. Enrollment module includes various checks based on BTN, SSN for the validity of the

customers. One Bill system talks to eRegistration system using .NET web services for the authentication of the

customer

Reports module contains various off line, dynamic reports for management review. Reports are generated in Excel

and viewed on the IE browser. Different COM+ components are used for to serve different reports.

Role: Software consultant

• Created complex business components using VB.NET Class library assemblies

• Created Stored Procedures and Triggers for Interaction with database using SQL Server 2000.

• Explored enterprise Web strategies to address issues involved in creating Web content using ASP .NET

Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET

and Data binding.

• Developed Security Layers in VB.NET for user Authentication.

• Constructed SOAP Messages to Integrate Information Delivery capabilities into NET (ASP.NET) application

using C# Classes.

• Enumerating and Managing the Resources in the Active Directory by VB.NET Objects.

• Development of Authentication System against Active Directory.

• Development of Business and Data Layers in VB.NET

• Generated Reports using Crystal Reports.Net

• Worked on programming various code modules and unit testing

• Involved in software design of the modules assigned using UML visual modeling tool

• Worked with DBA for developing database schema and fine tuning SQL queries and stored procedures

• Worked with QA team in order to help them for writing test cases and for preparing test data

• Worked with QA team for functional, integration and system testing based on the test cases

Software tools used: ASP.NET, VB.NET, C#, ADO.NET, Visual Studio 2003, MS SQL Server 2000, MS Excel 2000,

Visual Source Safe (VSS 6.0), VB6.0, COM+, XML, XSLT, Windows Scheduled task, Web Services

Client: Hewlett-Packard, CA

Project: CA Government Metadata Standards (CGMS) Aug 2004 – Mar 2005

This project is for the development of California State Government metadata search engine for CA Government

agencies. This search engine gives the results of any specified search phrase by fetching all the CA Government

sites content

This project is a multi-tier, data driven application supporting extraction of data from various platforms, data

manipulation and publishing of data using sophisticated datagrid concepts. It aims to enable the public sector

employees to perform effective and efficient searches and It also enhances retrieval of the Government internet and

intranet content. It has five main components such as HttpFetch (Webcrawler), Content management tool for “Meta-

Tagging”, Central search engine, and Search user interface, and Admin module

Role:

• Worked on design and development of ‘Proof of Concept’

• Worked on coding GUI module using Web Forms in ASP.NET, ADO.NET with C# as code behind

• Involved in pre-alpha, alpha, beta workshops with CA state government for gathering complete

requirements

• Performed requirement analysis and design using UML visual modeling tool

• Worked with DBA to develop database schema (constraints, stored procedures, triggers, sequences) using

Oracle 9i

• Prepared test suits, test cases for various modules

Software tools used: ASP.NET, C#, ADO.NET, Visual Studio.NET 2003, Oracle 9i, HttpFetch Web-crawler, VSS,

Active Directory Server, XML, XSLT, LDAP, Inter-woven tool, Crystal

Reports, .NET Remoting, Web Forms

Client: Hewlett-Packard, CA

Project: Electronics Order Processing System (EOP) Jan 2004 – Aug 2004

EOP, electronics order processing system is a multi tier web based online products ordering system for HP channel

partners and internal HP users. The project includes various modules for placing different kind of HP orders and

involves various calculations based on the kind of order. This system also extracts info from other legacy system

(RSAP, OME) for deal orders, Bundle orders and promo orders. This system also has Backend schedule tasks

running in 24x7 and DTS jobs will update these details daily from/ to legacy systems. Admin module is used to

create and maintain domain Groups, Users accounts using LDAP in Active Directory server environment. Different

rolls assigned and removed to users thru dashboard. Data flow between Legacy front-end UI and application

database is implemented in XML format using DTD structure.

Role:

• Worked on coding different modules and windows services

• Developed application User Interface using Web Forms in ASP.NET, ADO.NET with VB.NET as code

behind

• Developed database schema and stored procedures in MS SQL Server 2000, Scheduling DTS Jobs

• Prepared test suits and test cases for various modules

• Conducted unit testing, functional testing, integrating testing, and System testing based on the test cases

Software tools used: ASP.NET, VB.NET, ADO.NET, Visual Studio.NET 2003, XML, MSSQL Server 2000, DB2,

Crystal Reports 9.2, Visual SourceSafe, Web Forms, .NET Web Services.

Contact this candidate