Suneetha M

About Suneetha M

Over all 8 years of experience in Data Analyst, business requirements gathering, database design and development of Web Based, and Client/Server applications.• Experienced Data Analyst/Business Analyst in IT, Banking and insurance industry, Life Science. Experienced with different Relational databases like Teradata and SQL Server.• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.• Extensive knowledge in RDBMS, Data Warehousing, OLAP and OLTP. Very experienced in creating source to target data mapping documents in a data warehouse environment and executing SQL queries in a data warehouse environment In - depth knowledge and understanding of Concepts of Data Warehouse• Explore data in a variety of ways and across multiple visualizations using Power BI.• Hands on experience with SQL database, MS SQL Server, MYSQL and Oracle SQL.• Tested data quality for MDM, customer data integration and Match-Merge process• Experience in Business Intelligence, OLAP, OLTP, Star / Snowflake Schemas and Data Modeling (Physical/Logical/ER-Diagrams) etc.• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).• Experience in testing Business Intelligence reports generated by various BI Tools like Tableau, Cognos Series and Business Objects.• Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.• Experience with designing and verifying databases on DB2, Teradata, SQL Server RDBMS using Entity-Relationship Diagrams (ERD).• Expertise on ETL process and Reporting using SQL Server, SSIS and SSRS.• Experience writing SQL Queries for Data Validation and Data Integration.• Developing and executing Test Procedures, Test plans, Test scripts, test result validation, performing functional, usability, stress testing and ensuring that the software meets the system• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).• Experienced in creating Use Cases, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams and Class Diagrams using Rational tools and Microsoft Visio.

Experience

1. Data Analyst Bi Business Analyst

   Arch Insurance Group Inc.

   Mar 2021 — Present · NJ, US

   Gathering, process analysis, and application design sessions with company staff across all levels and functions and performed extensive Requirement Analysis including data analysis.• Built a Structured Analytical Data Framework in terms of relational and dimensional databases using SQL, Python and Excel and created a standard metadata for the HR team.• Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database.• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.• Created ETL pipelines for data flow from various sources ranging from Hadoop through Hive and Teradata RDBMS into raw and summary data.• Used ETL in Informatica, Python and SQL to transform and prepare the data for further statistical analysis.• Performed data cleaning based on imputation methods including regression imputation.• Analyzed the pattern on data and found the best suited algorithm for predictive analytics.• Modified existing dashboards as per new requirements in Power BI.• Created the Teradata Fast Load and the Multi load scripts to load the data from the Source to Staging and from staging to Base tables.• Implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.• Gathered requirement and proposed possible solutions to satisfy business needs and designed/ created star, snowflake schema models.• Created report form with Stored Procedure using T-SQL• Performed root-cause analysis to identify reasons for fluctuations in different sources of revenue and customer satisfaction using descriptive and Regression analysis in python and created visualizations through Tableau.

Education

• Sri Krishna devaraya University

  MBA at Sri Krishna devaraya University, 2010

  2010