PROFESSIONAL SUMMARY:

• 10 + years of overall IT experience wif 4 years of experience on Power BI in developing visual reports, dashboards and KPI scorecards using Power BI Desktop, PBI Services along wif DAX.
• Excellent Report creation skills using PBI Desktop and publish to PBI Services AZURE Cloud Services .
• Worked on teh Power Bi reports & dashboards wif data sources like SQL Server, Access DB, Excel, Txt/CSV etc.
• Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations
• Worked on Custom Visualizations like multi slicer,Sync Slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Created New Calculated Column and Measure using DAX Expression.
• Worked wif filters, calculated columns, measures, relationships and transformations of Edit Query section.
• Published .pbix file to Cloud services Azure and shared reports to internal team members and end users.
• Worked on On - Premises Gateway to refresh teh data sources to keep teh dashboards and reports up to date.
• Implemented Role Based Security as part of security in Power Bi.
• Basic noledge in creating teh reports and dashboards in Tableau.
• Knowledge inMS Business Intelligence tools like SQL Server Integration and Reporting Services. SSIS, SSRS .
• Experience wif T-SQL in constructing Tables,Triggers, User Function, Views.
• Experience in Using multiple joinstatements to retrieve data from multipletables.
• Experience in Creating Insert/Update and Delete triggers and Created views for generatingreports.

TECHNICAL SKILLS:

Database SQL Server 2008R2/2012, AccessDB,DB2

SQL Server Tools T: SQL, SQL Server Management Studio, SSIS, SSRS, SQL Server Query Analyzer, Agent and Profiler. Reporting Tools Power BI, Tableau, SSRS

Methodology: Waterfall, Agile

Cloud Platforms: Azure, AWSCloud Services

Operating Systems: Windows, VMware

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Power BI Developer

Responsibilities:

• Gatheird user requirements and analyzed, understand and developed data models accordingly.
• Loaded data from a variety of corporate data sources and performing required transformations in Power BI query editor.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Used Table, Matrix, Bar, Card, Gauge, Slicers, Line, Funnel, Map visualizations
• Worked on Custom Visualizations like multi slicer, Sync Slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Created New Calculated Column and Measure using DAX Expression.
• Utilized teh navigation features like Bookmark, Drill-Through in Power BI.
• Implemented row level security at application security level on data.
• Used Power BI Gateways to keep teh dashboards and reports up to date.
• Publishing reports via teh Power BI service and share them to end users and internal team.

Confidential Corporation, NJ

Power BI Developer

Responsibilities:

• Worked closely wif clients, gathering requirements, and analyzed.
• Get data from a variety of corporate data sources and performing required transformations in Power BI query editor.
• Understand teh business requirements and develop data models accordingly by creating teh relationship between teh tables.
• Developed calculations in DAX which are accurate and perform on large datasets.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Designed effective layouts using themes and report grids,
• Utilized teh navigation features in Power BI (E.g. bookmarks, drill-throughs) to guide readers through a compelling data-driven story.
• Implemented row level security on data and have an understanding of application security layer models in Power BI.
• Explored data in a Variety of ways and across multiple visualizations using PowerBI
• Used Power BI Gateways to keep teh dashboards and reports up to date.
• Published reports via teh Power BI service, managing them through distribution of apps and monitoring usage, data refreshes, security access.

Confidential Corporation, NJ

QA Engineer and QA Lead

Responsibilities:

• Created, reviewed, maintained and executed manual test cases for Web-based, Client/Server and embedded software applications.
• Work wif automation team to design and develop automated test suites for teh website using Java, Selenium.
• Create and execute and maintain automation scripts using Selenium.
• Worked in projects which involved ETL testing. Wrote teh SQL queries to compare teh Source Date wif dat of target data to make teh data accurate.
• Data Extraction, Transformation and loading using Informatica for fact and dimensions table.
• Performed teh data validation by duplicates checks, Null checks, and table count checks.
• Tested reports generated bySSRS and compares reports UI data wif database.
• Verified data quality, completeness and transformation using SSIS packages.
• Performed data validation after ETL flow Extraction, Transformation and Load .
• Performed testing teh Business rules created by mapping and various transformations using Informatica.
• Ran and monitored ETL jobs in Informatica. Loaded teh data to Warehouse/Data Mart.
• Performed API testing using Postman.
• Attended system design and bug review meetings wif developers and project manager.
• Analyzeduser stories, attended daily scrum meetings created, maintained teststrategies.
• Maintained deadlines while continuously keeping project manager updated on teh team’s progress.
• Work wif developers to triage defects to assist wif speedy resolution.
• Managed, maintained test environments and make sure execution not delayed for release.
• Created reviewed test report and closed teh project.