We provide IT Staff Augmentation Services!

Sql Power Bi Developer Resume

0/5 (Submit Your Rating)

San Francisco, CA

SUMMARY

  • Business Intelligence professional with more than 6 years of analysis, design, and development experience in providing highly effective BI solutions utilizing Microsoft SQL Server, BI Suit (SSIS, SSAS, and SSRS), Azure SQL, Power BI, and Tableau with various domains such as banking, technology, healthcare and insurance.

TECHNICAL SKILLS

Database: MS - SQL Server 2012/2008R2/2008/Azure SQL T-SQL Programming, Dynamic SQL, C#.Net:

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Power Pivot, Tableau Integration Services (SSIS) Analysis Services (SSAS, OLAP Cubes) Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS) CCNA (Cisco)

Microsoft Azure: Cloud Services (PaaS & IaaS) PowerShell Azure SQL Database (PaaS) Azure Storages (Blobs, Tables, Queues) Backup/Recovery Azure Data Factory Azure Data Warehouse

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint 2013/2010

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SQL Power BI Developer

Environment: SQL Server 2012, SSIS, SSAS, SSRS, MS Azure, Excel, TFS 2010, Power BI, Tableau, Performance Point Services (SharePoint)

Responsibilities:

  • Collaborated with business users and analysts through JRD and JAD sessions.
  • Wrote SQL code for various maintenance operations such as index maintenance, orphan object deletion.
  • Adopted different isolation levels to minimize locking and improve concurrency.
  • Evaluated execution plans for queries with performance issues to alter queries for better optimal query performance.
  • Implemented error handling utilizing try catch blocks and throw functions as demanded by complex business logic.
  • Optimized existing stored procedures utilizing approaches such as modularization, parameter sniffing, and indexes.
  • Retrieved and processed hierarchical data from tables by employing recursive CTEs, temporary tables and table variables.
  • Cleansed and loaded data by implementing data quality services, fuzzy lookup and SQL stored procedures.
  • Created fact tables with lowest granularity levels and maintained fact table relations with alternate and surrogate keys.
  • Developed ETL mapping documents to map source OLTP server data and Azure cloud data to on premise data mart.
  • Implemented networking infrastructure such as VMs, gateways, software patches to scan through Microsoft cloud databases.
  • Designed SSIS packages utilizing various task and transformations such as execute SQL task, script task, execute package task.
  • Traversed through data utilizing for each loop enumerators such as ADO.net, for each file as demanded by business scenario.
  • Deployed packages utilizing project deployment model in SQL Server 2012.
  • Collaborated with business analysts and developers to identify requirements and design the reporting application.
  • Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power Pivot.
  • Created multiple dashboards with filters and parameters for analyses utilizing Power View.
  • Created gauge, funnel, slicer, stacked area chart, line chart utilizing Power BI.
  • Utilized Power BI - Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Created reports in Power BI desktop preview portal utilizing the SSAS Tabular via Analysis connector.
  • Designed and implemented scattered charts to perform trend analysis for insurance claims coming in from various vendors.
  • Designed various reports and dashboards utilizing SSRS, Power View and Tableau.
  • Utilized SSRS and SharePoint BI primer to create multitude of data intensive visual reports for clients and executive management.
  • Collaborated with other team members utilizing TFS.

Confidential, Redwood city, CA

SQL/Power BI Reports Developer

Environment: Microsoft SQL Server 2008R2/2012, SQL Server 2012, SSIS, SSRS, BIDS/SSDT, Tableau, Power BI, SharePoint, Oracle (as source).

Responsibilities:

  • Collaborated with team members to derive functional requirements for the project.
  • Organized JAD and JRD sessions to analyze business needs and provide time tested solutions.
  • Maintained database integrity by implementing various constraints over relational and multi-dimensional databases.
  • Designed scalar user defined functions to address data related issues.
  • Optimized existing stored procedures using approaches such as modularization, parameter sniffing, and indexes.
  • Retrieved and processed hierarchical data from tables by employing recursive CTEs.
  • Designed SSIS packages to deliver Excel reports to managers through Email subscription.
  • Redesigned existing SSIS packages to utilize the new deployment techniques in SQL Server 2012.
  • Implemented master/child package model to improve performance and easier execution.
  • Employed checksum and timestamp as ETL incremental load technique to pull only the changed data from OLTP servers to be loaded in dimensional databases.
  • Deployed packages utilizing both package deployment and project deployment models.
  • Addressed complex business related issues by creating packages with script task and script component.
  • Designed and developed SSRS reports with options such as drill down, drill through, and cascaded parameters.
  • Designed analytical reports and dashboards utilizing Power View.
  • Designed reports in Power BI utilizing various with chart and graph features such as gauge, funnel, line better business analysis
  • Created dashboards with Microsoft Power BI desktop for early cancer detection analysis to improve decision making in specific case scenarios.
  • Optimized data sets utilized in report generation to reduce report latency by implementing various optimization techniques such as caching, snapshots including query level optimization.
  • Monitored SQL server performance utilizing SQL Profiler and DTA.
  • Managed sprint release scripts utilizing team foundation server (TFS).

Confidential Westborough, MA

SQL/BI Developer

Environment: SQL Server 2008R2, BIDS, BIDS, SSIS, SSRS, Report Builder, Erwin

Responsibilities:

  • Outlined technical specifications based of business requirement document.
  • Wrote complex queries to embed in OLEDB source for ETL packages.
  • Created stored procedures and user defined functions to implement complex business requirements.
  • Modularized stored procedures to improve performance and effortless maintenance.
  • Analyzed database and identified bottlenecks for performance; created indexes to optimize database performance.
  • Extracted data from sources such as flat files, OLTP databases to target databases.
  • Transformed and loaded data utilizing SSIS packages from pre staging to staging server.
  • Designed and created various complex SSIS packages to move data coming in from OLTP servers and dump it into centralized data mart by transforming it as per business requirements.
  • Validated data loaded to data warehouse utilizing stored procedures and basic C# scripts.
  • Implemented event handlers and precedence constraints to avoid run time errors in SSIS packages.
  • Created XML package configurations and deployed SSIS packages to other environments.
  • Designed report models for management to design the required reports.
  • Managed security of reports and models via report manager web portal.
  • Generated reports with SSRS and Power Pivot; deployed them on SharePoint.
  • Supported DBA in backup and recovery of databases.

Confidential, Stoughton, MA

SQL/ETL Developer

Environment: SQL Server 2008/R2, SSMS, SSIS, SSRS, BIDS, Excel, SQL Server Upgrade Advisor

Responsibilities:

  • Documented the business need of various stored procedures for future reference
  • Diagnosed database to find anomalies; normalized further and maintained referential integrity.
  • Presented static data on webpages by creating views.
  • Designed user defined functions to support front end team for data search related requirements.
  • Migrated existing data from SQL Server 2005 to SQL Server 2012 as a part of upgradation process utilizing side-by-side migration technique.
  • Applied pre-migration and post-migration considerations on migrated data sets to follow business code and constraints.
  • Created scripts utilizing various control flow options to provide logical flow to the business code.
  • Designed efficient stored procedures to address parameter sniffing issues.
  • Debugged issues with various DBOs utilizing industry standard approaches.
  • Cleansed data utilizing SSIS packages and stored procedures to meet organization requirements.
  • Developed SSIS packages utilizing control flow tasks, containers and data flow transformations.
  • Deployed packages to other environments after creating package configurations.
  • Utilized SSRS and Excel files to create reports including profit/loss analysis by vendor and explore business opportunities areas.

Confidential, New York, NY

SQL Developer

Environment: SQL Server 2008, SSMS, BIDS, TSQL.

Responsibilities:

  • Assisted QA team in developing SQL scripts for validation requirements.
  • Identified frequently used queries and designed views or stored procedures per requirements.
  • Created multiple stored procedure to handle business logic for performance related issues.
  • Improved the latency of the queries by normalizing and de-normalizing tables as required.
  • Altered tables to include new columns to support modified requirements.
  • Moved data from multiple sources to staging area for further processing.
  • Managed, maintained upgraded the existing schedules on the main portal service as per new business requirements laid out by the bank on periodical basis.
  • Collaborated with TFS (Team Foundation Server) to work with cross functional team environment including on-shore and off-shore.

We'd love your feedback!