We provide IT Staff Augmentation Services!

Lead Business Intelligence Developer/analyst Resume

Chicago, IL

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 Tableau, SAP BOBJ Reporting, BOBJ Data Services ETL process, SQL/PLSQL, SAP BW, SAP HANA, Xcelsius, Crystal Reporting, and R programming.

TECHNICAL SKILLS:

Reporting Tools: Tableau 2018.x/10.x/9.x/8.x, Business Objects Reporting (BOBJ) 4.2/4.1/4.0/3.2/3.1/ 3.0 XIR2/XIR1, Crystal Reports 2013/2011/2008 , 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

  • 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.
  • Currently working on Tableau 2018.1 and 2018.3 version.
  • Designed and developed a total of six university research Tableau Dashboards. The major ones are Proposal, Awards and Expense Dashboards.
  • Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.
  • Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.
  • Worked on creating optimized SQL query views for dashboard data source feeds. Reduced the time of SQL run by 90% in order to use in Live connection
  • 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.
  • Hands on experience in Native HANA Information modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, Analytical view and Calculated views with graphical and script methods.
  • Strong experience on creating native SQL, Hana SQL scripts, stored procedures and debugging SQL script.
  • Developed SAP BODS Extraction Transformation and Load (ETL) activities for Proposal, Awards and Expense DataMart.
  • Developed SAP BOBJ universe using Information Design Tool by creating a semantic layer using Dimensional Modelling (Star schema).
  • Developed SAP BOBJ web intelligence reports
  • Worked on SQL Server, Oracle database
  • Involved in administration activities such as user groups, projects, schedule reports and maintaining servers in BOBJ CMC

Business Intelligence Manager

Confidential

  • 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.
  • Worked on Tableau 10.4x, 10.2x, 9.0x and 8.0x version.
  • Developed Finance, HR, Assets, Fleet, HSP, Billing/Bill print and invoicing, Customer Service dashboards using Tableau.
  • Connected to SAP HANA views to create data sources for Fleet, HSP, Billing/Bill print and invoicing dashboards.
  • Connected to Microsoft SQL server to create data source for Assets management and HR dashboards.
  • Connected to Oracle to create data source for Customer Service and Operations dashboard.
  • Worked on creating optimized SQL query views for dashboard data source feeds hence reducing the run time.
  • Implemented row level security in Tableau Dashboards.
  • Designed an interactive dashboard by using quick and context filters, user parameters, actions URL for business users to navigate from summarized data in Tableau to details reports in Business Objects Webi reports.
  • Expert in using quick/context/global filters, parameters, calculated fields, actions, LOD, Data blending, groups, sets and hierarchies in Tableau.
  • Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.
  • Performed Tableau administration activities like adding users, groups, setting schedules for the extracts and monitoring site activity
  • Imparted Tableau user training sessions in order for business to get familiar with standard dashboard navigations as well as equip super users to create their own dashboards from available standard data sources in tableau online.
  • Support business users with any bug fixes and dashboard enhancements
  • Developed Xcelsius dashboards.
  • Developed SAP BOBJ Data Services ETL jobs.
  • Developed SAP BOBJ universe using Information Design Tool by creating a semantic layer using Dimensional Modelling (Star schema).
  • Developed SAP BW workbench backend model and Bex Queries.
  • Developed SAP BOBJ web intelligence reports.
  • Developed Crystal Reports.
  • Extensive experience in SQL/PLSQL coding.
  • Hands on experience in Native HANA Information modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, Analytical view and Calculated views with graphical and script methods.
  • Strong experience on creating native SQL, Hana SQL scripts, stored procedures and debugging SQL script.
  • Performed administration activities such as Server installation and configuration, user groups, projects, scheduled reports and maintaining servers in BOBJ CMC.
  • Worked on multiple databases like Oracle, SQL Server, DB2 and SAP HANA.
  • Worked on Machine Learning R programming for Home Service Provider project.

Lead Business Intelligence Developer, Accenture

Confidential, Houston, TX

  • 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 data visualization Tableau dashboard reporting for Deal capture and Risk, Operations and Settlement and accounting trading team.
  • Designed an interactive dashboard by using quick/context filters and user parameters.
  • Created Xcelsius Dashboards for Stock Option trade users
  • 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.
  • Administered user groups, scheduled reports, transport management and server administration using BO 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

  • 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

  • Consolidated data from multiple sources into one single system enabling the organization to use analytical data to make strategic business initiatives.
  • Worked on MNYL 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.

Hire Now