SUMMARY

• Over 8 years of experience in Software Development, Implementation and Maintenance of Business Intelligence(BI) and Database Platforms.
• Experience in Software Analysis, Design, Development and implementing core business software applications.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in versions of Tableau 7/8/9/10
• Extensive experience working with Tableau Software as a dashboard developer.
• Experience in Tableauserver installation, configuration and administration & experience in creating Tableau Mobile dashboards.
• Extensive Tableau experience in Enterprise Environment and Tableau experience including technical support, troubleshooting, report design and monitoring of system usage.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, bubbles, histograms, heat maps, geographic visualization and other making use of actions, other local and global filters according to the end user’s requirement.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Experience with creation of users, groups, projects, workbooks and the permission sets in Tableau server.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing wnerships, working with Sites, providing access to the users and adding them to the assigned groups and
• Projects, Scheduling Refreshes and Subscriptions in Tableau Server
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the assigned groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Successfully upgradedTableau platforms in clustered environment and performed content upgrades.
• Experience in creating aggregates, hierarchies, filters, quick filters, table calculations, calculated measures.
• Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
• Good Knowledge on Database, Data Warehousing concepts and SQL
• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes and data import/export.
• Well versed in query optimization for performance tuning and monitoring of processes
• Worked on data warehousing designer tools that include Informatica power center (Source Analyzer, Warehouse Designer, Mapping designer, Mapplet Designer, Transformation developer) and ETL.
• Quick learner, Proactive, self-motivator and highly adaptable to challenging work assignments / roles.
• Regular communication with Client on gathering the requirements, discussions and in resolving the issues & concerns.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Business Intelligence(BI) Tools: Tableau 8.x, 9.x, 10.x (Desktop, Server, Reader), SAP Business Objects.

Databases: Server 2000/2005/2008/2008 R2/2012, MS Access, TeradataOracle 11g/10g, Excel Flat files, DB2.

Programming tools: C, C++, T-SQL, Oracle, Java.

ETL Tools: Informatica Power Center 9.5.1

Operating Systems: Windows NT / 2000. Windows Server 2003/2008/2008 R2

PROFESSIONAL EXPERIENCE

Confidential, Bothell, WA

Tableau Developer / Administrator

Responsibilities:

• Responsible for gathering suit of business requirements, download extracts from SAP BW and work closely with ETL team and Prepare Source to Target Mapping specifications.
• Developing the target Database table as per the requirement by writing the source qualifier Queries.
• Read business user requirements, analyzed data, and designed software solutions inTableau Desktop based on the requirements.
• Extensively involved in migrations of Tableau 8/9 to 10
• Creating and Writing Custom SQL to get the desired output for building a Tableaudashboard.
• Creating Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Developed geographic maps showcasing demographics broken into age, race, and incomecategory that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableauDesktop.
• Working as business analysts and touch base with Data Architects regarding the nature of the information processing or computation needs.
• Responsible for developing Tableau based dashboards upon gathering the requirements from the customer.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Published and Scheduled the Reports in Tableau Server.
• Developed and executed unit test cases for code development; includes performance and load testing as needed.
• Create different performance metrics of all the reports. Writing Test cases for the data connections, Templates and Reports.
• Documentation of features of the Developed Tableau Dashboards.
• Prepared architectural documents and presentations for client meetings

ENVIRONMENT: Tableau 9.x, 10.x, SQL Server 2012, MS Access, MS Excel, Informatica Power Center 9.5.1.

Confidential, Lansing, MI

Tableau Developer / Administrator

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Converted all existing excel report into Tableau visualizations.
• Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Working on generating various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle/Excel/Text data etc.
• Required to create users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Developed Tableau data visualization using Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Involved in license management SLA's with Tableau support.
• Developing Dashboards and preparing ad-hoc Reporting.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.

ENVIRONMENT: Tableau 8.x/9.x, SQL Server 2012, MS Access, MS Excel

Confidential, Indianapolis, IN

Tableau Administrator / Developer

Responsibilities:

• Served as Tableau subject matter expert to assist the BI team in learning Tableau, addressing development roadblocks, and migrating reports from existing server to new Tableau enterprise server.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau Development life cycle.
• Administer and support a multi-tier Tableau Infrastructure include upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general system maintenance.
• Assist business users with certification trainings for self -service BI, which allows them to leverage the benefits of the tool and explore data themselves.
• Help the BI team plan/implement a Tableau community of practice by providing ideas/insights and best practices.
• Assist users with Tableau development, suggested enhancements to developed reports, and publishing reports to the server with security settings.
• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles.
• Creating active directory groups, importing them to Tableau server, syncing the groups on daily basis.
• Publishing the reports on server, scheduling workbooks, data sources on server.
• Embedding reports on BI Marketplace which is a common platform to share reports to end users.

ENVIRONMENT: Tableau Desktop & Server 7/8, MS SQL Server, Oracle.

Confidential, Memphis, TN

Informatica ETL Developer

Responsibilities:

• Analysis and evaluation of the issues faced during development and facilitating speedy recovery.
• Review and analyze data mapping document to determine ETL program design.
• Use Informatica to develop ETL program to extract data warehouse File extract to be created will follow the instructions specified in the data mapping and file layout documentation.
• Extracted data from flat files and oracle database, applied business logic to load them in the central Oracle database.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Did the Data Migration from various source systems (DB2 UDB, Siebel, SQL Server) to central oracle data base which is used to business users for easy access of the data.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Responsible for Unit Testing of Mappings and Workflows.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing and worked with QA teams regarding fixing bugs.

ENVIRONMENT: Informatica Power Center 9.1.1,Oracle 10g, SQL, SQL Server, XML, MS Access, Informatica Scheduler, Windows 2008.

Confidential, San Jose, CA

ETL/SQL developer

Responsibilities:

• Understanding existing business model and customer’s new requirements.
• Prepare ETL Design Documentation& Conducted Design walk-through sessions.
• ETL performance optimization.
• Closely worked with end-users to analyse, understand, and gather report requirements.
• Extensively involved in ETL Processes development, support.
• Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Wrote T- SQL code/Stored procedures to create datasets for SSRS reports.
• Created Views to store aggregated values for reporting purpose.
• Code development, UTC, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions
• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Developed database structures and SQL queries for web applications.
• Worked with development team to improve application performance by tuning queries.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

ENVIRONMENT: ETL, Oracle 10g, SQL, SQL Server, XML, MS Access, Windows 2008.