Graphic Designer Data Analyst

NASIR AZIZ

Green Card

************@*****.***

Bachelor in IT from Karachi University 2000

linkedin.com/in/nasir-aziz-aa7240236

PROFESSIOANLSUMMARY

Highly motivated Power BI developer and Data Analyst with around 8+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft-managed data centers.

Extensive experience with OLTP/OLAP system and ER modeling developing database schemas like Star Schema and Snowflake Schema used in relational and multidimensional,modeling .

Deep understanding of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.

Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).

Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data

Solid experience on both Cloud and on premise server to deploy power bi dashboard and maintain normal and row level security.

Strong ability to analyze user requirements, Business Requirement Specifications.

Wrote DAX Expressions, Power Query, Functions in Power BI

Extensive experience in building CI/CD

Developed ETL workflow using AWS Data Pipelines.

Strong experience designing various normalized and de-normalized models.

Used Power BI desktop to directly connect to database tables ( Direct Query Mode) or import the files into Power BI ( Import Mode)

Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services ( SSRS) with good knowledge on SQL Server Integrating Services (SSIS)

Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

Expert in Data Preparation, Data Modeling and Data Blending.

Extensively worked on performance tuning both at Cognos and database level

Written complex SQL queries and optimized queries for performance tuning.

End to end experience in designing and deploying data visualizations using Power BI

Developed reports using Tableau and qlikview

Hand on experience in writing calculated columns and measures using MDX and DAX query language

Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment

Expertise in Power BI, Power BI Pro, Power BI Mobile

Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation

Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports .

Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.

Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

WORK EXPERIENCE

QBE Insurance, Working remotely

Sr. Power BI Developer

Mar 2020 to Present

Project Specific Activities:

Designed user-friendly reports in Power BI utilizing various graph features such as Table, Slicer and Pie Chart.

Explore data in various ways and across multiple visualization using Power BI.

Installed and configured Enterprise Gateway in Power BI Service.

Designed and developed data modeling inside of Power BI with M-code and Query Editor.

Write complex T-SQL code and stored procedures to be utilized by applications, ETL and reports

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients.

Imported data from REST API client (Postman) to Power BI to generate reports.

Created CI/CD Build and release pipelines for deployment.

Designing SQL queries in MS SQL Server, Oracle, and Snowflake databases

Utilized Power BI Embedded for non- Power BI users to interact with reports in the custom application.

Implemented DAX function for SSAS tabular models and excel pivot table

Using Crystal report generated Summary report by Region.

Implemented Power BI Gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.

Transformed complex business logic to extract data across multiple sources using well written SQL Queries and PL/ SQL stored procedures

Used Power Query to acquire data and Power BI desktop for designing rich visuals.

Involved in trouble shooting of performance issues which were associated with Tableau reports.

Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.

Prepared user stories to create compelling Dashboards to deliver actionable insights.

Involved in validating data between Qlik Sense and Cognos reports

Scheduled automatic refresh and scheduling refresh in Power BI service.

Created T-SQL scripts, dynamic SQL, complex stored procedures, functions and joins.

Implemented Row Level Security by defining various constraints for each defined role.

Created database links and accessed the data through SQL statements.

Verified the transformation of de-normalized into a normalized model.

Established Content Packs in Power BI Service for sharing and collaboration between end-users and developers.

Utilized the Agile Scrum methodology to analyze the requirements to create stories

Gathered data and visual requirements from business users to deliver effective reports, dashboards and analytics.

Developed complex SQL Views, Common Table Expressions, and Temporary Tables

Charles Schwab, San Francisco, California

Sr. Power BI Developer

Jan 2018 – Mar 2020

Project Specific Activities:

Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.

Developed financial service closed loop advanced analytics framework with focus customer data risk data and operational data.

Involved in database development using stored procedures, triggers, views and cursors.

Performed analysis on historical trade position data trading trends and opposing trade position for fraud detection and trading limit violation

Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.

Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market

Applied row level securities in all power bi reports and assign active directory AID group, schedule and monitored data source to be refreshed accordingly Row Level Security RLS Data Security techniques.

Migrated Snowflake Database to window azure and updating the connection string based requirement

Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.

Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard

Utilized Power BI Gateway to keep dashboards and reports up-to-date with on premise data sources.

Reconcile credit and Market risk data stress result being sourced from legacy system into new data warehouse (CRIS) suing SQL setup data governance and data quality control in partnership with business.

Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.

Involved in database development using stored procedures, triggers, views and cursors

Wrote efficient Stored Procedures for the Optimal Performance of the system.

Used Microsoft Azure date storage and Azure Data Factory, Data Lake

Implemented projects using Agile Msethodology.

Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.

Provided guidance and insight on data visualization and dashboard design best practices in Tableau.

Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant

Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.

Designed dimensional data model of the OLAP database using Erwin.

Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Deployed Dashboards, Reports and Data sources in the Power BI Service.

Environment: MS SQL Server, SQL Server reporting services SQL Server Integration Services 2014 (SSIS), MS SQL Server 2016T-SQL, DAX, SQL Server, PowerBI Desktop,DAX,MDX, JIRA, Tableau, Microsoft Visual Studio 2014, Excel, Azure

New York Community Bank Brooklyn, OH

Power BI Developer

Oct 2015 – Dec 2017

Project Specific Activities:

Coordinated JAD session with the development team to understand functional requirements.

Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better.

Created indexes and indexed views for enhanced query performance.

Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases

Implemented Static and Dynamic Row Level Security in Power BI Desktop

Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.

Created indexed views, and appropriate indexes to reduce the running time for complex queries.

Monitored performance and optimized SQL queries for maximum efficiency.

Involved in all phases of SDLC, and gathered business requirements from business.

Created reports using multiple data providers such as Universes and personal data files in generating reports.

Formatted the reports as per the business requirements.

Created reporting which includes data sources like Microsoft SQL, Dynamic365, Flat files (.CSV), Denodo databases (AWS), PL SQL, Cloud databases, etc.

Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.

Designed dashboards utilizing Power BI with rich visuals sutableauch as charts, slicers, gauges, funnel, word cloud.

Developed Power BI Apps to deliver key metrics to multiple groups within the organization.

Shared Power BI reports and dashboards to various user's groups using app workspace.

Involved in designing and publishing visually rich and intuitive Power BI dashboards.

Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.

Utilized TFS (team foundation server) for coded check-in/check-out and the management of differing code versions.

Environment:, SSDT,DAX SQL Server Analysis Services 2014 (SSAS), SQL Profiler, SSMS, MS-Excel, Power BIDesktop, Azur

First Community Health Plan (Huntsville Hospital System), Huntsville AL

Data Analyst

Nov 2013 to Sep 2015

Project Specific Activities:

Coordinated with DBA's and generated SQL code from the data models and generated DDL scripts using forward engineering in ERWIN.

Developed Process Model for a Healthcare Payer Organization

Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse

Develop and implement strategies, policies and standards for OBIEE administration solutions in the enterprise.

Involved in requirement gathering and testing of consumer web portal for the enrollment of Medicare members.

Responsible for the development and implementation of enterprise data warehouse (EDW) with emphasis on data warehousing, OLAP, star schemas or reporting cubes for reporting and data analysis

Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.

Implemented and maintaining a successful billing process to ensure timely and accurate billing monthly.

Responsible for evaluating, configuring and testing healthcare claims payer system

Review clinicaldata in Cerner System to promote timely, relevant, accurate and consistent information use

Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI Transaction, Code set and Identifier aspects of HIPAA.

Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.

Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.

Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML

Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing

Contact this candidate