PRIYESH AGARWAL

+1-972-***-****; ac4r60@r.postjobfree.com; LinkedIn; Dallas Texas 75252

SUMMARY

Quality Analyst with 2+ years’ experience boosting wealth management profitability by 5 M$ per year for Fortune 500 Investment Banking company. Seeking transition to work as Business Analyst at PDDN INC. Have a M.S. in Information Technology and Management

TECHNICAL SKILLS

Scripting/Procedural Languages: PL/SQL, T-SQL, Java, C++, VBA, Python

Bug Tracking tools: HP QC - ALM, JIRA

Database tools: MS SQL Server 2016/2012, SSMS, MS-Access, SAP HANA, Oracle 12C

Other Tools: QlikView, Tableau, AgileSim, Advanced MS-Excel, MS-PowerPoint, Google AdWords

HTML, XML, JSON, MS-Project, MS-Visio, Visual Paradigm, SAS, Google Analytics, Unix

Satellite Image Analysis, Machine Learning, Statistical Analysis, NumPy, Pandas

EDUCATION

The University of Texas at Dallas May 2018

M.S., Information Technology, and Management GPA: 3.53

Devi Ahilya Vishva Vidyalaya, Indore India June 2014

Bachelors of Computer Applications GPA: 3.79

BUSINESS EXPERIENCE

The University of Texas at Dallas - Education System

Business Analyst Intern - Dallas, Texas May 2017 - Aug 2017

•Gathered, analyzed and documented business data requirements, workflow processes and process improvements; traced requirements to deployed system to assure all requirements were met under limited supervision

•Collaborated with end users; understood workflows, and its inter-dependencies; made corrective adjustments to enhance workflow; Supported system maintenance and updates

InnoEye Technologies - Telecommunication Services

Quality Analyst - Indore, India July 2015 - June 2016

•Performed verification and validation with team and documented testing of Reliance Jio Infocomm products

•Identified, reported, logged bugs in JIRA and HP ALM and kept track to ensure specified changes were implemented

Cognizant Technology Solutions - Banking and Financial Services

Quality Analyst - Pune, India July 2014 - June 2015

•Designed and suggested alternate options, recommended corrective actions to save $5M annually;

strategized and initialized new options to prevent loss due to redundant test case creation time by 90%

•Developed UAT test plans, test cases and test data; Reported insights to development leads and project managers

ACADEMIC PROJECTS

Scrum Master (Agile Sim, Agile, Scrum, User Stories)

•Followed Agile Project Management Methodology by utilizing AgileSim and MS Project by prioritizing business objectives, features, stories for each two-week sprint, and leading daily stand-up meetings

•Managed and coached team of 10 virtual software developers and testers and covered maximum user stories

QlikView Developer (QlikView, ETL, SSMS, Excel)

•Designed, developed, and implemented QlikView dashboards. Integrated data sources and databases with QlikView

•Created data queries and reports using QlikView, SQL Server Management Studio and Excel; Created custom queries/reports designed for quality verification and information sharing

•Performed detailed analysis of source systems data and modeled that data in QlikView

Data Analyst (SSIS, SSAS, SSMS, SQL, MS SQL Server 2016)

•Created Primary data warehouse and browsed via SSAS cubes; analyzed Sales by Date, Region and Product category

•Used different tasks, transformations, containers and source/destination components to create SSIS packages and browsed through SSAS cubes to drill down data in SSMS for OLTP system

Business Analyst (Documentation, Use Cases, Process Improvement, MS Visio, Visual Paradigm)

•Developed automated system for UTD Activity Center by project planning, sequence diagrams, context diagram in visual paradigm and MS Visio to cut down manual efforts and costs by 60%, thus revised process

•Produced provable set of analysis deliverables and used them to design and implement solution

•Translated business requirements to technical requirements in conjunction with technical team and documented technical software specification and use cases

Contact this candidate