Business Intelligence Power Bi

Murali Vallepu

: ******@*****.*** : 239-***-**** : Murali Vallepu

Professional Summary:

Lead Business Intelligence Specialist with over 18 years of experience in the full lifecycle of BI environments, including installation, configuration, design, development, implementation, and production support. Extensive expertise in Tableau Desktop, Tableau Server, Cognos, SSRS Proficient in databases such as Oracle, SQL Server, Teradata, AWS Redshift, and Databricks. Skilled in ETL tools like SSIS and Informatica, as well as AWS Cloud.

Certifications

Certified Safe Agile 5 Practitioner.

Certified in Azure Fundamentals.

Certified Tableau Desktop Professional.

Certified IBM Cognos 10 BI Reports Designer.

BI Tools:

Tableau Desktop, Server, Power BI, Cognos Analytics, SSRS, Qlik

ETL Tools

SSIS, Informatica

Languages

SQL, PL/SQL, C, Pro* C, C++, Shell Scripting, Python

Databases

Oracle, SQL Server, AWS Redshift, Teradata, Databricks, Postgres SQL, MS Access

Cloud Based Platforms

AWS Redshift, Databricks, Google Big Query

AWS Cloud Services

AWS Redshift, Cloud watch, S3, EC2

Other Tools

Motio CI/PI, Cubes, Framework Manager, Reporting Studio, Query Studio,

Technical Skills

Education:

Master of Computer Applications, JNTU, India.

Bachelor of Science in Mathematics, Physics and Statistics, SVU, India.

Professional Experience:

Working with TATA Consultancy Services Ltd, July 2010 – Till date.

Professional Experience:

Employer : TATA Consultancy Services Ltd.

Role : Lead Business Intelligence Specialist

Client : Hertz Global – FL Aug 2020 – Present

The Hertz Corporation, a subsidiary of Hertz Global Holdings Inc., is an American car rental company based in Estero, Florida that operates 10,200 corporate and franchisee locations internationally.

Responsibilities:

Developed and maintained over 40 interactive reports and dashboards using Tableau, Cognos, and Power BI, increasing user engagement.

Created and optimized data models to support efficient data analysis and visualization, reducing data processing time.

Extracted, transformed, and loaded data from various sources into Viz Tools (Tableau, Power BI, Cognos), improving data accuracy.

Optimized the performance of Tableau Server, including managing extracts, optimizing queries, and improving dashboard performance, reducing query response time by 30%.

Provided training and support to end-users on how to use BI Tools to increase user proficiency.

Implemented and managed data security protocols, including user permissions, roles, and access control within Tableau Server and Cognos Server, enhancing data security.

Ensure data quality and governance by implementing best practices for data management and documentation, decreasing data errors.

Troubleshot and resolved issues related to Tableau Server, including performance, connectivity, and data-related problems, reducing downtime.

Establish and enforce data visualization standards and best practices to ensure consistency and clarity in reporting.

Automated routine tasks and processes using scripting and scheduling tools, enhancing efficiency.

Stay current with the latest Tableau features and industry trends, exploring new ways to leverage Tableau for business intelligence.

Proficiency in both development and Administration of BI environments (Tableau and Cognos).

Resolved 80% of reporting problems through critical analysis and strategic escalation, enhancing decision-making efficiency.

Led the development of analytics applications with Salesforce, IBM, and Microsoft, delivering key insights that improved decision-making efficiency.

Perform Logshark analysis to identify the performance bottlenecks of the dashboards, reducing bottlenecks by 20%.

Environment: Tableau, Power BI, Cognos Analytics, SQL, Oracle, SQL Server, PostgreSQL, Teradata, Databricks, AWS Cloud, EC2, Redshift, Cloud watch, S3, Python

Role : Data Lead and Business Intelligence Specialist

Client: Genuine Parts Company – Atlanta, GA Nov 2017 – July 2020

Genuine Parts Company distributes automotive, industrial, office, and electrical/electronic parts.

Responsibilities:

Design and develop high-quality interactive dashboards and data solutions utilizing Tableau, Power BI and Cognos.

Translate business needs into actionable visualizations for stakeholders.

Develop charts, graphs, and other visual elements to represent data effectively.

Designed BI data model with multiple fact tables and dimensions depending on the business requirements.

Work with business stakeholders, analysts, and data engineers to understand requirements and deliver actionable insights

Troubleshoot and resolve issues related to Tableau Server, including performance, connectivity, and data-related problems.

Work with business stakeholders, analysts, and data engineers to understand requirements and deliver actionable insights.

Understanding of Tableau design best practices and ability to design dashboards adhering to company standards.

Automate routine tasks and processes using scripting and scheduling tools to enhance efficiency.

Monitor the health and performance of BI Servers, applying updates and patches as needed.

Adept at working in Agile methodologies.

Proficient in scripting languages such as Python, Shell script and Windows PowerShell.

Environment: Tableau Desktop, Tableau Server, Power BI Desktop, Cognos Analytics, Reporting Studio, Oracle, SQL Server, SSIS, SQL, AWS, Python

Role : BI Developer/Admin

Client : Walgreen Co – Chicago, IL May 2014 – Oct 2017

Walgreen's is migrating the existing Specialty fulfilment system Script Med 1 (SM1) to Script Med 6 (SM6). The current reporting to business and other stakeholders needs to happen without any discontinuity.

Responsibilities:

Performed Install, configure, upgrade and maintain BI Servers to ensure optimal performance and availability and Cognos version upgrades and migrations.

Design, develop, and maintain interactive reports using Cognos and SSRS.

Built models and published packages using Framework Manager.

Worked with data sources to improve query performance.

Implemented security, defining roles, appropriate user groups, assigning appropriate.

Possess a strong understanding of data governance, best practices, and regulatory compliance.

Collaborates with business leaders to understand their requirements, researches and analyzes potential solutions to enhance business performance using data analytics and visualization tools, by developing key performance indicators, dashboards and reports.

Proficient in MS tools like SSRS, SSIS, Access and Excel

Environment: Cognos 10x, Report studio, Framework Manager, SSRS, SSIS, Oracle, Windows, UNIX Shell Scripting, SQL Server, Composite, Motio CI/BI

Role : ETL and Reporting Developer

Client : Bank of America Jul 2010 – May 2014

The EIM Reporting application extracts data from various source systems and loads it into a staging area.

Responsibilities:

Design, develop, and maintain interactive reports using Cognos and SSRS.

Scheduled reports to run on a monthly, weekly, daily, and hourly basis to send e-mail to users. Also established triggers for triggered based reports schedules.

Build Power Cubes using Cognos Transformer and Data Models using Framework Manager.

Designed and Deployed extract-transform-load (ETL) processes using SSIS.

Data modeling and designing marts, along with developing stored procedures, to support business needs and facilitate easy data interpretation.

Various Performance and Tuning techniques are used to improve the load.

Environment: Cognos 8.4/10.1, Report studio, Query studio, Framework manager, Analysis studio, Cubes, Transformer, SQL, PL/SQL, Oracle10g, Server 2008, SSIS, SSRS, SSAS, Informatica.

Company : Polaris Software Lab Ltd.

Role : Developer

Client : National Bank of Abu Dhabi Aug 2006 – Jun 10

Accrual and application module allows the users you to define necessary parameters to process debit interest, credit interest and apply taxes on the debit / credit interest.

Responsibilities:

Developed new batch (EOD) programs.

Developed Stored procedures, Packages and Triggers

Tuned SQL, PL/SQL and Pro* C Code for Better Performances Using Performance Tuning Tools.

Designed and developed new programs for existing products.

Proficient in SQL, PL/SQL, C, Pro* C programing skills.

Environment: Pro* C, C, UNIX Shell Scripting, Oracle 8i/9i, SQL, PL/SQL

Contact this candidate