PROFESSIONAL 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
• Experience in building and organizing advanced DAX calculations and using it 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 .
• 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 BI/BO tools 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
• 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.
• 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 Business Objects, DAX, Power Query, Webi, Xcelsius, Lumira,Spotfire, IDT, SAS, R, Python, Azure, Github, Jenkins, SQL Developer Lumira, Design Studio. SSRS,.SSIS Power Query, Tibco SpofireETL

RDBMS: SAP Data Services, Informatica Power CenterAmazon Redshift, Oracle PL/SQL, 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000,Sybase,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:

Confidential, Chicago IL

Senior Business Intelligence Analyst/Consultant

Skills: Power BI, Tableau, SAP Business Objects, SAP Hana, SAP BW, Data Management, Informatica Power Center, Oracle, Agile Scrum methodology.

Responsibilities:

• Worked on developing Dashboards, Visualizations, Reports based on Oracle data source, Conversion of Tableau based dashboards, Business Objects Webi, BEX, SAP BW data in to Power BI dashboards.
• Setup connection, access to SAP Hana data source . Worked on Azure cloud, Security, Data mining, Analytics. trained Business users on BI skills. Worked on Performance issues, Data issues, KPIs, Data Modeling, ETL, Presentation, Distribution, Scheduling of Visualizations and Dashboards.

Confidential, Chicago, IL

Senior Business Inteligence Lead Developer/Architect

Technology: Tableau Desktop, MS Power BI solutions, Amazon Redshift, SAP Business Objects, Visualizations, Dashboard Design, /Design Studio, Lumira Xcelsius, Analytics KPI, Oracle,Informatica Power Center (ETL) Agile/ Version One.

Responsibilities:

• Responsibilities Designed structured dashboards in multiplie platforms and integrated data from multiple data sources (Excel, Oracle SQL, and flat files) into Tableau MS Power BI, Business Objects for analysis and visualization. Worked on converting the SAP Business Objects /Sql queries in to Tableau Dashboards and Power BI Visualizations. Developed complex visualizations and helped the enterprise to drive adoption and increase visibility into key measures. Worked with Finance, Sales, Marketing, legal, to gather data and metrics requirements and delivered BI solutions to help solve these problems. Gathered report requirements, mockups and followed agile methodology to complete the dashboards in time. Developed standard for the dashboard with performance metrics that aggregated key performance information from multiple sources that was made available to team members, aggregated at the Hierarchical Management levels and provided an interface by which this performance information could be further dissected, interrogated, and analyzed to support business management decision - making.
• Worked on setting up Cloud configuration, Power BI App work space, groups, security, Gateway, content packs, Scheduling, custom visuals, Themes variables, parameters, data model relationship, merge/append queries, direct queries and for Tableau Security, Groups, Variables, Actions Storyboard, Server /desktop configurations, Administration, Performance management, Security groups, Scheduling . Proposed and prioritized changes to reporting and created additional metrics / processes based on evolving requirements.
• Applied data modeling techniques to ensure development and implementation support efforts to meet integration and performance expectations. Analyzed historical data to identify trends and Insights. Refined and automated regular processes, tracked issues, and documented changes and participated in strategic & tactical planning discussions.
• Supported ad-hoc / project-based analysis by leading cross-functional teams with influence in the planning, analysis, and measurement process. Analyzes data security requirements and works with the technology team to implement data security policies. Worked on converting the SAP Business Objects /Sql queries in to Tableau Dashboards and Power BI Visualizations. Assisted in efficient and effective program management; identified poor work quality and cost effectiveness trends; and worked with appropriate staff in analyzing and compiling data from technical reviews, as applicable.

Confidential, Kansas city

Business Intelligence Subject Matter Expert /Architect

Technology: Tableau, MS Power BI, Power Query, DAX, SAS Analytics, SAS Data sets, SAP Business Objects, Oracle SQL,Design Studio, Unix /Solaris/RHEL/Windows, Dashboard Design Webi, Universe Design, Crystal Reports Architecture, Security, Web Services, LDAP, SAP Hana, SAP BW/Bex

Responsibilities:

• Worked as Subject Matter Expert on Developing and Maintaining Reports, Dashboards, Visualizations for Fiscal and Treasury data using Tableau, Tableau, Business Objects and Reporting in Web Intelligence, POC on Power BI, Crystal Reports, Rich Client tools . Responsible for Universes, Administration, BO upgrade, migration, setting up security, version control
• Users Access, data analysis, resolving issues on reporting, universes and performance tuning. Data is related to Federal Reserve Fiscal, Collection, Financial Information Repository, Business Intelligence, Treasury related data metrics. Worked on in creating operational and executive reporting/dashboards based on a wide variety of data sources including but not limited to the Corporate Data Warehouse, Integrated Collections Platform, and inventory management databases. Performed large - scale data analysis and modeling to identify opportunities for improvement and measured the impact of initiatives to make noticeable improvements based on impact and feedback.
• Conversion of BO Webi reports in to Data visualizations dashboards in Tableau dashboards including Schedule, Transform loading, Data cleaning and Data integrity and Maintenance. Analyzed and performed data mining of business data to identify patterns and correlations among the various data points. Established data quality requirements and develops data cleaning processes. Created maps tracing data from system to system to solve a given business or system problem. Designed and created data reports and reporting tools to help business leaders in their decision making. Utilized data analysis techniques including statistical and regression analysis of business data to identify trends and predict outcomes.
• Defined data classifications to allow information assets to be immediately identified and managed. Analyzed data security requirements and works with the technology team to implement data security policies. Recommended and established best practices for data management, report design and creation, and team development to help create a more data driven culture.

Confidential, Chicago, IL

BI Architect/ Lead BI Developer

Technology: SAP Business Objects, Tableau Dashboards and visualizations, SAS Analytics, Unix /Solaris, Dashboard Design 4. WEBI, Dashboards/Analytics, Crystal Reports, Universe Design, SAP BW/Bex, Hana, Architecture, Security, Web Services, LDAP

Responsibilities:

• Worked as Senior Business Intelligence Subject Matter Expert and Responsible for Data Visualization in Tibco Spotfire, Lumira, Xcelsius Dashboards, Reporting in Web Intelligence, Rich client, Crystal reports Designer for Developing 100s of Reports in Webi, Rich Client, Xcelsius for Commercial printing, Retail Printing Divisions . Lead team of Developers in Developing Business intelligence Dashboards.Data is related to Finance, E - Business, Costing, Printing, Distribution and Supply Chain. Developed standard set of sales performance dashboards that aggregate key performance information from multiple sources that can be made available to Sales team members, aggregated at the Sales Hierarchical Management levels.
• Worked on Providing an interface by which this performance information can be further dissected, interrogated, and analyzed to support business management decision-making. Provided internal market trend and competitor dynamics reporting and analytics to be used to support business decisions. Developed comprehensive reporting solutions to support reporting and analytics of customer accounts ranging from global strategic accounts more detailed customer spend reporting. Worked with commercial operations teams to develop and implement comprehensive performance analysis of global commercial operations, putting data models and analytics in place that provide a platform for strategic decision-making.
• Performed large-scale data analysis and modeling to identify opportunities for improvement and measure the impact of initiatives to make noticeable improvements based on impact and feedback. Lead team of developers in developing Business intelligence Dashboards. Participated in industry and other professional networks to ensure awareness of industry standards, trends and best practices to strengthen organizational and technical knowledge. Proactively interacted with Business, Data Integration Engineers, Data Architects, and team to improve processes, reporting interactions, and adoption of tools. Coached and trained business users to facilitate the move to Business Intelligence Reports.

Confidential

Sr. Business Intelligence Subject Matter Expert/Lead

Technology: SAP Business Objects, Tableau, BI Tools, WEBI, UNIVERSES, ETL SAPBW, BICS, BEX, Infocubes, OLAP, Dashboard Design, BMC Remedy data and Applications.

Responsibilities:

• Business Intelligence Reports development in SAP BO, Tableau, Xcelsius, Dashboard Design, Universe Development for Oil/Natural Gas /Finance/Distribution related data metrics .Participated in data gap assessments aligned to global KPI definitions Managed metric definition and Identified changes to people, process and technology for KPI implementation. Worked on getting required business process or data requirements. Worked on finding the change management associated with the requirements and lead the global KPI implementation.Coordinated with IT to implement updates, upgrades and enhancements to the data warehouse and BI applications Design, build, and implemented new reporting infrastructure. Recommended the establishment of new or modified reporting methods and procedures to improve report content and accuracy of information.
• Pushed the changes affect the metrics and developed programs and queries to retrieve, analyze and forecast data for project, and programing requirements. Extracted existing data to manipulate/calculate/format into presentable reports, charts and graphs. Obtained the report requirement document and analyzed reporting needs and requirements. Performed analysis and reporting on service and operational performance improvement efforts.
• Worked with Business, Architects and data Modeler to fully understand the business requirements and Translate Business requirement into System Requirements for Data warehouse and Reporting project. Lead technical delivery team for large Analytics project in a Global delivery model.

Confidential, Itasca, IL

Senior Business Intelligence Developer

Technology: Business Objects, Tableau, Dashboards, WEBI, BODS (ETL) Universe, Tibco Spotfire, Crystal Reports Development, BMC Remedy data and Applications, Infor, Navision, Service now

Responsibilities:

• Responsible for Visualizations and Dashboards using Dashboard design tool Xcelsius and visualization through Tableau, Tibco Spotfire, Xcelsius Dashboards, Data is related to Telecommunication, Finance,Manufacturing, QA, Airlines FAA data Business Intelligence. Developed comprehensive analytical methodologies methods to exploit data with the targeted result of increasing revenue, and promoting growth via deep data mining analysis Performed large - scale data analysis and modeling to identify opportunities for improvement and measure the impact of initiatives to make noticeable improvements based on impact and feedback. Developed comprehensive analytical methodologies methods to exploit data with the targeted result of increasing revenue, and promoting growth via deep data mining analysis and ensured that new and existing reports are accurate and that all supporting data is properly administered. Lead project implementation of selection solutions. Coordinate and collaborated with departments to include
• Marketing & Sales Management, IT and Operations in defining reporting requirements, establishing time frames for delivery, reviewing for quality and reconciling data. Created and document a framework to ensure effective operations controls and meaningful communication on reporting capabilities and activities. Engage key stakeholders to ensure proper and uses of data insights and business intelligence applications.Worked on to validate new and existing reports are accurate and that all supporting data is properly administered.
• Lead project implementation of selection solutions. Coordinated and collaborated with departments to include Marketing & Sales Management, IT and Operations in defining reporting requirements, Established time frames for delivery, reviewing for quality and reconciling data.Created and documented a framework to ensure effective operations controls and meaningful communication on reporting capabilities and activities. Engage key stakeholders to ensure proper and uses of data insights and business intelligence applications. Actively participated in change management activities including identification of stakeholders and assessment of existing reporting. Worked with team for implementation of BI globally and Acted as global escalation point. Actively participated in KPI implementation delivery prioritizations based on business requirements and data availability.

Confidential, Buffalo grove, IL

Business Intelligence Developer

Responsibilities:

• Worked on Business Intelligence reporting, analytics, data mining forecasting and statistics Data Analysis, Documentation and .

Confidential, Schaumburg, IL

Business Intelligence Developer

Responsibilities:

• Worked on Business Intelligence reporting, analytics, data mining forecasting and statistics Data Analysis, Documentation and .

Confidential, Deerfield, IL

Senior Business Reports Analyst/Designer

Responsibilities:

• Reports development in Deski, Complex Universes development and maintenance, scheduling reports, Ad hoc reports development, business analysis, data mining and data warehouse development. The data is related to Pharmaceutical, retail, Distribution and logistics .