SUMMARY

• Around 12 years of experience in Analysis, Design, Development, Testing and Implementation of Business Applications and Client/Server applications.
• Strong expertise in using Tableau software as applied to BI data analytics, reporting and dashboard projects.
• Strategic expertise in design of experiments, data collection, analysis and visualization.
• MS EXCEL: Experience in validating and Analyzing data in worksheets using sorting, filtering, Vlookup, creating PIVOT tables, charts.
• Expertise in working with all the modules of Business Objects like Supervisor, Designer, BO User, BO Reporter, Web Intelligence, Desktop Intelligence, Info view, Data Integrator, Broadcast Agent, Auditor, EPM, Zero Admin BO(ZABO),Import Wizard, Report Conversion, Report Bursting, Migration from 6.5.1 to BOXI R2, Crystal Xcelsius, Live Office. CMC and Crystal Reports XI .Expertise in Development, Maintenance, Upgrade, Integration, Production Support and Re - engineering Projects.
• Extensively worked on Reporting and Designing module.
• Created web reports through report template in Web Application Designer.
• Well versed with Dimensional techniques - Star & Snow-flake Schemas.
• Efficient in Preparing SQL, PL/SQL, Stored Procedures, Functions.
• Good knowledge of System Development Life Cycle (SDLC) and excellent experience in Data Warehousing building Data Marts, generating OLAP reports.

TECHNICAL SKILLS

OLAP/DSS Tools: Tableau, BusinessObjectsBI4.0, SAP BW,XI3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x,SDK,CrystalReports XI,SIA,Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Performance Manager, Deployment Tool, Auditor, Crystal Report Explorer, Dashboard Manager, Scorecards, Tomcat 4.0.6,Oracle Warehouse Builder, Apache 1.3.x, Business Objects JAVA SDK, CMC, CMS, Crystal Reports XI

RDBMS: Oracle 11,10G/9.x/8.x/7.x/5.x, DB2/400,SQL Server 2000/2005, MS Access 2000

Languages: C, ASP, VB Script, HTML, JAVA, JSP, PL/SQL, SQL, Shell Scripting

GUI: Oracle Developer 2000,Visual Basic 5.0/6.0,Power Builder

Utility Tools: Erwin, TOAD, SQL*Navigator,Developer 2000, SQL*Loader

Operating Systems: MSDOS,Windows2003/XP/NT/2000/98/95Unix, Confidential - Unix, Sun Solaris

Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Tx

BI Tableau Consultant

Responsibilities:

• Development: Serves as a technical resource aligned with BI consultants to drive key projects to completion. Responsible for accessing disparate sources of data and integrating these sources of information into a common and interactive platform through Tableau. Design dashboard visualization tailored to customer needs and ensuring flawless integration within the reporting framework.
• Analysis: Perform analysis to build Tableau Extract data sources leveraging existing data marts and warehouses. Technical expert in the identification of solutions meeting complex business needs that facilitates automation and drives self-service.
• Deployment: Performance test and deploy dashboards onto Tableau Server to enable broad distribution to large audiences
• Support: Produce and distribute weekly, monthly and quarterly key performance management reporting.
• Quality: Attention to detail and appreciation for need to consistently generate high quality, highly sensitive output. Good business judgment and ability to maintain confidentiality of all data.
• Synchronize the FPCMS Tax and Shareholder reports.
• Improve the Core Deliverables process using Tableau Desktop.
• Schedule the reports and restructure the Tableau Server with appropriate site creations.
• Tableau Product Presentation and implementation of Tableau across Teams.

Environnent: Tableau10.2, Tableau 10.0.2, Oracle Sql Developer 4.1.2.20, Toad.

Confidential, Dallas, Tx

BI Analyst.

Responsibilities:

• As a Consultant I have been involved in designing of solutions & full lifecycle implementations Business Intelligence projects and to deliver the best solution.
• Act as a liaison between stake holders, clients, reporting and software development teams and conduct sessions, one-on-one meetings to collect requirements.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Single point of contact for both Tableau Admin and Dev.
• Adding trusted host to tableau server.
• Partition the Tableau server and creating various sites.
• Scheduling the reporting tasks on the Tableau server.
• Creating groups with respect to projects on the Tableau Server.
• Scheduling the mailing groups on the Tableau Server.
• Tableau Product Presentation and implementation of Tableau across Teams.
• Migration and Deployment of Tableau 8.3 to Tableau 9.2.6
• Single point of contact for Developing Tableau Reports across various environments Dev, UAT, Prod.
• Revamped the testing and product scenarios for successful implementing of various Projects.
• MS Visual Studio Source control explorer for Product work tracking.
• Support for various teams for setting up dbvis and implementing ODBC changes.
• Introspect and Retrospect Data according to their sources. iDeploy to manage release cycles and implementing DB code changes across all environments(CIT,SIT,TT,UAT,PreProd and Prod)

Environment: Tableau8.3/9, MSVisualStudio2013, Oracle11g, MSSqlServer2012, iDeploy, CompositeStudio7.0, Toad, DBvis.

Confidential, Dallas, Tx

Consulting Tableau Developer

Responsibilities:

• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Created visually compelling and actionable interactive Tableau reports and dashboards.
• Documentation, Maintenance and Scheduling. Also preparing status report for the project.
• To understand Business requirements, analysis and translate into Application and operational requirements.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Interacted with end users regularly in order to gather the requirements.
• Prepared Reports like financial reports, HR reports, standard and ad-hoc reports, and universes. Created hierarchies for drilldown paths.
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of profit in each deal.
• Revamping the Jasper Reports according to the current needs.
• Act as a liaison between stake holders, clients, reporting and software development teams and conduct sessions, one-on-one meetings to collect requirements.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges

Environment: Tableau 8.1/ 8.2, Jasper Reports, ReportBuilder2.0, MSSqlServer2008,, Toad, Oracle 11g.

Confidential, Dallas, TX

Consulting Tableau Developer/ Business Objects Developer

Responsibilities:

• As a Consultant I have been involved in designing of solutions & full lifecycle implementations Business Intelligence projects and to deliver the best solution.
• Act as a liaison between stake holders, clients, reporting and software development teams and conduct sessions, one-on-one meetings to collect requirements.
• Perform Gap Analysis and feasibility study for implementing Extract/reporting enhancements.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Work with subject Matter Experts to identify data relationships, report field mappings and translate them into technical requirements for development.
• Design mockups/wire frames for various reports by using MS Visio and Excel.
• Write and execute SQL scripts, Stored Procedures to develop reports and perform data/report validation.
• Design, develop and maintain reports using various tools like Webi, Yotta, and Xcelsius to generate and run reports monthly, quarterly and annually
• Created visually compelling and actionable interactive reports and dashboards.
• Gap analysis between standard system and proposed system.
• Developed Webi, Webi Rich Client and Xcelsius Dashboards.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Involved in building the interactive visual reporting Dashboards in Tableau, contains charts of key metrics for the executive leadership team.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Created alerts, filters and inserted Breaks in designing reports.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• MS EXCEL: Experience in validating and Analyzing data in worksheets using sorting, filtering, Vlookup, creating PIVOT tables, charts.
• Created Classes and Objects for management system based on the warehouse schema in Universe.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.

Environment: Tableau 8.0/ 8.1, Business Objects BI 4.0, XI R3.1,Xcelsius Dashboards,QAAWS, Yotta, Dial, Neoview, Sequest, HPDM, Oracle 11g, PLSQL, UNIX, BI 4.0 Launch Pad

Confidential, Houston, TX

Consulting Tableau Developer / Business Objects Developer

Responsibilities:

• Involved in Exploring, Designing, Building, QCing and Deployment the high level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics using Tableau 7.0 tool.
• Upgrading universes and reports to BI 4.0 from 3.1
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Adhere to good systems agile development methodology.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed universe using Information design tool (IDT)
• Develop and drive the implementation of Business Objects 4.0 best practices and standards.
• Develop new reports and enhancing existing reports in Business Objects Web Intelligence environment.
• Having Good experience in Tableau Business Intelligence Tool for dashboard development.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
• To understand Business requirements, analysis and translate into Application and operational requirements.
• Translates functional requirements of the reports build into technical specifications document.
• Involved in the complete process cycle; functional skills in analysing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Develop and execute test cases and test plans for functional performance of the reports.
• Translates functional requirements of the reports build into technical specifications document.
• Tuned Universes for Report level performance.
• Design deliverable content to precisely reflect the engagement contract and client needs and strive to improve deliverable quality through verification and validation of results.
• Designed aggregated tables on the most frequently queried data for Daily, Monthly & Yearly based reports.
• Writing PL/SQL validation queries for cross testing the resulting data from the reports.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Recommend and take lead on new ideas of implementation/developing of WebI reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
• Created Classes and Objects for management system based on the warehouse schema in Universe.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Migrated number of reports from Dev /Test to Production environments.
• Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
• Revised the Group Structure in both Development and Production Environments.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Developed Webi, Webi Rich Client and Xcelsius Dashboards
• Created alerts, filters and inserted Breaks in designing reports.
• Design processes to minimize data quality risks and proactively identify potential data issues.

Environment: Tableau 7.0, Business Objects BI 4.0, XI R3.1,QAAWS, Oracle 11g, PLSQL, SQL SERVER 2005,TOAD, UNIX, BI 4.0 Launch Pad,Xcelsius Dashboards

Confidential, Dallas, TX

Tableau Developer/ BO Developer

Responsibilities:

• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Hands on experience on Tableau reports development and visualization.
• Created visually compelling and actionable interactive reports and dashboards.
• Documentation, Maintenance and Scheduling. Also preparing status report for the project.
• To understand Business requirements, analysis and translate into Application and operational requirements.
• Presented to the higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Developed new reports in BI 4.0
• Interacted with end users regularly in order to gather the requirements.
• Designed Universes using different data sources.
• Created Objects and prepared Reports like financial reports, HR reports, standard and ad-hoc reports, and universes. Created hierarchies for drilldown paths.
• Designed crystal reports and Webi reports and published to corporate documents and viewed by Launch Pad.
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Designed Calendar, Metrics, analytics & Dashboard reports (IMT, Speedometers, Pareto Charts, Alerter, traffic lights etc,), and using Performance Manager.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Created Views, Stored Procedures and validated data for the Performance.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Used Breaks and Sections in Webi reports and used different graphical charts and bars.
• Writing technical specs for Business Objects Universe and reports Development
• Development, testing, Implementation and Production support for Business Objects Universe, Reports.
• Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
• Designed Business Objects Universes. Used Contexts and Alias to resolve the Loops
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Tableau 7.0, Business Objects BI 4.0, XI R3.1,QAAWS, Oracle 10g, SQL SERVER 2005,TOAD, UNIX, BI 4.0 Launch Pad.

Confidential, Atl, GA

Tableau/Business Objects Developer

Responsibilities:

• Interacted with Users to know their Business views while gathering the Tableau Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements in business/technical requirement documents.
• Developed Webi, Webi Rich Client and Xcelsius Dashboards
• Defined Rows, columns, filter conditions and variables in each query as per the guidelines.
• Created ODBC Drivers and SAP Net weaver connection in the Universe.
• Developed new reports in Tableau 7.0
• Involved in unit testing and user acceptance testing.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Installed Crystal Xcelsius 2008 and developed dashboards using various components.
• Created Tableau Datavisual Dashboards for Sales and Product level data based on Product Age & Usage.
• Created WSDLs using QaaWS (Query as Web Services) and implemented into Xcelsius dashboards.
• Created Pseudo dashboards one report having multiple hyperlinks to various reports using Open Document functionality from Dashboard to Webi Report.
• Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• Integrated Dashboards into External Portal Applications using Qaaws.
• Created Hyperlinks to Integrate Xcelsius Dashboards to Corporate portal.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose using Teradata SQL Assistant tool.
• Created users, groups, server groups and setup security architecture.
• Implemented Row Level, Object Level security for data restriction Confidential Universe level.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Created Complex reports using Web Intelligence in BO XI R3 environment.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Environment: Tableau 7.0,Business Objects BI 4.0, XI R3.1, Crystal Xcelsius2008 and QAAWS, Oracle 10g, SQL Server 2005, Teradata, Toad, AIXand Web logic 9.2.

Confidential, Atl, GA

Business Objects Developer

Responsibilities:

• Maintained Report Tracker system to open new report tickets and prioritize them accordingly.
• Worked as a production support and managed change and help desk cases using the Remedy.
• Maintained Users in Production Environment using CMC.
• Arranged Interactive Sessions for the end users and provided training for ad-hoc querying.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Created the reports (Master/Detail, Cross tab and Outline reports) in Crystal Report and writing the complex queries including sub queries.
• Worked extensively with the major functionalities of Business Objects like Alerter, Group By, Query, Prompt, Drill Filter, Indexes, Breaks, Sorts, Ranking, and Calculation using the Slice and Dice panel.
• Building Dashboards using Xcelsius 4.5 to depict Sales Analytics using Live Office as the Data Connection
• Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
• Used Breaks and Sections in Webi reports and used different graphical charts and bars.
• Scheduled Webi reports on daily basis and exported them in Excel/PDF format.
• Implemented SQL/PLSQL programs/Stored procedures/Views to test ad hoc reports
• Created Dashboard Templates with Visualization for different group’s usage for their Best Practices.
• Designed Visualizations for Operational and Financial groups.
• Created WSDLs using query as web services and implemented WSDLs into Xcelsius dashboards
• Created WSDLs using Query As a Web Service (Qaaws) from different Data sources.
• Integrated Dashboards into External Portal Applications using Qaaws.
• Deployed Qaaws from One server to other server.
• Created customized Web Intelligence reports as a source data for Live Office to Integrate Xcelsius on Corporate dashboards.
• Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• Created Hyperlinks on Dashboard to drill down for Detailed Analysis Reports.
• Designed Universes using different data sources.
• Created Classes and Objects for management system based on the warehouse schema in Universe.
• Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
• Created hierarchies for drilldown paths.

Environment: Tableau7.0,Business Objects, Crystal Reports, Xcelsius 4.5, Sybase, SQL Server 2005, Oracle 9i,PL/SQL, Unix, shell scripts and Perl Scripts.

Confidential

Associate Software Engineer

Responsibilities:

• Major role player in the enhancement, Development and testing activities.
• Involved in developing Test plan, Test Cases and Test Metrics for various projects.
• Reviewed test cases for requirements coverage, ambiguity, and completeness.
• Responsible for setting up test environment.
• Involved in installing the software components in the server.
• Developed suitable test cases and test scripts
• Developing of enhanced features and writing test cases.
• Check functionality of Cincom Tiger on different Application servers.
• Reporting the bugs that have been identified in the testing process