SUMMARY

• Overall 4+ years of professional IT experience in developing and designing Business Intelligence solutions utilizing Power B and SQL Server.
• Extensive experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule reports and create and share dashboards based on reports in Power BI desktop
• Familiarity in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services(SSIS), Analysis Services(SSAS), and Reporting Services(SSRS) Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping and worked with various data transformations like Merge, Sort, Conditional Split and Multicast
• Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.
• Created different visualization in Power BI according to the requirements.
• Proficient in defect tracking tools like JIRA, Quality Center and Service Now
• Experience in relational database design, SQL queries like Joins, stored procedures, views, Variables.
• Skilled in creating and developing BI Dashboards into rich look for better understanding.
• Experience in Creating, Maintaining & scheduling various reports in Power Bl like Tabular Reports
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Worked on both live and import data to Power BI for creating reports.
• Experience in Performance Tuning and Optimization of the rendering time on the interactive visualization dashboards with In-Memory OLAP/OLTPprocessing.
• Experience in data extraction, analysis, modelling, migration, cleansing, transformation, Integration and loading usingETLtools.
• Experience inQlikdata merges from sources like MS SQL, Flat Files, Excel, and XML
• Good Knowledge and experience onPowerBIGateways (Personal and Enterprise gateways).
• Extensively involved in development and supporting of design forPowerBIDashboardReports for various risk areas as per mappings provided across different countries that are within the scope of the project
• Experience in Publishing Power Bl reports from Power BI desktop to Power B service.
• Extensively worked on performance tuning both at Cognos anddatabaselevel
• UsedDAX(Data Analysis Expressions) &MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data splitting.
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Temporary Tables, Constraints and Indexes using various commands.
• Experienced to generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CV files to the data warehouse
• StrongDataGovernance/Profiling experience includingDatacleansing,Dataquality,Dataarchiving andData/Code Migration experience using SQL, T-SQL and Informatica.
• Expert in creating different visualizations using Slicers, Lines, Pies, Maps, Scatter, Bullets, Tree maps, etc. using Power Bl.
• Good understanding and exposure to Software Development Life Cycle (SDLC) methods like Water and Agile, Process Documentation, Data Organization, System Documentation, and Report Writing
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Good logical, analytical, interpersonal skills and commitment to perform quality work as well as an excellent team player.

TECHNICAL SKILLS

Rporting BI Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SSRS, SSIS

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

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, Deerfield, Illinois

Power BI Developer

Responsibilities:

• Worked on all type of transformations those are available in power bi query editor.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• TEMPEffectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• 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.
• Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Serve as a subject-matter expert and proactively identify and implement the best methods/models to address complex business questions, such as data visualization
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using Dimension modelling with Teradata.
• Created Azure Data Factory for Data movement from various sources to Azure SQL Data Warehouse
• Created Power BI Visualizations and Dashboards as per the requirements
• Created mock up and functional user stories implemented in JIRA
• Used Power Query to acquire data and Power BI desktop for designing rich visuals
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Building maps and partitioned SQL queries inInformaticatool to support the large volume objects data migration.
• Involved in validating data between Qlik Sense andCognosreports
• Created data marts and multi-dimensional models like Star schema and Snowflake schema
• Created various data modelling in Power Bl and linking the tables using various dimensions.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map 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, SQL Server SIS), SQL Server Reporting Services (SSRS), Azure, Windows 2012/2018 R2 Server.

Confidential, Bloomington

Power BI Developer

Responsibilities:

• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map Slicer, Time Brush etc.) in Power Bl according to the requirements.
• Responsible for building reports in Power BI from the Scratch.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports usingTableau.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests
• Developed and deployed reports for the internal users in Power BI Report Server.
• Implemented DAX Time-intelligence functions SAME PERIOD LAST YEAR, PREVIOUS YEAR, PREVIOUS QUARTER to manipulate data using time periods, including days months, quarters, and years, and then build and compare calculations over those periods
• Connected Power BI toAzureSQL Database along with a key configuration before connecting Power BI to Azure
• Involved in extracting the data using SSIS fromOLTPto OLAP
• Ensure that all bugs are logged with adequate information into JIRA to assist developers in reducing the problem.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• UsedQlikViewto extract, transform and load (ETL) source data from transaction systems
• UtilizedPower QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging
• Developed, designed, and build dashboards per business requirements usingSSRS
• Created calculated columns and measure in Power BI and Excel depending on the requirement using AX expressions.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Participating in Daily stand upAgile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Involved in ET processes and develop source-to-target data mappings, integration workflows, and load processes
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected result based on requirements.

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 (SSAS Tabular), SQL Server Reporting Services (SSRS), Windows 2018 R2 server.

Confidential

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.
• Responsible for buildingPowerBIDashboards using Tabular and Multi-Dimensional Models.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Used various data visualizations withPower BI.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Implemented Star and/or Snowflake schemas while designing relationaldatabaseand data warehouse as per business and report requirements.
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Customized columns and tables utilizing Named calculations and Named queries inSSAS.
• Migrated from Tableau and Cognos reporting to Power BI reporting
• Worked in theAgileMethodology using the Microsoft VSTS leveraging the Scrum Process to finish the tasks in the Sprint time frame.
• Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc
• Created Row-level security so based on role, the end-user can view the data.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Monitored performance and optimized SQL queries for maximum efficiency.

Environment: Power BI Desktop & Service, DAX, T-SQL, Microsoft Visual Studio 2017, DAX STUDIO, MS Excel., MS SQL Server 2018, SQL Server Integration