Sumaja Nair

adbv9u@r.postjobfree.com 470-***-****

Information technology professional with strong experience in Data visualization, Data analysis and Reporting.

I have experience using varied BI tools- Tableau desktop, Server, Reader, Online 9.x, 10.x, SAP Business Objects, SAP Hana, MSBI, with complete design, development, deployment and security implementations.

I have 6 + years of IT experience in Development and support projects.

I have hands on experience in implementing Enterprise Level Application as per ITIL standards on the ITSM platform (ServiceNow).

Quick learner and proven ability in maintaining strong communication with cross-functional teams, end-users, and contractors.

EXPERIENCE SUMMARY

Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards to deliver actionable insights.

Proficient in SQL/PLSQL queries.

More than 4 years of experience in Business Intelligence tools using Business Objects XI R2/3.1,4.0, Designer, Web Intelligence, Crystal Reports for Enterprise edition, Analysis for OLAP, Xcelsius, CMC.

Expertise in performing end to end requirement gathering from business users and owners.

ITIL V3 certified.

Well versed with SDLC process.

Demonstrated worthy skills to write test cases, test plans and execution of test cases using HP Quality Center

Professional Experience

Tableau developer

Roles and Responsibilities:

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Administer user, user groups and schedule instances for reports in Tableau.

Handled Tableau admin activities granting access and managing extracts.

Good Knowledge in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots and Waterfall Charts according to the end user requirement.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Developed worksheets to perform yearly, quarterly, YTD, QTD and MTD type of analysis.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.

Administer user, user groups and schedule instances for reports in Tableau.

SAP Business Objects Developer

Roles and Responsibilities:

Responsible to maintain Universe and create Business critical Reports for one of the Leading Investment Bank.

Involved in the Creation of Competitive Landscape Report which had the use of Alters, previous month and current month’s Amount Financials in the same Report.

Creation of reports like Reports by Period, Forecast, Demographic reports and Comparative Reports.

Extensively used Calculations, Variables, Breaks, Sorting, and drill down, Slice and Dice, Alerts, Ranking, Filtering for creating Business Critical reports.

Extensively used Calculations, Variables, Breaks, Sorting, drill down, Slice and Dice, Alerts, Ranking, Filtering for creating Business Critical reports.

Granting Group level access to users for Info view through CMC.

SAP BI Consultant

Roles and Responsibilities:

Involved in creating reports built on SAP BW 7.0 system by accessing BEX Queries for leading drug wholesale company in USA.

Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month and All Plants Distribution Report.

Setting up access level security in CMC to give access to users as per their business departments.

SAP BO/HANA Developer

Roles and Responsibilities:

Converted and optimized PL/SQL stored procedures into HANA database models using Attribute, Analytic and Calculation Views.

Expertise in extracting data from legacy systems, transforming and loading data (ETL) into SAP HANA using SAP Business Objects Data Services (SAP BODS).

Designed Universe and created IOU Profitability dashboard which showed the gross profit/margin, cost and revenue by Operating Unit/Account level in TCS.

Demonstrated and created reports-Analysis Workspaces on OLAP by consuming Analytical view using OLAP Connections (cubes of data). Functionalities explored were creating jumplinks to connect it to Crystal/Webi reports and presented it to users for data Analytics.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Created Universe and Report Checklist to be followed as a baseline for development.

Developed Sales Analysis Dashboard and used the formatting options like cross tab representation, section breaks, calculated measures and formulas.

Organized data in the reports inserting Filters, Sorting, Ranking, and highlighting data.

Prepared Universe and detailed report documentation to understand its functionality for business users and owners.

Business Objects Developer

Roles and Responsibilities:

Designed and Developed

Entity-relationship for backend tables of ServiceNow for Incidents/Service request/Projects and SLAs.

Reports developed helped to track additional 40% Incidents/Service Requests that otherwise would have missed SLAs, thereby saving the penalties.

Procedures to calculate Incidents, Service requests, projects, resolution lead time and time left for SLA breach.

IBM Data Stage ETL tool to extract data from source system to Oracle DB.

Procedures to calculate Incidents, Service requests, projects, resolution lead time and time left for SLA breach.

Data mart for Reporting.

Consolidated KPI information in Business Objects Webi with links to detail report for analyzing the Incidents and Service requests and time left to breach SLA.

ServiceNow Developer

Roles and Responsibilities:

Create and modify workflows and customizations for ServiceNow modules like Incident Management, Problem Management, Change Management and Configuration Item (CMDB)/ Service Catalog Management.

Configured ACLs for user roles and permissions.

Setting up user, roles and permissions and security features in ServiceNow.

Build reports, gauges, and customized dashboards according to distinct roles.

Attended weekly CAB meeting to represent the ServiceNow Change tickets and moved those fixes to the Production after the approval.

Scripting to add custom attributes using JavaScript, Glide Record and Query.

Creating UI Pages using Jelly Scripting and XML/HTML.

UI developer

Roles and Responsibilities:

Was involved in the development of the XML and retrieve the values from the web service and provide field validation with the Application.

Was involved in the development of Load Program, which the Web Services will consume to create/modify/delete request in the target system and to automate master data creation process

Did complete round of Functional and system integration testing

Also involved in extended browser support for IE 6.0, 7.0 and latest version of fire fox, Chrome and Safari.

Project Experience -Omnipoint Services Inc. (Oct 2017 - Dec 2019)

Parental Leave/Caring for kids- (2015-2017)

Project Experience - L &T Infotech. (Jan 2014- July 2014)

Project Experience - Tata Consultancy Services Ltd. (Dec 2009- Dec 2013)

Education

Bachelor’s Degree, Computer Engineering, Mumbai University (2005- 2009) with

First Class

Technical Skills

ITSM Tools/Applications

ServiceNow, ITSM Suite, HP Service Manager, HP Asset Manager

Enterprise Business Intelligence Tools

Tableau desktop, server, reader, online 9.x,10.x, SAP Business objects 4.0, XI R2, XIR3.1(CMC, Designer), SAP BI 7.0, Web Intelligence, Crystal Reports for Enterprise, SSIS, SSRS

Programming Languages

.Net, Java, C, C#, XML, PLSQL, CSS, JSP

Web Scripting Language

JavaScript, Jelly Script

Database

SAP HANA, SQL Server 2012, Oracle 11g, Teradata.

Web Technologies

HTML, CSS, ASP.NET.

Contact this candidate