About
• Experience in BI Solutions (Data Visualization) (ETL & Reporting) using Power BI, SSIS, SSRS and T-SQL Programming using DDL, DML commands for various business applications.
• Experience with Microsoft SQL Server, SSIS/SSRS in OLTP and OLAP (Data warehousing) environments.
• Developed Calculated Columns and Measures and Data Visualization using DAX in Power BI to create Key Performance Indicators (KPI’s) visuals and dashboards to meet and satisfy client needs on Power BI Desktop.
• Experience in creating SQL objects such as Tables, Complex Stored Procedures, User - defined Functions, Views, Indexes, Triggers, Join.
• Experience in supporting Data Flow transformations: Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analyst, Design, Development, Testing, and Implementation in Agile Methodology
Portfolio
Minimum Wage In United State From1968 To 2020
In the United States, states and the federal government set minimum hourly pay (\"minimum wage\") th... ... More
Employment History
-
SQL/ Power BI Developer
Colaberry INC (Plano TX USA)
July 2018 - Present
• Implementing various Error Handling and Event Handling techniques in SSIS to ensure efficient package execution using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Experience in creating complex (SSIS) packages for ETL purposes, performed data migration from various type of sources (Excel, Flat File, CSV, XML, OLTP DB, etc.), Data Conversions, Data Extraction/Transformation/Loading (ETL) using SSIS and SQL scripts to produce a Data Warehouse for reporting.
• Developing various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Join, Source Qualifier, Expression, Stored Procedure, Sorter.
• Cleaning and extraction of data and defined quality process for the warehouse and involving in the Data warehouse Data modeling based on the client requirements.
• Managing detailed work plans and mentoring peers and junior staff in both design and development of ETL Architecture.