SUMMARY

• Over 7 years of experience in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development and implementation of client server applications.
• Experience in different versions in Cognos 8/10 (including Cognos connection, Report studio, Analysis Studio, Query Studio, Powerplay Studio, Event Studio, Workspace and Workspace advanced, Business Insight, Framework Manager, Transformer, Dynamic Cubes).
• Worked on complete lifecycle development process which includes analyzing business needs, documenting business information requirements, technical designs, developing, integrating, Implementation and production support using Cognos as a BI tool.
• Strong understanding of dimensional modeling of Star Schemas, Snow - Flake Schemas methodologies, dimensional data structures and complex hierarchies.
• Responsible for interacting wif users and department directors to identify information needs and business requirements.
• Experience in installing, configuring, maintenance and administration of Cognos BI suite in different environments.
• Implemented enterprise level Cognos security and server administration using Cognos 10.x/8.x and administration of security access using Access Manager, LDAP(ADLDS) and custom autantication provider.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using metadata Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Extensive noledge in creating models in Framework Manager(Physical layer, Business layer and presentation layer) and exporting packages to use it for report building.
• Created IQD's in Framework manager to use in Transformer using externalized method.
• Created Dynamic cubes in Cube designer tool and deployed in cognos environment to increase the performance.
• Expertise in creating complex reports using lists, charts, crosstabs, drill-through, Master-detail reports, dashboards and cascading the reports using Report studio.
• Had experience in Developing various Dashboard Reports to see at-a-glance the volume and characteristics.
• Has worked on several requests from business towards building Report Studio reports, Query Optimization and Performance Tuning of all reports.
• Experienced in working wif RAVE visualizations in cognos workspace advanced and Report studio for building interactive reports for the end users.
• Experienced in javascript and HTML for creating dashboard reports.
• Experience wif ETL using SQL scripts using various data sources such as Oracle, DB2, SQL server and access.
• Building and maintaining Power cubes in Transformer using relational, DMR and OLAP packages as data sources, calculated measures, Customized views and Optimized Cube building process.
• Good analytical, problem solving and interpersonal skills. Ability to work on a team environment or independently and handle multiple tasks concurrently.
• Team Player wif the ability to communicate effectively at all levels of the development process.
• Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules

TECHNICAL SKILLS

BI Tools: Cognos 10.2.X, Cognos10.1.X, Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Cognos workspace advanced, Cognos Mobile, Cognos administration, Report Net, Cognos Access Manager. Tableau Public, SSRS, Business Objects.

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manger

ETL Tools: Informatica workflow designer, Workflow manager, Workflow Monitor, Data Manager

Languages: SQL, PL/SQL, HTML, MDX, Java script

RDBMS: Oracle 11g/10g/9i/8.x, Teradata, MS Access/Excel, DB2, and SQL Server

Operating Systems: Windows 2008/2012 R2, UNIX, Sun SOLARIS, Linux RHEL 6-5.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr.Cognos Consultant

Responsibilities:

• Integrated cognos portlets wif IBM portal server and cognos reports wif external java/asp applications.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email.
• Created Backups of the content store and Public folders by saving as an archieve file in deployment files location in Cognos configuration.
• Developed and maintained BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.Created Framework models, queries according to standards and requirements continued wif testing the report data wif PL/SQL stored procedures.
• Created and published packages to Cognos Connection.
• Re-designed Framework Manager Model to leverage Best practices to ensure predictable queries.
• Imported metadata by creating database connections for different data sources like Oracle and MS SQL in Framework Manager
• Established framework for gathering and analyzing business requirements; designed a star-schema datamart to meet requirements; developed Cognos solutions to deliver information; trained client’s staff.
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers.
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 10.1and 10.2
• Developed filters, calculations, prompts, conditions, and created various reports, using Report Studio for users.
• Maintained source/version control for Cognos models, reports and involved in Documentation for user training.
• Developed various Dashboard Reports such as the Loan Originations dashboard to see at-a-glance the volume and characteristics of new loan originations, such as credit scores and loan-to-value calculations throughout the portfolio.
• Designed, developed, administered and deployed Cognos Cubes based on requirement.
• Worked wif Relational Databases - Oracle and MS SQL and involved in ETL team discussions.
• Used SQL Developer to access and analyze data directly from Oracle databases and testing reports data wif Hand written SQL.Involved in performance tuning of several Reports.
• Performed report reviews by creating scripts to capture the run time sql sent to database by cognos.
• Performed detailed documentation of design, development, testing and deployment activities.
• Made judgments and took decisions while addressing complex business issues wif minimal supervision.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Involved in unit testing of all the reports and documented all the test cases worked on.

Environment: Cognos 10.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis studio, Metric Studio, Metric Designer, Metric Studio Event Studio), Power Play Transformer, LDAP, Oracle 11g, Windows 2008/2012 Server, Batch scripting, Tomcat/Apache.

Confidential, New york city, NY

Sr. Cognos Consultant

Responsibilities:

• Managed scheduling of reports, maintenance of public and individual folders, users, groups and roles using Administrative tools in Cognos 10.
• Imported metadata by creating database connections for different data sources like Oracle and MS SQL in Framework Manager.
• Involved in designing models using Framework Manager and published them.
• Created various business mix and trend over time reports using Report Studio.
• Created claims summary reports wif multiple measures for different years.
• Generated financial reports related to revenue generated vs. cost comparison for each product line and sales region.
• Used detail, summary and context filters and row suppression to focus on the more relevant part of a report.
• Created a Bonus Report that shows the employees that received bonus in an year by region using list reports, page sets, multiple prompts, filters, grouping, conditional highlighting and conditional rendering
• Created multiple paged professional reports wif table of contents and bookmarks, to provide easy access to data.
• Worked on Report Studio to create calculated columns to measure the Gross Profit and Net Profit in terms of Revenue.
• Cognos Active reports were used to develop interactive reports and dashboards using data decks, tab control items etc.
• Used Render variables and data items to hide confidential information in the reports.
• Provided drill-thru report functionality wif drill thru to a different report in Report Studio.
• Designed a high level graphical view of company’s performance indicators in a dashboard report using a crosstab, column chart and a gauge chart.
• Used Transformer to create cube groups based on sales territories for different regional managers.
• Worked wif Relational Databases - Oracle and MS SQL and involved in ETL team discussions.
• Used SQL Developer to access and analyze data directly from Oracle databases and testing reports data wif Hand written SQL.
• Used various techniques to improve report performance.
• Used Analysis studio for slicing and dicing of the cubes
• Performed detailed documentation of design, development, testing and deployment activities.
• Analyzed the user needs and gathered the requirements for reporting purposes.
• Implemented data level security using parameter maps, session parameters and macros.
• Performed report reviews to capture runtime SQL sent to database by Cognos.
• Upgraded Cognos from 10.1.1 to 10.2.1 and tested for multiple environments like Development, Testing, UAT and Production using Cognos life cycle manager.
• Provided training and support to internal clients and end-users on Query studio, Report Studio, Analysis Studio and the COGNOS portal.

Environment: Cognos 10.x (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), Oracle 11g, Windows 2008/2012, Toad, Microsoft Excel.

Confidential, Cookeville, TN

Sr.Cognos Developer

Responsibilities:

• Formatting data to analyze in drill mode and slice & dice mode. Develop reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Cognos PowerPlay.
• Involved in the Design, Development, Testing and Implementation of All phases of Project
• Publishing priority reports to the Corporate Intranet wif security and scheduling them
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Design Multi Dimensional Cubes, so that all key performance indicators can be analyzed
• Used Cognos Scheduler to schedule various reports weekly and daily by customizing scheduling icon near report.
• Developed Framework Manager Models for different reporting projects wifin the organization to satisfy the needs of different departments and various projects and published packages to the Cognos Connection.
• Used Event Studio to create agents that monitored status changes and priority customers that was important for the Business users.
• Imported metadata by creating database connections for different data sources like Oracle and MS SQL in Framework Manager.
• Created different joins according to requirements depending upon which schema we are using either star schema or snow flake schema.
• Created list reports, master-detail reports and Drill through reports in a single complex report.
• Worked wif Analysis Studio to develop multi dimensional reporting.
• Cognos Active reports were used to develop interactive reports and dashboards using data decks, tab control items etc.
• Creation of Multidimensional Cubes Model using Transformer and generation of PowerPlay.
• Documenting and understanding the existing system designs and tan building the PowerPlay Cubes.
• Involved in documenting the project.
• Used detail, summary and context filters and row suppression to focus on the more relevant part of a report.
• Involved in solving stitched query by changing the query looking in sql developer and also modifying the model for better performance.
• Designed a high level graphical view of company’s performance indicators in a dashboard report using a crosstab, column chart and guage chart.
• Assists wif implementing the processes necessary to refresh or otherwise maintain sets of data for testing and development purposes and automates processes when possible.
• Provided production support for the report and involved in activities including program analysis, testing and system enhancements.

Environment: Cognos PowerPlay 8, Cognos Transformer8.4, Access Manager, Windows 2003, Oracle 9i, SQL Server 2008 .

Confidential, Kansas City, MO

Cognos Developer/Admin

Responsibilities:

• Formatting data to analyze in drill mode and slice & dice mode. Develop reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Cognos PowerPlay
• Applied best practices on the Framework Manger models to refine and fine tune the models and provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Created complex reports involving multiple prompts, filters, multi-page, multi-query reports against multiple databases for the users to view information both by business unit and at a more strategic level across the organization.
• Implemented Data level, object level and package level security in Framework manager to achieve highly complex security model
• Used conditional variables to govern the rendering of prompts on the prompt page.
• Involved in the Design, Development, Testing and Implementation of All phases of Project
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Design Multi Dimensional Cubes, so that all key performance indicators can be analyzed
• Used Cognos Scheduler for scheduling weekly and daily reports.
• Used Cognos Connection to set privileges for Cognos FM packages, folders and reports by granting up read, write, execute and traverse permissions based on user requirements.
• Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic wif reports.
• Participated in the QA process through phases such as test development, review, execution and analysis and solved the issues.

Environment: Cognos 8.4 (Query Studio, Report Studio, Framework Manager), Cognos Connection, Transformer, Access Manager, MS SQL Server 2008, Oracle 11g, Windows 2008

Confidential, San Francisco, CA

Cognos Developer

Responsibilities:

• Designing mapping of process flow and interacting wif analysts and core team members to select the proper system infrastructure.
• Design and review the processing steps and create processes for new system.
• Review project specifications, flow charts, process diagrams and system documentation for application operations and methodology.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Coordinating wif other teams to improve the quality of work.
• Created prompts in report to restrict data fetch and ease data load.
• Extracting OM(Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
• Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
• Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model.
• Restricting the user access wif halp of Access Level privileges.
• Creation of repositories and security domain wif user groups and security implementation

Environment: Cognos 8.4 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i, MySQL, MSQL Server, windows 2003.

Confidential

Cognos Developer

Responsibilities:

• Gathered User requirements and reviewed them from a technical perspective and conducted meetings wif end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort. Worked on framework Manager tool creating models.
• Created Multiple complex reports using Drill through functionality in List, chart and crosstab reports.
• Created Multi-Dimensional Cubes by using Power play transformer for preparing multidimensional/IQD reports.
• Drill Down and Drill Through functionalities were used in the cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Worked wif Analysis Studio to develop multi dimensional reporting.
• Maintained source/version control for Cognos models, reports and involved in Documentation for user training.
• Used SQL Developer to access and analyze data directly from Oracle databases and testing reports data wif Hand written SQL.
• Involved in understanding Data warehousing concepts and documenting project.
• Developed PL/SQL procedures, packages, triggers and other database objects.
• Design, review and implement functional specifications. Attend client meetings along wif business analysts to discuss technical design for new features.

Environment: Cognos 8.4(Cognos Report Studio, Query Studio, Cognos Framework Manager, Cognos Connection, Powerplay Transformer), Oracle 10g, SQL Server.