SUMMARY

• 6+ years of professional IT experience in developing and designing Business Intelligence solutions utilizing Power BI and SQL Server.
• Extensive experience in PowerBI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in PowerBI desktop
• Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.
• Experience in implementing physical data model (Databases, Schema Tables, Views & Virtual Data Warehouse)
• Experience in relational database design, SQL queries likeJoins, stored procedures,views.
• Experience in Creating, Maintaining & scheduling various reports inPowerBIlike Tabular Reports.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI andSSRS
• Experience in Publishing Power BI reports from Power BI desktop to Power BI service.
• Created different visualizations in Power BI according to the requirements.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, DataAggregation, Data Merging and Data splitting.
• Expertise in DAX queriesto get and better way to analyzing the data.
• Complete understanding in all facets of Software Development Life Cycle (SDLC).
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Temporary Tables, Constraints and Indexes using various DDL and DML commands.
• Skilled in creating and developing BIDashboards into rich look for better understanding.
• Experienced to generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CSV files to the data warehouse.
• Good logical, analytical, interpersonal skills and commitment to perform quality work as well as an excellent team player.
• Expert in creating different visualizations using Slicers, Lines, Pies, Maps, Scatter, Bullets, Treemaps, etc. using Power BI.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Having the ability to work closely with the team to ensure the timely delivery of business requirements.

TECHNICAL SKILLS

Reporting BI Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SSRS

Databases: MS SQL Server 2016/2018, Oracle9i/10g/11g, MySQL, MS Access,Snowflake

Web Technologies: HTML, Java Script

Operating Systems: Windows 2012/2016/2018 R2, UNIX.

Scripting Languages: SQL, PL/SQL, T-SQL, VB Script

Other Tools: MS Access, MS-Excel

PROFESSIONAL EXPERIENCE

Confidential, Broomfield, CO

Power BI Developer

Responsibilities:

• Develop, Maintain Data Models \ Power BI Reports and provide production support for the Marketing Team
• Created reports using Clustered Column Chart, Line and Stacked Column Chart, Stacked Column Chart and Dash Boards as per the requirement.
• Wrote DAXqueries to validate the data and created new measures, calculations to find out average, sum and differences as per business requirements.
• Responsible for creating meaningful Data Visualizations to communicate results and highlight business impact; utilize various techniques and delivery methods of visualization that are marketing appropriate.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date(MTD), same period last year leads for marketing team to analyze.
• Worked with cross functional teams across the business to ensure deliverables continue to be improved and add value to their business stakeholders.
• Wrote SQL queries to pull data from Snow Flake database for Power BI visualizations.
• Created Drill down Reports, Drill through Report by product wise within the time intelligence like Month to date, Quarterly and Yearly.
• Wrote Measures for conversation ratesin power bi desktop to show good data analysis techniques.

Environment: Power BI Desktop, Power BI Service, Power BI Data Gateway, DAX, Snow Flake, Jira, MS Excel, Windows 10, Sales force, MS SQL Server 2018, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure, Windows 2012/2018 R2 Server

Confidential, Pittsburgh, PA

Power BI Developer

Responsibilities:

• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Worked on all type of transformations those are available in power bi query editor.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Hands-on expertise in SQL reporting, development, analytics, or BI.
• Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Wrote complex SQL queries in database Access and created various joins (inner, outer joins) to fetch the desired output for Data Analysis.
• Used various sources to pull data intoPowerBIsuch as SQL Server, excel,cloud, SQL Azure, etc.
• Created Power BI Visualizations and Dashboards as per the requirements
• Wrote DAX Expressions,PowerQuery, Functions inPower BI.
• UsedDAX(Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map, kpi etc. in Power BI.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Strong experience on connecting various Data Sources inPowerBI.
• Created various data modeling in Power BI and linking the tables using various dimensions.
• Developed and maintained multiplePowerBIdashboards/reports and content packs.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• UsedPowerBIPowerPivot to develop data analysis prototype and usedPowerView andPowerMap to visualize reports.
• Creating, maintaining the users, roles and granting privileges.

Environment: Power BI Desktop, Power BI Service, Power BI Data Gateway, DAX, T-SQL, SQL Profiler, MS Excel, Windows 10,MS SQL Server 2018,Snowflake, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure, Windows 2012/2018 R2 Server.

Confidential, New York, NY

Power BI Developer

Responsibilities:

• Worked closely with Business Analyst, Data Modeler, and all team within the organization to understand business processes.
• Generated context filters and data source filters while handling a large volume of data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date(MTD), same period last year.
• Created Row-level security so based on role, the end-user can view the data.
• Wrote DAX Expressions,PowerQuery, Functions inpowerbi.
• UsedPowerBIPowerPivot to develop data analysis prototype and usedPowerView andPowerMap to visualize reports.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data publishing a report to Power BI Services.

Environment: Power BI Desktop & Service, DAX, T-SQL, Microsoft Visual Studio 2017,DAX STUDIO, MS Excel., MS SQL Server 2018, SQL Server Integration Services 2018 (SSIS), Windows 2018 R2 server.

Confidential, Basking Ridge, NJ

Power BI Developer

Responsibilities:

• Created Reports using Charts, Gauges, Tablesand matrix.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports,Drill Through Report by Region.
• Responsible for building reports inPower BIfrom the Scratch.
• Responsible for creating and changing thevisualizationsinPower BIreports and Dashboards on client requests.
• Worked on various Conditional formatting in power bi visuals to define the data in appropriate way.
• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.

Environment: Power BI Desktop & Service, DAX, T-SQL, DAX STUDIO, MS Excel., MS SQL Server 2017, SQL Server Integration Services 2017 (SSIS), SQL Server Reporting Services (SSRS), Windows 2012 server

Confidential, Jersey City, NJ

Power Bi/ MSBI Developer

Responsibilities:

• Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems MS SQL Server.
• Designed and developed Data models to connect all the incoming/onboarded funds.
• Developed and executed ETL Packages using SQL Server Agent/SSIS to migrate the incoming transactional data from various systems into the Datawarehouse.
• Maintain/check for data consistency in Cascade suite.
• Create SSRS reports and upload them into Cascade to be previewed by the fund accountants.
• Convert Microsoft access Databases to SQL server databases for Trade Capture Application.
• Extensive use of GIT for code check-in and Confluence for documenting the workflow process.
• Extensive data modelling in SSAS to create cubes for efficient reporting.
• Extract data from Various internal API’s/Databases into PowerBi and create data models to be used by different financial teams.
• Setup Data gateways for on premises data servers Implement row level security to keep report access to specific users in the organization.
• Setup PowerBi report server which can be used for paginated (existing SSRS reports) and new PBI reports.
• Develop Data models for the real estate team for efficient data visualization in Power BI.
• Implemented Power BI gateway to keep Dashboards and reports up to date with on-premise data sources.

Environment: MS SQL Server 2008, SSIS, SSRS, SSMS, Visual Studio 2013, Power pivot, T-SQL, Power BI, MS TFS, JIRA, VB.Net

Confidential, Rutherford, NJ

Manual /ETL Tester

Responsibilities:

• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Extensively used SQL programming in backend and front-end functions, procedures, packages.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted data from various sources like flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Tested analytical reports using Analysis Studio.

Environment: Informatica 8.1, SQL Server 2016, Flat files, PL/SQL, TOAD 8.0, SQL, Windows 2012 Server,Testing:Manual,Quality Center