Bi Developer Resume
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