James O

Houston Texas. [214-***-****] [acxl0l@r.postjobfree.com]

• Overall 6 Years of Experience in IT which includes; analysis, design and development of reports using Tableau, Oracle SQL, PL/SQL, Data analysis

• 2 years of Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.

• Report conversion from Excel, Cognos to Tableau Interactive Dashboard

• Interacted with business daily to define and document requirements for each report converted.

• Extensive Experience in various Tableau Desktop reporting features like Measures, Dimensions, Folder, Hierarchies, Live/Extract, Filters, Table Calculations, calculated fields, Sets, Groups, Parameters, Forecasting, Blending and Trend Lines.

• Representing data using the Cross Tabs, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts, Heat Maps, Tree Maps. Use groups, bins, hierarchies, sorts, sets and filters to create focused and effective visualizations.

• Used multiple data sources like Oracle, Access, SQL Server, Excel etc, to develop the dashboards hence combining multiple data sources in a single view.

• Interact with internal and external clients to understand requirements, explain issues and prioritize work.

• Created actions in worksheets and dashboards for interactivity and to compare data against different views

• Creating Tableau reports based on existing Excel reports.

• Created Filters, quick filters, table calculations, calculated measures and parameters.

• Experience in creating a dual-axis bar chart with multiple measures.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.

• Worked with Extracted Data Sources and Live Connection Sources

• Interact with internal and external clients to understand requirements, explain issues and prioritize work.

• Published workbooks and dashboards on Tableau Server.

• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau

• Created Tableau Data extracts for improving query performance improvement and enable efficient in-memory data access on Tableau Data Engine

• Understanding of analytical and problem-solving skills, capable of learning new technologies quickly.

Tableau Developer

CAMAC Energy - Houston Tx (Sept 2014 - to date)

• Interact with business daily to define and document requirements for each report converted.

• Interact with internal and external clients to understand requirements, explain issues and prioritize work.

• Creating Tableau reports based on existing Excel reports.

• Work with Extracted Data Sources and Live Connection Sources

• Creat Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

• Report conversion from Excel, Cognos to Tableau Interactive Dashboard

• Understanding of analytical and problem-solving skills, capable of learning new technologies quickly.

• Ensure projects are completed on time and within budget.

Data Analyst SQL / Excel

Kelsey-Seybold Clinic - Houston Tx. (Feb 2010 - Aug 2014)

• Ensure best practices are applied and integrity of data is maintained through, documentation, change management and security.

• Experience writing complex T-Sql Queries.

• Creating reports by integrating SSRS, SSIS and SQL Server Management Studio.

• Work with business stakeholders, application developers, and across functional units to identify business needs and discuss solution options.

• Created new tables, wrote simple to complex SQL queries, stored procedures and some user defined functions

• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.

Scheduled database backup and performed full, incremental and differential backups of database and transaction logs.

• Expert level skills with Microsoft Office Programs: Word, Power Point, Excel, Access, VBA, SQL

• Expert level experience with all of the features of Microsoft Excel and Access including Forms, Queries

• Restored data confidence, application accountability with measurable and cross-verified statistics.

• Participated in the design and developed data models and backend queries for presenting data.

• Proficient in OLTP/OLAP System, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

SQL Server Management Studio, SQL Server Enterprise Manager, TSQL, Pl/SQL, Toad, Oracle 11G, Microsoft Office(MS), MS Access, MS Excel, VBA.

Software / QA Intern.

CWG (2009)

• Exposure to all stages of Software Development Life Cycle.

• Working knowledge of tools like Eclipse, JIRA and Bugzilla, Jenkins.

• Involved in Defect tracking and Reporting using JIRA defect tracking tool.

• small scale projects( projects less than 100 files) in Subversion/SVN

• Strong verbal and written communication skills and the ability to lead and motivate.

Education

Bachelors Degree: Mechanical Eng. 2006

Certification

Oracle: OCA, OCP

PMI: CAPM

Additional Information

OS Platforms: Windows 98, windows server,

Programming: Html,css,Sql

Databases: Oracle, MS Access, MS Excel

Ssis, ssrs, ssas,Ibm neteeza, sql server, mysql, oracle, sap,

Git, Github, Jira, SVN, Notepad++,

SQL Server Management Studio, SQL Server Enterprise Manager, TSQL, Pl/SQL, Toad, Oracle 11G

Contact this candidate