SUMMARY:

• Overall 7+years of experience in Software development life cycle (SDLC) including Analysis, Design, Development, Integration, Implementation, Testing, Deployment and Maintenance with Business Intelligence Tools Usage of MSBI.
• Experience with Agile and Waterfall project management methodologies.
• Experience in Statistical Analysis Software (SAS) for developing and implementing various applications.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; generated various plots that is maps.
• Experience in creating solution driven dashboards, worksheets using calculations, parameters and then creating different types of chart in Tableau Desktop environment.
• Good experience to translate the reports to web using HTML or JavaScript.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Good knowledge in implementing ETL enterprise solutions with IBM Data Stage.
• Proficient working SQL databases with stored Procedures, Triggers, User-defined Functions, Views and Cursors using PL/SQL, T-SQL.
• Proficient in SSIS to develop Crystal Reports for extracting, cleaning, transforming and loading data into warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script Task and Send Mail Task to generate various Crystal Reports.
• Created SSIS Packages to extract, transform and load data into Data marts. Integrate SSRS reports and SAP Crystal Reports into ERP system.
• Utilized dynamic data connections for Reports creation.
• Implemented Tableau /Oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• 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. Improved Reports performance in Tableau using extracts and context filters.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensively used Quality center for defect tracking and linking them with test cases.
• Experience in automated testing tools Mercury Interactive/HP QTP, Load Runner, and Quality center.
• Worked on the Tableau security setting up AD users using windows run as user. Setting up SSL /SMPT mail server configuration for alters on report failures.
• Good knowledge in Selenium IDE Experience on manual and automation testing and knowledge in QlikView.
• Participate in the user requirement gathering and Design meetings.
• Experience in working onsite-offshore model.
• Highly proficient in understanding the complex applications and making enhancements as per client requirements with creative ideas.
• Have monitored new joiners and team members in terms of knowledge transfer, assessments and review.
• Strong team player with ability to take new responsibilities.
• Very good player, selfmotivated hardworking with positive attitude,leadership and good communication skills.

TECHNICAL SKILLS:

ETL Tools: ETL and Reporting Tools

Tableau: Tableau 8.0/9.2, Tableau server 8.2/9.2, Tableau Reader 8.1/8.2, Tableau, Tableau Public 9.2Databases: Databases Postgre SQL, MS SQL Server, MS Access 2000, Oracle10g, Programming Languages SQL, T-SQL, PL/SQL.

Developments: Ms-office suite, MS Visio, Dream viewer

Web Server: Internet Information Server (IIS).

Reporting Tools: SQL Server Integration Services (SSIS), Crystal Reports. Tableau

Programming Tools: Java, C, C++, SQL, TSQL, PL/SQL

Web server: IIS 7.0/6.0/5.0

Operating Systems: Windows XP/7/8/10, Mac

Methodology: Agile Methodology, Scrum Model, Water fall method.

DefectTracking/Management: Quality Center, Test Director, Version Manager

WORK EXPERIENCE:

Confidential, MN

Sr. Tableau Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Experience with full software development life-cycle, architecting scalable platforms, objects oriented programming, and agile methodologies.
• Followed Agile Methodology, Adherence to the Agile Scrum Methodology and following up on work on items JIRA.
• Generated Tableau combination charts using Tableau visualization software.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails SSL/ SMPT with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Mentored business power users to create reports/dashboards using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Given training/demos to users on Tableau Desktop for development.
• Included finalized model from data mining team to OLAP cubes created by real-time data to test the efficiency of the model.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau. Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Desktop 9.1/9.0/8.2, Tableau server / Administrator, Agile, SQL developer, SQL Server 2012 2008, Oracle 11g/12c, Microsoft Excel 2012, Microsoft office 2012.

Confidential, Southfield, MI

Sr. Tableau Developer

Responsibilities:

• Understanding existing business model and customer's new requirements.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created dashboard views from provider information data to members
• Extensively created visualization dashboards for the claims.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Involved in creating dashboards, reports and then published on to the Tableau server.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
• Helped customize Tableau Server with Company Logo
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users in Tableau dashboard development
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Coordinate new data development, which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
• Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.
• Created a proof of concept for the optimal data integration process.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.

Environment: Tableau Desktop 8.1/8.2, Tableau server 8.1/8.2, SQL Server management studio, MS SQL Server 2008R2, UNIX, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007.

Confidential, Peabody, MA

Tableau Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment, and user training.
• Involved in Physical/Logical design of database, creating and managing the database and all the database objects.
• Designed and developed forms using Visual Basic with ODBC.
• Designed and developed reports using Crystal Reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Involved in dimensional modeling to design data warehouse.
• Identified the measures, dimensions, and defined cubes to enable decision makers to drill through the detail data.
• Used the calculated members in the fact tables to improve efficiency.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Created roles, assigned permissions and users/groups to roles to limit the access for the users.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products for customer satisfaction
• Prepared functional specifications for user requirements.
• Experience in writing, testing, and implementation of the PL/SQL triggers, stored procedures, functions, and packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views, Synonyms, and Integrity Constraints.
• Involved in creation of schema objects, roles and privileges.
• Prepared user manual and technical documents for the end user.
• Prepared executables for system deployment and led the release of applications following.

Environment: Tableau Desktop 8.0/ 7.0, Oracle 9i, Server 2000, PL/SQL, TOAD, SQL, SQL Server Management Studio, SQL Server Integration Services (SSIS), Crystal Reports, Erwin, XML .

Confidential, Raleigh, NC

Tableau Developer

Responsibilities:

• Partnered with business analysts to understand requirements, source systems, and perform data analysis.
• Transformed OLTP Data to OLAP Data Warehouses based on requirements.
• Developed proof of concepts to showcase BI tool functionality to the end users and management audience including report and dashboards. Built the needed master data objects as "Attribute Views
• Created cube-like view by joining attributes view to fact data. Built a "Data Foundation based on transactional table and join attribute views to data foundation.
• Improved performance by narrowing the data set by creating projection nodes and by applying filters
• Wrote SQL select statements against existing raw tables or Column Stores (preferred).
• Defined output structure and activation creates column store based on Script Output.
• Wrote SQL script required to create Script based Calculation Views
• Built Visualizations and Storyboards. Combined data sets, edit, and cleansed datasets. Enriched data by creating calculated measures and attributes in the data sets. Grouped multiple measures together and used them in visualizations.
• Built necessary Materialized views to support the Data mart and coordinated with ETL for mappings and transformations
• Designed, Developed and Presented Dashboards. Made interactive designs using Multiple Drills Down, Dynamic Visibility, and Alert Features to support various requirement scenarios.
• Available on iPad by changing the theme of applications for mobile and generated QR code for users.
• Designed and presented intuitive Business intelligence presentations by creating slides in power point with SAP Business Objects Analysis in developing interactive analysis views on SAP BEx queries and SAP BW Info providers.
• Dashboards using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.

Environment: Tableau (Desktop/Server), MicroStrategy (Desktop/ Server), Teradata, Oracle, Teradata SQL Assistant, TOAD, PLSQL Developer, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential

PL/ SQL Developer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables. Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• The project was designed using SQL, Pl/SQL, SAS, Mainframe, Teradata, and Oracle.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting.
• Involved with Design and Development team to implement the requirements.
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Monitors test coverage and achieve high coverage using branch coverage analysis.
• Tracks how test results and code quality change over time.
• Conducted performance and load testing using Load Runner.
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: MS-Office Tools, SQL, PL/SQL, UNIX, Shell Scripting, Manual Testing, Test Director, DB2, and Oracle .

Confidential

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 6i.Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Provided Productions support and ongoing user support for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle Application Server 9i and UNIX.