Manager Sales
Resume:
Shailin Shah
***********@*****.***
SUMMARY
Software professional more than 4 years experience in various parts of the
SDLC experience as a Cognos Developer developing effective Business
Intelligence (BI) & Data warehousing solutions to facilitate business
decisions. Extensive experience in Architecting, Data modeling (reporting
and OLAP Cubes) with Cognos BI Tools including Cognos EP Series
8.x/7.x,Cognos,Cognos 8.x/Report Net 1.1 (Report Studio & Query Studio,
Cognos Framework manager). Self motivated, creative, work with minimal
supervision, debugging and crisis management. Excellent interpersonal and
oral and verbal communication skills.
. Experience installing Cognos 8 BI and architecting and delivering data
warehousing using Cognos 8 BI suite.
. Multidimensional and Relational modeling in Framework manager.
. Experience migrating legacy systems and other low end BI tools to Cognos
8.
. Design of complex reports in Report Studio and Design of Adhoc reports in
Query Studio.
. Created, modeled and published packages in Framework Manager from
multiple databases for use with Reportnet, Report Studio and Query Studio
and Analysis Studios.
. Monitor jobs with the Cognos Administrators, debug and enforce scheduled
report.
. Extensive experience with multidimensional models (OLAP) using Framework
Manager and Power Play Transformer and Cognos Analyst.
. Experience in understanding the business requirements and designing
Cognos applications.
. Planned and constructed OLAP Power Play Transformer OLAP/CUBE 7.3/6.0 for
Data modeling of the corporate Data for building multi dimensional cubes.
. Worked extensively with the Metadata Modeling utilizing Framework
Manager.
. Expertise in design and development of highly complex query reports
including Dash board reports.
. Expertise with Framework Manager, Cognos BI 8.4/8.3/8.2/8.1/8.0/CRN,
Cognos Connection, Report Studio, and Query Studio, Metric Studio and
Analysis Studio.
. Implemented Security at different levels in Framework Manager and Cognos
Connection to restrict access.
. Supporting cubes on weekly basis with verifying the sales with SAP Globe.
. Suggest ETL changes to enhance data integrity and data warehouse
reporting.
. Experience in metadata modeling including star-schema and dimensional
modeling.
. Versed with other BI tools like Business Objects, SAP BW and Hyperion
Essbase.
. Expertise in OLTP/OLAP system study, analysis and developing Database
schemas like Star Schema and Snowflake Schema.
. Recommend Cognos Enhancements, up gradation and chart the path forward.
. Extensively interacted with business users in understanding business
application, business data flow and data relations.
. Worked with Different Databases like Teradata 7.1, Oracle 8.0/8i,
9i,10g,11g,,MS-Access, MS-SQL, and PL/SQL 8.0
. Troubleshooting Cognos environments UAT.
. Testing, debugging of reports, Defect identification in Cognos and back
end databases, resolution.
TECHNICAL SKILLS
OLAP Tools Cognos Impromptu 7.0/6.2/6.0, Power Play Transformer, Power
Play for windows, Cognos BI 8.4/8.3/8.2/8.1/8.0 (Framework
Manager, Report Studio and Query Studio),TM1 9.5
Database Teradata 7.1, Oracle 7/8i/9i/10g,SQL Server 7.0/2000/2005,
DB2
Operating Systems Windows NT4/2000/XP, Solaris 2.6
Programming &ETL SQL, PL/SQL, TOAD Informatica 6.0/7.0
PROFESSIONAL EXPERIENCE
Deutsche Bank, NY
Cognos Developer
April 2009 - Oct 2010
Deutsche Bank is a leading global investment bank with a strong and
profitable private client's franchise. Its businesses are mutually
reinforcing. A leader in Germany and Europe, the bank is powerful and
growing in North America, Asia and key emerging markets. Currently working
with Cognos 8 BI on the Corporate and Investment Bank (CIB) group. CIB is
subdivided into two Corporate Divisions: Corporate Banking & Securities and
Global Transaction Banking. Corporate Banking & Securities covers Deutsche
Bank's origination, sales and trading of capital market products, corporate
advisory and corporate financing businesses, asset finance and leasing, and
commercial real estate. Global Transaction Banking covers Deutsche Bank's
trade finance, cash management and trust & securities services businesses
and serves both financial institutions and corporate clients.
Responsibilities:
Reporting
. Requirements gathering and specification writing after interfacing
with Business Users, Line of Business and Other Stake Holders.
. Interacted and interfaced with high level management to conceive and
deliver BI solutions, dashboard reports and score card structures.
. Multidimensional and Relational modeling in Framework manager.
. Designed and Developed List & Cross Tab reports, Charts, Drill through
Reports, Master Detail Reports using Report Studio. Worked on Query
Studio.
. Developed complex Dashboard reports.
. Tuned and improved the performance of the reports by optimizing SQL
generated, suggesting changes to backend schemas.
. Lead the team of Cognos administrators and developers and collaborated
with ETL, database teams to work on the development, sanitization and
optimization of data streams.
. Supporting cubes on weekly basis with verifying the sales with SAP BW
Globe.
. Resolved conflicts and provided recommendation in data modeling,
permissions issued to Cognos and ETL teams by setting up meetings
between the teams.
. Worked extensively with the Metadata Modeling utilizing Framework
Manager.
. Experienced in implementing various prompts such as cascading,
conditional, date, value based on the user's needs.
. Imported metadata from various sources such as Relational Databases,
Cognos 8.4 models.
. Create Master-Detail Relationships for reporting from multiple data
sources.
. Created Business views, namespaces, model query subjects in Framework
Manager Model for easier report development and to enhance multi user
environment.
. Testing, debugging of reports, Defect identification in Cognos and
back end databases, resolution
. Deployment of Framework Manager Packages and reports from Development
to UAT and to Production.
. Cognos Multidimensional Cube development using Cognos Power play
transformer.
. Report generation on Cognos Power play cubes.
. Worked extensively in OLTP/OLAP system study, analysis and developing
Database schemas like Star Schema and Snowflake Schema.
. Apply OLAP functionalities such as drill-down/drill-up in Analysis
Studio and Report Studio.
. Worked extensively with the ongoing support for data loading,
validation with SAP BW Tool.
. Oversee transition from Cognos 8.2 to 8.4 and Experience installing
Cognos 8 BI.
. Worked with ETL tool Informatica to change mappings and enhance data
warehouse reporting.
. Technical Design of Reports, Report bursting and Report Distribution.
. Developed complex reports, Scorecards and Job sets.
. Developed test plans, scripts and test cases for Unit, Integration,
Regression, UAT.
. Testing, debugging of reports, Defect identification in Cognos and
back end databases, resolution.
Environment: Access Manager 8.0/7.3, Cognos 8.4/8.3/8.1 (Framework Manager,
Report Studio, Query Studio, Metric Studio, Event Studio, Cognos
Connection, Power play Transformer),TM1 9.5,SAP BW/BI, MS Excel 2003,
Teradata 7.1/12.0, SQL Server 2005, Informatica 7.0, Windows XP.
Deluxe Corporation, Minneapolis, MN
Cognos Developer
Feb 2008- March 2009
Deluxe Corporation is the leading provider of personalized printed products
and services to small businesses, financial institutions, and consumers
primarily in the United States and Canada. The company operates through
three segments: Small Business Services, Financial Services, and Direct
Checks. The project was aimed at creating Cognos cubes to Segment the 9000
Financial Institutions into 15 unique segments. Cubes were also developed
to track sales, revenues and costs of 25 different new projects (financial
products). The cubes were designed in a way to facilitate unique reporting
and analysis of the data housed in the cubes.
Responsibilities:
Report Studio
. Interfaced with business users and line of business to gather
requirements and translated into specifications.
. Lead the project team giving direction and inputs to be used by
Project Owner, Cognos Developers, ETL, database teams and Cognos
administrators.
. Developed List & Cross Tab reports, Charts, Drill through Reports,
Master Detail Reports using Report Studio. Worked on Query Studio.
. Developed Dashboard reports.
. Created Prompts, and Cascading Prompts. Worked on multiple Report
pages and multiple Prompt pages.
. Framework Manager modeling with MS SQL Analysis Server Cube.
. Created reports having Filters, multiple Prompts (Select & Search
prompt, value prompt, tree prompt) and provided option of bursting of
reports.
. Worked on ETL to change existing mappings to enhance the data
warehouse and quality of data.
. Built Power play cubes using Cognos transformer.
. Developed Prompt pages and Conditional Variables.
. Experience in metadata modeling including star-schema and dimensional
modeling.
. Created New Jobs using Cognos Connection.
. Worked on Cognos Connection. Scheduled the reports.
. Merged different block objects to create desired complex report
structures.
. Documentation of all phases of development of Business Intelligence
solution.
. Developed test plans and test cases for testing new reports.
Environment: Cognos Planning 8.0/7.3 Analyst, Contributor 8.0/7.3, Access
Manager 7.3, Cognos 8.0 (Framework Manager, Report Studio, Query Studio,
Cognos Connection), TM1, SAP BW/BI, MS Excel 2003, SAP, Lotus Notes 7.0,
Oracle 9i, Informatica 6.0, Windows XP.
Lanco Group, India
Cognos Consultant
June 05 - July 06
Resource Management System is a web application for Lanco Group. This
project is used to automate the Lanco Companies day-to-day activities and
transactions. It is an Intranet based enterprise application, which
automates the process of resource management and provides better services
like stock management, and accounting. It links their activities like
office maintenance and inventory control and provides access to all of
their branches.
Responsibilities:
Reporting
. Involved in gathering Business Requirements for New models.
. Interacted with Development and Management Teams.
. Provided Technical Assistance to Developers.
. Built models using Framework Manager.
. Involved in Testing and Exploring New Tools ReportStudio and
QueryStudio.
. Developed Standard Reports, Charts, Drill Through Reports, Master
Detail Reports, Bursting Reports Using ReportStudio and QueryStudio.
. Developed Dashboard reports and Scorecard reports.
. Optimized queries.
. Created Query Prompts, calculations, Conditions & Filters.
. Developed Prompt pages and Conditional Variables.
. Created New Jobs using Cognos Connection.
. Scheduled and Distributed Reports through Schedule Management in
Cognos Connection.
. Worked with ETL teams for data quality control and cleansing.
. Tested and improved Report Performance.
. Trained Users on QueryStudio for Ad-Hoc Reporting.
. Documentation for User training.
PowerPlay
. Designed models by mapping business needs using PowerPlay Transformer
and created multi dimensional cubes, cube groups, Power Play reports.
. Decreased the Cube build times drastically and increased runtime
performance.
. Deployed Cubes and Reports on Power Play Enterprise Server.
Environment: Cognos 8.0 (Framework Manager, Report Studio, Query Studio,
Cognos Connection), Cognos 7.3 (Power Play, Transformer, Power Play
Enterprise Server), Oracle 9i, MS SQL Server 2000, Windows 2000.
Tata Infotech, Goa India
Cognos Consultant
Aug 04 - May 05
Tata InfoTech is a leading software service provider in India. The project
dealt with "Integrated Information Warehouse" which provides flexible
reporting and analysis environment for business users to identify
opportunities in the banking market space.
Responsibilities:
. Worked with Business Units to define Business strategy and create a
centralized reporting capability for users to perform analytical, and
ad-hoc reporting for business applications and provide accurate
information available to Decision Makers.
. Developed reports for Call Center managers and workload scheduling
team.
. Used Cognos Report Net as the web reporting solution of choice by
conducting product demonstrations and improve business performance at
all levels of their enterprise.
. Used Cognos Connection for organizing, security, scheduling and
distributing reports.
. Built models and published packages in Framework Manager to the Report
Net server.
. Developed filters, calculations, prompts, conditions, and created
various reports, using Cognos Report Studio.
. Responsible for the delivery of solution-oriented complex reports
using Cognos Report Studio.
. Developed complex Dashboard reports.
. Responsible for Business Data Analysis, Design, Development of
Multidimensional OLAP Cubes, deployment and providing drill-through
targets to another Cube, Power Play Portable Reports, Impromptu
reports and Report Net reports.
. Published Cubes and Reports through Power Play Enterprise Server
Administration and integrated access to information using Cognos
Connection.
. Used Transformer with a variety of sources and combined them into
Multi-Dimensional Cubes.
. Provided technical assistance, training and mentoring to Users and
Business Partners.
Environment: Cognos BI New Tool Report Net 1.01 (Frame work manager, Cognos
Connection, Report Studio, Query Studio), Impromptu, Power Play, Power Play
Transformer, Oracle 8i.
Education:-
Masters in Computer Science (M.S) December 2007
University of Bridgeport, Bridgeport, CT
Bachelor in computer science (B.E)
SVIT, Vasad, INDIA
August 2004
Contact this candidate