SUMMARY

• Having 8+ years of experience in Information Technology including Data warehousing & Business Intelligence.
• Experience in interacting with business users to analyze the business process and requirements and transforming requirements into data warehouse design, documenting and rolling out the deliverables.
• Good Experience in BI Reports/Dashboard development (Tableau 8.2,9.2.7 and 10.1.5, Power BI and Cognos 10.2).
• Expertise in designing and creating various analytical reports and Dashboards to facilitate strategic planning in the organization using Tableau/Power BI/MicroStrategy/Cognos.
• Extensive experience on building Interactive dashboards using Tableau.
• Expertise in SSAS cube development using hive view, Performed multiple cube level calculation.
• Expertise in designing different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Working experience on different Visual Analytics concepts in Tableau like Parameters, Groups, Sets & Filtering conditions Etc.
• Extensively worked on Cognos all studios, Framework manger data modelling and administration area.
• Familiar with database such as MS SQL Server, SAP HANA, Hive and Teradata.
• Advanced knowledge of MS Excel.
• Created flowcharts, ER diagrams for designing data warehouse tables using lucid Chart.
• Good working knowledge of Agile Methodology and good understanding of Planning meeting, Execution of sprint tasks, Review meeting and Retrospective meeting.
• Experience in coordination with multiple teams including onsite - offshore coordination.
• Excellent communication skills with end customers, developers and other team members.

TECHNICAL SKILLS

BI Tools (Reporting & Modeling): Tableau 2018.1, Tableau 10.1.5, Tableau 9.2.7, Tableau 8.2, Cognos 8.4, Cognos 10.2, Microsoft Power BI, Framework Manager, IBM Life Cycle Manager

ETL Tools: Pentaho PDI 4.4.0 (Big Data ETLTool)

Database: SQL Server 2008, Teradata, SAP HANA, Hive (Hadoop)

Scheduling Tools: Hudson Scheduler, Cognos BI, Tidal, Metric Insight

Cube Builder Tools: Transformer, Microsoft SSAS

Language: R, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst and BI developer

Responsibilities:

• Responsible for interacting with business users to analyze the business process & their requirements
• Responsible for transforming requirements in the form of BRD
• Responsible for developing business scenarios and making sure that it includes all the key data points checks to ensure in UAT we don’t come up with any defects
• Closely working with Product Owner and interacting to make sure the development is on track per business requirement.
• Responsible for schedule meeting with product owner to explain progress on development which help to avoid gap/risk in future if any.
• Responsible for end to end development of the Dashboards
• Responsible for making dashboard as interactive as possible for Confidential senior management/Product Owners
• Responsible to educate end users about Power BI which helps end user to execute Power BI dashboard efficiently
• Responsible for designs (Cubes, Entity Relationship) using Lucid chart which gives everyone clear view about business data flow.
• Responsible for Microsoft SSAS Cube development - Cubes are created to handle large data efficiently
• Helping QA team for Business scenarios testing and if any issues related to dashboard execution as well.
• Creating view/table in hive and connecting with cube for analysis.
• Actively involved in all phases of project such as documentation, analysis, Development and testing
• Responsible for finalizing end design such as - whether to go for star schema or snowflake schema etc.
• Responsible for coordinating with multiple teams including offshore team

Environment: Power BI, Tableau 2018.1, Microsoft SSAS cube and Hive (Hadoop Big Data)

Confidential

BI Developer

Responsibilities:

• Performed requirements gathering, analysis and source data analysis and identified business rules for the development.
• Prepared Life Cycle Manager (LCM) PPT and gave the presentation before Business Users and Client Manager.
• Installed Lifecycle manger tool and did the comparison of more than 2000 reports.
• Fully involved in the workshop PPT and prepared the slide with Model/Cube architecture.
• Published Package from Framework Manager and had done object level security.
• Rebuild the cubes on transformer 8.4
• In Cognos connection defined groups and roles
• Created data source for the packages and for static cubes on cognos connection.
• Involved in debugging and troubleshooting
• Fixed multiple issues during Migration of reports.
• Code export from production to development and vice versa.
• Involved in end to end development of the Dashboards and to make it as interactive as possible for Confidential senior management.
• Created set, groups, Map and parameter, Action filters as per the project requirements for better visibility of the data.
• Assigned geographic roles to some fields which were not automatically recognized by tableau and done the editing for unrecognized locations also.
• Extensively used filter, highlight and URL actions to make more interactive dashboard.
• Involved in interaction with the business users directly as and when required.
• Responsible for UAT support in case business users face issues in the usage of the report.

Environment: Cognos 8.4, Cognos 10.2, Teradata, Transformer, Framework Manger, Life cycle Manager 10.2, Tableau 8.2

Confidential

BI Developer

Responsibilities:

• Daily data load and dashboard reports to users
• Resolving DW & BI Helpdesk tickets
• Working with Cognos planning Environments
• Working with Contributor Administration Console management
• Creating and supporting applications and Jobs
• Monitoring Job servers
• Working with Cognos Access Manager 7.3 user management
• Running Macro Doctor and its usage
• Using Cognos Model Review tool
• Interacting with IBM Cognos support for complex issues.
• Installation of Cognos application and patches
• Created Admin link to refresh data in Planning Analyst
• Created Macro to run the job and scheduling Macro in web portal
• Worked on Reconciliation and GTP
• Published the application to the portal from Contributor Console

Environment: - IBM Cognos Planning 8.4.1, SAP Business Objects 12.5.0, IBM Cognos Access Manager 4.8.1