SUMMARY:

• Around 7+ years of experience in IT industry as a Tableau Developer and SQL ETL Developer with extensive knowledge in functional and technical domain of Business Intelligence, ETL tools, creating reports, dashboards through Tableau, identifying trends and processing mapping with strong background in Databases and Data Warehousing concepts.
• Extensive experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Worked in Data Analytics and we designed, developed and we used to a maintain the various data for ease of use
• Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Involved in full life cycle implementation of data warehouse projects.
• Our team have ability to understand the data and we make our business process design and development for maintain
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and Tableau servers for maintaining DB schemas
• Well versed in the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2014/2012 Packages with the proper control flow and data flow elements by using MS SQL Server 2014/2012/2008 R2/2008.
• Hands on experience in designing complex spreadsheets in Excel and maintaining.
• Very good experience in writing SQL, Stored Procedures, Functions, Indexes, Views and Triggers.
• Excellent understanding of relational database concepts and dimensional modeling techniques, Star and Snow-flake schema.
• Good skills in designing and maintain defect reporting and validating defect fixes
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Building user acceptance and monitor test plans, test scenarios, test processes and schedules, and prior testing and training
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Good Knowledge in Claims, Provider and Member modules of QNXT system in Healthcare domain.
• Experience with all phases of Software Development Life Cycle (SDLC) involving Requirement Analysis, Design, Development and Implementation.
• Modify Existing Reports to tune performance of Reports. Create Tablix, Drill down, Drill through and sub reports using SSRS.
• Experience with enterprise processes and tools like ServiceNow, iServe Ticketing System, RFC process, Autosys job scheduler.
• Expertise in EDI transactions like 837 I\P\D, 835, 999 and 270\271 files.
• Strong experience working with Confidential transactions using different NCPDP versions like 5.1\D.0.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, Tableau Reader, Tableau Public.

ETL Tools: SSIS, SSAS, SSRS

RDBMS: SQL Server, MY SQL, MS Access

Data Bases: MS SQL Server 2012/2008R2/2008/2005, Oracle 9i/10g/11g

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Development Tools: Visual Studio 2013, Biztalk Server 2009

WORK EXPERIENCE:

Confidential, Long Beach, CA

Tableau Developer

Responsibilities:

• Worked on generating various dashboards in Tableau Server using different data sources. Used Data Blending to merge data from different sources.
• Created dashboard reports to avoided and revered claim payments using parameters, sets, groups and calculations.
• Involved with Payment release team to identify gaps in claims payment logic and benefits.
• Developed several reports for reversal and adjustment claims.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, user defined functions, and views and other SQL joins and statements for applications.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Perform Code management, migration and deployment to development/ Production environments.

Environment: Tableau Server, Tableau Desktop, Excel, SQL Server management studio, MS SQL Server 2008R2

Confidential, Long Beach, CA

ETL Developer

Responsibilities:

• Created Stored-procedures in T-SQL for commonly used Query tasks for better efficiency.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Used SQL server profiler to troubleshoot slow running SQL queries to optimize for speed to improve performance of SSIS and SSRS reports.
• Worked extensively on Data Migration by using SSIS. Used different transformations lookup, condition split, row count Transformation, Derived Column, Data Conversion and Union All.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Created interactive reports with SSRS using the different kinds of report parameters to enable business user to choose the filter conditions.
• Automated SQL Reports using new Data Driven Subscriptions in SSRS Environments.
• Developed enhancements and optimization to BizTalk Process and SSIS packages.
• Developed SQL Stored Procedures, Dynamic SQL Queries for reports generation.
• Developed “batch scripting” files to trigger SSIS packages to integrate with Autosys jobs schedules.
• Configured Subscriptions to send Reports in Excel or PDF files to the higher management.
• Migrated SSIS Config files into SSISDB catalogs during SQL server 2008 migration to 2014.
• Provided operational support to IT applications and business enquiries.
• Produce ad-hoc queries and develop reports to support business needs.

Environment: SSRS, SSIS, SQL Server 2014/2008/R2, T-SQL

Confidential, Long Beach, CA

SQL\ETL Developer

Responsibilities:

• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Running test scripts for facets applications and modules
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive experience working in an Agile development environment
• Created Complex SQL Queries using Views, Indexes and User Defined Functions
• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required

Environment: MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010.

Confidential

SQL Developer

Responsibilities:

• Developed different type of provider reports using SSRS and SQL Server 2008.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager. Exported and delivered to analysts for review in Excel version.
• Created and maintained SSIS ETL packages to extract data from different systems and load large volume of data into data warehouse from different sources like Excel, CSV Tab delimited files.
• Developed new reports and perform maintenance of existing reports
• Setup SQL views to pull specific information for SSIS packages.
• SQL Scripting, using Microsoft SQL Server Management Studio 2008 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses.
• Designed SSIS Packages for Excel, CSV, and Tab delimited files for reporting purposes to end users.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Created packages in SSIS with error handling as well as created complex SSIS packages using Precedence constraints in control flow and data flow elements.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Authored Technical documentation for each SSRS report.

Environment: MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010.