We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Nyc, NY

PROFESSIONAL SUMMARY:

  • 6+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
  • Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
  • Experience managing Big Data platform deployed in Azure Cloud
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Worked Extensively on ETL process using SSIS package.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
  • Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
  • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience in Creation and deployment of cubes on SSAS.
  • Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014.
  • Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
  • Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Involved in DBA activities such as backups and restores.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

TECHNICAL SKILLS:

SQL Server Tools and Databases: SQL Server Management Studio (SSMS), SQL Server 2012, 2014, 2016, MS Access 2008, Oracle 11g, SQL Server Integration Services (SSIS), SSRS (Reporting Services), SSAS (Analysis Services), Microsoft Visual Studio 2012/2014/2016 , SQL Server Business Intelligence Studio (BIDS), SharePoint, .Net

BI tools: Power BI, Qlikview, Tableau

Statistical tools: SPSS, SAS JMP

Applications: Visual Basics, Excel -Macros

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

EMPLOYMENT SUMMARY:

Confidential, NYC, NY

Power BI Developer

Responsibilities:

  • Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
  • Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
  • Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
  • T-SQL in constructing User Functions, stored procedures, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
  • Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
  • Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
  • Experience in Data Analysis, understanding trends and patterns in data.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
  • Converted the old Data flow logic written in .NET C# to SSIS packages.
  • Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
  • Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
  • Responsible for the analysis and reporting of consumer data generated for compliance across all touch points from multiple databases
  • Involved in scorecard and KPI Reporting.
  • Experience in generating performance reports (using slicer), cluster/scatter charts along with various other basic charts.
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
  • Experience with Power BI desktop and Power BI Service.
  • Published dashboards on an intranet site using SharePoint Server.
  • Migration of SQL Databases from SQL 2008 to SQL 2012/2014.
  • Recommended internal process changes using data analysis.
  • Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.

Environment: MS SQL Server 2012/ 2014/ 2016 , Microsoft Management Studio, Teradata SQL Assistant, Microsoft Visual Studio, Azure SQL, Azure Storage Explorer, Azure Blob, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, SQL Server Reporting Services (SSRS), Power BI, T-SQL.

Confidential, Waltham, MA

SQL BI Developer

Responsibilities:

  • Detailed Data mapping for different schedules for FRY-M and FRY-Q’s
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation
  • Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
  • Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services (SSRS).
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Trouble shoot any kind of data issues or validation issues
  • Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
  • Design the ETL frame work for the data load into FRY Tables.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Worked on the ADW Data Warehouse.
  • Create Master Package to run different other ETL in one Master package.
  • Bug fixes in SSIS, SSRS and stored procedures as necessary.
  • Used C# and VB Scripts in ETL Packages where ever necessary.
  • Worked in an agile scrum methodology.
  • Scheduling the jobs to run for ETL using SQL Server Agent.
  • Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
  • Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
  • T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Perform T-SQL tuning and optimizing queries for SSIS packages.
  • Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
  • Scheduling SSRS jobs and production support.
  • Production support for SSIS and SSRS jobs.
  • Worked as an IBM - COGNOS Report Designer and created number of Business-Critical sales reports for company’s Management team.
  • Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2012/2014, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 (MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Erwin Data Modeler.

Confidential, NYC, NY

SQL BI Developer

Responsibilities:

  • Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
  • Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008 R2
  • Analyzing and designing reports and reporting solutions according to the specifications given.
  • Knowledge and implementation of Reporting Services and other MS tools and in combination to design report solutions to deliver on several CI projects.
  • Meet deadlines while meeting the reporting needs of the business users and project owners.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Designed the SSIS packages with error handling.
  • Built a consolidated Data Mart for five different Company Organizations which was further populated and used to build a Cube on SQL Server 2012 for further reporting requirements.
  • Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Creating Ad Hoc and Parameterized Reports using SQL server 2008 R2 Reporting services.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using Sql Server Reporting Services 2008 R2 and COGNO’s.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Wrote the Visible Basic expressions in SSRS according to the requirement of the report developed.
  • Worked on some ETL development using Informatics.
  • Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
  • Scheduling the jobs for monthly reports and yearly reports
  • Played a major role in production support and maintenance of SSIS jobs.
  • Documenting the Developed Code by following the Organizational guide lines where ever required.
  • Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
  • Assisted in Creating SSIS process design architecting the flow of data from various sources to target.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation
  • Use of version control system (SERENA) for proper accounting.

Environment: MS SQL Server 2008/2012, Micro Soft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2007 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

SQL Server Developer

Responsibilities:

  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
  • Part of team for analyzing and implementing the physical design for the database.
  • Responsible for drafting documentation for describing the metadata and writing technical guides.
  • Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
  • Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
  • Thorough understanding of first NF (1NF), second NF (2NF) and third NF (3NF).
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Installation and configuration of SQL Server 2008.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Subreports using Sql Server Reporting Services 2008.
  • Created SQL Server Analysis Project using MS SSAS 2008.
  • Querying and manipulating multidimensional cube data through MDX Scripting.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created complex SSAS cubes with multiple fact measures groups.
  • Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
  • Used performance Point Services, SSRS, excel as the reporting tools.
  • Wrote the expressions in SSRS wherever necessary.
  • Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Modifying report content and exporting reports in multiple formats based on the business requirements.
  • Designed and implemented Parameterized and cascading reports using SSRS 2008.
  • Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Understanding the OLAP processing for changing and maintaining multidimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
  • Created Analytical reports by PROCLARITY tool.
  • Played a major role in production support of SSAS (cube refresh), SSIS jobs.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Hire Now