Nithya Aruchamy-Power BI-Resume

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

NITHYA ARUCHAMY

POWER BI DEVELOPER
+1(732)596-7114
nithya.aruchamy@gmail.com

PROFESSIONAL SUMMARY

9-years of experience as a Power BI developer with proven track record of designing and
implementing end-to-end BI solutions that provide valuable insights to stakeholders through
visualizations and tabular models. Possessing advanced skills in Power BI, Data Analysis, Data modeling,
ETL processes, Data Pipeline, and Data visualization, which enable me to build robust, scalable, and user-
friendly data solutions with expertise in data warehousing. Skilled in conducting data audits, data
profiling, and data quality assessments to ensure data accuracy and integrity. Highly organized and
detail-oriented with strong interpersonal skills with ability to deliver enterprise-wide solutions.

TECHNICAL SKILLS
 BI Tools-Microsoft Power BI, IBM Cognos BI Analytics, Tableau
 ETL Tools-Informatica PowerCenter v10 (Designer, Workflow Manager, Workflow Monitor)
 Database-Db2 (v11, v9, v8), Oracle 12c, SQL Server 2012, Azure, Snowflake
 Other Tools-Advanced Query Tool (v9, v7), Toad
 Operating System-Windows XP, 2007, AIX, UNIX
 Programming Language-SQL, PL / SQL, UNIX Shell Script

EXPERIENCE
POWER BI DEVELOPER, ACCOLITE DIGITAL-NEW JERSEY JAN 2021 – PRESENT
 Build broad range of operational efficiency improvement and marketing performance dashboards to
deliver KPIs for real-time decision making
 Proficient in DAX and M languages, with the ability to implement complex business logic and custom
visualizations in Power BI
 Conduct data analysis, data visualization, and data storytelling to communicate key insights and
trends
 Install and maintain deployments pipelines in the Premium capacity workspaces
 Created and managed workspaces, setting up security and access controls, and sharing reports and
dashboards with users within your organization through apps
 Implement data model techniques to existing reporting elements, driving better performance and
reporting experience for the end users
 Engage with end users to understand Requirements and recommend solutions to address
impediments and enhance Power BI Platform architecture
 Report findings from data creatively in a tabular and /or visual formats that appropriately provides
insights to the organization
 Manage huge volume of data by creating weekly partitions in SQL Server and used Power BI
gateways to keep the dashboards and reports up to date
 Developed, monitored, and optimized data integration processes to ensure efficiency and scalability
Environments: Power BI (Desktop, Service), DAX, Power BI Gateway, Power Query, M language, MS SQL
Server, Azure, Hive, Teradata, MS Excel, ALM, Jira, Windows 10, and Report builder

POWER BI CONSULTANT, VMware-CALIFORNIA NOV 2019 – DEC 2020


 Strong experience in Power BI desktop with exposure to advance DAX functions, performing Role
Level Security, and Azure platforms
 Analyzed sales data to identify trends, patterns, and opportunities for improvement by creating
Power BI visualizations for the dashboard and ad-hoc reporting solutions
 Implemented database integration techniques, including data modelling and data normalization,
and carried out data analysis and data warehousing for performance in Power BI
 Developed data reconciliation SQL queries to validate the overall data migration
 Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle,
SQL Server, Teradata, Flat files
Environment:  Power BI Desktop, DAX, MS SQL Server, SQL, Azure, JIIRA, MS Excel, Teradata, SSIS

POWER BI DEVELOPER, AVEON TECHNOLOGIES- HYDERABAD, INDIA JULY 2015 – AUG 2017
 Created reports, visualizations, and interactive dashboards using Power BI, while leveraging live and
imported data, and scheduling daily job refreshes
 Led and oversaw the EDW team responsible for business intelligence, data warehousing, metadata
management, enterprise data integration, and database modeling. Managed day-to-day activities
such as code review, Year End Processing, and production support
 Optimized and updated Logical & Physical Data Models to support new and existing DW projects,
and worked with architects and end users to map data from legacy systems to the Data Warehouse
 Developed various dimensional and relational reports using Power BI, deploying lists, crosstabs,
charts, union, joins, burst, and drill up/down reporting techniques. Analyzed logs and reports to
create materialized views to speed up larger queries
Environment: Microsoft Power BI (DAX, Power Query, Power Pivot, Power View, Power Map), Cognos BI
11 (Framework Manager, Report Studio, Dashboard, Visualization, Data Module), SQL Server 2012,
Oracle 12c, Advanced Query Tool v9, Windows XP & UNIX server, SQL

ETL DEVELOPER, GE EQUIP SERVICES, HYDERABAD, INDIA AUG 2011 – JUN 2015
 Developed shell scripts for automation of Informatica session loads and administrated Informatica
server and ran Sessions & Batches.
 Develop mapping, sessions, and workflows for ETL processes.
 Conduct ETL performance tuning, troubleshooting, and provide support.
 Map sources to targets using a variety of tools, including Business Objects Data Services/BODI.
 Work extensively on different types of transformations such as source qualifier, expression, filter,
aggregator, rank, lookup, stored procedure, sequence generator, and joiner to ensure accurate data
integration
Environment: Windows, UNIX script, Oracle 8.0, SQL, PLSQL, MS Access, SQL Server, Informatica 5.1, MS
Excel

EDUCATION
Bachelor of Engineering in Computer Science from Anna University, India 2007-2011

You might also like