SUMMARY

• Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 4 years 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 inTableau 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 teh 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.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for teh Web Applications.
• Worked on teh development of Dashboard reports for teh Key Performance Indicators (KPI) for teh top management.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), SQL Server MS Access and client/server applications.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Highly proficient in using T-SQL for developing complex Stored Procedures, TEMPEffective 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 teh 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 teh ETL operations.(Automate teh SSIS Packages and Import, Export).
• Extensively worked in OLTP & OLAP environments dat 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.
• Experienced in roles such as End-to-End BI and data-warehouse Solution 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 intelligence

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

ETL Tools: Informatica, SSIS

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

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, ASP.net,C

Document 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.
• PerformTableauServer admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• TEMPEffectively used data blending feature in Tableau.
• Prepared and published customized reports/dashboards.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server dat allowed end users to understand teh data on teh fly with teh usage of quick filters for on demand needed information.
• 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.,
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues TEMPeffectively in Tableau.
• Involved in administrating Tableau server and creating tabadmin scripts for automating backup procedures through windows scheduler.
• Created reports in Tableau using SSRS SQL Queries and Stored procedures.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with Stakeholders and business groups.
• Handled Tableau admin activities such as site creation, adding site admins, users, schedules & subscriptions, server maintenance, connectivity, backup etc.

Environment: Tableau Desktop 8.1, Tableau Server 8.1, Oracle (11i & r12), SQL, PL-SQL, TSQL, SQL Server 2008, MS Office Suite.

Confidential, Seattle, WA

Tableau Data Analyst/Developer

Responsibilities:

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Partnered with peers internal and external to teh team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of teh measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving teh performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• 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 teh external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on teh Business need and teh Business Value of teh solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Actively involved in teh creation of users, groups, projects, workbooks and teh 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), Teradata, MS SQL Server, SQL, Teradata SQL Assistant, Java API, Putty, UNIX, Microsoft (Word, Access, Excel, Outlook).

Confidential, Atlanta, GA

Sr. Tableau developer / Data Analyst

Responsibilities:

• Understand teh 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 teh DB2 environment source data
• Optimized teh performance of teh queries by passing teh parameters based on teh merchants selection from teh UI
• Developed financial reports in tableau for understanding teh assortment based on performance
• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Resolved teh 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.
• Involved in teh end to end analysis of teh data from teh source to teh correctness of teh reports
• 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.
• Actively participated in clarification meeting with teh Clients
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Analyzing teh data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with teh report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.

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

Business Systems Analyst/ Data Analyst

Responsibilities:

• Analyzed requirements to understand business needs.
• Formal Training in Unica affinium campaign tool.
• Coordinate with marketing, channel and operational managers to ensure campaigns are consistent with a customer-centric strategy & channel capabilities.
• Design ETL spec documents for teh development team and perform data analysis for gaps.
• Assisting developers to resolve complex issues. Developed jobs for ETL audit trail process.
• Extensively developed and used custom routines and enhance teh existing projects for campaign management.
• Extracted customer data to suffice source data requirements for campaigning using complex SQL.
• Responsible for complete data integration with other systems developed for marketing.
• Designed teh augmentation of MDM processes to improve teh quality of teh referential databases.
• Managed and assigned engineering tickets and resolve them in very critical time.
• Define methodologies for performance improvement and device strategies for ETL and database optimization.
• Suggested efficient routes in extraction, load and data archiving strategy.
• Involved in Test Plan Preparation and Effort Estimation.
• Understanding and providing feedback for all allocated features / defects, including teh work dat may need to be completed by teh offshore team.
• Involved test planning, test scenario development, and execution of E2E testing with teh help of teh offshore team as an onsite resource.
• Understanding and analyzing teh release statuses and activities
• Provided review feedback for all aspect of testing (test plan, test case, test execution) to teh offshore team.

Environment: Oracle, UNICA, Informatica, SQL, TOAD, UNIX, HP Quality Center, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential - Mount Laurel NJ

BI Analyst/ Data Analyst

Responsibilities:

• Gatheird user requirements, analyzed and designed software solution based on teh requirements.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
• Make use of data modeling techniques in designing teh data marts project.
• Assisted teh DBA in converting teh logical models to physical.
• Conduct Design discussions and meetings to come out with teh 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 teh team of ETL developers to implement teh same.
• Designed database tables to feed Promotions, Campaigns, Customer, Sales data for TEMPeffective 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 teh Implementation team to ensure a smooth transition from teh design to teh implementation phase.
• Involved in testing, fixing teh bugs and troubleshooting teh technical problems.
• Created teh templates for test plan, test cases, process flow diagrams etc.
• Involved in Performance Tuning of Parallel Jobs by analyzing teh performance of teh jobs and project and enhance teh performance using teh standard techniques.
• Experience in Confidential -coordinating offshore team with responsibilities such as providing solutions for teh issues/troubles/technical difficulties dat offshore team TEMPhas 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 teh existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into teh central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created teh AS-IS and TO-BE process flow diagrams.
• Defined teh scope of teh project based on teh gatheird 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 tan 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 teh jobs, using Data Stage
• Involved in teh 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 teh 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 teh existing Dashboards using MicroStrategy desktop.
• Interacted with teh End users on a regular basis for resolving issues pertaining to teh reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared monthly status reports for Enhancement Requests to teh project team dat was used in efficient tracking and monitoring of open issues of teh 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 teh design and development of an ORACLE application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with teh project manager to understand teh scope of each phase & module and further understand & implement teh Object Model & Database design specifications, Domain Model.
• Framing teh 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