SUMMARY

• 8+years of adept experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• ExtensiveBusiness Intelligenceand Data warehousing experience using Tableau, QlikView, SSRS, OBIEE 10g/Siebel Analytics 7.x,, Informatica7.x/6.x
• Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Experience in designing Tableau Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Expertise in Tableau BI reporting tools &Tableau Dashboards Developments & Server Administration.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.
• Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and Production support.

TECHNICAL SKILLS

• Tableau 8.x, SSRS, OBIEE 10.1.3.4.1, Siebel Analytics7.x (Admin, Web, Answers, Dashboards), Scheduler, BI Publisher,
• Oracle 8.x/9i/10g/11g, MS - SQL, SQL Server.
• SQL*PLUS 8.x/9.x, PL/SQL
• Windows 95/98/NT/2000/XP, Vista and Windows 7, Sun Solaris, HP Unix, MS Access, MS Outlook

PROFESSIONAL EXPERIENCE

Sr. Tableau Developer

Confidential, Louisville, CO

Responsibilities:

• Worked closely with sales, marketing, and production business units to perform business and system analysis.
• Generated ad - hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Combined multiple data sources by joining tables and using Data Blending.
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards with the security using filters for the clients to measure cost saving.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Created visualizations in Tableau using Excel data extract source, wrote Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, and handled the performance issues effectively.identify critical KPIs and facilitate strategic planning in the organization using Tableau
• Performance tuning by analyzing and comparing the turnaround times between SQL and Tableau

Environment:Tableau Desktop 8.2 Tableau server / Administrator, SQL developer, OBIEE

Confidential, Beverly,MA

Tableau /OBIEE developer

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• 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.
• Created highly interactive visual Reports using Tableau.
• Designed business intelligence dashboards using Tableau (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Gathered, documented requirement from the users and developed Complex Graphical User Interactive reports using various Tableau Objects.
• Strong Skills in Data Modeling & Loading data from multiple data sources..
• Actively involved in deployment and post release support.
• Validated technical design created by developers against functional specifications.
• Created interactive dashboards using OBIEE 10g, created ibots.
• Lead OBIEE and QA teams to design test plan for user Acceptance Testing (UAT)
• Provided formal project presentations to the client, executive management and line staff as required
• Trained the users on how to use the Dashboards and Interactive Reports.

Environment:Dash boarding/Analytics Tableau 8.0, MS SharePoint

Confidential, Milwaukee, WI

BI Consultant

Responsibilities:

• Involved inrequirements gathering of the various work streams by meeting with the business userand base lining the details.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
• Created Data extracts for better performance and accessing data offline.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Created Technical Requirement based on BRD functional document for (Order Management, Order Fulfillment and Inventory Etc)
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Modified many logical Metrics/Columns by duplicating as per the requirements.
• Involved in implementing the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog
• Implemented external tables for Authorization and LDAP for Authentication.
• Created Complex Reports by using Pivot, Table, Chart, Column selector, View Selector and Union view for POS and Performance Reports/Dashboards.
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file.
• Involved in HR and Financial analytics implementation.

Environment:OBIEE 10.1.3.4.1, Informatica 8.6.1, Siebel CRM, SQL Developer, Linux and Windows Server 2003, Teradata, Oracle, SQL Server.

Confidential, Cupertino,CA

BI/ETL Consultant

Responsibilities:

• Gathered user requirements from business representatives and convert them into functional and technical specifications
• Handled rapidly growing dimensions while maintaining the history of the data.
• Migrated packages from development server to production server using package configuration.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub - Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Implemented AD HOC reporting with the report builder for the end users.
• Generated reports using Expressions and Functions using SSRS.
• Analyzed the existing applications and identified redundant data sourced from the same data sources.
• Developed Proof of Concepts of consolidated applications and demonstrate to the Business users.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems
• Designed and documented the validation rules, error handling and test strategy of the mapping
• Tuned the sessions for better performance by implementing the partitions
• ImplementedDimensional modelingin the database and created appropriateviewsalong with DBA to acquire the Metadata for the given requirement.

Environment: Tableau 6.x, OBIEE 10.1.3.4.1, Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler, BI Publisher, QlikView, SAP BO, Oracle 8.x/9i/10g/11g, MS-SQL, Teradata, Oracle, SQL Server. • SQL*PLUS 8.x/9.x, PL/SQL • Windows 95/98/NT/2000/XP, Vista and Windows 7,, MS Outlook