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