Career Summary

Around **+ yrs. of experience in Software Development including 13+ yrs. of experience in Data Warehousing.

Good knowledge of Data modelling and Data ware house models

Working knowledge on Oracle, Sql Server, DB2 and IBM Netezza,Teradata,AWS

Experience in Data Visualization with Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 2019,2018,2022, Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown cross different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform

Having hands on experience of Cognos Server and Portal administration, installation of various Cognos products on windows environment and Unix environments

Hands on Experience on the migration of Cognos Business Intelligence 7.4/8.1/10 cubes and reports to Cognos 8.4 and 10 environments, V11

Hands on Experience on SDLC process, Requirements gathering, Analysis, Technical specifications and project related docs

Hands on Modeling Business Layer using Cognos Business Intelligence Framework Manager for dimensional and relational models

Has experience in requirement analysis, design, developing and testing various types of reports for various projects ranging from simple to complex reports and dashboards.

Experience in designing and development of reports using Cognos Series 7 and Cognos 8 and 10 Suite of products, CognosV11 Analytics

Good knowledge in Cognos Business Intelligence Transformer cube design, builds Analysis Studio for multi-dimensional reporting.

Having experience in Cognos Installation and configuration of Cognos 8 and 10 on stand-alone and distributed environment

Automation of cube builds process and deployments, Automation using shell scripts and batch scripts

Good conceptual knowledge in Data Warehousing, OLAP and report generation using COGNOS – (8, 8, 10, Report Net, Impromptu, Transformer 7.3,8,10, Power play studio, Cognos Workspace and Workspace Advanced), Cognos V11 Analytics

Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.

Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.

Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.

Efficient management of Tableau Server by managing & setting permissions, publishing various data sources, troubleshooting and ex and workbooks to Tableau Server.

Having good working experience in Cognos BI, Crystal reports, Informatica, OWB,SSIS,Business Objects,SSRS,PowerBI,Power Apps, DAX functions and visualizations Tableau 10+,2018,2019,2022 Tableau prep, Alteryx

Working knowledge on Tableau prep tool

Good Sql and pl/sql coding skills using Toad and Aginity Workbench on Oracle, SqlServer,IBM DB2Netezza and DB2 Visualizer

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, data blending, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters and security implementation in Tableau dashboards

Professional Experience

BI Development – Genentech, South SFO, CA.

June 2019 to till date

Project: BI Development

Description: CTO (Clinical Trial Optimization) is the Site Selection application to cater the organization need across US and global markets and also involves Sites, Studies and Principal Investigators and various other business areas involving multiple departments.

Role: BI Lead Developer & Solutions LEAD

Tools and Technologies: Windows 2012 Server, Tableau 2018, 2019, 2022, Toad, Oracle, JIRA, Thoughtspot Agile, PowerBI, Power Apps

Study, analyze and understand business requirements in context to business intelligence.

Design and map data models to shift raw data into meaningful insights.

Utilize Power BI to build interactive and visually appealing dashboards and reports.

Spot key performance indicators with apt objectives

Analyze pervious and present data for better decision making

Transform business requirements into technical publications

Build multi-dimensional data models

Develop strong data documentation about algorithms, parameters, models

Perform detailed analysis on tested and deployed Power BI scripts

Run DAX queries and functions in Power BI

Upgradation of Tableau dashboards to latest versions

Fixes and security implementation on existing tableau dashboards.

Securing of the dashboards and deployment to production environment

Schedule and dashboard refresh of the Tableau, PowerBI

Performance tuning and optimal design of the dashboards and Code review

Collaboration with various teams on requirements

Re-design and optimize to match/improve performance of the application

Securing of Tableau dashboards to sync with enterprise level security

Unit testing and data accuracy testing of the and reports

Study, analyze and understand business requirements in context to business intelligence.

Design and map data models to shift raw data into meaningful insights.

Utilize Power BI to build interactive and visually appealing dashboards and reports.

Spot key performance indicators with apt objectives

Analyze pervious and present data for better decision making

Transform business requirements into technical publications

Build multi-dimensional data models

Develop strong data documentation about algorithms, parameters, models

Perform detailed analysis on tested and deployed Power BI script

BI Development – UCOP, Oakland, CA.

Jan 2018 to May 2019

Project: BI Development

Description: UCOP (University of California, Office of the President) own 10 campuses across California. This project is about developing dashboards, reports for IRAP and various departments of UCOP.

Role: BI Lead Developer

Tools and Technologies: Windows 2012 Server, Tableau 10 &2018,2019, Cognos Business Intelligence suite 10.2.2,Cognos V11,Toad,IBM DB2,DB2 visualizer,Oracle,Apache - Impala, JIRA,Agile,SSRS,PowerBI

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information

Delivering reporting for revenue cycle client’s reports, Summary reports, dashboards, monthly reports such as Bar charts, 3D charts.

Partner with business analysts to understand requirements, source systems, and perform data analysis

Worked with the Business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines, testing, and technical delivery.

Prepared Business Requirement Document and converted business requirements into Technical Specification documents.

Analysis and requirement gathering.

Design of dashboards, Visualizations using Tableau 2018 using various functionalities and visualization capabilities

Upgradation of Tableau dashboards to latest versions

Performance tuning of the dashboards and code review

Fixes and security implementation on existing tableau dashboards.

Writing sql to connecting various schemas to act as source to Tableau Dashboards

Securing of the dashboards and deployment to production environment

Schedule and refresh of the Tableau and cognos dashboards

Collaboration with various teams on requirements

Migration of cognos 10.2.2 content to V11

FM changes on the existing packages as per requirement

Design and development of cognos reports and dashboards

Development of cognos reports and dashboards using version 11

Re-design and optimize to match/improve performance of the application

Securing of Tableau dashboards to sync with enterprise level security

Unit testing and data accuracy testing of the and reports

Fine tuning of the reports to improve the performance.

Bug fixes to the existing prod reports and dashboards.

Tool evaluation based on the requirement

Upgradation of Tableau dashboards to latest versions

Fixes and security implementation on existing tableau dashboards.

BI Development – IS, Tenet Healthcare

Oct 2016 to Dec 2017

Project: Tenet BI

Client: Tenet, Dallas- Texas, USA

Role: Data warehouse/ Business Intelligence Lead Developer

Tools and Technologies: Windows 2008 Server, Cognos Business Intelligence suite 10.2.2,Cognos V11 Netezza,Tableau10,Aginity Workbench, Sql Server 2012,PowerBI,BMC Remedy, JIRA

Description: This project is for Tenet HealthCare is one of the biggest Hospital Chains in USA. Currently the project is BI development of reports/dashboard using Tableau as well Cognos suite of products

Design dashboards, monthly reports such as Bar charts, Line Area graphs and Pie Charts

Collaborate with various teams and business partners to understand requirements, source systems, and perform data analysis

Worked with the Business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines, testing, and technical delivery.

Prepared Business Requirement Document and converted business requirements into Technical Specification documents.

Securing of the dashboards and deployment to production environment

Schedule and refresh of the Tableau and cognos dashboards

Securing of Tableau dashboards to sync with enterprise level security

Requirement analysis based on business users request

Collaboration with various teams

Tool evaluation based on the requirement

Design of cognos dashboards as per requirement

Design and development of cognos cubes and deployment

Development of dashboard using cognos cubes

Re-design and optimize to match/improve performance of the application

Unit testing and data accuracy testing of the dashboards

Securing of the dashboards and deployment to production environment

Schedule and refresh of the Tableau and cognos dashboards

Data blending using multiple sources of data and dual axis capabilities

Providing work around solutions for tableau limitations

End to end development from requirement gathering to design, development and deployment

Migration of Content of 10.2.2 to V11

Creating of data modules and datasets for dashboard in V11

Creating the dashboards in V11

Upgrade and fixes to existing dashboard in 10.2.2 to V11

Unit testing and Support and fix the business user reports/dashboards in Version11

Tableau dashboards using various functionalities and features in tableau

Tableau data blending and dual axis capabilities

Tableau extracts with high volume of data

Testing of Data accuracy using Aginity Workbench for IBM Netezza

Go to Market – Assort Financial, Nike Retail Inc.

Portland, OR Feb 2015 to Sep 2016

Role: Data warehouse/ BI Lead Developer

Go to Market Business Intelligence solution within Nike Retail Inc., is of one business unit which captures the sales and inventory information. This project enables insightful business intelligence solution decisions by providing Go to Market solutions to BPLs and other leaders across organization to access to consistent, accurate and timely information of Sales and Inventory of various Retailers across GEO’s based on the medal type (Gold, Silver, Bronze and Unclassified)

Tools and Technologies: IBM Cognos BI 10.2.2, IBM Go office, Oracle, Teradata, Version One, Agile, Service Now

Tableau dashboards using various functionalities and features in tableau

Tableau data blending and dual axis capabilities

Tableau extracts with high volume of data

Testing of Data accuracy using Toad sql,Aginity Workbench

Migration of Cognos Reports from Oracle DB to Teradata

Collaborate with various teams on requirements, product owner and other teams

Validation of cognos objects and data against multiple scenarios after migration

Develop, Design and Publish of Cognos FM model and changes

Requirement analysis and validation with BSA’s and Product owners

Design the Report prototypes as per the Business needs and solutions

Develop and Design the various report as per the Business owners demand

Consult and collaborate with various teams on requirements

Release process implementation and follow the deployment activities across various teams

Enhancement to the existing reports and design of new reports

Feasibility study of the requirements and providing optimal BI solutions

Performance Tuning of reports using cognos best practices

Providing cognos best solutions and coordinating with support team and IBM

Validation of objects across environment after migration and deployments

FM changes on the existing packages as per requirement

Installation and configuration and updgradation to cognos 10.2.1 on windows server 2003

Active reports for mobile version of Iphone and Anroid phones

Tenet- BI, Dell

Jul2011 – Dec 2014

Project: Tenet BI

Client: Tenet, Bangalore, Ind/Plano, USA

Role: Data warehouse/ Cognos Business Intelligence Lead

Tools and Technologies: Windows 2008 Server, Data Stage, Cognos Business Intelligence suite 8.4, 10, Oracle, Daptive, Netezza, Tableau 10,Aginity Workbench, Cognos SDK,BMC Remedy

Description: This project is for Tenet HealthCare is one of the biggest Hospital Chains in USA. Currently the project is migrated from oracle 11g to Netezza db and cognos 10.1 to 10.2 in which all the objects and tested and migrated and wherever required the codes are changed according to Netezza.

Roles and responsibilities

Support the tickets raised in the HP Quality Center ticketing system

Change and update the tickets and prioritize based on the ticket severity

Schedule and Monitor the Cube build process, reports and jobs through batch scripts and portal administration

Design, Build and deploy the Transformer cubes in different environments

Export and Import of the packages/reports to different environments

Installation and configuration of Cognos product tools and fix packs.

Content store backup on regular basis

Development and test of various objects to Netezza db.

Design of cognos dashboards as per requirement.

Re-design and optimize to match/improve performance of the application

Design of cognos mobile reports using IBM cognos apps for android and ios using Active report functionality in cognos 10.2

Upgradation of cognos 8.4 objects to cognos 10.1 and validation and fixes any required.

Ensure same end-user experience and usability of the tool, with no impact and accuracy of data

Installation and configuration and updgradation to cognos 10.2.1 on windows server 2003

Active reports for mobile version of Iphone and Anroid phones

Tableau dashboards using various functionalities and features in tableau

Tableau data blending and dual axis capabilities

Tableau extracts with high volume of data

Testing of Data accuracy using Toad sql,Aginity Workbench

DFC Migration, Dell Services

NOV 2010 – Jun 2011

Project: DFC Migration

Client: DOLE FOOD COMPANY, CA, USA

Role: Data warehouse/ BI Lead

Tools and Technologies: Windows 2000 Server,Unix,Oracle 8.3,9.1, Cognos 7.3 Series, Cognos 8.4 Business Intelligence, Crystal reports,Toad,Sql

Description:

This projects is for the client Dole Food Company (DFC).DFC is the one of the division of Dole.DFC migration involves the migration of Cognos 7.4/8.1 application to Cognos 8.4

The following roles and responsibilities:

Weekly status call with client on business understandings

Requirement Analysis of the existing system and compatibility study of the Cognos environment

Design of the Cube models using Framework Manager model

Installation and configuration of Cognos in distributed environments

Generation of the iqds from the Framework manager

Administered tasks such as Scheduling, Deployment

Export and Import of Packages into different environments

Creation of data sources backup of the Content store

Migration of Reports from various BI tools to Cognos BI

Providing the access privileges to different users of AD groups

SWIFT, Mindtree Ltd, Bangalore

April 2009 – Oct 2010

Project: SWIFT BI Projects

Client: SWIFT, Belgium, Europe

Role: Data warehouse/ Cognos Business Intelligence Lead

Tools and Technologies: Sun Solaris UNIX, Cognos Series7, Cognos Business Intelligence 8.4, SSIS, SSRS

Description:

SWIFT supplies secure messaging services and connectivity software to more than 8,000 financial institutions in more than 200 countries.

SAMS:-SAMS (Support, Analysis, Metrics, System) application is monitoring the daily metrics related to customers’ support of SWIFT, and cubes for cases, tickets and incoming ticket measures cubes.

LLUR: Leased Line Usage Reporting (LLUR) service available on swift.com. LLUR provides customers with bandwidth utilization statistics for their permanent connections to SWIFTNet.

ATLAS:-Atlas reporting is the ticket management system of SWIFT where cases are raised by the internal and external customers.

SLA reporting: SLA reporting is development of around 13 reports for swift services subscribed by customers of swift

Roles and responsibilities were performed

Interaction with client for requirements and business clarifications

Maintenance of cubes and CR’s to the existing cubes

Development of new reports as reqd and troubleshooting to the existing reports

Cognos 8.4 installation and configuration tasks – involved in the installation of Cognos 8.4 Fix pack 2 on Sunsolaris OS

Content Store back on regular basis

As Cognos core team need to help the internal report development team and troubleshoot their issues.

Publish and deployment of packages from one environment to another environment

Assigning of the user groups for the various packages

Implementation of CRs and troubleshoot the various issues in Cognos applications

Design of the report specifications and development of reports using report studio.

Mindtree Ltd, Bangalore

Sep 2008 – March 2009

Project: Truston and Hotline – Online Reporting

Role: Senior Developer

Description:

Affinion Group offers innovative products and solutions like Membership services and Insurance service. The Scope of this project is to implement the Truston and Hotline-Online

Client: Affinion Group, USA

Tools and Technologies: Oracle9, Informatica, Cognos 8.3

The following are the roles and responsibilities performed

Regular calls with the onsite team on the status

Client interaction on the business understanding

Analysis and modeling business layer using Framework Manager

Developed model and published package.

Interacting with the client on a regular basis for business clarifications

Mindtree LTD, Bangalore

Mar 2008 – Aug 2008

Project: Phoenix Usage Reporting

Role: Cognos Sr. Developer

Description: The Purpose of Phoenix reporting is to capture the Customer details that login to John Wiley site to access the Wiley products.

Client: John Wiley, USA

Tools and Technologies: Cognos 8.3, Oracle 9i, OWB, Business Objects, Crystal reports

The following are the roles and responsibilities

Coordinated the team on the deliverables

Weekly status call with onsite coordinator and client

Created Dynamic column reports based on the Prompt values selected.

Created Cascade Prompts and various prompts as per requirement.

Created drill through reports to link two or more reports.

Migration of BO reports to Cognos

Validation of data after migration

Unit testing of the reports

Mindtree Ltd, Bangalore

May 2006 – Feb 2008

Project: Peregrine and Quote Migration

Role: Cognos Developer

Description:

This Client General Motors Acceptance Corporation Insurance is the financial services unit of the $185 Bn General Motors, One of the Top 10 Auto Insurance companies in the United States. The project involved converting crystal reports as part of organization-wide Peregrine ImplementationClient: GMACI, USA

Tools and Technologies: Crystal reports, ReportNet 1.1MR3, Cognos 8, Oracle 9i

The following as the roles and responsibilities performed

Created filters and prompts to reports to add interactivity for users.

Created drill through reports to link two or more reports.

Created reports using conditional formatting.

Created various kinds of reports using report studio.

Created report using Tabular set.

Created master detail reports.

Aptronics Ltd, Bangalore

Sep 2005 – Apr 2006

Role: Developer

Project: GS Reporting System

Description: This project is for Retail Business covering the consumer products especially FMCG products. Involved in developing reports using Cognos Impromptu

Client: Grupo Sanborns, Mexico

Tools and Technologies: Oracle 8i, Informatica 6.1, Cognos 7 Series Impromptu

The following tasks were performed

Creating catalog and connecting between impromptu and data source through ODBC.

Creating catalog to build various kinds of Reports using prompts and other features

Involved in reports using hot file, snapshots.

Creating various kinds of reports using impromptu for end user.

Creating joins to get the necessary detailed data from tables.

Aptronics Ltd, Bangalore

Sep 2004, Aug 2005

Project: Billing system

Client: TELCO

Role: Programmer Analyst

Tools and Technologies: Oracle 8 and Visual Basic 6

Description: Automation of processes for the medical distributors. The project Modules included Invoice entry, Billing, Master maintenance, Order management and Inventory control.

Roles and Responsibilities:

As a Team member involved in requirements gathering

Analysis and design of the product

Coding and testing of product

Education

Bachelor degree in Electronics, Kakatiya University, Warangal,

Master of Computer Applications, Osmania University, Hyderabad

Academic Affiliations

PG affiliation to OSMANIA University, Bachelor’s affiliation to Kakatiya University

Achievements

Achieved Outstanding Performer for the Year 2009-2010 in Mind tree Ltd

Spot award winner for DELL Services for outstanding work and management of team

Contact this candidate