MARINA Azimi
Lawrenceville
Summary
Highly analytical and process-oriented Data Analyst/Power BI Developer with 7 years of work experience in data analysis and data management and has proven ability to work efficiently in both independent and teamwork environments. Designing and executing A/B testing, creating machine learning models for driving efficient growth in R-Studio. Conducted in-depth analysis of Performance Network Service Provider (PNSP) metrics to evaluate network efficiency and identify opportunities for improvement. knowledge and usage of reporting tools such as Tableau, SAS, SSRS, MicroStrategy and Power Bi Experience in data analysis, data visualization using Tableau/Microsoft Power BI, model building with machines using statistical/econometric tools like SAS data mining, and SQL. Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. Managed the data entry of issues requiring remediation into the client's ticketing management system, ensuring accuracy and timeliness. Proficiency in Troubleshooting SQL queries, ETL jobs, data warehouse. Build SQL scripts, indexes, and complex queries for data analysis and extraction that provide database coding to support business applications using T-SQL. Extensive experience with end-to-end data analysis, encompassing data cleaning, data manipulation, database (Oracle) testing, and control development in R and SQL. Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies. Experience in creating technical metadata for the underlying physical data model of the Source systems as well as Data Warehouse. Experience in SAS, SQL, SSRS, Tableau, Python, MS EXCEL (VLOOKUP, VLOOKUP charts, Macros). Proficient in data mining languages like base SAS and SAS SQL. Skills in SQL, data warehouse, data exploration, data extraction, data validation, reporting and excel. Used tools like Tableau and Microsoft Excel for data analysis and generating data reports Developed visualizations using Tableau for better understanding of data, performed data cleaning, normalization, data transformation Extensively used SQL for accessing and manipulating database systems. Capable in Text Analytics, generating data visualizations and creating dashboards using tools like Tableau & PowerBI.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Analyst
Bioscape Digital
06.2022 - Current
- Project Description: I used to work as a Business Data Analyst to gather the data of healthcare providers with user-friendly technology solutions to enhance patient engagement, improve patient experience, and streamline care coordination.
- Responsibilities:
- Followed Agile Methodology in analyze, define, and document the application, which will support
- Work as a Tech Bridge for software application migration approaching SDLC mainly on tech analysis, design, development, testing, and maintenance of software.
- Ensured Function and Integration testing for DB and Application and ensured the Development and Testing phase of SDLC.
- Managed the data entry of issues requiring remediation into the client's ticketing management system, ensuring accuracy and timeliness.
- Actively experienced in Analysis, Detail Design, Development, Bug fixing and Enhancement in Agile methodology.
- Worked in data mining, data cleansing, data profiling, data modeling, data quality and data warehousing.
- Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
- Worked on Big Data analytics platform for processing customer viewing preferences using Java, Hadoop, and Hive.
- Worked on investment banking industry, project finance, credit card industry, mortgage loan servicing, ACH, Wire transfers, commercial banking, retail, banking, Capital Management, and credit risk fundamentals.
- Worked on creating Tableau, and Grafana dashboards to produce different views of data visualizations and presented dashboards on web and desktop platforms to End-users and helped them make effective business.
- Highly used Hadoop (pig and Hive) for basic analysis and extraction of data in the infrastructure to provide Data Summarization.
- Worked in Relational Database Management Systems RDBMS and Rapid Application Development Methodology.
- Created Data Mapping STTM Creation from the Data Warehouse RD to RDS, Glue, and Snowflake. Created mapping specifications from Data Warehouse to SAS, Cognos, and MicroStrategy Data marts.
Data Analyst
Frontdoor Inc
05.2020 - 05.2022
- Responsibilities:
- Focused on selling and flipping properties, a recent project involved conducting market research and analyzing property data to identify undervalued properties with potential for renovation and resale at a higher price point.
- Directed all aspects of data analysis for real estate investments, utilizing Excel and Python to build financial models that increased ROI by 20%.
- Streamlined cost analysis and project management for property renovations, effectively coordinating with contractors and optimizing budget allocation.
- Enhanced operational workflows by implementing Agile methodologies, improving project delivery timelines and stakeholder communication.
- Designed and optimized database structures, tables, and indexes for improved query performance.
- Developed comprehensive reports and dashboards to effectively communicate insights and trends to stakeholders.
- Developed data mining models and implemented them in real-world scenarios to optimize business processes and improve decision-making.
- Proven track record of delivering actionable insights and driving business growth through data-driven initiatives.
- Created complex SQL queries to retrieve specific information from large databases efficiently.
- Create an executive report using advanced SQL features such as common table expression, window function, rank order, pivoting, etc.
- Create action filters and parameters and calculate sets for preparing dashboards and worksheets in Tableau.
- Involving requirements gathering and source data analysis and identified business rules for data migration and for developing the data warehouse.
- Perform SQL operations that include advanced filtering and data aggregation, window functions.
- Writing SQL (DDL, DML, AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, functions (UDF), cursors, triggers, locking issues, common table expressions (CTEs).
- Generate a variety of business reports from SQL server using excel with a pivot table and pivot chart.
- Constructed interactive KPI dashboards and implemented funnel and cohort analysis for customer behavior and product sales using Tableau.
- Represented efficiently forecasted product demand to the Sales and production teams through power BI dashboards, helping in Inventory Optimization, resulting in saving 10% production cost
- Proactively advanced opportunities to track business results and make recommendations and financial projections to product owners, vendors, and other internal stakeholders
- Optimized SQL performance, integrity, and security of the databases and schemas, contributed to optimization of data manipulation techniques and performance tuning
Data Analyst
CWU Inc
03.2014 - 06.2017
- Responsibilities:
- Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
- Worked on SSIS packages to Extract, Transform and Load data from heterogeneous sources into data warehouses, performed data cleaning and data validation before marketing analysis.
- Constructed customized reports using SQL Reporting services as per ad hoc requests by client implementation teams.
- Worked on financial data for analyzing revenue inference, profit fluctuations and customer value matrix.
- Analyzed market trends using statistical analysis, presented the KPIs resulting in CCM growth and insights to senior leadership, contributing to business decision-making targeting 10% profit next quarter.
- Led the integration of new healthcare analytics software, enhancing data capture and analysis capabilities using SQL Server and SPSS.
- Analyzed the requirements and segregated them into high level and low-level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models
- Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights
- Was responsible for indexing the tables in that data warehouse. Used senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data warehouse processes
- Used tools like Tableau and Microsoft Excel for data analysis and generating data reports
- Worked on 1000+ ad hoc queries on JIRA for reporting, Tableau dashboards, and data investigation using SQL queries.
- Managed team of Data Integration Analysts and Data Engineers for successful implementation of new data platforms for recently acquired companies
- Worked on heterogeneous relational databases like Teradata, Oracle, MS Access, SQL Server, and AWS Redshift for data mining, manipulation and analysis
- Developed automated ETL data pipelines in SSIS to extract data from disparate data sources and load it into a consolidated data warehouse, improving the analytics efficiency by 20%
- Developed analytics solutions that improved patient care processes, utilizing data visualization tools like IBM Cognos to communicate findings effectively.
- Collaborated with IT and clinical teams to tailor healthcare systems to the evolving needs of the organization, significantly improving data usability.
- Authored detailed analytical reports that informed policy changes and improved service delivery, influencing key decision-makers within the healthcare sector.
- Managed and analyzed critical data sets related to healthcare processes, using Microsoft SQL Server and advanced Excel features for robust data manipulation.
- Analyzed the data warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed
- Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs
Education
Bachelor of Arts -
Hazara University
01.2000
Skills
- Programming Languages: C, Visual Basic
- ETL tools: Confidential Power center, SSIS, AB Initio
- MS-Office Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project)
- Data Visualization Tools: Tableau, Power BI, IBM Cognos
- Statistical Software: SAS, SPSS
- ETL Tools / Tracking tool: Confidential, SSIS, SSAS, SSRS / JIRA
- Database Development: T-SQL and PL/SQL, Microsoft Hyper-V Servers
- Databases: Teradata R12 R13 R1410, MS SQL Server, DB2, Netezza
- Testing and defect tracking: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe
- Operating Systems: Windows, UNIX, Sun Solaris
- Methodologies: Scrum
- Excel functions
Certification
Business Analytics Science, Ziplines Education, March 2024, Credential ID: 98400500
Timeline
Data Analyst
Bioscape Digital
06.2022 - Current
Data Analyst
Frontdoor Inc
05.2020 - 05.2022
Data Analyst
CWU Inc
03.2014 - 06.2017
Bachelor of Arts -
Hazara University
Similar Profiles
Hanief ArviantoHanief Arvianto
Head of Legal at PT True Digital Indonesia (part of True Digital Group Thailand)Head of Legal at PT True Digital Indonesia (part of True Digital Group Thailand)
Grace BlakeGrace Blake
MTPE Project Coordinator & Editor at Digital Press Media (Books Digital Media)MTPE Project Coordinator & Editor at Digital Press Media (Books Digital Media)
Dipendra GhoshDipendra Ghosh
Program Manager at Lummus Digital - TCG Digital Solution LLCProgram Manager at Lummus Digital - TCG Digital Solution LLC
Payton WardPayton Ward
Customer Service Associate at KrogerCustomer Service Associate at Kroger
Vanessa TorresVanessa Torres
Server/Bartender at RReal TacosServer/Bartender at RReal Tacos