Nageswara Rao Nuthankihttp://www.bisource.com/cognos.html

469-***-****

Email: ad24vy@r.postjobfree.com

Professional Summary:

Over 18 Years of total IT experience and technical proficiency in Data Analytics, Business Intelligence, and Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.

Extensive experience in Power BI/MSBI/IBM Cognos Analytics 11.x / Cognos BI 10.x, Framework Manager and Data Modules as an administrator, modeler, and report developer, and extensively used Informatica PowerCenter with Power connect for SAP R/3 to develop Mappings.

Experience in using Motio CI for automates the deployment of build process.

Experience in ETL by using Informatica and IBM Cognos Data Manager with production support.

Have Good Experience on Creating Cubes and Powerplay reports by using Powerplay Transformer, Powerplay, Framework Manager and Analysis Studio

Experience in creating dashboards in Qlik Sense, and the deployment of dashboards in Qlik QMC, QVD Generator, task scheduling and triggering, and section access.

Data processing experience in designing and implementation of data mart applications, mainly transformation processes using MSBI Suite/Informatica.

Good exposure in maintenance and administration of SSIS by creating jobs, alerts, SQL Mail Agent, and schedule DTS/SSIS Packages

Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.

Good exposure in creating various reports like Drill Down, Drill through, Parameterized.

Experience In creating Power BI reports and dashboards using database, Excel Data, and various sources like Oracle, Azure and Snowflake. Publishing reports into Power BI Service Workspace. Report builder has been used to create paginated reports.

Experience in creating calculated columns and measures using DAX and multiple filters using Slicers in Power BI, and used Power Apps and Power Automate.

Experience in development and implementation of SSIS, SSRS and SSAS application solutions.

Experience in Tableau server installs, configures, manages, and maintains the Tableau Server or Tableau Bridge is installed in the data center.

Experience in Tableau Server, Tableau Site Administrators create and manage the site's users and groups, create projects to organize content on the site, and assign permissions to allow users (groups) to access the content. And developed the dashboards using with Tableau Desktop.

Strong knowledge with databases using Oracle, SQL Server.

Experienced in domains like Supply Chain Management and Logistics (TMS), Mobile device manufacturing and Manufacturing BI Reporting and Data Warehousing projects.

Experienced in client interaction and understanding business application, business dataflow and data relation from them.

Extensively involved in identifying performance bottlenecks in Reports and successfully tunes them for maximum performance using best practices.

Experience in Microsoft Master Data Services (MDS) database in SQL Server and used Informatica MDM(Master Data Management) for data extraction.

Knowledge on Python libraries like Pandas, Numpy, Matplotlib (Exploratory Data Analysis) and Big Data technologies like HDFS, Pig, Hive, HBase, Kafka, Oozie, Spark, Scala and PySpark.

Strong team player with excellent analytical skills with the ability to solve complex analytics systems, reporting issues, interpersonal and communication skills along with the ability to provide support to technical teams and business user.

Interacted with End Users and prepared requirement specifications.

Strong organizational and multi-tasking skills as well as the ability to cope with the fast-paced and challenging work environment.

Education:

Masters in Computer Science from Madras University in 2003.

B.Sc in Computer Science from Nagarjuna University in 2001.

Certifications

Microsoft Certified: Azure Fundamentals

Microsoft Certified: Power BI Data Analyst

Certified Scrum Mater

BDA – Telecom equipment and Networks (TCS internal)

IBM Certified Developer Cognos TM1 10.1

ITIL Foundation

IBM Certified Cognos BI Professional – Cognos 10 BI

IBM Certified Administrator – Cognos 10 BI

IBM Certified Developer - Cognos 10 BI Metadata Models

IBM Certified Designer - Cognos 10 BI Reports

Technical Skills:

BI Tools: IBM Cognos Analytics, IBM Cognos Business Intelligence (Report Studio, Query Studio, Event Studio and Analysis Studio), Cognos TM1, Cognos Report Net, Framework Manager, Data Modules, Powerplay Transformer, Web Explorer, Cognos Go! Mobile, Cognos Go! Office, Simba, Tableau, Power BI, SSRS, SSAS, Qlik View/Qlik Sense and WebFocus (Developer Studio).

ETL Tools: Informatica Power Center, Cognos Data Manager, Decision Point Warehouse Administrator, SSIS, Oracle analytical workspace manager (AWM), SIMBA, Azure, Snowflake.

Authentication Tools: Custom Java Authentication Provider, Access Manger Administrator, SunOne

Java, ODSEE

Cloud: AWS–EC2, Azure(ADLS, Synapse Analytics,ADF, Azure SQL DB,) and Snowflake.

Web Server: IIS, Apache.

Databases: Oracle, SQL Server and SAP R/3

GUI Tools: TOAD, PL/SQL Developer, SQL Developer, SQL Server Management Studio

Operating Systems: Linux/Unix & Windows

Professional Experience:

ADPH (Alabama Department of Public Health), IMM Reporting, Bruhat Technologies

Role: Consultant (Sr. BI/SQL Developer)

Project Location: Montgomery, AL Apr 2003 –Till Date

Responsibilities

Collecting and transforming end-user requirements into effective and efficient dashboards using Power BI.

Create Data models in Power BI and maintaining the power BI Server.

Performed data modeling, transformation, and cleansing using Power Query and DAX.

Create Different reports/Dashboards with Power BI Desktop and proficient in advance level calculations on the data set.

Developed tabular and multidimensional models, visual reports, dashboards, and KPI scorecards using Power BI desktop.

Implemented and maintained the security workspace, report level and row level security.

Published reports into the Power BI server and scheduled the datasets, provided row-level Security.

Extensively used SSMS, SSRS, SSAS to developed tabular reports (visual studio), and used T- SQL to develop stored procedures for reports.

Created report layouts, data queries, visualization components and configured report parameters, formatting, and interactive features to enhance user experience using SSRS tool.

Designed and developed SQL Server databases, including tables, views, stored procedures, functions, complex SQL queries and optimizing database performance.

Ability to understand medium to complex SSIS packages and extensive knowledge and experience in developing pipelines in SSIS.

Involved in Database migration from Oracle to SQL Server and tested dashboards and reports.

E2 Analytics, Transport Management System (SCM Products: KT- TMS and TMS4S),

e2open(Blujay Solutions)

Role: Development Lead Jan 2018 – Mar 2023

Project Location: USA (Holland, MI)

Responsibilities

Cognos Analytics upgrade to 11.1.7 on Linux environment with FP6(Installations and configurations).

Worked on datacenter migration for Cognos BI Reporting instance and ETL (IBM Cognos Data Manager) to deploy the new datacenter with OS and JDK upgraded to latest versions.

Creating Data Modules and Data Set which is the new feature of Cognos Analytics for web based modeling.

Import data design the model using Data Modules and Framework Manager.

Leveraging data visualization tools for senior management and enterprise data visualization.

Monitoring the status of the scheduled jobs and report and fix the issues if any encountered.

Creating Reports, Data visualizations and Dashboards using Cognos Analytics 11.x.

Leveraging data visualization tools for senior management and enterprise data visualization.

Administering the Cognos like implementing the securities, creating groups and give the access permissions to the users.

Creating Metadata Model based on the technical specification documents using Framework Manager.

Implementing data security, object security and package security in Framework Manager.

Designed and develop Qlik sense apps (reports, visualizations, and dashboards), model changes as per business requirement and implemented change requests.

QVD generator configuration to build the qvds from excel configuration file.

Manage the operational process for Qlik Sense, including optimisation reload tasks, QVD management, access controls and other processes on QMC.

Migrated Cognos Dashboards to Power BI with various data sources like Oracle and Snowflake.

Extensively used SnowSQL to integrate from Power BI - Power Query, as part of EDW data migration from IBM Data Manager ETL processes to Snowflake’s Etleap pipeline.

UNISTORE has been used ODS and EDW data completely moved to snowflake.

Collecting and transforming end-user requirements into effective and efficient dashboards using Power BI.

Create Data models in Power BI and maintaining the power BI Server.

Create Different reports/Dashboards with Power BI Desktop and proficient in advance level calculations on the data set.

Developed tabular and multidimensional models, visual reports, dashboards, and KPI scorecards using Power BI desktop.

Extensively used Power Pivot, Power Query, and Power View and DAX queries in Power BI desktop. Designing and Integration of Power Apps for write back functionality.

Published reports into the Power BI server and scheduled the datasets, provided row-level Security.

Actively worked on report development, Framework Manager modeling and administration.

JIRA dashboard has been developed for higher management in Cognos analytics.

Code deployments and UAT and Production Support issues with on-call support.

Worked on WebFocus – Developer studio to develop new reports as part of Jreports to WebFocus migration.

Data Manager ETL Jobs monitoring and production support. Data full refreshment due to hardcodes in existing ETL processes.

Environment: Cognos Analytics 11.1.1, Cognos BI Suit 10.2.1, Power BI, Oracle12c, Framework Manager, SQL Developer, Power BI, WebFocus Developer Studio, Data Manager, Jenkins, WinSCP, Jreport designer,Qlik Sense and Kafka, Linux, Windows10, Oracle 12c, 19c.

RSI (Republic Services) BI Reporting, Delta technologies and management services

Role: Sr. Software Engineer Jan 2017 – Jan 2018

Project Location: USA (Phoenix, AZ)

Cognos upgrade to 11.0.6 with FP2.

Developed dashboard and complex reports, along with production support issues.

Experience in using the Motio CI to automate the deployment of build process.

Daily health check and server monitoring.

Performance tuning on poor performance reports.

Used SSIS high-performance data integration solutions, including extraction, transformation and load (ETL) packages for data warehousing.

Extensively used Control Flow, Data Flow, Event Handler, Package Explorer and Parameters components in SSIS.

Developed reports using Microsoft Reporting Services (SSRS) from a variety of data sources including Analysis Services (SSAS) Cubes and relational databases.

Created cube partitions for better performance of the cube in SSAS

Tuned the Migrated Report Builder Reports.

Created the Data Model’s in the Power BI.

Created the Dashboards for the different subject areas.

Created the ETL Packages using SSIS.

Team coordination and report review of all deliverables done by team before moving to UAT and Production.

Developed dashboards in Qlik sense.

Created and managed data connections, tasks, triggers, and apps deployment in QMC.

Configure and administer Qlik Sense using Qlik Management Console (QMC)

Shut down Qlik servers on windows box in case of any major database server upgrade or Qlik box upgrade and verified the functionality and integrity of the server on the restoration of Servers.

Environment: Cognos Analytics 11.0.6, IBM Cognos BI Suit 10.2.2, Framework Manager, Qlik Sense, Cognos Transformer, SSIS, SSRS, SSAS, PL/SQL Developer, TOAD, Windows Server 2008 and Oracle12c.

Blackberry, Research In Motion (RIM) – TCS

Migration project: Cognos 10.1.1 to Cognos 10.2.2, FP4.

Cognos TM1 Support, Tableau admin support, MFGWEB Support, HUB Consolidation project,

Migration project: Cognos 8.4.1 to Cognos 10.1,

MFG Reporting, KPI Dashboards, RIM – MAQR (Data Warehouse)

Role: Tech Lead/ Associate consultant Sep-2008 to Aug-2016

Project Location: Canada (Waterloo/Mississauga)

Experience in designing and implementing the architecture on Windows servers.

Installations and Configurations, and load balancing on production servers. Identify and resolve the product issues.

Implementation in authentication and authorization mechanisms using LDAP servers and single sign on tools.

Performance monitoring and tuning.

Regular health check of servers across various environments.

Root cause analysis for performance and tool limitation issues.

Setup the Cognos Audit package to view the information in a logging database about users and report activity.

Implemented Go! Mobile on Cognos environments to view the BI reports on users Blackberry mobiles.

Involved in operational activities like set up the user security using Sun Java to create the new user accounts and assigning appropriate permissions.

Study of existing Manufacturing Quality Assurance reporting system and users requirements for business analysis.

Involved to prepare the Technical Specification Documents for BI Reports as per business requirements.

Analysis & study of existing metadata & restructured the same using framework manager model.

Created Standard Reports using Report Studio like List Reports, Repeater and Chart Reports with Drill-Through functionality.

Developed Complex Reports using Cascading Prompts, Conditional Variables, conditional blocks and Data Formatting properties.

Build dimensional model by using Cognos Transformer and created dashboards using analysis studio.

Worked and managed the Onsite - Offshore team to complete migration on time.

Involved in resource selection and mentor team members on IBM Cognos BI 8.4.1/10.1.1suites to support the project.

Peer reviewed all deliverables done by team before moving to UAT and Production.

Upgraded the Cognos environments to 8.2.2 to 8.4.1, 8.4.1 to 10.1.1 and 10.1.1 to 10.2.2.

Developed the mappings to extract data from Oracle and SAP systems to DW.

Experience with Tableau Administration to understand environment health, monitor jobs, stop/start services, installation/upgrades and configuration of Tableau, configuration changes, performance tuning.

Experience in Tableau to debug issues at the server level, resolved performance issues.

Designed and developed Tableau dashboards. Utilized data blending activities for Tableau functionalities.

Handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Sequence generator, Update Strategy, Expression and Sorter etc.

Created reusable transformations and mapplets.

Extensively used workflow manager to create Sessions and run the Workflows

Involved in execute and monitor the data load batch processes.

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

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

Performed Unit Testing and User Acceptance Testing.

Eaton – TCO, Electrical: Truck BI support Project (CIS / RWS BI Support) - TCS

Role: Cognos developer/Consultant Jul-2006 to Sep -2008

Project Location: USA (Galesburg, MI)

Understand the existing Business Intelligence and Data Warehousing environment.

Understand the specification documents for Reports as per client requirements.

Involved in analyzing the Framework Manager model and validating.

Created Standard Reports using Report Studio like List Reports, Crosstab Reports, and Chart Reports with Drill-Through functionality.

Developed Complex Reports using Cascading Prompts, Conditional Variables, and Data Formatting properties.

Involved to monitor the weekly and monthly scheduled reports as per user’s requirement.

Involved in Unit Testing of Reports.

Involved in identifying the root cause of poor performance reports and improved the report performances.

Under supporting activities involved in monitoring ETL jobs and quick resolution to failed jobs which are scheduled jobs in Decision Point Warehouse Administrator.

Worked with Onsite team to complete regular change requests to deploy to production instance.

Used Powerplay Transformer to create the logical models and build the power cubes.

Used Access Manager Administrator to create the new user accounts and gives the required permissions to user.

Data warehouse for NXI, AREVA T&D - TCS

Role: ETL Developer (Informatica) Jan-2006 to June-2006

Project Location: France/India

Developed the mappings in Informatica that caters the Extraction Transform and Loading from various source systems to target systems.

Defined Source and Target Definitions in Informatica.

Developed mapping using Informatica power Centre Designer to load data from Oracle and Flat file Source system to Target database.

Developed mapping to fetch data from SAP R/3 to Oracle database.

Worked on Informatica tool and handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, and Sequence generator, Update Strategy, Expression and Sorter etc.

Created reusable transformations and mapplets.

Extensively used workflow manager to create Sessions and run the Workflows.

Worked with Onsite – Offshore team to deliver the project on time.

Execute and monitor the data load batch processes.

Involved in unit testing for individual mappings.

Prepared Unit test case and test results.

Timely resolution of global user base issues.

Contact this candidate