SUMMARY

• Progressive Technology Leadership & Experience: Business analytics & Insights, Information Management, Data Warehouse, Data Architecture & Modeling, Data Integration, Data Quality, Data Migration, ILM, MDM, Data Visualization, operational reporting, Enterprise Performance Management and Mobile BI
• Extensive Hands - on experience implementing Data Models, ETL and Data Analytics solutions for Fortune 500 companies and State Governments
• 10+ years of experience in Business Objects building Universes, Web Intelligence reports, Dashboards, BO Administration, BO Migration and Upgrade, Server Sizing, Content and Security Management and Performance Tuning.
• 8+ End to End BO Implementation with Architecture & Administration expertise.
• 1+ years of experience working with Python scripts
• 4+ years of Confidential (Cloud BI) tool architectural experience building data models, ETL pipelines, semantic layers, dashboards and pixel perfect reports for Confidential customers along with consulting, training and support.
• 5+ years of Data Modeling experience building ER & Dimensional Data Models, Data Marts and Data Warehouses
• 5+ years of ETL experience using Confidential, Oracle Warehouse Builder, Informatica, Data Stage, BODS, Alteryx and Oracle PL/SQL
• Instrumental in Data Warehouse Architecting and managed multiple end to end BI Implementations
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.
• Strong Unix, SQL and Database Skills on multiple databases with excellent Performance Tuning Skills
• Excellent Domain Experience in Manufacturing, Health & Public Sector, Taxation, Oil & Gas, Finance, Banking, Products, Transport, Media & Pharma and Aviation.
• Performed roles as SAP BO BI Architect, BI Manager, BI Lead, BO Administrator, Data Modeler/ Data Architect, Business Analyst, Principal BI Support Lead, Confidential Architect

TECHNICAL SKILLS

Data Modeling: ERwin, Sybase Power Designer 11.0, and MS Visio 2003

ETL: Oracle Warehouse Builder, IBM Data Stage, Informatica, BODS, Alteryx

Web: Java, JSP, ASP, XML, Java Script, VB Script

Cloud Connectors: Salesforce, Google Analytics, Marketo, Jason, Netsuite, Omniture, REST, Jira, SAP BAPI, XMLA, SFTP

Operating System: Windows NT/2000, Linux 9.0, Unix, Solaris, AIX

Database: Oracle, SYBASE, SQL Server, DB2, SAP HANA, SAP BW, NoSQL, RedShift, MongoDB

Big Data: Aster Data, Big Data Concepts

Data Analytics: Confidential, SAP Business Objects 4.2, Python, Tableau, SAP Crystal Reports,, Qlikview, Tibco Spotfire, IBM Cognos

PROFESSIONAL EXPERIENCE

Confidential

BI Engineer

Responsibilities:

• Analyzing existing Cloud Business Intelligence (BI) architecture and propose recommendation for Confidential BI Appliance server installation and configuration.
• Designing data models and building data warehouses for Next Generation Flight Operations System(FOS) Java Web application using Amazon S3, Amazon Web Services (AWS), Redshift, and MySQL.
• Designing and developing BI reports and dashboards using Agile Scrum Methodology, defining user stories and tasks in Pivotal Tracker.
• Conversion of existing Business Objects and Crystal Reports to Confidential Designer/Visualizer reports
• Planning Sprint activities which include daily standup, kickoff, BI product demos, and collaborating with Product, Engineering and Marketing teams for BI strategy and implementation
• Gathering multiple customer business requirements for BI semantic layer, BI reports, analytics and dashboards; Building business and technical specification documents.
• Designing complex solutions, developing new product features, enhancements, fix defects, root cause analysis and deployment of BI analytics across multiple environments.
• Consulting and training end users on the usage of Confidential BI tool set and enabling customers to build their own custom BI reports and dashboards
• Conducting performance monitoring and tuning of BI servers, reports and dashboards; and managing Confidential BI content by establishing data and user security
• Developed Python scripts to use Confidential API’s for Process Automation and perform QA testing to reconcile data between source systems and Confidential reports

Environment: Confidential 7.3, PostgreSQL, MySQL, Amazon Redshift, Python 3.0,Lucid Charts, Business Objects, Crystal Reports, Tableau, Windows, Linux

Confidential

SAP BO Consultant

Responsibilities:

• Analyze and validate existing BO design specifications built on SAP HANA
• Build Webi Reports on Olap cube
• Convert existing BO reports on S/4 HANA environment

Environment: SAP BO 4.2, S/4 HANA

Confidential

Confidential Architect/Lead

Responsibilities:

• Install & configure Confidential Appliance and recommend best practices for install, configure, upgrade and migration
• Coordinate with IT team, DBAs and Project Managers in building necessary Infrastructure for Confidential solution
• Build Confidential Data models for Claims and Year Over Year reporting
• Developed proof of concept on Confidential capabilities and conversion of 28 SSRS reports into Confidential Designer reports
• Develop ETL scripts using Confidential Query Language (BQL) to extract, transform and load data from SQL Server into Confidential Data Warehouse
• Developed Python scripts to use Confidential API’s for Process Automation
• Build Year Over Year Dashboard and claims reports using Visualizer, Designer & Dashboard tools
• Analyzing Confidential product configuration, troubleshooting issues with deep analysis of data architecture, modeling, reporting and dashboards.
• Train business users and provide guidance in core areas of Security, Confidential Connect, Designing Data Models,
• Space processing, Scheduling, BQL Scripts, Visualizer, Designer, Dashboards and Confidential Appliance Maintenance

Environment: Confidential 5.28, Confidential Modeling, SQL SERVER, Python, Windows

Confidential

Principal BI Lead

Responsibilities:

• Support and Service Customers on Confidential Cloud Implementation and ensure Customer meet their Go-Live Dates
• Train Customers and provide guidance in core areas of Confidential Connect, Application Connectors, Designing Data Models, Space processing & Scheduling, BQL Scripts, Python Scripts, Tableau connectors, Visualizer, Designer and Dashboards
• Rebuild customer reports, scenarios incase of product bugs/enhancements/features, provide indepth analysis, logs to engineering team for fixes
• Provide Technical Support in resolving performance issues in Reports and ETL scripts
• Manage Support Team, Assign and Monitor Customer Cases, Handling Customer Escalations and Manage Key Support Metrics
• Analyzing customer’s Business Intelligence product configuration & troubleshooting issues with deep analysis of data architecture, modeling, reporting and dashboards.
• Troubleshooting Star schema and Snowflake design models with a deep understanding of Data Warehousing concepts.
• Troubleshooting application and database event logs, system Backup & Recovery, application Load Balancing/clustering

Environment: Confidential 5.25, Confidential Modeling, SQL SERVER, ORACLE, SAP HANA, AWS, Tableau, Python Windows, Unix

Confidential

SAP BO/BI Lead

Responsibilities:

• Responsible for gathering Business Requirements and building data marts for Personal and Corporate Income Taxes. Enabled State employees to build self BI reports on Adhoc BI data mart
• Handled Data Modeling role and maintained Data model for 3 data marts
• Develop, maintain and support universes and reports using Business Objects.
• Perform performance monitoring and tuning of universes and reports during application testing and production operations.
• Document benchmarks and procedures needed to optimize performance. Ensure that all guidelines are followed.
• Establish and implement best practices to ensure data quality and report performance
• Collaborate with DBAs, architects, and developers in the implementation of BI solution.
• Manage team’s workload and deadlines - proactively communicate status to leadership.
• Provide technical direction on the use of best practices for Business Objects tools to members of the data team and other project teams.

Environment: SAP Business Objects 4.1, IBM Data Stage, Sybase Power Designer, Tableau, Qlikview, IBM DB2, Windows, AIX