About Me
Experienced Data Analyst with 3+ years of expertise in SDLC methodologies including Agile and Waterfall. Proficient in Python, R, SQL, and MATLAB with skills in data modeling, data visualization, and ETL processes. Demon…
Experienced Data Analyst with 3+ years of expertise in SDLC methodologies including Agile and Waterfall. Proficient in Python, R, SQL, and MATLAB with skills in data modeling, data visualization, and ETL processes. Demonstrated abilities in database management, visualization tools such as Tableau and Power BI, and ETL tools including SSIS and Informatica. Strong analytical and communication skills, complemented by a Master's in Computer Science.
Experience
Data Analyst
• Follow the Agile Methodology of Project Management.
• Use packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low
graphs to identify the relationship between different variables.
• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split,
Merge Join, Union and Execute SQL Task to load into database.
• Collecting and iteratively refining specifications from management to augment current pivot table
reporting with high-quality dashboard visualizations in Excel.
• Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and
reverse engineering data models and publishing data model to acrobat PDF files.
• Wrote several complex SQL queries to extensively test the ETL process.
• Working on developing Python script for the whole data science project life cycle including data
acquisition, data cleaning, data exploration, and data modeling.
• Performing data analysis and maintenance on information stored in MySQL database.
Data Analyst
Followed the Agile Methodology of Project Management.
Used packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the relationship between different variables.
Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union and Execute SQL Task to load into database.
Collected and iteratively refined specifications from management to augment current pivot table reporting with high-quality dashboard visualizations in Excel.
Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and reverse engineering data models and publishing data model to acrobat PDF files.
Wrote several complex SQL queries to extensively test the ETL process.
Worked on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling.
Performed data analysis and maintenance on information stored in MySQL database.
Jr. Data Analyst
Utilized the Waterfall methodology of development for Requirements, Planning, Design, and Deployment.
Used Python library to represent data in a pictorial form for better understanding.
Created customized reports pointing to the reporting servers per the business request using Power BI.
Skilled in Python modules like Pandas, NumPy, Matplotlib, Scikit - learn, Pisidia, SciPy, PyTables and generating complex graphical data.
Cleaned and Organized data into Tableau & Tableau Prep using data mining processes using ETL, and data warehousing and designed a star schema using SQL Server.
Performed data analysis and data profiling using complex SQL queries on various source systems including SQL Server.