Ayushi Rajput

Ayushi Rajput

Data Analyst | Product Analyst
United States of America

نبذة عني

Highly motivated Data Analyst with around 5 years of IT & product analysis experience having multiple skill sets, extensive working experience in Data Warehousing and BI technologies with expertise in SQL development, Ta…

الخبرة

CVS Health

not listed
Aug 2023 - حتى الآن · 2 سنوات 11 أشهر

Develop the product roadmap manage the lifecycle of the product and provide a dashboard report to the marketing team
 Involve in analysis, design, and documenting business requirements and data specifications
 Supported data warehousing extraction programs, end-user reports and queries
 Create and maintain project schedule and database documentation, and act as liaison between all departments
 Develop programs with manipulate arrays using libraries like NumPy and Python
 Use SQL Queries at the custom SQL level to pull the data in the Tableau desktop
 Prepare dashboards by calculating fields, parameters, calculations, groups, sets & hierarchies in Tableau
 Create and Published Tableau Dashboards into Tableau Server
 Collaborate with various to streamline various processes and update them
 Collaborate with Project Managers, Architects, Engineers, Developers, and Designers on scope, solutions, constraints, and risks

Product/Data Analyst

CVS Health, NJ
Aug 2023 - حتى الآن · 2 سنوات 11 أشهر

Develop the product roadmap
Manage the lifecycle of the product
Provide a dashboard report to the marketing team
Involve in analysis, design, and documenting business requirements and data specifications
Supported data warehousing extraction programs, end-user reports and queries
Create and maintain project schedule and database documentation
Act as liaison between all departments
Develop programs with manipulate arrays using libraries like NumPy and Python
Use SQL Queries at the custom SQL level to pull the data in the Tableau desktop
Prepare dashboards by calculating fields, parameters, calculations, groups, sets & hierarchies in Tableau
Create and Published Tableau Dashboards into Tableau Server
Collaborate with various to streamline various processes and update them
Collaborate with Project Managers, Architects, Engineers, Developers, and Designers on scope, solutions, constraints, and risks

Data Analyst

CueTech Systems, India
Aug 2020 - Jun 2022 · 1 سنة 10 أشهر

Performed data preprocessing & feature engineering for further predictive analytics by Python
Manipulation, Automation, and Analysis of Data using Python programming
Executed SQL queries from Python on complex table configurations
Generated report on predictive analytics using Python & Power BI including visualizing model performance & prediction results
Create, maintain, modify, and optimize SQL Server databases
Retrieving data from the database through SQL as per business requirements
Designed high-level ETL architecture for overall data transfer from the source server to the enterprise services warehouse
Used SQL server to pull data into Power BI & created Power BI reports by using joins in multiple tables from multiple databases using complex SQL queries
Design & develop Power BI graphical & visualization solutions with BRD and plans for creating interactive dashboards
Developed various solution-driven views, reports & dashboards by developing different chart types including Pie, Bar, Tree Maps, Circle Views, Line, Area, and Scatter Plots in Power BI, scheduling refreshes of Power BI reports, hourly/on-demand
Created reports utilizing Excel services and Power BI
Participated in providing project estimates for development team efforts for offshore & on-site

Sr. System Engineer

Infosys, India
Dec 2017 - Mar 2020 · 2 سنوات 3 أشهر

Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures
Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
Worked with data architects team to make appropriate changes to the data models
Tested the data using the Logs generated after loading the data into Data warehouse
Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
Worked with the data governance team to ensure the data quality of compliance reports for EDI transactions
Utilized Tableau server to publish and share the reports with the business users
Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups
Prepared Traceability Matrix with requirements and test cases

المهارات

نظام معلومات الحاسوب نظام معلومات الإدارة Python SQL Pandas NumPy SciPy TensorFlow Matplotlib Seaborn MySQL SQL Server Snowflake AWS Redshift ETL Hypothesis Testing Z-test T-test P-test Chi-square Regression Salesforce Statistics Tableau Power BI Alteryx Git GitHub Trello Jira Microsoft Office Excel SDLC Agile Scrum Waterfall MacOS Windows Data Warehousing Data Wrangling Data Cleaning Data Manipulation Data Mining Data Visualization Data Management EDA Descriptive Analytics Diagnostic Analytics Predictive Analytics Prescriptive Analytics Text Analytics Google Analytics
الإبلاغ عن هذا الملف الشخصي؟