SUMMARY

• Around 12 years of professional experience in development, implementation, analysis, administration and consulting in a Client - Server environment.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Installed and Configured and Maintained Enterprise Gateway and Personal Gateway in Power Bi Services to keep the dashboards and reports up to date.
• Created reports going against Oracle, SQL Server, Azure databases.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Successfully documented and published reports on the web using Data Warehousing techniques in Hyperion (Brio)/Oracle EPM Workspace, Tableau server and Power Bi Workspace.
• Experience in creating Tableau Dashboard using multiple workbooks going against Oracle and EDW databases.
• Experience in updating and publishing the Tableau workbooks to the Tableau server.
• Used SAS as a Data manipulation tool to extract data from various databases and load into a new table.
• Scheduled SAS program to run using Control M.
• Developed various operational Drill-through and Drill-down reports using SSRS .
• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports.
• Experience in developing complex reports using Hyperion Intelligence Designer 8.3, Hyperion Interactive Reporting Studio v9.3.1 and v11.1.x.
• Experience in working in an Agile environment.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a project environment.
• Worked with offshore team in coordinating the RFC’s and Database changes.

TECHNICAL SKILLS

Business Intelligence Tools: Microsoft Power BI, Tableau 10.5, Oracle EPM system 11.2.x, Hyperion System 9, Hyperion Essbase 7.x/6.x, Cognos 11, SSRS, Oracle Report Builder.

Language: SQL, PL/SQL, Python, Visual Basic 6.0

Database: ORACLE 9i/10g/11g, MS-Access, MS-SQL SERVER 2000/2005, Teradata, Azure Database.

Tools: TOAD, PL/SQL developer, DB Designers, SQL Navigator.

Operating Systems: MS-DOS, WINDOWS 98/NT/2000/XP Professional, WINDOW Server 2003, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Eagan MN

Power BI / Tableau Report Developer

Responsibilities:

• Participate in requirements analysis, high level design, developing the reports, coding, unit test, integration and system level testing.
• Creating Row level security with power bi and integration with power bi service portal.
• Executed dashboard setups and data manipulation using DAX.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Populated data using multiple data sources.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Create ad hoc reports for the business on their request.
• Created Dax Queries to generate computed columns and measures.
• Worked on various types of transformations that are available in Power bi query editor.
• Scheduled Automatic refresh and scheduling refresh in Power Bi workspace.
• Good database knowledge and experience to be able to write complex SQL queries .
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Responsible for Maintaining the Access Control for Users, and Groups.
• Wrote JavaScript on control buttons to connect different sections like query, result, Pivot Tables with Dashboard

Hyperion Developer / Cognos Developer

Confidential

Responsibilities:

• Worked with Global sales team to create GSIS and GAIN reports and Dashboards using Hyperion.
• Assisted in the upgrade of Hyperion Brio to Oracle EPM .
• Create ad hoc reports for the business on their request.
• Developed complex Hyperion Interactive Reports using EPM system 11.1.2.1.
• Responsible for Maintaining the Access Control for Users, and Groups.
• Created Dashboards and Reports using JavaScript.
• Converted the existing Sky partner reports from Hyperion to Cognos.
• Wrote JavaScript on control buttons to connect different sections like query, result, Pivot Tables with Dashboard.

Hyperion Developer

Confidential

Responsibilities:

• Worked as part of Sales IT and created Sky Partner Reports using Hyperion.
• Work closely with other technical staff to analyze, design, develop or modify existing reports using Hyperion Tool.
• Create ad hoc reports for the business on their request.
• Developed complex Hyperion Interactive Reports using EPM system 11.1.2.1.
• Responsible for Maintaining the Access Control for Users, and Groups.
• Created Dashboards and Reports using JavaScript and SQL queries.
• Wrote JavaScript on control buttons to connect different sections like query, result, Pivot Tables with Dashboard.

Environment: Microsoft Power BI, Tableau 10.5, Hyperion Interactive Reporting Studio 11.1.2, Hyperion Shared Services 11.1.2, Hyperion Workspace 11.1.2, Oracle 11g, Cognos 11, SAS.