Summary

• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Administering users/groups/roles deploying Packages, Reports across environments.
• Production Support Experience.
• Knowledge on tools MS Project, Erwin MS Visio Professional.
• Extensive experience in supporting Enterprise Data warehouses and Data marts.
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, DB2.
• Good understanding of Data Mart Architecture, data modeling and dimension modeling using Star Schema and Snow-Flake Schema.
• Working Knowledge on Informatica, Ascential DataStage, Cognos Planning, SqlServer Integration Services SSIS .
• Experience in migrating the Reports with the utilities.
• Expert in customizing the Cognos connection portal.
• Sound Knowledge as a Solution Designer in designing and building end user reports using Cognos 10.2, design a model to generate power cubes using Cognos Transformer.
• Experience in designing, developing and maintaining Cognos Impromptu and PowerPlay reports.
• Experience in training the end users.
• Experience in creating packages for adhoc querying.
• Experience in creating packages for analysis through DMR modeling
• Sound knowledge of Query Studio, Analysis Studio, Event Studio, Report Studio, Go-Office.
• Well-versed in developing reporting applications using Cognos 10.2, Cognos 8.4 suite components like Framework Manager, Report Studio, Query Studio, Cognos Connection.
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
• IBM Certified Designer Cognos 10 BI Reports.
• Cognos reporting suite expert with good experience in developing dashboards in Tableau.
• 12 Years of Overall experience with 10 Years of professional IT experience.
• 9 years in Data Warehousing, generating OLAP reports using Cognos Enterprise Suite 10.x/8.x/7.x/6.x and ReportNet 1.1/1.01.
• Around 1 year of experience in developing interactive data visualizations in Tableau.
• Develop, design and support Tableau dashboards and workbooks.
• 2 years of experience as BI/Data Analyst in understanding the underlying source data and working with ETL ODS teams in populating the data from source to target.
• Involvement in activities like Business Requirement gathering to Design and Development of Data Warehouses and end user reporting. Hands on experience in leading BI tools.
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team and proven leadership qualities.
• Domain knowledge and experience in the areas of Finance, Energy, Banking.

Technical Skills:

Professional Experience

Confidential

Sr.Cognos Tableau Developer/BI Analyst

• IFC provides loans, equity, structured finance and risk management products, and advisory services to build the private sector in developing countries and helps companies and financial institutions in emerging markets to create jobs, generate tax revenues, improve corporate governance and environmental performance, and contribute to their local communities.
• Migration of the reports created in series 7 to cognos 8.2.
• As a team, delivered around 350 reports in this migration project.

Overall Responsibilities:

• Conducting interview with business groups, identify their business needs and prospects.
• Analyzing on the business requirements, identify the bottlenecks and iterate them with business groups.
• Documenting the business requirements.
• Translate the business requirements into system specifications and develop the reports as per the client requirements.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Created Ad-Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Customized Portal Tab, specific to a Department need.
• Created a Dashboard Page in Cognos Connection as a single point of access for all the reports.
• Created data sources, Projects and Packages by using Framework Manager.
• Created Models in Framework Manager and Published Packages
• Creating and testing the Data Source connection, Created Database layer, Physical layer and Business/Presentation layer.
• Created Reports by using Report Studio.
• Created Dashboard in Report Studio.
• Created conditional formatting and drill-throughs for the reports.
• DMR modeling, to create a package for the management team in order to analyze the summarized data.
• Created Dimensions with different levels forming a hierarchy as per business need Time-Period dimension in DMR modeling.
• Involved in creating proof of concept for Go Office.
• Develop application prototypes. Design and develop Test Plan, Test cases, Perform certify the Quality and working on improving the Report Performance.
• Analyzing Oracle Queries to resolve the performance issues in Cognos reports. Scheduling and distributing reports through schedule management, Data validations, Data conversion and migrations.
• Analyzed the existing report specifications of Series 7.1 and ReportNet.
• Involved in Upgradation of ReportNet reports to Cognos8 and migration of series 7.4 to cognos8.
• Created Adhoc reports by using Query Studio.
• Created Event Conditions and Tasks by using Event Studio.
• Involved in Applying Package Level Security, Object level security.
• Used Javascripts,basing on the requirement.
• Installation of Migration Utilities Migs7 and Migdeploy.
• Converted catalogs and reports to XML by using impcat2xml and migratetoc8 commands.
• Deploy the converted xml to cognos8 portal by using migdeploy command.
• Tested series 7.1 reports before upgradation to series 7.4 as per the Audit.
• Involved in Upgrading reports to series 7.4 before migrating to cognos8.
• Carried out the performance testing of ReportNet reports as compared to Cognos8 reports.
• Recreated reports in Cognos8 which had migration issues broken drill through links, missing variables and parameters .
• Consolidated multiple reports into single report based on the requirements.
• Upgraded Framework Manager Models from 8.2 to 8.4.
• Created Models by using Trasformer and published the cubes to Cognos Connection.
• Modified the existing upgraded packages and republished to the cognos8 portal.
• Involved in setting up a process for moving the reports with drill through links.
• Unit testing of the reports to ensure the correctness of the data.
• Created POC for Active Reports Dynamic Cubes in 10.2.
• Created dashboard prototypes in Tableau for management decisions on final, standardized information dissemination templates.
• Involved in implementing the security for the Tableau Dashboards.
• Design and deploy Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Worked on the development of Tableau Dashboard reports for the Key Performance Indicators for the top management.
• Develop, design and support interactive Tableau dashboards and workbooks, that answer key business questions.
• Assisting Tableau Consultants in their visit to help us in implementing the best practices.

Environment

ReportNet 1.1, Cognos Series 7.4 Impromptu, Upfront, Impromptu Web Reports IWR , Access Manager , Cognos 8.4 Framework Manager, Report Studio, Query Studio,Go-Office , Cognos 8.2, SQL Developer, Oracle 10g, Cognos 10.2, Tableau 8.1

Confidential

Consulting Engineer

OpenPages enables the well-governed business through a software solution that provides a single enterprise system for managing governance, risk and compliance procedures and policies. With capabilities to identify new business opportunities and route out losses from business risk, OpenPages helps organizations implement a strong business governance practice. The results include improved top and bottom-line performance, and a higher valuation from investors.

Responsibilities:

• Interacting with the customers regarding the reporting requirements.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Deploying the reports developed on the customer environment by arranging the Webex Sessions.
• Training the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Creating highly complicated Heat-Map reports.
• Taking the customer through the entire technical process that has been used to develop their report.
• Scheduling Reports and Jobs to run periodically.
• Imported metadata from multiple data sources to build a model and publishing packages in Framework Manager to the ReportNet server.
• Extensively worked on relationships cardinality between query subjects to better represent the logical structure of the business and the user requirements.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Model.
• Created database layer and business layer, defining appropriate relationship between query subjects.
• Created custom templates and custom tool boxes for the use of reporting.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involving in writing the test plans testing the reports.
• Validated report results with the source data and authorized the reports to production environment.
• Prepared User documentation to train users and functionality of each report.

Environment: Cognos Reportnet 1.1MR3 Framework Manager, C.C, Query Studio, Report Studio , Oracle9i, Windows NT.

Confidential

Sr Cognos Developer

• Keane is using EPM as its Data warehouse. Enterprise Performance Management EPM , provided by Peoplesoft enables organizations to achieve world-class performance by aligning the right information and resources to strategic objectives.
• Within the GlobalConnect implementation, Keane Management requires insight into various pieces of information that is used to both manage the business on a day-to-day basis, as well as support business decisions and strategy. The goal is to provide various levels of management within the organization with a single point of truth for reporting.

Responsibilities:

• Extracting Peoplesoft financial data using the ETL tool, Ascential Datastage.
• Creating tables/views basing on the requirements in PS Application Designer.
• Migrating Catalogs, Reports from Version 7 to C8 using the migration utilities.
• Extensive Work Experience on Modeling using Cognos 8 Framework Manager.
• Importing Power play Cube Data Sources and defining multi Dimensional Hierarchy and creating packages For Cognos 8 Report Studio and Cognos 8 Analysis Studio.
• Creating list reports Bursting , cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Customize the Cognos connection portal using existing portlets and customized tabs.Define Global Drill- through definitions and established drill-through from Report Studio report to analysis studio report.
• Worked on complex reports using Tabular Objects, Customized/ Static Prompt conditions.
• Extensively worked on building Transformer Models dimension hierarchy, drill-down paths, calculated measures, roll up's, Performance Tuning.
• Involved in designing and building the Powerplay cubes using Transformer.
• Administering the business users in the portal based on the requirements.

Environment: Cognos 8,Ascetical DataStage, Cognos 7x Suite Impromptu, Transformer, Powerplay Enterprise Server, Cognos Planning 7.1, Cognos Visualizer 7.3, DB2, Sqlserver2005, Peoplesoft 8.4, Windows NT, Migration Utilities Impcat2xml, Migratetoc8, Deploytoc8 .

Confidential

• The reports for retail data warehouse are generated with the help of target TERADATA databases. The data into teradata is loaded using INFORMATICA and is sourced from the following:
• The RDW Retail Data Warehouse was built to manage all kinds of assets related information flowing into Entergy. Reports generated from RDW help the business users to improvise on their strategies with respect to the business application. RDW is a centralized repository for all the retail business related data having valuable information about the Entergy business. This information serves as an authenticated information source for all the departments in generating various reports.
• CCS database customer database on SAP ,
• ODS marketing database on oracle ,
• CUFS any customer related document or correspondence with customer related to his welcome kit, bill etc., i.e. sub part of customer database
• Call Center Data flat files
• The packages are defined/built in Framework manager and are published into Reportnet Server. The requests raised for the reports are built in Report Studio.

Responsibilities:

• Built Power Play Reports based on these cubes and published to ReportNet Server.
• Involved in designing and building the Powerplay cubes using Transformer.
• Worked on complex reports using Tabular Objects, Static Prompt conditions.
• Extensively worked in Scheduling and Deploying Staging to Production Reports.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Involved in Migrating metadata and reports from Impromptu to Reportnet using utilities.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Implemented Security with LDAP and Group level security in cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Worked on framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to ReportNet server.
• Installation and Configuration of the Cognos Reportnet 1.1 MR3 environment.
• Administering the business users in the portal based on the requirements.

Environment: Informatica, Cognos ReportNet1.1 MR3 Framework Manager, C.C, Query Studio, Report Studio , Teradata, Tivoli LDAP, Migration Utilities.

Confidential

Software Programmer