SUMMARY

• Over 12 years of solid experience in Business Intelligence, Data Warehousing, Client Server Technologies as well as on Web - based Applications and Databases.
• Industry experience in Retail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Insurance, Marketing, Service, Pharmaceuticals, Networking and Engineering.
• Managed project tasks effectively and provided active support to project managers in estimation, risk management and issue resolution
• Expert in Power BI, Tableau, SAP Lumira dashboard tools and extensive experience in building data model, Visualizations, Story board Calculations, Variables and KPI based Dashboards.
• Experience in building complex dashboards in Power BI using advanced DAX calculations/Queries/data models and build sales/financial reports. Worked on Merged dimensions, Relationship in data modeling, Parameters, Variables and advanced visualizations using custom visuals and themes.
• Worked on Tableau Desktop visualizations, Cloud server setup, Security, Groups, Variables, Actions Storyboard, Server /desktop configurations, Administration, Performance management, Security groups, Scheduling .
• Worked on advance calculations in tableau and worked on action filters, parameters and calculated sets for preparing dashboards and worksheets, Developed calculative fields using functions available in order to obtain different metrics as per the requirements.
• Experience in writing SQL queries and Stored procedures to get the data relevant for the Tableau reports and Restricted data for particular users using Row level security and User filters.
• Experience in latest SAP Lumira Discovery /Design to build dashboards based on Universes on SAP Hana
• Provided support in designing and evaluating programs and worked on Dashboards, Scorecards and analysis of Business Intelligence data using Tableau /SAS data integration. Built Tableau dashboards and Analytics using SAS data sets. Experienced in SAS Data Sets, Statistical Analysis, Reporting involving analysis, design, development, testing and validating the applications
• Experience in Github, Jenkins, Amazon Redshift, Cloud configurations.
• Worked on complex interactive reports, dashboards, and data stories using data visualization tools including SAP BOBJ (Business Objects), Tableau, Power BI from Cloud /Amazon Redshift/Oracle/SQL Server.
• Worked extensively on the all BI/BO tools SAP Lumira 1.3, Business Objects Web Intelligence, IDT, Universes development, Dashboard Design, Lumira, Xcelsius, Design Studio, BO Explorer.
• Participated in data gap assessments aligned to global KPI definitions and actively participated in KPI implementation delivery prioritizations based on business requirements and data availability.
• Have wide knowledge in building data visualizations with a strong understanding of the appropriate chart types to use to highlight patterns in the data for unstructured and structured data sets
• Developed Version One Stories and docs by Translating Business Requirements to System Requirements for Agile global delivery model Experienced with Agile Scrum approach or hybrid of Agile and Waterfall methodology
• Worked on Hive SQL, NO SQL, Mongo DB data sources
• Used BI expertise in business intelligence tools and data warehousing technologies to implement designed solutions using a combination of coding, scripting, integration, configuration, and data visualization techniques using SQL, DAX, Power Pivot, Power Query, Power BI, Data Gateway, App Work space, Azure .
• Experience in optimizing Tableau dashboards with a focus on usability, performance, flexibility, testability, and standardization and experience in creating security with Tableau.
• Worked proactively with business process owners and subject-matter experts to elicit requirements for new business intelligence and analytics solutions.
• Worked on Data metrics, Forecasting, slice and dice, Actions, KPI, What if Analysis, Graphical representations, Drill down capabilities, Effective management of tests, Data Blending, Data filtering. Worked with large group data sets with millions of rows and improved the performance with the latest guidelines /solutions from forum and user support groups. Built rich and dynamic dashboards using out-of-box features, customizations, and creative visualizations using in-house tools as well as third party tools such as Tableau,
• Worked on conversion of Business Intelligence reports from Business Objects, Excel in to Tableau and Power BI visualizations and trained the Business users. Worked on SSRS and SSIS reporting and ETL tools.
• Project Management experience along with Change/Incident Management, Maintenance, Upgrades, Installations, and working on determining Resolution Methods as well as Time, Cost and Budget.
• Worked on creating complex ad hoc and scheduledwebreports using slice and dice, drill down, cross tab, complex variables, Case/If else conditions, multiple data-providers, multiple table/section and master detail type reports BO Webi and Rich client
• Experienced in Agile Version one Management experience utilizing both Rational Rose and CVS or hybrid of Agile and Waterfall methodology.
• Took the initiative to evaluate software systems activities including requirements, design, development, documentation, integration, test, verification and validation.

TECHNICAL SKILLS

BI Tools: Tableau 10, Microsoft Power BI, SAP Lumira 1.3, SAP Business Objects 4.1 sp5, DAX, Power Query, Webi, Xcelsius, SAP Lumira, Design Studio

ETL: RDBMS:

Data Services, Informatica Power Center: SAP Hana, Amazon Redshift, Mongo db, No Sql, Hive, Oracle PL/SQL, 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000Sybase,MS Access

Database Tools: Toad 7.1, Erwin 3.5.2, AQT

Functional Tools: JIRA, Agile Version one, BMC Remedy, Service Now, Navision, Infor, Mapics, CVS, Camstar, Syspro

PROFESSIONAL EXPERIENCE

Business Intelligence Lead/Architect/Development

Confidential

Responsibilities:

• Worked on building BI Dashboards based on Sales/Performance, Distribution Center, Invoice, Finace, KPI . Worked with IT, Business Users in building reports and dashboards based on their needs and integrating with model and analysis outputs to create real-time reports and dashboards.
• Delivered complex interactive reports, dashboards, and data stories using data visualization tools using Tableau and SAP BOBJ (Business Objects) Worked proactively with business process owners and subject-matter experts to elicit requirements for new business intelligence and analytics solutions and business needs for the current technical environment, and recommended best-fit data visualization and tools/platforms.
• Implemented new BI and analytics technology applications across all functional areas ensuring user adoption and satisfaction .
• Worked on Data analytics and migration from Mongo db, Hive SQL, NoSQL .Gathered business requirements from the business on BI and data analytics projects. Worked on design, development, testing and implemented to Production Powerful KPI based visualizations and dashboards with complex variables Worked on Moving Tableau reports in to Power BI dashboards and visualizations.

Confidential

Senior Business Intelligence Architect/Lead

Responsibilities:

• Worked on developing Dashboards, Visualizations, Reports based on SAP Hana /BW Data source and Oracle data source, Conversion of Lumira dashboards to Tableau BI Dashboards .
• Good exposure in optimizing BI dashboards with a focus on usability, performance, flexibility, testability, and standardization. Participated in visualization, testing and local implementation of defined solutions .
• Good experience in building and organizing advanced Time calculations, YOY Calculations, Band /Grouping variables Worked on Merged dimensions, Query Scripts, Parameters, Variables and advanced visualizations using custom visuals and themes.
• Experience in optimizing BI dashboards with a focus on usability, performance, flexibility. Worked on Modifying and development of existing dashboards worked on KPI /Performance based/Sales/Invoice .