Ananya Ghosal
Data Analyst
Greenwood Village,CO
Summary
Experienced data analysis professional delivering impactful insights and driving business decisions. Specializing in data visualization, statistical analysis, and database management. Known for reliability, analytical thinking, and results-driven approach. Skills in Python, R, SQL, and Tableau ensuring robust data solutions and strategic recommendations for success.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
Work History
Data Analyst
Dish Denver
Denver, Colorado
07.2022 - Current
- Collaborated with stakeholders to identify business needs and data sources.
- Performing Extract,Transform and Load using SSIS and Python and worked with different types of Control flow, data flow tasks performing data enrichment and data management.
- Performed EDA using Python/R and SQL to extract insights and identify key features that contributed to fraudulent activity and improve payment platform.
- Created data models to support decision-making processes.
- Applied machine learning and statistical techniques (e.g., logistic regression, decision trees, and anomaly detection) to identify potential fraud patterns in transaction data.
- Analyzed payment transaction data using statistical methods (e.g., regression analysis, time series forecasting) to identify trends and predict potential issues.
- Created effective dashboards and data visualizations to provide actionable insights. Created different KPIs using calculated fields, parameters in Tableau.
- Developed and maintained data warehouses and data marts to support business operations.
Reporting Developer
Envision Financial Systems Inc
09.2020 - 07.2022
- Designed and developed interactive dashboards using Power BI/Tableau, improving reporting efficiency and providing valuable insights to the management team.
- Developed and maintained ETL pipelines to ensure data was accurately transferred from source systems to reporting databases.
- Wrote complex SQL queries and optimized performance for generating ad-hoc reports.
- Troubleshoot issues with existing reports and made optimizations to improve load times and data accuracy.
- Maximized profitability through diligent analysis of financial reports and data-driven decision-making processes.
- Facilitated seamless collaboration between analysts, engineers, and other stakeholders by serving as a subject matter expert in all aspects of data wrangling process design and execution.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Senior Software Engineer
Happiest Minds Technologies
10.2016 - 09.2020
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Collaborated with management, internal and development partners regarding software application design status and project progress.
- Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.
- Designed enhancements and updates for subsystems of end-user applications software running on local, networked and Internet-based platforms.
- Expedited development timeframes by leveraging pre-built libraries and frameworks such as React.js or AngularJS for front-end components creation.
- Used NodeJS, SQL/No-SQL to develop and manage databases.
- Developed secure RESTful APIs using Node.js and Express for seamless data exchange between frontend and backend systems.
- Build responsive web pages and added interactivity to website using Bootstrap and CSS media Queries.
- Monitor website performance, watching for traffic drops related to site usability problems and rectify issues.
- Improving system performance by writing unit test cases in Jasmine framework and resolving bugs.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
Education
Bachelors of Technology - Information Technology
Orissa Engineering College
BBSR, India 05.2012 - 05.2016
Skills
Python and R programming
Machine learning
ETL processes (Python and SSIS)
Database management
Statistical analysis
Data modeling
Data analysis
Python and R programming
Exploratory Data AnalysisETL ProcessingSoftware Application Testing(UI Testing)Incident Reporting using different tools like Jira and BugzillaDatabases : MySQL, SQL-Server, PostgreSQL, Athena, RedshiftVisualization Tools : Tableau, Power BI, D3js, Jasper ReportsTools /Software : R-studio, Visual Studio, Jupyter Notebook, Pycharm, SSMS,MySQL WorkbenchProgramming/Scripting Languages : HTML,XML,CSS, JavaScript, Python, R ,Java, SQL and Base SASMS Tools: PowerPoint, Sharepoint, Visual Studio, MS-ExcelCertification
Certified Tableau Desktop Specialist: Candidate ID:T000066502Registration ID:457117141
Timeline
Data Analyst
Dish Denver
07.2022 - Current
Reporting Developer
Envision Financial Systems Inc
09.2020 - 07.2022
Senior Software Engineer
Happiest Minds Technologies
10.2016 - 09.2020
Bachelors of Technology - Information Technology
Orissa Engineering College
05.2012 - 05.2016