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#