Sr Sql Etl/ Power Bi Developer Resume
3.00/5 (Submit Your Rating)
Pasadena, CA
SUMMARY
- Over 7 years of experience in Database Design and development with Business Intelligence using SQL Server 2012/2014, Integration Services(SSIS), DTS Packages, Reporting Services (SSRS), SQL Server Analysis Services(SSAS), MDX Queries, OLAP Cubes, Star Schema and Snow Flake Schema.
- Have excellent skills in Data Warehouse, Relational and Multi - Dimensional databases, Data Migration, System & Data Integration, Reporting, Analysis and Software Development and Data Management.
- Experience on Migrating SQL database to Azure SQL Database and Azure SQL Data warehouse and Controlling and granting database access.
- Experience performing Relational and Dimensional Data Modeling for data warehouse, data mart or decision support systems.
- Excellent communication skills with excellent work ethics and a proactive team player with a positive attitude. Domain Knowledge of Legal, Finance, Logistics and Health insurance.
- Strong experience on T-SQL, Index fragmentation and Performance tuning using Execution plan and SQL Profiler. Designed and created databases, tables, views, store procedures and triggers.
- Strong skills in visualization tools Power BI, Microsoft Excel - formulas, Pivot Tables, Charts and DAX Commands.
- Experienced in working with MDX & DAX queries and created analytical cube solutions for business reporting (both Multidimensional and Tabular)
- Worked on the Optimization of critical T-Sql, Store Procedures, Etl Jobs, SSAS Cubes and SSRS Reports.
- Expertise in various phases ofproject life cycles (Design, Analyzing, Implementation and testing).
- Led database administration and database performance tuning efforts to provide scalability and accessibility in a timely fashion, provide 24/7 availability of data, and solve end-user reporting and accessibility problems.
- Developed ETL scripts to enable weekly processing of 2-4 GB data sets into data warehouse. Optimized ETL performance to provide quickest response time possible.
TECHNICAL SKILLS
- Business intelligence development
- Designing/modifying data warehouses
- Online analytical processing (OLAP)
- Programming C#, Python
- MSBI (SSIS, SSAS, SSRS)
- Data Visualization
- Data Migration
- SQL Server programming
- Microsoft Power BI
- Microsoft Office
- Analytic Problem-Solving
- Effective Communication
PROFESSIONAL EXPERIENCE
Confidential, Pasadena, CA
Sr SQL ETL/ Power BI Developer
Responsibilities:
- Collaborated with senior management, subject matter experts, and IT teams to define business requirements
- Transformed business requirements into functional and nonfunctional requirements.
- Created complex stored procedures to perform various tasks including, index maintenance, data profiling, metadata searches, and loading of the data mart.
- Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
- Implemented SSIS packages to perform ETL data operations (data Loading, profiling, cleansing, and verification).
- Designed incremental loads to populate the data mart with checksum and timestamp techniques.
- Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.
- Implemented package configurations on development, test, and production environments utilizing parameters.
- Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
- Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Integrated custom visuals based on business requirements using power BI desktop
- Developed Complex sql queries using store procedures common table expressions (CTEs), temporary tables to support Power BI and SSRS reports.
- Developed complex calculated measures using Data Analysis Expressions language (DAX).
- Provided continued maintenance and development of bug fixes for the existing and new power BI Reports.
Environment:SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, Power BI, TFS, SQL Profiler, Visual Studio, C#.
Confidential, Chicago, IL
MS SQL/MSBI Developer
Responsibilities:
- Analyzed business requirements, facilitating planning and implementation phases of the OLAP model in Team meetings
- Participated in Team meetings to ensure a mutual understanding with business, development and test teams.
- Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
- Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.
- Implemented a master-child package model to improve maintenance and performance.
- Configured packages with parameters to acquire values at runtime.
- Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.
- Managed packages the in SSISDB catalog with environments; automated deployment and execution with SQL agent jobs.
- Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to Sql tables.
- Implemented new and complex calculated members in cubes improve report performance.
- Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.
- Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
- Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams and Use Case Modeling.
- Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
- Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
- Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
- Proactively resolve issues to drive quality and system performance improvements across the application
- Participate in cross-team information sharing resources and work to identify risks early in the development process
- Implemented TFS for project version control and change management with bug tracking.
Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, SSAS, Power BI, TFS, Visual Studio, C#