SUMMARY

• Over 8+ years of experience in Software Design, Dashboard Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 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 with in Tableau Server and Reports.
• In - depth knowledge on Tableau Desktop 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.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked on various domains including Insurance, Finance, Banking, Healthcare and Retail.
• Worked in various Heterogeneous Source Systems like DB2 Mainframes, Oracle, Teradata, MS SQL Server, Flat files and Legacy systems.
• Experience publishing the reports to web portals through tableau’s javascript api function.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expertise working with Big data technologies as a backend and creating complex Tableau Dashboards with optimal performance
• Expertise writing complex custom SQL for various client needs and utilized Tableau 10 to implement Cross Joins from heterogenious sources in creating KPI’s and Scorecards using Tableau
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Created ETL to translate and structure data into a model that makes visualizations render using Informatica powercenter.
• Created WebI Reports (4.0) with multiple variables at report level and also created User Defined Variables on report site upon user's requests.
• Created Multi tab reports using multiple data providers and applied different Webi functionality such as hiding and filtering tables based on specific prompt conditions. Also used Union, Intersection, minus, Master/Detail, cross tab and Charts using Webi functionalities.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Involved in creating detailed design documents and performing Proof of Concepts (POC).
• Used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experienced in SDLC (Software Development Life Cycle) by following Agile methodology/ Waterfall for gathering requirements, analysis, design, development, testing, debugging and deploying.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Excellent knowledge of Business Intelligence and Data Warehousing with good fundamentals in Databases and Programming.
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Supported team in resolving SSIS, SSRS, T-SQL and ETL related issues.
• Experience in Dimensional modeling using Star Schema and Snowflake Schema and data analysis to provide Business Intelligence solutions.
• Expertise in writing T-SQL Queries using Joins, Sub queries, stored procedures, functions, triggers for building packages and Performance tuning SSIS packages and SSRS Reports.
• Expert level skills on T-SQL and query optimization and developing ETL strategies using SSIS.
• Extensive experience in architecture design of source table mappings to Extract, Transform, Load data into target environment using ETL Tool - Informatica Power Center.
• Extensive experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop and Tableau Server.
• Experience configuring reports from different data sources using data blending
• Worked on MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques.
• Familiar with Complex Reporting Requirements like Dashboard, Matrix, Cascading Summary, Sub reports and pass through parameters from main report to the sub reports.
• Participating on Review and Retrospective meetings for sharing ideas to improve productivity.
• Working experience in using various Microsoft office products like MS Excel, MS Access, MS Visio and MS PowerPoint to create and reports and templates.
• Excellent communication skills, Client Interaction and sharing knowledge with demos.

TECHNICAL SKILLS

BI Tools: Tableau 10.x/9.x/8.x/7.x/2019.1, SAP BO 4.0, SSRS 2012,Alteryx 2019.3

Databases: Oracle 10g/9i/8i/7i, IBM UD2 DB2, Sybase SQL Server 11.0, MS SQL Server 6.5/7.0/9.0, MS Access 2000, Teradata

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML

Web Technologies: JavaScript 1.2, HTML 4.0

Others: Erwin 4.1.2/3.5.2 , TOAD,, SQL Loader, MS Office, Smart FTP, Ultra Edit, Autosys, Unicenter, Control-M,Quality Center, MS.Visio, Informatica

Operating Systems: Sun Solaris, Windows NT 4.0,Windows 95/98/2000/XP,HP Unix, MS DOS 6.22, IBM-PC Compatibles

PROFESSIONAL EXPERIENCE

Confidential

Sr. Tableau Developer /BI Developer

Responsibilities:

• Interacted with business users for requirement analysis and Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Worked closely with Business Analysts for requirement gathering, designing and creating work flow.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create a detail level summary report and dashboard using KPI's.
• Interacting with Coordinator/Team for the clarifications on daily calls and updating Status on JIRA.
• Database development and Data analysis on Stored procedures, Triggers and Functions.
• Developed complex Tableau Dashboard reports by gathering requirements on direct interactions with Business/Operation teams.
• Created and managed Tableau sites, projects, and workbooks, groups, data views, data sources and data connections.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Deep experience with the design and development of Tableau visualization solutions.
• Established Tableau security, back-up and restore process.
• Maintained and scheduled of Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
• Created multiple workflows including the different tools like join, summarize, Regex, filter, formula and macro tools using Alteryx.
• Created variety of data sets after doing data cleansing, data blending and data parsing using alteryx and used the workflows to get the summarized data for Tableau for the further analytical visuals.
• Maintained development process for developing ETL Packages and reports as per the norms like Gathering requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA.
• Good T-SQL Programming techniques in query optimization and performance tuning.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Experienced working on business object to provide users daily extracts of data.
• Created universe data models for the bo reports.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Experinced working on ETL jobs through informatica to create data flows using different transformations like aggregation, joiner,rankerand lookup etc. worked on infromatica data quality anallyst tool to create the user accesaable data as needed to update the reports perimeters for exception handling.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Extensively used Tab cmd commands in scheduling the reports using differnt kind of filters inside the bat files.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in installing tabcmd to schedule the report's and setup email reports using command lines and bat files automation through contol-m.

Environment: Tableau 10.1,9.x,10.5.2,2018.2, Erwin, SQL SERVER 2012, XML,T-SQL, batch Scripts, Informatica 9.5.1, Informatica data quality analyst(IDQ) 10.1.1, Business Objects XI, JIRA 7.3.1,SAP SYBASE ASE

Confidential, Nj

Sr. Tableau Developer

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Responsible for implementing effective Business dashboards & visualizations for senior management employing Tableau Software.
• Leading of visualization projects and initiatives within multiple divisions.
• Administrate Tableau Server, data content and report distribution.
• Gathering, cleaning and classifying data from multiple subsystems to support correct metrics distribution within the company
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in installing tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Involved in creating ad hoc analysis and reporting requests in a timely manner for Health Dept, Approval's, Declines weekly monthly and yearly
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Deep experience with the design and development of Tableau visualization solutions
• Worked on XML Web Services Control Flow task to read from XML Source.

Environment: Tableau 10.1,9.x, Erwin, SQL SERVER 2008, XML,T-SQL, batch Scripts, SSIS 2005, Rational Suite, Business Objects XI R2

Confidential

Sr. Report Analyst/Tableau Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Have published the data sources,worksheets and dashboard to the clients’s web portalswith the help of JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data to provide a high level of interactivity between a Tableau visualization and the rest of the web page.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure
• Validated the reports before publish reports to server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Building, publishing interactive reports and dashboards, report scheduling using Tableau Server
• Set up Tableau Desktop, Data Analysis and publishing reports.

  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: Tableau 8.3, SSIS 2005, SQL Server 2008, DB2, Cognos, Aqua Data Studio, Erwin 4.1.2, Toad, Winscp, Autosys, Rational Clear Case, Rational Req.pro, Rational Clear Quest, UNIX

Confidential, St. Louis, MO

Sr. Reports Developer

Responsibilities:

• Creation of user, groups, folder structures, library and repository Tableau server logon and security checks.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Validated the reports before publish reports to server.
• Worked in Agile like JIRA environment and involved in Conducting scrum meetings.
• Extensively gathered information by conducting walkthrough, workshop, brainstorming sessions and surveys. Identified the business requirements, analyzed and prioritized these requirements that should be included in advantage.
• Extensively used various techniques like Multiple Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections, if conditions while developing and creating the reports.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

Environment: SQL Server 2008/2012, Enterprise Edition, SSIS 2005, Tableau 7.0, ECM Live link workspace, Import Wizard, Microsoft Excel 2007, Windows 2003 server.

Confidential

BI Developer

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Worked with testing team to understand the validation requirements to design mappings.
• Worked with Functional team to make sure required data has been extracted and loaded.
• Worked on handling Master and Transactional data using Informatica.
• Involved in Functional Unit Testing and fixed the defects to meet the requirements.

Environment: SSIS, SSAS, SSRS, Oracle 10g, SQL, PL/SQL,UNIX Shell Scripts, TOAD 8.0, SAP R3, ABAP.