Nirlipta Daschaudhury

Email: ablk8g@r.postjobfree.com

Phone: 571-***-****

Experience Summary

Seven years of experience in all phases of Enterprise Software Application

Development encompassing full life cycle of projects.

Strong analytical experience with focus on BI/DW business requirements

gathering and requirements management.

Highly experienced in administration, development and deployment of

Business Intelligence/Decision support systems.

Excellent problem resolution and communication skills with ability to work

under pressure in a highly visible role.

Experienced in conducting design sessions based on system specifications

and test plans with the ability to handle training sessions and

documentation.

Experienced in data warehousing methodologies of star-schema design for

OLAP systems.

Highly experienced in developing simple and complex reports using Business

Objects XI R3 and earlier versions, Crystal Reports 10.0 and earlier

versions and Crystal Excelcius.

Extensive experience of writing complex PL/SQL Stored Procedures

Proficiency in using Oracle, SQL Server and MS-Access databases with

Reporting Tools.

Programming Skills:

Operating System: Windows XP/2000/NT/98, UNIX-HP 11.0, Sun Solaris 2.x

Languages: SQL, PL/SQL, SQL* Plus, Toad, ASP and HTML, C++

RDBMS: Oracle 7.x/8.x/9i/10g, MS Access, SQL Server 7/2000

Data Modeling Tools ErWin

OLAP Tools: Crystal Reports 10/ 9.0/8.5, Business Objects XIR3 / R2,

6.0

Web Servers Apache 2.x, Tomcat 5.x/ 4.x, IIS

Project Management tools: MSOffice, MS Power Point, MS Project

Educational Qualifications:

. Masters in Technology - IIT Bombay, India

. Bachelor of Engineering

Professional Experience:

Reporting Analyst Jan 2009 to June

2010

Electronic Arts (Redwood City, CA)

Product Master Data Management Reporting (P-MDMR)

Description:

Electronic Arts Inc. is a leading global interactive entertainment software

company. EA develops, publishes, and distributes interactive software

worldwide for video game systems, personal computers, wireless devices and

the Internet.

EA replaced its legacy product definition and planning systems with a MDM

solution, which is expected to aid better product definition and data

governance.

. Coordinated and collaborated with business stakeholders to gather,

analyze and document business requirements, business questions, report

specifications and fact qualifier matrix.

. Worked with end users to capture analytical needs, document the

business metadata requirement and worked with Business Objects

Designer to design and test multiple universes for reports and ad-hoc

query.

. Assisted in dimensional data modeling for enterprise data warehouse.

. Involved in designing the data model for the MDM application,

integrated and historical data stores (ODS and EDW)

. Designed and developed the framework for dashboard and operational

reporting which

resulted in accurate product planning by top management.

. Used Business Objects in creating canned reports as well as dashboards

that helped analyze trends and dashboards that reported data quality

over a period of time in different cross tab and visual formats like

charts, bar graphs, pie charts etc.

. Testing and deploying BO reports

. Project was delivered on time and on budget and was very well

appreciated by senior management.

Environment: Business Objects XI R3, Oracle 10g, Erwin 7, Informatica

8.1, Linux, XML

Business Analyst June 2007 to Dec

2008

Sprint, Herndon VA,

XOHM Business Intelligence Data Warehouse & Reporting (XDW)

Description: XDW was the Data Warehouse group of Sprint Wimax division

which developed a Business Intelligence (BI) and Data Warehouse reporting

system for the 4th generation wireless communication system(XOHM). XDW

captured data elements from various Sprint and third party systems like

XOHM Portal Webserver logs, Inventory (OMIM), Point of Sale (iRMS), DCS,

AMDOCS and BrightPoint.

Responsibilities:

. Gathered and documented business, system and reporting requirements

from several business units like Sales & Marketing, Customer

Management and Finance

. Worked with business users to develop comprehensive report templates

in XL

. Worked with source system experts to explain reporting requirements

and obtain staging data for the Data warehouse

. Mapped business and report requirements to data elements in systems

containing over 30,000 tables e.g. AMDOCS

. Designed database structures for the BI warehouse which integrated

data from multiple data sources. Wrote lots of PL/SQL procedures to

pull data from various sources with necessary transformations and

cleansing.

. Involved in designing Star schema models for each single fact, multi-

dimension tables.

. Involved in Designing phase which consisted of an overall context

describing the data mart solution. The designing phase consisted of

different system schema design including the mapping of source data to

elements within schema, the business objects XI universe design, which

describes the view of data seen by user when using the tool to run

reports and build new reports.

. Developed advanced Business Objects reports with BOXI R2 to satisfy

the business needs.

. Created canned reports for Sprint executive team that had complex

measures with complex logic behind it, especially the Month to Date

XOHM Activity Report which had Ending period activations, Beginning

period activations, Churn, False churn, raw deactivations, Gross Adds

etc.

. Publishing the reports in Business Objects for auto delivery to users.

. Defined and documented reports and dashboards, with key performance

indicators and user interactive features, for implementation in the

Business Objects automated reporting system.

. Created reports with Crystal Excelcius

. Produced documentation for business procedures, data dictionaries and

a business glossary.

. Conducted interviews and application development meetings with

technical staff and business users.

Environment: Windows 2000, Business Objects XI R2, Crystal Excelcius,

Oracle 10g, PL/SQL, Microsoft Office

Analyst /Report Developer June 2005 to May 2007

Sprint, Reston VA

OE Reporting

Description: The Order Entry Reporting System was built to support the

reporting needs of marketing management executives and sales supporting

team. This system provided a single point of access to order entry data

consolidated from a number of source systems, (i.e. TOES, FAST, Web Sales

and OVM) on a daily basis. These data sources provided data for sales

orders through the telemarketing channel, order entry fulfillment and

activation data, online order data from online authorized representatives

like Amazon and Inphonic etc.

Responsibilities

. Study the existing system, analyze the existing reports and support

the user requirements

. Created complex reports with sub reports, parameters, drill down,

graphical reports, cross tabs, dynamic grouping reports

. Created complex reports using stored procedures Views, Info queries

. Maintained / Modified the procedures to keep in sync with the new

release changes

. Created monthly files for sales support team with the data needed for

the Marketing

. Created reports for IWS Team, which supported the sales on WEB

. Published reports in Crystal enterprise using crystal publishing

Wizard.

. Customized e-portfolio to the client specifications.

. Used Crystal Management Console to administer the system.

. Maintained the servers

. Administered Crystal Enterprise (activitied included creating users,

user groups, giving access to the users folders and Production support

24/7)

. Created online reports and tuned the reports with out affecting the

production system performance.

. Prepared documents for reports with Column mappings to the Business

rules.

. Created admin level crystal reports from SQL Server to monitor

pending, failed or running instances.

. Created dump/Monthly files for sales support team with the data needed

for the Marketing needs.

. Wrote stored procedures to load data from LDAP serves using DBMS

Packages

. Mentored the new hires on business requirements and the existing

system

Environment: Windows 2000, Crystal Reports 8.5, Java, Oracle 8.1.7, SQL

Server 2000, Microsoft Office

Analyst

NEXTEL Communications, Herndon, VA Sept 2004 to May 2005

OSS Reporting

Description : The Business owners wanted to analyze reports on key metrics

to gauge system performance parameters like uptime and downtime statistics,

performance and efficiency of the systems, understand the reason for the

bad / good performance of the production systems and trigger alerts or

flags on the performance of the applications.

Responsibilities

. Created Crystal Reports, for daily, weekly and monthly requirements.

These reports represented the status of tickets, sales figures, hits,

usage etc. that were used by upper management

. Created, maintained and enhanced reports on Vantive ticketing system

. Gathered key metrics from several application teams

. Analyzed the data and compiled them to show on the report

. Created, maintained and enhanced PL/SQL procedures that were used to

load the reporting tables on a daily basis

. Created, maintained and enhanced reports used by the Project planning

group e.g. 'Project release schedule report for 30, 60, 90 days',

'Projects due this month' etc.

. Scheduled the Crystal reports in Crystal Enterprise for distribution

and maintained the reports.

Environment: Windows 2000, Crystal Reports 8.5, Java, Oracle 8.1.7, SQL

Server 2000, Microsoft Office

Consultant July 2003 to August 2004

Constellation Energy Group, Baltimore, MD

Business Reporting System

Project 1

Description: The objective was to develop a single reporting system from

data sources at various locations of CEG - a fortune 200 company. This

Reporting System helped CEG's Marketing and Sales department in the

decision making process, tracking the progress, generate KPIs and taking

corrective actions.

Responsibilities:

. Worked with Marketing and Finance departments to gather requirements

. Created Crystal Reports, that would facilitate decision making

. Created Contract Reports that would be called from a jsp application.

Compiled jsp code that would instantiate the Crystal Reports Viewer

and display the report in PDF format. The parameters were passed as

variables from the jsp page directly

. Worked directly with the upper management in Sales and Marketing, in

the process of building a single repository (datawarehouse) for all

their reporting needs

. Created and documented logical data models that would consolidate the

different data sources like Oracle, SQL Server and Access

. Created 'Usage and hits', 'Daily Tracking' and 'Energy consumption by

Customers' among other reports using complex custom SQL and by using

Stored procedures

. Created cross-tabs and drill reports for the upper management

Environment - Crystal Reports 10.0, Oracle 8.1.7, SQL Server 2000, MS-

Access

Project 2

Description: Work with the clients to integrate and enhance reports for

the on-line applications.

Responsibilities:

. Developed requirements and detailed documentation to produce reports.

Communicated effectively for requirements and reports testing with the

end users and programmers to integrate reports in applications.

. Communicated with the Database team and other programmers to guide

them with the reports integration to implement Crystal reports in web

based applications.

. Designed Crystal Reports using Crystal Reports version 10.0

. Used SQL, T-SQL to develop Views, Stored Procedures and Functions.

Environment: Windows 2000, Crystal Reports 10.0, Java, SQL Server 2000,

SQL, T-SQL etc

Contact this candidate