SUMMARY

• Over 11+ years of professional IT experience in software development, Architecture decisions and leading projects in all phases of BI full life cycle including requirement gathering & analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Good understanding of business process and analysis in implementation of proper solution to meet the business need for making better decisions
• Good working knowledge on distributed data processing systems
• Strong understanding of Data Warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snow flake Schema, FACT and Dimension tables
• Data modeling using different Normalization forms, Dimensional data modeling using Conceptual, Logical and Physical data models with the tools like Erwin
• Well experienced with Waterfall, Agile and Scrum methodologies
• Created/reviewed project specific documents to ensure the accurate proposed solution has to be executed
• Expertise in various visualization tools Tableau, Microsoft Power BI, Yellowfin, IBM Cognos BI and SSRS for producing attractive rich graphical parameterized visuals/dashboards to convey the story inside the data
• Good knowledge on working with cloud services like AWS and Microsoft Azure
• Generate standard and custom reports summarizing business, financial/economic data for review by executives, managers, clients and other stakeholders
• Good hands on experience in connecting data and embedding the dashboards to SharePoint, Salesforce and Amazon S3 Bucket.
• Experience in creating different visualizations using Bars, Lines, Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets and Highlight tables
• Can assess the impact of implementing new requirements/enhancements within the enterprise warehouse with respect to data integration, other system interdependencies, people and processes
• Expertise in UAT support management, ensure the test script, test data, defect management, conducting defect status meetings, managing new CR’s till smooth completion of UAT
• Proficient in defect management system using HP ALM and participated defect status meetings to report the root cause analysis and resolution of the defect within the stipulated time
• Worked as liaison between the Customer and the Off-shore & On-shore team
• Good knowledge in Administration for publishing, migrating code over multiple environments
• Good knowledge on interactive visualization with predictive analytics R
• Flexible and versatile to adapt any new environment with a strong desire to keep pace with latest technologies and can work as an individual or as a team
• Good written and communication skills
• Excellent Analytical, Programming and Logical skills

TECHNICAL SKILLS

Hardware / Platforms: Windows 98/XP/2000/Win 7

Data/Tabular Modeling: Erwin, SSAS

Reporting Tool: Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, Cognos Framework Manager, Yellowfin Reporting, Yellowfin Storyboard, Tableau Desktop, Tableau Server and Microsoft Power BI Desktop, Microsoft Power BI Service, SSRS

ETL Tool: Informatica, SSIS

Database/Languages: Oracle, MS SQL server, SQL/T-SQL

PROFESSIONAL EXPERIENCE

Confidential

Sr Power BI Lead

Responsibilities:

• Interacted with the business users for understanding the business requirements and the existing system
• Conducted the gap analysis to identify the feasibility of the existing system to accommodate the new integrations
• Analyzed the functionality and formulas of the data and created metric (KPI’s) dashboard reports using the visualization tool
• Implemented Role based access security using Microsoft Power BI
• Lead the team and mentored them in prioritizing and distribution of the tasks
• Good hands on working experience with Microsoft Azure cloud services
• Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database
• Created SSAS tabular model to use a source for Microsoft Power BI visuals.
• Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Tableau and Microsoft Power BI data visualization tools
• Expert in implementing business related custom visuals in addition to the visualization tool to showcase the data in a easy and efficient manner
• Developed professional reports as per the business requirements using Yellowfin
• Expert in designing and creation of Yellowfin storyboards which can give a summarized story of the data about the business
• Written SQL queries for verifying the logic to test the data w.r.t the visuals.
• Performed administration tasks during upgrade, code migration/movement between the environments and user access permissions using Microsoft cloud Power BI services
• Done effective reviews to avoid defects for meeting the quality goals
• Published dashboard reports to online Power BI could service for the use of report consumers
• Interacted with the business users in UAT
• Participated defect status meetings to report any issues during UAT with root cause analysis and resolution of the defect within the stipulated time

Environment: Tableau 10.4, Microsoft Power BI, Microsoft Azure, Yellowfin BI, SSIS, SSAS and SQL Server 2012

Confidential

BI Consultant

Responsibilities:

• Interacted with business users for understanding the business requirements and the existing system
• Conducted gap analysis to identify the feasibility of the existing system to accommodate any new integration in future
• Analyzed the functionality and formulas of the data and created metric (KPI’s) dashboard reports using Tableau and Microsoft Power BI
• Migrated/Recreated the Dashboards from Tableau to Microsoft Power BI as per the client interest to showcase the result of data analysis from the database
• Done effective reviews to avoid defects for meeting the quality goals
• Participated defect status meetings to report any issues during UAT with root cause analysis and resolution of the defect within the stipulated time
• Published dashboards to the Microsoft Power BI Web service for navigating the dashboards through web by the consumers
• Performed administration tasks during upgrade, code migration/movement between the environments
• Provided end user training on the navigation of Power BI dashboards to know the story of their data

Environment: Tableau 8.3, Microsoft Power BI, Informatica, Erwin and Oracle

Confidential

BI Consultant

Responsibilities:

• Interacted with business users for understanding the business requirements and the existing system
• Conducted gap analysis to identify the feasibility of the existing system to accommodate any new integration in future
• Analyzed the functionality and formulas of the data and created metric (KPI’s) dashboard reports using Tableau Desktop
• Developed Tableau Desktop Dashboards to showcase the result of data analysis from the database
• Done effective reviews to avoid defects for meeting the quality goals
• Participated defect status meetings to report any issues during UAT with root cause analysis and resolution of the defect within the stipulated time
• Published dashboards to the Tableau server for navigating the dashboards through web by the consumers
• Provided end user training on the navigation of Tableau dashboards to know the story of their data

Environment: Tableau 8.0, Informatica and Oracle

Confidential

Sr. BI Developer

Responsibilities:

• Developed Dashboards to showcase the result of data analysis from the database using Cognos Report Studio
• Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs
• Published dashboard reports to web service for navigating the developed dashboards through web
• Actively participating in peer review of UTC (Unit Test Cases), mappings and Business functionality
• Automating and streamlining the manual jobs to have minimal dependency
• Bug fixing and fine tuning in the existing Informatica Objects
• Created couple of mappings to meet the requirements
• Given trainings/demos to users on Cognos reports navigation

Environment: Cognos, Informatica and Oracle