Microsoft Office Management

Yash Dwivedi, MBA

**** *, ****** ****, *****, Arizona 85281 805-***-****

************@*****.*** www.linkedin.com/in/yashdwivedi

IT & Business Analyst

Driven IT & Business Analyst who delivers comprehensive analytics and insights that drive executive-level business planning, financial management, and the development of technical projects, employing knowledge of technical applications, programming languages, accounting and budgeting processes. A motivated problem solver with an aptitude for innovation and solutions development. Communicative and personable team member who will benefit a top organization by combining technical, financial, strong analytical skills to drive productivity and savings.

Areas of Expertise

Financial Modeling & Forecasting

Computer Proficient

Requirements Gathering

Report generation and analysis

Performance Metrics & Analytics

Client Communication

Microsoft Office/ Pivot/ Dashboards

Excel in Data Analysis

Intermediate in PL/SQL development

Team Collaboration

Result Oriented

Negotiation

Technology Proficiencies: Programming Languages (JAVA, C, C++, MS-ACCESS, HTML, JS), SQL,

Microsoft Office Suite (including Excel and Visio)

Education

Master of Business Administration, Finance – GPA 3.63 – 2016

California Lutheran University, Thousand Oaks, CA

Bachelor of Information Technology – GPA 3.5 – 2013

University Of Mumbai – Mumbai, India

Research – Image Encryption and Decryption using Hybrid and TPC using DWT: Embedded secret data via image compression by utilizing a Discrete Wavelet Transform with error detection through Turbo Product Code in MATLAB. Enhanced security and improved the compression ratio of image analysis by developing a modified version of DES.

Skills

C, Computer Networks, consulting, Conversion, CRM, CSS, Cision, data migration, databases, database, designing, E-business, Embedded C, English, ERP, XML, Finance, forms, Hindi, HTML, Image Processing, International Business, Java, JSP, JavaScript, knowledge management, Managerial, Managerial Accounting, Marketing, Excel, Microsoft Office, PowerPoint, Word, Operating Systems, PL/SQL, coding, quality, Real Time, SDLC, Servers, scripts, SQL, Statistics, Strategic Management, UNIX, Business Communication, Business process, Visio.

Professional Licenses & Certifications

Master Certification in Business Analysis – in progress Villanova University Online

Project Management, IS/IT Professional Elective

Microsoft Excel 2013 Certification – 2016 Vision Training System

Professional Experience

HEALTH WELL, Beverly Hills, CA 3/2016 – 7/2016

Market Research Analyst Intern

Collect, analyze, and manage market and public relations data using the Cision PR database and Google Analytics. Leverage data to identify trending blogs and bloggers whose content focuses on key products, services, and industries relevant to company products as well as current marketing and PR strategies.

Key Accomplishments:

Develop a network of brand ambassadors by analyzing and screening profiles to identify industry influencers.

Research market trends to deliver current, accurate data for constantly evolving web content.

ANNAPURNA BUILD CON INFRA PVT. LTD., Mumbai, India 8/2012 – 8/2014

Business Analyst

Collaborated with senior managers and customers to gather business requirements, and analyzed and translated requirements into functional specifications for the design and implementation of customized products and services. Drove process and design improvements by designing and executing test cases, User Acceptance Testing (UAT) plans, and Unified Modeling Language (ULM) development. Leveraged Visio to develop diagrams, flow charts, and sequencing models. Facilitated strategic planning and executive decision-making by developing sales and financial forecasts, planning and creating budgets, and tracking costs to identify savings opportunities.

Key Accomplishments:

Implemented all Phase of SDLC activities: participated in knowledge management activities: Interface with the internal team to ensure high- quality deliverables with the guidelines of the organization.

Led a team of Four new recruits, trained them and monitored their performance.

Develop detailed assessments, business requirements, process flows and other documentation as needed to understand the use case/life cycle of electronic document management for all the internal departments at Annapurna Build.

Foster a collaborative and results driven environment among stakeholders. Worked effectively across teams to achieve shared goals and objectives; value open communication and kept all stakeholders apprised of essential information.

Created and Modify databases, which consisted of customer information and products as per stakeholders' specifications.

Create functional requirements, and reports on databases. Design and develop database architecture. Design, develop and test new and existing databases. Develop database management systems for easy access, storage and retrieval of data.

Create Tables, Table Partitions, and Indexes. Organize and improve functionality of data.

Spearheaded the development of marketing and financial strategies to boost revenue and sales volume.

Cultivated strong client partnerships by analyzing performance metrics against Service Level Agreements and presenting results to clients and senior managers.

Trained new folks on board to enable them to understand the process, work flow and applications.

BONSOIR ARTS PVT. LTD., Mumbai, India 6/2011 – 9/2011

Technical Trainee

Improved the efficiency of multiple departments and processes by developing a new intranet landing page that automated product-based services, utilizing HTML/CSS, JS, and jQuery for website development.

Language

English Hindi Gujrati Punjabi Marathi