| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data Analyst/Power BI PHONE NUMBER AVAILABLE Email LinkedInProfessional SummaryHighly skilled SQLBI (SSIS/SSRS/SSAS)/Power BI Developer and Data Analyst with extensive experience in designing and implementing advanced data visualization, data warehousing, and ETL processes. Proven ability to create complex SQL queries, develop data models, and build comprehensive dashboards and reports using Power BI and Tableau. Experienced in Python and SAS for data extraction and transformation, and adept at working with various data platforms including Snowflake, Azure, Hadoop, MongoDB, and SQL Server. Strong background in requirement gathering, database design, and implementing star-schema and snowflake schema data warehouses. Proficient in performance tuning, source code management, and real-time data string.TECHNICAL SKILLSData Visualization: Power BI, TableauData Warehousing: Snowflake, Azure SQL Data Warehouse, Teradata, Star Schema, Snowflake SchemaSQL Development: Complex SQL queries, PL/SQL, T-SQL, Stored Procedures, Views, IndexesETL Processes: SSIS, Python, SAS, Spark, Data Bricks, Apache KafkaBig Data Technologies: Hadoop, Hive, Pig, Cloudera Hadoop YARN, MongoDBReporting & Analysis: SSRS, Business Object Crystal Report, OBIEETools & Environments: MS Excel, Power Point, SVN, JIRA, Agile, Erwin, Visual Studio, TFS, One DriveWORK EXPERIENCEData Analyst/Power BI Developer June 2023 - PresentClient: BCBS, Durham North CarolinaDesigned Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.Developed data warehouse model in snowflake.Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the dataUsed Python& SAS to extract, transform & load source data from transaction systems, generated reports, insights, and key conclusions.Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the businesss needs.Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.Developed complex DAX queries to improve report performance and functionality, enhancing insights into KPIs and other critical business performance metrics. extracted, transformed, and loaded (ETL) data across platforms using CData's connectors for complete reporting.developed and optimized machine learning models with an emphasis on feature selection, classifier optimization, and predictive analytics using the Azure, AWS, and Databricks ML cloud platforms.Created dynamic reports and dashboards in Alteryx and integrate them with visualization tool Power BI.Used tools Power BI within Microsoft Fabric to explore data, identify trends, and uncover insights.Designed and developed custom reports and dashboards in ServiceNow to track key performance indicators (KPIs), service level agreements (SLAs), and other critical metrics.Performed and utilized necessary PL/SQL queries to analyze and validate the data.Wrote Data Bricks code and ADF pipeline with fully parameterized for efficient code management.Design and implement database solutions in Azure SQL Data Warehouse, Azure SQLCreated action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.Created the Power BI report on data in ADLS, Tabular Model and SQL server.Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically.Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement.Experience in building SSIS packages. Dtsx involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.Used forward engineering approach for designing and creating databases for OLAP modelUsed Teradata utilities such as Fast Export, MLOAD for handling various tasksUsed Spark API over Cloudera Hadoop YARN to perform analytics on data in Hive.Configured real-time streaming pipeline from DB2 to HDFS using Apache Kafka.Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.Expertise in writing Hadoop Jobs for analyzing data using Hive QL (Queries), Pig Latin (Data flow language), and custom MapReduce programs in Java.Source code admin - Manage and configure SVN resolve issue regarding source code management, manage branching and merging, code freeze process.Environment: Snowflake, Azure Data Factory, Power BI, Kafka, Hadoop, Yarn, MS Excel, Power Point, SQL Server, SVN, Agile, Mongo DB, JIRA, ETLSQLBI (SSIS/SSRS/SSAS)/Power BI Developer Feb 2021 Nov 2021Client: Capgemini /IndiaPerformed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.Interacted with the business users for understanding the business requirements and the existing system.Perform thorough data quality checks using Excel functions like VLOOKUP, pivot tables, and other validation tools to ensure correct data mapping.created and optimized PL/SQL queries, stored procedures, and triggers to improve data retrieval and processing performance, in addition to managing and maintaining Oracle databases.In order to assure data integrity and system functionality, troubleshoot integration issues between pricing systems and store operations by interacting with service technicians and staff.In order to provide thorough insights on operational indicators and company performance, I created and managed complex reports in Cognos using advanced data modeling.Utilizing Apache Airflow, I managed and implemented intricate data workflows while streamlining task scheduling and orchestration.Reviewed existing SQL queries, execution plans, partitions, and indexes, identifying opportunities for performance enhancements to reduce the execution time of long-running queries.Created and maintained detailed operational and financial reports in Cognos, focusing on claims analysis, premium breakdowns, and risk assessments, ensuring data accuracy and timely delivery of insights to business leaders.Managed the integration of Guidewire systems with internal data infrastructure, enabling automated data flow for claims, policy management, and billing operations, streamlining the data management process.Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2014.Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in staging database.Created Records, Tables, Objects, Collections (Nested tables and Arrays) and Error handling with PL/SQL.Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations fromImplement automation scripts and continuous integration/continuous deployment (CI/CD) pipelines using GitHub Actions or other tools to streamline data processes and deployments.used the capabilities of Microsoft Fabric to ingest data from files, databases, and cloud services, among other sources.Performed data modeling and ETL processes to integrate data from multiple sources into the OBIEE environment, ensuring data consistency and integrity.Conducted performance tuning and optimization of OBIEE reports and dashboards to improve query performance and userexperience.Created many complexes Query' s and used them in Power BI Reports directly to generate reports on the fly.Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files intoSQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.Designed, tested, and deployed modular SQL transformations in DBT for better data modeling practices.Used One Drive for storing different versions of Power BI report.Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time foreach tile in the dashboard.Used JIRA for Version Control needs, task check-ins.Responsible for complete maintenance and delivery of scheduled releases.Environment: MS SQL Server 2014/2008 R2, SSIS 2008/2014, SSRS 2008, Visual Studio 2013/2008, Business object crystal report 2008, Tableau, Power BI Desktop and Report Server on Azure Cloud, TFS, MSData Analyst/MSBI/ Tableau Developer Aug 2018 Jan 2021Client: Birla Soft, IndiaImplementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical reporting and scorecard/ dashboardson SQL Server 2008 R2 using SSAS, SSIS/DTS, SSRS.Based on business requirement, developed complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger toimplementing the business rules and transformations.Design, build, and maintain data pipelines using Google Cloud Platform (GCP) technologies like BigQuery, Cloud Dataflow, and Cloud Storage.Gained experience working with Pension Benefit Management programs, analyzing data to ensure compliance with program requirements and providing insights to support decision-making.Process and analyze huge amounts of data in GCP environments while making sure that additional tools, such Tableau for reporting, integrate seamlessly.Seamless coordination between EWM and TM for optimized logistics.Involved in creating the custom objects, workflows, Visual Flow, Page layouts, Emails, alerts, Templates and data validations, triggers and test classes.Maintained strict confidentiality of business data in adherence to data security policies, ensuring compliance with organizational and regulatory requirements.Created complex SSIS packages using Scripts Task, for each loop, Derived Columns, Fuzzy Lookup, Condition Split, Sort, Union.Extracted relevant data from SAP MM, WM, and EWM modules for analysisExecute SQL Task, Data Flow Task and File System Task.Involved in extracting the data using SSIS from OLTP and OLAP.Created robust data models using Power BI or Tableau to visualize key performance metrics.Coordinated with MM for seamless material movements and inventory updates.Comprehensive analysis of warehouse operations using SAP BI tools to drive continuous improvement.Extracted data from various sources like DB2, Oracle, Flat Files, and XML Files and loaded in to Fact and Dimension tables of dataWorked on the Audit Logs that capture the audit details before and after the package execution using Variables and Parameters.Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly, quarterly reports including current status.Combined SAP data with external data sources for a comprehensive view of business operations.Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of performance.Created Drill reports which give all the details of various transactions like closed transactions, pending approvals and summary oftransactions and scheduled this report to run on quarterly basis using SSRS (Sequel Server Reporting Services).Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS).Provided ongoing QlikView implementation and support. Outlined new features of QlikView for clients.Utilized SAP BI tools for comprehensive reporting and analysis of procurement and inventory data.Extensively involved in SSAS storage and partitions, aggregations, calculation of queries with MDX, Data Mining Models, Tabulardeveloping reports using MDX and SQL.Supported in creating KPI, Calculation Members and Measure groups and MDX queries.Worked with preparing the documentations for analysis, Technical Specification Documents, Functional Specification Documents,Mapping documents etc., for various migrations and upgradation process.Environment: T-SQL, PL/SQL, MS SQL Server 2008R2, SSAS, SSIS, PowerPivot, Erwin r4, Oracle 9i, DB2, Visual SourceSafe (VSS), Tableau, Windows XP and VBScript.EDUCATION DETAILS: -Masters in business Analytics, Lewis University GPA: 3.45/4.0 Jan 2022 May 2023Bachelors in Electronics and Communication Engineering GPA: 6.44/10 June 2015 May 2019Gokaraju Rangaraju Institute of Engineering and TechnologyGraduate Projects:1.Sales Data for Economic Data Analysis sales data is a crucial component for any business, as it helps in analyzing the performance of the business over time. Economic data analysis, on the other hand, helps to understand the economic condition of a country region. Combining sales data with economic data analysis can provide valuable insights.2.RFID and MATLAB based attendance monitoring system with CCTV camera image capture.3.Electronic Controlled Security System for Smart Doorbell using Arduino with MATLAB.Certifications:Introduction to Data Analytics Microsoft & LinkedInAgile Project Management COURSERASAP ERP LinkedInSAP MM LinkedInSQL Essential Training LinkedIn |
