SUMMARY:

• Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 4years of extensive Tableau Experience in Tableau 6.x/7.x/8.x /9.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and SQL, PL SQL and UNIX shell scripting.
• Worked a great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Experience in configuring reports from different data sources using data blending
• Development in SQL server 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Proficient in data migration from sources like MS Access, SQL server, Text files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services(SSIS); and Data collation, data cleansing, Entity Relationship Design.
• Expert in developing code and testing based on defects in the logs.
• Perform system and integration testing of large data Ware house application developed using SQL and oracle.
• In addition to the ongoing involvement in Data Ware House Development life cycle was the designer, developer and architect of several Data ware House, Data marts and related back - end applications.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages
• Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations.(Automate the SSIS Packages and Import, Export).
• Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Developed scripts in PLSQL and Python to ingest API data from internal web servers. implementation expert, BI Project Concept Scoping, BI Semantic layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop v6.x/v7.x/v8.x/v9.x, Tableau Server v6.x/v7.x/v8.x, Tableau Online v9.x, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligences, SSRS

Databases: Teradata, MySQL, MS SQL Server, Hadoop, ORACLE, IBM DB2, MS Access, Amazon Redshift

ETL Tools: Informatic, SSIS,SSAS,Cognos BI

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, JIRA

Programming Languages: SQL, PL/SQL, HTML, ASP.net,CDocument Management: Documentum, Share point, Ultra Edit

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Productivity Tools: Ms Word, MS Excel, MS PowerPoint, MS Visio, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

Data Analyst/ Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Perform Tableau Server admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Worked on the Reports module of the project as a developer (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Worked on different kinds of transformations in SSIS as per the Requirement.
• Monitored Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Managed and maintained all production and non-production databases.
• Design of physical data storage, maintenance, access and security administration andcorrect functioning of backup and recovery on DBMSs.
• Configured database parameters, creates prototype designs against logical data models,and defines data repository requirements, data dictionaries and warehousing requirements..
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Developed Multi-Dimensional Objects Cubes, Dimensions using SSAS.
• Hands on experience in UAT Test management, Execution, Scripts
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Tableau Desktop 9.1, Tableau Server 9.1,SQL, PL-SQL, TSQL, SQL Server 2012, MS Office Suite.

Confidential, Seattle, WA

Data Analayst/ Tableau developer

Responsibilities:

• Involve in Data asset Inventory to gather, analyze, and document business requirements, functional requirements and data specifications for Member Retention from sources Xcelys / SQL / Hadoop.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database, which provides efficient and granular level of control.
• Created dashboards for analyzing POS data using Tableau 8.0 on top of SAP HANA.
• Was the lead in Data Ware Housing Foot-Print reduction
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Hands on experience in UAT Test management, Execution, Scripts
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution. develop Scripts to load data into tableau and work with multiple dataconnections including Hadoop/Hive and by data blending.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Environment: Tableau (Desktop/Server), Hadoop Hue,MS SQL Server, SQL, Assistant, Microsoft (Word, Access, Excel, Outlook),sql server, SSIS,SAP HANA

Confidential, Atlanta, GA

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Understand the business requirements for report development on exceptions and financial reports
• Developed and deployed merchant friendly UI to generate assortment exception reports
• Created modules and pass through queries to access the DB2 environment source data
• Use the Share embed code the Share button at the top of each view provides embed code that you can copy and paste into your webpage.
• Developed financial reports in tableau for understanding the assortment based on performance
• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Enhance the embed code that Tableau provides, and build own code. Either way you can use parameters that control the toolbar, tabs, and more.
• Resolved the data blending issues based on data from multiple sources
• Developed various tableau BI charts on assortment planning and reporting
• Created parameters, calculated fields, various filters and groups to facilitate different views on dashboards.
• Developed sales reports from Teradata on store wise performance and filtering them on top sales
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Used SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application using platform database objects.
• Responsible for all the activities related to configuring Data Loader, uploading data in CSV files into salesforce.com, checking for the correctness of the data.
• Worked with Salesforce.com team to make application certified.
• Packaged and Deployed customizations from Sandbox to other environments using Force.com IDES.
• Help users with Chatter teams/Groups and follow application as well.

Environment: Tableau (Desktop, Server), MS Access 2010,VBA, Teradata, SQL, Teradata SQL Assistant, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Hanover, MD

Tableau/ Data Analyst

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Designed datamarts to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
• Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ datamarts.
• Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Refreshed the Tableau Extract in production server using scheduler.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, Lookups and Quick Table calculations.
• Created Actions in Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
• Involved in administrating Tableau server and creating tabadmin scripts for automating backup procedures through windows scheduler.
• Worked in user management, group management and permission management for accessing dashboards based on security requirement.
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Provided 24/7 customer support to tableau users.

Environment: Tableau(Desktop/Server)6.1,.2/6.0.1,Oracle,Teradata,MSSQL Server, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, CA Service Desk, Microsoft (Word, Access, Excel, Outlook),Adobe Marketing Cloud

Confidential, Mount Laurel, NJ

BI Analyst/ Data Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure and to maintain data efficiently.
• Worked with source system teams to understand source data and complete source data profiling.
• Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same.
• Designed database tables to feed Promotions, Campaigns, Customer, Sales data for effective targeting and direct marketing campaigns.
• Extensively worked on Pre-Campaign and Post-Campaign data analysis.
• Designed various analytical reports and dashboards on Sales performance, campaign response data in Tableau.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Involved in testing, fixing the bugs and troubleshooting the technical problems.
• Created the templates for test plan, test cases, process flow diagrams etc.
• Involved in Performance Tuning of Parallel Jobs by analyzing the performance of the jobs and project and enhance the performance using the standard techniques.
• Experience in co-coordinating offshore team with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.

Environment: Tableau (Desktop/Server), Oracle, Teradata, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, UNIX, MS SQL Server, ERWin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Schaumburg, IL

Data Analyst / Business System Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs, using Data Stage
• Involved in the some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using MicroStrategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Developer

Responsibilities:

• Worked as developer of a team, responsible for the design and development of an ORACLE application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with the project manager to understand the scope of each phase & module and further understand & implement the Object Model & Database design specifications, Domain Model.
• Framing the business logic plus code for accessing data stores.
• Develop validation routines for complex business rules and data handling.
• Created numerous forms and reports using Forms and Oracle Reports.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Used SQL*Loader to load data into Oracle database.
• Troubleshoot performance issues and bugs within packages.

Environment: Oracle, SQL*Plus SQL, SQL* Loader, PL/SQL