BI Developer Resume

SUMMARY:

3+ years of progressive work experience in Data Warehouse and BI Application Development including Requirement/Data Analysis, Design, Implementation, Testing and Documentation of BI applications.
3+ years of experience in T - SQL and relational database design and implementation in MS SQL Server.
Working experience handling very large database from sourcing, modeling and transformations.
Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3rd Normal Form (3NF) and Multidimensional Data Modeling (MDL) Schema (Star schema, Snow-Flake Modeling, Facts and dimensions). Complete knowledge of data ware house methodologies (Ralph Kimball, Bill Inmon).
Experience in designing and implementing data warehouse and DataMart using Microsoft SQL Server 2008R2/2012/2014, Integration Services, Analysis Services.
Extensive experience in SQL Server SSIS packages to import and transform data from various data sources like Excel, ODBC, OLEDB, FILE, FTP.
Reporting Services ability to design and develop SSRS reports using MS Reporting Services.
Experience in design, develop and deploy analysis model using SSAS and SSRS for data analysis and reports.
Excellent exposure in creating database T-SQL scripts, stored procedures, triggers, views, tables, indexes, and constraints, user defined functions, security using SQL SERVER 2005/2008/2012.
2+ years of experience in developing BI applications (reports, dashboards) using SSRS, MS Excel Power Pivot and Power BI, Power pivot and Tableau.
2+ year of experience in developing BI Data warehouse using SSIS, SQL Server and ERwin Data Model Tool.
Strong communication and organizational skills; proactive, good ability to work positively and effectively in a team and adapt new environments with great potential to learn effectively in a team environment.

TECHNICAL SKILLS:

Data Platforms: SQL Server

ETL Tools: SSIS

Reporting Tools: SSRS, Tableau, Power BI

Languages: SQL, C#

Analytics and Others: Data Modeling (ERwin), SSAS, PowerPivot, MS Office

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

Gather business requirements and build requirement document.
Build source to target mapping documents based on business requirements.
Design specs for ETL packages, reports and dashboards.
Build optimized Data Models for reporting purposes using a Ralph Kimball dimensional model approach.
Build ETL Code using custom SQL scripts and SSIS.
Develop and maintain the data acquisitions (ETL) from source using SSIS for the Data Warehouse.
Write stored procedures, views and query script as part of data acquisitions and reports developments.
Develop customers, resources and regional centric daily/weekly/Monthly reports.
Develop data visualization dashboards trend analysis using Tableau and Power BI.
Developed various operational Drill-through and Drill-down reports using SSRS.
Configuring, tuning, and optimizing SQL Server 2014.
Publish and monitored various reports - Excel, Power BI, SSRS, Tableau.
Automate source data validations.
Work on source data quality issues.
Schedule SQL Agent jobs for various ETL processes.

Environment: SSIS, SSAS, SSRS, Excel Power Pivot, Power BI, Windows Server 2012, Visual studio 2015, SQL Server 2014, Tableau

Confidential

BI Developer

Responsibilities:

Gather business requirements and build design specs for ETL packages and reports.
Build ELT packages using custom SQL scripts to pull data from source systems to data warehouse.
Create optimized data model for reporting purposes using a dimensional model approach.
Build new and monitor existing ETL jobs using complex SQL.
Build OLAP security groups as required by specs.
Design and implement SSRS reports including static and prompted drillable reports.
Design and implement SSRS reports, including static and drillable reports for customers and partners.
Design and implement Subscription Provisioning Dashboards for the Executives.
Tune SQL queries as required to improve performance.
Analyze data and create views and composite indexes to return data quicker.
Technical documentation and reports generation for the application.
Use SQL Profiler to improve performance and monitoring.

Environment: SQL server data tools, visual studio, SSIS, SSAS, SSRS, Tableau, PowerPivot, and SQL Server

Confidential

Laboratory Assistance

Responsibilities:

Conducting statistical analyses on collected data and writing reports.
Maintained the day to day functioning of the lab, including collecting and organizing samples, maintaining cultures and lab supplies as well as inventory and data entry.
Attending seminars, presenting lab reports and define short and long term goals.
Perform Cloning, PCR, Western Blotting, qPCR, qrPCR, Cell Culture.
Isolating DNA/RNA from bacteria and different cells.
Preparing growth media and petri dish with appropriate antibiotics to grow bacteria.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship