Manager Data

SARIKA SINGHAL [pic]

IBM/Cognos Certified Professional

PROFESSIONAL SUMMARY

. IBM Certified Data warehousing Professional with global 9+ Years of

Business Intelligence practice experience as Analyst, Developer &

Solution Architect.

. Implemented the long term sales reporting strategy for fund management

group.

. Converted the user stories and business case to business requirement by

conducting executive interviews, workshops, show casing demos &

prototypes.

. Experienced in developing the Financial Reporting solutions as per Basel

accords for the Credit Risk domain, Reporting Asset balances for Fund

Management Groups, Business performance reporting/analysis, Predictive

analytics, Sales matrix analysis and planning, Risk analysis & Product

performance analysis.

. Highly proficient in working with BI tools for developing Reports,

Analysis, Dashboards and

Scorecards that communicate complex information quickly and monitor

performance against

Targets using - Cognos Series 7.x, 8.x, 10 BI Suite: Report

Studio/Query Studio/Analysis

Studio/Event Studio/Workspace/ Workspace Advanced and MS SSRS 2008/2010

BI Reporting Suite (Report Builder/Report Designer).

. Expertise in building data models (relational, dimensionally modeled

relational (DMR)) using Star and Snowflake Schema. Create or revise

technical design of Cognos metadata models and development

standards/methods for BI reports and data cubes. Implementation

experience to convert complex reporting requirements into Meta-Data Model

using Framework Manager Tool.

. Expertise in building OLAP data models and publishing Power Cubes using

Cognos Transformer, Dynamic Cubes and TM1. Develop reports to supplement

the workload of Cognos development resources and to prepare prototypes

when needed to meet new and unusual requirements.

. Worked as an analyst for Extract Transform and Load (ETL) process. Also

Involved in Cognos deployment, Administration and Security Implementation

tasks.

. Worked with Cognos SQL to analyze and simplify and pushing the complexity

to database end. Expertise in implementation of performance tuning and

improvement tricks at all stages.

. Worked with HP Quality Centre and Application Life Cycle Management for

Complete mapping of requirement to test-cases and defects logging.

. Experienced in planning and implementation of the Migration projects.

. Certified for 'Cognos Certified Developer', 'Cognos Reportnet Product

User'

. Involved in knowledge transfer, developing Cognos training curriculum and

train business users. Provide technical direction to Cognos Development

and Operations resources.

. Strong analytical and problem solving skills. Team Player with the

ability to communicate effectively at all levels of the development

process.

EDUCATION

. Bachelors of Engineering (Hons.), RGPV-Bhopal, India

. CDAC (Center for Development of Advanced Computing)-Pune, India

SKILLS

Business Intelligence Tool Cognos Series 7.x & 8.x & 10 BI Suite,

MS SQL BI SSRS, Tableau

Data Warehouse/ETL Tool Data Stage PX 7.5.1, Informatica 8.6

/9.x

Databases Oracle 8.0, IBM DB2, Oracle 10g,

MS SQL Server

Languages/Tools Java Script, HTML, SQL, PL/SQL, Java Script

PROFESSIONAL EXPERIENCE

Wells Fargo, Menomonee Falls. Cognos Lead Consultant

Oct '12 - Jan '15

WFAM BRT (Business Reporting Team)- Wells Fargo Asset Management strives to

help their clients achieve their financial goals through top-tier

investment solutions managed by specialized investment teams and backed by

superior, collaborative service. Business Reporting Team is liaison between

Wells Fargo's asset management group and their IT staff. This team is

responsible for providing all levels of business metrics reporting needs

for Funds management group. Team helps providing individualized reports for

territory management, product/transaction/activity tracking, sales

commission calculations, and reviews.

. LTS Project (Long Term Sales Strategy) - To provide a dynamic process

oriented common reporting & analysis platform. Worked closely with the

business owner to understand the current state of information

availability in the enterprise and then identify future needs based

the analysis of business requirements, current state environments, gap

analysis, and future state warehousing implementation.

. Collaborated with business to define the business requirement by

conducting executive interviews, workshops, show casing demos &

prototypes.

. Defined high-level designs including logical models and functional

specification documents, these document became the base line for

development.

. Developed wireframes and prototypes for the ease of understanding of

the implementation strategies.

. Developed and Published Packages in Framework Manager - Designing the

strategies using Reporting requirements and available data, Connecting

and testing the data source, created database layer, Business Logic

layer and presentation layer, defining appropriate relationship

between query subjects, created star schema groupings, maintaining

conformity between all the star schemas.

. Developed interactive Dashboards using in-report prompts and advanced

visualizations.

. Developed Multi-dimensional and multi-source Cubes for Mutual Funds

measures and tracking activity to be used in Analysis

Studio. Implemented Time-Based Partitioning and dimension based auto-

partitioning for performance improvement and optimization.

. Developed dimensional reports using multidimensional data sources

(Cubes and DMR) in Report Studio. Also implemented various levels for

searching techniques for large amount of data. Carried out report

bursting for services group to streamline report delivery process.

Used Report studio/Analysis Studio to connect cube sources. Created

multi-pages report and used different report output formats to

distribute the data.

. Developed complex Reports using different features like slice & dice,

Drill capabilities, queries, Master detail and cross tab tables with

multiple breaks. Developed reports involving dynamic sorting, Drill-

Through, multiple Conditional blocks and Conditional Variables,

Prompts, Page Sets, Joins, Union and Filters.

. Developed interactive Dashboards using Cognos Report Studio,

WorkSpace, WorkSpace Advanced and Active Reports.

. Developed and Tested Dynamic Cubes and Dynamic Query Mode enabled

Framework Packages for Enhanced Performance improvement and self-serve

BI Implementation . Used Aggregate Advisors and Dynamic Query Analyzer

tools for better understanding of the performance enhancement

techniques of Cognos 10.2.

. Experienced in writing complex SQL Queries, Stored Procedures,

Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User

Defined Functions to implement.

. Involved in writing the complex SQL statements for creation and changes

in databases.

. Worked with all kinds of joins in SQL (Self Join, Inner, and Outer Joins)

for complex queries involving multiple tables.

. Recommended and designed summary tables to be used in reports to

optimize performance.

. Actively worked with the BI team and Business to transition the

application into Production Environment by providing support and

training through the release cycle.

. Developed test cases and code migration / change management procedures

and follow up to ensure completeness and quality of the BI development

and business user satisfaction.

. Wrote SQL scripts and developed audit reports to compare warehouse

data with the staging and source data.

Environment: COGNOS BI 10 (Transformer, Framework Manager, Report Studio,

Query Studio, Analysis Studio, Cognos WorkSpace & Workspace Advanced), SQL,

HP Application LifeCycle Management, MS Office, Windows XP

First Financial Credit Union, CA Cognos Consultant Sept '11 - Oct

'12

ACR (Advanced Contact Routing) - Advanced Contact Routing engine (CR) is

the process that takes contact requests, from both telephone and web

contacts, and then finds a suitably skilled and available agent. CR

provides the centralized processing to match contact routing requests to

available agents. It records all agent activities. Also provides the whole

idea of the application in terms of request analysis and customer

satisfaction too. It was end to end application starting from designing of

tables, ETL job processing and generating reports.

. Actively participated in analysis and requirement gathering

activities. Developed prototype and proof-of-concepts for ease of

understanding of the implementation strategies.

. Developed metadata models Framework Modeling tool with different data

sources using Star and Snowflake schema groupings, Parameter Maps,

Native SQL implementations. Security implementation data and package

level.

. Designed and implemented data cubes using Cognos PowerPlay transformer

to facilitate executive, management and end user reporting.

. Built Reports using Report studio, Query studio and Analysis studio.

. Developed highly complex reports involving dynamic sorting, Drill-

Through, multiple Conditional blocks and Conditional Variables,

Prompts, Page Sets, Joins, Union and Filters.

. Used JavaScript, Conditional Formatting etc. to meet the user's unique

reporting needs.

. Worked on crosstab and chart reports including prompt controls.

. Performed administration and Deployment of Cognos Content from DEV -

QA - PROD.

. Developed QA test scripts and code migration / change management

procedures and follow up to ensure completeness and quality of the BI

development and business user satisfaction.

. Used ETL manager for scheduling of scripts to load data.

. Worked with writing Complex SQL statements for testing the data as

generated by Cognos Reports.

. Worked of informatica technical design for ETL & Datamart,

implemented/modified mapping & sessions for data warehouse by

extracting data from CRM system and Dialer database.

. Created timer & event waits. Worked on workflows using task developers

& workflow designers.

. Supported the ETL production process using workflow monitors.

Scheduling Jobs via Autosys.

Environment: COGNOS BI 10 (Framework Manager, Report Studio, Query Studio),

Informatica 8.6, DB2 SQL, CA - Autosys, HP Quality Center, MS Office,

Windows XP

HSBC Technology Services UK/India, Sr. Software Engineer Dec '07

- May'11

HSBC HTS is a development center offering to its client i.e. HSBC Group

around the globe a wide array of development options and end-to-end

solutions. I was involved into the development work in 'Gleam' Project for

one of the company's main clients, HTSE and HTSA.HTSE and HTSA (HSBC

Technology Services Europe/America) have BI teams specifically responsible

for the delivery of end user solutions covering all aspects of BI reporting

and ad hoc query and analysis.

Group Limit Exposure Activity Management (GLEAM) is a Flagship Project for

HSBC Group. GLEAM system is intended to facilitate the promotion of

consistency and best practice across the Group companies through the

adoption of common strategic systems and processes. In addition it is to

support any new reporting requirements from the current deliberations of

the Basel Committee on banking supervision. Automated and consistent Group-

wide credit reporting based on actual exposures and commitments. Provide a

single view of the larger corporate, bank and sovereign customers. Provide

reconciliation between credit and finance data and ensure credit data can

be used for regulatory capital reporting under Basel I, II and III.

. Involved in modeling of reporting data mart which was built from Gleam

Data Warehouse in a report-driven approach, considering aspects as

Granularity, Normalization and Performance of reports - This data mart

was updated monthly from the DW.

. Also involved in managing group of people and leading them for

development and management activities, training, assigning tasks,

making task plans and weekly and monthly status reports.

. Built Financial Reports specific PowerCubes Implemented security using

Custom Views.

. Created several Dashboards to showcase the Statistics using several

views quickly.

. Developed central modeling Layer (Framework Model) with Star and

Snowflake schema groupings, Parameter Maps for enhanced performance

.Implemented macros to build the dynamic string to enforce dynamic

behaviors.

. Used Native SQLs and PL/SQLs in Framework Manager to achieve the

results required by the business.

. Performed Deployment of Cognos Content from DEV to PROD, Job

Scheduling, Folder Security, and Framework Object Level Security.

. Developed highly complex reports involving dynamic selection based

sorting, Drill-Through, multiple Conditional blocks and Conditional

Variables, select and search prompts with multiple options, prompt

pages.

. Used JavaScript, Conditional Formatting and rendering etc. to meet the

user's unique reporting needs.

. Worked on migration and upgrade of the content from various Cognos

environments and Versions starting from Reportnet to Cognos 10.Put

together upgrade plan and testing strategy documentation from

successful upgrade. Also helped team and users to get familiar with

the upgraded features.

. Used TM1 to set up the multidimensional database for GMO. Turbo

Integrator was used to create dimensions and populate with data from

relational data sources and CSVs.

. Integrated TM1 and Cognos 8 BI Reporting applications.

. Designed rules using TM1 Rule Editor.

. Developed Metadata repository (.rpd), configured metadata the Business

Model Layer & Physical Data Model and Web Catalog Objects as per the

reporting requirements using OBIEE

. Admin and web tool.

. Worked on Oracle BI Answers to build Interactive dashboard with

drilldown capabilities.

. Created templates for presenting results and Analytics and modified

the OBIEE Dashboard using cascading style sheet.

. Used Datastage for leading the end-to-end design, development, testing

and execution of the process to transform and load data and meta data

into the Enterprise Data Warehouse, ODS and/or data marts.

. Developed QA test scripts (SQL statements for data matches) and code

migration / change management procedures and follow up to ensure

completeness and quality of the BI development and business user

satisfaction.

. Used MQTs for performance improvement of the reports using DB2 SQL.

Environment: COGNOS BI 10, 8.4 (Framework Manager, Transformer, Report

Studio, Query Studio, PowerPlay Studio, Analysis Studio),TM1, DB2 SQL,

PL/SQL, OBIEE 10.1.3.4, Oracle10g, Oracle SQL,HP Quality Center, MKS, MS

Office, Windows XP

HSBC Technology Services, UK/India Sr. Software Engineer,

April '06 - Nov '07

UK BI Delivery Project is a suit of multiple sub projects, which are from

Data Warehousing domain. It includes Predefined reports from multiple Data

Marts. These Data Marts have been developed for different requirements. FVQ

(Folder, View and Queue) -In late 2005 BI created a reporting package to

assist Service centers to monitor operator performance by tracking and

reporting the time and frequency to process work memos from work queues.

The queues are lists of work requests to undertake a particular type of

task. The application was end-to-end starting from designing of new tables,

ETL job processing and generating reports. There were also enhancements to

existing reports.

. Gathered and understand business requirements and translate into

Cognos Reports using using Report studio and query studio.

. Involved in full development cycle within Cognos reporting framework

from developing the business requirement, data modeling, report

writing, quality assurance testing to production deployment.

. Implemented metadata using Framework Modeling tool with data and

object level security.

. Created Insight portal using SDK for accessing the report.

. Performed Deployment of Cognos Content from DEV to PROD

. Developed Reports involving Crosstabs, Drill-Through, Conditional

Rendering and Conditional Variables, Prompts, Query Joins, Drill-

Through, PDFs, Master-Detail Relatonships.

. Delivered reports with high level of graphic elements including

charts.

. Developed QA test scripts and Report Views for concurrent and

regression testing.

. Documentation and support provided to ensure completeness and quality

of the BI development and business user satisfaction.

. Worked with writing Complex SQL statements for testing the data as

generated by Cognos Reports.

Environment: COGNOS BI 8 (Framework Manager, Report Studio, Query Studio),

DB2 SQL, MKS, MS Office, Windows XP

Contact this candidate