Ambarish Patra

818-***-****, adioq4@r.postjobfree.com (email and Skype)

Work Summary

IBM Certified Cognos Developer with over 10+ years of IT experience focusing on Business Intelligence and Data Warehouse Applications.

Strong exposure in IBM Cognos Analytics (Framework Manager, Reporting, Dashboard, Visualization, Maps, Event Studio, Data Module etc).

Strong exposure on Cognos TM1 v9.5/v10.1

Good exposure on Cognos TM1 (TM1 Architect, TI processes, Rules, Planning Analytics Workspace (PAw) and Planning Analytics for Microsoft Excel (PAx).

Experienced in Performance Tuning, Application Development and in resolving all BI Production support issues on various platforms, using Data Warehouse tools including IBM Cognos 11/ 10.x/8.x.

Designing new reporting applications to ensure reporting requests that can be supported by the underlying data source by building star schema and snowflake schemas.

Identifying, building, and maintaining relationships with business process owners and colleagues and Collaborating with other software developers, business analysts and software architects to plan, design, develop, test, and maintain Cognos and Informatica based business applications.

Perform source system analysis, identification of key data issues, data profiling and development of normalized star and snowflake schemas.

Experience to create a solution roadmap based on cross-organizational planning and forecasting tool using Cognos TM1.

Good exposure on Createing ETL (Extraction, Transformation & Loading) processes using Turbo Integrator in Cognos TM1 performing business rule mappings of relational data into dimensional model.

Hands on ETL processes for creating dimensions and cubes, and loading data retrieving data from various data sources.

Worked on Designing dimensions, hierarchies, attributes, and cubes, creating cubes and cube rules associated.

Involved in creating Turbo Integrator (TI) programs to process data, writing system documentation.

Experience in Advanced Turbo Integrator scripting.

Extensively worked on Rules to apply business rules to a cube.

Experience in scheduling Turbo Integrator process using Chores.

Configuring and Designing dependencies and interrelationships between Cognos and other Data Warehouse and Business Intelligence tools and designs; Troubleshooting in the area with this knowledge with development and maintenance of relational databases along with development of processes and procedures for entering information into Data Warehousing systems and for ensuring reliability of information entered.

Good experience in creating Dimensional and Relational model using Framework Manager.

Responsible for conducting data investigations and assist the business partners with complex data analysis and ad-hoc queries along with developing data management best practices, including reporting, analytics, SQL, data modeling.

Worked on conversion project to convert business object reports to Cognos analytics by using Cognos tools and Business Object.

Strong complex reporting skills – complex Drill-Through, Cross- Tabs, Summary Reports and Burst Reports, Dashboard, Map, Visualization, Active reports.

Performing data warehouse design and testing, including data design, database architecture, Metadata, repository creation, data warehouse schematics layouts, and capacity planning by using Informatica, Power Designer, Cognos Framework Manager Model adhering to all Metadata management and data quality standards by leading quality management reviews.

Responsible for overall designing, creating, and testing different Cognos reporting application and provide solution with identification of changes in scope or work effort that could result in budgetary overrun or the missing of delivery date and design.

Well- versed in understanding OLTP data and in developing OLAP multi- dimensional data structure.

Working with the ETL architect to understand the flow of data from OLTP system to the OLAP system.

Experienced in Data Warehouse, Data Mart Concepts, Methodologies on ODS, Star and Snowflake schemas, Data Lake.

Developing data management best practices, including reporting, analytics, SQL, multi layer data modeling, data management, file management, reference data management.

Hands on exposure on DB2 and Oracle database.

Analyzing and writing complex SQL code to build procedures and views and use them as data source to develop Framework Manager Model for querying and development of reports and data analytics.

Tuning existing SQL Code along with other performance tuning methods like using cache memory, using indexes, avoiding cross join and many to many relationships to enhance the faster data processing.

Good exposure on various database objects like schemas, views, Synonyms, materialize views, trigger, cursor, tables, stored procedures, indexes, table spaces etc.

Have used tools like Toad, SQL Developer, Advance Query Tools etc.

Have exposure on job scheduling tools like Tivoli Work Scheduler, Control-M, Autosys (CA Workload Automation).

Use code versioning tool Motio-CI for version control and code deployment from lower environment to production environment.

Providing new design methodologies for legacy applications based on best practices for Business Intelligence and Cognos toolset functionality to maintain industry standard dashboard and reporting.

Hands on experience on sql / plsql language and UNIX shell scripting.

Developing Business Intelligence application products and deliverables throughout development life cycle, including model prototype design in Framework Manager and other design and development activities with the Cognos toolset

Building in-memory OLAP dynamic cube using Cognos Cube Designer and experience in performing OLTP data and developing OLAP multi- dimensional data structure.

Provide enterprise-scale architecture design solution to business for end to end process automation of data flow from various legacy data sources to report authoring

High initiative, self- motivated with excellent communication, analytical and presentation skills, willingness and ability to quickly adapt to new environment and learn new technologies.

Certifications:

Business Analytics -

IBM Certified Developer - Cognos 10 BI Metadata Models

IBM Certified Designer - Cognos 10 BI Reports

Information Management -

IBM Certified Database Administrator – DB2 Universal Database v8.1 for Linux, UNIX and Windows

IBM Certified Database Associate – DB2 Universal Database v8.1 Family

Expertise in Operating System / Tools & Technology / Languages, etc:

BI Tools – IBM Cognos BI v11.x, v10.x & v8.4 (Framework Manager, Report Studio, Dashboard, Data Module, Analysis Studio, Query Studio, Event Studio, Cognos Workspace and Workspace Advance), Cognos Cube

Financial Planning Tools - TM1 v9.5 & v10.1 (TM1 Architect, TI processes, Rules)

ETL Tools – Informatica PowerCenter v10 (Designer, Workflow Manager, Workflow Monitor)

Database – Db2 (v11, v9, v8), Oracle 12c, SQL Server 2012

Jo Scheduling Tool – CA Workload Automation v11, Control-M, Tivoli Workload Scheduler

Version Control Tools – Motio-CI

Other Tools - Advanced Query Tool (v9, v7), Toad

Operating System – Windows XP, 2007, AIX, UNIX

Programming Language - SQL, PL / SQL, UNIX Shell Script

Project Work Experience:

American Electric Power (Columbus, Ohio)

(September 2019 - Present, consultant at Intuites LLC)

American Electric Power (AEP) is a major electric utility in the United States of America, delivering electricity to more than five million customers in 11 states. AEP ranks among the nation's largest generators of electricity; AEP also owns the nation's largest electricity transmission system. AEP ranked 185th on the 2018 Fortune 500 of the largest United States corporations by revenue

Roles and responsibilities:

Designing, building & delivering Business Intelligence solutions using Cognos Analytics 11.x and working with DBAs, and system administrators to track down and improve or eliminate bottlenecks in the Business Intelligence reporting.

Develop TI process to import data directly from various data sources as flat file and map them into TM1 cube.

Implement complex business rules in TM1. Worked on PAX and PAW.

Use chore in TM1 to automate processes. Enhance different dimensions levels in TM1.

Design, develop, and implement Cognos TM1 and Cognos BI solutions for financial planning and budgeting projects using Turbo Integrator (TI) and complex business rules.

Extensively used TI for loading data into Dimensions and Cubes, added new dimensions and cubes to existing environment.

Developed TM1 application to gather and consolidate data in support of the foot notes in the annual report.

Manage TM1 data through TM1 Reports (Active Form & Slice).

Created and arranged different TM1 rule statements and performed complex calculations for cubes

Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.

Deployed the TM1 data into production environment.

Use Cognos TM1 cubes for different level of data validation with different types of business rules.

Have exposure work with Database Administrator, Data Management and DB2 database Specialists to find the root causes for data issue and troubleshoot and report issues.

Analyzing and writing complex SQL code to build procedures and views and use them as data source to develop Framework Manager Model for querying and development of reports and data analytics.

Creating multi-dimensional data models by querying complex data structures using SQL.

Working with business users to define new cognos requirements, including gathering requirements, documenting requirements, data mappings, unit testing and user acceptance testing.

Developing full project lifecycle with the Cognos Products like Cognos 11.X Framework Manager, Report Studio, Dashboard.

Developing, and optimizing stored procedures, functions, SQL, PL/SQL, database structures, and ETL processes adapt to changes in needs and requirements

Creating Active Reports using different sophisticated Cognos features like Charts, Visualizations, and Crosstabs with Data Decks, Button Bars, List Boxes, and Check Boxes.

Developing and designing code for reports with Query Subject from Stored Procedures, views which are published through Framework manager model as packages.

Responsible for the preparation of the time estimation reports which involve estimations for the time required to develop the new cognos reports, dashboard, Framework Manager models, Informatica process for data mapping and transformation.

Working with SQL to understand and interpret data transformation code and implement that Business logic in Cognos Framework Manager Model for sophisticated report authoring.

Developing and implementing Cognos security models to provide security of sensitive Business Information and grant access to stakeholders in different line of business

Creating reports, dashboards, scorecards in Cognos Report Studio and Framework Manager as well as ad hoc reports for internal Business Intelligence team and external customers.

Working with Business to ensure a smooth transition from requirements to development to testing to production deployment.

Designing and Developing Data Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (creating Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (creating presentation catalogs), creating presentation folders, testing and validating the model.

Migrating the Cognos reports and Framework models from one instance of Cognos to the other using Motio CI tool and upgrading the existing content on Cognos to the latest version of Cognos

Drafting and maintaining Business requirements and aligning them with function and technical requirements.

Developing interactive and static reports as well Active Reports using Cognos toolset like Report Studio, Data Module, Visualization, Dashboard, and Event Studio

Developing, maintaining appropriate documentation on reports, dashboards, scorecards, during the Project Development Lifecycle and Designing the portal framework as per the roadmap.

Developing various dimensional (DMR) and relational reports by deploying lists, crosstabs, charts, union, joins, burst, drill up/down reporting techniques

Creating Business units’ flow of the data and the tasks and workflows in the task and workflow managers respectively.

Configuring and Designing dependencies and interrelationships between Cognos and other Data Warehouse and Business Intelligence tools and designs; Troubleshooting in the area with this knowledge with development and maintenance of relational databases along with development of processes and procedures for entering information into Data Warehousing systems and for ensuring reliability of information entered.

Performing complex data models and mappings, prevention of unions, stitches and nested datasets to enhance performance of applications

Analyzing logs and reports to create reports from the Database layer (also called materialized views) to speed up larger queries.

Using Debugger to validate Mappings by creating breakpoints to analyze and monitor Data flow.

Performing SDK and the use of java script and HTML in Cognos 11.X and integrating Cognos with other web portals.

Maintaining and curating a central repository of enterprise Business Intelligence assets including dashboards, visualization and interactive reports

Enabling capabilities available in the Business Intelligence technology such as drill-through functionality, KPI and scorecard reporting, advanced visualizations including mapping and geospatial analysis, predictive analytics, and other capabilities as arise.

Providing analysis, design, development, testing and implementation of Business Intelligence, Ad-hoc and Operational Reporting along with troubleshooting any technical issues within SLA timeline that the program may have.

Developing Data models, Data mappings, Data migrations and assisting in Data Warehouse design in Oracle environment for Cognos report authoring

Responsible for the development and implementation of interactive reports for our Line of Business partners using the IBM Cognos Analytic suites. This included following an agile SDLC project management process.

Correcting customizations of Data Warehouse, reports and in Dashboards.

Debugging complex SQL queries.

Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence suite.

Designing and developing enterprise and departmental Business Intelligence and Data Warehousing solutions by Supporting and improving production Data Integration System.

Interacting with architects and end users in mapping data from legacy systems to Data Warehouse.

Tools and Technology used:

TM1 10 (Architect, Turbo Integrator, Rules), Cognos BI 11 (Framework Manager, Report Studio, Dashboard, Data Module etc), Db2 11, Advanced Query Tool v9, Windows XP & UNIX server

American Modern Insurance Group (Amelia, Ohio)

(August 2015 – September 2019, consultant at Brite Systems Inc)

American Modern Insurance Group, Inc., operating under the American Modern® insurance brand, is the holding company for a number of subsidiary property and casualty insurance companies that provide specialty products for owners of a variety of specialty dwellings such as seasonal homes and mobile homes, and collectable or recreational vehicles such as watercraft, snowmobiles and motorcycles. American Modern's ultimate parent is Munich Re, one of the 100 largest companies in the world in annual revenue. It is part of Munich Re's primary insurance operations in the United States.

Roles and responsibilities:

Designing, creating and implementing multi layer (Database Layer, Logical Layer, Symantec Layer etc) data models in Data Warehouses, transactional databases and ETL using datastage pipelines gathering data requirements through analysis of system data, analysis of business processes.

Designing and building a semantic model with a scalable physical, logical and Presentation layers in Cognos Framework Model and publish packages in into Cognos portal for report development and data analysis.

Performing Data Warehouse design and testing, including data design, Database architecture, metadata, repository creation, data warehouse schematics, layouts, and capacity planning by using Cognos Framework Manager Model

Monitoring security and performance of Cognos 11.x analytics on regular basis

Effectively communicating and collaborating with cross-functional business partners and made them understand the flexibility the Cognos BI tool has to offer.

Design, develop, and implement Cognos TM1 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.

Scheduled Chores and Monitored Data Loads on timely manner.

Created TI Processes to transfer currency data to currency cube.

Created rules to transfer data between cubes.

Used TM1 rules editor to create and edit rule to create various calculations.

Used Replication to copy the Cubes from one server to other server.

Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using TurboIntegrator.

Import the data from ODBC and Text files using TM1 Turbo integrator.

Working with Line of Business partners on multiple occasions to create requirements for IBM cognos BI reporting solutions

Designing and creating different processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform by following the best practices for ETL process development and table design, including new sources of data into the data warehouse, modifying existing processes to bring more data in and maintaining the existing data warehouse infrastructure.

Design and Develop Cognos Framework Manger model using tables, views, synonyms, stored procedures and published to different Cognos server

Write complex programming in IBM Cognos using different types of statistical functions for more sophisticated data analysis

Design, develop, and unit test applications in accordance with established standards with high standards of software quality by developing, refining, and tuning integrations between applications.

Developing technical specifications to resolve business client questions, problems, and to address enhancement needs by coding, decoding and debugging, analyzing and working on complex and cross-functional IT and business intelligence solutions.

Creating, maintaining, enhancing, and updating technical and critical software development program using IBM Cognos Analytics, Framework Manager, Oracle Database, and SQL Developer.

Develop and design code for reports with Query Subject from various database objects which are published through Framework manager model as packages;

Involve in data error and bug fixing activities for the existing reports and dashboards

Design and develop different types of complex dashboard and score card for business user.

Develop various dimensional (DMR) and relational reports by deploying lists, crosstabs, charts, union, joins, burst, drill up/down reporting techniques.

Generate reports using various sophisticated analytical mechanism such as drill through definition, master-details, crosstab, graphs and charts etc.

Develop active reports so that user can see data by dynamic value selection.

Define Developer and Test Methodology to carry out the development schedule.

Analyze and Design document for the Impact and Risk involvement for all the new releases;

Write UNIX shell scripts for system automation.

Use Control-M tools for various jobs scheduling architecture including dependencies.

Collect requirements from business analyst and translated them to technical specs.

As part of data science analyze the existing Database and Data Warehouse / DataMart for report requirements.

Use Cognos TM1 cubes for different level of data validation with different types of business rules.

Involve in defining the source definitions and Target Definitions and created mapping.

Involve in various types of data mining for business transformation.

Create SQL and procedural language (stored procedures) as per business requirement.

Validate stored procedures and deployment testing before releasing to stakeholders.

Handle and fix bugs in .various job streams, jobs and batch files i.e. bug fixing of any error occurs during the ETL Process and production release.

Converting numerous Cognos Data Module based reports and dashboards to rich Cognos visualizations.

Implementing Cognos projects that span the full life cycle from user requirements gathering, analysis and database design to implementation. functional and technical development in support of comprehensive report development from corporate data sources.

Providing functional and technical development in support of comprehensive report development from corporate data sources

Developing Cognos reports and dashboards and ensuring they are tested in the development and test environments before being moved to production.

Conducting IBM Cognos training sessions for client's team

Generating reports using various sophisticated analytical mechanisms such as drill through definition, master-details, crosstab, graphs and charts etc.

Developing active reports so that users can see data by dynamic value selection

Tools and Technology used:

Cognos BI 11, 10.x (Framework Manager, Report Studio, Dashboard, Analysis Studio, Active Reports, Data Module etc), TM1 10, Transformer, Oracle 12c, SQL Developer, Control M scheduler, Windows XP & UNIX server.

Republic Indemnity (Encino, California)

(January 2015 - August 2015, consultant at HCL America Inc)

Republic Indemnity Company of America and Republic Indemnity Company of California are members of Great American Insurance Group and subsidiaries of American Financial Group, Inc., which is a publicly traded company on the New York Stock Exchange. Republic Indemnity provides workers’ compensation coverage to businesses in all of the Western States of USA.

Roles and responsibilities:

Analyze the existing database and Data Warehouse / Data Mart for report requirements.

Work along with the ETL team to understand the flow of data from OLTP system to the OLAP system.

Involved in Defining the Source Definitions and Target Definitions and created mapping.

Created Projects, Models, and Packages using Cognos Framework Manager as required for the report development.

Published packages on Cognos Connection as required for reporting.

Developed and maintained Framework Manager Models and apply proper securities while publishing packages.

Develop various types of query subjects like data source / model / stored procedures query subjects and query items and use those objects to build reports for specific report needs.

Interacted with business and technical users to gather requirements and created design document.

Exposure on building in-memory OLAP dynamic cube using Cognos Cube Designer.

Develop various dimensional (DMR) and relational reports by deploying lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill up/down reporting techniques.

Involve in creation of analytical reports, modifications to existing reports in Base Product.

Developed complex prompt/cascade prompt reports and dimensional reports using different features like Drill capabilities, queries, Master detail and cross tab tables with features like multiple page set/breaks, pagination etc.

Create different Dashboards in report studio using combination of List, Crosstab, Chat and Map reports.

Have exposure on Cognos Workspace and Cognos Workspace Advance.

Developed UTC (unit test cases) and helped Business Partners in UAT (user acceptance test cases) documentation as part of testing.

Handle pre implementation and post implementation issues as part of implementation process.

Handle Production Support issues

Tools and Technology used:

Cognos BI 10.2 (Framework Manager, Dashboard, Report Studio, Analysis Studio, Active Reports), SQL Server 2012 Management Studio, Windows 2007 server

Timberland Co. (India)

(January 2014 - November 2014, consultant at HCL Technologies)

Timberland LLC is an American manufacturer and retailer of outdoors wear, with a focus on footwear. It is owned by VF Corporation. Timberland footwear is marketed towards people intending outdoor use.

Roles and responsibilities:

Worked with Business users to analyze the business process and user requirements.

Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.

Design, develop, and implement Cognos TM1 9.5 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.

Created temporary Views, Subsets using Turbo Integrator and populated data.

Created complex Active Forms and enhanced the performance of existing Active forms.

Scheduled Chores and Monitored Data Loads on timely manner.

Created rules to transfer data between cubes.

Used TM1 rules editor to create and edit rule to create various calculations.

Used Replication to copy the Cubes from one server to another server.

Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using Turbo Integrator.

Import the data from ODBC and Text files using TM1 Turbo integrator.

Provided the What If Analysis facility to users to get desired output by changing parameters.

Reviewed Business Requirement Document (BRD) for Completeness, Gather and analyze financial planning, budgeting and reporting requirements.

Performed Unit Testing and User Acceptance Testing

Designed Relational and DMR models using Framework Manager and deployed packages to the Cognos Connection.

Generated multiple Enterprise reports using Cognos from SQL Server Data Mart and included various reporting features such as group by, drilldowns, drill through, sub-reports.

Created database layer and business layer, defining start schema by creating appropriate relationship between query subjects in Framework Manager.

Created various complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.

Customized data by adding various types of Prompts, Filters, Calculations, Summaries and Functions/Macros.

Delivered Advanced Multidimensional Reporting solutions using Report Studio.

Developed Dashboard Portals and integrated multiple Cognos reports onto a single Dashboard Page.

Customized Reports by writing complex custom SQL.

Designed, Created and managed jobs scheduling.

Tools and Technology used:

Cognos 10 Suits (Framework Manager, Cognos Connection, Query Studio, Report Studio, Analysis Studio etc), TM1 9.5 (Contributor, Perspectives and Turbo Integrator), Oracle, Windows 2003 Server.

EMI Music (India)

(March 2010 - December 2013, consultant at HCL Technologies)

EMI Group Limited (also referred to as EMI Records Ltd. or simply EMI) was a British Transnational conglomerate founded in March 1931 in London. At the time of its break-up in 2012, it was the fourth largest business group and record label conglomerate in the music industry, and was one of the big four record companies (now the big three); its labels included EMI Records, Virgin Records, and Capitol Records, which are now owned by other companies.

Roles and responsibilities:

Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.4

Designed multidimensional models in Framework Manager.

Understood data and business logic underlying the business requirements.

Created Projects, Models, and Packages using Cognos Framework Manager and published Packages to Cognos Connection.

Created and established Joins / cardinality between the tables in the application layer.

Designed and applied conditions and based on business functionality as per requirements.

Developed Drill up/ Dill Down, Master details reports for dashboards.

Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.

Created charts, lists and crosstab reports using Report Studio and ad hoc reports using Query Studio.

Worked with business partners in understanding business requirements to create design and technical documents.

Designed and developed Relational and Dimensional models for analysis.

Manually tested the application based on software requirements specifications.

Performed Backend Testing by executing SQL Queries statements.

Performed the Data validation to meet all test condition requirements

Developed SQL queries to test the Database values for data Integrity

Creating SQL and Stored Procedures as per business requirement.

Communication with client to understand future requirements and perform fit gap analysis.

Handling and fixing the bugs in Job Streams, Jobs and Batch Files.

Design, develop, tests, debugs, implements, and documents moderately complex software component using UNIX shell scripts, AIX 5.3L Operating System and Database technology DB2 UDB V8 to perform ETL (Extract – Transform –Load) operations

Contact this candidate