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…
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, Tableau & Power BI for building, deploying, managing applications and services through a global network of Microsoft - managed data centers. Excellent working understanding of Python and its libraries including Pandas, NumPy, SciPy, Tensorflow, Matplotlib, and Seaborn. Superb attention to detail, highly skilled in Exploratory Data Analytics, Data Modelling, Data Wrangling, Data Cleaning, Data Manipulation, Data Mining, Data Visualization, Data Management. Adept at providing valuable insights via data analytics and advanced data-driven methods. Able to create and present data in graphs, infographics, and other visual methods to the team. Skilled in developing new data collection systems that optimize data management, delivery, and quality. Strong foundation in data structures and algorithm development. Excellent understanding of business operations and analytics tools for effective data analysis. Can work on SDLC, Agile process, and on both Windows and Mac OS environments. Self-motivated team player who has the drive to learn and master new technologies & techniques.
Experience
CVS Health
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
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
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
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