SUMMARY

• 6+ years of experience in designing and developing database, data warehousing and Business Intelligence using Microsoft technologies Power BI, Excel, SSIS and SQL Server.
• Good experience in Power Query, Power Pivot and Power View for creating the TEMPeffective reports and dashboards in Power BI.
• Strong experience in creating dashboards using Power BI visualizations.
• Experience working on Custom Visualizations like Chiclet Slicer, Pulse Chart etc.
• Expertise in publishing the reports into Power BI Service and sharing the dashboards to the Users.
• Proficient in creating content packs and creating roles to implement Row Level Security (RLS) for the reports.
• Experience on enabling various types of filters for reports and pinning visuals into dashboards.
• Hands on experience in importing data from developed excel into power bi desktop using get data option.
• Experience in using DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business Calculations based on requirements.
• Experience in creating visual interactions using edit interactions to make few visual to TEMPeffect data based on requirement.
• Good skills in trouble shooting On - Premises Gateway to refresh the dashboards/ reports.
• Experience in creating dashboards and sharing with users.
• Hands-on experience in Dashboard design on Power BI desktop, have done report creation using virtualization on Power BI.

TECHNICAL SKILLS

BI Tools: Power BI

Databases: SQL Server

Programming Languages: SQL, T-SQL, DAX, Visual Basic (VB)

ETL Tools: Power Query, Power View, Power Desktop, Power Pivot, Power BI View

Operating Systems: Windows

Other Skills: SSIS, Excel

PROFESSIONAL EXPERIENCE

Data Engineer - Power BI

Confidential, Nashville, TN

Responsibilities:

• Implemented Visual Level, Page level, report level filters and pinning in dashboards.
• Written simple DAX calculation as per the requirement to maintain business measures.
• Worked on report permissions and dashboard permissions to provide access to different users.
• Used Quick insights to get various types of visuals to match the requirements.
• Worked on relationship tab to provide cardinality between fact and dimension tables.
• Created TEMPeffective reports, dashboards and published in to Power BI service.
• Created the roles for the dashboards, sharing the developed dashboards to the client in Power BI.
• Created content pack library for sharing the dashboards and reports to the colleagues.
• Developed best practices for database design and development activities.
• Connected, imported, shaped, and transformed data for business intelligence (BI).
• Developed Visualization reports and dashboards using Power BI.
• Implemented row level security on data and have an understanding of application security layer models in Power BI.
• Visualized data, authored reports, and scheduled automated refresh of reports.

Environment: Power BI, Power View, Power Query, DAX

Data Engineer - Power BI

Confidential, Austin, TX

Responsibilities:

• Designed and built a dashboard involving KPIs and trend charts to depict Client's overall business needs.
• Designed and deployed reports with Drill Down and Dropdown menu option and Parameterized and linked reports using Power BI.
• Participated in regular technical reviews, defect review and walkthrough meetings with important project and business stakeholders throughout the project life cycle.
• Created Data extracts for better performance and accessing data offline.
• Analysed the requirements and discussed with managers and leads on the functionality.
• Extracted data from different kind of source systems into Power Query and then cleansed the data by applying business rules and loading it into Power Pivot.
• Created new measures and columns with DAX in MS Power BI Desktop.
• Created visualizations like Pie Charts, Tree Map, Tabular and Matrix by using Power BI View.
• Designed different types of reports like drill down and drill through reports in Power BI.
• Knowledge in creating Groups and content packs in the Power BI services.
• Worked on On-Premises Gateway to refresh the data sources/creating a live connection.
• Created SQL Server (T-SQL) stored procedures, views, and Power BI reports for project planning and regulatory reporting.
• Implemented Role Based and Row Level Security as part of security in Power BI.
• Shared the reports & dashboards to end user.

Environment: Power BI, Power Query, Power Pivot, Power BI View, MS Power BI Desktop, T-SQL, DAX

BI Developer

Confidential, Irvine, CA

Responsibilities:

• Worked on Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Scheduled and maintained daily and monthly loads of Legacy systems.
• Involved in installing and maintaining MS SQL Server 2000/2005.
• Created SSIS package for loading the data coming from various interfaces like KOL, Confidential and different Gaming sites and also uses multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Developed Visualization reports and dashboards using Excel 2013.
• Visualized data, authored reports, and scheduled automated refresh of reports.

Environment: SQL Server 2012 Excel, SSIS