Data Tableau
Resume:
Dashawn Wakefield
Software Test Engineer
**** ***** ***** ********** ** 30078
adhxk6@r.postjobfree.com
Summary:
● Experienced in business analytical skills of taking on a project from initial project implementation planning, sourcing technical project requirements, developing project workflows, estimation of cost and completion timelines and development/testing/ and deploying jobs to production environments.
● Experienced with project management life cycle using either Agile scrum or waterfall methodologies.
● Knowledge of managing Big data by cleansing, Mapping, Importing/Merging data from multiple sources including API’s, designing new tables, and building data models for data warehouse
● Expert knowledge of using database platforms like Oracle, Sybase, SQL Server, DB2, Vertica, MySQL, Cloud, AWS, Hadoop cluster, Linux/Unix programming.
● Experienced in Business Intelligence visualization tools like Tableau and Looker to design drill down summarized business performance reports.
● Experienced working with large structured, semi-structured and unstructured data sets and determining the key takeaways for preparing high performance data sets for business intelligence reporting platforms.
● technical skills with numerous software packages that include JIRA, Excel spreadsheets, MSVisio, DBVisualizer, writing SQL scripts, and sourcing data from AWS or exporting to Cloud Platforms.
● Experienced in writing user testing cases, logging defects, validating.
● Ability to collaborate with peers in both, business and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
● Demonstrated leadership role of onshore/offshore resources and the ability to accomplish tasks under minimal direction and supervision and drafting training/workflow documentation user guides.
Technical Skills:
Databases
IBM DB2, Sybase, Oracle 12g/11g, SQL Server, Vertica, MySQL
Database Tools
DBVisualizer, Rapid SQL, Toad, SQL Plus, SQL Loader
Reporting Tools
Tableau 10.3/Looker/Microsoft Power BI/SAP Business Objects
Tracking Tools
JIRA, Service Now, Service Catalog, ClearCase, ClearQuest
GUI
MS SharePoint, MS Word/MS Excel, Macros/MS PowerPoint, MS Visio
Other Tools/Scheduling Tools
Facets, TWS Scheduler, Linux/Unix Scripting, XML, Agile Methodology
Professional Experience
Ezay IT Consulting, New Brunswick NJ Aug. 2013- Jun 2020
Quality Assurance Analyst
Ensured all QA tools (bug management automation and test management) are fully utilized by team
Coordinated work with Database administrators, Java/Flex teams and business analyst to resolve data questions and anomalies and performed work estimation and routine data testing.
Writing and executing automated functional, non-functional, and regression tests
Record test results and report defects using team processes and standards.
Write and execute test cases based upon requirements and design specifications
Designing, creating, and publishing customized interactive reports, dashboards, and scheduling using Tableau Server.
Created job sequences for automation and generated the job reports.
Used Quality Stage for data cleansing and standardization for HR.
Prepared design document for all the jobs designed.
Customized Unix scripts as required for preprocessing steps and to validate input and output data elements.
Worked closely with management in the process of standardizing job parameters, job flows and audit process and disaster recovery strategies.
Create detailed QA reports and defect tickets based on the outcome of QA test cycles
Performed unit testing and system testing by creating automated test scripts in SQL and manual test cases for all modules. Environment: Informatica, Oracle 11g, IBM DB2, SQL Server, SQL Loader, Unix, Control-M, Windows 7, MS SharePoint, MS Visio,
Osher Bank and Trust, Wilmington DE Jan. 2020 - Jun. 2020
Quality Assurance Analyst
Delivered the project progress on time and within the agreed acceptance criteria in an Agile Methodology.
QA testing and provided accurate estimates and timeline of completion dates.
Researched business data flow, the data volume metrics, and KPI’s (Key Performance Indicators)
Work closely with the Business Analysts, formulating test plans, preparing test cases, executing the tests, and fully documenting and reporting the results
Migrated data from Flat files and wrote SQL commands for source code extraction to Data Warehouse.
Designed and published Tableau dashboards with multiple panels and parameters that were utilized across the teams which captured the trending performances of portfolio investments and customer growth.
Used several Tableau dashboard visualization charts that include bar graphs, line, scatter plots, pie-charts, heat map and tree map. Published dashboards to Tableau Server and scheduled daily extract refresh of reports.
Wrote test cases and business validation SQL queries. Coordinated with DBA architects in building database schemas, dimension and fact tables and optimizing table performance through indexing.
Wrote technical documentation for project designed and utilized Visio diagrams.
Environment: Informatica, Oracle 11g, IBM DB2, SQL Server, SQL Loader, Unix, Control-M, Windows 7, Pentaho, Tableau, Unix, Windows 10, Service Now, MS SharePoint, MS Visio
Education
Computer Programming AAS, Chattahoochee Technical College, Marietta, GA
Java Certification, Jan 2018-July2020
Contact this candidate