BI Developer Resume

SUMMARY:

6+ years of experience in ETL/Data Warehouse/BI Report testing.
2+ year experience with testing and deploying Big Data solutions on Spark.
1+ year of experience in web automation testing with Selenium WebDriver.
Expertise in data analysis, validation, verification, cleansing, completeness, integrity, and mismatch identifications.
Solid understanding of Software Development Life Cycle and Agile methodologies.
Strong SQL knowledge.
Self - motivated with positive attitude, desire to learn and ability to adapt to new environment quickly.
Excellent communication and documentation skills.
Ability to work well under pressure to meet deadlines.

SKILL:

BI Tools:: MS SQL Server, SSIS, SSAS, SSRS, Master Data Services (MDS), Azure Data Lake, Azure Data Factory V2, Databricks

Platforms: Microsoft Azure

Big Data Tools:: Spark, Hive

Languages: T-SQL, MDX, DAX, Python, PowerShell

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook

Operating Systems: MS Windows Server 2008 R2/2012

Databases: SQL Server 2008/2012/2014/2016

EXPERIENCE:

BI Developer

Confidential

Create/modify tables, views, stored procedures and functions.
Modify ETL SSIS packages to load data from source to target.
Modify data factory pipelines and PySpark scripts to load data to Azure Data Lake.
Monitor daily Production on premise ETL jobs, Azure data factory pipelines and Spark jobs. Troubleshoot job failures and data issues. Determine downstream impacts and notify users of any data delays. Determine root cause and work with developers and/or DBAs on resolution.
Manage junior and off-shore QA team of 3 members, providing guidance and direction in test case development and execution.
Gather and document requirements.
Create and maintain data mapping documents and data dictionary.

QA Lead

Confidential

Performed Functional, Performance, Integration, and Regression testing.
Tested incremental ETL Change Data Capture (CDC) based loads into slowly changing dimensions (SCD).
Tested data, security and UI in various SSRS/Power BI Reports, including payroll/sales trend analysis and sub reports.
Manually tested .NET WPF application hospital accountants used to process doctors’ commissions.
Designed and executed test cases & scripts based on business and data mapping requirements.
Logged and managed defects in TFS/VSTS.
Worked closely with developers to reproduce and resolve issues.
Updated and reviewed release notes to ensure clarity and completion of deployment instructions.
Participated in design and code reviews.
Wrote SQL scripts to validate data loaded into target SQL tables, CSV, and Excel files.
Wrote MDX/DAX queries to validate data in SSAS Cubes and front-end SSRS Reports.
Designed and implemented test automation framework using T-SQL and SQL Server Agent Job for end-to-end validation in Operational Data Store (ODS) and data warehouse. Job ran nightly and email of test results sent.
Developed PowerShell tool to automate deployment of SSRS Reports.
Wrote PowerShell scripts to verify data and role-based user security in SSRS Reports.
Automated testing of SSRS Reports using NUnit.
Wrote automated test scripts in Python using Pandas library and PyTest framework to validate data against Azure Databricks and on premise SQL Server.
Wrote PySpark scripts to test batch Spark data pipelines that loaded data from CosmosDB to Azure Data Lake and from Azure Data Lake to BLOB files in Azure Storage.
Managed junior and off-shore QA team of 3 members, providing guidance and direction in test case development and execution.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship