Summary
Overview
Work History
Education
Skills
Timeline
Generic

Manasa Pothineni

Mississauga,ON

Summary

Dedicated and highly accomplished Business Intelligence professional with 5+ years of experience and proven expertise in data warehousing and business intelligence tools like Power BI, MSBI (SSRS and SSIS). Generated reports and visualizations by connecting to various data sources (MS SQL Server, Snowflake, MySQL, MongoDB, MS Access, Share Point, Excel, CSV). Expertise in using Common Data Service entities creation and using in Power BI desktop to create reports. Experience in extracting data from data sources and transforming it using SQL and Python. Good knowledge of System Development Life Cycle (SDLC). Followed SDLC methodologies in performance of all development activities, including design, development, test, and quality assurance support. Team player with good logical reasoning ability, coordination and able to complete projects independently. Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services. Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports. Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling. Experience in leading and delivering data centric projects with concentration on Data Quality and adherence to data standards and best practices. Familiarity with Data Lakes, Data Warehouses, MDM, BI, Dashboards, AI, ML Develop and test ETL components to high standards of data quality and performance. Technical experience and knowledge in Cloud Data Warehousing, data migration and data transformation Develop advanced and optimized SQL stored procedures and functions. Experience in performance tuning, processing,and deploying the cubes. Experience in cube partitioning for better database performance. Experience in Performing Data Mining features like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities. Experience with system and user defined Variables, Package, and Project Configurations for SSIS packages. Experience in managing Control flow and Data flow transformations for SSIS packages. Experience with Performance tuning of SSIS packages using Synchronous and Asynchronous Transformations. Experience in Job Scheduling and Package Automation of SSIS packages. Loaded Data from SFTP/On-Prem data through Azure Data factory to Azure SQL Database and Automize the pipeline schedules using Event based Scheduling in Azure Data Factory (ADF). Customize the Power BI reports, dashboards and Azure Data Factory (ADF) pipelines when source data updated. Migrating on-premises SSIS packages to Azure and orchestrating with Azure Data Factory ADF V2 Azure-SSIS IR. Experience with logical and physical database design, normalization and data modeling using ERWIN and SQL Server Enterprise Manager.

Overview

6
6
years of professional experience

Work History

PowerBi Developer

Central1 Credit union
, Canada
07.2022 - Current
  • Designed Contract Retention database using SQL Server technology
  • Designed and developed data models for the data warehouse using star and snowflake schema
  • Creating Stored Procedure and Scheduled them in Azure Environment
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes
  • Developed and implemented SSIS ETL processes to load data from source files to target table
  • Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated also worked with Script Task to perform a custom code
  • Worked on creating dependencies of activities in Azure Data factory
  • Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient
  • Building the pipelines to copy the data from source to destination ADF
  • From analyzing sales and inventory data, decreased warehouse costs by 35% by eliminating dead inventory
  • Manage BI Strategy, including data sourcing, acquisition, integration, as well as all activities related to analytics and reporting
  • Created Pipelines in ADF using Linked Services / Datasets / Pipeline / to Extract, Transform, and load data from different sources like Blob storage, Azure SQL Database, write-back tool and backwards
  • Developed reports using the data imported in the local Power BI environment for Finance, Sales, Warehouse, Supply chain, Delivery Execution, Production, and Fleet departments
  • Designed and implemented migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools)
  • Deployed and tested (CI/CD) our developed code using Visual Studio Team Services (VSTS)
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems
  • Developed ADF pipelines to automate ETL activities and migrate SQL server data to Azure SQL database
  • Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa
  • Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse
  • Made the package dynamic so it fit the environment
  • Formulated the strategy, development and implementation of executive and line of business dashboards through Power BI

BI Developer

Broker link Insurance
, Canada
11.2021 - 06.2022
  • Worked on both live and import data to Power BI for creating reports and Power BI gateway to Schedule daily job to refresh data
  • Published Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data formatting
  • Implemented DAX functions for various fact calculations for efficient data visualization in Power BI
  • Parameterized Reports, Report Models and ad-hoc reports and Dashboards
  • Worked in Microsoft Power BI connection types, including Oracle direct, Azure SQL data warehouse, and ODBC and configurations and data flows
  • Worked in administering Power BI permissions, roles, and security and securing data layers based on specific identifiers, including role or agency
  • Applied advanced analytics to large data sets as needed
  • Worked in data and database integration techniques, including data modeling and data normalization
  • Worked in data analysis and data warehousing for performance in Power BI
  • Knowledge and experience with full SDLC lifecycle
  • Worked in Agile teams and working independently with Business stakeholders providing solutions and regular updates
  • Built enterprise data models using Power BI desktop
  • Worked with Microsoft Azure platform and Power BI Desktop
  • Strong understanding of Power BI application security layer models
  • Created sustainable and scalable data models and datasets in Power BI
  • Sourcing and converted the legacy reports during this Power BI Report Migration
  • Experience Power BI (Dashboards, Paginated Reports, Datasets and Dataflows, Power Query, DAX)
  • Formulated the technical strategy for BI solutions, with a specific focus on Microsoft Power BI
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
  • Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases
  • Develop custom calculated measures using DAX in Power BI to satisfy business needs
  • Responsible to handle the entire deployment life cycle of the dashboard from DEV to PROD, created the Power BI Service level datasets, scheduled the refreshes nightly and implemented row level security on each report
  • Develop Analytical Dashboards, PBI Dashboards and Paginated Reports using Power BI
  • Publish the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
  • Used Power Query to acquire data and Power BI desktop for designing rich visuals

SQL BI Developer

Amdocs
, India
09.2018 - 10.2021
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes
  • Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated and worked with Script Task to perform a custom code
  • Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient
  • Utilized T-SQL to pull data from various databases and created various dashboards, scorecards and reports to support loan business decision making
  • Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and business using Tableau
  • Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts build-in Excel
  • Built daily, weekly, monthly graphs and charts of loan data using R and Stored Procedures
  • Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables
  • Created new forecasting model that consolidated different markets leading to quicker, more dynamic forecasts and greater efficiencies; Dealt with time series data (decomposition, forecasting)
  • Perform validation checks to maintain the integrity of the data
  • Using SSIS/DTS packages, I built ETL packages for different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and loaded the data into target tables by applying various transformations
  • Developed SQL Stored Procedures and User defined functions using Dynamic SQL using advanced concepts of SQL Server
  • Developed complex SSIS packages using proper control and data flow elements
  • Worked on creating testing scripts for various ETL Processes and Reports to validate the data

Education

Bachelor of Technology -

India

Skills

  • SQL Server
  • Snowflake
  • MySQL
  • MS Access
  • MongoDB
  • SQL
  • Python
  • Power Shell
  • TSQL
  • Microsoft Visio
  • Tortoise SVN
  • Team Foundation Server (TFS)
  • Git
  • Windows Server 2012
  • MS DOS
  • UNIX
  • Linux
  • SSIS
  • ADF
  • Databricks
  • Visio
  • Erwin
  • Red gate
  • SQL Server Management studio
  • Visual Studio
  • Enterprise Manager
  • SQL Profiler
  • SQL Server Data Tools
  • DTS
  • Report Builder
  • Power BI
  • Tableau
  • SSRS
  • Azure Data Factory
  • Synapse Analytics
  • Azure Data Lake Storage
  • SQL Database
  • Azure Analysis Services
  • Azure Storage Account
  • Blob Storage

Timeline

PowerBi Developer

Central1 Credit union
07.2022 - Current

BI Developer

Broker link Insurance
11.2021 - 06.2022

SQL BI Developer

Amdocs
09.2018 - 10.2021

Bachelor of Technology -

Similar Profiles

  • Angela Olsen

    Angela OlsenAngela Olsen

    Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)Teller, Operations Department at Beehive Credit Union (now Security Services Credit Union)

  • Jan Sylvester

    Jan SylvesterJan Sylvester

    Senior Accounts Clerk/Accounts Clerk I at G.U.T. Credit Union Ltd/Nexa Credit Union LtdSenior Accounts Clerk/Accounts Clerk I at G.U.T. Credit Union Ltd/Nexa Credit Union Ltd

  • Briana Dame

    Briana DameBriana Dame

    Customer Service Representative II at Coastal1 Credit Union FKA Pawtucket Credit UnionCustomer Service Representative II at Coastal1 Credit Union FKA Pawtucket Credit Union

  • Cassandra Mandap

    Cassandra MandapCassandra Mandap

    Nursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery UnitNursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery Unit

  • HIREN PATEL

    HIREN PATELHIREN PATEL

    Senior Abilities and Accommodation Specialist at Humber PolytechnicSenior Abilities and Accommodation Specialist at Humber Polytechnic

CREATE PROFILE
Manasa Pothineni