Data Security

Narasimha Reddy Budideti

Home: 952-***-****; Cell: 651-***-****

E-Mail: *********@*****.***

Professional Summary

1. Over 12 years of total IT experience in Applications Development using

client-server architecture and web technologies.

2. Very strong in Business Objects Administration and report development.

Lot of experience in report development using tools like Crystal, Web

Intelligence, OLAP Intelligence, Brio SQR.

3. Proven ability to analyze problems and formulate and deliver effective

solutions

4. A team player with a strong work ethic and works well independently.

5. Involved in all phases of development life cycle.

6. Business Objects Certified Professional.

Areas of Expertise

Business Intelligence: Business Objects 6.x/XI/R2/R3

Web Technologies: ASP, ASP.NET/VB.NET, JSP, HTML/DHTML, JavaScript,

VBScript, CSS, and XML/XSL

ETL Tools: MS DTS, Business Objects Data Integrator/Data Services,

Informatica

Databases: Oracle, SQL Server, DB2, Sybase, MS Access

Reporting Tools: Crystal Reports, Web Intelligence, Desktop Intelligence,

OLAP Intelligence (Voyager), Crystal Excelcius, Brio SQR, Reports 2.5

Operating Systems: Windows, UNIX/AIX, MS-DOS

ERP: Peoplesoft 7.x (HRMS), People Tools, People Code

Additional: Visual Studio/.NET, Visio, Power Designer, ERWin, IIS,

WebLogic, Websphere, Tomcat

Experience

National Marrow Donor Program Minneapolis, MN

7/2007 - 3/2010 Business Objects Architect (Consultant)

. Information Architecture

o As part of new enterprise architecture initiative, demonstrated

advantages business intelligence and data warehouse to the

business.

o Responsible for sizing, installation and configuration of

Business Objects Servers.

o Involved in negotiating the pricing of Business Objects software

purchase.

o Configuration of Windows AD and Single-Sign-On along with well

designed Business Objects security.

o Developed Pilot BI solution using Business Objects and SQL

Server.

o Designed (including datamart modeling) the data marts (DIY and

DCP) and populated them using Business Objects Data Services ETL

tool.

o Developed Universes and Web Intelligence Reports.

o Mentoring client team on Business Objects tools and

administration.

o Recently upgraded Business Objects Servers from XI R2 to XI R3.1

o Setup report bursting using InfoBurst.

o Redesigned the BO security in XI R3.1 by leveraging all the new

features.

o Responsible for administering the BOXI and BODI servers

including installations and service/fix packs.

o Upgraded Data Integrator server from R2 to R3, R3.1 and then

3.2.

o Set up/upgrade all BODI local repositories and central

repositories.

o Worked as a Data Architect in Designing a Data Mart for CIBMTR

(Research) team. Using BO Data Services, populated (ETL) the

data mart with a data from various data sources and multiple

locations. This complicated data mart contains data from many

data sources and multiple locations. This data mart has been a

huge help for the business to clean up the transplant center's

data issues.

ShopNBC Eden Prairie, MN

2/2009 - 11/2009 Business Objects Consultant

o Sizing recommendations

o Installation and Configuration of Business Objects XI 3.1

o Setting up Single Sign On with Windows AD authentication

o Migration of reports from XI R2 and 6.5 version

o Documentation of the all processes and best practices

Land O' Lakes Shoreview, MN

2/2007 - 7/2007 Business Objects Consultant

. Rebuild/modification of Product Bulletins (BO Reports)

o Enhanced existing Product Bulletins (BO reports) and developed

new complex reports using Business Objects 6.1b and some reports

has up to 32 data providers.

o Developed a macro that generates hundreds of PDF files using the

report template looping through all products and push them to a

portal application for external users.

o Developed universes that has built in measures at different time

periods like Current Month, Prior Month, Prior Year Month, Year

to date, Prior Year to date etc.

o Created reports using Web Intelligence that meets the user

requirements.

. Administration/Security

o Completely redesigned the folder structure to support enterprise

level reporting. Implemented new type of security in place of

very ineffective security setup.

o Accommodated all the existing reports into new folder structure

by interviewing appropriate business users/managers. This

eliminated lot of confusion for end users as they will see few

folders and universe that are right for them.

o Implemented LDAP authentication.

Secure Computing Corporation St. Paul, MN

12/2006 - 2/2007 Business Objects Consultant

. Environment, Administration and Security Implementation

o Set up Development and Production environments

o Responsible for design and implementation of security to meet

the client's requirements. Security was set up at three

different levels (Object/Report, Data, and Functional Level)

o Implemented Active Directory authentication with Single-Sign-On

capability for InfoView.

. Report/Universe Development

o Converted exiting complex excel reports to web intelligence

reports.

o Created Restriction Sets in the Universe to provide data level

security.

Prime Therapeutics LLC Eagan, MN

4/2006 - 12/2006 Business Objects Consultant

. Business Objects Universe and Reports Development

o Converting reports from legacy system (Sagent) to Business

Objects XI R2 (Web Intelligence documents)

o Created Webi documents using existing report logic and tuning

SQL to get best performance.

o Consolidated multiple old reports into one Webi document by

providing users prompts and all possible objects to create their

own reports.

o Developed Universes that meets the functionality defined the

legacy system.

o Developed some reports using Crystal reports as well.

. Administration and Security Implementation: Responsible for design and

implementation of security to meet the client's unique and customized

security needs. Customized the InfoView by hacking the JSP code to

meet the security requirements.

o Security was set up at three different levels

. Reports Level Security

. Data Level Security

. Functional Level Security

o Reports Level Security: This model restricts users to access

only certain number of folders/categories/reports.

o Data Level Security: This model was implemented in Universes

using restriction sets. The data is restricted at row level,

connection level. For example MN users gets MN related data and

IL users will see IL related data from the same report/Webi

document.

o Functional Level Security: This type of security ensures that

different types of users will see different functionalities of

the InfoView.

o Fixed so many security related issues.

United Health Group Minneapolis, MN

10/2004 - 4/2006 Technical Lead

. Business Objects Development and Administration:

o Installed (version 10 and later on XI) and configured the

environments for both development and production.

o Created repository and security domain with user groups and

security implementation, so that certain type of users can

access only permitted reports.

o Involved in full life cycle of Business Objects reporting

Application.

o Developed hundreds of reports using Crystal Reports XI.

o Developed Web Intelligence Reports.

o Developed OLAP reports using Business Objects XI OLAP

Intelligence.

. Sales and Marketing data mart development:

o Designed and developed a data mart for reporting purposes. The

data extracted using MS DTS from various databases and loaded

into this data mart.

o Created lots of crystal and OLAP reports that accesses data from

this mart.

. Ovations Data Mart development

o Worked on the biggest data mart for Ovations business segment,

which contains three main types of claims (facility, physician

and pharmacy) data, member and provider data and enrollment

data.

o Developed ETL packages using MS DTS that pulls above mentioned

data from Galaxy (the main UHG data warehouse) and other

sources.

o Developed MS OLAP cubes for the reporting in Business Objects

against the ODM.

. Business Trends reports

o BTR is a dash board reporting developed using Microsoft .NET

Reporting Services that contains patient demographic information

along with the data from various different sources.

o Developed a utility that generate reports in excel, PDF, html,

rtf formats for every facility.

Target Corporation Minneapolis, MN

6/2000 - 10/2004 Technical Consultant

. Designed and developed Pharmacy Management System, which is a web

based recruitment application for Target Pharmacy. It enforces and

guides the recruiter to follow the workflow of hiring process. It

tracks all the personal and professional details of pharmacists. It

also produces the required letters for the applicants. This

application was developed using ASP, SQL Server

. Designed and developed Work Requests Application that provides a central

repository for all work requests (projects) and key decisions in the

Target Pharmacy department. This application provides the management with

the ability to review work requests, assign priorities and resources to

these work requests. This application provides a set of reports for the

management to facilitate the communication. This application works in

conjunction with TPM (Tivoli Problem Management) and Niku and also serves

as a communication vehicle between TTS Pharmacy and business clients.

This application was initially developed using MS Access and Visual Basic

for applications (VBA) as a temporary solution.

This application was redesigned that developed using ASP.NET and SQL

Server to make it available over the web to meet the growing demands of

the application.

. Target Pharmacy Guest Lookup: Designed and developed Target Pharmacy

Guest Lookup Utility that leverages the strengths of Target's Guest

Database and Personalization Projects. It provides a simple interface,

available only through our private, internal network, for an authorized

Pharmacy Store or Support team member to look up information at the

specific request for such information from a guest. The application

queries against the guest database to retrieve guest's information that

contains list of Target stores where the guest has made department

purchases. This list can be used to Auto transfer prescriptions.

Technologies used are ASP, JavaScript and Oracle.

. Pharmacy Workflow: As a member of the Target Pharmacy reengineering Study

team, responsible for testing and quality assurance of a new workflow

system to save money, provide quicker delivery time, allow pharmacists to

counsel customers, automate filling and dispensing, ensure accuracy of

prescriptions, and improve Target Brand Service.

. System Integration: Developed PDX DAT reports and Korn Shell scripts to

pull data from PDX system and send it to GMS (General Merchandising

System) and vice versa. The main motto of this project is integrating the

Pharmacy item data and sales data with Target GMS system to centralize

Pharmacy business.

. Marketing Reports: Developed a reporting packages for Pharmacy

Marketing/Pricing team using VBA, MS Access and PDX DAT. Source data

was created using PDX DAT that will be imported to Access database to

produce the desired report. These reports are used for sales/marketing

personnel to make important pricing decisions, comparing most selling

drugs, Third Party and helps increasing the gross margin percentage.

. FileBuy Reporting: Developed PDX DAT reports package for the Pharmacy

FileBuy process. When Target acquires pharmacy store, these reports

are used to extract the data and that data will be merged with the

Target Pharmacy PDX data.

. Automation: Automated many processes like NDC Pricing Analyzer and

Verispan Application using Korn Shell scripting.

. PDXX: Developed PDXX application using DAT and shell scripts to pull the

transaction level data from the stores and pushed to RxR (Third Party

Receivables) system. This application was developed in replacement for

the PDX proprietary system which takes a long time to do the similar

functions. PDXX application reduces the run time by 95%, so the Target

pharmacy personnel have time to focus on pulling the missing stores data

to host and some other house keeping operations.

IRMAC USA Inc Eagan, MN

2/1999 - 6/2000 Technical Consultant

. Designed and developed web portal prototype for symplesource.com using

ASP, SQL Server.

. Involved in Design and development of an intranet application for

PIMMS, a merchandising service company. This application tracks the

company, project and resources data.

. Luther Auto: Involved in development of an e-commerce website utility

(www.lutherauto.com) for Luther auto that includes onsite

administration. This controls display of a particular advertisement

based on the customer membership status. Web site administrator has

ability to add, delete, modify information and can change the display

status (show or hide) of the automobile information. Technologies: VB,

ASP, SQL Server.

Freedom-nation.com extranet: Involved in development of an extranet

application for Emerald First Financial (now FREEDOM-nation). As a key

member of the development team, designed and developed dealer extranet

application, where boat, motorcycle, RV and power sports dealers login

to perform different operations such as adding, modifying and deleting

inventory. Technologies: VB, ASP, Oracle, HTML.

Trade Labor Extranet: Designed and developed a secure web site

accessible to members of this nationwide resource matching company

catering to the trade industry. This application maintains a

centralized database where members can post their available resources

and other members can access this information. Technologies: ASP, SQL

Server

. Time tracking System: Involved in design and development of an intranet

application that keeps track of employee timesheets. Employees login to a

secure page and enter their time on a weekly basis. The website has

capability to check available vacation time, sick time, personal days

available etc. There are some predefined reports built in for the

management.

Rudolph's Ribs Website: Designed and developed a website for Rudolph's

Bar-B-Que which is a well-known Bar-B-Que Restaurant located in

Minneapolis. Using JavaScript functions, created special effects to

display menus (specials) available at the restaurant.

. IRMAC Website: IRMAC is a technical consulting company with four offices

worldwide. Designed and developed a website with intranet capabilities.

IRMAC Software Services Ltd Hyderabad, India

3/1997 - 1/1999 Programmer

. Involved in development of in-house client server applications using

Visual Basic and Oracle.

. Peoplesoft Upgrade from version 6.02 to version 7.5: Worked on this

project after a year of extensive training in Peoplesoft 7.x (HRMS)

with people tools, PeopleCode and SQR. This project is done for CSX

Transportation, Jacksonville, FL. This project involves identifying

all customized SQRs from PeopleSoft delivered and also newly developed

SQRs that may impact version upgrade. Applied all customizations from

V6.x to V7.5 delivered SQRs. Upgraded the CSX developed SQRs (i.e.

both reports and interfaces) by adding the new columns and tables

introduced in V7.5. Involved in online changes like adding customized

translate values, PeopleCode, panels and menus.

Education

Master of Computer Applications (M.C.A), Osmania University, INDIA

Bachelor of Science (B.Sc.) in Electronics, S.V. University, INDIA

References

Upon Request[pic]

Contact this candidate