manideep T

manideep T

Data Analyst
United Kingdom

About Me

Around 4+years of experience in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms.
Proficient on the phases of Software …

Experience

Data Analyst

data analyst
May 2024 - Present · 2 years 1 month

 Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
 Interacted with Business partners to understand the requirements, provide solutions using SSRS, SSIS, SSAS, Power BI tools as per need.
 Involved in Data Analysis, Data Mapping and Data Modelling and Performed data integrity, Data Portability testing by executing SQL statements.
 Built and maintained data visualization dashboards using tools such as Tableau, providing clear and concise reports to stakeholders and senior management.
 Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
 Good at creating a Star/Snowflake scheme depending on the requirement and creating complex views or stored procedure to design the required fact & dimension tables for the tabular model and then establishing relationships.
 Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging
 Created different chart types and drill-down reports using Power Bi Desktop (SSRS).
 Designed and documented enterprise application (OLTP), data warehouses (OLAP), and NoSQL databases & logical and physical database designs
 Utilized Tableau to create interactive and visually appealing dashboards for data visualization purposes.
 Created Pipelines to pull data from different sources to Azure Blob and PostgreSQL using Azure Data Factory (ADF V2).
 Optimized the Power BI reports and improved the performance of dashboards by fine-tuning the DAX.
 Designed and built several dashboards involving KPIs and trend charts comparing cumulative vs. actual values to depict the client’s overall business needs.
 Experience on SQL, Python, and Pyspark were used to generate automated Data bricks notebooks, and jobs were used to create worked Data bricks notebooks.
 Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers.
 Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.
 Responsible for developing & implementing end to end solutions using Hadoop, Spark, Flume, Hive, Pig, Sqoop, Cassandra, HBase, MongoDB, spark, zookeeper, AWS.
 Used JIRA as a sprint tracking platform, followed the agile process, and took part in daily SCRUM meetings, sprint planning, showcases, and r

Data Analyst

Sonata Software
Jan 2022 - Present · 4 years 6 months

Create and manage dynamic dashboards and reports.
Ensure accurate and compliant data by working together across sectors.
Leverage SQL, Python, Tableau, and Power BI to uncover insights and improve operations.
Effectively convey messages while using data visualization to shape achievement.
Define and analyze data requirements needed to support business processes within information systems.
Interact with business partners to understand requirements and provide solutions using SSRS, SSIS, SSAS, and Power BI.
Perform data analysis, data mapping, and data modelling.
Perform data integrity and data portability testing by executing SQL statements.
Build and maintain data visualization dashboards using Tableau.
Extract data from different sources and store the data into the intermediate staging database using SSIS ETL tool.
Create a Star/Snowflake scheme depending on the requirement.
Create complex views or stored procedures to design fact and dimension tables for the tabular model.
Establish relationships for the tabular model.
Utilize Power Query in Power BI to pivot and un-pivot the data model for data cleansing and data massaging.
Create different chart types and drill-down reports using Power BI Desktop (SSRS).
Design and document enterprise application (OLTP), data warehouses (OLAP), and NoSQL databases and logical and physical database designs.
Utilize Tableau to create interactive and visually appealing dashboards for data visualization purposes.
Create pipelines to pull data from different sources to Azure Blob and PostgreSQL using Azure Data Factory (ADF V2).
Optimize Power BI reports and improve dashboard performance by fine-tuning DAX.
Design and build dashboards involving KPIs and trend charts comparing cumulative versus actual values.
Use SQL, Python, and Pyspark to generate automated Databricks notebooks and jobs.
Develop custom SQL, T-SQL, stored procedures, functions, and triggers.
Convert Boulder Tables from Excel to Power BI with better graphs and visualizations.
Develop and implement end-to-end solutions using Hadoop, Spark, Flume, Hive, Pig, Sqoop, Cassandra, HBase, MongoDB, Spark, Zookeeper, and AWS.
Use JIRA as a sprint tracking platform.
Follow the agile process and take part in daily SCRUM meetings, sprint planning, showcases, and retrospective.
Create daily and monthly reports using SQL and UNIX for business analysis.

Data Analyst

Synechron
Aug 2019 - Jan 2022 · 2 years 5 months

Perform extensive data modelling to differentiate between OLTP and Data Warehouse data models.
Build multiple Power BI reports using multiple SQL tables for data visualization and publishing on Power BI cloud.
Design and develop Oracle PL/SQL and Shell Scripts, data import/export, data conversions, and data cleansing.
Create Python script for fuzzy match of names and address based on match score accuracy and percentage confidence.
Create and review SSAS tabular cubes for consuming as a data source for reports, dashboards, and pivot tables.
Work on creating Star schema cubes using SSAS.
Use Spark for interactive queries, processing of streaming data, and integration with popular NoSQL database for huge volume of data.
Use Report Designer and Report Builder in Microsoft SQL Server Reporting Services (SSRS).
Create SSIS packages using ETL methods for loading data from several external sources and internal servers.
Install, configure, and administer Jenkins on Linux with plugins such as SVN, GIT, Maven, ANT, and Puppet.
Use DAX for writing functions and building formulas and expressions in Power BI.
Work on structured data analysis utilizing SQL, Tableau, Excel, and Python.
Use Tableau Server to publish and share reports with business users.
Collaborate with the security team to develop various Tableau services.
Use SQL, SQL Azure, Azure Storage, Azure Data Factory, SSIS, and PowerShell for data migration.
Use JIRA tickets and assist in their closure by supplying workable solutions to the problem.
Participate in Agile process with backlogs and story points and daily scrum meetings.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Software Design Database Design Business Intelligence SDLC Waterfall Agile Data Modeling Enterprise Data Management Data Presentation Visualization Optimization Risk Assessment Predictive Analysis Data Analysis Business Research Quantitative Analysis SQL Server Integration Services SSIS SQL Server Reporting Services SSRS SQL Server Analysis Services SSAS ETL Informatica PL/SQL HBase Cassandra Snowflake AWS S3 Power Query Power Pivot Power View Power Maps Data Cleansing GIT CI/CD Crystal Reports MDX T-SQL Azure Storage Azure SQL Data Warehouse Azure Data Lake Azure Cosmos DB Azure Stream Analytics ER Modeling OLTP Kimball Methodology OLAP
Report this Profile?