Business Analyst / Report Developer

Aparna Alapati

Business Analyst

• Phone: 678-***-**** • Email: *********@*****.***

Summary

Around 4 years of experience as a business analyst with in-depth knowledge of SDLC and solid

understanding of business requirements gathering, evaluating data sources, translating

requirements into specifications, application design and implementation.

Experience in analysis, design, testing and implementation of software applications.

Experience in Waterfall, Iterative Waterfall and Scrum/Agile Development processes.

Professional knowledge of business intelligence, reporting, business architecture, data

warehousing, relational database systems and SOA environments.

Extensive experience in gathering Business and Functional Requirements, developing Use

Cases, conducting Gap Analysis and Impact Analysis, modeling Businesses Processes,

and preparing Training manuals and Knowledge Transfer manuals.

Experience in Creating and Maintaining the Requirements Traceability Matrix (RTM),

conducting Joint Application Design (JAD) sessions, project meetings, reviews and

walkthroughs, and customer interviews.

Experience in using Rational Requisite Pro, Rational Rose for requirements management

and analysis use case development, business and data modeling.

Proficient in creating Use Cases, Sequence Diagrams, and Collaboration diagrams, Activity

Diagrams, Class Diagrams, and Business Intelligence Tools .

Experience in BI Report Authoring using Cognos 8 Suite (Report Studio, Query Studio,

and Framework Manager).

Experience in enterprise reporting tools like Business Objects, Crystal Reports and

Cognos.

Experience in development of various kinds of reports like List, Cross tab, Charts etc in

Cognos 8 which involved Multiple Prompts, Filters, multi-page and multi-query reports.

Professional knowledge of business intelligence, business architecture, data warehousing,

relational database systems.

Effective communicator with excellent skills in making Business Presentations,

Documentation, writing and developing Business Reports and Technical Specifications.

Proven ability to contribute significantly to projects independently and in a team

environment.

Well experienced in full life cycle of reporting including Requirement Gathering, Report

management and Scheduling, Report Delivery and Publishing, and Report Security.

Strong Knowledge of Data modeling techniques, E-R charts, Star Schema for data

warehousing.

Experience in using SQL and PL/SQL to write Stored Procedures, Functions, Packages

and Triggers.

Technical Skills

Crystal Reports 2008/XI R2/10.0/9.0/8.0, Business Objects

Data Warehousing Tools Enterprise XI 3.1/XI R2, SSRS

JSP, ASP, XML, HTML

Web Technologies

Oracle 10g/9i/8i, MS SQL Server 7.0/2000/2005, MS Access

Databases

Windows XP/2003/2000/NT, UNIX, SUN Solaris

Operating Systems

PL/SQL, SQL, T-SQL, Java and Perl

Languages

TOAD, SQL* Plus, Visio, MS Office 2003/2007, MS

Tools/Packages

Access, MS Excel.

Education

Masters in Information Systems

Master of Business Administration

Professional Experience

ThyssenKrupp Elevator Ltd Feb 12 –

Present

Dallas, TX

Business Analyst

ThyssenKrupp Elevator Ltd is the largest producer of elevators in the Americas. ThyssenKrupp

Elevator Ltd is the North American market leader in the manufacturing, modernization,

installation and maintenance of elevators, escalators and moving walks.

Project: Job Site Management System

Project Details: JMS is a custom application used to manage the elevators built in the various

regions in America. Applications enable the user to view number of elevators currently deployed

in a particular region and view, edit or create the various details about the elevators such as

Elevator type, address, contract details, unit details, manpower used, change orders etc. The

system also allows the field managers to view elevator details, elevator shipping date (after

construction) enter the comments about the construction for the particular Job Site. Finally, the

reports are generated about elevators information for that particular job.

Responsibilities:

Involved throughout the Business Analysis phase, conduct business requirement gathering

sessions with the business users.

Gathered business requirements and translate them to functional requirements for use

by the development teams.

Organized requirements into logical groupings of essential business processes, business

rules and information needs, ensuring that critical requirements are not missed, by

following a structured approach.

Actively involved in the process and design of the sales data collection, transformation and

reporting.

Maintained the Requirement Traceability Matrix to ensure that all the business needs are

met.

Reviewed the functional test scenarios and the test cases developed by the testing team.

Analyzed the requirements and assist in the design of the Oracle data models, data

extraction, transformation and loading.

Conducted regular status presentations to the senior management and responsible for

escalation of any critical issues.

Coordinated user acceptance tests and pursue successful sign offs from the business

users.

Responsible for coordinating the formal knowledge transfer to the production support team.

Responsible for maintaining the BI team Share Point and the project document repository.

Conducted daily defect status meetings and weekly team status meetings for assessing

testing status and requirements traceability, reviewed test plans of peers’ projects and

shared ideas for improved testing efforts.

Scheduled and conducted walkthroughs of existing functionality and performance to maintain

product quality.

Gathered the requirements from the existing documentation and update with changes,

enhancements break fixes that have been implemented since each interface went live.

Identified and documented issues, risk and gaps, their descriptions, their impact and

provided recommendation and alternatives to develop the application to meet the user

requirements.

Experienced with web services concepts and support utilities, related database utilities.

Demonstrated understanding and experience with ETL, stored procedures and SQL

queries.

Tracked requirements, test execution and defects using Mercury Quality Center.

Coordinated User Acceptance Testing (UAT) with the business users and managed

maintenance and change requests.

Involved in System and Integration Testing with the Quality Team.

Clark County Government Center Jun 11

– Feb 12

Recorder’s Office, Las Vegas, Nevada.

Business Analyst / Reports Developer

The Clark County Recorder’s Office is focused on recording, preserving, and providing access to

public records. The County Recorder records and indexes documents deposited in the office that

are authorized, entitled or required by law to be recorded. The recorder’s office handles huge

amount of data and performs a wide variety of tasks staring from recording land documents to

selling of marriage copies. The reports developed for Recorder’s Office include Statistical Reports,

Financial reports, Performance assessment reports, Accuracy Reports and so on which are required

for both internal and public use.

Responsibilities:

Involved in continuous process improvement and for identifying and maintaining a clear and

measurable development Process that is deployable throughout the enterprise using RUP.

Derived Functional Requirement Specifications (FRS) based on User Requirement

Specification. Understand and articulate business requirements from user interviews and then

convert requirements into technical specifications.

Extensively involved in JAD sessions to converge towards a design acceptable to the

customer and feasible for the developers.

Involved in Relational database designing and modeling and maintaining referential

integrity and normalizing database.

Analyzed the requirements and assist in the design of the data models, data transformation

and loading logic.

Coordinated user acceptance tests and pursue successful sign offs from the business users.

Involved in database re-engineering to meet the business system requirement by breaking

down the existing database tables into many tables and restructured the tables and fields

including the reference keys and constraints following RDBMS normalization rules.

Created documentation for use cases, functional specs, process flow diagrams, test plans,

project issues, risks, assumptions and process maps.

Participated in Team Meetings with major departments of the Recorder’s Office and

worked on redesigning the reports specifications to meet the advancements in the system.

Gathered user requirements, draft specifications, design and deployed reports using

Crystal Reports Designer.

Responsible for drafting documentation for end user usage and developed training

materials.

Created Stored Procedures, Views, Queries, User Defined Functions and Triggers in SQL.

Developed reports using Crystal Reports 10.0. Reports developed include Cross Tab

Reports, Sub Reports, Standard Reports and Charts.

Developed complex reports based on multidimensional data to figure out the monthly,

quarterly, and annual sales from different geographic locations based on different customers.

Developed Cross tab reports, Pie, Bar and Line Charts and drill-down reports with

Formulas and Parameter fields.

Created reports using tools like Command Objects, Select expert, Selection Formulas and

Formula workshop to filter the records.

Automated Reports Scheduling using Central Management Console.

Created Stored Procedures and Views on SQL Server to be used in various Reports.

Wrote SQL and used them as Crystal Command Objects for developing various Crystal

reports.

Involved in performance tuning of Crystal Reports for better performance.

Environment: Crystal Enterprise XI/2008, SQL Server 2008, Windows XP, MS Office 2007, HP

Quality Center 10

HP Enterprise Services Dec 09 –

Mar 11

Raleigh, NC

North Carolina Health Information System

Business Analyst/Crystal Reports Developer

HP Enterprise Services delivers enterprise-class IT infrastructure consulting, support,

outsourcing, financing and education. The Health Information System (HIS) application

developed for the State of North Carolina will improve public services and programs and

increases collaboration among local agencies/health care providers leading to improved patient

care. HIS provides reporting capabilities for local and statewide public health activities. The

reports developed include the following program areas: Client Characteristics, Appointments,

Billing, Patient Assessments and Patient Medical History etc. for analysis and day-to-day

activities.

Responsibilities:

Extensively gathered requirements from Business Users and Subject Matter Experts

(SME's) to understand the current functionality and assess the needs of the users.

Assisted in the preparation of Functional, Non functional and Systems Requirements

Specifications for each project.

Worked on Software Development Life Cycle (SDLC) from requirement analysis till

deployment, using highly efficient RUP process of software development

Prepared As Is and To Be workflows & analyzed the processes which needed customization

Assisted in Calculation of Software Costs, Training Costs, Benefit Amount and ROI for

various software products.

Created and Maintained the Requirements Traceability Matrix (RTM).

Reviewed quality with respect to the requirements based on reliability, functionality and

performance with the help of QA testing team.

Involved in creation of several de-normalized views in order to develop a data warehouse

model to help users create their own ad hoc reports using Query Studio in Cognos.

Participated in the creation of company’s source dimensional model with different layers like

Business View, Database view etc for different packages with the help of segment links.

Responsible for creation of Burst reports using Report Studio, removing several

individual versions of the same report for individual levels in the company’s hierarchy

using Email addresses and Security groups.

Designed the company’s own custom templates for creating List, Crosstab and Chart

Report types.

Created the Event Studio alerts in order to let the administrator know whether the daily

jobs are successful or not.

Involved in the creation of daily and monthly sales OLAP cubes to improve performance

for the users to create their own analytical reports using Analysis Studio

Developed several standard Summary Reports using Analysis Studio and created drill-

through to Detailed Report Studio Reports.

Responsible for creating report studio reports using Master Detail Relationships, Custom

SQL, Unions, Conditional Blocks, Bookmarks etc.

Involved in writing and validating the test scripts of several views created for ad-hoc

reporting purposes.

Environment: Crystal Reports XI R2, MS Office 2003, Oracle 10g, Windows XP, MS Project

2003, Rational Tools, Mercury Quality Center 9, MS Visio 2003, HIPAA

Honkong and Shanghai Banking Corporation (HSBC) Mar 08 –

Nov 08

Corporate Banking

Jr. Business Analyst/ Sales & Mktg

The project is an Online Banking Application. The application was developed on Oracle.

Customers can access their savings account, checking account, and credit card account through the

Internet. Customer has the option to transfer funds between different accounts, check their

transaction details, schedule payments, pay bills, and send online requests to banks. The

Application was tested with Rational Tools.

Responsibilities:

Prepared Business Workflow models using MS Visio that cover "How" business processes

are accomplished.

Prepared As Is and To Be workflows & analyzed the processes which needed customization

Interacted and interviewed business and operations to get input for specifications.

Created detailed Use Cases and UML diagrams.

Involved in Business Process Reengineering initiatives and Continuous Improvement

initiatives.

Performed Gap Analysis for new functionality requirements, as well as prioritized them

based on actual business needs so as to align them with the product release roadmap.

Gathered user requirements, draft specifications, design and deployed reports using Crystal

Reports Designer.

Responsible for drafting business process documentation for end users and developed

training materials.

Assisted in the preparation of Functional, Non functional and Systems Requirements

Specifications for each project.

Reviewed quality with respect to the requirements based on reliability, functionality and

performance with the help of QA testing team.

Performed various SQL activities like creating and modifying Tables, Views, Stored

Procedures and Functions.

Developed complex SELECT statements which involve correlated and non-correlated sub

queries, summaries, inner and outer joins, group by and order by functions.

Used CASE statements to check for conditions when extracting the date using Select queries.

Experience in using INSERT, UPDATE and DELETE statements for data cleanup in the

tables.

The reports developed include Statistical Reports, Financial reports, Performance assessment

reports, Geographical reports, and demographic reports etc. which are required for both

internal and public use.

Contact this candidate