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 …
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 Development Life Cycle (SDLC) and models including Waterfall and Agile.
As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis
Extensive experience in SQL Server 2016/2012/2008 Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
Exclusively experienced in Extracting, Transforming and Loading (ETL) data from spreadsheets, database tables and other sources with Informatica.
A very good experience with dealing different types of data sources such as flat files, Excel, Oracle, XML and SQL Server.
Demonstrated experience in statistical analysis, predictive modelling, and data visualization, facilitating effective communication of complex findings to diverse stakeholders
Good experience on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL.
Have experience of NOSQL databases like HBase and Cassandra.
Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems which include loading nested JSON formatted data into snowflake table.
Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.
Experience in reports deployment automation with Power shell scripts to publish reports to Power BI Service. Gained knowledge GIT experience for dev-ops, including building and releasing pipelines for CI/CD.
Developed Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS).
Well versed in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
Hands-on experience on MDX, T - SQL, PL SQL, Power Pivot, and Power View reports. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins, and Query Writing.
Experience in designing and delivering solutions using the Azure Data Analytics platform including Azure Storage, Azure SQL Data Warehouse, Azure Data Lake, Azure Cosmos DB, Azure Stream Analytics.
Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling / Kimball Methodologies for OLAP.
Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
Experience working on Tableau (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.
Hands on in Designing, maintaining, and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS.
Proficient in programming languages such as Python and R, with hands-on experience in SQL and database management systems.
Implement one-time data migration of multistate level data from SQL Server to Snowflake by using Python and Snow SQL.
Hadoop knowledge of Map Reduce and Spark. Excellent understanding of the Spark (Spark SQL, Spark Streaming) and Hadoop 2.0 (HDFS, Hive, Pig, Impala) ecosystems as they relate to big data.
Skilled on how to manage projects, processes, custom fields, dashboards, and reports using JIRA.
Experience
Data Analyst
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
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
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.