PROFESSIONAL SUMMARY:

• Over 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Proficient 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, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Data Visualization and Analytical professional using Tableau to:
• Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Define specification, design and build of Tableau Desktop reports and dashboards
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and Web Intelligence.
• Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Experienced in tuning long running SQL queries for better performance.
• Experience Working with MS Office Suite (Word, Excel, Access and PowerPoint skills)
• Excellent communication skills, strong team-building and conflict management skills.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

Languages: C, SQL, PL/SQL, Java, XML, UNIX shell Scripting.

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008, MS Access 2000Visualization Tools Tableau 8.1/8.0/7.0/6.0

OLAP Tools: Business Objects 6.X, Designer, Supervisor, DesktopIntelligence, Web-Intelligence, Info View, CMC, CCM, Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

Other Tools: Toad, Putty, Erwin, MS VisioRational Tools Clear Case Explorer

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MN

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements,managing the delivery and creating mock up screens for reviews.
• Worked with various data-sources i.e. Databases and File Systems and was successful in doing a data Mashup.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Creating parameter information links, joins, filters in information designer for fetching data in to Tableau as per the business needs.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Designed and developedvarious analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Used filters to display information from various time ranges such as YTD, TTM, and Fiscal Year-to-date.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Unit testing and participation in UAT and production cut over plans.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Desktop 8.2 & 7.1, Tableau Server,Oracle 11g, MS Office Suite, Oracle SQL Server R2, MS Excel, Clearquest, Clearcase,SQL,PL/SQL,Teradata,MS Project.

Confidential, KY

Tableau Developer

Responsibilities:

• Worked with Demand Planners to gather reporting requirements and provided design recommendations.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked on drill through reports by creating HTML references.
• Recreated existing dashboards (Web FOCUS, Xcelsius, Crystal Reports) using Tableau with added visual and interactive functionality such as drill-downs, actions, and links.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Created report schedules, data connections, projects, groups in Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps,Gantt charts using show me functionality.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Created extensive joins for data blending from several different data sources
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Developed customized calculations when required.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Worked towards the goals of quality, time and budget.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.

Environment: Tableau Desktop, Tableau Server, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Greenville, NC

Business Object Developer

Responsibilities:

• Worked with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
• 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.
• Created Reports based on subtotal of Currency and General Ledger category.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Deployment of Crystal Reports via various methodologies Central Management Console(CMC), Publishing Wizard, Infoview, Import Wizard.
• Experience on Developing Crystal Reports.
• Developed universe user documentation guide for the end users reference.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Involved in joining the tables by creating aliases to resolve the loop.
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Business Objects 6.5, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2,Import Wizard, Report Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer,oracle 10g, Info View, SQL Server2008,TSQL, SQL

Confidential, MN

Business Object Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Used Cascading prompts for geographical hierarchies.
• Used Teradata Utilities to increase the performance on the reports.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence Rich Client.
• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Troubleshooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, Teradata 13.10, SAP BW, TOAD, Windows 2003 Server.

Confidential

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Installed and managed MS SQL Server 2005.
• Extracted data from xml and flat files using SSIS
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS andCrystal Reports.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment:MS SQL Server 2005, Erwin,MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services,XML