Alteryx Developer/Data Analyst Resume

OBJECTIVE

Process oriented and dedicated Data analyst with diverse skills. A quick learner, adaptable and prolific problem solver who works well with teams and also can deliver independently. My expertise involves working with large data set and implementation of ETL process and extracting data from multiple sources, while preserving data integrity.

PROFESSIONAL EXPERIENCE

Alteryx Developer/Data Analyst

Confidential

Responsibilities:

Conduct statistical analysis and draw insightful decisions to present to both technical and non - technical stakeholders.
Use advanced Excel functions (VLOOKUP, Pivot tables) for data analysis and creating reports.
Develop new and modify existing SQL code based on the requirements to generate data reports.
Run Ad-hoc requests for the business as needed.
Convert complex data from multiple sources into meaningful and easy to understand formats for various stakeholders.
Implement ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
Manage end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and create visualization using tableau to develop high quality dashboards.
Update fields and data types and heavily utilized case statements logics for developing business logic.
Use joins and sub queries / nested queries in SQL.
Develop various documents associated with design phase; Software Specification Document (SDD), unit testing validation document and traceability document.
Support in gathering requirements from the business partners and develop Business Requirement Document (BRD).
Conduct peer review test, create test plans, and execute test script and validation.

Data Analyst

Confidential

Responsibilities:

Direct activities related to dispatching, routing and tracking transportation vehicles.
Managed all truck’s driver contracts including insurance liability, payables, compensation, and benefits.
Oversaw scheduling for the day to day activities of employees.
Handled new recruitment and employment law matters.
Actively participated in streamlining operational policies and procedures related to transportation.
Establish performance objectives for associates in the distribution center, analyze attainment to find ways to improve performance.
Established transportation cost standards and economical shipping practices.
Forecasted manpower requirements based on daily workload and company targets.
Increase employee retention rate above 90% by creating and maintaining a positive environment