Sales Project

Meghana Ramesh

Phone: 408-***-****; Email: *************@*****.***

SUMMARY

Hands on Jr. Data Analyst with excellent experience in Tableau, Python, SQL and Advanced Excel.

Experience in coding complex SQL queries and stored procedures.

Hands on using MS office and Proficient in: Word, Excel, PowerPoint, Outlook, Visio, Access

Trained and experienced working with SQL Server and Oracle and solid SQL coding skills.

Eager to advance and gain additional knowledge in the Machine learning and Data analysis industry.

Provided remote service support and customizing for the SAP security

Seeking to apply learned knowledge of Machine learning from my Master’s.

Strong understanding of accounting concepts, AP, AR, GL, Journals, Inventory management and methodologies.

Understanding of Financial modeling and analysis.

Extensive experience with object oriented analysis and design and developing use-case models.

Excellent Documentation skills and experience creating BRD, FSD, Project Charter, Use Case diagrams, Wireframes, Test Cases

Experience in working with various SDLCs like Waterfall, Agile methodology.

Understanding of DB concepts & languages like RDBMS, R, SQL, HTML, C++ Hard working and willing to learn new concepts and tools.

Excellent communication, technical, analytical, problem-solving and leadership skills.

Positive attitude and highly motivated personality.

A go-getter who loves to be with people and with ardent desire to learn. TECHNICAL SKILLS

Languages/Databases: R, MS Access, C, C++, SQL, Teradata, Oracle, MySQL, SQL Server Analytics Tools: Tableau, MS Excel, R, Python

ETL/ Reporting: Informatica, SAP, Control-M, Business Objects, Cognos, Project Utilities: Microsoft Excel, Microsoft Word, PowerPoint, Visio, Access BI & Analytics skills: Data Mining, Visualization, Statistical Analysis, Predictive Modelling, SURF Data Mining: Variable reduction, Segmentation/clustering techniques, Time series analysis Project Management: JIRA, MS Project, Agile, Waterfall, Requirement Analysis EDUCATION

Bachelors in Commerce and Computers Jul 2013 - May 2015 St. Mary’s College, Hyderabad India. GPA of 3.6

MBA in Management Information System Jan 2016 - Jul 2017 Lincoln University, SF, USA

EXPERIENCE

Bag’n Baggage, San Jose, CA Mar 2016 – Aug 2017

Jr. Data Analyst

Developed dashboards, reports with KPIs in Tableau 10 to analyze customer, inventory data to build strategic planning solutions.

Developed month end reports with key metrics, visualizations, Trent Charts, Histograms, and created excel pivot table ad-hoc reports.

Implemented interactive reports, transactions, and SAP scripts.

Tested custom SAP transactions to ensure proper functionality.

Analyzed transaction data to discover patterns and design price optimization strategy.

Worked closely with ETL developers and helped analyze and transform data using ETL Informatica

Used Oracle SQL to conduct query-level analysis of search results to derive insights and investigate for customer conversation and sales.

Responsible for 52 stores inventory, AP, AR, Journals using QuickBooks and RetailPro.

Communicate with vendors and customers while responding to inquires. Support to merchants and provide troubleshooting and technical support via phone, web-based tools and email.

Document and maintain supporting documentation for audits.

Advice merchants regarding the best implementation practices and address merchant's issues.

Created expense report and company forms using MS Excel and RetailPro.

Resolve discrepancies in the slip inventory, purchase items list and packing quality records.

Committed, flexible, and have demonstrated an ability to maintain elevated levels of productivity with minimal supervision.

Chevrolet division (General Motors), Hyderabad, India Apr 2013 - Jul 2014 Reporting Analyst

Created project charter defining project goals, objectives, identifying scope, resources allocation, budget, timelines, and financial forecasts.

Created catalogs, course guides and training brochures for sales reps to help understand complex product features and improve sales.

Performed ongoing customer/market research and demographic profiling to identify and capitalize on unmet market needs ahead of the curve.

Provided value-added analyses for new product strategic planning and expense management.

Generated more stickiness for daily unique visitors by instituting a Deal of the Day program: the number one most clicked ad running on the site with a click rate of 5%. DNA, Hyderabad, India Mar 2012 - Aug 2012

Financial Analyst

Created performance reports and ad-hoc analysis, to assist sales and management team in evaluating progress.

Managed all monthly, quarterly, and annual division financial results analysis.

Compiled data to generate financial statements including cash flow, P&L, and balance sheet for review by management.

Analyzed financial activities using excel (Vlookup, Pivot Tables, Formulas, etc) for monthly close process, balance sheet account valuations. reconciliations, expense budgeting, forecasting, and expense allocations to product lines.

Contact this candidate