We provide IT Staff Augmentation Services!

Bi Developer Resume

3.00/5 (Submit Your Rating)

Las Vegas, NV

PROFESSIONAL SUMMARY:

Experienced IT professional with a proven track record delivering successful BI projects; 6 years of experience in analyzing, designing, and developing projects with MS SQL Server 2012/2008R2/2008within banking, technology, and insurance industries.

TECHNICAL KNOWLEDGE:

  • MS - SQL Server 2008, 2008 R2, 2012
  • SSMS, BIDS, SSDT, ERwin, MS Visio
  • SharePoint, Team Foundation Server (TFS)
  • Power BI, Power Pivot
  • Integration Services (SSIS)
  • Analysis Services (SSAS)
  • Reporting Services (SSRS)
  • SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

BI Developer

Responsibilities:

  • Collaborated with customers and analysts to collect requirements for the development of a cube and report.
  • Created Mapping document between BRD and Cube.
  • Created MDX cube with multiple facts and dimensions from Tsql database in tabular mode.
  • Created f view in SSMS for cube usage.
  • Created calculated members to implement complex business logic per report requirements.
  • Create database for Confidential Project, migrated data from previous database to Confidential database.
  • Populated sample data into database.
  • Created stored procedures to manipulate tables.
  • Created SSIS Package to load and verify data, defining delta marker in each source system.
  • Collaborated with other team members utilizing TFS.

Technical Environment: SSMS 2015, SSIS, SSAS, MicroStrategy, Netezza, SharePoint, Excel, TFS 2017.ATI, CMS, Halo.

Confidential, Roseville, CA

BI Developer

Responsibilities:

  • Collaborated with customers and analysts to collect requirements for the development of a cube and report.
  • Created cube with multiple facts and dimensions from oracle database in tabular mode.
  • Created f view in oracle database for cube usage.
  • Created Customized fact table and dimension table as needed.
  • Browsed the cube in SSMS, processed the cube in different modes.
  • Partitioned fact table for incremental processing when volume of data in fact table will increase in the future or full cube process is taking more than 30 min.
  • Created complex measure or derived column in fact table and dimension table.
  • Validated cube data against data warehouse, validated calculated items logic.
  • Granted cube access to DW and UAT users.
  • Deployed cube to test server and UAT server for testing.
  • Debugged and resolved errors within cubes on the UAT or Production.
  • Created cube data dictionary for customers.
  • Created complex SSRS reports including row group, column group, table, chart.
  • Created dashboard and detailed reports using drill through, subreports.
  • Customized parameter queries to remove unwanted values and improved the report performance.
  • Validated report data against data warehouse, validated logo, fonts, colors and formatting with standards document.
  • Deployed report to test or UAT server, managed report using report manager.
  • Developed /ad hoc reports utilizing SSRS or Tableau Desktop or Power BI.
  • Collaborated with other team members utilizing TFS.

Technical Environment: Oracle, SSMS 2015, SSIS, SSAS, SSRS, SharePoint, Excel, TFS 2017, Power BI, Tableau.

Confidential, San Diego, CA

MSBI Developer

Responsibilities:

  • Collaborated with business users and analysts to collect requirements for the development of data mart utilizing JRD and JAD sessions.
  • Developed logical and physical data models for data mart with ERwin.
  • Created stored procedures, user defined functions, views, and TSQL scripts for implementing business logic.
  • Wrote complex queries utilizing joins, sub queries, CTE, and set operators involving multiple tables.
  • Analyzed execution plans to optimize queries; created proper indexes to improve query performance.
  • Implemented error handling utilizing try catch block, raise error system function and @@error system variable.
  • Developed mappings in SSIS to transform and load data from multiple sources such as excel and flat files.
  • Designed the ETL process to access, manipulate, and analyze the information from both internal and external sources.
  • Designed and deployed SSIS packages with multiple transformations.
  • Utilized techniques such as event handlers, row redirects, and loggings for error handling in SSIS packages.
  • Implemented data profiling, data cleansing utilizing stored procedures, data profiling task, fuzzy lookup, DQS and Oledb command.
  • Implemented parallel processing, checkpoint, delay validation and parent-child package model to improve SSIS package performance.
  • Managed cubes objects such as KPIs, drill through actions, perspectives, aggregations, and translations.
  • Implemented drill through, linked, and subreports functionality in SSRS reports.
  • Deployed multiple reports to the report server in native and SharePoint Integrated modes.
  • Created dashboards using Power View to identify KPIs.
  • Discovered slow executing reports and optimized embedded queries or stored procedures which generate reports.
  • Collaborated with other team members utilizing TFS.

Technical Environment: SQL Server 2012, SSIS, SSAS, SSRS, SharePoint, Excel, ERwin, TFS 2010, Power BI

Confidential, Pleasanton, CA

SQL/SSRS Developer

Responsibilities:

  • Collaborated in JAD sessions to understand the scope of requirements; drafted functional requirement documents
  • Maintained domain integrity by creating check constraints and triggers.
  • Identified claims involving in different ICD codes utilizing stored procedures.
  • Created multiple stored procedures for index maintenance, data profiling, and data cleansing.
  • Delivered data to managers in Excel format; created ETL packages.
  • Designed complex SSIS packages for extracting data from Excel and Flat files into SQL server.
  • Redesigned SSIS packages to meet evolving business requirements.
  • Implemented master/child package model for better performance and simpler execution.
  • Created package configurations; SSIS packages to deploy packages for development, test, and production environments.
  • Designed SSRS reports with options such as drill down, drill through, and cascaded parameters for business analysis.
  • Optimized queries or stored procedures for faster report generation.
  • Designed analytical reports and dashboards utilizing Power View.
  • Monitored SQL server performance utilizing SQL Profiler and DTA.

Technical Environment: Microsoft SQL Server 2008R2/12, SSIS, SSRS, SQL Profiler, DTA, BIDS/SSDT, SharePoint, Windows Server, Power View

Confidential, Los Angeles, CA

SQL/SSRS Developer

Responsibilities:

  • Acquired business logic by creating stored procedures and complex queries for ETL packages.
  • Created, analyzed, and modified indexes to optimize query performance of stored procedures and T SQL queries
  • Performed extraction, transformation, and loading of data from SQL Server and Flat file sources into the target database.
  • Imported data to staging database and data warehouse using multiple ETL Packages.
  • Created cubes from relational data warehouses and created KPI’s for the front-end team.
  • Implemented named queries and usage based aggregations for performance improvement of cubes.
  • Processed cubes using process default and process full options through SSIS Packages.
  • Assigned MOLAP, HOLAP, and ROLAP storage modes for cubes depending on age of the data.
  • Produced SSRS report models for creating ad hoc reports by higher management.
  • Generated reports with SSRS and Power Pivot; deployed them on SharePoint.
  • Created multiple SSRS reports such as linked reports, parameterized reports, sub reports; deployed and managed reports.

Technical Environment: SQL Server 2008R2, BIDS, SSIS, SSAS, SSRS, Report Manager, Report Builder, Power Pivot

We'd love your feedback!