Manager Data

Sapna Joshi

Cognos Developer

Email: *****.********@*****.***

Ph: 848-***-****

Responsibilities:

Over 8 years of IT Experience with 6 years in development, maintenance and support of BI applications using Cognos 8 and Cognos 10.

Excellent Business Analysis capabilities and skilled in gathering end user requirements.

Experienced in using various Cognos tools such as Cognos 10.2 BI, Cognos 8 BI, (Framework Manager, Report studio, Query studio, Analysis studio, Event Studio, Data manager, Cognos Connection, PowerPlay Studio and Transformer).

Experience in designing, developing and integrating functional executive Dashboards using Tableau desktop and Server enabling easy interpretation of Portfolio Status, Workflow Analysis and actions etc.

Experience extracting, loading data from multiple source in Qlikview. Creating Dashboards and Visualization for Data discovery.

Experience in installing and managing Cognos application on Windows, UNIX and Linux.

Experienced in generating several complex reports using Report studio, Query Studio and Analysis Studio in Cognos 8 & 10 Environment.

Hands on experience in Cognos Administration like creating user groups and roles, Deployments, Creating data sources, Managing Configuration settings, performance management etc.

Experience in creating models and implementing security using User Groups and Roles.

Experience in creating IQD’s in Framework Manager to use in Cognos Transformer.

Experienced in creating reports based on DMR and OLAP sources using MDX queries.

Experienced working with ETL tools Informatica Powercenter and Data Manager.

Creating user authentications and authorizations to apply security on Cognos content using Cognos connection.

Expertise in OLTP/OLAP schema, designing/developing Star Schema and Snowflake Schema used in relational, dimensional modeling.

Experience with complete SDLC methodology.

Extensive experience with relational databases like MS SQL server, Teradata, DB2 and Oracle.

Experience in writing and working with complex SQL queries to validate data and for data analysis.

Excellent communication, organizational and problem solving skills and ability to work individually or in a group.

EDUCATION

B.S. from Jawaharlal Nehru Technological University (JNTU) in Jun 2008.

TECHNICAL SKILLS

BI Tools: Cognos 11/10.2/8 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Studio, Transformers), Qlikview, Tableau.

Operating Systems: Windows 2012/7, UNIX and Linux.

Languages: SQL, PL/SQL, C, C++, Java, VB, VB.Net.

Databases: Oracle 11g/10g, MS Access, SQL Server 2008/2012, Teradata, DB2.

Other: MS-Office, Adobe Photoshop, Adobe Acrobat.

PROFESSIONAL EXPERIENCE

Bancroft, Mt Laurel NJ Jul 2015 to Present

Cognos BI Developer

Responsibilities:

Gathering and analyzing business requirements from users and analysts.

Creating requirements documents, Design documents, Use case scenarios etc.

Analyzing existing transactional database schemas and Data Warehouse to design star schema models for supporting reporting requirements or BI application requirements.

Generating various List Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

Generating Complex reports in Cognos 10.2 report studio including Drill Down reports and reports based on DMR and OLAP sources.

Creating Dashboards to present critical company data in a single view.

Developing solution/framework for provisioning data for consumption by business users who create Tableau reports.

Developing Tableau based ad-hoc user interfaces for end users.

Creating Dashboards and reports using Tableau.

Maintaining existing and developing Tableau code and optimizing/streamlining informational lining and feeds.

Excessively working on Reports tuning, Modification and report performance on daily basis.

Working with DBAs, ETL teams to resolve performance and data issues on a daily basis.

Distributing reports to various agents using Bursting.

Developing Framework Manager Models using best practices to ensure efficient model building and usage.

Creating DMR models to support Multi-dimensional analysis in reports.

Creating OLAP models using Transformers.

Building and Deploying Power cubes to PROD.

Modifying the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join queries in Report Studio.

Writing complex SQL queries to validate report data against the Transactional data for unit testing/system testing purposes.

Creating Sophisticated Reports and Portal page Dashboard reports by using Report Studio.

Using advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Creating reports that included functionality such as prompt pages, cascading prompts, conditional filters and conditional formatting etc.

Working on production support issues that are logged in JIRA.

Deploying reports and packages from DEV to QA/PROD environments.

Administering Cognos 10 environment by modifying configuration settings, activity monitoring and resolving Server issues.

Working on POC projects involving other technologies.

Environment:- Cognos 10.2, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, SQL Server 2012, Oracle 11g and Windows Server 2012, Tableau.

Oppenheimer Funds Inc, Denver, CO Feb 2014 to Jun 2015

Cognos Developer/Admin

Responsibilities:

Gathered and analyzed requirements from Business users and analysts.

Created requirements documents, Design documents, Use case scenarios etc.

Used advanced scripting, data modeling (star schema), worked with large data sets, and utilized multiple data sources in a Qlikview model.

Generated Complex reports in Cognos 10 report studio including Drill through reports.

Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.

Created complex SQL queries to validate report data against the Transactional data for unit testing/system testing purposes.

Excessively worked on Reports tuning, Modification and report performance on daily bases.

Worked with Data teams, infrastructure teams to resolve any issues pertaining to the BI environment.

Performed BI Content Administration tasks including scheduling, deployment and content management, user administration, security tasks and permissions, user authorization.

Responsible for Administering DEV, QA and PROD environment of Cognos BI.

Developed Relational and Dimensional (DMR modeling) models in Framework manager using the best practices.

Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects, embedded filters, Stand-alone filters, Custom Calculations etc as per the business requirements in the Framework Manager.

Created Transformer models for building powerplay cubes.

Generated IQDs from FM to use them as data source in Transformer models.

Created Dashboards using Tableau.

Extracted, loaded and merged data using Qlikview. Creating Dashboards and Analysis in Qlikview. Using scripts to manipulate data in Qlikview.

Responsible for building cubes and deploying them to QA, PROD.

Worked on all production issues for the Cognos BI environment.

Conducted user training sessions.

Environment:- Cognos 10.2 BI, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Transformer, Tableau, Qlikview, ORACLE 11g, Microsoft SQL Server 2012.

Key Bank, Philadelphia PA Oct 2012 to Jan 2014

Cognos Admin/Cognos Developer

Responsibilities:

Involved in gathering Business Requirements for Reports and Models.

Actively participated in JAD sessions for requirements gathering, planning and design of BI applications.

Worked with ETL teams, Data Architecture teams to design and create the BI solutions.

Installed and configured Cognos 10.1.1 on Windows.

Developed complex ETL mapping, transformation and workflows using Data Manager.

Managed the health of Cognos servers by monitoring the environment, execution tasks and log files.

Created FTP access to Cognos server used for deployment of cubes, Packages and reports.

Wrote reports using MDX queries and functions.

Deployed FM and cube packages from development to QA and Production.

Created user authentications and authorizations to apply security on Cognos content using Cognos connection.

Created new Cognos users groups and roles using Access Manager, LDAP.

Validated Reports in Life cycle manager and comparing them in 8.4 and 10 environments and fixing the issues in Cognos 10.

Migrated Reports, Dashboards,FM models and Transformer Models from Cognos 8.4 to Cognos 10.1.1

Tested the SQL based reports and changing the SQL to fix the issues in Cognos 10.

Wrote SQL queries to validate report data and for unit testing.

Created Dashboards and Visualization using Tableau.

Trained Business Users on how to build visualization and perform data discovery using Tableau.

Worked extensively on creating the Model using Framework Manager according to user requirements and publishing the package on Cognos Connection for reporting purposes.

Created FM models employing the best practices to make the model efficient.

Administered Cognos Environment to support Day to Day business activities.

Created filters, Calculations within the Model for improving the performance of the model.

Developed Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports Using Report Studio.

Created Query Prompts, calculations, Conditions & Filters.

Updated the existing store procedures to create reporting tables in the SQL server and update the FM model and use it to develop complex reports in the report studio.

Developed Prompt pages, Multi Page Reports and Conditional Variables.

Developed Transformer models to create powerplay cubes.

Monitored Cube updates as well as the performance of Power Play cubes.

Designed and created data visualizations (reports and dashboards) as required to support user stories.

Extracted, loaded and merged data using Qlikview. Creating Dashboards and Analyis in Qlikview. Using scripts to manipulate data in Qlikview.

Scheduled and Distributed Reports through Schedule Management in Cognos Connection.

Worked on Report Performance tuning.

Environment: Cognos 8.4, 10.1.1, Report Studio, Framework Manager, SQL server 2008, Cognos Transformer, PowerPlay Studio, Informatica Powercenter, Tableau Server and Desktop, Qlikview, Windows Server 2008

S.C. Johnson, Wisconsin Jan 2011 to Sep 2012

Cognos Developer

Roles and Responsibilities

Analyzed reporting infrastructure

Worked on requirements gathering and created design documentation.

Participated in JAD sessions for Data warehouse/BI design and requirements.

Configured Cognos Server Environment and monitored it to manage its health on daily basis.

Deployed cubes, Packages and reports to QA and PROD.

Worked with various teams to address critical issues pertaining to Cognos or Data access.

Decide on the summarized/data mart table structure to be used for various reports

Model the Cognos metadata layer for report development using Framework Manager.

Created dimensional reports using MDX.

Created Dashboard reports using MDX functions with Data source as transformer cubes and DMR packages.

Created Mapping documents for Source to Target mapping for FM design documentation.

Created SQL queries to run directly on database server for validating report output and unit testing

Involved in cube/report development activities using Report Studio and powerplay studio.

Created Trigger based scheduling for reports.

Automated various manual day to day reporting processes done using Microsoft excel.

Created inventory reports including excess and idle stock, inventory turnover, customer service rate, stock out, suppliers’ performance and critical stock items status, and provide updated reporting to clients when needed.

Creating Flow charts and diagrams using Microsoft Visio.

Performance tuning of reports in production.

Administered Cognos Environment to support day to day business activities.

Worked on Production Issues logged in HP Quality Center.

Environment: Cognos 8.4, Framework Manager, Oracle 10g, SQL Server 2008, Transformer.

Genpact (GE Financial Services), India Sep 2008 to Nov 2010

Business Analyst

Roles and Responsibilities

Gathered client requirements through interviews, workshops, and existing systems documentation and procedures.

Attended daily Stand-up, retrospective meeting, sprint workshop meeting, demo meeting and release meeting.

Work closely with the business team SME's and business users in a fast paced work environment to review, analyze and transfer high level requirements from whiteboard and convert them into functional user stories.

Created project related status reports for sharing and distributing with the target audience and project team in a timely manner.

Coordinated and lead design review sessions with different cross-functional teams from Americas and Asia-Pacific to get sign offs on the business requirements from different project stakeholders.

Independently put together presentations on project related topics for presenting to Program manager, design, testing and development team members.

Environment: MS Office, Visio, Windows 7/XP, SQL Server, HP Quality Center.

Contact this candidate