Priyanka B

Client: Deutsche Bank

Description: The bank main activities are loan origination and deposit generation. In this bank, my duties included creating, implementing, and maintaining all databases, including complex queries, triggers, and stored procedures. I also helped with the administration of several bank databases in both development and production environments. It offers the entire spectrum of personal and business banking services and products.

Responsibilities:

•  Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
•  Created different drill down reports using Power BI Desktop. Created measures, calculated columns in Power BI Desktop to show good data analysis techniques
•  Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
•  Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
•  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.
•  Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS.
•  Created and stored T-SQL queries to validate data between different sources and Power BI.
•  Involved in source code management with the help of GitHubusing push and pull operations of GIT an Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• d created a local GIT repository so that the source code can be managed locally.
•  Creating stored procedure and scheduled them in Azure Data factory and Creating Data factory in Azure Data factory.
•  Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
•  Designed and documented logical and physical database designs for Enterprise Application (OLTP), Data Warehouses (OLAP), NoSQL databases.
• Created Spark applications using PySpark and Spark SQL for data extraction, transformation, and aggregation from various file formats, uncovering insights into customer usage patterns.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Collaborated with key internal and external stakeholders to gather and analyze needs and requirements to design and implement robust analytic solutions to support the identified needs.
• Good Understanding of Azure DevOpspractices for continuous integration/delivery and creating CI/CD release pipelines for release management to push the changes to higher environments.
• Gained Knowledge Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• 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.
• Following Agile (Scrum) Methodology for developing application development.

Environment: Power BI, NO SQL, SSAS, SSIS, SSRS, OLTP, OLAP, Pyspark, Spark, Azure SQL, Azure DW, Azure Data Lake, Azure Data bricks, Scala, T SQL, Git, Github, Azure Data factory, Power Query, T SQL, ETL, Power BI Desktop, Excel, DAX, Star Schema, Snowflake Schema, Jira, Tableau, CI/CD, Azure DevOps.

Client: Capital one

Description: The project goal is to provide a scalable and trustworthy solution that can track transactional data in real time from diverse sources and spot any problems. The projects goal is to fix the mistakes as quickly as possible to avoid any financial losses and to preserve the data integrity so that it can be trusted for further study.

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
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports created many Drill through and Drill Down reports using SSRS.
• Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Implemented version control using Git for ETL processes, data mapping, analytics scripts, dashboard development, and report templates, ensuring collaboration and tracking changes.
• Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task.
• Used SQL, Python, and PySpark, worked Data bricks notebooks were generated, and automated notebooks were made using tasks.
• Leveraging advanced Power BI DAX calculations and cutting-edge conditional formatting for comprehensive Data Analysis.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.
• 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 /2016 environment.
• Wrote T- SQL scripts to validate and correct inconsistent data in the staging database before loading data into the database.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Utilized monitoring and deployment tools to efficiently manage Power BI Service CI/CD and data flow operations.
• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• Developed automated reports and scheduled updates using Tableau publishing and scheduling features, providing stakeholders with up-to-date insights.
• Utilized Jira for project task management, requirement tracking, and collaboration among team members, ensuring timely delivery and effective communication.
• Actively applied Agile Methodology practices for development of the Microsoft reporting environment.

Environment: Power BI, Git, ETL, SSIS, SSRS, SQL, OLTP, Pyspark, Python, CI/CD, Azure Data Factory, Logic Apps, Azure, Tableau, Jira, Agile, DAX, Power Desktop, Jira, Agile, T SQL.