PARUL SHER

Local Address

***** ** **** **

Email: acfi3h@r.postjobfree.com

Redmond WA - 98052

USA

Phone: 617-***-****

Summary:

. Accomplished Data Warehouse and BI professional with a proven

expertise in ETL, BI and DBA.

. More than 9+ years of total software experience.

. Extensive experience in building and maintaining data and reports in

Retail, Healthcare, Pharmaceuticals, Financial, Manufacturing,

Telecommunications and Software industry.

. Experience with SAP FI, oracle financials and HRMS, QAD EE, PeopleSoft

and Seibel. Reported off the views created on oracle HRMS system.

. Proficient in all phases of Data warehousing concepts. Experience with

Dimensional modeling, like Star Join Schema, Snowflake Schema, FACT,

Dimension Tables and logical/Physical data modeling using ERWIN.

. Expertise in SQL, PL/SQL and Dynamic SQL for stored procedures.

. Excellent knowledge of Data Analysis & Report Building

. Proficient in designing complex reports using Conditional Prompts,

Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards and

Drill-Through Reports.

. Experience in creating scripts to refresh the cubes and automating the

process using TIDAL and command Center.

. Experience in Cognos Administration like setting up Security access to

clients using Access Manager, Setting up Users, Groups, Roles, Data

Source Connection, Content Administration, Dispatchers and Services

and Deployment of content from Development to Production Servers.

. Extensive experience in cognos security and external security like

LDAP, AD and OAM.

. Extensive experience with Data warehousing and ETL concepts

. Extensive experience in performance tuning in database (oracle)

and framework manager to enhance the report performance.

. Experience in developing SDK applications using Java for execution and

extraction of reports and upgrading the reportnet 1.1 SDK applications

to cognos 8 SDK applications.

. Extensive domain knowledge around Budgeting, Forecasting and Planning

Business Process.

. Expert in creating cooperate level Dashboard for better visibility of

overall metrics affecting the performance. Used Cognos NOW to provide

real time continuous monitoring of operational metrics and KPIs (Key

Performance Metrics)

. Effective Team Player with excellent analytical, programming, written

and verbal communication skills.

. Excellent interpersonal and technical skills with a sharp acumen

for understanding and grasping of the various needs of

businesses.

Technical skills :

. Languages: C, C++, Pascal, JAVA, SQL, HTML, DHTML, CSS, PHP,

PERL, JavaScript, XML, XLS, NetLogo, MS Visual Basic,VB.NET,

Flash, shell scripting

. Networking: Socket programming, LAN, WAN

. Platforms: Windows (9x, NT, 2000, XP), UNIX, MS-DOS, HP-UX,

SOLARIS, LINUX.

. Database: mySQL, Oracle9i, Oracle 10g, Teradata, MS SQL server

2000, Access

. Applications: Microsoft (cc: Word/Excel/PowerPoint), Adobe

Photoshop, J2SE, J2EE, JSDK 1.4, EJB, Servlets, Hibenate, JSP

Struts J2EE, portlets (JSR 168, JSR 286, WSRP), Swing (Java),

ClearCase, ClearQuest.

. Network Management Tools: eHealth, CISCO WAN Manager, Unicenter,

UAM, USD, URC.

. IDEs: Win Runner, Visual Studio 6.0, Netbeans 5.0

. ETL Tool: INFORMATICA 7.0, Oracle Warehouse Builder, Design

Stream.

. ERP Solutions: Oracle apps, QAD, SAP

. Reporting and BI tools: COGNOS 10

. Planning Tools: Cognos TM1 10.2

. Scheduling Tool: TIDAL, Command Center

. Web servers: Apache, IIS 6,7

Certifications:

. Cognos ReportNet 1.1 certification.

. Cognos 8 BI - Content Administration

. Cognos 8 BI - Server Administration

. PowerPlay OLAP Modeling for Series 7 Version 3 & Cognos 8 BI

. Cognos 8 BI - Authoring and Modeling

. Cognos 8.3 Contributor Application Administrator

. Cognos 8.3 Analyst Model Building

. IBM cognos TM1 9.5.2 Design and Develop Models

. Business Analyst certification from BOSTON UNIVERSITY.

Awards and Recognition:

. GFS Customer Award in recognition of Cognos 10 upgrade (Planning and

Forecasting) in Amazon.com

. Data Architect of the month in GFS.

. STAR award in Millennium Pharmaceuticals for accomplishing the

milestones before the time limits.

Work Experience

Amazon.com, Seattle WA (September 2010 -

Present) Position: Sr. Cognos developer/BI Lead

Worked as BI lead in Global Financial Systems (GFS), an IT organization

under amazon responsible to cater Finance. Created and managed a BI

platform for Finance, Gift Cards, Oracle Financial Applications and Finance

Planning and Analysis (FP&A). FP&A system is responsible to quarterly

results and guidelines for amazon.com.

Environment: Oracle 10g/11g, SQL, PL/SQL, TOAD, Netezza, Informatica 9.5,T-

SQL, Cognos 10 BI, Cognos 10 Planning, TM1 10.2, Cognos command center,

CDM, CAF 10.2, TM1 Perspectives, SunOne LDAP, Veritas Netbackup, SCOM,

OBIEE, Tableau 8.2, Motio CI, Motio PI, PRTG.

Responsibilities:

. Provided architecture, design and support for Cognos BI, EP (including

TM1), OBIEE and Tableau platforms as per the best practices (with

active failovers).

. Performed capacity planning and deployed Cognos 10.2.1 BI and TM1 10.2

on Linux and windows (distributed environment).

. Created Business Requirement Documents (BRDs), Functional Requirement

Documents (FRDs) and Technical Design documents for Cognos BI and TM1.

. Created DR documents for Cognos (Local and Regional DR).

. Created Cognos models and packages using framework manager.

. Create complex reports (with drill down and slice and dice

functionality) in Cognos using reports studio, query studio and

analysis studio.

. Created Cognos BI dashboards and active reports.

. Configured CAF 10.2 by creating a TM1 application server and created

reports using TM1 as data source.

. Validated report data by running SQL queries in oracle.

. Created alerts and monitored Cognos BI and TM1 URLs using PRTG.

. Used Netezza as a data source for Cognos BI reports for better

performance.

. Implemented Cognos Disclosure Management (CDM) with SQL server to

store the objects.

. Created dynamic reports and dashboards in MS word using CDM for oracle

and excel data sources. Checked in the reports and dashboard to cognos

connection to others to view and edit. Updated the reporting package

and refreshed the reports in the word documents.

. Imported and refreshed reports in MS word through CDM for users to get

dynamic up to date results.

. Created and managed the object workflow in CDM to track progress.

. Worked extensively with BI Dynamic cubes, TM1 Operations console, TM1

Web, TM1 applications server, TM1 Perspectives, command center and

CDM)

. Created TI processes and chores in TM1.

. Created reports and dashboards in Tableau desktop and published them

to the server.

. Lead a team of 3 developers to create ETLs for new geographies: Europe

and Japan.

. Arranged meetings with the stake holders to understand their

requirements and created a project plan with milestones.

. Created ETLs using informatica to load data from source Oracle

Financial R12 (OFA) into the financial data warehouse.

. Created ETLs based on POS business systems logic.

. Created a POC for POS system using Hadoop MapReduce.

. Designed metadata models for reports.

. Developed dashboards representing forecasted numbers vs the actuals.

. Troubleshot the day to day challenges involved with the software

performance and environment anomalies.

. Worked with FP&A to build Cognos packages and canned reports.

. Created capex and opex cubes in TM1 using feeders and TI processes.

. Installed Motio CI and used for version control and prod promotion.

Executed queries on CM through Motio PI.

Blue Cross Blue Shield Association, Chicago IL

(March 2010 - August 2010)

Position: Sr. Data warehouse developer/Software Engineer II

BCBSA is the central organization behind the various 39 BCBS organizations

covering over 100 million Americans. BCBSA has a system called NRS which

allows plans to request reports in order to get a better idea about the

various healthcare professionals and organizations around their area. This

helps them to get insurance contracts in their areas from commercial and

non-commercial organizations.

Environment: Oracle 9i/10g, PL/SQL, DB2, clearcase, Cognos 8.4, Framework

Manager, Power Play, Cognos 8 Planning 8.4 Analyst, 8.4 Contributor, TIDAL,

websphere, informatica.

Responsibilities:

. Successfully upgraded ReportNet 1.1 to Cognos 8.4.

. Successfully fixed formatting, data and other issues related to the

upgrade (mostly in Report Studio, Framework Manager). This included

some underlying model changes.

. Created Cognos go dashboards for business users.

. Designed the data warehouse for NRS in oracle.

. Created ETL mappings using Informatica and PL SQL to load data from

ODS to the staging area of data warehouse and to the fact and

dimension tables.

. Involved in the unit testing prior to giving the code to QA.

Medtronic, Redmond WA (September

2009 - March 2010)

Position: Sr. IT BI Analyst

Medtronic decided to move from CorVu to cognos 8.4. So the project involved

creating the data warehouse in SQL server for cognos and creating models

and packages through Framework manager where the data source is in SAP.

Environment: Oracle 9i/10g, SQL Server 2005, T-SQL, Progress, Cognos 8.4,

Framework Manager, Impromptu, Power Play, Cognos 8 Planning 8.4 Analyst,

8.4 Contributor, TIDAL, SAP, QAD EE, QAD transformer, informatica.

Responsibilities:

. Successfully installed and configured cognos on Prod environment

(Distributed installation)

. Served as cognos administrator for creating user security. Also

created object, package and data level security.

. Integrated SAP with cognos for reporting.

. Worked Extensively on Data Warehouse Workbench and customized info

objects, info cubes, DSOs, Data Sources, DTPs, Transformations and

multiproviders

. Designed the data warehouse for cognos models. Populated the data

warehouse using SAP supply chain management scripts and informatica.

. Designed and created FM models and published packages for shipments

reports and Sales Datamart for finance.

. Created complex finance reports using HTML and javascript.

. Created a number of sophisticated Data Transformation Services (DTS)

in T-SQL and VBScript in SQL Server

. Served as subject matter expert (SME) for reporting (cognos) and ETL.

. Created ETL scripts using progress 4-GL language to load the data in

the datawarehouse.

. Gathered business requirements and converted them into the design

specs.

Millennium Pharmaceuticals Inc., a Takeda Oncology Company, Cambridge MA

(April 2006 -

August 2009)

Position: Software Engineer

Millennium Pharmaceuticals Inc. a subsidiary of Takeda Pharmaceutical Ltd

Japan is a leading pharmaceutical company specializing in oncology. Their

product "VELCADE" is a blockbuster billion dollar drug.

The job position involves working with the data warehouse and BI for the

sales of VECADE. The reports and cubes mainly involve sales analysis and

reporting. The company moved from reportnet 1.1 to cognos 8 in jan 2008.

Involved in the administration of cognos 7.3 and cognos 8.3/8.4. A major

milestone was to troubleshoot and enhance the current reports, cubes and

catalogs. Most of the reports were migrated from impromptu,reportnet 1.1 to

cognos 8. Most of the powerplay reports were converted to analysis studio.

The job required administering and supporting the application on a daily

basis.

Environment: Oracle 9i, Oracle 10g, SQL server 2005, T-SQL, ReportNet 1.1

MR3, Cognos 8.4, Framework Manager, Impromptu, Power Play, Cognos 8

Planning 8.4 Analyst, Cognos 8 Planning 8.4 Contributor, TIDAL, Design

Stream, MDM.

Responsibilities:

. Created calls/sales cube in transformer 8.4. Integrated sales and

calls data in the cube.

. Created models and published packages to be used for report building.

. Upgrading reports from ReportNet 1.1 MR3 to Cognos8.4.

. Modified the existing sales reports through report studio. Created

specs and SDLC documentation for them. Tested the data by querying the

database and/or by the cubes.

. Used HTML and javascript to creat complex weekly sales reports.

. Converted business requirements into design artifacts.

. Recreated PowerPlay reports in Analysis Studio.

. Performed dry runs for the cognos8 qualification purpose.

. Updated the CRN 1.1 SDK to cognos8.4 SDK and scheduled the SDK to run

through TIDAL.

. Published reports and cubes to the portal for the sales reps.

. Created sophisticated SQL Server 2005 complex queries (T-SQL, DTS,

triggers, stored procedures, functions, optimization) and .NET data

access components

. Created scripts to refresh the cubes to schedule them through TIDAL.

. Created users in Access Manager and assigned the corresponding access

to them.

. Created security to users thorough Cognos connections.

. Installed Cognos in a single server environment.

. Created security in cubes so that the sales reps can see data only for

their respective territories.

. Worked with the users to resolve their application and data related

issues.

. Created incident and change control requests (rfc) through remedy.

. Modified the current sales cubes to include data for expanded sales

force and added new date categories under the date dimension.

. Created reports by joining two queries.

. Assisted in redesigning the data warehouse and migrated the Customer

Master (CM) to Siperian's MDM.

. Created/modified/enhanced D-Lists, D-cubes and D-Links in Cognos

Planning Analyst. Used macros to automate the tasks.

. Enhanced the report performance by performing database tuning and

optimization in (FM) framework manager.

. Determine correct calculation for forecasting year-end and monthly-end

headcounts.

. Created cognos NOW real time continues monitoring the KPIs using

Dashboards.

. Created and administered Cognos Planning Contributor applications.

. Created CGP (Corporate Giving Program) reports.

. Worked with Operational Data Store (ODS) to integrate data from

multiple sources to facilitate operation, analysis and reporting.

. Created mappings for the incremental loads for various region of

Sales.

. Developed Mappings to populate data marts using Informatica Power mart

designer. This involved using the dimension tables as lookup tables

for the keys in the fact tables.

. Created mapping to load the data from the error tables to the fact

tables.

. Created views in the database to retrieve the required fields for the

tables and filter the records as per requirements.

. Used debugger to evaluate ETL timings and optimized SQL's in mappings

to run faster.

. Workflow manager to create Workflow sessions to define mapping

sequence.

. Optimized mappings by using Aggregator, filter, Joiner, Expression,

Lookups.

. Optimized the workflows for the better performance.

. Created Unix shell scripts to automate batch jobs through cron. Some

of the jobs involved in populating or updating the dimension tables.

Computer Associates, Framingham, MA (May2005-Dec2005)

Position: Engineering Co-op.

Environment: Oracle9i, PL/SQL, UNIX, HP-UX, SOLARIS, ReportNet1.1,

Impromptu7.1, Powerplay7.1, PowerPlay transformer.

Company/Project: eHealth is a network governing application. When

deployed in the system, it gathers information from the elements of

the network and stores that in the database. This data can be then

fetched from the database and populated in the reports (Cognos). These

reports give a complete picture of the network of the system. But

before passing the data to Cognos it needs to be regularized, which is

done through stored procedures.

Responsibilities :

. Generated customized reports in COGNOS (ReportNet). This

involved creating drill-thru reports, list reports, cross tab

reports

. Developed eHealth (Firebird, Nautilus) Performance reports in Report

Studio using Prompts, Filters and Calculated Fields to generate the

required reports.

. Developed Ad-Hoc queries and complex reports using Query studio and

Report Studio.

. Created different kinds of Query Subjects (model, Sql and stored

procedure), created links and defined the relationships and

Cardinality.

. Design a Framework Model for ReportNet and created security levels on

model.

. Automated COGNOS reports using WinRunner.

. Did scripting to automate the tasks.

. Used TOAD to confirm the accuracy of the data in the reports.

. Performed database (oracle) compression studies for economic

utilization of space.

Assistantship:

. College of Business Administration, Marketing Dept. Researcher,

Northeastern University. Boston, MA

Coding in NetLogo

Jan 2006 - May 2006

Developing (coding) simulation models in NetLogo for management

research projects.

Simulated the models under different environment settings.

Education :

. Northeastern University

Boston, MA

College of Engineering

Jan 2004 - May 2006

Master of Science in Information Systems

GPA: 3.30

. University of Mumbai

Mumbai, India

D.J Sanghvi College of Engineering

Sept 1998 - July 2002

Bachelor of Science in Chemical Engineering

GPA: 3.5

Interests:

. Sports: Tennis (for University), Table Tennis (for

College), Badminton, Cricket, Roller Blading.

. Others: Debating, Dramatics, Public Speaking, Hosting

public events.

Contact this candidate