Assistant Technology Analyst Resume
Raleigh, NC
SUMMARY:
- 3 years’ experience of Data Extraction and Analysis, Statistical analysis, Project Management, Documentation, QA Testing, Requirement Gathering, Tech Support, and Process Improvement
- 5 years of strong programming and business reporting skills
- Proven track record as a leader as well as team player in various industrial projects
- Strong collaboration skills with internal/external customers and cross - functional teams
- Excellent communicative skills catered towards industrial audience
- 3 years’ experience in analyzing data and developed innovative solutions for real business challenges
TECHNICAL SKILLS:
Statistical Software: Tableau, MS Excel, SAS (JMP), R, and Crystal Reports (CR)
Programming Languages: SQL, VBA, Python, C, and Matlab
Project Management & CRM: SAP, MS Project, and Salesforce
WORK EXPERIENCE:
IT Specialist,
Confidential .
Skills - Data Analysis, web analytics etc; Tools Used - SQL, Excel, VBA, Python, Tableau, etc.
Responsibilities:
- Performed data extraction and data mapping from web and manual resources
- Designed, developed, and tested relational database system along with user friendly interface with SQL
- Analyzed and generated business reports and improvement plan
IT Analyst,
Confidential, Raleigh, NC
Skills - Data Analysis, data mapping etc; Tools Used - SQL, Excel, VBA, Salesforce, CR, etc.
Responsibilities:
- Analyzed and improved business processes, while using data from different stakeholders
- Forecast customer behavior pattern extracting Salesforce CRM data (SOQL) and project data
- Scripted test case and performed software quality testing in Salesforce platform
- Trained new hires and troubleshoot, and created insightful business reports
- Instrumental in developing project automation and Predictivv platform -Yahoo Finance, 15-Jun-2015
Data Analyst
Confidential
Skills - Data Requirement Analysis, data mapping etc; Tools Used - SQL, Excel, SPSS, Tableau, etc.
Responsibilities:
- Collected and analyzed data to understand trend in customers’ inquiry using SPSS and SQL
- Assisted in planning and identifying potential areas of improvement in customer service division
- Improvement plan included quality requirement and best-in-class analysis of customer service
Assistant Technology Analyst
Confidential
Skills - Data Screen and Analysis, Business reports, etc; Tools Used - SQL, Excel, Visio, SAS etc
Responsibilities:
- Reduced 16% inventory cost by implementing tracking system dashboard using SQL Query
- Lead market research for identifying new revenue stream by product portfolio expansion
- Lead the most profitable new project - improvement of a customized mechanical product
Consultant,
Confidential, Moline, IL
Responsibilities:
- Improved the accuracy of John Deere’s total supply chain cost model by 20% in their ERP system
- Developed modified version of the same tool using MS Excel and SAP
- Identified missing cost structures that are currently not considered in John Deere’s planning tool
Confidential
Responsibilities:
- Built efficient database management system using SQL Query
- Applied knowledge of relational database to prepare financial report
- Developed user friendly interface, providing visibility in distribution network, for the system
Quality Control Analysis
Responsibilities:
- Performed parameter design analysis using non-linear statistical optimization tool
- Determined set point for each controllable factor to comply with desired response using simulation
Statistical Engineering
Responsibilities:
- Statistical modeling for single and multiple facility locations, and supply chain networks
- Developed and solved using MATLAB