We provide IT Staff Augmentation Services!

Bi Developer Resume

Rancho Cordova, CA

PROFESSIONAL SUMMARY:

Expertise in database design, development, and business intelligence utilizing Microsoft SQL Server, MSBI (SSIS, SSAS, SSRS) Power BI, and Tableau. Over 7 years of experience in Healthcare, Technology, Investment industries.

TECHNICAL KNOWLEDGE:

Database: MS - SQL Server 2016/2012/2008 R2/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)

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

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint, JavaScript 1.8.2 Data Science with R and Python

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cordova, CA

BI Developer

Technical Environment: SQL Server 2016, SSDT, SSIS, SSAS, SSRS, Azure SQL, Tableau, TFS, SharePoint, Power BI Desktop, Performance point, Microsoft Stream Insight, SQL Server Audit, R programming for predictive analysis.

Responsibilities:

  • Collaborated with business analysts to understand requirements for several reports and dashboards.
  • Developed a live dashboard on Tableau, which tracks activity of a lobby by the second with information about waiting area and reason for visit etc.
  • Developed a predictive model for finding the approximate waiting time for a person in the queue, with 85% accuracy using R language and machine learning algorithms.
  • Created a python application which uses an API to connect to JIRA data to download all the data on a daily basis and save it as a text file.
  • Modeled the data after extracting from the JIRA text file and designed a data warehouse to store this data and created a dashboard on top of that.
  • Wrote complicated views and functions to aggregate data as per requirement in order to use for dashboards.
  • Developed easy to use Dynamic-SQL stored procedures to set up audit logs on server level as well as database level.
  • Developed a security application to read data from audit log files continuously using Microsoft StreamInsight to detect unwanted access to personally identifiable information or possible PII theft.
  • Creating Dimension tables and Fact tables and setting up ETL packages and SQL jobs to fill these tables in a periodic fashion.
  • Generating Performance Point reports on top of Cubes and Power BI reports on to of Dimension and Fact tables.
  • Wrote MDX code to create calculated members in cubes to be used in Performance Point.
  • Created user defined hierarchies in SSAS tabular model utilizing DAX.
  • Generated reports on Power BI to track the historical operation of service centers displaying information about tasks and calls with varying granularity.
  • Developed reports for management to track their budget for the entire year on performance point.
  • Used several optimization techniques, such as re-writing views with better programing practices, creating indexes such as column store indexes to optimize performance and bring down execution time and reduce load on server in terms of IO and CPU usage.
  • Implemented TFS (Team Foundation Server) for code check-in and check-out and manage different versions.

Confidential, San Diego, CA

SQL/ BI Reports Developer

Technical Environment: SQL Server 2012, SSDT, SSIS, SSAS, SSRS, Azure SQL, Tableau, TFS, SharePoint, Power BI Desktop, Erwin.

Responsibilities:

  • Collaborated with business analysts to design relationship between entities.
  • Designed database model (physical/Logical) utilizing Erwin.
  • Created database objects per business requirement such as (tables, views, stored procedures, and UDFs) utilizing SSMS.
  • Wrote queries to retrieve/ update data utilizing CTEs, joins, sub queries, temp objects and control flow statements.
  • Optimized queries by partitioning tables, updating statistics, utilizing SQL Profiler, and implementing DTA tools.
  • Implemented column stored indexes to retrieve large dataset.
  • Implemented try-catch blocks to handle runtime errors in stored procedures.
  • Implemented MOLAP, HOLAP, and ROLAP storage modes for data, based on project specifications.
  • Generated reports from relational databases, relational data warehouses, and OLAP cubes.
  • Wrote intermediate level MDX expressions to create KPIs and calculated members for better analysis of data as per business requirements.
  • Created Calculated members and KPI’s utilizing Multi-dimensional expressions (MDX).
  • Created user defined hierarchies in SSAS tabular model utilizing DAX.
  • Created various types of SSRS reports such as (parameterized, drill down, and drill through reports) utilizing SSRS.
  • Designed score cards utilizing Power BI Desktop.
  • Implemented report delivery to users utilizing SSRS subscriptions (data driven/ standard).
  • Created multitude of Tableau visual reports for effective reporting of data intensive tasks.
  • Designed summary and detailed dashboard utilizing Tableau desktop.
  • Worked with Azure Databases to migrate on premises data on Microsoft Cloud.

Confidential, San Diego, CA

SQL SSRS Developer

Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSAS, SSRS, ER Win, MDX, TFS, Power BI

Responsibilities:

  • Collaborated with multiple teams in JRD sessions and SCRUM stand-up meetings.
  • Removed unused columns and deleted redundant data from tables.
  • Created stored procedures and complex queries to implement the business logic.
  • Implemented query performance by eliminating key and RID look up operators from the execution plan.
  • Implemented performance tuning for concurrency of queries, utilizing proper isolation levels.
  • Designed named queries and usage-based aggregations to improve performance.
  • Created various SSRS reports such as drill down, drill through, and cascaded parameterized.
  • Modified MDX scripts in report datasets to add query parameters.
  • Improved data visualization utilizing Power BI Desktop.
  • Implanted report delivery with data-driven and standard subscriptions in SSRS.
  • Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
  • Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
  • Deployed SSRS reports to the reporting server in SharePoint integrated mode.
  • Implemented report security utilizing report manager/ report server.
  • Generated reports utilizing Excel with Power Pivot; deployed reports on SharePoint.
  • Collaborated with Team Foundation Server to update project documents, scripts, and packages.

Confidential, Folsom, CA

BI Developer

Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, TFS, ER Win

Responsibilities:

  • Utilized Erwin to implement data models.
  • Implemented database integrity per business requirement utilizing database constraints and triggers.
  • Implemented various database concepts such as Joins, Views, CTE, Temp objects, Indexes, Transactions to manage database objects.
  • Implemented error handling in SQL scripts and procedures utilizing try-catch statements, ‘throw’ and ‘raiserror’ functions.
  • Implemented covering-indexes to optimize query performance.
  • Designed and modified stored procedures and UDFs to support front-end applications.
  • Created perspectives for multiple departments to obtain applicable data from cubes.
  • Generated Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports utilizing SSRS.
  • Optimized the performance of reports by optimizing stored procedures and embedded them in reports as well as implemented caching methods for the same purpose.
  • Implemented TFS (Team Foundation Server) for code check-in and check-out and manage different versions.

Confidential, Chicago, IL

BI Developer

Technical Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SQL Profiler, MS Visual Studio, MS Excel

Responsibilities:

  • Analyzed historical data and extracted required data to support management decisions.
  • Created ER diagrams and performed normalization on them to ensure faster querying.
  • Designed staging database as intermediate stage for population recovery DataMart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
  • Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.
  • Facilitated data retrieval and manipulation through implementation of views, procedures, triggers and cursors.
  • Supported some business specific relationships, and advance constraints by embedding triggers on tables.
  • Deployed SSRS reports to the reporting server and resolved deployment problems.
  • Rendered reports into multiple formats per the business requirements with subscriptions.
  • Optimized reports by optimizing embedded queries, and stored procedures that generate them.
  • Designed various SSRS and Tableau reports to analyze the performance of client investments with portfolio for better business decision.

Confidential, Nashville, TN

Database Developer

Technical Environment: SQL Server 2008/2008R2, BIDS, T-SQL, DTA, Flat File, Excel

Responsibilities:

  • Created High Level normalized database and detail design utilizing Erwin.
  • Wrote stored procedures, tables, triggers, indexes and views utilizing detailed design specifications.
  • Tuned queries, assigned proper Indexes for better performance.
  • Analyzed source data and designed the overall data architecture for OLTP database.
  • Embedded complex queries and procedures in SSIS Packages based on business requirements.
  • Optimized poorly performing queries and procedures for optimal performance.

Hire Now