VINEET CHANDRA NANDIKANTI

Company: S& P

Client: KPMG

Role: Power BI Developer Duration: Nov 2021 to Till date

Description:As part of the data innovation team focusing on developing analytics-based products and solutions as part of client service industry. My responsibility is to build scalable and interactive Business Intelligence solutions that will serve the client in driving Business Insights. The role involves working independently in an Agile approach while collaborating with counterparts across workstreams to develop automated analytics business solutions

Responsibilities:

· Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

· Worked on how to handle security according to needs when creating reports, charts, and dashboards using Power BI Desktop.

· Worked on creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).

· Used Power Query, transform, define, and browse the data from the data source and execute merge and append queries.

· Used T-SQL constructs for data querying, such as joins, sub queries, derived tables, and views.

· Worked on many DAX functions have been implemented for various fact calculations to facilitate effective data display in Power BI.

· Used detail level summary report sets, groups, hierarchies, backdrop images, maps, trend lines, computations, advanced analytical activities, and KPI dashboards.

· Responsible for optimizing queries which take longer time in execution with SQL Server 2019/2016/2012.

· Experience of a range of data processing languages and systems, including Oracle PL/SQL, SQL Serve T-SQL, MySQL, and PostgreSQL.

· Extensive experience with Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling, Star Schema Modeling, and Data Warehouse.

· Worked on Data Modelling and Data Mining tomodel the data as per business requirements.

· Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.

· Developed a variety of joins (inner, outer joins) and complicated SQL queries in Access to retrieve the required output for data analysis. Used a variety of sources, including SQL Server, Excel, the cloud, SQL Azure, etc., to import data into Power BI.

· Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, Power Shell.

· Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards

· Implemented version control using Git for ETLprocesses, data mapping, analytics scripts, dashboard development, and report templates, ensuring collaboration and tracking changes.

· Utilized Git as the version control system for source code management, ensuring efficient collaboration, and change management.

· Involved in migrating Tableau reports to PowerBI with multiple data sources like Salesforce and web portals. Developed custom visuals using Python and R languages.

· Used SQL, Python, and PySpark, worked Data bricks notebooks were generated, and automated notebooks were made using tasks.

· Used for testing and data processing, Scala and Spark-SQL were used to develop Spark.

· Worked on track record of modifying Jiraprojects with a wide range of schemes, complex processes, flows, authorization schemes, and notification schemes.

· Actively applied Agile Methodology practices for development of the Microsoft reporting environment.

Environment: Power BI, Tableau, SQL, Azure Data Factory, RLS, Git, Python, Pyspark, Scala, Jira, Excel, My SLQ, PostgreSQL, KPI, Snowflake, Star, T SQL, DAX, Power Desktop, View, Pivot, Query, Maps, Agile, ETL.

Company: EPAM

Client: IQVIA

Role: BI/SQL Developer Duration: May 2019 to Nov 2021

Description:IQVIA Consumer Health Ecomm and its BIDS team (Business Intelligence and Data Science) continuously invest in ways to help life science companies find the next breakthrough in improving human health. Building Industry benchmarking to compare financial and operational performance, and target areas for improvement. Created Datawarehouse and Reports performing IQVIA data analytics, Projection, Imputation and quality check.

Responsibilities:

· Designed, developed, modified and enhanced the database structures and database objects. Data warehouse and data mart designs efficiently support BI and end user requirements

· Used Power Query to implement ETL Methods on the PowerBI desktop, combine diverse data sources, including SQL servers, spreadsheets, and external data obtained through web services, into a single, centralized data warehouse.

· Designed Power BI data visualizationutilizing cross tabs, maps, scatter plots, pie, bar and density charts.

· Daily tasks included processing client-supplied external files and, on occasion, transferring data across servers using Older DTS Packages in a SQL Server 2000/2005/2008 /2016environment.

· Experience on PL/advanced SQL features, such as Records, Tables, Object types, and Dynamic SQL, extensively.

· Designed the structure and relationship between the fact table and dimension table enabling end- users to have in and be able to produce their own Self BI Reports by developing the Data model in the form of a Star Schema.

· Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.

· Created Power BI reports using DAX using a variety of data sources, including Microsoft SQL Server, MySQL DB, SharePoint, and Excel, and published the BI solutions to the Power BI service.

· Developed dashboards in the Tableauenvironment and published them to the server using Tableau Desktop.

· Created data visualizations using various visual objects (line chart, bar chart, tree map, single card, KPI, map, pie chart, custom visuals).

· Involved in creating the external and internal tables in Azure SQL Data warehouse and created stored procedures to move the data from external to internal tables.

· Developed automated reports and scheduled updates using Tableau's publishing and scheduling features, providing stakeholders with up-to-date insights.

· A Python script was created to process big data sets and to extract data from various files.

· Employed JIRA as a tracking tool for the sprints, participated in daily SCRUMmeetings, sprint planning, showcases, and retrospective, and adhered to the agile methodology.

· Developed various UNIX shell scripting for data scrubbing to load monthly loads in Redshift Data ware house.

Environment: Power BI, Power Query, ETL, SQL Server, PL SQL, Star, SSIS, DX, Git, Azure, Tableau, Python, Jira, Unix Shell, Agile, Scrum, My SQL, Excel.