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.

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

Involved in requirements gathering, analysis, design, development, change management, deployment.
Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Worked with key stakeholders to understand the data requirements and translated strategic requirements into usable enterprise information architecture.
Created automated solutions using Databricks, Spark, Python, Snowflake, HTML.
Python for data transformation tools and application development, including experience with web APIs and SQL Server for connecting applications to local data storage.
Designed and implemented a Python-based data processing tool using the "requests" library to automate data retrieval from RESTful APIs, optimizing data collection workflows.
Expertise in Laravel PHP framework for supporting web-based functions and developing custom Web APIs.
Proficient in Microsoft Excel, with strong capabilities in data visualization using Microsoft Power BI.
Engineered an automated reporting system in Python, integrating SQL Alchemy for database interactions, which streamlined the generation of data insights for strategic decision-making.
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.
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.
Implemented a classification algorithm to identify discrepancies in payroll processing, enhancing accuracy by 30% and significantly reducing overpayment errors.
Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull requests. Created Teradata objects like Tables and Views.
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.
Created project presentations for business, stakeholders, and clients using MS PowerPoint.
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.
Performed data comparison between SDP (Streaming Data Platform) real-time data with Azure Data Lake and Snowflake data using Databricks, Spark SQL, and Python.
Established robust Extract, Transform, Load (ETL) processes for populating data marts, incorporating best practices for data integration and transformation.
Implemented metadata management processes to document and track data lineage, ensuring transparency and traceability of data transformations.
Integrated data marts seamlessly with Power BI to empower end-users with interactive and insightful reporting capabilities.
Possessed advanced skills in SharePoint, demonstrating proficiency in utilizing its features and functionalities for effective document management, collaboration, and information sharing.
Used Agile methodology and Scrum process for project development.

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

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

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

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