SUMMARY

• Over 8+ years of IT experience, all in the data warehousing, business intelligence reporting and analytics space.
• Expert in developing reports, visualizations, dashboards, storyboards, and mobile capable business intelligence reports using Microsoft Power BI Analytics platform.
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Expert in building row level security (RLS) with Power BI and integration with Power BI service portal
• Used DAX Functions for filtering and creating calculated columns and measures in the Data View.
• Used M language in the Query Editor to transform data before loading into Data Model.
• Developed event - driven analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions
• Utilized Power BI to create various analytical dashboards that depict critical KPIs such as billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Expert knowledge using advanced calculations using MS Power BI Desktop. Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• IBM certified Cognos Business Intelligence Solution designer and developer with in-depth knowledge in interpreting data, analyzing results, and draw conclusions through advanced analytics and statistical techniques using IBM Cognos BI Suite
• Extensive hands-on experience in metadata modeling using Cognos Framework Manager which involves Data security, Object security, DMR, Determinants, Parameter Maps etc.
• Expert in Cognos Report Studio (Relational and OLAP) list, crosstab, chart, report bursting, drill through, master-detail etc.
• Extensive experience in creating Cognos Transformer models for Power cubes and Dynamic Cube Models for DMR based reports
• Experienced in Cognos Active Reporting for Mobile Users, and Advanced Event Studio Schedule Management.
• Ensured maintenance and security control of the Cognos products and solutions.
• Good knowledge in OLTP/OLAP Systems, ER Modeling, Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Experience in creating complex and efficient Stored Procedures, Tables, Views, Materialized Query Tables, Indexes, and SQL/PLSQL.
• Experienced in SQL optimization to improve the performance of reports.
• Hands on experience on Tableau Business Intelligence/Business Analytics software.
• Experience in various phases of Software Development Life Cycle (SDLC) conducting requirements and solution design sessions with executives and creating requirements and design documents for data driven BI projects and development in order to satisfy business reporting requirements.
• Provided extensive End User Training on BI Applications.
• Proficient in database design and analysis, data management, and developing BI solutions for different industries.
• In-depth knowledge of SQL for data analysis, data profiling, data cleansing and development of BI solutions.
• Experience in coordinating and managing global IT delivery model. Worked with large offshore IT teams.

TECHNICAL SKILLS

BI Reporting Tools: Microsoft Power BI Desktop, Power BI Service, Cognos Analytics V11, 10/8 series (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos Report Net 1.x, Cognos Impromptu (7.x/6.x), Power Play Transformer (10.x/8.x/7.x), Tableau 10.x/2018.x

RDBMS: Oracle Exadata (12c)/11g/10g/9i/8i, Teradata, HP Vertica 7.x, IBM DB2 for LUW, SQL Server 2012/2008/2005 , MS Access, PL/SQL, Oracle, MongoDB.

Scheduling Tools: Control-M, UC4, Tivoli Workload Scheduler (TWS), Tidal Scheduler.

Programming Languages: C#, ASP. NET Core, ASP .Net, VB.NET, C, C++

Tools: SSIS, SSRS, SSAS.

Modeling Tools: Erwin, Visio

Cloud: Azur, AWS

PROFESSIONAL EXPERIENCE

Confidential, Minnesota

Power BI Developer

Responsibilities:

• Conducted requirement gathering sessions with business team and functional team to review business and functional requirements.
• Documented requirements in organization standard template and provided effort estimation and execution plan to project managers and business stakeholders
• Prepared wireframes/mockups and elicit feedback from end users
• Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.
• Worked on DAX expressions like filter, aggregate, mathematical functions etc.
• Created hierarchies and attributes as part of dimensional modeling.
• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.
• Designed and developed Power BI reports, self-service packages and dashboards for a large pool of business associates
• Designed and developed operational reports using MS Power BI Desktop for various regional managers and also created calculated measures and columns with DAX.
• Participated in the Agile methodology's daily scrum and other Confidential meetings; developed and prioritized product backlogs and the Confidential burnt down charts etc. to meet the daily deliverables and timelines.
• Used Power Apps visuals in power BI desktop.
• Worked with canvas apps in power App.
• Worked on all types of transformations that are available in Power BI query editor.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset.
• Take Configuration form different data source. Like Azur, Amazon Red-ship, snowflake, SQL etc.
• Connecting to Snowflake in the Power BI service differs from other connectors in only one way.
• Written calculated columns, DAX, MDX, Measures queries in power bi desktop to show good data analysis techniques.
• Developed the reports in Power BI desktop, publish the report and pinned dashboards in the Power BI Service.
• Windows Server EC2 instance to host Power BI Desktop as well as to act as an on-premises data gateway that handles the communication between Power BI and Amazon Redshift.
• Amazon Redshift cluster deployed in a private subnet.
• Created Drill Down, Drill Through, Book Marking and Hyperlinks features in the Power BI report.
• Extensively worked in analyzing profiling and modeling data in the Power BI Desktop using Query Editor and Relationship view.
• Involved in transforming the data from data sources and loading into the target databases using Informatica and generating reports using Power BI and Cognos.

Environment: Power BI, Power Query, Cognos 11/10.2.2 (Framework Manger, Report Studio, Analysis Studio, Transformer, Dynamic Cubes), Tableau, Oracle Exadata, SQL, PL-SQL, Java Script, Share Point, Microsoft TFS, Informatica 9.1, TWS Scheduler

Confidential, Arizona

Power BI Developer

Responsibilities:

• Developed calculated columns and measures using DAX in Power BI
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Created Power BI dashboard and generated reports.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
• Published Power BI Desktop to the cloud.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Developed complex SQL queries to obtain complex data from tables.
• Read source data from HDFS, Azure SQL DB, CSV, ORACLE 11g, SQL Server 2016. through Power BI.
• Read different formats of Source data from hive like JSON, ORC, TXT.
• Generated context filters and data source filters while handling large volume of data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize report
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Created Row level security so based on role, the end user can view the data.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.
• Created SQL Queries for testing the tableau Dashboards.
• Hand on Experience in Unix to write basic commands, Moving files from HDFS to local and vice versa.

Environment: MS SQL Server 2012, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8.

Confidential, Conway, Arkansas

Power BI Developer

Responsibilities:

• Document the impact analysis of the existing reports due to changes in parent-child hierarchies of Entity, Account and Responsibility Centers
• Identify consulting equivalent reports in RIS and document the changes required by consulting users.
• Create new reports for consulting report that are not available in RIS.
• Co-ordinate with EBS, Hyperion, ETL, and DG teams for data related issues.
• Work with offshore team to complete report changes and testing.
• Create projects in Oracle data visualizer using relational databases and flat files.
• Provide day-to-day support to the user regarding report extracts, security and addressing the data related issues.
• Performed performance tuning of long running reports.
• Worked on GIT to maintain source code in Git and GitHub repositories
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Infographic Designer, Spline Chart to make the visuals look and understand better
• Created DAX Queries to generate computed columns in Power BI
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI.
• Worked on Power Query in Power BI desktop to edit the queries and Model for data modelling and establishing the relationships.
• Worked on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team using Power BI service to create the dashboards.
• Generated computed tables in Power BI by using DAX.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Identify the data feed changes and co-ordinate with ETL teams of downstream application to update the ETL workflow and OBIEE reports.

Environment: OBIEE 12c, BI Publisher 12c, Oracle DVD 12c, Power BI, Power Pivot, Power Query, Oracle 11g, Windows, MS SQL Server.

Confidential, TX

Power BI /SQL Developer

Responsibilities:

• Involved in gathering the user requirements.
• Conduct business process analysis and identify critical issues and gaps for an established organizational process.
• Documented conceptual, technical, and operational information accurately and clearly.
• Developed business plans, determine key performance indicators (KPIs) and coordinate the measurement results.
• Analyzed qualitative and quantitative data to uncover competition and industry information to drive the business revenue.
• Gathered information, analyzed new products and services, and allocated relevant data to different departments.
• Conducted evaluation of organization's workflows, implemented process improvements on Microsoft SharePoint to optimize internal process and to determine cost drivers in process using detailed methodologies
• Develop a roadmap for a short and long-term work, manage prioritization, and monitor the work to meet objectives
• Manage projects and create a detailed business process roadmaps for the large single capital project.
• Work with stakeholders to design the roadmap and measure production value ensuring cost effective processes.
• Work with subject matter experts and managers to design advanced analytics that supports energy delivery and applying the appropriate statistical modeling techniques utilizing various platforms and applications to store data
• Create and implement simple statistical models such as logistic regression or forecast modeling to identify risks.

Environment: SQL SERVER 2005/2008, Power BI, T-SQL, SSIS (2005), SSRS (2005), Business Objects, Windows Server 2008, Visual Studio.