SUMMARY

• 10+ years of IT experience with around 9 years’ experience in Cognos applications.
• Experience in full life cycle project development including design, coding, testing, implementation, delivery, Optimize, document and ongoing support for Cognos 10.2.1.,x/Report Net on multiple database platforms.
• 8+ years of IT experience in complete systems development life cycle.
• 8+ years of experience in developing Cognos applications using Cognos(8,9,10), ReportNet, Framework Manager, Impromptu, PowerPlay, Impromptu Web Reports (IWR), PowerPlay Enterprise Server (PPES), Transformer.
• Experience in installation, upgrading, Setup and Management of multi servers and Cognos10.x/8.x/7.x components.
• Administered Access Manager to implement Security among Cognos applications by using LDAP Server and user creation.
• Extensive experience of the Cognos environment and tools such as Cognos10/8BI, PowerPlay, Impromptu Web Reports (IWR), Access Manager, Architect and Server Administration on Enterprise, Upfront and IWR servers.
• Designed, developed Cognos data models and published Packages in Framework Manager to COGNOS 8.x/10.x BI Server/ReportNet Server.
• Published reports to IWR server with controlled access as per the end - user requirement.
• Published Cubes and PowerPlay reports on Cognos Upfront server.
• Worked on Deployment Manager in deploying the Cognos applications to different environments between development, test and production environments.
• Involved in migration of the applications from Cognos 8 to Cognos 10.
• Automated various activities in Cognos using Scheduler.
• Created various multi-dimensional cubes using PowerPlayTransformer.
• Installed and configured Cognos tools for various business requirements.
• Highly experienced in modeling the metadata dimensionally.
• Migrated Cognos 7 catalogs & reports to Cognos 8/CRN 1.1 using metadata migration utility
• Created and managed complex reports in zero-footprint environment using Cognos 8 BI and ReportNet.
• Experience in creating Prompts, Cascading Prompts, Conditional Variables and Bookmarks with multiple Report pages and multiple Prompt pages in Report Studio.
• Created Complex Reports with advanced features such as Master Detailed sections, Conditional formatting, Render variables, Drill-trough, Page set and bursting using Report Studio.
• Experience in building and publishing packages, managed security issues, designed metadata models created consolidated views and presentation views using Framework Manager.
• Proficient in Meta data modeling with Framework Manager and experienced in layered approach such as Physical Layer, Business Layer and Presentation Layer.
• Used both DQM & CQM data modelling.
• Administered Access Manager to implement security among Cognos applications.
• Experienced in the process analysis and performance optimization of BI reports.
• Interacted with end-users to gather requirements for reporting.
• Provided extensive end-user training and support.
• Ability to transform business requirement into Cognos enabled reports, dashboards and use of both drill down and drill through alternative.
• 3+ years’ experience with Tableau Desktop and Server.
• Created complex Tableau work books with twenty dashboards and over 500 sheets.
• Worked on creating links between different work books on server
• Maintained, Scheduled and published workbooks on server with both live and extract data
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time and location dimension
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Represented portfolio data as tree map based on the margin, detailed application data is represented as column graph with highlight table distributing margin across employee roles
• Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category.
• Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expense and margins as currency values.
• Computed margins using calculated field following pre-defined business rules
• Implemented hierarchies in Tableau with Portfolio as the highest level followed by application and project details.
• Generated groups for the application field to do category based analysis.
• Upgraded Tableau workbooks to use newer versions.

TECHNICAL SKILLS

OLAP Tools: Cognos 10.2, Cognos 10.1, Cognos 8.4 BI, Tableau 10.1, Tableau 10.2, Business Objects XI Rel 2.0.

ETL Tools: Informatica 8, Data stage 7.5, Microsoft SSIS 2008, Cognos Data Manager.

Data Bases: Oracle 10G, SQL Server 2012, Teradata V2R6, DB2 8.0

Web Servers: Apache web server, IIS 7.0.

Languages: SQR, C, HTML, SQL, PL/SQL.

Internet Technologies: HTML, DHTML, ASP, Java Script and VB Script, XML.

Tools: MS Office, Erwin, TOAD, VSS.

Operating Systems: Windows XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Cognos Admin/Developer and Tableau Developer

Responsibilities:

• Worked closely with finance department team to gather business requirements and specifications.
• Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions.
• Worked on technical design specifications for Framework manager, and reporting per the requirements.
• Used Framework Manager to build projects, packages based on business requirements and publish packages to the Cognos connection. Created relational models and dimensional models in Framework manager per requirements.
• Developed the Models in Framework Manager buy using both DQM and CQM’s.
• Used Cognos Mobile to Design and push Dashboards, reports and analysis on to mobile devices for top-level Executives for on-the-go analysis.
• Designed projects in Framework manager based on two tier models (Physical view and Presentation view). Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and importing only necessary query subjects.
• Implemented package level security and object level security while creating models in Framework manager.
• Developed cubes in Transformer from IQD files and packages.
• Designed & developed reports using Cognos 10.1.1 Report Studio, Query Studio and Analysis Studio.
• Created various List Reports, Grouped Reports, Cross Tab Reports, Charts and Drill- through Reports using Conditional Formatting, multiple Prompts and queries, Filters, Slicers, Multi dimension page breaks & Sections, master-detail relationship, aggregation function.
• Created reports in Analysis Studio by using cubes and multi dimension models.
• Developed Dashboards Using Business Insight and Business Advanced Insight and created Drill through reports from Dashboard to all summary reports and Summary to Detail reports.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection. Implemented bursting and event trigger function when it’s needed.
• Analyzed the reports which are in SSRS format and implemented these reports to Cognos Report Studio.
• DevelopedCognos Portal integration & Cognosportal design.
• Customized Cognos Connection with appropriate reports and security measures.
• Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.
• Provided technical assistance and training to Cognos Users.
• Experience in creating the Uni-variety, Bi-variety and Multi-variety chats
• Implementation of stored procedures, Views, functions and packages.
• Schedule refresh extracts on Server.
• Extensive knowledge in various reporting objects like Measures, Dimensions, and Hierarchies,
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created complex work books of multi dashboards and sheets for the Key Performance Indicators (KPI) for the top management using Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc.
• Developed maps manually using custom geo-coding and WMS servers
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document for each module.
• Generated test plan specifying overview of testing approach, testing strategy, roles, responsibilities & scope.
• Created Test Scripts, Test hierarchy to represent features and functionality that needs to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.
• Worked extensively in creating dashboards usingTableauthat includes tools likeTableauDesktop,TableauServer andTableauReader in various versions ofTableau9.
• Also, involved in the administration ofTableauserver like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementingTableauBI tool in all IT projects. Generated reports using SQL queries inTableauand published them to users in online thruTableau server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.
• Performed generating Daily/Weekly reports usingTableauby identifying the dimensions, measures, measure values and level of details for Business Analytics and Top Executives to give an overview.
• Created schema on Tableau by joining different tables to eliminate materialized views and flat structures.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Performance turning inTableauto improve report response time.

Environment: Cognos 10.2.1 (Report Studio, Query Studio, Metric Studio, Analysis Studio, Framework Manager, Cognos Connection, Transformer 10), Tableau 9&10, SSIS, Oracle Server, SQL server 2012, SSRS, Apache webserver

Confidential, Downers Grove, IL

Sr. Cognos and Tableau Admin/Developer

Responsibilities:

• Develop, enhance and maintain reports leveraging best available technology to meet business requirement (e.g., Cognos Tools)
• Performed requirements analysis, report, dashboard, and analytics solution design and consulting
• Design, develop, and unit test standard, complex and ad-hoc reports
• Validate the data warehouse feeds into the reporting tools
• Administrations and maintenance of Tableau and IBM Cognos environments
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Designed Tableau Analytics for Operational reporting.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Developed interactive Dashboards using dashboard actions. Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• According to the Business requirements created Data Layer, Business and Presentation Layers.
• Worked on framework manager to create models by importing metadata from multiple data sources and published packages to Cognos Portal (Relational, DMR and DQM models).
• Created reports in Analysis Studio by using cubes and multi dimension models.
• Developed Dashboards Using Business Insight and Business Advanced Insight and created Drill through reports from Dashboard to all summary reports and Summary to Detail reports
• Query structure by using filters, calculations, complex expressions, and conditional formatting.
• Created reports using SQL objects by writing the queries manually and Created Macro Prompts in Report
• Developed Cognos reports, FM Models, Transformer Cubes and Dashboards using various studios, Framework Manager, transformer and also implemented security.
• Developed interfaces for People soft to Cognos which includes modifying the existing Stored procedures to load the data into respective databases.
• Worked on the transformation logic of source data to reporting environment
• Assist with SQL/ETL programming to develop, test, and deploy while utilizing project methodology and internal standards
• Experience with creating the Tableau dashboards with relational and multi-dimensional databases.
• Knowledge in standalone/cluster Installation, Configuring and managing the Tableau Server
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, Filters and parameters

Environment: Cognos 10.2 (Query Studio, Report Studio, Analysis Studio, Active Reports, Work Space Advance, Cognos Connection, Framework manager), Tableau 9, MySQL, Oracle 11g, SQL Server 2012

Confidential, Chicago, IL

Sr. Cognos Admin/Developer

Responsibilities:

• Develop in-depth understanding of underlying data & data structures to ensure reports meet customer needs.
• Worked with users and coordinated with application developers to understand and capture data/reporting requirements
• Designed and developed Dash Boards, Report studio to show reports from different packages on to a single portal page and applying filters.
• Worked with Work Space & Advanced to design dashboards and also designed portal tabs, port lets.
• Drill-through definitions from Cube to a relational Package.
• Created Crosstab reports using DMR Models, also improved the turnaround time by tuning some of the functionalities.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables
• Worked on exploring the dimensions such as Drill Down, Drill Up, drill down and up on nested categories, filtering the data etc.
• Created various reports using Conditional formatting as required by the User.
• Created Income and Balance Sheet Reports based on Company details, Revenues, Budget vs. Forecast reports etc.
• Implemented security in reports based on various companies and roles according to the requirement.
• Involved in creating security and deployment (exports and imports).
• Created folders, filters, prompts, and complex financial calculations in Report Studio
• Created static choice value prompts, conditional variables and conditional blocks associated with these variables to display/hide columns and queries based on user’s selection in Prompt pages.
• Performance tuning experience related to reporting queries.
• Understood data integration issues (validation and cleaning), familiar with complex data and structures.
• Created test cases and work with QA team to ensure accurate and complete testing.
• Created technical documentation of report logic and processes.

Environment: Cognos 10.2 (Query Studio, Report Studio, Analysis Studio, Active Reports, Work Space Advance, Cognos Connection, Framework manager), MySQL, Oracle 11g, SQL Server 2012

Confidential, Atlanta, GA

SR Cognos Developer

Responsibilities:

• Involved in requirement gathering and Developed technical specification documents based on functional requirements.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design & development of the reports using Report Studio, Query Studio and Analysis Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed Active Reports, List, cross tab, master-detail, chart, multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
• Designed simple and complex active reports for offline reports for users on the go.
• Created Special Categories, User Class Views, Securities.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Used Transformer to build multi-dimensional cubes and then built reports on top of the cubes. Also, developed DMR to replicate Transformer Models.
• Developed reports using Multi-dimensional data sources like transformer models, DMR models etc.
• Installed and configured cognos 10.1 mobile service to manage activities related to cognos 8 go mobile client
• Customized cognos portal and change the default look and feel of cognos connection by editing CSS, Java and HTML files in cognos configuration.
• Understanding the existing security structure of the company and implemented organizational security for Cognos environment (Folders, Models and Reports).
• Designed Active reports and embedded the reports onto Cognos dashboards (business insight and also portal pages)
• Worked as a team towards finishing the tasks and achieving project deadlines
• Provided support for resolving technical issues for reports in report studio and query studio.
• Created indexes on the tables to extract the data quickly for the reports and developed PL/SQL Packages, Functions and Stored Procedures using Dynamic SQL.
• Created or maintained SSIS packages and used a visual development tool and worked on editingSSIS packagesusing a drag-and-drop user interface.
• Created the Event Triggers in Event Studio to run the Job sets.

Environment: Cognos 10.2, Cognos 8.4 Transformer, HTML, CSS, Java Framework Manager, SQL Server 2008, TM1, ORACLE 9i, SQL Server 2005.

Confidential, Arlington, TN

Cognos Admin/Developer

Responsibilities:

• Involved in the full project life cycle of planning, development and implementation stage across Cognos applications.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather
• The requirements and create functional and Technical specification documents and then pass them onto the offshore team in India.
• Create planning and estimation documents for the enhancements/projects and present it for approval to the project manager.
• Involved in the development of new Cognos reports, cubes and dashboards based on the requirements given by the corporate management group. Support the existing reports in Production
• Provide options on enhancement of the reports, which would make it easier for the higher management to look at the data in new and better way.
• Involved in performance tuning of some of the Cognos reports.
• Deploy the enhancements in staging servers for Acceptance Testing by the end users; and get sign-offs from necessary business partners
• Worked on Cognos portal customization and enhancement by modifying cognos files on the server.
• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to standards
• As part of the review of work done by the offshore team, collect metrics like: Number of bugs/issues per each enhancement/project, Number of hours spent by each team member in new enhancement, bug fixes in existing implementation, testing etc.
• Using .net via Cognos SDK to setup new portal in cognos connection and advanced functionality to cognos portal pages for end user analytics.
• Created appropriate user classes, groups, database signons in Active Directory to provide different levels of authentications and privileges.
• Performed Data validations, Unit testing and preparation of Unit test cases.

Environment: Cognos 8.4 BI, Framework Manager, Transformer, Power Play Transformer, SDK ( .net), SAP, Active Directory, IIS 6.0, Oracle 10g,Unix.

Confidential, Nashville, TN

Cognos Developer

Responsibilities:

• Responsible for gathering report requirements, creating functional and Technical specifications.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and migrating from Impromptu to CRN and then to Cognos 8.4.
• Migrated Packages, reports and cubes from CRN to Cognos 8.4.
• Used Life cycle manager to compare and verify with earlier version after migration.
• Created dashboards in order to organize the information to change the display type and collaborate with insights about the business performance.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security.
• Created Burst, master detail, conditional formatting, and drill through reports.
• Administration of Cognos Server/Environment including performance tuning and Issue resolution.
• Analyzed, designed and Implemented Multi dimensional cube for Claims analysis.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Imparted guidance and mentoring in Cognos report development best practices.
• Processed and summarized data in the application layer and generated summaries of that data.
• Involved in the design and development of indexes, views for performance up gradation wherever required based on the requirement.
• Created test plans from Use Cases and other user requirements.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Followed the best practices in development of packages, reports and cubes.
• Responsible for migration of cubes
• Involved in Batch scripting and Process-automation. Involved in sprint planning and execution
• Interacted with clients and worked on understanding the business requirements, Delegated jobs to offshore for a smooth transition.
• Involved in trouble shooting the issues, Ensuring quality standards for the deliverables.
• Involved in support of User Acceptance Testing (UAT) for all the completed applications. Involved in the creation of documentation of the overall process.
• Reporting and updating the status of the work to the Project Manager on weekly basis.

Environment: Cognos Impromptu (7.4), Cognos Reportnet, Cognos 8.4 BI, BI, SQL Server 2008/2005, Oracle, FM.

Confidential 

Software Associate

Responsibilities:

• Development & Unit Testing of Informatica PowerCenter mappings for the selected set of surveys to implement suggested changes in the mappings of Metadata tables.
• Execution of Informatica scripts for migration data to System testing environments and Validation of migrated data.
• Involved in requirements gathering, Data Analysis and Assessment. Used Impormptu (7.4), Powerplay And Cognos reportnet 1.1 to develop reports using report studio,analysis studio.
• Review the design and code of the Informatica Scripts to be migrated.
• Actively involved in Quality Assurance activities related to Project
• Data validation of migrated data in UAT environment.
• Involved in trouble shooting and debugging of issues.
• Involved in ensuring the quality process and adherence to standards
• Reporting and updating the status of the project to the Project Manager on weekly basis