Somnath

Detail-focused Data Analyst with knowledge in data warehousing, process validation, and business needs analysis. Proven to understand customer requirements and translate them into actionable project plans. Dedicated and hard-working with a passion for Big Data.

<p>Participated in daily team meetings to discuss project progress and challenges.<br>
Collaborated with business users and IT teams to gather requirements, ensuring a clear understanding of business processes and logic.<br>
Extracted data from various sources such as SQL Server, SQL Server Analysis Services, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.<br>
Developed complex SQL statements, including stored procedures and common table expressions (CTEs), to extract data from the data warehouse server for report creation.<br>
Integrated data lakes with various data sources, ensuring seamless data flow and accessibility for analytics and reporting purposes.<br>
Developed a Python-based data transformation tool, enhancing data accessibility from qTest and Inventory Management systems, directly supporting the Diagnostics Team's analysis capabilities.<br>
Developed a comprehensive database management system utilizing SQL Alchemy ORM for efficient data manipulation.<br>
Implemented Power BI dashboards for Diagnostics Program Management, improving data visualization and decision-making efficiency.<br>
Automated inventory management processes using Laravel, reducing manual data entry errors by 25% and saving approximately 200 hours of team effort annually.<br>
Applied clustering techniques to segment employee data, optimizing operations and enabling personalized compensation packages, which increased employee satisfaction and retention rates.<br>
Built interactive and storytelling dashboards in Tableau workbooks using dashboard actions.<br>
SQL Server for database management, with extensive experience in developing and maintaining Python-based tools for data access and inventory management.<br>
Implemented Data Analysis Expressions (DAX) for creating measures and calculated fields, extensively using DAX functions for reports.<br>
Created PowerPivot models and reports, published them on SharePoint, and deployed models into SQL Server SSAS instance.<br>
Designed and developed star and snowflake schema data marts, ensuring efficient storage, quick retrieval, and easy interpretation of business data.<br>
Worked on Power BI reports, employing various visualizations like line charts, doughnut charts, tables, matrices, KPIs, scatter plots, box plots, etc.</p>

<p>Involved in requirements gathering, analysis, design, development, change management, deployment.<br>
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.<br>
Worked with key stakeholders to understand the data requirements and translated strategic requirements into usable enterprise information architecture.<br>
Created automated solutions using Databricks, Spark, Python, Snowflake, HTML.<br>
Python for data transformation tools and application development, including experience with web APIs and SQL Server for connecting applications to local data storage.<br>
Designed and implemented a Python-based data processing tool using the "requests" library to automate data retrieval from RESTful APIs, optimizing data collection workflows.<br>
Expertise in Laravel PHP framework for supporting web-based functions and developing custom Web APIs.<br>
Proficient in Microsoft Excel, with strong capabilities in data visualization using Microsoft Power BI.<br>
Engineered an automated reporting system in Python, integrating SQL Alchemy for database interactions, which streamlined the generation of data insights for strategic decision-making.<br>
Utilized qTest for centralized test management, significantly enhancing communication within the QA team and streamlining the bug tracking process, which contributed to a 20% improvement in project delivery timelines.<br>
Developed a machine learning model using Python to forecast payroll expenses, resulting in a 20% reduction in budget discrepancies by accurately predicting staffing needs and overtime expenses.<br>
Implemented a classification algorithm to identify discrepancies in payroll processing, enhancing accuracy by 30% and significantly reducing overpayment errors.<br>
Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull requests. Created Teradata objects like Tables and Views.<br>
Applied advanced Excel features, including pivot tables, data validation, VLOOKUP, and intricate formulae, to conduct comprehensive data analysis and create insightful presentations, decision-making in the role of a data analyst.<br>
Created project presentations for business, stakeholders, and clients using MS PowerPoint.<br>
Captured end-to-end lineage and ensured proper impact analysis has been performed in the event of changes to data assets as they move across the pipelines.<br>
Performed data comparison between SDP (Streaming Data Platform) real-time data with Azure Data Lake and Snowflake data using Databricks, Spark SQL, and Python.<br>
Established robust Extract, Transform, Load (ETL) processes for populating data marts, incorporating best practices for data integration and transformation.<br>
Implemented metadata management processes to document and track data lineage, ensuring transparency and traceability of data transformations.<br>
Integrated data marts seamlessly with Power BI to empower end-users with interactive and insightful reporting capabilities.<br>
Possessed advanced skills in SharePoint, demonstrating proficiency in utilizing its features and functionalities for effective document management, collaboration, and information sharing.<br>
Used Agile methodology and Scrum process for project development.</p>

<p>Collaborated with a diverse team of clients, analytics experts, data sources, QA professionals, and visualization specialists.<br>
Played a role in agile processes, showcasing expertise across the entire project life cycle, from inception to completion.<br>
Established data warehouses and data marts from the ground up, aligning with specific data structures and reporting needs.<br>
Crafted ad hoc SQL scripts crucial for meeting reporting requirements.<br>
Developed fundamental dashboards in Tableau, connecting them to Azure SQL databases for client reporting.<br>
Managed user access and facilitated dashboard access for Power BI online.<br>
Utilized Power BI for both dashboard creation and the execution of ad hoc DAX queries.<br>
Provided robust back-end support for a variety of reports on both Tableau and Power BI.<br>
Created stored procedures, functions, triggers, indexes, and views to enhance data processing and cleansing.<br>
Designed and executed advanced Power BI reports, enhancing data visualization and decision-making processes for internal customers.<br>
Generated a range of SSIS packages for efficient data movements and transformations.<br>
Implemented Python code to efficiently load data from Google buckets into Big Query tables, employing data flow for ELT in Big Query.<br>
Possessed hands-on experience in Applications Migration and App Development within AZURE.<br>
Engaged in Web jobs, AZURE data factory, and Logic Apps for effective application and project development in Azure.</p>

<p>Evaluated client requirements and content standards for each phase of product development to produce quality creative structure.<br>
Designed custom mapping applications using Adobe Creative Suite – predominantly Illustrator and InDesign.<br>
Conducted meticulous research to identify information and answer multifaceted questions on urban sustainability management.</p>

<p>Performed several ad-hoc analyses to support business needs and presented them to discrete business units.<br>
Prepared project documentation at all stages of implementation as part of knowledge transfer and listed simple steps for users to refresh and update Excel tools.<br>
Adept at crafting and customizing reports using the Guidewire InsuranceSuite platform.<br>
Possess expertise in retrieving and analyzing data from Guidewire InsuranceSuite databases, unveiling valuable insights.<br>
Used Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in line with Agile Software Development methodologies.<br>
Helped manage the Global Leadership online platform and cultivated a network of environmentalists.<br>
Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables.<br>
Transformed staging area data into a STAR schema, which was then used for developing embedded PowerBI dashboards.<br>
Applied advanced data modeling techniques to create a clear and comprehensive representation of business entities and relationships within data marts.<br>
Developed strong professional relationships by communicating effectively with a wide variety of colleagues and external contacts.<br>
Handled performance requirements for databases in OLTP and OLAP models.<br>
Generated, constructed, and executed a SQL script to apply DB modifications such as updating indexes and adding tables.</p>

<p>Worked alongside senior scientists on an ongoing project.<br>
Designed UML diagrams/models, Activity diagrams with Microsoft Visio and Lucid chart for better understanding.<br>
Supported IT department in handling technology rollout and maintenance.</p>