AMIRTHAVARSHINI BALIYA MOHAN
Bothell,WA
Summary
With 6 years of experience in Software Design, Database Design, and Business Intelligence, I specialize in developing, integrating, and maintaining BI solutions across various platforms. Proficient in Tableau, Power BI, and SQL, I have extensive experience creating interactive dashboards, reports, and visualizations using advanced BI functionalities like data blending, complex calculations, filters, and parameterized reports. Skilled in working with databases such as SQL Server, Oracle, and DB2, I have a strong background in ETL processes, data extraction, and reporting for business users.
I am well-versed in Python and PySpark for big data processing, statistical analysis, and visualization, leveraging libraries like Pandas, Matplotlib, and Scikit-learn for data manipulation. Additionally, I have expertise in Excel-based analysis (VLOOKUPs, pivot tables, macros) and creating ad-hoc reports. Experienced in Agile and Waterfall methodologies, I have worked on cloud-based data solutions using AWS and developed end-to-end BI solutions in environments that support OLTP and OLAP reporting.
Overview
11
11
years of professional experience
Work History
Business Analyst II (Contractor)
Amazon
01.2025 - Current
- Develop a deep understanding of the business across multiple areas, identifying gaps and solving data-related issues to support strategic decision-making.
- Analyze complex data sets using SQL, Python, and other analytical tools to inform business strategies and drive efficiency improvements.
- Evaluate assumptions about data and analysis methods, ensuring all analyses are valid and relevant to business objectives.
- Design and execute comprehensive analyses, providing actionable recommendations that impact both short-term and long-term business goals.
- Create dynamic dashboards and reports using Tableau and QuickSight to visualize data trends and performance metrics for various business teams.
- Develop and deliver presentations using clear data visualizations, ensuring that all insights are communicated effectively to stakeholders.
- Collaborate with cross-functional teams to understand business needs and refine analytical approaches, improving overall data quality and reporting accuracy.
- Identify opportunities for automation in reporting and analysis, providing recommendations that reduce manual work and increase operational efficiency.
- Provide feedback on analytical tools and methodologies, suggesting improvements to increase accuracy and efficiency in future analyses.
Business Analyst II (Contractor)
Amazon
09.2022 - 02.2024
- Transformed complex datasets into actionable insights by utilizing predictive modeling techniques to forecast future outcomes, enabling data-driven decision-making across various business units
- Employed SQL, ETL processes, Tableau, and advanced Excel functions to extract, analyze, and visualize data, delivering comprehensive dashboards and reports that enhanced visibility into key performance indicators and business metrics
- Developed and maintained detailed business documentation, including Standard Operating Procedures (SOPs), work instructions, and process flow diagrams, ensuring clear communication and adherence to best practices across teams
- Actively participated in cross-functional knowledge transfer and requirement gathering sessions to identify business objectives and areas for process enhancement, fostering a culture of continuous improvement and collaboration
- Conducted thorough data collection and analysis to assess information accuracy and quality, implementing validation processes that improved data reliability and supported strategic initiatives
- Collaborated with diverse stakeholder groups across the organization to align business needs with technology solutions, presenting tailored proposals and recommendations that met defined specifications and enhanced operational efficiency
- Assisted in managing multiple projects by tracking deliverables, facilitating communication among stakeholders, and ensuring timely completion of initiatives that supported organizational goals
- Developed key performance indicators (KPIs) and dashboards to monitor business performance, enabling proactive adjustments and strategic planning based on real-time data insights
Data Analyst
Wunderman Thompson
07.2021 - 09.2022
- Company Overview: Seattle, WA
- Build Power BI Dashboards to Analyze complex and non-standard data from 3 credit bureaus for consumer and small business lenders and implement credit risk models using Power BI
- Performed data mining, analysis, and support various BI group to develop analytical and operational reporting
- Performed data processing using Python libraries like NumPy and Pandas
- Performed downloading HTML Scrape data using Beautiful soup library in Python
- Automated report downloading using Selenium WebDriver and using page object model with CSS and XPath selectors using Python
- Loaded the data into MySQL using Python
- Merging SAS datasets using various SQL joins such as LEFT JOIN, RIGHT JOIN, INNER JOIN and FULL JOIN as well as using SAS procedures such as SET, MERGE, PROC APPEND etc
- Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Power BI Dashboards, and managing the delivery
- Designing and developing Power BI visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies
- Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
- Extensive usage of MS office and the functionality of excel such as VLOOKUP’s, pivot table, macros, statements etc
- Performed approvals for peer audit reviews on reports by analyzing data
- Monitor progress of the Dashboards and facilitate the management on impact, issues, and risks
- Worked Closely with the ETL data team to fix the Data issues identified in tableau reporting
- Worked in cross-functional teams across region and ensured reporting numbers are correctly provided to senior management
- Planned a roadmap of project activity that generated measurable improvement in business performance metrics and Key Performance Indicators (KPIs)
- Creating ad-hoc data analysis to the users as when required
- Used a variety of reporting tools like Power BI and Spreadsheets to assess Product program performance for the new system integrations
- Published and scheduled daily/Weekly/Monthly Power BI dashboards to the Power BI server
- Seattle, WA
Process/Data Associate
Plintron
05.2014 - 02.2017
- Company Overview: India
- Involved in creating database objects like Tables, Views, Procedures, Triggers and Functions using T-SQL to provide definition, structure and to maintain data efficiency
- Interacted with the existing database developers and DBA to understand the existing schema
- Automated monthly excels report into Power BI workbooks and dashboards
- Created Tableau dashboards with interactive view, trends, and drilldowns along with user-level security
- Hands-on development in assisting users creating and modifying worksheets and data visualization dashboards
- Well documented the entire process of working with Power BI desktop and in evaluating business requirements
- Created dashboards by extracting data from many different sources using data blending and joining multiple tables in case merging data from different sources using Power BI and SSRS for a different set of teams
- Wrote complex SQL queries involving Inner and Outer joins, Temp Tables, Views and Indexes
- Created Gantt charts, Nested Donut pie charts, heat map, bar charts, funnel chart
- Worked on Extracts and live connections to connect MSSQL server
- Scheduled an extract refresh and subscriptions for daily, weekly and monthly reports
- Successfully delivered the dashboard on time, utilizing project management best practices
- India
Education
Bachelor of Engineering - Electronics and Communication Engineering
KLNCIT
01.2014
Skills
- MS SQL Server 2008R2
- MS SQL Server 2014
- MS SQL Server 2016
- Oracle
- MySQL 50
- DB2
- Cosmos
- Tableau Desktop
- Power BI
- MS Excel
- SQL server management Studio
- SQL server profiler
- SSIS
- SDLC
- Agile
- Waterfall
- Data Modeling Logical Physical
- Data Modeling Conceptual
- Python
- MySQL
Timeline
Business Analyst II (Contractor)
Amazon
01.2025 - Current
Business Analyst II (Contractor)
Amazon
09.2022 - 02.2024
Data Analyst
Wunderman Thompson
07.2021 - 09.2022
Process/Data Associate
Plintron
05.2014 - 02.2017
Bachelor of Engineering - Electronics and Communication Engineering
KLNCIT