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
<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
<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
<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>