We provide IT Staff Augmentation Services!

Sql/power Bi Developer Resume

SUMMARY

  • A seasoned Business Intelligence Analyst and Standard Query Language(SQL) Developer with a track record of delivering large - scale analytics solutions and service models for brands in the Information Technology (IT) Industry.
  • I earn the trust of business partners by investing time in the most impactful opportunities to advance strategic decision- making and enabling teams I am part of to deliver incremental and sustainable value towards achieving company-wide objectives.

TECHNICAL SKILLS

Database: MSSQL 2008, 2012, 2014, 2016, 2018

Operating Systems: RHEL 5x, 6x,7x, 8x, OEL, Windows

Programming Languages: SQL, Python

BI Tools- Power BI, Tableau:

ETL & Data Modelling Tools: SSIS, Azure Data Factory, ERWIN

SDLC Experience: Agile and Scrum Methodology

PROFESSIONAL EXPERIENCE

Confidential

SQL/Power BI Developer

Responsibilities:

  • Imported data from Microsoft MSSQL Server Database (DB) to Power BI to generate reports.
  • Organize, Scheduled meetings with business users to understand, document the purpose, goal, and objectives of the report/extract request.
  • Use Performance Monitor and SQL Profiler to optimize queries and enhance the performance of relational database servers.
  • Create technical specification document, including the implementation methodologies using tools and technologies such as SQL, Power BI, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
  • Maintain and write complex Transact SQL (T-SQL) queries, views, transformation queries, triggers and stored procedures in multi-database environment with little supervision.
  • Collaborate with Confidential departments to create new database solutions and standard procedures in an Online Transaction Process (OLTP) environment
  • Import data from different data source to create Power BI reports and dashboards.
  • Develop data visualizations and BI (Business Intelligence) dashboards (including self-service BI for non-technical colleagues) by leveraging software development life cycle for designing new analytical models, data marts, reports, and dashboards.
  • Design and implement BI and data analytics solutions with MS technologies (SSIS, SSRS, and Power BI).
  • Create technical specification document, including the implementation methodologies using tools and technologies such as SQL, Power BI, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
  • Create Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
  • Handle SQL Server and SSIS, SSAS, SSRS. Converted SSRS reports into Power BI visualizations.
  • Work together with business partners to design the automatic data acquisition or data delivery process for the required reporting data using various tools and technologies such as SFTP, Control-M, Batch scripts, SSIS and SQL Server Database.
  • Create reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
  • Engage in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
  • Support and develop DataStage jobs to load respective Dimensions and Fact tables.
  • Design and build scalable/reusable data models and ETL (Extract Transform Load) processes to support analysis and reporting on platforms such as: Teradata, SQL Server, Oracle, Hadoop, performing routine maintenance, and address special requests.
  • Coordinate cross-functionally to accomplish assigned tasks.
  • Mentor less experienced members of the team.
  • Assist in live site support and incident resolution that may include on-call rotation and debugging as needed.

Confidential

BI Developer

Responsibilities:

  • Collaborated with senior management, subject matter experts, and IT teams to define business requirements.
  • Transformed business requirements into functional and nonfunctional requirements.
  • Created complex stored procedures to perform various tasks including, but not limited to; index maintenance, data profiling, metadata searches, and loading of the data mart.
  • Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
  • Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
  • Designed incremental loads to populate the data mart with checksum and timestamp techniques.
  • Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.
  • Implemented package configurations on development, test, and production environments utilizing parameters.
  • Developed Data Mapping, Performance Tuning and Identified Bottlenecks of sources, mappings, targets, and sessions.
  • Utilized Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
  • Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.
  • Designed SSRS reports for in depth business analyses.
  • Designed expressions to calculate, group, filter, parameterize, and format report contents.
  • Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.
  • Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
  • Performed thorough unit testing on all relevant platforms to ensure proper implementation.
  • Designed SSAS Cube and developed MDX queries for Analysis.
  • Utilized Team foundation server (TFS) for managing source code changes.
  • Assisted in developing test cases for Unit Testing

Confidential

Data Analyst, Internship

Responsibilities:

  • Created various visualization tools for Senior Management.
  • Performed Data analysis on data to determine workforce trends.
  • Reviewed work from management and prepared written documentation via Microsoft Excel.
  • Supported strategic workforce planning initiative.
  • Assisted with workforce data analytics.
  • Presented to Senior Level Management
  • Assisted in reorganization plan for the department.

Hire Now