SUMMARY

• 6 years of extensive IT Experience in Data Warehousing and Business Intelligence and Analytics applications in Insurance, Health Care and Financial industries.
• Experience in Tableau BI products (Tableau Desktop, Tableau Server, Tableau Reader and Tableau Public)
• Technically experienced in created various Dashboards and reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and also making use of actions, Tableau filters, Tableau dashboards color coding and formatting, proto types, mock up reports, Design documents(HLD,LLD).
• Worked on Data analysis including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Experienced working as a Tableau Developer, Tableau Administrator and Tableau Analyst in different Tableau BI products(Tableau Desktop and Tableau Server)
• Worked with different IT teams, management and/or data scientists to determine the goals
• Experience withdata modeling techniques, including 3rd normal form, dimensional data models, star/snowflake schemas, which includes understanding business, processes, modeling dimensions, hierarchies and facts
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Involved in different types of testing (Unit testing, Integration testing, System testing, Regression testing and User Acceptance testing). Developed test requirements, test plans, scripts, test conditions and test data.
• Created real-time interactive dashboards using different KPI's and impressed the clients with my work
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS

Operating System: Windows 98/2000 NT/XP/Vista/7

Databases: Teradata v2r5/v2r6/12/13, Oracle 10g, MySQL, DB2 9.0

BI Tools: Tableau 9.x/8.x, SSRS, Micro Strategy

SQL Tools: SQL Developer, Teradata SQL Assistant

Data Integration Tools: Informatica Power center, SSIS

Scripting/ Language: C, SQL, PL/SQL, HTML, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

BI Developer/Admin

Responsibilities:

• Worked as Tableau Desktop Developer and Tableau Server Administrator.
• Gather Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Installed and configured Tableau Server and Tableau Desktop
• Upgraded Tableau Server from Tableau 8.1.6 to 9.0.3 version
• Involved in POC's with Amazon Redshift Database and Google Big Query to get the better performance of the workbooks
• Perform software sync activities like Planned upgrades, Configuration changes and patch deployments
• Provide recommendations for data presentation within reports/dashboards.
• Experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Perform maintenance activities Backup, Logs Cleanup and Archiving Log files in prescribed intervals.
• Ability to move data between production systems and across multiple platforms
• Includes expertise in data quality, data organization, metadata, and data profiling
• Used Alteryx for Data Blending in single work flow and for checking whether the data is correct.
• Expertise in creating Report Inventory, Report Mapping document, Report Business Requirement Document (BRD), Reports Functional Requirements Document (FRD), Use cases diagrams and report inventory document.
• Developed Tableau workbooks from multiple data sources viz AWS and SQL server using Data Blending.
• Experienced in connecting with AWS Redshift and then getting the data into Tableau
• Involved in maintenance and scheduling of Tableau Data Extracts using Tableau Server and the Tableau Command Utility
• Assisting key stakeholders achieve important risk reduction goals through meaningful metrics and dashboards.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Understanding of ETL concepts and has the ability to learn ETL process from different data sources.
• Involved in writing complex calculations using LOD functions and table calculation functions.
• Have experience in running cleanup and create backups of the database. Have knowledge of Tableau Licensing
• Exposure to Java script API to connect to the web using Tableau
• Worked in a rapid prototyping environment with local and remote team members.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau desktop 9.1/8.1/8.2, Tableau server 9.1/8.1/8.2, Microsoft SQL Server, Google Big-Query, SSIS,SSAS,SSRS, Netezza, Autosys, MS BI, CSS,HTML, JavaScript API, Business Objects, Agile, Alteryx

Confidential, LA, California

Tableau Developer/Analyst

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Built and published customized interactive Dashboard reports in Tableau Server
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Worked with other team members to complete special projects and achieve project deadlines
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Have command on TABCMD and TABADMIN command prompt
• Developed optimized data collection and qualifying procedures
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Created responsive dashboard using CSS through which user can access Dashboard through Ipads, IPhones and Desktop
• Identifying appropriate source systems and understand how data flows within various systems
• Develop aggregated Tables for Tableau to consume using PeopleSoft database and Informatica Power Center.
• Implementing trend lines, reference and forecasting to already developed worksheets for better understanding
• Handle Tableauadmin activities such as granting access, managing extracts and installations
• Analyze and interpret results using standard statistical tools and techniques
• Collaborated with the technical team, in any given product development cycle, on data requirements such as data structure, data flow, dependencies, and data mapping in the context of a relational database.
• Performed Data Analysis and developed Visualizations using Tableau, SQL, Excel and Qlikview.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Performed daily data queries and prepared reports on daily, weekly, monthly and quarterly basis
• Used advanced Excel functions to generate spreadsheets and pivot tables
• Perform data analysis for complex data and files
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Looking at the trends of data and coming to new conclusions based on the findings.
• Answering specific business questions quickly and reliably.
• Making proactive recommendations based on analyzed data
• Responsible to work closely with the team’s Business Analyst/ Program Manager but also interact with internal customers.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.

Environment: Tableau 8.0, Teradata 13.10, Teradata SQL Assistant, OBIEE, Oracle SQL, Share Point, Agile-Scrum, Informatica, Postgre, Agile, UNIX, MS VISIO, Microsoft Office Suite, JIRA,TOAD,AWS Redshift

Confidential, Richmond, VA

Tableau Developer/Qlikview Developer

Responsibilities:

• Experience with the design and development ofTableauvisualization solutions.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Worked with Data Warehouse developers to define and obtain reporting data view models
• Experience in optimizing QlikView dashboards with a focus on usability, performance, and flexibility
• Strong hands-on experience with QlikView scripting, Section Access, QVD, QVW, data loads, etc.
• Strong experience with RDBMS systems like Microsoft SQL Server, Oracle, Sybase etc. Knowledge of Qlik Sense
• Experience in QlikView installation, sever side administration, and user administration
• Extracted data from SSAS cubes and also developed dashboards in MS BI
• Mentored business power users to create reports/dashboards using tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Conveying the story in a meaningful way which is easily understood and actionable.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 7 (Desktop, Server), Qlikview, Teradata, Teradata SQL Assistant, SSRS, Teradata Administrator, SQL, PL/SQL, MS Project, SAP BW, Agile

Confidential, Jersey City, NJ

Teradata Developer/ Analyst

Responsibilities:

• Supported the customer for database needs and guidance using tools and utilities like explain, visual Explain Index wizard, Performance Monitor (PMON) and dictionary views.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, Multiload, FastLoad and BTEQ.
• Update system design documentation including high level design, low level design, source to target mappings, etc.
• Develop scripts for UNIX to run the ETL programs
• Familiar with Teradata Database Query Manager.
• Written several Teradata BTEQ scripts to implement the business logic.
• Extensively used FASTEXPORT utility to export and load data to/from Flat files
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Writing BTEQ scripts to perform database modifications.
• Prioritizing relevant and meaningful business questions.
• Collecting the best data that is relevant for the decision from multiple large volume data repositories.

Environment: Teradata V2R5/v12, BTEQ, FastLoad, Multiload, Tpump, FastExport, Teradata SQL Assistant, Oracle, UNIX.

Confidential

Teradata Developer

Responsibilities:

• Understanding the Technical design document and Source-To-Target mappings.
• Performed Analysis on Metadata according to TDD.
• The data is extracted from Flat files and loaded in to Teradata Database.
• Interaction with Client /End User for New Requirements and update status on Daily bases.
• Used Teradata Utilities like BTEQ, SQL Query manager to maintain database.
• Performing Data analysis and generating Datasets for quantitative analysis.
• Maintained, debugged and optimized existing data warehouse system and streamlined batch processes.
• Wrote SQL statements to extract data from the Tables.
• Performed all aspects of including data modeling backups, replication and recovery.
• Involved in writing Unix Shell Scripts for automation.
• Testing the Jobs to assure that data is loaded as per TDD.
• Providing the support after post production.

Environment: Teradata V2R5/v12, BTEQ, FastLoad, Multiload, Tpump, FastExport, Teradata SQL Assistant, Oracle, UNIX.