SUMMARY:

• Around 8 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4+ Years of extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Gathering/ analysis, Design, Development, Testing and Production rollover.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML.
• Improved Reports performance in tableau using extracts and context filters.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau 8.0/7.0, OBIEE 10.1.3x/11g, Business Objects 5.x/4.1, Crystal Reports, Cognos, Micro Strategy, SAS

Data Warehousing ETL Tools: Power Center 8 .X,7.X, Talend 4.2.x/5.1.2, IBM Info sphere Data Stage, Microsoft SQL Server Integrated Services

Databases: Oracle 11g/10g/9i, MySQL, SQL Server, Teradata

Database Tools: TOAD, SQL Developer, SQL Plus

Data Modeling: Star schema modeling, Snow-flake schema modeling

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Web Tools: HTML, DHTML, XML, JavaScript

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

Sr. Tableau Admin/Developer

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Administrating tableau server infrastructure (DEV/QA and PROD),
• Developed tableau server audit reports to view and analyze tableau server insights (health, tableau server usage, tableau server data extract failures etc.)
• Tableau server status reporting and data extract management.
• Worked with Stakeholders and business users for mentoring and training.
• Creating and maintaining new data extracts as per the new requirements,
• Resolving ODBC driver issues with the data extracts,
• Tableau desktop and server tickets resolution (primary contact for support)
• Resolving tableau dashboards development and performance issues
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed effective and interactive Dashboards using Parameters and Actions
• Developed donut charts for analyzing sales planning data.
• Created different KPI’s using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
• Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Using the Shiny UI with lower level code of HTML tags and JavaScript.
• Also involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

Environment: Tableau Desktop 8/9, Tableau Server 8/9, Tableau Public, Oracle 11g, Microsoft SQL Server 2012, Microsoft Visio, Shiny, Windows 7/8/10.

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

• Gathered user requirements, analyzed and designed visualizations based on the requirements.
• Created aggregations, calculated Fields, Table calculations, Totals, percentages, Bubble chart, Analytics, Drill down analysis using tableau desktop.
• Used Informatica to extract the data from Siebel CRM, transform and load to warehouse.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters
• Created stories in Tableau using Story functionality.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Created Prompts, Conditions, Parameters, Sets, Local and Global filters, for various dashboards.
• Customized the tooltips and labels, to user understandable format.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Produced Forecasted Reports for the upcoming time period to observe timely trends in Tableau.
• Generated views using multiple Measures like Individual Axes, Blended Axes, Dual Axes.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau by connecting live and static datasets.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 8.0, SQL Server 2008, Windows 7/8.

Confidential, Durham, NC

Tableau Developer

Responsibilities:

• Interaction with a diverse group of professionals and gathered user requirements and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping and Design process for various sources and Targets.
• Adhere to good systems agile development methodology.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet.
• Created Stories using Tableau as part of report presentations to Business
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Responsible for Preparing the Report Design specifications based on the User’s requirements
• Created different types of charts.
• Providing the Security while Publishing to the Tableau Server.
• Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Coordinating with Business Analyst in validating report requirements.
• Applied the actions in the work sheets and dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Environment: Tableau 7.0/8.0, MS Excel, DB2, TOAD, Windows,

Confidential, Atlanta, GA

Data Analyst/Programmer

Responsibilities:

• Developed the SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) packages to transform data from SQL 2012 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment for Weekly, Monthly, and Quarterly reports/processes.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Documenting various Data Quality mapping document, audit and security compliance adherence.
• Providing inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed SQL loader scripts to load the data into the custom tables.
• Performed database integrity check using SQL and Unix Shell Scripts
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing

Technologies: Mainframes, Data Mining, MDM, MS Excel, MS Access, SSIS, SSRS, Oracle 10g, Meta Data, IDQ, IDE, UNIX, Windows XP, SQL, PL/SQL

Confidential, St Louis, MO

Data Analyst

Responsibilities:

• Interacted with cross functional teams to facilitate gathering of business requirements.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Analyzed Business Requirements, performed GAP analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using Rational Rose.
• Involved in Change Management Configuration using Rational Clear-Quest.
• Performed UAT testing of the requirements. Testing for checking the data flow of the application using SQL.
• Involved in preparing flow diagrams for the decision logic using Visio tool.
• Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
• RUP process model was used for the different phases of the application development of the Software Development Life Cycle
• Recommended and coordinated development efforts and enhancements
• Generation of the UML Collaboration and Sequence Diagrams for specifying the call flow.
• Worked on Data Mapping for the models for data transformation.
• Worked with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing and documenting functional and technical requirements to develop packages and reports.
• Developed standard/complex reports and analytics to meet the needs of business analysts and business users.
• Built ad-hoc reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of master-detail reports using repeaters and repeater tables.
• Customized reports by adding Filters, Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Bursting reports to different user groups.
• Involved in full development of life cycle (SDLC) within Cognos reporting Framework from developing business requirements to production environment.
• Provided the prompts, filters, drill up/drill down in Query Studio.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis studio), Oracle 10g, Windows, Microsoft Excel, Microsoft Word, Microsoft Visio, Rational Tools, Clear Quest, Clear Case, Microsoft Access

Confidential, Boston, MA

Data Warehouse Analyst / Developer

Responsibilities:

• Conducted JAD/Requirements gathering sessions to get business rules, transformation logic.
• Design and create Logical and Physical data Models using Erwin.
• Lead the efforts for Standardization of Data and Naming standards for Data Elements.
• Participated and contributed in Requirement gathering for Data warehousing, data migration, and data integration projects.
• Creates and publishes periodic reports, as well as any necessary ad hoc reports.
• Create database objects, scripts to deploy in target Oracle database like Tables, Views, and Materialized Views etc.
• Create views and queries to pull data from source SQL Server, Excel, CSV, and flat files.
• Create ETL Mapping with Talend Integration Suite to pull data from Source, apply transformations, and load data into target database.
• Engineering the data conversion process for customer projects, based on the data profiling & data analysis.
• Created ETL mappings for Staging, Operational Data Source (ODS), Data warehouse & Data marts.
• Developed Talend & SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, Cleaned and validated.
• Converted many SSIS packages to Talend jobs as company migrated from SSIS to Talend.
• Coding, troubleshooting and performance tuning SQL and ETL jobs.
• Develop the ETL jobs mappings to get data from Oracle, SQL Server, excel, XML, .CSV, .TXT sources and load to the data warehouse (OLAP) with Talend ETL jobs.
• Designed ETL jobs for Data-Mart history and Change Data Capture (CDC) load.
• Optimized the performance of queries with modification in TSQL queries.
• Generated reports using SQL Server Reporting Services (SSRS) 2005/2008 from OLTP and OLAP data sources.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Provide technical support to users and testers.

Technologies: Talend 4.2.2, SQL Server 2005/2008, T-SQL, Windows server 2008, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, BIDS.

Confidential, Richmond, VA

Database ETL developer/Data Analyst

Responsibilities:

• Architecture design of Extract, Transform, Load ETL environment.
• Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2, Type 3 to capture the changes.
• Designing, developing and deploying end-to-end Data Integration solution.
• Develop the ETL mappings for XML, .CSV, .TXT sources and also loading the data from these sources into relational tables with Talend ETL.
• Developing complex ETL mappings for Staging, Operational Data Source (ODS), Data warehouse and Data marts load.
• Conducted Data/Requirements gathering sessions and created & managed Source to Target mapping documents for all Facts and Dimension tables.
• Scheduling the ETL mappings on daily, weekly, monthly and yearly basis.
• Actively participated in gathering business requirements and system specification from system users.
• Analyzed requirements, designed, maintained and updated data models.
• Analyzed existing data management procedures in practice and suggested ways to automate the process and improve the existing system.
• Developed stored procedures to pull data from the distributed systems.
• Developed PL/SQL Packages, Procedures and Database Triggers.
• Tuned SQL queries using quest central tools and Explain Plan.
• Developed and implemented complex data models and logical database designs and defined database requirements and designed data model.
• Extensively used SQL Loader to load data from flat files to the database and validated data with PL/SQL procedures.
• Developed back-end PL/SQL packages, built UNIX shell scripts for data migration and batch processing.
• Tuned complex stored procedures for faster execution and developed database structures according to requirements.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Designed and developed user interfaces using Oracle Forms 6i and worked on Oracle Reports 6i.
• Developed and implemented dozens of automated batch processing jobs in numerous development, test and production environments.
• Involved in importing production data to work environment using TOAD.

Technologies: Oracle 8i/9i/10g/11g, Oracle Forms 6i,9i, Reports6i,9i, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer, Putty.