SUMMARY

• Over 7.5 years of IT experience as a Cognos Consultant in the development of Data Warehousing, Reporting tools, design and development of Transformer models, complex Reports using Cognos Series 7.x/8.x/10.1 development and administration of Framework manager models using Cognos set.
• Certified IBM Cognos analyst and reports author / Meta data modeler
• Hands on experience in Cognos BI suits, Cognos Planning software and Cognos OLAP/Transformer
• Experience in working with business experts, end users and IT professionals to understand business processes, integrate Cognos solutions with other software products and architect solutions to minimize manual work and future maintenance.
• Expertise on Report Studio, Query Studio, Events Studio, Analysis Studio, Cognos Connection settings, Cognos GoOffice and Cognos workspaces Advanced.
• Experience in designing and developing complex Framework Manager models from various data sources and implementing security using session parameters.
• Expertise on OLAP cubes, Powerplay Transformer, Powerplay Studio and converting and upgrading Powerplay transformer models across platforms.
• Expertise on creating Framework Manager Models out of OLAP sources (Power Cubes, MSAS, and ESSBASE).
• More than 4+ years of experience on Events Studio with creating alerts, executing tasks and distributing re - ports.
• Expertise on creating dashboards, portals, drill through reports and complex reports with conditional rendering and conditional layouts.
• Hands on experience on Cognos Planning including Contributor Administration Console and Planning analyst.
• Experience in developing dashboards using Metrics Studio Packages, deployments and jobs.
• Experience on customizing templates, saving reports to an external folder and distributing reports upon events. Also designing and implementing a report distribution system that distribute reports and alerts upon arrival of new data
• Hands on experience in using Oracle SQL developer, Query Analyzer, TOAD, Teradata SQL Assistant / Teradata performance monitor (POM), ETL tools to analyze data and design reporting requirements
• Used MSSQL Server 2000/2005, Oracle 10g, 9i, 8i, DB2 8.1/9.2, Teradata V2R12 / V2R6.
• Experience in working with ETL and database developers to design, develop and documents data warehouses
• Experience in analyzing and troubleshooting reporting issues by referring to system generated SQL from Cognos
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

BI Tools: IBM Cognos 10, Cognos BI 8.x, ReportNet MR1, MR2 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio), Cognos Planning, TM1 Web, EP Series7.0, (Impromptu, PowerPlay Transformer, Administrator, Enterprise Server, Architect, Access Manager, Visualizer, Upfront)

Languages: SQL, PL/SQL, C, Java, J2EE, Visual Basic

Web Technologies: HTML, DHTML, XML, CSS, JavaScript, AJAX

Java Technologies: J2SE, Servlets, JSP, EJB, Web Services, ODBC/JDBC, EJB, JMS, JNDI, GOF Design patterns

Servers: Web Sphere 6.0, BEA Web Logic 8.0, JBoss and Tomcat

Tools: My Eclipse 5.1.1, JBuilder, Log4j, ANT, Junit3.8.1, CVS,VSS, Microsoft Project, TOAD, PL/SQL Developer.

Databases: Oracle 10g/9.x/8.x/7.x/, DB2, Sybase, Teradata, MS SQL Server and MS Access.

Operating Systems: MS DOS, WinNT/2000, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Plano, Texas

Cognos BI Analyst

Responsibilities:

• Planned, installed and configured Cognos BI 8.1 products in four different environments including CBO server and Cognos Framework Manager in many workstations.
• Worked on upgrading all four Cognos 8 BI environments from 8.1 to 8.2 and 8.2 to 8.3
• Planned implemented and documented Cognos 8 security structure and integrated with MS Active Directory. Implemented package level, object level security. Created user group/ roles and assigned capabilities.
• Extensively worked with company’s Intel Application Services on maintenance, upgrades and patches related Cognos 8 servers
• Extensively conducted business process analysis, data analysis and BI capabilities for many new and migration projects. Create many pre project analysis documents and QA plans
• Designed and built Cognos 8.4 PowerPlay cubes to build and use reports in Analysis studio
• Created complex Dashboards, Scorecards in Reports studio and Analysis studio
• Created complex summary-detail reports, multi-page reports, complex reports with conditional layouts and conditional rendering
• Created forecast reports, ranking reports and multi prompt reports with various containers like crosstab, list and repeaters.
• Extensively worked UI developers, ETL and JAVA developers on project that used Oracle/Lombardi Teamworks/Cognos 8 to develop a front end UI and Cognos reports for Relationship Management team
• Worked with eBIS team to initiate Cognos 8 reporting standards, created Cognos 8 templates, custom portals, naming standers and distribution setup.
• Created Metrics, projects and actions, verified metric details and maintained metric history
• Created user friendly Metrics Studio Scorecards in a single display to monitor Broker Dealers and their performances
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
• Worked with Oracle 10g, MS SQL Server 2000 & 2005, DB2 and Teradata V2R6 & V2R4 data sources to create connections, import data and build Framework manager models
• Extensively used Analysis Studio for reporting against OLAP sources and Events Studio to set up red flagged reports.
• Worked to solve many production level issues related to sort memory buffer size, query reuse and post upgrade issues and extensively worked with IBMs’-Cognos support to solve more than 100 issues
• Planned and implemented a Cognos TM1 Project, TM1 architect used Executive viewer. Created dimensions, cubes and rules.
• Trained business users and eBIS team members on using Cognos tools. Participated and led a knowledge transferring process to TATA consulting (TCS) in a out sourcing project/process

Environment: Cognos 8 BI, Cognos Connection, Frame Work Manager, Cognos Reports Studio, Analysis Studio, Events Studio, Oracle 9i/10g, DB2, SQL Server 2000/2005, Windows Server 2003/NT, MS Analysis Services, Hyperion Essbase 9.0, Teradata V2R6/V2R4.

Confidential, New York, New York

Cognos Analyst

• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Designed Standard List Reports, Cross-tab Reports, Charts, Master-Detail and Drill through Reports using Report Studio.
• Developed metadata models with appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Implemented security in Framework Manager Packages & Reports.
• Created Multidimensional cubes using Cognos Transformer 7.3 and Transformer in Cognos10.
• Migrated Cognos Series 7 reports to Cognos 8.3., including configuration of the namespace security.
• Discussed business requirement and mapped Business need using Model Capability of Cognos Transformer.
• Developed the most complex Margin cube which has all the cost details as well gives clear picture regarding the variable cost and Margin growth.
• Analyze clients Decision Support System needs. Participated in the entire life cycle of the application, which involved business analysis, documentation, development and implementation of Cubes and Reports.
• Extracted the sales data, applied transformation rules and placed in Data Mart. Designed and developed some of the more complicated data translations.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection
• Implemented drill through with reports to obtain the detail information in other report.
• Created Multi-Dimensional Cubes and Reports as per the User Requirements.
• Production Support which involves solving user problems and Provided End User Training and Support

Environment: Cognos 10 & Cognos 8.3 (Business Insight, Report studio, Query Studio, Analysis Studio, Powerplay Studio, Framework Manager and Cognos Connection) Dashboards in Cognos 8.3.Transformer 10 & Series 7 Transformer, Powerplay client 7.4, COGNOS EP Series 7 (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, Enterprise Server, PowerPlay Web, Server Administrator, Access Manager, Configuration Manager, Upfront, Deployment Manager), DB2, SQL.

Confidential, Irving, Texas

Cognos Developer/BI Consultant

Responsibilities:

• Installed and configured Cognos 8 BI and worked with Cognos 8 BI modeling, Report Studio.
• Developed Metadata Models using Cognos 8 Framework managers.
• Responsible for Access permission and administrating the server.
• Created highly customized reports in Cognos 8 Report Studio and some of the Ad-hoc reports in Query Studio.
• Created Score Cards, Dash Boards for multiple views of Reports from multiple data sources.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables
• Created Repeater reports and graphical reports based on HR and Financial data warehouse.
• Scheduled the Reports using schedule management tool in Cognos 8.1&8.2.
• Worked on exploring the dimensions such as Drill down/Drill up on nested categories and filtering the data etc.
• Created HR reports based on employee details, Leavers, Budget vs. Forecast reports etc.
• Implemented security in reports according to employee groups and roles according to the requirement.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Migrated several existing Cognos Impromptu Catalogs into XML files and importing them into Cognos 8.

Environment: Cognos 8.2 and Cognos 8.1 BI, Cognos Connection, Report Studio, Query Studio, Framework Manager, Impromptu, Cognos Power Play Transformer, Power Play for Web, Access Manager, XML, MS SQL Server 2005, Oracle, DB2, Windows 2003 server and TOAD.

Confidential, Beaverton, OR

Cognos Analyst

Responsibilities:

• Analyze current reporting architecture, use cases and design a new BI reporting solutions using Cognos 8.4 on a Teradata environment
• Worked with DBA and ETL team to explain the reporting requirements and design the data mart
• Created Cognos Framework Manager (8.4) models including data layers, business layers and presentation layers following Confidential ’s global business intelligence GBI standards and Teradata standards
• Created model query subjects, shortcuts, calculated fields, namespaces, folders and filters in appropriate layers in model to make it simple and more user friendly
• Created complex graph reports with multi select cascading prompts and drill through option to analyze purchase order information by regions, models categories
• Created complex trending reports to analyze Confidential ’s supply chain management and avoid factories operating over/under their capacities.
• Used dynamic data item / dynamic series (in graphs) and static prompts to consolidated similar reports/graphs to make those user friendly and reduce future maintenances
• Created reports to analyze demand projections for future seasons based on previous sales data. Worked extensively with data ware house developers to get projected data needed for reporting in to the data mart and process all subsets and calculations in the Teradata source
• Used tree prompts with in relational data to avoid having cascade prompts, conditional rendering techniques to give user the option to hide/display report columns and java scripts to modify the prompt pages

Environment: Cognos 8 BI, Cognos Connection, Frame Work Manager, Cognos Reports Studio, Analysis Studio, Teradata V2R6/V2R10

Confidential, Piscataway, NJ

Cognos Consultant

Responsibilities:

• Extensively worked with Confidential -Hill’s DBAs and used database client tools to analyze data for reporting
• Extensively worked with business experts and end users to identify the business process/requirements and verify/validate the data and discuss the Cognos capabilities
• Gathered data requirements, created pre project documents with Cognos functionalities/options such as report distribution, archives and security for the project
• Extensively worked with Oracle 9i, MS SQL Server 2000, and Teradata V2R6 & V2R4 to built complex model and reports using Cognos 8 BI tools
• Extensively worked with DBAs for performance tuning and used reporting techniques to minimize the local processing on Cognos query engine to reduce the workload on servers and maximize data retrieval speed
• Installed and configured Cognos Framework Manager for modelers
• Created Projects, Models, and Packages using Cognos Framework Manager
• Designed relational and a multidimensional models for reporting
• Created complex reports with Dashboards, Scorecards and summary - detail reports using drill through techniques.
• Integrated high level tactical dashboard with graphs and gauge charts in to a separate portal for management to analyze
• Created complex reports with conditional layouts, conditional formatting prompts and filters
• Created folders, filters, prompts, and complex query items in Framework Manager and Report Studio
• Extensively worked to achieve faster data retrieval out of a mega size database
• Created few different customized portal pages to grant access to users based on business needs
• Mentored and trained many business users who were new to Cognos and supported their inquiries.

Environment: Cognos 8 BI, Cognos Connection, Frame Work Manager, Cognos Reports Studio, Analysis Studio, Events Studio, Oracle 9i/10g, SQL Server 2000/2005, Windows Server 2003/NT, Teradata V2R6/V2R4

Confidential, Medina, OH

Cognos developer

Responsibilities:

• Developing a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Analyzing requirement Specification document and preparing the Specification document as per the Business requirement.
• Developing the SQL scripts as per the business requirement.
• Developing Dash Board reports in Report Studio.
• Creating the Report Studio reports using the Cube as a data source.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report.
• Creating the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Extensively working with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos BI Series 8.X, ReportNet, Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos Series 7, Impromptu 7.3, Cognos Transformer7.3.