SUMMARY:

• 9+ Years of Business Intelligence Experience in Analysis, Design, Development, Quality Assurance and Implementation and Tableau Reporting.
• Involved in the installation and configuration of Tableau server. Have also configured distributed installation for Improved Performance
• Extensive experience in tableau dashboard design and development, troubleshooting, technical support and monitoring of system usage.
• In - depth Experience on Tableau Desktop, Tableau Viewer and Tableau Server.
• Extensive experience in data analysis, profiling, data validation and data visualization.
• Experience in writing Business requirements and Functional requirements document.
• Extensive experience in design and development of reports,worksheets and dashboards.
• Experience on data modeling in relational and dimensional data model.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Ability to deliver strategic and tactical solutions for critical reporting requirements.
• Extensive experience in designing and building Webi reports using Business Objects.
• Expertise in using Business Objects reporting functionalities such asDrilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Experience in developing Dashboards using Xcelsius.
• Strong experience of designing, building, testing, documenting the Universe.
• Strong SQL Query experience using various RDBMS like Oracle, Teradata, Microsoft SQL Server and DB2 databases.
• Expert in Crystal Reports Enterprise, Crystal Reports 2008/2011, WEBI Reports, Universe and IDT development.
• Experienced in tuning Long running SQL queries for better performance.
• Excellent problem solver and solution provider; ability to work in a fast-paced, complex and time sensitive environment.
• Excellent written and verbal communication skills.
• Excellent experience in Banking and Finance domain.

TECHNICAL SKILLS:

REPORTING TOOLS: Tableau Desktopv8/v9,Tableau Server v8/v9, Business Objects XI4.0, Crystal Reports 2011,Xcelsius 4.5

DATABASES: Oracle 11g/10g, Teradata, Microsoft SQLServer 2005/2008, DB2.

LANGUAGES: SQL, PL/SQL, C, HTML.

OPERATING SYSTEMS: UNIX, Linux, Windows NT/2000/XP/7 and MS DOS.

SQL TOOLS: Teradata SQL Assistant, SQL Developer, Rapid SQL, TOAD, SQL Server MANAGEMENT STUDIO

OTHER TOOLs: Microsoft Office, Microsoft TFS.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

SR. TABLEAU DEVELOPER

Responsibilities:

• Working as a Tableau Desktop Consultant focusing on developing high-end visualizations driven by data from SQL Server.
• Convert business requirements into story-telling viz by developing dashboards in Tableau Desktop and publish them to Tableau Server allowing end-users to control data and filter down further as desired.
• Attended requirement gathering sessions with end-users.
• Created functional and technical specification document and test cases documents.
• Created customized Calculations, Filters (Local, Global), Parameters, Sets and Combinedsets for various analytical dashboards.
• Worked on creating aggregates, Annotate,hierarchies, sorting and grouping.
• Proficient in creating Actions in Worksheet level and Dashboard level.
• Experience in building Maps manually by using Custom Geo-coding.
• Created customized reports using various chart types like text tables, tree maps, heat maps, line charts, combination charts,bar charts, pie charts, bubble chartsin tableau using excel and other data sources.
• Worked on Drill down, Drill up analysis, custom hierarchies using tableau desktop.
• Created Ad hoc worksheets from the given data.
• Generated a consolidated report on weekly and monthly basis.
• Createdguided navigation links within InteractiveDashboards.
• Extensively used analytical features in Tableau like Statistical functions, reference lines, trend lines,forecasting in many tableau worksheets.
• Publish the developed worksheets and dashboards to Tableau Server for end users to view.
• Scheduled frequency and time to refresh data when source data is published.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be tested in the application.
• Exercised best practices for Tableau report development.
• Knowledge on tableau installation and configuration.
• Conducted Training sessions to the end users.

Environment: Tableau Desktop v9, Tableau Server v9, Windows Server Standard R2, SQL Server, Crystal 2011, CMS, CMC, MS Excel, UNIX.

Confidential, CHICAGO, IL

SR. BO/CRYSTAL/TABLEAU DEVELOPER

Responsibilities:

• Performed data analysis on large data volumes to support business decision making.
• Working with business users to create business requirements and translate them into functional specifications.
• Understanding of business and technical metadata, data lineage and data models.
• Worked with data modelers to identify required fields, data types and default values.
• Worked with different source systems to identify the required data points for data mapping.
• Worked on data validation to make sure data loads were accurate as per mapping rules.
• Identified discrepancies in source data and found alternative mapping for attributes.
• Created Webi reports, Crystal reports and Charles river reports according to user requirements.
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Involved in the designing and Building of Universes, Classes and objects.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Customized Universe Level Prompts as per Functional Requirements.
• Check the integrity of the Universes, and export the universes to Repository for making available to users.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail, Formulae, Optional Prompts, Functions, Alerters etc.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.
• Used Web intelligence to create, edit and set different options for the corporate documents.
• Created Cross tab crystal reports using various cross tab complex and nested formulas.
• Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
• Created Crystal reports using add command, stored procedures and universes.
• Migrated reports to SIT, UAT and PROD using promotion management.
• Assisted Business Users in building and understanding reports during UAT and postproduction support.
• Worked with quality assurance team in BRD walk through sessions and in testing phase.
• Created Tableau worksheets and dashboards for Charles River trading application reports.
• Created Advanced connections, join new tables, create & manage live and extract connections in Tableau.
• Created Data blending, Relationships, Filters, Quick filters, Context filters, Parameters, Hierarchies, Sorting, Groupings.
• Worked extensively with Advance analysis Actions, Calculations, Background images, Maps.
• Implemented Individual Axis, Axis Blending and Dual axis in Tableau.
• Extensively used Marks section and Page shelf.
• Proficient in creating Data bins and histograms.
• Meticulously formatted reports and dashboards as per user’s inputs.
• Created, sorted and managed groups according to report requirement.
• Supported Testing team during SIT and UAT and created unit test case documents.
• Involved in publishing various kinds of interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau servers.
• Helped business users with Post production activities and issues.
• Given KT to new team members.
• Worked on various emergency production fixes.

Environment: Tableau Desktop v8, Tableau Server v8, Business Objects 4.0/XIR2, Crystal Reports 2011, ORACLE 11g,Rapid SQL, Microsoft Office, Charles River Application.

Confidential, DEERFIELD, IL

BO/CRYSTAL DEVELOPER

Responsibilities:

• Involved in gathering the requirements from Business Users.
• Maintained metadata repositories and data dictionaries.
• Worked with data governance team to maintain consistency with attributes and data definitions.
• Analyzed these requirements and prepared Technical Specifications Document for crystal reports.
• Fetched new data sources that are required for reporting.
• Involved in data modeling discussions with system analysts and data modelers.
• Worked on data lineage initiative to track the attributes from system of record till the reporting layer.
• Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
• Used On-demand, normal sub reports concepts in the Crystal reports.
• Formatted the Various Crystal reports according to the specifications by the end user.
• Created Unit Testing Documents, FD and TD’s.
• Validated warehouse data to ensure the consistency between multiple monthly loads.
• Created Webi and Crystal reports and dashboards according to user requirements.
• Involved in Beta testing of Data Warehouse project.
• Validated the data such that it is pulling the intended data from SAP BW to reports and created a Unit test document for those reports.
• Modified already existing Crystal reports according to customer requirements.
• Created groups according to the report requirement, sorted the data in groups, managed the groups, giving different header names. Used specified order for the groups.
• Modified the Crystal reports to increase the performance of reports.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins.
• External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Developed Universes, Webi, Webi Rich Client reports.
• Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checking the integrity.
• In Universes, created classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented the Object-Level Security and Row-level security in Universe.
• Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created users, groups, server groups and setup security architecture.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail, Formulas, Optional Prompts, Functions, Alerters etc.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

Environment: Business Objects XI3.1/XIR2, Web Intelligence, Universe Designer, Business View Manager, Desktop Intelligence, Crystal Reports 2008, Tableau v7,SQL Server 2008, ORACLE 10g

Confidential

BO/CRYSTAL DEVELOPER

Responsibilities:

• Connecting to the different databases like SQL Server / Oracle / Sybase etc.
• Creating different kinds of reports like Standard reports, mailing label reports, Cross Tab reports.
• Creating complex formulas.
• Creating sub-reports.
• Creating different kinds of charts.
• Creating dynamic cascading parameter.
• Creating static / dynamic- parameters.
• Publishing the developed report to the repository.
• Formatting the reports with conditional formatting or non-conditional formatting.
• Writing commands at the crystal reports level.
• Trouble shooting of various issues faced by customers.
• Creating different complex report as per the customer requirements.
• Inserting summaries’ and running totals using default crystal option.
• Creating manual running total formulas.
• Applying Row Level / Column Level security through crystal reports.
• Exporting the reports to various formats like PDF, Excel and Data Definition etc.
• Creating data connection to the database.
• Creating a dynamic data connection to the database.
• Creating a data foundation.
• Creating a business element.
• Creating a business view.
• Creating a list of values for the report (Dynamic parameter).
• Setting up of user right business views.
• Applying row level security and column level security using BVM.
• Creating filters at data foundation and business element level.

Environment: Business Objects XI R2, Broadcast Agent, Infoview, Crystal Reports XI, Xcelsius 4.5, Performance Management, Dashboards, Toad, SQL, PL/SQL, Oracle 8i, Windows 2000, MS SQL Server 2000, MS Office.

Confidential

TECHNICAL ASSOCIATE

Responsibilities:

• Worked on data profiling to see whether data met the expectations of business requirements.
• Worked on documenting functional specifications and data mapping rules.
• Worked on data validation in different environments like UAT and PROD.
• Worked on multiple data feeds from different source systems.
• Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
• Used On-demand, normal sub reports concepts in the Crystal reports.
• Formatted the Various Crystal reports so that the end product will look as specified by the end user. Used Forms.
• Very good in formatting crystal reports.
• Used fetching data from command objects and various databases.
• Modified existingCrystal reports according to customer requirements.
• Modified the Crystal reports to increase the performance of reports.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Applied row level and object level securities on different groups and users.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Use the slice and dice feature, set variables, and set alerts and group values in a report.
• Built queries to retrieve data through a universe and set up query conditions.
• Created Cross-tab and Master Detail reports in Business Objects.
• Creating complex reports using features like slice and dice, Drill capabilities, Functions and Cross Tab tables with multiple breaks.
• Used alerts to highlight critical data based on business conditions.
• Created various MTD, YTD and daily reports.
• Extensively used Calculations, Sorting, Rank, Drill, Slice and Dice.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects.

Environment: Crystal Reports, Business Objects Enterprise, SQL Server 2000/2005, Oracle 9i/10g, TOAD, MS Access, MS Office Suite, Windows XP / Windows 2003 Server.