Power Bi Developer

Ramyasri Nallani

**********@*****.*** 806-***-**** Dallas, TX – 75052 LinkedIn: linkedin.com/in/nallani-ramya17

SUMMARY

BI Developer with 4 years of industry experience specializing in data visualization and ETL processes. Proficient in Tableau, Power BI, and SQL, with a strong background in implementing data pipelines, conducting data cleansing, and ensuring data quality. Experienced in collaborating with cross-functional teams to meet business intelligence requirements. Aimed at leveraging technical skills and teamwork to enhance data-driven decision-making at the enterprise level.

TECHNICAL SKILLS

Programming Language Cloud Technologies

: Java, Python, C, C++, Scala, Spark, Kafka, Hive, Impala, SAS, Matlab, R

: AWS (EC2, Redshift, Glue, Lambda, Kinesis, Athena, EC2, DynamoDB, S3, and Redshift),

Azure (Azure DevOps, Azure Data Lake, Azure Synapse Analytics), GCP

Web Technologies

: HTML, CSS, Bootstrap, JavaScript, NodeJS, JSON, jQuery

Front End frameworks

: React, Angular

Operating Systems Containers

Web Servers Scripting

: Linux, Windows

: Docker

: Tomcat

: UNIX (ksh, Bash)

Database Cloud SCM

Big Data Ecosystem

: SQL, MongoDB, Oracle, Redshift, NoSQL

: AWS

: Git, GitHub, Bitbucket

: MapReduce, Hadoop, Hive, HDFS, Spark, HBase, Apache Beam

Tools

BI Tools

: NetBeans IDE, Eclipse, Airflow, Stream Set, Informatica Power Center, Elasticsearch

: Tableau, Power BI, Oracle Analytics Server, OBIEE, Quicksight

WORK EXPERIENCE

State of Tennessee Feb 2023 -Present

Role: BI Developer

Hands on experience on Tableau Desktop Versions 7/8.2, Tableau Reader, and Tableau Server.

Mastered the ability to design and deploy rich graphic visualizations with Drill Down and drop-down menu option and parameters using Tableau. Utilized Tableau server to publish and share the reports with the business users.

Developed Tableau data visualization using Cross tabs, Heat maps, Box and whisker charts, pie charts and Bar charts.

Expert in Tableau, Power BI Dashboard Development and publishing them to respective server, Cloud.

Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.

Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.

Involved in trouble shooting of performance issues which were associated with Tableau reports. Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Expertise on OBIEE.

Converted existing Tableau reports to OB dashboards.

Developed many Reports / Dashboards with different Analytics Views (Drill-down/Dynamics, cascading style sheets, Pivot table, Chart, Compound Layout, Narrative, Column Selector, View Selector, Ticker, Segment, Section, Tabular with local and global filters) using OBIEE Analytics.

Hands on experience in customizing analysis, filters, and charts in OBIEE Analytics. Unit, Integration, System testing for all components in OBIEE Reporting. Test cases have been prepared and documented the results.

Migrated over 40 dashboards/reports from Tableau which were sourcing from different sources like SQL Server, Tableau SSAS into OAS & Power BI.

Hands on expertise on Power BI.

MDX programming, DAX expressions, analysis, and business forecasts.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Created calculated measures and dimensions members using multi-dimensional expression (MDX).

Write Custom SQL queries to pull data into tableau/ Power BI.

Supported Power BI reports, Power BI dataflows on Service, Tableau reports on tableau Server and Cognos reports.

Provided Production support to tableau users and wrote custom SQL to support business requirements.

Design and develop interactive dashboards and reports using Power BI that meet business requirements and provide insightful data visualizations.

Utilized Power Query in power BI to pivot and un-pivot the data model for data cleansing and data massaging.

Involved in data analysis by writing SQL queries against database and performing data validation.

Wipro Limited Client – Mitie Jun 2020 – Oct 2021

Role: Data Engineer and Database Admin

Responsible for maintaining of airflow Jobs, Stream set pipelines, handling servers and Access management.

Installation, configuration, customization, maintenance, and performance tuning of SQL server 2005/2008/2008 R2.

Designed and implemented Backups and Restore strategies using Native SQL and Light speed 3rd party tools. Provided 24 x 7 production support for the database and application issues.

Employed ETL tools such as Informatica, Oracle Data Integrator (ODI), SQL Server Integration Services (SSIS), BusinessObjects Data Integrator (BODI), and IBM DataStage to streamline data integration and transformation processes.

Automated routine data extraction and processing tasks with Python and KornShell scripts, leading to a 30% reduction in manual processing time.

Performed database/infrastructure physical design, database upgrades applied software patches to databases as per

application/client requirements. Responsible for monitoring 50 servers using internally developed ‘Server

management system’ with a team of 5 members. Investigated service interruptions, determining root cause, and led troubleshooting in a timely manner by tracking and monitoring issues until resolution.

Responsible for designing and implementing the data pipeline using Big Data tools including Hive, Oozie, Airflow, Spark, Drill, Sqoop, EC2.

Used Sqoop to extract and load incremental and non-incremental data from RDBMS systems into Hadoop.

Utilized SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, and Scala to query and manipulate data, enhancing data retrieval efficiency.

Converted some existing sqoop, hive jobs to SparkSQL applications to read data from Oracle using JDBC and write it to hive tables. Created scripts for the deployment of clients into Mozaic.

Conducted thorough data profiling and analysis to identify data quality issues and implemented corrective measures, improving data accuracy by 25%.

Extensive experience in developing and maintaining data pipelines using Apache Airflow.

Proficient in writing and debugging Python code for Airflow DAGs (Directed Acyclic Graphs) to orchestrate data workflows. Strong knowledge of Airflow's core concepts, such as operators, sensors, and hooks.

Wipro Limited Client – Optus Jun 2019 – May 2020

Role: SQL Developer

Experience in managing the oracle database, SQL Queries and Hive Language

Aided daily support and monitoring the production system and maintained the customer details. Experience in Testing environment and worked on test cases. Worked on Informatica PowerCenter and executed and monitored the repositories.

Involved in developing ETL packages with SQL Server Integration Services (SSIS)- ETL tool and extracted data from different sources, staged them to the SQL Server. Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements.

Have excellent technical skills and be able to develop new skills quickly Strong knowledge and working experience with Linux/Unix environment.

Created and Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements instead of Cursors in T-SQL. Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-

hoc business requests.

Developing stored procedures, triggers, views, and adding/changing tables using SQL for data load and transformation, and data extraction. Provided Production support to tableau users and wrote custom SQL to support business requirements. Involved in data analysis by writing SQL queries against database and performing data validation.

Integrated NoSQL databases with big data platforms such as Hadoop or Spark, enabling analytics on diverse data sources and large-scale data processing.

EDUCATION

Texas Tech University, Lubbock, Texas December 2022

Master of Science in Computer Science GPA: 3.6

CERTIFICATION

Google Data Analytics

Contact this candidate