Mukta Patel, adbqik@r.postjobfree.com, Cell: +1-469-***-****

**** ******* ****** **, ********* corners GA USA, 30092

Sr.Business Intelligence /Tableau Developer

Tableau, SAP Business Object BI, SAC, Crystal Report, QlikView, DW, ETL, SQL

A dynamic professional with over 9 years of IT corporate experience in Reporting, interactive Data visualization, Data warehousing, ETL and BI solutions for different domain like Banking and Financial services, Hi-Tech and Manufacturing and media domain. Quick learner, Self-motivated, highly dedicated, passionate about to learn new technologies with good analytical, communication skills coupled with a proactive attitude and good team spirit with excellent relationship building.

Work Summary:

Working experience as senior Business intelligence developer with end to end BI implementation, ownership, team lead, client communication, capturing requirement, convert them into technical functionalities, effort estimation for design build and configure, technical design, development, documentation, training to fresher’s, maintenance and production support incident, problem and change management, Onsite experience, Onsite-offshore model, POC work.

Work experience on multiple Business Intelligence projects, building Reports, Data analytics, Dashboards and Data warehousing solution for Banking & Financial Services, Insurance, contract to cash flow application, CRM, Sales reporting, HR Reporting, Hi tech & Manufacturing and Media information services and international television sales business.

Understanding of the business processes, responsible for complete ownership of Reporting and dashboard application, lead team and work in tight coordination with the client and Onsite.

Focused on process and performance improvement, tool automation, best practices and added value to the client.

Work experience in Tableau desktop Data Visualization, Design, Data Blending, Creating Calculations, Geocoding, Statistics, Filters, Parameters, Forecasting, charts, Mappings, working with Data sources, Joins and Calculations.

Analysed large data sets of structured, semi-structured unstructured data to discover data insights and collaborate with business partners to deliver business value.

Worked on Advanced data visualization (Tableau) and dash-boarding skills to support business decisions, provided recommendations and evaluated business performance.

Designed interactive visualizations that enhanced analytics storytelling and communicated business performance.

Supported ad hoc business studies/reporting.

Strong work experience in SAP Business Object Business Intelligence Reporting Analytics and Data visualization, ETL, SAP Analytics Cloud, Design Studio, Lumira Designer using data sources SAP HANA, SAP ERP and non-SAP like Oracle PL SQL, and SQL server. Training and hands on in SAP BW4HANA data modelling, process chain, Bex analyser.

Expertise in development of BO Webi Reports, Universe design using UDT and IDT, Crystal Report, Deski report, Dashboard design, Data visualization, and BI workspace based on relational database like Oracle11g, SQL server, and OLAP sources like SAP Bex queries, HANA views.

Developed of SAP analytics cloud visualization model, story, smart predict, statistics, forecasting, search insight and smart discovery.

Work experience in SAP BODS ETL extraction of large volume of data from SQL server, apply transformation and load data into data mart for reporting and visualization purpose, Job creation, monitoring and to resolve data issue.

Working experience in BI reports migration 560 IT Reports and 460 Business reports from SAP BO 3xi to BI 4.2, Deski to Webi conversion for banking and finance users.

Work experience in BO administration activities, Auditing, CMC management, User security, scheduling, publication, services monitoring, Report conversion tool.

Work experience in QlikView application design and development, scripting, Data modelling, user interface dashboard, ETL based on relational data sources and SAP. Hands-on in Qlik sense

Worked on Data modelling start schema, snowflake schema, Scripting, Data extraction from flat files, SQL server, oracle and SQL, transformation and loading data into DataMart’s, performance monitoring.

Work knowledge in Cognos framework and Reporting, design schema, joins, SQL, complex reporting.

Handling multiple application independently and working in team as well.

Work experience in application development using water fall and Agile model-scrum meeting, story planning, grooming, Git, JIRA, Service Now tool.

Achievements:

Received Belfius Bank client appreciation for My proactive approach, dedication and immense commitment towards delivery of reports well in advance. It has resulted in winning important additional contract and built client relationship.

Received recognition award in project Barclays bank for focused on delivering excellence.

Received ‘Feather in My Cap award’ in project FTB bank in situation ever changing requirements and a strict deadline, I led the team and shown immense commitment towards delivery of development of dashboards as per the business requirement.

Functional domain experience - Banking & Financial Services Reporting, contract to cash flow application, CRM, Sales reporting, HR Reporting, Hi tech & Manufacturing and Media- International television sales.

Certification: Open SAP- Modern data warehousing with SAP BW4HANA.

PROFESIONAL SUMMARY

SOFTTECH USA: Software Developer- Application Jan 2020- till

ACCENTURE Solution Pvt Ltd: Application development Team Lead May 2015 - Dec 2019

ACCENTURE Solution Pvt Ltd Belgium: Lead Analyst May 2018 – Mar 2019

TATA Consultancy Services: System Engineer Mar 2014 - Apr 2015

WIPRO Technologies: Software Engineer Apr 2011 - Mar 2014

BLUE Zone System: Trainee May 2010 - Apr 2011 As Internship

EDUCATION: BTech in Information Technology, SGGS IE&T India, Year 2010, 85%

SKILLS: Technical Domain: SAP BOBI, Business Intelligence tools, Data Visualization, Data Warehousing, ETL, Oracle PL SQL, SQL Server

Business Intelligence Reporting and Data visualization Tools: SAP BO 3XI, SAP BI 4.0 & 4.1,4.2, WEBI, Universe Designer (UDT,IDT), SAP Analytics Cloud, Tableau desktop, Crystal Report 2011,Deski, Xcelsius 2008, Dashboard Design, QWASS, Web service, BEx Query Analyzer, BEx Query Designer, QlikView Dashboard, BO CMC, Lumira Designer, Cognos

ETL Tools: SAP BODS, SAP BW, QlikView, SAP BW4HANA

Database: Microsoft SQL server, PL SQL & Oracle, SAP HANA

Web: HTML,ASP.NET, C#

Trainings completed: BW/4HANA, Tableau, Business Analyst, Big Data and Hadoop, QlikView, SAP BODS, SAP BW, Teradata 13 basics, Hyperion Planning & Essbase, DataStage 8.5, Oracle and PL SQL, .net framework, SQL SERVER2009

PROJECTS UNDERTAKEN & ACCOMPLISHMENT

NEXTGEN, Norcross GA, USA

From Jan 2020 to till

The scope of the project is implementation of BI solution using Tableau dashboards, Business object Webi reports, universe design and Oracle PL SQL for HR module of Nextgen client.

Tools: Tableau desktop 10, SAP Business Object 4.2, Oracle 11g, PL SQL

Role / Responsibilities:

Client communication, requirement gathering and analysis.

Designing, developing and maintaining business intelligence solutions.

Work in Agile model.

Provide weekly status, sprint planning and grooming.

Phase 1: Involved in creating database objects like tables, views, procedures and functions using oracle pl sql for Tableau and BO Reporting.

Working on Tableau dashboard data visualization for HR module.

Prepared and effectively presented findings to business stakeholders, including executive management in a concise fashion

Preparing analysis and design document.

Creating interactive tableau dashboard user interface with quick filters, calculation and parameters for HR users.

Phase 2: To create business object webi reporting using multiple data sources to perform joiners and leavers analysis yearly, monthly and quarterly.

Creation of tableau workbooks, story, dashboard using multiple data source like data blending to perform YTD, QTD and MTD type of analysis.

Creation of Universe design using oracle data sources using IDT.

DEUTSCHE Bank, London, UK

From Apr 2019 to Dec 2019

Project Description:

The scope of project was development of Tableau and QlikView data visualization, BO Reporting, SAP analytics cloud for iHAP and PRIME application for Credit and Risk department users.

Tools used: QlikView, Tableau desktop 10, Cognos, SAP Business object 4.2, SAC, Informatica, Oracle 11g, PL SQL, GIT, JIRA

Role / Responsibilities:

Client communication, requirement gathering, analysis, convert them into technical design and solution.

Worked on POC for Tableau dashboard data visualization for iHap application.

Worked on Tableau dashboard Design, Data Blending, Creating Calculations, Geocoding, Statistics, Filters,

Parameters, Forecasting, Mappings, Working with Data sources, Joins and Calculations for hedging app.

, complex filters, combined queries and calculated measure.

Designed interactive visualizations that enhanced analytics storytelling and communicated business performance.

Provided recommendations, guidelines and best practices.

Worked on universe design modelling using aggregate tables, hierarchies, functions, predefined filters and prompts which simplifies database schema and helps business users building reports to do business analysis.

POC on SAP analytics cloud reporting and data visualization using data sources SAP HANA.

Built dashboards, workbook, story using different charts for measure with forecast, statistics for iHAP hedging app.

Worked on QlikView Dashboard development, scripting, data modelling design for PRIME app.

Worked in Agile model- sprint planning, grooming, service now tool.

Generated Tableau dashboard with quick filters, calculation and parameters.

Worked on Cognos framework and reporting enhancement and new Reporting development.

Prepared analysis, design, KT document, cross skill trainings, suggested best practices.

BELFIUS Bank, Brussels, Belgium

From May 2018 to Mar 2019

Project Description:

Belfius Bank is a one of largest European bank, headquarter in Brussel, Belgium.

The scope of project was migration and upgradation of SAP BO 3.1 reports into BI4 .2 webi, conversion of deski to webi reports, development of webi report, crystal report and Tableau dashboards using data sources Oracle 11 g for IT reports and business report for multiple banking department and SAP analytics cloud dashboard for PCB users.

Tools used: SAP BO 3xi, BI 4.2, Crystal report tool, Tableau desktop, deski client tool, Oracle 11g, PL SQL, SAP Analytics cloud

Role / Responsibilities:

Onsite Role, Client communication, to understand requirement and convert into technical design and solution.

Worked on migration from BO3xi to BI4 reports of total 560 IT Reports and 450 Business Reports.

Technical lead for Crystal report application.

Received recognition from client for best service and delivery of reports well in advance.

Development of webi reports for BI 4 platform Audit and Crystal Reports.

Development of interactive medium and complex dashboards using Tableau.

Created dashboards, stories using multiple data sources, geocoding, mapping, groups, filters, analysis using different charts for analysis of Financial transaction stats across different periods monthly, quarterly and yearly for PCB department.

Development of universe for BI Auditing using IDT.

Validation of BO reports in BI4 for various bank departments includes credit, insurance, PCB etc.

Resolved complex issues for partially converted report faced in the migration.

Worked on Deski to webi conversion for 450 business reports.

Development of SAP analytics cloud visualization model, story, smart predict, statistics, forecasting, search insight and smart discovery.

Estimated effort for crystal reports & built new webi reports for crystal reports for Insurance, PCB, credit & Risk business team.

To discuss daily status with Project supervisor.

Followed agile scrum methodology SP1 to SP40.

Prepared document for known issues resolution. Suggested best practices.

Provided technical assistance, training for team.

BARCLAYS Bank, London,UK

From May 2015 to May 2018

Project Description:

Barclays owns one of Europe's largest banks, a top market-making investment bank, the top UK credit card, and an international wealth management firm.

The scope of the project was development and maintenance of webi reports, universe, Dashboards for HR users.

Tools used: SAP BO 4.0, 4.1, 4.2 SQL Server 2012, SSIS, SAP 7 BI/BW, SAP BODS, QlikView, Tableau

Role / Responsibilities:

To set up new team for production support for Business object reporting Analytic solution.

To lead technical team, requirement gathering, client interactions & convert them into technical functionalities.

Worked BO reports development based on SAP BW queries and universe for HR users.

Worked on QlikView HR dashboards designer, data issues, scripting, data modelling for HR department.

Worked on Tableau Dashboard development, enhancement, data issues, design, joins, calculations, data blending, different charts using SQL, Oracle and SAP HANA views for HR team.

SAP BODS ETL job creation for data extraction SQL, data transformation and loading in to data marts for dashboards and BO reports refresh.

Worked on incident, change management and production support using Service now

Worked independently on multiple applications reporting and dashboard My HR, Community Investment.

Performance management. Data ETL using SSIS and SAP BW.

Worked on BI migration from BO3xi to BI4.2 for CI app.

Provided BO training to Application team and users.

Host daily status call with client to update Incident status of BI Reports.

Process improvement and automation. SAP BW job creation.

Worked on Process chain monitoring and resolved BW file issues and data loading issues.

Worked on creation of Info cubes, DSO Objects, Info Objects, process chain.

Identified and resolved reporting and dashboard data issues at database SSIS job level and BW files issues.

Prepared project documents.

SONY PICTURES AND ENTERTAINMENT, LA, USA

From Mar 2014 to Apr 2015

Project Description:

Sony Pictures & entertainment (SPE) is the American entertainment subsidiary of Sony. It has 4 LOB-Motion Pictures, Home entertainment, television business and Corporate. It operates in multiple countries.

The scope of the project was development of webi reports, universe for finance and sales users.

Version: SAP BO 4.0, 4.1, Crystal Reports, Oracle 10g PL SQL, Crystal Reports

Role / Responsibilities:

Independently worked on BO webi reporting, crystal report for ITSM and C2C application.

Worked on PL SQL and oracle database for BO SQL query performance issues.

Client interaction, gather requirements from BRM and estimate efforts for design, build, configure.

To develop BO reports using advanced functions, calculations, multiple data provider.

Designed universe with aggregate tables, multi start schema modelling.

Implemented various performance improvements activities to increase performance of reports at Universe level.BO administration CMC. Troubleshooting & Resolved production BO reporting issues.

Worked on Incident management tool Service Now

Peer review of the documents and source code. Prepared project documents

Provided Training to C2C application team.

TRANSFIELD SERVICES LIMITED, Australia

From May 2013 to Mar 2014

Project Description:

Transfield Services Limited (TSE) is a provider of operations, maintenance, asset management and project management services. TSE operates in Australia, New Zealand, the United States, the United Arab Emirates, Qatar, South East Asia, India and Canada across industries, including mining and process, hydrocarbons, roads, rail and public transport, water, power, telecommunications, facilities management.

The scope of the project was development of webi reports,Crsytal reports, dashboards, universe, Analysis workspaces and BI workspaces and BO administration for finance and CRM users and BW, BODS ETL solution.

Version: SAP BO 4.0, Dashboard Design, Crystal Report, SAP BW 7.3, SAP BODS, SQL server 2008, Design Studio

Role / Responsibilities:

Requirement gathering and estimation of work.

Development of BO reports using BICS connection referring BW source. Universe designing, Dashboard creation and BO support.

Enhancement of Crystal Report.

Data extraction from source file systems, ERP, SAP in SAP BW and data loading into Cubes and DSO.

BODS job creation for data extraction from DSO and data transformation and loading in to data marts for dashboards and BO reports refresh.

Worked on Design studio, creation of Info cubes, DSO Objects, Info Objects, process chain.

Monitoring BODS Jobs, BW process chains, Data loading, Production data issues resolution.

To troubleshoot and resolve production issues.

Worked on Incident management tool Remedy.

Project document preparation.

FIFTH THIRD PROCESSING SOLUTIONS, Cincinnati, USA

From Mar 2012 to Apr 2013

Project Description:

Vantiv is a U.S.-based payment processing company headquartered in the greater Cincinnati, Ohio area. Vantiv is the largest PIN Debit U.S. acquirer and third largest U.S. merchant transaction acquirer ranked by general purpose transaction volume.

The scope of the project was development of 4 dashboards to show live performance of Transaction stats, Response time, CPU usage, and Top customers/networks for each business hour/day/Month refresh of the enterprise data warehouse (EDW) by the means of IBM Data Stage ETL tool, Oracle 11g database and Business Objects QWass (Query as web service) to read live data from universe to dashboards.

Version: SAP BO 3XI, Xcelsius, Oracle 11g, Datastage

Role / Responsibilities:

To gather requirements and estimation of work.

Design and development of BO Dashboards independently using Xcelsius Design and development of POC for Dashboards for Finance MI, Credit/debit networks, CPU usage and top networks/customers.

Development of Data Stage jobs for data extraction from source and transformation of data and loading into Data marts to refresh dashboards and reports.

Development of QWass (Query as web service) and live office connection.

Design and development of BO reports and Universe.

BO administration activities-User access security, CMC management, reports promotion.

Dashboard data testing using AQT

Deployment of dashboards, BO Reports, Qwass, Universe in production.

Worked on Incident management tool Remedy and CR’s of dashboards.

Post Deployment support.

Document preparation dashboards, universe, Reports, Project KT document and Test Cases.

To give KT to onsite and offshore team.

Worked on Oracle concepts PL SQL part- Stored procedure, Function

ABB_CEU_SAP_PROJECTS, Germany and Switzerland

ABB_CEU_SAP_TIME_AND_MAT

ABB-HPSMC-1

From May 2010 to Apr 2012

Project Description:

The project involved development of Monthly Financial Reports and Dashboard Presentation in SAP BO 4.0 and Crystal Report 2011 and SAP BW queries. The development of crystal reports MFR is 40-page PDF document which compares Actual, Forecast and Budget on various dimensions like monthly, quarterly and yearly. The reporting was at country level, division level and operational unit level. It also involved provision to enter comments at various OU levels.

Role / Responsibilities:

Involved in requirement gathering to understand the formatting and data requirement of each report design.

As major responsibility was Crystal Report development. Developed 72 crystal Reports and Dashboard on Bex queries as per client requirements.

Involved in BO admin part CMC management, Publication, Scheduling reports.

Worked on Bex report creation and Bex queries designer, worked on Bex Analyzer to analysis and validate Crystal report data., worked on Bex designer to analysis and explore BW objects and mapping.

Resolved UAT issues, worked on SIT, Unit testing.

Worked on document preparation related to crystal Report, Dashboard, Unit testing, SIT and SMTD(Software maintenance technical document)

Worked on report migration and Deployment.

Language known: Fluent in Spoken and written English, Dutch Beginner (Level 1.2 certification), Hindi

I hereby declare that all the details mentioned above are true as per the best of my knowledge and belief.

Mukta Patel

Contact this candidate