SUMMARY

• 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms
• Having 4 years of versatile working experience on Business Intelligence/Business Analytics software also experience in Infrastructure services.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Deployed the reports and Scheduled Reports for the use of end users.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Ability to architect a custom solution. Design, development, distribution of custom client-server and WEB solutions. Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.
• Experience in modelling, architecture, designing, coding, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Able to handle different projects concurrently and Lead experience.
• Technical support to the team, reviews of deliverables, communication with offshore team, track all the deliverables and to impart on job to the team.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with project managers, business Analyst, Architects, DBAs and Developers.
• Experience on data warehousing concepts, ETL tool Informatica.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, MS BI, Tableau Server

ETL Tools: Microsoft SQL Server Integration Services, BO Universe Designer, BO Web intelligence, Crystal reports XI/2008

Databases: Microsoft SQL Server(2005/2012), IBM BD2, MySQL

Document management: Visual Source Safe 6.0, Share point

Programming Languages: C, C++, SQL, PL/SQL, C#, ABAP, HTML, JavaScript

Data Modelling: MS VISIO

Applications: Eclipse, NetBeans, Oracle SQL Developer

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008

Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE

Confidential, CO

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development and analysis projects withinTableauDesktop.
• Developed Tableau Dashboard standard template based on user requirements.
• Developed Tableau Data Visualizations using Cross Map, Scatter Plots, Geographic Map, worked on different chart types based on the requirements including Pie Charts, Bar Charts, Combination Charts, Page Trails, and Density Chart.
• Created Tableauscorecards, dashboards, Heat maps using Show me functionality.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Upgraded Tableau 7.0 environment to Tableau 8.3
• Developed custom SQL queries to minimize the data to improve the performance in Tableau.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets to create detail level summary report
• Created rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Developed Story telling dashboards in Tableau Desktop and published them on to Tableau Server.
• Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.
• Created context filters and used performance actions while handling huge volume of data.
• Developed Tableau dashboards for sales & profit analysis with forecast and lines.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Testing and debugging the dashboard for quality assurance.
• Served as a primary point of contact for Production Support issue resolution.

Environment: Tableau 8.3, Tableau Server, SQL, PL/SQL, MS Office Suite, Oracle SQL Server Weblogic 10, SQL, Oracle10g, SQL Server 2008, SVN, ANT BUILD, GITHUB, Tableau Desktop 8.2

Confidential, Denver, CO

Tableau Developer/Data Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Given /demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with
• Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, UNIX, Toad, MS Office, Visual Studio 2010.

Confidential, Minneapolis, MN

System Analyst

Responsibilities:

• Documented of Product Definition Document (PDD), Business Requirements Documentation, System Requirement Specification (SRS) and Functional System Documentation (FSD).
• Gathered requirements and prepared business requirement documents (BRD)
• Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution
• Developed and maintained all operational and technical flows using Visio and Power point.
• Created use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models using MS Office Suite.
• Defined Use Cases from requirements and helped convert them into integration software specifications.
• Aided in workflow analysis and process design.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective. Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Designed business intelligence dashboard using Micro Strategy’s Web development tools, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Analyze business requirements from Black Box Testing perspective, business process and system architecture/design
• Maintained documents for change request and implemented procedures for testing changes.

Environment: Oracle, TOAD, SQL, Share Point, TFS, Informatica, Micro Strategy, Autosys, UNIX, SQL Server, Power Designer, MS VISIO, Mercury Test Director, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential

BO Developer/Data warehouse Developer

Responsibilities:

• Understand the technical requirements, developed simple reports to satisfy the user requirements
• Worked on DeskI and WebI reports in BO 6.5
• Worked on Universe Designer and designed simple Universe by defining Joins, resolving loops and cardinalities
• Resolved Loops in Universe by creating Aliases, Contexts.
• Export the universe into the repository. Initiated migrating universe and reports between environments.
• Created several Classes, Dimension Objects, Measure objects and Conditions.
• Created Web I reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Features such as breaks, alerter and hide blocks are used in developing reports.
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Developed universes and DeskI reports from the Oracle 9i database.
• Written queries to retrieve data from Oracle database for multi-dimensional analysis using slice & Dice and Drill up/down functionality.
• Generated various standard reports and queries based on the existing classes/objects.
• Responsible for Creating Complex and Multi-Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created numerous Alerts that are executed based upon certain conditions.

Environment: Business Objects 6.5.1, Desktop Intelligence, Web Intelligence, Crystal reports 9, Oracle 9i, SQL TOAD, Windows NT/2003

Confidential

SQL Server Developer/ SSIS/SSRS

Responsibilities:

• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, Writing new stored procedures and modifying existing ones and tune them such that they perform well
• Involved in designing various reports to flat files generated by the database script.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Actively involved Normalization & De-normalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely with Application Developers and Business Analysts to produce all required documentation
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partition views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.
• Created Reports by using Reporting tool SQL Server Reporting Services (SSRS).
• Erwin tool.
• Design and create SQL Database, tables, indexes

Environment: MS SQL Server 2005, Windows 2003 Server, Transact-SQL, SSIS, SSRS, Erwin Tool