SUMMARY

• Over 8+ years of extensive experience in Report design, Dashboard development, data quality testing, Quality Assurance and Testing of Software applications.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Experience in SAP BO Full Life cycle implementations on different modules.
• Proven ability to deliver and ensure success in high - pressure/high-risk situations.
• Involved in many aspects of teh SDLC including requirements gathering, proof of concept delivery, Implementation, user support and maintenance.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created incremental refreshes for data sources on Tableau server.
• Worked on moving Tableau Dashboard from Development to Production Live Environment.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Experienced in all activities of full life cycle implementation including Project management, requirement analysis, Data Modelling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, testing, Documentation and maintenance in BO
• Wif Strong Knowledge in all phases of Software Development Life Cycle (SDLC) of BO such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/98.
• Business analyst experience interacting wif end users, functional/technical experts and management to identifying, analyse and developing teh reports that meet teh business needs.
• Strong knowledge of business/process data flow in organizations and experienced in data modelling Concepts.
• Hands of experience on Information Design Tool for Creating BICS Connection, Business Layer, Data foundation Layer in SAP BO 4.0/4.1
• Hand of experience on Universe Design Tool for Creating Universe.
• Extensively worked on development of Web Intelligence, Desktop Intelligence Reports.
• Hands on experience writing SQL Queries.
• Experience in SAP BO upgrade strategy, project planning, landscape design, test strategy and execution.
• Good knowledge on troubleshooting and problem solving skills.
• Excellent communication, interpersonal and analytical skills wif ability to manage and work TEMPeffectively to Meet deadlines in fast paced environment.

TECHNICAL SKILLS

Operating Systems: Windows 9x/NT/2003/2008,UNIX

Languages: C, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005 , MS Access 2000

Visualization Tools: Tableau 9.0/8.1/8.0/7/0

OLAP Tools: Business Objects 4.1/4.0/ XI 3.1/ 6.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CMC,CCM,LCM,Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

BI Tools: SAP BW 7.0, BODS

Other Tools: Toad, Putty, Sub Version

Rational Tools: Clear Case Explorer

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Gatheird business prerequisites, definition and outline of teh information sourcing and information streams, information quality investigation, working in conjunction wif teh information stockroom draftsman on teh advancement of consistent information models utilizing ERWIN.
• Dealt wif Database configuration and Architecture.
• Included in task arranging, planning for database module wif venture supervisors.
• Building, distributed tweaked intelligent reports and dashboards, report booking utilizing Tableau server.
• Made activity channels, parameters and ascertained sets for planning dashboards and worksheets in Tableau.
• Made Tableau scorecards, dashboards utilizing stack bars, visual diagrams, scattered plots, geological maps, Gantt outlines utilizing show me usefulness.
• Worked broadly wif Advance examination Actions, Calculations, Parameters, Background pictures, Maps
• Adequately utilized information mixing highlight as a part of scene.
• Characterized best practices for Tableau report advancement.
• Directed client, client bunches, and booked occurrences for reports in Tableau.
• Executed and tried required inquiries and reports before distributed.
• Created dashboards in Tableau Desktop and distributed them on to Tableau Server that permitted end clients to comprehend teh information on teh fly wif teh utilization of fast channels for on interest required data.
• Scheduled information invigorate on Tableau Server for week by week and month to month increases in light of business change to guarantee that teh perspectives and dashboards were showing teh changed information precisely.
• Changed over metric understanding reports to scene reports.
• Create, customize and share intuitive web dashboards in minutes to basic drag and drop.
• See a far reaching perspective of you're business pipeline and results.
• Access dashboards from any program or tablet
• Pattern Lines, Statistics, and Log Axes. Bunches, chains of command, Sets to make point of interest level synopsis report and Dashboard utilizing KPI's.
• Made composed, tweaked investigation and pictured ventures and dashboards to present to Senior Level Executives.
• Information examination and Adhoc exercise manual creation utilizing Filtering Measures and Dimensions.
• Planned organizing tables according to teh prerequisite and utilized for teh report creation.
• Made WEBI reports wif complex counts.
• Composed and kept up Universes and sent out them to teh store.
• Created Webi investigates SAP BW Queries utilizing BICS as a part of Business Objects 4.0/4.1.
• Configuration and advancement of Xcelsius dashboards according to teh necessity.
• Broadly included in making database bundles, strategy capacities, cursors and triggers utilizing PL/SQL.
• Created complex webi reports utilizing joined inquiries, combining measurements, complex capacities at teh report level and complex channels to fulfill teh end client prerequisite.
• Experienced in working wif gathering, positioning, report variables and diverse capacities in WEBI.
• Organized information in teh report Inserting Filters, Sorting, Ranking and highlighting information.
• Broad information in SQL Server 2008/2012, SSIS.

Environment: Tableau Desktop 8.1/8.0/ 7.0, BusinessObjectsXIR3, IDT, CrystalReports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server, .NET and Java based Applications.

Confidential

Tableau Developer

Responsibilities:

• Included in distributed of different sorts of live, intuitive information representations, dashboards, reports and exercise manuals from Tableau Desktop to Tableau servers.
• Helped clients to distribute and team up reports through a web program and insert Tableau views in other web applications like SharePoint.
• Included in directing trainings to client on cooperate, channel, sort and tweak sees on a current perception created through Tableau desktop.
• Involved in recognizing and tackling teh issues by planning wif senior administrators in crisis and typical issues to meet teh objectives.
• Extensively participated in making an interpretation of business needs into Business Intelligence reporting arrangements by guaranteeing teh right determination of toolset accessible over teh Tableau BI suite.
• Extensively involved in characterizing teh dashboard necessities and giving teh best practices/way to deal wif perform ETL and distribute information to teh reports/dashboards.
• Responsible for teh group that construct scene engineering and dashboards utilizing Tableau desktop, Tableau Server and Tableau Online.
• Working wif User for necessities and part of teh group building up teh product.
• Distribute Tableau exercise manual to cloud and timetable teh invigorate of information. Spent significant time in investigating teh incremental revive situations.
• Taken an interest in Preparing Detailed specialized records from teh useful determinations.
• Made Advance associations, join new tables, make and oversee Extract and Monitor Queries utilizing SQL Assistant.
• Created parameter and measurement based reports, drill-down reports, network reports, outlines, and Tabular reports utilizing Tableau Desktop.
• Executed and tried required questions and reports before distributed dashboards.
• Given backing once teh dashboards were distributed if their were any information changes, framework changes, or prerequisite changes.
• Broadly chipped away at Tableau Desktop, by making Sears and Kmart Complex reports and Dashboards.
• Made Tableau scorecards, dashboards, Heat maps utilizing show me usefulness.
• Great Experience in distributed reports and dashboards to Tableau server
• Made complex information Views Manually utilizing different measures likewise utilized sort, Filter, bunch, Create Set usefulness.
• Distributed Reports, exercise manuals and information source to server and sending out teh reports in various Formats.
• Great involvement in using URL’s, Hyperlinks, Filters for creating Complex dashboards
• Worked making Aggregations, computed Fields, Table figuring, Totals, rates utilizing Key Performance Measures (KPI) and Measure.
• Created and made classes wif Dimension, Detail and Measure questions and Developed Custom pecking orders to bolster drill down reports Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Troubleshoot issues wif existing reports in teh production environment.
• Created Views, Stored Procedures and validated data for teh Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Experienced in developing Dashboards using Xcelsius 2008.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely wif Data Modelers in designing various data warehouse schema techniques
• Create complex reports against SAP BEx Queries.
• Created teh reports on teh web by using Web intelligence.
• Worked on teh data provider that forms teh basis of teh ad-hoc analysis

Environment: Tableau 7.0 (Desktop and Server), BusinessObjectsXIR3, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008, Windows 2003Server, .NET and Java based Applications.

Confidential, NYC

Reporting Developer - Tableau

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for teh Individualized Education Program
• Created Data Connections, published on Tableau Server for usage wif Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed teh best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on several complex visualizations that all had to do wif improving teh programs offered to various schools in NYC.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish teh developed dashboard, reports on teh Tableau Server so that teh end users having access to teh server can view teh data.
• Developed business process and technical design documentation for each reporting service developed in dis project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Developed Reports in SSRS to send teh reports directly to teh respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems wif different transformation and scheduled Jobs to run teh packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement teh business logic.
• Used Stored Procedures to pull teh data from teh Production server and scheduled jobs to run teh Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of teh database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential

Business Object Developer

Responsibilities:

• Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
• Assigned Scheduling Rights as per teh User Requirements
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work wif Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Work wif production team to coordinate and assist in rollout of releases.
• Setup hierarchies in teh Universe for providing drill down options in teh reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Worked wif BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Co-ordinating wif various groups in scheduling releases between environments.
• Deployment of Crystal Reports via various methodologies Central Management Console(CMC), Publishing Wizard, Infoview, Import Wizard.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Assist wif website deployment architecture (e.g. web servers, databases etc.) and code optimization.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.
• Used Clear case Explorer to Take Backup of Webi Reports and Universe.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

Business Objects Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
• Work wif Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in teh Universe for providing drill down options in teh reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Monitoring Scheduling Reports
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.

Environment: Business Objects 3.1, Universe Designer, Web Intelligence. Oracle 10g