SUMMARY

• Over 7+ Years of experience in the areas of analysis, design and development of Business Intelligence solution using Tableau Desktop, Tableau Server and Business Objects reporting tools.
• Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8, Tableau 8.1 and Tableau 8.2
• Publish Tableau Dashboards in Tableau Server, Tableau public Premium.
• Good knowledge on Star Schema, Extended Star schema and Snowflake modeling.
• Partnered with Business stakeholders and executives with the goal of providing them with the ability to make decisions and gain insights through data visualization reports and operational reports.
• Experience in building prototypes for demonstration and illustration purposes for Business partners and senior leaders
• Developed dash boards with rich Graphic visualizations, Drill Down and Drop down menu options, Parameterized using Tableau.
• Involved inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in understanding and supporting the client with project planning, project definition, requirements definition, analysis, design, testing, system documentation and user training.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors, importing data from xls into Oracle Database.
• Extensive experience in Business Intelligence Reporting tools like Business Objects XIR2/R3/3.1/4.0 (Supervisor, Designer, Reporter), Web Intelligence, Info View, and BCA, BOXIR2 (CMC, CCM, Desk I, Web I, Performance Manager, Crystal Enterprise).
• Extensive experience in gathering requirements and documenting the same as per the industry best practices.
• Experience in deploying Business Objects products in various environments.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Snow-Flake Modeling and Star Schema Modeling.
• Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development and to manage risk analysis and mitigation plans, status reports, and client presentations.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Demonstrated ability to self-motivate and be flexible within a fast-paced environment

TECHNICAL SKILLS

BI Tools: Tableau, Business Objects, Microstrategy

ETL Tools: Data Stage, Microsoft SQL Server Integrated Services

Databases: Oracle 9i, SQL Server, DB2, MS Access, MS SQL Server 2005

Programming Languages: C, HTML, SQL, PL/SQL, XML, Python, C#

Data modeling: ERwin, ER Studio, MS Visio

Scripting Languages: SQL, T-SQL

OLAP Tools: SSAS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

Tableau Developer

Responsibilities:

• Responsible for gathering requirements, interactions with business stake holders and managing the delivery.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
• Used Sheet filters to produce multiple chart types in a single view.
• Extensively used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created visualizations for logistics calculations and departmental spend analysis.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: Tableau 8.2, BI Applications, SQl Server 2012, Oracle MDW,R12,BigQuery, MS Excel, Salesforce, Windows 2007

Confidential, San Diego CA

Tableau Developer

Responsibilities:

• Experience using Tableau tool to handle the various data feeds from the different data sources using Tableau Desktop tool.
• Creating customized and interactive dashboards using multiple data sources, data extraction and custom objects.
• Migrating some of the existing excel - based dashboards of Tableau.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Understanding of relational database structures and ability to create SQL views.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.

Environment: Tableau 8.2, SQL Developer, MicroStrategy (Desktop/ Server), MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Boise Idaho

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Experience in Marks,Publisher and Security.
• Working with Multiple data Connections.
• Used Snow flake and Star Schema Designs for data modeling.
• Experience with troubleshooting.
• Installation, maintenance and administration of Tableau Servers.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience withTableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Expertise in Tableau Analysis.
• Experience with creating Worksheets, Dashboarding and infographics Experience in BI interactive Dashboards and TableauPublisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Live, optimized connections to Teradata to leverage the investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environments: Tableau Desktop 8.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4

Confidential, San Antonio TX

SAP Business Objects Developer

Responsibilities:

• Analyzed the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports
• Designed and Documents Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Created Financial Analysis Universe and worked with the report development team for the first release of Business Objects to the user community.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Implemented the Object-level, Row-level and Data-level security on the developed Financial Analysis Universe.
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Creating, maintaining and modifying the business critical reports using the Webi, Deski and Webi rich client
• Created Webi reports with multiple data providers and synchronized the data using Merge Dimensions option in BO.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and functions like prompt and aggregate Awareness
• Created Metrics, Goal and Analytics to create Dashboards for better decision using Crystal Xcelsius.
• Designed Dashboards by calling the Child Dashboard from Parent Dash Board with Open Document Functionality in accordance to the user requirement.
• Experience in using Xcelsius designer for creating customized Web Intelligencereports as per the requirements.
• Involved in creating variable width charts using Xcelsius.

Environment: Business Objects XIR3.1, Web Intelligence, Infoview, Desktop intelligence, Designer, Xcelsius, Oracle 10g, Windows 2003 Server, IIS, Informatica 8.1.

Confidential

MS SQL Developer

Responsibilities:

• Carried out a Developer's role on MS SQL Server 2005, MS Access Databases (using DTS, Stored procedures and Views.
• Involved in developing the SQL code for the application.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Identified and worked with parameters for parameterized reports in SSRS.
• Created ad hoc T-SQL Queries.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.

Environment: Erwin, ER/ Studio, Data Stage, SSIS, SSRS, Oracle, SQL Plus/ PLSQL, Toad,SQL Developer, Teradata SQL Assistant, TOAD, UNIX, SQL, MS Office (Word, PowerPoint

Confidential

SQL Developer

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Recovered the backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Coordinating with peer groups for Network, Infrastructure and DatacenterOperations.
• Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML.