SUMMARY

• Over 9 years of total IT industry experience analysis, design, testing, development and implementation of Business Intelligence & data warehousing environments.
• Experience in Financial Services, Healthcare, Insurance and IT sector.
• Excellent working knowledge of BI tools Cognos 8BI, Cognos Report Net 1.1/1.0 MR2 (Query Studio, Report Studio, Framework Manager, Cognos Connection), Cognos Series 7 (Cognos Impromptu, Cognos Power play), and Cognos 8.4.
• Strong Experience in developing Business models using Framework Manager and published packages to Cognos Connection in Cognos 8 and Report Net.
• Expertise in OLTP/OLAP system study, analysis, E - R modeling and developing Database schemas like Star Schema and Snowflake Schema.
• Experience in creation of Enterprise Data warehouses and Data Marts.
• Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
• Expertise in Ad-hoc Reports using Query Studio in Cognos 8 BI Suite and Report Net.
• Excellent skills in advanced Report Authoring which includes Conditional Formatting, using Filters and Report Validation.
• Analyzed multidimensional data and generated reports using Analysis Studio.
• Extensively worked on PowerPlay Transformer 7.x/6.x for Data modeling of the corporate Data for building multidimensional cubes. Created cubes tailored for widespread distribution by using dimension views and user class views.
• Extensive experience in creating Models and Packages in Cognos Architect.
• Extensive experience on Transformer Models for building Multidimensional Cubes.
• Used TOAD and SQL Developer to run SQL queries and validate the data in Data Warehouse and Data Marts.
• Good exposure in Relational Databases (PL SQL/Oracle, SQL, SQL Plus, MS SQL server and MS Access) for modeling and supporting analytical and reporting needs of Corporate Business.
• Installed TM1 prospective on User’s machine and performed Troubleshooting.
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Responsible for assigning user Sign-Ons for the New Users.
• Increased Performance by Monitoring Stats by Cube and TM1 Top Utility.
• Performed Troubleshooting by Diagnosing errors by viewing error log files.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Knowledge on Cognos TM1 Work flow and TM1 Executive viewer
• Experience in guiding users through TM1 Web and TM1 Reports.
• Created customized prompts using Cognos SDK.
• Integrated the Cognos Application with third party portals applications using JSP servlets and TIBCO.
• Customized the look and feel of Cognos Portal using JSP
• Strong troubleshooting and production Support skills and coordination/interaction abilities with end users.

TECHNICAL SKILLS

BI Tools: Cognos TM1 9.5.2,9.4 Cognos 10.2/10.1, 8.4.1/8.4/8. x Suite Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Metric Studio, Cognos Transformer 8.4/8.3 (Multi-Dimensional OLAP), Report Net 1.1/1.0x, Cognos Business Insight Advanced, Cognos EP Series 7 (Impromptu, IWR, Power Play Transformer and Power Play Windows/Web), Cognos Administration, Access Manager, Cognos Connection, PowerPlay Studio, PowerPlay Client, Cognos PowerPlay Enterprise Server (PPES), Cognos Visualizer, Cognos Enterprise Planning. Qlikview, Brio, Actuate, Business Objects XI R2, Designer, Info View, Web-Intelligence XI, Xcelsius 2008/2011, Application Foundation 6.0/2.5 & Dashboard Manager, Crystal Reports, Broadcast Agent.

Scripting Languages: ASP, JavaScript

Databases: Oracle 9.x/10g/11g, SQL Server 2000/, DB2, MS Access

Querying/Reporting: T-SQL, PL/SQL, SQL * Plus, SQL*Developer, TOAD, ORACLE

Web Portal Technologies: HTML, Visual Studio

Programming Languages: PL/SQL, TSQL, UML, XML

Data Modeling Tool: Erwin, Cognos Framework Manager

Web Servers: IIS, Apache 2.2

Documentation Tools: Latex, MS Office (Including MS Project, VISIO)

Operating Systems: WindowsNT/2000/XP/ 2003/2000/98/95, Windows Server 2000/2003, Linux Distributions-Red Hat Linux 5.8,Ubuntu

Database: Connections ODBC, JDBC

PROFESSIONAL EXPERIENCE

Confidential, Waukegan, IL

Cognos Architect

Responsibilities:

• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Designed multi-dimensional reporting packages and built BI reports with TM1 cubes as the datasources.
• Set up the Security at the package level, query subject level and the query item level.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.

Environment: Cognos TM1 10.1(Architect, Contributor, Perspectives, Turbo Integrator), Cognos BI 10.2 (Framework Manager, Cognos Connection, Query Studio, Report Studio and Cognos Transformer)

Confidential, Milwaukee, WI

IBM Reporting Lead

Responsibilities:

• Analyzed change impacts related to IT and business process controls.
• Analyzed the existing data mart and performed SQL data analytics to provide value to the business.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Installed TM1 prospective on User’s machine and performed Troubleshooting.
• Integrated Cognos TM1 with Cognos BI and performed BI Reporting.
• Responsible for assigning user Sign-Ons for the New Users.
• Increased Performance by Monitoring Stats by Cube and TM1 Top Utility.
• Designed and created conceptual and logical data model to support OMS (Sterling) data structures.
• Responsible for designing a dimensional model for the sterling data mart using Cognos Analytical Application/Warehouse.
• Created Source and Target star-schema model using Cognos AAF.
• Created ETL scripts and filters using Cognos Adaptive Warehouse layer.
• Created Cognos Framework Manager relational model to support OLTP ship from store data.
• Created shipment and order reports using Cognos Report Studio.

Environment: Cognos TM1 9.4, 9.5.2(Architect, Contributor, Perspectives, Turbo Integrator), Cognos 10.2 (Framework Manager, Cognos Connection, Query Studio, Report Studio and Cognos SDK), Cognos Adaptive Warehouse/Application 10.2, Oracle 11g, Erwin, MS-Visio and Red Hat Linux

Confidential

Cognos Architect

Responsibilities:

• Migrated LDAP to Active Directory using Cognos SDK programs.
• Design, develop, and implement Cognos TM1 9.5.2 Applications for Financial planning and budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles, and security.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Created complex Active Forms and enhanced the performance of existing Active forms.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created TI Processes to transfer currency data to currency cube.
• Portal integration was achieved using the Cognos SDK via Tibco as the middleware between Java portal and Cognos connection.
• Automated major administration task using SDK programs like the Deployment, running the reports etc.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts. Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).
• Developed Cognos multidimensional cubes and published cubes in analysis studio to analyze the business reports.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Involved in training users about Business Insight interface where they can easily access all kinds of data in one work area.
• Experience in deploying reports, migrating objects and testing reports in different environments.
• Involved in end user Cognos training to explain how effective can we use the tool.

Environment: Cognos 10.1.1 (Framework Manager, Cognos SDK, Business Insight, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, and Event Studio, Cognos Administration), Business Objects, JavaScript and HTML, Oracle Database 10g, TOAD, SQL Scripts, PL/SQL.

Confidential, Deerfield IL

Cognos Dashboard Developer

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Dashboards which consisted of Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Designed reports using slicers to filter dimensional data.
• Published reports in Cognos connection and implemented security to grant access to business group.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.

Environment: Cognos 10.1.0/10.1.1 BI Suite (Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced), Cognos Transformer 8.4, Teradata, SQL Assistant, Cognos Administration.

Confidential, IL

Sr. Cognos Developer

Responsibilities:

• Gathering Business Process Requirements from business users, for the reports to be developed and transforming them into functional requirements.
• Migrating reports from Qlikview BI to Cognos BI.
• Expertise in designing and developing DMR and Relational models using star and snowflake schemas.
• Training users to use the Cognos connection to access their corresponding reports.
• Developed complex cubes using MDX queries and Cognos Transformer.
• Expertise in using Query Studio for developing Ad hoc reports.
• Expertise in developing Dash Boards using Report Studio.
• Used joins to extract data from different tables.
• Working closely with the data modelers and providing them with queries, those are required to develop the facts & dimensions in the data model.
• Created calculations, filters, prompts and conditional formatting in Report Studio reports.
• Developed hide and show reports by using Conditional blocks and HTML Items.
• Expertise in creating reports by using Master Details, Drill through, Drill up and Drilldown.
• Performance tuning of the complex reports for better performance.
• Expertise in developing Prompt pages and Cascaded input prompts.
• Tested the Metadata model and relationships in Framework Manager.
• Moving/deploying reports from Development to testing and production servers using Content Administration.
• Follow quality standards and best practices for the development tasks.
• Created views and tables in Oracle Server database as a requirement for some Cognos reports.
• Installing and configuring of Cognos 8BI and Sun Solaris Server.
• Effectively involved in Unit Testing.
• Provided administration support and Development support for production issues.
• Scheduled and distributed reports using Scheduler in Cognos Connection.

Environment: Cognos 10.1.1/8.4/8.3 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Cognos Transformer 8.4, Oracle 11g, SQL Server 2005/2008.

Confidential, Hoffman Estates, IL

Cognos Business Analyst/Developer

Responsibilities:

• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.
• Developed Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Designed reports using slicers to filter data.
• Performed report bursting by sending the reports through E-mail.
• Scheduling and Distributing Reports through Scheduler in Cognos Connection.
• Created Analysis studio Reports using PowerPlay cubes.
• Defined agents using Event Studio.
• Testing and improving Report Performance.
• Involved in importing and exporting of data (reports/package) from development to production using the deployment option in the Cognos connection portal.

Environment: Cognos 8.4 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio) Cognos PowerPlay Transformer, Oracle 10g.

Confidential, Pittsburgh, PA

Cognos Consultant

Responsibilities:

• Installed and ConfiguredCognos8.4BIin a multi-tier Environment.
• Involved in Developing Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses’ needs (Folders, Filters, and Macros).
• Design and develop query models that support their tactical and strategic reporting needs
• CustomizedCognosConnectionwith appropriate reports and security measures.
• Created new jobs and scheduled reports using Cognos Connection.
• Deployed the Cognos Application on to the IBM Websphere servers.
• Design and develop logical dimensional models implemented in multi-dimensional databases or cubes and in the form of star schema database.
• Design, Develop, Build and Support metadata/ models and cubes in Transformer.
• Developed reports involving Multi Query, Multi page, Discontinuous cross tab, Graphical, Repeater, Union queries with a very high level of detail and formatting.
• Created custom prompt reports in Report Studio, Bursting reports to different user groups.
• DevelopedDash Board reportsinReport Studio.
• Trainedpower usersto useQuery StudioforAd-Hoc reporting.

Environment: Cognos 8.4, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, PowerPlay Transformer, Informatica Power Center, SQL Server 2005, IIS Web Sever.

Confidential, Alpharetta, GA

Cognos Developer

Responsibilities:

• Interacted with the Business users for requirement gathering.
• Installed & configured Cognos component such as the ReportNet.
• Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.
• Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cubes using MDX functions and queries.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP/NT

Confidential

Business Objects Developer

Responsibilities:

• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Created and tested classes and objects to organize the universe.
• Created complicated reports including sub-reports, graphical reports and well formatted reports according to user requirements.
• Linked the universes to share the common objects between them.
• Created Alerts in various reports according to user requirements.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in creating aggregate tables at different levels.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries and Reports.
• Used Broadcast Agent to schedule the reports depending on the user profile.

Environment: Business Objects XI R2, Designer, SDK, Web Intelligence XI, Desktop Intelligence, Xcelsius, Crystal Reports, Info View, BO Live Office, Dashboards, Performance Management, SQL Tuning, SQL Server 2005, OLAP, Oracle 10g, RDBMS, SQL, PL/SQL, Windows 2003/XP, SQL plus, SAP Business Objects suite.