SUMMARY:

• 11 years of experience in various capacities as a Business Intelligence Consultant, specialized in Business Objects, SQL and Tableau. 8 years of experience in Data warehousing and Business Intelligence technologies along with around 5 years of data visualization using Tableau. Skilled in analyzing current business processes, determining System requirement , reporting needs, and configuring applications to match those needs while incorporating best business practices.
• Worked with business clients, creating SAP Webintelligence Report and Crystal Reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations. Expertise in Business Objects tools such as Scheduler, Designer, Data Integrator, and BO Universe design ( Confidential ).
• Demonstrated experience in bridging business requirement and technical development.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2008/2012, SQL Server Analysis Services of 2008/2012 and SQL Server Integration Services.
• Demonstrate Tableau solutions expertise, problem solving orientation, teamwork, and time management.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Strong Analytics/Data warehouse experience using SAP HANA, SAP Business Objects Data Services/ Data Integrator
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experienced with vLookups and data sorting and filtering in MS Excel.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing testing, migrating, administrating, security management and production support in BI.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.
• Universe (Meta data) development experience on Oracle 9i/10g/11g/12c and MS SQL Server 2005/2008/2012/2014.
• ETL, SQL, multiple data source analysis and Tableau reporting/dashboard skills. I contribute my skills as a Team Player towards the success of project and Performance Management

TECHNICAL EXPERTISE:

• SAP Business Objects 4.2
• Dashboard Design
• MS Excel Expert
• BODS
• Confidential - Upgrade/Migration
• MS SQL Server SSIS/SSRS
• Webintelligence
• Crystal Reports
• Oracle 10g/11g/12C
• Universe Design
• Tableau Desktop/Server
• DB2, Hadoop, Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Visualization Consultant - BOBJ/SQL/Tableau

Responsibilities:

• Develop solutions in accordance to client specifications. Created Report templates, summary reports, master/details reports, parameterized reports and cross-tab reports.
• Interact With business users and Managers in gathering business requirement for reports and Dashboards. Developed Tableau workbooks from multiple data sources using Data Blending.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Designed and developed interactive dashboards using Web Intelligence Charts and Dashboard 4.1.
• Developed various Charts, Graphs, Scorecard and drill down reports.
• Work with BI Strategy and Architecture team to understand the design and model and in corporate the design into the Business Objects Universe
• Scheduled the weekly, monthly, quarterly reports using BI launch Pad. Train, direct and mentor technical and process teams.
• Develop automated reports and dashboards using Tableau, Power BI, SSRS, Excel, PowerPivot and other reporting tools. Define or assist with best practices during implementation and integration of Tableau Platform
• A good understanding of the concepts and best practices of data warehouse ETL design
• Have designed and developed ETL work packages on data warehouse project.

Environment: Tableau 10.3.1, SAP Business Objects 4.1/4.2 Web Intelligence/ Launch pad, Information Design tool, Universe Designer, SAP Lumira, SAP BODS, SAP Hana, Crystal Reports, Design Studio 1.6, SAP Dashboard 4.1, SQL Server, Oracle, and Netezza

Confidential, Houston, TX

Crystal Reports/ Tableau Developer / SQL

Responsibilities:

• Facilitated daily internal team meetings and frequent client status meetings. Conduct research and analysis to create innovative solutions.
• Locating and acquiring data from existing data locations, external sources, and new data sources as needed to support Tableau reporting. Design and develop Tableau visualization solutions.
• Designing data model from scratch to aid team in data collection to be used for Tableau visuals.
• Conducted presentations to other area of business as a meta role to show value of Tableau as a BI tool
• Design and implement complex ad-hoc queries and views.
• Analyze Business Requirements and implement Code Modifications. Followed Implementation Methodology and finalize and deliver reports based on scheduled deliverable dates.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs. Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Design, develop, build, modify and maintain reports using SQL.

Environment: Tableau Version 8.3.5, Crystal Reports, BI Launch Pad, Web Intelligence, Design Studio 1.6, Dashboard 4.1, BW 7.4, SAP Business Objects 4.1/4.2 Web Intelligence/ Launch pad, Teradata 14, Oracle 11g, 12c, Oracle SQL developer 4.2, SQL Server, SAP BODS, IBM, Netezza, Teradata, Hadoop, and Oracle

Confidential

Business Objects Analytics Developer/Business Analyst/SQL

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Conducted meetings with Business Users to define the System Requirement Specifications, technical and functional requirements.
• Worked on SAP BO 4.1, designed, developed and managed Universes in Information designing tool ( Confidential ) which include creating data foundation, business layer based on adhoc requirement catering several business units.
• Created new Web intelligence reports in BI Launch pad 4.1 for Business users, Used BEx Queries in Designer Business Intelligence Consumer Service (BICS)/ and Webi to develop reports.
• Created Universes from multiple sources using Information Design Tool.
• Requirement gathering sessions with business, Interviews with supply chain managers and HR managers from to identify KPI’S. Developed various Charts, Graphs, Scorecard and drill down reports
• Created functional documentation, technical documentation and Business signoff documentation.
• Commercial evaluation report development in BI 4.1 Webi using BEx queries.
• Preparation of wireframes and behavioral flow chart with visualization team.
• Analyzing and implementing enterprise wide Business Objects system implementation including installation, troubleshooting and architect designing. design, development, deployment, Maintenance, Production Support of complex universes and updating of existing universes using Universe Designer. Scheduling and bursting the reports using Central Management Server
• Develop automated reports and dashboards using Tableau, Power BI, SSRS, Excel, PowerPivot and other reporting tools follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively

Environment: SAP BI/BO Enterprise I 4.1 SP2, BI Launch Pad, Web Intelligence, Design Studio 1.3, SAP Dashboard 4.1, BW 7.4, SAP Business Objects 4.1/4.0/3.1/Web Intelligence/ Information Design tool, Universe Designer, Explorer, SAP Lumira, Crystal, Xcelsius 4.5/2008, Broadcast Agent, Auditor, QAAWS, BI 7.0, 7.3, BEX Query Analyzer, SAP BODS, Tableau, SQL Server, SharePoint. SAP BODS SAP, IBM, Netezza, and Oracle

Confidential, NY

BI Consultant- Crystal Enterprise and Tableau - SQL

Responsibilities:

• Worked in preparing the technical design documents as required for the project.
• Provided guidance to the business users for doing their reports against the Adhoc Universe.
• Being part of Implementation team for BO 4.1 and SAP HANA, have worked extensively in testing the existing features as well as new features and implementing the same.
• Help Client IT Department to Build Xcelsius Dashboard and use of web Intelligence for Adhoc Reporting.
• SAP Business One integrated with Crystal Reports tool for Invoice, Inventory, Commission and Quotes
• Write queries to Answer immediate business questions
• Involved in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Created dashboards for analyzing POS data using Tableau 8.0.
• Develop automated reports and dashboards using Tableau, Power BI, SSRS, Excel, PowerPivot and other reporting tools

Environment: SAP BOBJ Enterprise XI 4.1 SP1, Oracle 10g,11g SQL, PL/SQL, Tableau Version 8.1.3, SQL Server, SAP BODS, IBM, Netezza, Teradata, Hadoop, and Oracle

Confidential, NY

Senior Business Objects Developer/Admin

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements for universe, report and dashboards. Prepared Technical Specifications documents and Training guides.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Develop and migrate the Environment (Reports & Universes) from BOBJ XI R3.1- Business Objects XI 4.0 Web Intelligence Using Upgrade management tool.
• Troubleshoot the Issues and Problems encountered using used cases in new while migrating the reports & universes from BOBJ XI 3.1 to BI/BOBJ XI R4.0
• Used BEx Queries in Designer Business Intelligence Consumer Service (BICS)/ and Webi to develop reports.
• Created new Web intelligence reports in BI Launch pad 4.0 for Business users
• Created Universes from multiple sources using Information Design Tool, also converted existing UNVs to UNX files.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Customized user reports using canned reports depending on the user requirements.
• Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in the universe. Setup user profiles, Categories and Channels using Confidential .
• Designed complex reports involving multiple sub reports or reports based on MSSQL 2008 R2 SQL commands and Stored Procedures.
• Created parameters, running totals and summaries for calculated fields within Crystal Reports.
• Worked with the IT team to bring in the data required into Business Objects Universe.
• Constantly tested SQL for joins and contexts for new object creation. Using Rapid SQL conducted functional testing in the SQL of existing objects.

Environment: SAP BOBJ Enterprise XI 3.1 SP3/ SAP BO Business Intelligence 4.0, BI Launch Pad (Info View), Web Intelligence, Crystal Reports 2008, Xcelsius 2008 SP3, Qaaws, Live Office, Import Wizard, Oracle 10g, SQL, PL/SQL.

Confidential, Atlanta, GA

Senior Business Objects Consultant

Responsibilities:

• Created user groups and managed access privileges using Business Objects Confidential .
• Responsible for Business Objects repository and Web intelligence maintenance and tuning.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Developed various Charts, Graphs and drill down reports
• Extensively used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc.
• Worked on User/System report documentation, user training and testing developed reports for final deployment.
• Worked on creating groups, conditions, filters ranking in reports
• Scheduled the weekly, monthly, quarterly reports using business objects
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Made use of flash variables to link Master detail dashboard.
• Created users and groups in Confidential, created folders and granted rights for the different user groups.
• Develop automated reports and dashboards using SSRS, Excel, PowerPivot and other reporting tools.

Environment: SAP Business Objects Business Intelligence 4.0, BI Launch Pad, SAP BODS, Web Intelligence, Crystal Reports Oracle 10g, SQL, PL/SQL. Microsoft Office, SQL Server, Oracle 10g