SUMMARY

• Over 8 years of experience as Business Intelligence & Data Analyst
• Experience & knowledge of BI Tools like Power BI, Tableau, OBIEE & Oracle BICS (Cloud Service)
• Experience in developing Performance Dashboards, Score cards, Metrics, Prompts, Drills, & Reports/Dashboards
• Experience in integrating Custom Visuals based on business requirements using Power BI Desktop
• Experience in developing calculated measures using Data Analysis Expression language (DAX)
• Experience in production support to Tableau users and writing Custom SQL to support business requirements
• Experience in creating calculated fields, groups, bins, sets & hierarchies using Tableau Desktop
• Experience in defining and development of dimensions, fact tables, star schema, hierarchies, level - based measures in Business modeling of OBIEE 11g & Oracle BICS
• Experience in Object level & Data level security setup for Stakeholders & Business users using repository objects in OBIEE 11g & Oracle BICS
• Experience in creating Web Catalog Objects (Dashboards, Pages, Reports, Agents) using OBIEE 11g & Oracle BICS Web UI

TECHNICAL SKILLS

BI Tools: Power BI, Tableau, OBIEE 10g/11g, Oracle BICS (Cloud Service)

Database Languages: SQL, PL/SQL, T-SQL

Databases: Oracle 10g/11g, MS SQL Server 2008/2012

Database Tools: TOAD, SQL Developer, SQL Server Management Studio

Software methodology: Agile Scrum, JIRA software

Computing platforms: Windows Server 2003, 2008

Application Tools: SAP, MS Office 2003, 2007, 2012, 2016, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Handled Power BI development and administration role
• Developed custom visual reports, dashboards and KPI scorecards using Power BI desktop
• Connected to data sources (SQL Datawarehouse, flat file), importing data and transforming data for Business Intelligence
• Resolved data gateway issues like reconfiguration, create new data sources in existing gateway cluster by providing windows credentials, file path or server name by going to manage gateway then add these data sources to the gateway in schedule refresh window.
• Excellent in analytical thinking for translating data into informative visuals and reports
• Implemented row level security on data and have a good understanding of application security layer models in Power BI
• Created queries using DAX functions in Power BI desktop
• Used Power shell commands to download PBIX files which were created online in service
• Expertise in using advanced level calculations on the data set
• Good understanding of writing SQL queries and pulling data from SQL server
• Analyzed & Modified existing SSRS reports & SSIS packages
• Created basic SSIS packages using excel or text files as source and Insert/Update records into SQL Server table
• Created & supported production SQL Server jobs
• Performed SQL Server Admin tasks like creating logins & setting permissions for new & existing users
• Responsible for design methodology and project documentation
• Adept in developing, publishing and scheduling Power BI reports as per the business requirements
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources

Confidential

Power BI Analyst / SQL Developer

Responsibilities:

• Led the design and development of reporting data module of order management system (OMS)
• Participated in requirements meetings to understand business needs. Gathered and documented requirements in Business Requirement Documents (BRD)
• Developed at least two-three visual options for each report for discussion with stakeholders & business users
• Integrated Custom Visuals based on business requirements using Power BI Desktop
• Developed SQL queries, Common table expressions (CTEs) & Temporary tables in SQL Server to support Power BI Reports
• Developed calculated measures using Data Analysis Expression language (DAX)
• Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business requirements to support executive business needs
• Used excel features like vlookup, power pivot and functions like concatenate etc to do data analysis and validations
• Provided support & maintenance of Power BI reports to business users

Confidential

Oracle Business Intelligence Analyst

Responsibilities:

• Created Sales Analytics subject area using Salesforce CRM as source
• Created pre-aggregated logical columns like # of Leads, # of Opportunities, total revenue etc.
• Created hierarchies like Product, Time etc.
• Created level-based measures like Quarterly revenue, monthly leads or opportunities etc.
• Designed, developed & tested reports & dashboards based on requirements from stakeholders & business users
• Created Freight Analytics subject area which was running live and replicated into Oracle BICS (Cloud Service)
• Created Performance Tile views like YTD Freight weight, Shipments & Total amount paid
• Created bins on the basis of Weight break showing Total Amount paid & # of Shipments
• Created prompts on dashboard pages like Year, Origin of Shipment, Month & Carrier names
• Created All Driver performance summary report and drill down report of each driver
• Created application roles for setting object level & data level security & permissions for users
• Provided enhancement, support & maintenance of reports & dashboards for users to support executive business needs

Confidential

Tableau Analyst

Responsibilities:

• Worked on reporting project for Order Management data of Oracle ERP
• Gathered the business requirements, imported the data and created the worksheets and visualizations using Tableau Desktop 8.0.3
• Developed Tableau Desktop data visualizations using Heat maps, Waterfall charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Control & Funnel Charts, forecasting & forecast precision.
• Provided Production support to Tableau users and wrote Custom SQL to support business requirements
• Created calculated fields, groups, bins, sets & hierarchies using Tableau Desktop
• Designed, developed & tested visualizations & dashboards based on documented requirements using tableau Desktop
• Utilized Tableau server to publish and share customized interactive reports with stakeholders & business users
• Provided authorization and permissions of reports and dashboards for Tableau users
• Provided 24/7-production support for Tableau users

Confidential

Oracle Business Intelligence Analyst

Responsibilities:

• Assisted team in gathering business requirements
• Performed source system discovery and data analysis
• Designed relational and dimensional enterprise BI data models
• Developed OBIEE 10g/11g repository and build Reports/Dashboards/iBots/Agents for users
• Designed Physical, Business Model and Presentation layers, define logical views and physical data Security structures
• Created and Supported following Subject Areas/Analysis in OBIEE 10g/11g:

Confidential

Business System Analyst

Responsibilities:

• End to End ownership of the product lifecycle, mostly Interactive Voice Response (IVR) - In-dial & Out-dial, SMS
• Took briefs from enterprise sales team as well as enterprise clients and translated them into product document
• Created report formats of all products and shared with technical team
• Created initial solution concepts to be given to sales for client pitch
• Conceptualized product A to Z based on client briefs
• Coordinated with internal development teams
• Wrote functional features, scripts for bearers like SMS, Voice & WAP etc