Ayushi Rajput

Ayushi Rajput

Data Analyst | Product Analyst
United States of America

About Me

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…

Experience

CVS Health

not listed
Aug 2023 - Present · 3 years 2 months

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 - Present · 3 years 2 months

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

Data Analyst

CueTech Systems, India
Aug 2020 - Jun 2022 · 1 year 10 months

<p>Performed data preprocessing & feature engineering for further predictive analytics by Python<br>
Manipulation, Automation, and Analysis of Data using Python programming<br>
Executed SQL queries from Python on complex table configurations<br>
Generated report on predictive analytics using Python & Power BI including visualizing model performance & prediction results<br>
Create, maintain, modify, and optimize SQL Server databases<br>
Retrieving data from the database through SQL as per business requirements<br>
Designed high-level ETL architecture for overall data transfer from the source server to the enterprise services warehouse<br>
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<br>
Design & develop Power BI graphical & visualization solutions with BRD and plans for creating interactive dashboards<br>
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<br>
Created reports utilizing Excel services and Power BI<br>
Participated in providing project estimates for development team efforts for offshore & on-site</p>

Sr. System Engineer

Infosys, India
Dec 2017 - Mar 2020 · 2 years 3 months

<p>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<br>
Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results<br>
Worked with data architects team to make appropriate changes to the data models<br>
Tested the data using the Logs generated after loading the data into Data warehouse<br>
Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)<br>
Worked with the data governance team to ensure the data quality of compliance reports for EDI transactions<br>
Utilized Tableau server to publish and share the reports with the business users<br>
Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups<br>
Prepared Traceability Matrix with requirements and test cases</p>

Skills

Computer Information System Management Information System 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
Report this Profile?