PROFESSIONAL SUMMARY:

• Outstanding Business Intelligence specialist with thirteen years of extensive experience in leading BI team.
• Strong communicator and excels in identifying client need and providing project consulting, preparation and planning, requirement gathering & analysis, estimations, architectural design and development, testing, deployment and production support activities.
• Hands - on technical expert in SAP BOBJ Reporting, BOBJ Data Services ETL process, Tableau, SQL/PLSQL, SAP BW, SAP HANA, Xcelsius, Crystal Reporting, and R programming.

TECHNICAL SKILLS:

Reporting Tools: Business Objects Reporting (BOBJ) 4.2/4.1/4.0/3.2/3.1/ 3.0 XIR2/XIR1, Tableau 2018.x/10.x/9.x/8.x, Crystal Reports 2013/2011/2008, SAP Lumira, Design Studio, Analysis for Office, Xcelsius Dashboards

ETL/Data Provisioning: HANA SLT, HANA SDA, HANA SDI, HANA DXC, SAP Business Objects Data Services (BODS) 4.2/4.1/4.0/3.2/3.1/ XIR2/XIR1

SAP BI/BW: BW/4HANA, BW ON HANA 7.5/7.4, BW 7.3/3.5, BI 7.0

SAP HANA: Native HANA 2.0/1.0, S/4 HANA, HANA Live

ERP: Knowledge of SAP ECC

Programming Languages: SQL, PL/SQL, R Programming, HTML, CSS, C, C++

Databases: HANA, Oracle, SQL Server, DB2 MS Access

Project Management: Microsoft Suite (Outlook, Project, Visio, Word, PowerPoint, Excel)

Testing Tools: HPALM

Ticketing Tools: Clear Quest, ITS, Service Now, JIRA

Domain: 8 years in Energy (Oil and Gas, Utilities), Education (1 Year), Life Science (1 Year), Insurance (1.5 year), CRM Sales (1.5 year)

PROFESSIONAL EXPERIENCE:

Lead Business Intelligence Developer/Analyst

Confidential, Chicago, IL

Responsibilities:

• Leading Business Intelligence reporting team.
• Provide solution, estimate and architectural design for the new AURA Grants 8.0 project
• Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse (DW) strategy.
• Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support.
• Expertise in Business Objects enterprise Products (Universe Designing using IDT, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM, Import Wizard, Publishing Wizard, Translation Manager, Report Conversion Tool, Life Cycle Manager)
• Developed SAP BOBJ Data Services jobs.
• Developed SAP BOBJ universe using Information Design Tool.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Developed SAP BOBJ web intelligence reports.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Created reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Developed data visualization Tableau dashboard reporting for AURA grants 8.0 university research and financial data.
• Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.
• Worked on creating optimized SQL queries for dashboard data source feeds.
• Worked on performance improvement of dashboards using Performance Recording option in Tableau.
• Performed Tableau administration activities like publishing and sharing workbooks and data sources to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts.
• Worked on Oracle database
• Involved in administration activities such as user groups, projects, schedule reports and maintaining servers in BOBJ CMC.
• Experience in publishing and sharing workbooks, data sources to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts.

Business Intelligence Manager

Confidential

Responsibilities:

• Managed and lead Business Intelligence team.
• Worked in various implementation projects in complex environments with many involved parties (technical team, business analyst team, client management, business users, software vendors, outsourcing partners etc.)
• Provide solution, estimates and architectural reviews on new projects as well as production support issue.
• Worked on process improvements, make appropriate recommendations, and facilitate change
• Worked on to consolidate and control changes management process by using Service Now.
• Worked with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse (DW) strategy.
• Interacted with strategic development team, business analyst to analyze business needs and developed technical specifications.
• Involved in all parts of the software development lifecycle of BI solutions including preparation, planning, analysis, design, development, testing, deployment and support. Actively tracked the projects using Microsoft project plan.
• Worked on various projects like Asset Management, Asset Investment strategy (AIS), Fleet reporting, Historical Trending analysis, Diversion, Customer Satisfaction Survey, Home Service Provider (HSP), Finance and Regulatory reporting, Data Migration of Finance Data, Business Objects (Reporting as well as Data Services) upgrade and SAP BW upgrade.
• Expertise in Business Objects enterprise Products (Universe Designing using IDT, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM, Import Wizard, Publishing Wizard, Translation Manager, Report Conversion Tool, Life Cycle Manager)
• Developed SAP BOBJ Data Services jobs.
• Developed SAP BOBJ universe using Information Design Tool.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Developed SAP BOBJ web intelligence reports.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Created reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Developed Finance, HR, Assets, Fleet, HSP, Billing/Bill print and invoicing, Customer Service dashboards using Tableau.
• Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.
• Worked on creating optimized SQL queries for dashboard data source feeds.
• Worked on performance improvement of dashboards using Performance Recording option in Tableau.
• Performed Tableau administration activities like publishing and sharing workbooks and data sources to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts.
• Developed SAP Lumira, Design Studio and Xcelsius dashboards.
• Developed SAP BW workbench backend model and Bex Queries.
• Developed Crystal Reports.
• Extensive experience in SQL/PLSQL coding.
• Developed native HANA and BW on HANA attribute, analytical and calculation views.
• Performed administration activities such as Server installation and configuration, user groups, projects, scheduled reports and maintaining servers in BOBJ CMC.
• Worked on migration project moving SAP FIGL (Finance) data to Oracle Database.
• Worked on SAP BOBJ and SAP BW upgrade.
• Worked on multiple databases like Oracle, SQL Server, DB2 and SAP HANA.
• Worked on Machine Learning R programming for Home Service Provider project.
• Knowledge of Logi Analytics reporting tool.
• Knowledge of Informatica tool.

Lead Business Intelligence Developer

Confidential. Houston, TX

Responsibilities:

• Worked on commodity trading of crude oil in order to support Shell downstream business. Oil data warehousing was implemented for deal capture/risk, operations, settlements and accounting functional areas.
• Worked with business users for requirement gathering and analysis of downstream business functions.
• Created target tables in Oracle database using SQL coding
• Developed complex SQL coding and embedded in ETL jobs.
• Created ETL jobs for Oil data foundation layer.
• Developed custom SQL and embedded in BOBJ universe using IDT and BOBJ web intelligence reports
• Created BOBJ universe design and web intelligence reports for DLC/RSK, OPS and STA trading team.
• Developed data visualization Tableau dashboard reporting for DLC/RSK, OPS and STA trading team.
• Administered user groups, scheduled reports, transport management and server administration using CMC.
• Created user groups, projects and scheduled reports in Tableau server.
• Performed activities like internal testing, volume regression testing and supported business for UAT process.
• Extended production support activities post go-live.

Business Intelligence Developer

Confidential

Responsibilities:

• Developed new planning process which provided a means of collecting data from multiple sources in a standard format thus enabling rapid development of Confidential Crop business growth.
• Worked with business users for requirement gathering and analysis of the data.
• Developed custom SQL and embedded in BOBJ universe using IDT and BOBJ web intelligence reports
• Designed and developed complex Web Intelligence reports using calculated measure, graphs and charts.
• Performed testing of reports and fixed bugs present in the reporting layer.
• Developed sales BI Dashboards using Xcelsius 2008 tool using Live Office connection.
• Scheduled reports using Central Management console.

Business Intelligence Developer

Confidential

Responsibilities:

• Consolidated data from multiple sources into one single system enabling the organization to use analytical data to make strategic business initiatives.
• Worked on Confidential Insurance project as well as CRM and HR process projects.
• Worked with business users for requirement gathering and analysis.
• Created tables in SQL Server and Oracle database.
• Implemented Extraction Transform and Load (ETL) to target tables by using SAP BOBJ Data Integrator
• Created BOBJ Universe and Web Intelligence reports
• Tested ETL jobs, Universes and Web Intelligence reports and successfully deployed to production environment.
• Scheduled ETL jobs and Web intelligence reports using BODS and BOBJ administration console.