SUMMARY

• 15 years of experience in Business Intelligence, Reporting & Data Visualization, Data Analytics & Data Warehousing practice.
• Implement BI solutions using Microsoft Power BI, Tableau BI, IBM Cognos Analytics, Business Objects, Google Cloud BI Looker & AWS Quicksight.
• Expert in designing interactive BI visualizations dashboards, drill down reports, bursting reports, Geo - Spatial dashboards, advanced visualization dashboards, KPI Metric dashboards.
• Well versed in Business Intelligence Architecture, Installation & Maintenance, Content & User administration
• Implement security in reporting environments (Role based and Data based)
• Expert in designing Data Models to meet complex self-service BI requirements (Relational & Dimensional)
• Excellent working experience in Data integration ETL tools like IBM DataStage and Informatica for transforming and loading data into reporting data marts.
• Strong working experience in writing SQLs in databases like Teradata, Oracle, Netezza, DB2, SQL Server and writing PL/SQL in Oracle DB.
• Experience in implementing end-to-end DevOps CI/CD pipeline
• Experienced working in AWS Cloud and Snowflake Cloud Data Warehouse environments.

TECHNICAL SKILLS

• Business Intelligence
• Tableau
• Power BI
• Visualization
• ETL
• IBM DataStage
• Data Warehousing
• IBM Cognos Analytics
• Leadership
• Manage teams
• Performance tuning
• BI Architect SQL
• Data Modelling
• AWS Snowflake
• DevOps
• Star Schema
• Offline reporting
• Teradata
• Oracle
• Critical thinking
• Cloud computing MPP

PROFESSIONAL EXPERIENCE

BI & Analytics Architect, Technical Manager

Confidential

Responsibilities:

• Lead Information GovernanceCataloguereporting for Ally Data Governance team
• Lead discovery, analysis & requirement gathering of all 150 Data Quality KPI s involved in data governance and compliance reporting.
• Design a new Data model that supports dis requirement which can enable self - service reporting using Power BI reports and dashboards.
• Design and Develop new Power BI reports / dashboards for all the 150 KPI s . Use Interactive reports wif drill down capability, dynamic visualizations, trend views, scheduling and emailing KPIs and other BI reporting requirements.
• Create regulatory report for a critical KPI for Compliance to Policy
• Support and help wif development of data integration tasks using IBM Data Stage
• Perform cleansing, de-duplication and harmonization of data across multiple systems.
• Lead and implement end-to-end DevOps CI/CD pipeline for APEX application involving Jenkins and Bitbucket.
• Adopt JIRA scrum boards for all project work tasks management and on- board the whole team to adhere.
• Train team in SNOWFLAKE and NIFI as part of adopting these technologies in pipeline project activities.

Senior Business Intelligence Engineer

Confidential

Responsibilities:

• Requirement analysis of 700 Reports, 60 Dashboards, 15 schedules & 5 OBIEE Models
• Design reverse engineering of Reports, Dashboards, iBOTS & data models from OBIEE.
• Rationalize reports & dashboards to remove redundant reporting views, better report design and eliminate historically unused reports.
• Work wif Walmart Business team in understanding scope and business critical reporting needs.
• Drive design sessions wif End users & business owners to ensure we are addressing the right problem statements meeting the customer expectations.
• Manage 3 LOBs having 3 separate teams at offshore performing these migration tasks.
• Lead development effort in building Cognos Framework manager model and developing reports.
• Analyze for better reporting performance improvements
• Migrate all the dashboards and Geo Spatial reporting into Tableau BI

Confidential

Responsibilities:

• Design and develop 3 dimensional models to support all the reporting needs in scope.
• Gather requirements on reports to be automated that are currently generated manually or using spreadsheets and understand the visualization needs.
• Develop executive Dashboards and Visualizations using Tableau BI for Verizon collection Managers and Supervisors
• Convert SQL based reports to Tableau reports and dashboards.
• Develop canned reports using Cognos Analytics and Develop packages using Framework Manager using Star schema model.
• Use analytics features liketime - series and forecast reporting/ predictive analytics using Tableau BI for forecasting and trend analysis.
• Design and develop reports involving drill down, drill thru functionality, conditional rendering and other report studio features.

Confidential

Responsibilities:

• Gather & design data model for reporting requirements for 3 regulatory reports to be developed
• Create Functional & Technical Design Specification documentation
• Map data lineage information from existing CDW DataMart to the fields in the reports.
• Design reporting table and use IBM DataStage to load data as per data modelling guidelines
• Create Source to Target mapping for ETL requirements.
• Develop the reports using Cognos Analytics - report studio, event studio & Active reports.
• Use conditional rendering and macros/java scripting in reports to implement very specific prompting needs.

BI Reporting Lead

Confidential

Responsibilities:

• Design Supply Chain Intelligence (SCI) reports based on the VSI requirements.
• Create transformer Cube for Quantity analysis.
• Design Workspace Advanced Dashboards based on the subject areas like, Inventory, Replenishments, Inbound, Outbound etc.
• Develop Geospatial reporting visualization for Inventory needs.
• Create and maintain Data Framework Model that for the all reporting needs.

BI Reporting Team Lead

Confidential

Responsibilities:

• Migrate Cognos reporting environment from Cognos BI 8.4 to Cognos BI 10.2.1 FP4
• Administer Cognos reporting environment for Client which includes giving/restricting users access to different folders and other security features using Cognos Administration.
• Manage & Lead Offshore development team activities for project release
• Involve in planning and estimation of Promotional Spend Compliance reports to be developed
• Review reporting requirements in Business Requirement document
• Develop new Cognos reports & Charts based on the requirements provided by the End users and Business partners.
• Implement external triggering of Cognos reports using Batch file by using batch scripting.
• Scheduling Cognos reports in Cognos connection based on different business area needs.

Business Analyst

Confidential

Responsibilities:

• Involve in planning and estimation of the new set of BI reports that needs to be created/ converted as part of the reimplementation project.
• Involved in the requirement gathering of the future state account mappings and assist in Technical specifications.
• Supervise the development of new Cognos reports and Cognos for office workbooks reports based on the requirements provided by the Report owners and Business partners.
• Provide advice on enhancement of FOCUS reports for better performance and good design for maintenance.
• Work wif the Client s infrastructure team to migrate the changes to production servers.

Senior BI Developer

Confidential

Responsibilities:

• Develop of new Crystal reports based on the requirements given by the corporate management group. Support the existing reports in Production.
• Develop new reporting dashboards in Go Dashboard in Cognos 8 on resource utilization data. Develop trend charts for executive reporting.
• Provide options on enhancement of the reports, which would make it easier for the higher management to look at the data in new and better way.
• Involved in performance tuning of reports.
• Developed reports wif filters, calculations, cascading prompts and conditional formatting.

Informatica developer

Confidential

Responsibilities:

• Actively involved in the Development & Unit Test of Informatica PowerCenter mappings
• Use transformations like, Aggregator, Look up, Filter, Update strategy, Rank, Router etc.
• Execution of Informatica scripts to migrate data to System testing environments and Validation of migrated data.
• Involved in requirements gathering, Data Analysis and Assessment.
• Review the design and code of the Informatica Scripts to be migrated.
• Actively involved in Quality Assurance activities related to Project

BI Reporting developer

Confidential

Responsibilities:

• Involved in conversion and testing.
• Analyzing the functional requirement from BO reports for model and report generation.
• Created various list, grouped list, crosstab, and nested crosstab reports using Cognos Report Studio and used Query Studio to create ad - hoc reports.
• Implemented filters, calculations, prompts, conditions, and created various reports using Report Studio.
• Expertise in creating multiple drill-through, and master-detail reports.
• Created variables for conditional formatting the report to highlight the deviation of data.
• Development & Unit Testing of Informatica PowerCenter mappings for the selected set of surveys to implement suggested changes in the mappings of Metadata tables.
• Execution of Informatica scripts to migrate data to system testing environments
• Actively involved in Quality Assurance activities related to Project
• Data validation of migrated data in the UAT environment.
• Involved in trouble shooting and Debugging of issues.
• Reporting and Updating the status of the project to the Project Manager on weekly basis