SUMMARY:

• Over 8+ years of experience in IT industry as Data Analyst, Support Analyst, and Data Modeler in Telecom, Finance, Networking, Healthcare Banking and Manufacturing industries.
• 4+ years Extensive experience Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.2.3,9.x, 8.x Tableau 7, Teradata, Informatica Power Center, SAP BI - BW
• Business Objects Enterprise, Java Script API, SQL Server, Oracle11g.
• Highly proficient in Agile , Test Driven , Iterative , Scrum and Waterfall Software Development Life Cycle (SDLC).
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Proficient in creating Use Cases, Data Flow Diagrams, Sequence Diagrams, Class Diagrams, State Transition Diagrams, ER Diagrams etc.
• Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.
• Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Scheduling Auto sys jobs (inserting, deleting and updating job definitions) in various production instances.
• Connected to Amazon AWS Virtual Private Cloud created Various dashboards
• Experience working on Production, Development and QA env
• Develop Scripts to load data into tableau and work with multiple data
• Connections including Hadoop/Hive by data blending.
• Highly proficient in design and development ofprototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filtersand creating Dashboards for key performance indicators.
• Knowledge on troubleshooting the data stage failures going through director logs. Also, possess hands on experience on importing and exporting data stage components.
• Expert in creating advanced calculations, sets, parameters and level of detail in Tableau Desktop.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse (EDW) and Data Marts.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Creating Tableau BI dashboards of call handing forecasting, call rate, call waiting time, and call forward, average call time Tableau BI.
• Worked with business partners and Server Side BI engineers to rigorously define, implement and further develop metrics and key performance indicators.
• Extensive usage of Actions, sorts, colors, layout and designing of dashboards.
• Expertise in URL Actions, passing parameters from Tableau to web applications.

TECHNICAL SKILLS:

BI Tools: Tableau( Desktop/Server/Mobile/Public), Crystal Reports XI, XCelsius, SSRS, QlikView

ETL Tools: Alteryx, Informatica, Cognos, Data Stage, SSIS

Applications: Microsoft Office, Share Point, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio

Languages /Scripting: C, C++, Java, JavaScript, R, HTML, SQL, PL/SQL, XML, VB, CSSData Modeling Tools

Autosys, Power Designer, Erwin, ER Studio, MS Visio.

Design/Version Control: UML, Rational rose

Red Hat Linux, HP: UX, Sun Solaris, Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7

Utilities: RMAN,EXP,IMP, Datapump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace & UTL FILE

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Created Hive tables and implemented loading mechanism for the tables and developed BigSQL tables which acts as the base of Tableau Reports.
• Connected Tableau with the data lake and created visualizations using, Hadoop, Spark SQL with ODBC connector.
• Analyzed the source data and handled efficiently by modifying the data types.
• The AWS EC2 instance is the Tableau server.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Logging and tracking of business user’s requests in the trouble ticket system.
• Application Validation after Releases and Deployments.
• Developing, modifying and Maintaining various scripts associated with AML.
• Support maintenance and update of DB objects (packages, procedures, triggers etc.) and Tableau Reports and Dashboards.
• Perform database tuning and performance monitoring.
• Developing new feeds coming into Dashboard from different systems.
• Data export and import by Oracle utilities.
• Represent AML systems in various forums, chat rooms and discussions.
• Support unit, system testing, and coordinate end user testing.

Environment: Tableau 9.3/9.0/8.2/8.1, 8.0 Tableau Server 7.0/8.0,AWS,Hadoop, Alteryx9.5/9.0/8.5,SharePoint, SOA, SAP BI-BW,Oracle 10g, SQL Developer, Agile-Scrum, Rally, Asp.Net, JavaScript, SVN, Netezza, Redshift

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Creating and modifying Business Intelligence analytical reports using Tableau.
• Major integration with web applications using JavaScript API, Asp.Net and IIS Server.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Core member for integration of Tableau Reports with Asp.Net web application and usage of JavaScript API for performance improvement.
• Extensive use of Rally software tool to manage agile development, creation of user stories, estimates and updates. Viewing the burn down charts and other reports, updating the team in meetings.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developed Omni channel analysis Dashboards
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked collaboratively with a team of developers to build ETL process needed for reporting.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Build and manage business self-service mash-up of data to enable combining and analyzing from multiple sources using Tableau & Alteryx.
• Used Alteryx for Cleansing, Joining, And Shaping Data.
• Worked heavily on Alteryx futures Formula Preparation, join, Parse, Transform, data investigation, Predictive, Time Series, Developer.
• Using Alteryx Audit The process and fixed errors quickly
• Worked on drill through reports by creating HTML references.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends Confidential various geographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Usage of Context, SQL filters to improve performance and different date filters to show the details for different quarters and years.
• Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 9.3/9.0/8.2/8.1, 8.0 Tableau Server 7.0/8.0, Alteryx9.5/9.0/8.5,Share Point, SOA, SAP BI-BW, Oracle 10g, SQL Developer, Agile-Scrum, Rally, Asp.Net, JavaScript, SVN, SQL Server 2012

Confidential, SFO, CA

Production Support

Responsibilities:

• Primary responsibility is to make sure the daily data is made available to the business users reporting purpose within the defined SLA.
• Responding to business user queries related to Java application (PRiMA) and regarding the data loads to the repository.
• Providing Java application (PRiMA) access to the business users in production as well as lower environment (UAT).
• Troubleshooting the production nightly batch failures, user run failures.
• Performing regular cleanup activities of production and lower environment file systems.
• Track production issues and report periodically to group charged with monitoring up-time and efficiency of production application.
• Provide knowledge articles to the Level 1 group on the new/updates made to the production batch that would help them in monitoring and escalation of issues in timely manner.
• Co-ordinate on the issues with various teams like IBM Netezza DBA’s, UNIX, Network, Application development teams and help fixing of the issue.
• Co-coordinating in application releases, attending meetings with the application dev and business users to help them understand regarding the production process (Incident, Change and Problem management).
• Testing the ESSO changes that happen as part of the software upgrades and take part in other infrastructural upgrades like LDAP, Server migration etc.
• Help system test team with the Java version changes testing in UAT environment to make sure there are no hiccups for the end users.
• Maintaining clear quest tickets for the audit trials.
• Documenting the new releases.

Environment: Autosys 11.3.5, IBM Netezza (Aginity Workbench), BMC Remedy, TOAD

Confidential

SQL Developer / Data Analyst

Responsibilities:

• Designed, developed, maintained and implemented operational and reporting database systems utilizing the latest techniques in data modeling and ETL concepts, from business requirements to technical design to the final product.
• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Scheduled the SSIS jobs using SQL Server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Experience using Power Pivot, Power Map, Power Query.
• Deployed different SSIS packages on test and production servers.
• Upgraded the existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Configured and maintained Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
• Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run Confidential different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Prepare data mapping and transformation rule documentation.
• Test and prepare ETL processes for deployment to production and non-production environments. Participate in unit, integrations, regression testing on a regular basis. Support system and acceptance testing including the development or refinement of test plans.
• Develop ETL/DW best practices and participate as a reviewer and contributor in requirement, design and code reviews.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, BI Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office2007, MS Access, ETL, Performance Point Server 2007, JavaScript, MS Excel

Confidential

ORACLE - PL/SQL Developer

Responsibilities:

• Create database objects (tables, indexes, etc.)
• Write database procedures, functions and triggers.
• Tune database queries.
• Monitor application related jobs and data replication activities.
• Software Analysis and Development.
• Debugging, Unit Testing in Oracle 8i, Oracle Forms & Reports 6i assignments.
• Preparing the required documents like DB Design, Test Plans.

Environment: Oracle 9i,Sql, PL/SQL, Enterprise manager, Toad, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003 and MS Excel.