We provide IT Staff Augmentation Services!

Senior Bi Developer Resume

SUMMARY:

Confidential is an experienced BI Developer specializing in SQL. Currently working at Confidential Mar as a consultant. Confidential also brings extensive use of stored procedures, T - SQL, triggers and modifications of existing performance tuning. He also has experience with Power Query, Power View, Power Pivot, Power Map and Power BI. He’s fully functional programming in C# with scripting experience in JavaScript and PowerShell.

TECHNICAL SKILLS:

Visual Studio, Confidential Visual Studio Team Foundation Server, SQL Server, Confidential Test Management, SSIS, SSRS, SSAS, Cosmos, DAX, Power Query, Power View, Power Pivot, Power Map, Pivot Chart, Product Studio, Windows Test TechnologyOctopus, Fiddler, PowerShell, HTTP Watch, Azure Diagnostic Manager, Cloudberry Explorer for Azure Blob Storage and Azure Management Portal, Entity Framework, LINQ, MVC 4, C#, Service Bus Explorer

PROFESSIONAL EXPERIENCE:

Senior BI Developer

Confidential

Responsibilities:

  • Create data model
  • Import data from data sources
  • Create relationships between tables
  • Handle role-playing dimensions
  • Rename or hide tables
  • Mark date tables
  • Delete unnecessary columns
  • Rename columns
  • Verify data category, format and types on columns
  • Reduce the number of tables
  • Define business logic
  • Define measures
  • Set the ‘Summarize By’ property on measures
  • Define calculated columns
  • Define hierarchies
  • Define Key Performance Indicators
  • Use DAX query to create measures
  • Create Ad-hoc Power BI report

BI Developer

Confidential

Responsibilities:

  • Gather with business/functional analysts to determine ETL, report and analytical requirements
  • Involved in the complete ETL life cycle and solely responsible for the design, development and maintenance of SSIS packages.
  • Creating and manipulating ETL calls through SSIS
  • Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005
  • Creating interface stored procedures and complex queries used in SSIS to load/transform data to the database.
  • Develop SSIS with logging, event handling and error tracking to support the BI processes
  • Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
  • Extensive use of Stored Procedures. Writing new stored procedures, T-SQL, UDF, Trigger and modifying existing ones and tune them such they perform well
  • Performed a schema change to improve query execution time and performance.
  • Created proper indexes to support queries.
  • Addressed performance issues associated with stored procedures and fix them.
  • Dropped and recreated the Indexes on tables for performance improvements.
  • Extract data from the relational database and prepare reports using SQL Server Reporting Services.
  • Working with highly volume databases with partitioned data, performance and tuning.
  • Hands on experience in Cosmos/Scope script development
  • Writing Cosmos script to debug issue related to cosmos download that we are using as source on our ETL package
  • Expertise in generating on-demand and scheduled reports for business analysis or management decision using Power BI tool both Desktop and Web version.
  • Creating ad-hoc Power BI reports to users

BI Developer

Confidential, Redmond, WA

Responsibilities:

  • Designed, developed and test various SSIS packages (ETL) to extract and transform data from source to Staging DB and to Azure Database
  • Designed developed and test SSIS packages(ETL) to extract data from two source one is on-prem database and one azure database and load the data to azure database
  • Write Store Procedures used by ETL packages to populate from source tables to staging tables
  • Create a SQL job script to run the SSIS package
  • Designed and implemented stored procedures, views and other application database code objects to aid complex mappings
  • Maintained SQL scripts and complex queries for analysis and extraction
  • Create SQL script to create environment variables used by SQL job when the Job runs in different environment
  • Create Automated test case script for all new created objects
  • Performed troubleshooting and debugging of new and existing ETL solutions
  • Participated in providing the project estimates for development

BI Developer

Confidential, Redmond, WA

Responsibilities:

  • Wrote technical specifications for cube development
  • Designed and developed various SSIS packages (ETL) to extract and transform data from source to DataMart
  • Hands on experience on data profiling
  • Created multiple hierarchical aggregates for faster performance and develop OLP Cubes.
  • Hands on experience in Creating Star Schema
  • Developing BI/SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube
  • Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI s & MDX Queries
  • Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes
  • Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of
  • Use NBI testing frame work for BI unit testing SSAS
  • Use SQL Nexus tool that helps you identify the root cause of SQL Server performance issues

BI Developer

Confidential, Redmond, WA

Responsibilities:

  • Design and implement batch processes against an OLTP database to load the data.
  • Extensive use of Stored Procedures. Writing new stored procedures, T - SQL, Trigger and modifying existing ones
  • Extensive use of Power Query, Power Pivot, Power Map, and Slicers.
  • Design and develop reporting using excel 2012/2013 Dashboard

Environment: MS SQL Server 20014, Confidential Visual Studio 2012/2013, Excel 2012/2013

BI Developer

Confidential, Redmond, WA

Responsibilities:

  • Design and implement batch processes against an OLTP database to load the data.
  • Extensive use of Stored Procedures. Writing new stored procedures, T - SQL, Trigger and modifying existing ones
  • Expertise in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS)
  • Involved in Creating and manipulating ETL calls through SSIS using stored procedures and complex queries and make automated.
  • Experience in full life cycle of SSRS (Authoring, Managing and Delivery reports)
  • Design and develop reporting services reports using SSRS
  • Work on analyzing of data to prepare Executive summary report using charts, Graphs and Gadgets
  • Involved in creating reports based on business request and adhoc requirements using SSRS 2005/2008
  • Create Automated test case script for all new created objects
  • Involved in creating user interface stored procedures that returns data as an XML format.
  • Involved extensively in creating and updating technical specification.

Environment: MS SQL Server 2005(2008), MS Vista, Confidential Visual Studio Team Foundation Server, MS Visual Studio 2008, SQL Server Reporting Services, SQL Server Integration Services

SQL Database Engineer

Confidential, Issaquah, WA

Responsibilities:

  • Design and Implement SSIS package to execute the batch and load data from different sources.
  • Redesign of existing batch SQL batch processes to implement business rules in volume.
  • Responsible for the creation of ad - hoc request script/report and regular SQL queries.
  • Create package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
  • Performance tuning of existing database SQL batch processes including stored procedure, views, triggers and different data base objects.
  • Extensive use of Stored Procedures. Writing new stored procedures, T-SQL, Trigger and modifying existing ones and tune them such they perform well based on the business logic

BI SDET

Confidential, Redmond, WA

Responsibilities:

  • Wrote test plan for SSIS package, DataMart and SSAS.
  • Creating test scenario and test case for SSIS package, DataMart and SSAS.
  • Creating complex queries used in SSIS to test data in database.
  • Executing test covering: Map doc validation, constraint validation, data consistency issue, data quality, null validate, duplicate check, cube design testing, security testing, performance.

Sr. SDET

Confidential, Redmond, WA

Responsibilities:

  • Designing Test Plan and Test Cases for a dynamic web site in Azure for ford car campaign.
  • Designed and implement test automation for a web trend tracking tool.
  • Hands on experience running automated deployment of Azure components to the functional test environment and deploying web role in Azure.
  • Preparing test plans and test cases and create test automation for a web trend tracking tool
  • Run an automated deployment of Azure components to the functional test environment
  • Perform Web testing using VS2010 and load testing using VS2010 to find bottleneck
  • Generate Performance Report and submitting bug reports on VSTF
  • Perform regression testing and create reports (daily status reports and weekly reports)

SDET (contract) Confidential, Redmond, WA July 2010 - Oct 2011

Confidential Online Commerce Platform

  • Designing Test Cases based on functional and technical specification.
  • Develop WCF testing scripts and executed using MS Visual Studio (VSTF).
  • Responsible for the creation test cases and for VSTS Web testing
  • Generate Web test code and develop test driven automation using C# and SQL for the web services
  • Wrote Complex Ad Hoc SQL query for testing and store procedures for test automation
  • Responsible for WCF testing and perform regression testing
  • Participate in daily triage meeting and create report (daily status reports and weekly reports)

SDET

Confidential, Redmond, WA

Responsibilities:

  • Designing Test Cases based on functional/technical specification for testing XBOX live application.
  • Created/updated deployment automation using PowerShell, create test cases & update deployment automation.
  • Create and update deployment web site
  • Follow up daily BVT deployment run, investigate the failure and create a bug whenever there is a failure and make sure that is fixed within the 24 hours.
  • Run QFE deployment manually using octopus
  • Participate on Pre-production meeting to create an instruction for a new release Wrote scripts using power shell that help to cleanup and setup the test environment.
  • Submitted bug reports on product studio.
  • Perform regression testing and create virtual machine using VS 2008 server for test environment

SDET

Confidential, Redmond, WA

Responsibilities:

  • Create test cases.
  • Created UI automation (using VSTS (2008)) in KAF frame work Environment.
  • Design and implement team web site using ASP.NET
  • Wrote scripts that help to cleanup and setup the test environment.
  • Submitted bug reports on VSTS and perform regression testing
  • Create reports (daily status reports and weekly reports)

SDET

Confidential, Redmond, WA

Responsibilities:

  • Created test cases scripts in Visual Studio.
  • Wrote and maintain test cases automation (using C# and T-SQL)
  • Wrote Complex Ad Hoc SQL query for testing
  • Wrote Store procedure for test automation
  • Perform load, performance, and stress testing
  • Do both manual and Automated test cases
  • Submitted bug reports covering system on bug tracking software (Product studio)
  • Perform regression testing and create report (daily status reports and weekly reports)

Hire Now