Shanti Nannepaga

Ph: 678-***-****

Email : abh10u@r.postjobfree.com

Business Analyst

Summary

. 8 years experience in requirements gathering, designing and developing

software.

. Excellence in developing browser generic web pages compatible for

Netscape, Internet Explorer, Safari, and Fire fox.

. Extensive experience in technical writing for client server applications

including creating, editing and developing business process

documentation.

. Good track record in documenting process flows, business requirements

mapping and defining, documenting deliverables; good exposure to process

based test management tools and creating test plans, test cases, system

specification, analysis documents, defect tracking, record results and

test reports; experience working with production and development systems;

ability to communicate and work with people at different roles and

responsibilities.

. Extensive experience in analysis, design, development and technical

writing of client server applications; well versed in client Server

technology, integrating IT solutions into business process designs and

developing test cases that match user requirements.

. Managed Data Warehouse application utilizing Informatica, Oracle 9i.

. Authored many technical documents such as: RFPs, requirement guides,

design documentations, specification documentations, and project

schedules, testing manuals, test case and user guides.

. Extensive work experience with business objects 6.5.

. Excellent communication and interpersonal skills with an excellent

corporate predisposition.

Expertise

Programming Languages: VB.NET and Visual Basic 5.0 / 6.0.

Web Technologies: ASP 1.0/2.0, D/HTML, Java Script, VB

Script, IIS 4.0/5.0, PERL, and PWS.

Component & Servers: COM, MTS and COM+.

Database: Oracle, SQL Server 6.5/7.0/2000, DB2

and MS Access.

Reporting Tools: Crystal reports 7.0/8.5/. Net.

Development Tools: Visual Studio.Net, Visual Studio

6.0, and Visual Interdev 6.0.

Configuration Management: Visual Source Safe.

Operating Systems: Windows 2000/NT/98/95.

Testing Tools Rational Rose

Requisite Pro

Reporting tools Business

Objects 6.5

Certifications

Microsoft Certified Professional in Visual Basic 5.0

Brain Bench Certification in ASP 2.0

PROFESSIONAL EXPERIENCE

Word for you Today, Alpharetta

Jan '10 till date

Business Analyst (Permanent Position)

Description: Word For you today (www.wordforyou.com) is a Christian

devotionals publishing company, with its worlds head quarters located in

Alpharetta GA. It also distributes devotionals to churches around the

world. The systems dealing with CRM and shipping were to be migrated into

access application called Traverse. Some of the applications that were

implemented are Deerfield, TPM, Info-Alert etc.,

Responsibilities:

. Analyze new software requirements for applications upgrading to

windows 7 platform.

. Document requirements and initialized application release phases.

. Develop mockups, and conducted workshops with the clients to

communicate the updates.

. Generate reports using SQL Coding.

. Provide analysis for the software requirements for the sales

applications.

. Integrate CRM and TPM systems, analyze data write specification

document.

. Implement, test software for remote support.

. Develop reports, and queries using MS SQL Server 2005.

Environment: Microsoft Visio, SQL Coding, Microsoft Word, MS Access,

Macromedia Dream weaver, Microsoft Edit plus, Microsoft PowerPoint,

Rational Rose Requisite Pro, MS SQL Server 2005.

AT & T, Alpharetta

Feb' 08 to Jan '10

Business Analyst

Description: AT&T IT commission group manages sales applications for sales

operations team. These applications help maintain sales agents and company

owned retail rep and managers commission payment information. CENET feed

sends dealer and rep information to various downstream systems. Another

central repository application called Cingle Point manages the employee,

location, dealer, and market and agent contract information for various

business channels. The sales operation for their reporting needs rely on

business objects 6.5 for reporting on various systems like BID, Cingle

Point and Horizon (Retail and Agent)

Responsibilities:

. Analyze changes suggested by business; convey system impact and risks.

. Conduct workshops to capture the business requirements with business.

. Review use cases with business, development and system test.

. Write detailed commission's formula for new products in the

requirements document.

. Document project flow and gather system requirements for development.

. Maintain requirement matrix and follow the IT Up process for SQA.

. Provide assistance in testing the application. Helping QC team with

creating their test cases.

. Maintain business, system requirements in Requisite Pro.

. Validate the requirements and check Sarbanes Oxley (SOX) compliance

for requirements involving legal bindings with legal team.

. Maintain document for the systems researched for each project.

. Create and document SQL Queries and Join information for Business

objects universe updates for BID, Horizon and Cingle point.

. Document classes and objects information for BO Universe updates.

. Generate SQL queries to learn and test the application, to check and

see if the requirements have been implemented per planned.

. Approved HLD documents for development and also provide approvals for

Test rules on the requirements by QC.

. Cross train the Business Analyst team on the changes to the systems

via requirements to keep the team abreast of the application

enhancements.

. Conduct workshops for various business partners and business analyst

teams.

. Provide support to the business objects team on their reporting

requirements.

Environment: Business Objects 6.5, Microsoft Visio, SQL Coding, Microsoft

Word, MS Access, Microsoft PowerPoint, Rational Rose Requisite Pro, Oracle

SQL Developer, Toad.

Word For you Today, Alpharetta Dec '07

to Feb '08

Business Analyst

Description: Word For you today (www.wordforyou.com) is a Christian

devotionals publishing company, with its worlds head quarters located in

Alpharetta GA. It also distributes devotionals to churches around the

world. The systems dealing with CRM and shipping were to be migrated into

access application called Traverse. Some of the applications that were

implemented are Deerfield, TPM, Info-Alert etc.,

Responsibilities:

. Documented requirements and initialized application release phases.

. Developed mockups, and conducted workshops with the clients to

communicate the updates.

. Developed Technical Documentation for the procedures that lack

documentation, in scope with CRM.

. Generated reports using SQL Coding.

. Provided analysis for the software requirements for the email

management.

. Tested and implemented Visnetic mail flow to interact with different

applications.

. Implemented, tested software for remote support.

. Developed reports, and queries using MS SQL Server 2005.

Environment: Microsoft Visio, SQL Coding, Microsoft Word, MS Access,

Macromedia Dream weaver, Microsoft Edit plus, Microsoft PowerPoint,

Rational Rose Requisite Pro, MS SQL Server 2005.

GE Energy, Atlanta July

'06 to Sep '07

Business Analyst

Description: PSRM - Post Sales Relationship Management is designed to be a

CRM tool to help field and service engineers to contact call center (Power

Answer Center) and log breakdowns or issues on hydro turbine. There are

around four types of these turbines, Wind, Thermal, hydro and Aero. My area

of work has been mostly with Hydro Turbines.

Responsibilities:

. Gathered requirements from hydro-turbine users that include field

engineers and project managers Also enhancements for Data Warehouses.

. Developed functional specifications using UML class use case diagrams,

for PSRM interface for post sales customer interface for hydro-turbines.

Used Dream weaver to develop a mock up GUI.

. Developed mockups for presentations to explain the enhancements to the

users.

. Corresponded with the hydro team to get the functional specifications

signed off for development.

. Documented test metrics for applications running on PSRM servers. Used

JAD Sessions to develop mock up presentation to the users

. Developed Technical Documentation for the procedures that lack

documentation, in scope with CRM.

. Developed use cases for the process map documents for the PSRM fourth

phase release.

. Tested application developed out of functional specs and written use case

test scripts.

. Generated reports using SQL Coding.

. Written UAT Test scripts performed UAT on applications before giving sign

off for production.

. Provided post deployment support with Professional Issue Tracker.

. Tested application using Rational Rose Requisite Pro

. Implement Data Mart and Data Warehouse utilizing Oracle 8i

. Utilized Oracle Warehouse Builder OWB

. Incorporated Six Sigma capabilities to develop functional specs for the

application.

Environment: Microsoft Visio, SQL Coding, Mercury Director, Microsoft Word,

Oracle 8i, Macromedia Dream weaver, Microsoft Edit plus, Crystal Reports,

Microsoft PowerPoint, Rational Rose Requisite Pro.

Guardian Life Insurance, New York September '05

to Jul y'06

Business Analyst

Description: Guardian Online (GOL) is a collection seventeen intranet and

internet website applications developed and maintained by Field Technology

department. GOL helps agencies gather and store information on different

Insurance polices. Applications are developed using Visual Basic, ASP,

Java, COM, and MTS. Backend being SQL Server and UDB. All the applications

are being accessed behind a web seal server to accommodate security into

existing applications.

Responsibilities:

. Gathered and defined Business requirements / Enhancements for Data

warehouses, from users/agents on GOL websites.

. Initialized production releases with tracker numbers for each

enhancement.

. Improved communications between developers and users and reducing project

communication overheads via Process Engineering methods

. Developed data porting utility to port data from SQL tables to UDB, also

using SQL Coding.

. Maintained and monitored daily server jobs on UDB Client.

. Developed application to infer on application usage statistics using VB,

ASP and COM objects to be accessed by GOL clients from their offices

. Enhanced code to improve the quality of the application using VB6, ASP,

and COM+ for Terminal Services to register the com objects.

. Migrated and developed applications using .Net architecture.

. Prepared functional specification document with UML standard

presentation.

. Generated As Is and To-be Process Maps

. Prepared Technical Manual for users to help use the application.

. Documented high level Needs and Features in Requisite Pro

. Documented UAT testing analysis using Rational Requisite Pro

. Detailed Business Requirement Document (BRD)

. Supported application prior to deployment.

Environment: Microsoft Visio, SQL Coding, Microsoft Word, Crystal Reports,

Oracle 8i, Macromedia Dream weaver, Microsoft Edit plus, Microsoft

PowerPoint, Rational Rose Requisite Pro.

AT&T, Somerset, NJ

December '03 to September' 05

Business Analyst/ Developer

Description: The system was re-engineered from Access and VBA, to VB.Net

and ASP. The application processed new Public Switched Telephone Network

users and additional services for existing users. The system was designed

to receive the information in Excel spreadsheets, or Access database files

or text files from AT & T franchisees. The received files were processed to

create new records in the SQL Server database and send a confirmation email

to the franchisees. It is possible to have a single or thousands of new

telephone connection orders in a spreadsheet. The application validated the

new telephone numbers assigned to the ones which exists and generates order

tickets and each new phone number is assigned a circuit id.

Responsibilities:

. Developed Process maps, use case diagrams and use case test scripts.

. Documented Business requirement document.

. Used UML to develop testing strategy.

. User Interface Prototype for Intranet Order Management System.

. Detailed Use Case specification

. Assisted in developing virtual private network architecture

. Detailed Data Element Analysis for Tracking Orders.

. Involved with all components, standards, protocols of the voice and data

network. (TCP/IP, H.323, SIP, AAA, Servers, Routers, ATM, Large and LAN /

WAN Networks, Softswitch, 3G HDR-1xEVDO/1XEVDV, etc.) In addition,

configured several optical fiber / microwave back-haul networks as a more

cost effective and reliable means to link their base stations to the

switch for several major markets. Co-created back-haul business financial

cases.

. Developed automated tool using ASP, XML, JavaScript and VbScript,

maintaining the log for the users using the tool.

Environment: Oracle, access 97, SQL Server 2000, ASP, VB, VbScript,

JavaScript, Visual studio 6, access 97 VBA.

Solutions Time Inc, SD November' 02

to December'03

Business Analyst

Description: A Project LD Accounting application from Client Phone One

helps keep track of long distance usage and bills it to virtual phone

connections. The application provides itemized call information on each for

each virtual phone connection. The system also allows you to view a listing

of your Long Distanc

e inventory associated Phone One account. You also have the ability to

filter and/or download your inventory and create/view repair tickets. In

addition, the Long Distance product application provides you the ability to

view your Accounting Codes.

Responsibilities:

. Designed user interface proto-type and modeled presentations to the

client.

. Developed Request for Proposals and work flow diagrams for LD Accounting.

. Gathered specifications from vendors to plan the project.

. Designed UML project flow to Map with the inputs from users and

developers.

. Used VB.net coding methods for ASP.Net application for the client Phone

One.

. Created controls to accommodate the application requirements, written

assemblies to add components to the application.

. Provided Analysis of telecommunication networks and products. In-Depth

understanding of network architecture design and deployment

Environment: Oracle, ASP, Visual Basic, ASP. Net, Visual Studio, Microsoft

FrontPage, macromedia dream weaver, Macromedia Flash, Fireworks, VB,

VBScript, HTML, SQL Server 2000.

RTC, Calgary, Canada August'00

to November' 02

Business Analyst

Description: RTC is a recruiter tracking control system that helps

recruiters and marketing managers maintain their client and consultants

list to efficiently place the people in jobs there by contributing towards

implementation and development of the company profile. This is a desktop

application used by the company employees. RTC intranet application was

developed for recruiters in three locations in Canada Alberta, Manitoba and

Toronto

Responsibilities:

. Generated As Is and To-be Process Maps

. Documented high level Needs and Features in Requisite Pro

. Detailed Business Requirement Document (BRD)

. Developed User Interface Prototype

. Detailed Use Case specification

. Detailed Data Element Analysis Designed intranet application using .Net

and SQL Server

. Evaluated the need to develop more robust app to bridge communication

between three client locations using .net software.

Environment: ASP, Visual Studio, Java Script, SQL Server 2000, ASP, HTML,

DHTML, VB, Web Services.

Morning India, Ridgeland, MS

November' 99 to August'00

Business Analyst

Description: HPN under took a project with morningindia.com to develop

ecommerce web sites for the client. HPN is located in Mississippi and we,

as developers are required to travel to the client locations for launching

the websites. The web page is divided into four sections, one news section

with the news from across the country and across the globe, second daily

highlights with weather and sports, third being the entertainment section,

and fourth the ecommerce section where there is a list of services provided

for users to use over the internet like purchasing gifts, phone cards,

donations et

Responsibilities:

. Developed user manuals, BRD and RFP.

. Detailed Use Case specification

. Detailed Data Element Analysis

. Developed the project that has particular highlights on the socio

economic updates of the country for the users. This web application was

developed using ASP also used ADO's and CDONT's.

. Used the backend as SQL Server, the development team updates this portal

continuously.

. Used Content rotator to keep the data rolling on the pages avoiding

static display.

Environment: ASP, Visual Basic, Java Script, SQL Server 2000.

APDPEP,

June'98 to October' 99

APDPEP Web designer/programmer

Description: Our esteemed clients are one of the most powerful central

government organizations called DPEP (District Primary Education Program)

for Andhra Pradesh. They had taken steps to launch the web site for APDPEP

to show their work and its results on Web to one and all. Their work

includes providing primary educational facilities to the people in

districts and mandals of the state. Responsibilities:

. Designed the web pages where data of the state DPEP schools have to be

displayed using Photoshop and Flash.

. I was involved in creating the mail program to store and display the

mails using ASP.

. I used both IE and Netscape Navigator tested the web page.

Environment: Windows 98, HTML, JavaScript, Vbscript, Macromedia Dream

weaver, Flash, Oracle.

EDUCATION

. Master Of Arts - MA English Literature - Completed

in 2000

. Honors Diploma in Computer science - Completed in 1999

. Post Graduate Diploma in Foreign Trade Management - Completed in 1996

. Bachelor of Science - Completed in 1995

Contact this candidate