About
Skilled Data Visualization Analyst experienced in designing and developing captivating reports and applications in Power BI. I am skilled in SQL Server Management Studio, Reporting Services (SSRS), Integration Services (SSIS), and Visual Studio. A highly communicative individual with strong interpersonal skills and ability to adapt to working in team environments. Motivated by a challenge, an astute and dedicated professional working with the highest of ability and effectively managing the challenges of reporting. Current engagement demonstrates a focus on customer satisfaction with reliability, honesty, integrity, and ability to collaborate.
Portfolio
Netflix Movies and TV Shows
Since Netflix debuted in 1997, the streaming market started to soar in 2015 and 2016 with tremendous... ... More
Employment History
-
SQL /Power BI Developer
Colaberry Inc
July 2018 - Present
Analyzed, designed, and developed the BI solutions for complex requirements.
• Developing T-SQL code with the with use of Complex Stored Procedures, SQL Window Functions External
Tables, Views, Indexes, Joins, Sub Queries, Temporary Tables, Table Variables, Merge statements and CTEs.
• Using the ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data
warehouse.
• Creating complex SSIS packages using various transformations in data flows such as Script Components,
Union alls, Sorts, Lookups, Slowly Changing Dimensions, OLEDB, commands Derived columns, Data
conversions and Conditional splits.
• Extracting data from a large variety of date sources such as parquet files, XML files, SQL Databases, Flat
files, MS Excel files, and CSV files.
• Building new report in SSRS and stored procedure output reports.
• Implementing slowly changing Dimension methodologies such as Merge Statements to maintain and
update Dimension tables in the Data Warehouse.
• Implementing logging and error handling in packages.
•Create KPIs using complex DAX functions and reports in Power BI