Manager Data
Resume:
Srinivas
BI Lead Developer
**********@*****.***
Summary
** ***** ** ** ********** in Analysis, Design, Testing, Development and Implementation of client/server applications
Experience with Cognos Tools such as Cognos 8 Suite, Cognos Report net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x.
Expertise in Cognos 10.1.1,Cognos 8/ 8.4 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio and Query Studio)
Expertise in Relational and Dimensional modeling. Good knowledge in cognos 11.
Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages) and Complex Report building with Report Studio
In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
End to end experience in designing and deploying data visualizations using Tableau
Deployed the reports and Scheduled Reports for the use of end users and customers
Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
Expertise in Report building using Report Studio reports integrated with JAVA Scripts.
Experience in Transformer model design and Power play cube building
Experience in Installation and configuring the Cognos 8 and CRN environment.
Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
Experience in databases like Oracle 9i/8i, my SQL, MS SQL Server 2005/2000, DB2 and Teradata.
Performed analysis of reporting requirements: design, develop, implement and support Cognos-based reporting solutions for a variety of clients.
Strong problem solving skills, ability to develop strategies for clients and provide detailed documents to clients
Customized the Cognos Connection Portal/reports based on user requirements.
Strong experience in Map Reporting using Google Map APIs, Yahoo Map APIs.
Good hands on experience with PeopleSoft EPM
Extensive Experience on Production Support and Troubleshoot/Test issues with existing reports and cubes.
Experienced in gathering of User requirements and responsible to provide efficient end-user training and designing report specifications.
Certifications:
IBM Certified Designer Cognos 10 BI Reports
Cognos 8 BI Author v2 Certification Program Cognos Report Net Modeling Product Professional Cognos Certification Program Cognos Report Net Authoring Product Professional Cognos Certification Program Cognos Report Net Product User Cognos Certification Program
Impromptu Series 7 Administrator Cognos Certification Program
Technical Skills
BI TOOLS
Cognos 11,Cognos10.2 and 8.x Suite, Report Net 1.1/1.0x, Cognos- Impromptu 7x/6x, SSAS/SSRS/SSIS, Tableau desktop, Tableau Server, Data Manager,SQL*Plus.
DATABASE
ORACLE 8i/9i, MS-Access7.0/2000, SQL Server 2000,DB2,Teradata
OPERATING SYSTEMS
UNIX 5.0, Windows XP/NT/2000 and MS-DOS
ETL Tools
Informatica 8.0/8.3/8.5.1/7.1/6.2/6.0
WEB SERVERS
IIS, Netscape Enterprise Server, IE
APPLICATION SERVERS
Apache Tomcat, Web sphere application server(WAS 6.0)
PROFESSIONAL EXPERIENCE
Project # 1
Client: Price waterhouse cooper, CA
June 2016 – AUG2017
Role: BI Developer
Responsibilities:
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Worked closely with clients to understand, gather and documented business requirements
Deep experience with the design and development of Tableau visualization solutions.
Background in installing and upgrading of Tableau server and server performance tuning for optimization.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Defined best practices for Tableau report development.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters in Tableau.
Understanding of relational database structures, theories, principles, and practices.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed Dashboards, List, cross tab, drill through, master-detail, chart, Active reports and complex reports which involved Multiple Prompts in Report Studio.
Design and creation of Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed
Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
Participated in the process of Identifying BI tools for the future.
Involved in Requirement Analysis, Functional Design and Technical Design.
Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
Created Materialized views for summary tables for better query performance.
Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
Extensively worked in the performance tuning of mappings, ETL procedures and processes.
Perform unit testing at various levels of the ETL.
Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
Loading of data from different source systems into Oracle Target database.
Environment: Cognos 10.2.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Tableau Desktop 7.0, 8.0, 8.1, Tableau server, Oracle 9i,oracle10g (SQL, PL/SQL), Teradata, SQL Server,MySQL, DataStage,Informatica Power Center/Power Exchange 8x, Oracle 10g, Flat files, Toad, SQL Developer
Project # 2
Client: Bank of America, A
June2012 – June 2016
Role: Cognos Lead Developer
Responsibilities:
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Worked closely with clients to understand, gather and documented business requirements
Deep experience with the design and development of Tableau visualization solutions.
Background in installing and upgrading of Tableau server and server performance tuning for optimization.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Defined best practices for Tableau report development.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters in Tableau.
Understanding of relational database structures, theories, principles, and practices.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed Dashboards, List, cross tab, drill through, master-detail, chart, Active reports and complex reports which involved Multiple Prompts in Report Studio.
Design and creation of Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed
Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
Participated in the process of Identifying BI tools for the future.
Involved in Requirement Analysis, Functional Design and Technical Design.
Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
Created Materialized views for summary tables for better query performance.
Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
Extensively worked in the performance tuning of mappings, ETL procedures and processes.
Perform unit testing at various levels of the ETL.
Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
Loading of data from different source systems into Oracle Target database.
Environment: Cognos 10.1.1 and Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Tableau Desktop 7.0, 8.0, 8.1, Tableau server, Oracle 9i,oracle10g (SQL, PL/SQL), Teradata, SQL Server,MySQL, DataManager,Informatica Power Center/Power Exchange 8x, Oracle 10g, Flat files, Toad, SQL Developer
Project # 3 JAN 2009 – May 2012
Client: Nike, Beaverton
Sr Cognos consultant
Responsibilities:
Analyzed Business requirements from the analysts
Customized Cognos Connection with appropriate reports and security measures
Worked on Analysis Studio to develop multi dimensional reporting
Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP)
Designed Power Play reports to provide summarized results by measures and dimensions.
Created custom prompted reports in Report Studio, Bursting reports to different user groups.
Involved in Designing 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 Framework Manager Model.
Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in ReportNet
Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
Created dashboard using parameters, sets, groups and calculations.
Created drill down and drill up in worksheets.
Involved in creating a dual-axis bar chart with multiple measures.
Created report schedules on Tableau server.
Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
Scheduled Reports using Cognos Connection
Migrated Cognos 7.3 Catalogs and Reports to Report Net1.1 MR2.
Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
Developed Complex Report Studio Reports using Bursting, Tabular Objects.
Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
Prepared User documentation to train users and functionality of each report.
Production Support which involves solving user problems.
Securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace.
Creating IQD files from Report net and designed Power play models in Transformer.
Involved in building the complex cubes and optimizing the cube creation.
Publishing cubes and created Power play Reports for the web users.
Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
Responsible for overseeing the Quality procedures and Software configuration management related to the project.
Environment: Cognos 8, Reportnet1.1 MR2, Tableau Server v6/v7, Tableau Desktop v7/v6, DB2, Oracle 9i, mySQL, windows 2000, UNIX 5.0.
Project # 4 Aug 2007 – DEC2008
Kaiser Permanente Information Technology, Pleasanton, CA
Sr Cognos Developer
Description:
Kaiser Permanente is the largest nonprofit health plan* in the United States, serving 8.6 million members in nine states and the District of Columbia. It is an integrated health delivery system which provides entire scope of care including preventive care well-baby and prenatal care, immunizations, emergency care, screening diagnostics, hospital and medical services and pharmacy services.
Responsibilities:
Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
Customized Cognos Connection with appropriate reports and security measures
Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
Used
Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
Data analyzed and created ad hoc reports using custom PL/SQL
Developing Prompt pages and Conditional Variables
Scheduled and Distributed Reports through Schedule Management in Cognos Connection
Trained Users on Query Studio for Ad-Hoc Reporting.
Created Cognos reports, prompts and layouts integrating with Java Script.
Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports
Designed multidimensional models using Transformer
Involved in Deploying reports, cubes and packages from Development to Production environment.
Maintained the packages and reports in development, test and production environment.
Environment: Cognos 8.2 and 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio),Cognos Report Net 1.1 MR2 (Framework Manager, Report Studio and Query Studio), Informatica Power Center/Power Exchange 8x, SSIS Oracle 10g, Flat files, Toad, SQL Developer,Cognos PowerPlay 7.2, Cognos Transformer 7.2, Oracle 9i, oracle10g (SQL, PL/SQL), SQL Server,DB2,Teradata
Client: IFC, the World Bank, Washington, DC Mar 2005 - Aug2007
Cognos/Report net Consultant
Description:
Capital, Pricing and Risk (CAPRI) system facilitates a new risk management framework at IFC, by providing tools to gather data, generate key empirical risk parameters and adapt industry methodology to suit IFC's needs. This framework and the system support formulation of potential policy changes and development of state of the art risk management tools for internal applications such as pricing, economic capital allocation, performance measurement, limit setting and financial planning. The key objective is to better serve the future needs of the Corporation, taking into account the need for flexibility to meet client needs and the Corporation's mandate, as well as the need to maintain profitability and risk levels consistent with a AAA credit rating
Responsibilities:
Installation of ReportNet 1.1 and Framework Manager 1.1, setting Cognos configuration and integrating different components were part of the project.
Communicated with the business users to comprehend the requirements.
Designed the reports and catalogs using impromptu as per the requirements.
Extensively used PowerPlay Transformer to convert the data into power cubes.
Modified Power Cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube models using reports modeled according to user needs.
Installed Cognos ReportNet and Framework Manager in an interim environment as a proof of concept.
Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
Created customized BI reports linking various databases, to meet the user requirements
Designed models using Framework Manager and deployed packages to the ReportNet Servers.
Created standard and Ad hoc reports using Cognos Query Studio.
Assigning work to the offshore team
Developed technical document for offshore team
Developed Templates, standard Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query studio. Provided training on Query Studio to create Ad-hoc Reports.
Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
Created Mapplets and used them in different Mappings.
Created events and tasks in the work flows using workflow manager
Provided production support by monitoring the processes running daily.
Created Schema objects like Indexes, Views, and Sequences.
Environment: Cognos Report Net 1.1/1.0x,Power Play Transformer7.0,Power Play Web 7.0,Visualizer 7.0,Upfront 7.0, Access Manager, Power Play Enterprise Server, Oracle 9i(SQL,PL/SQL), Windows NT,UNIX, Informatica Power Center 6.1, Oracle, DB2
Contact this candidate