PROFESSIONAL SUMMARY:

• 6+ years of extensive IT Experience as a Data Analyst/BI Developer across various Domains likePublic, State and Finance
• Experienced in generating different types of Reports like Ad - hoc reports, Dashboard reports, linked reports, Sub-reports, Parameterized reports, Drill-down and Drill-through reports by using PowerBI .
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups & Conflict Management with Project team members.
• In depth understanding of the As-Is and To-Be business processes and experience in converting business requirements into Technical Specifications for preparing Test Plans.
• Utilized PowerBI gateway to keep dashboards and reports up to-date with data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports using Tableau.
• Data analysis and model development using the R programming language.
• Experience in writing functions, resampling methods, simulations and app development using R Shiny
• Very good experience in Oracle database application development using Oracle 12c/11g/10g/9i,SQL, PL/SQL.
• Strong experience in writing SQL, Stored Procedures, Functions and Triggers.
• Transformed complex business logic to extract data across multiple sources using well written SQL Queries and PL/SQL stored procedures.
• Effectively involved in the data migration from Teradata server to MySQL Server of other reporting Systems.
• Experience in Data analysis, with good data modeling exposure. I am a great team player and very easy to work with.
• Expertise in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

TECHNICAL SKILLS:

BI Reporting Tools: PowerBI Desktop, PowerBI Online (M Language, DAX), Tableau Suite of Tools includes Desktop, Server, Online, Public (10.x/9.x/8.x/7.x)

SQL Tools : Toad, PL/SQL Developer.

RDBMS: Oracle 11g/10g/9i, SQL Server 2005, 2008, 2012, Access,MongoDB, OLAP, Teradata

Documentation: SharePoint, GIT

Scripting/Languages: R,R-Studio, R Shiny ProgrammingHTML, JavaScript,CSS

Operating Systems: UNIX, Linux, Windows 7/XP/2000, 2008/2003, Windows 10

SQL Programming: SQL, TSQL, PL/SQL

Statistical Tools: MS-Excel, MS-Office,MS PowerPoint, MS Visio, MS Project, Erwin

PROFESSIONAL EXPERICANCE:

Confidential, Richmond, CA

PowerBI Developer

Responsibilities:

• Actively engaging in business stakeholder requirements gathering sessions to understand, interpret and translate requirements into an effective technical solution .
• Create multidisciplinary Power BI reports and dashboards for finance and refinery operations teams to visualize and forecast performance.
• Drive the development of a secure framework for how data, reports, and dashboards are designed and maintained .
• Implementing Power BI with back-end database transition support and Azure suite.
• Transition current analysis tools from Excel format to Power BI report format via Power Query, creating bespoke cost forecasting tools for complex maintenance and Turnaround projects, and advising / implementing longer term data management and storage solutions.
• Create reports dashboards using POWER BI desktop and server and maintaining POWER BI Dashboards on servers.
• Extract and analyze data using Power query Pivot tables MS Excel Power BI and SSAS.
• Develop Proprietary tools and reports with Microsoft Excel and POWER PIVOT and POWER POINTS.
• Using dataset ingestion, data model creation, reports, dashboards, KPIs,features, workspaces and security.
• Develop dashboards and reports and implement complex hierarchical row level security as applicable.
• Educate business stakeholders on intelligence reporting capabilities .
• Effectively communicate and interact with business and technical stakeholders to solve complex data related business and technical problems.
• Documentation of applications to satisfy the requirements of the Analytics and Reporting functions.

Environment: Power BI Desktop, MS Office Suite, SQL, T-SQL, PL/SQL, MS-Excel, Microsoft Analysis Services, SharePoint, R, R Studio, Azure Data Lake.

Confidential, Tampa, FL

Data Analyst / PowerBI Developer

Responsibilities:

• Interacted with Business users, BusinessAnalysts to understand reporting requirements and transform them into technical specifications.
• Responsible for extracting, validating, compiling and presenting copious amounts of data in SQL Developer using Sub queries, correlated sub queries, Join conditions, Procedures,Views and Functions.
• Written complex SQL queries and optimized queries for performance tuning.
• Using Statistical Programming Language R/R Shiny along with HTML,JavaScript in automating the Excel reports.
• Developed Queries for generating drill down, drill through reports in Power BI
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inPowerBI.
• Experienced in PowerBI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.
• Updating weekly data and monthly in various excel reports and constantly talking with Business users and product managers and working on excel reports.
• Develop load scripts for extracting, transforming and loading data into Power BI applications.
• Worked on reports existing in Micro strategy.Developed some ordinary reports in the micro strategy.
• Involved in the different Dashboard actions like URL Filters, Action Filter and User Filters.
• Performed different calculations like Quick table calculations, Date Calculations, Aggregate Calculations, String and Number Calculations.
• GeneratedQuarterly/Yearly DEP Metrics which will be sent to Department of Environmental Protection
• Generated Quarterly/Yearly Business Plan Metrics which will be sent to Office of Executives in Confidential .
• Part of Water Use Permit Online Permit Information Center (WUP ePIC) developing team.
• Analyze, identify and resolve data issues for all the four modules (Environmental Resource Permits, Water User Permits, Well Construction Permits) in ePermitting system.
• Resolving the data related issues such as assessing data quality, data consolidation, evaluated existing data sources.

Environment: Power BI Desktop, MS Office Suite, SQL, T-SQL, PL/SQL, MS-Excel, Microsoft Analysis Services,SharePoint, R, R Studio.

Confidential, Detroit, MI

Data Analyst/Tableau Developer

Responsibilities:

• Used agile methodology to understand the existing system and the current business process and methods to identify deficiencies and areas for improvement and enhancement.
• Involved in reviewing business requirements and analyzing data from data sources for design, development, testing, and production rollover of reporting within Tableau Desktop.
• Installed and configured tableau worker servers.
• Created views in Tableau Desktop and published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using Tableau desktop.
• Created AdHoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau AdHoc reports.
• Generated Tableau dashboards with combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields within Tableau reports to facilitate automated data visualizations.
• Provided detailed User Interface Document to the new Salesforce development and testing team for clear understanding of the system
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Effectively used Data Blending, Filters, Actions, Hierarchies feature in tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Enabled the data security filters for the users/groups in an AD.
• Tuned the reports performance using Cache options / Timely refreshes of data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Tableau Desktop(9.x/10.x), Tableau Server(9.x/10.x),R,RStudio,Oracle, SQL,PL/SQL,Salesforce

Confidential, Richmond, VA

Data Analyst / BI Developer (Power BI)

Responsibilities:

• Gathered data from multiple resources and cleaned the data.
• Interpreted healthcare data to identify trends and patterns using Excel and SPSS.
• Designed and developed functional dashboards and reports to improve operation efficiency.
• Used DAX to create complex measure and calculated columns.
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Gained basic knowledge of Healthcare systems and data.
• Interpreting data, analyzing results using statistical techniques and provide ongoing reports
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Identifying, analyzing, and interpret trends and patterns in complex data sets
• Working with management to prioritize business and information need
• Locating and define new process improvement opportunities
• Determining the meaning of data and explain how various teams and leaders can leverage it to improve and streamline processes.Perform testing and validation of data sets
• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created dashboard using parameters, sets, groups and calculation

Environment: Power BI Desktop, Oracle 11g,MS. Excel,), SharePoint, PowerPoint, Visual Studio 2010.

Confidential, Carbondale, IL

Data Analyst/PowerBI Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within PowerBI Desktop
• Coordinating with business users in gathering business requirements and translating them to technical specifications.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently.
• Developed complex calculated measure using Data Analysis Expression language (DAX)
• Embedded Power BI reports on Salesforce portal page and managed access of reports and data for individual users using Roles.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Using Power BI generated context filters and data sourcefilters while handling huge volume of data and built dashboards for measures with forecast, trend line and reference lines and published Workbooks by creating user filters so that only appropriate teams can view it.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Also involved in administration tasks such as publishingworkbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports inPower BI Service.

Environment: Oracle 10g/11g, Power BI Desktop, Power BI Service MS Access, MS Excel, MS Outlook, PowerPoint, SharePoint.

Confidential

Junior Data Analyst

Responsibilities:

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Analyze data from various sources and creating reports weekly, monthly and quarterly reports using Excel, SQL, Power BI.
• Created views in Power BI Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using Power BI desktop.
• Running the Extract schedules on daily, weekly, monthly basis and refreshing all the published data sources.

Environment: Power BI Desktop, Excel reports,MS SQL Server 2008