SUMMARY

• Hands on Data Analyst and Product Management with excellent experience in Tableau, 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 noledge in the Data analysis industry.
• Provided remote service support and customizing for the SAP security
• Seeking to apply learned noledge 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, Sequel Pro

Analytics Tools: Tableau, MS Excel, ActiveAdmin, Python

ETL/ Reporting: Informatica, SAP, Control-M, Business Objects, Transmit 5, CFF

Project Utilities: Microsoft Excel, Microsoft Word, PowerPoint, Visio, Access, Mission Control

BI & Analytics skills: Data Mining, Visualization, Statistical Analysis, Predictive Modelling, SURF, Tableau, SAP BO

Data Mining: Variable reduction, Segmentation/clustering techniques, Time series analysis

Project Management: JIRA, MS Project, Agile, Waterfall, Requirement Analysis

PROFESSIONAL EXPERIENCE

Confidential

Product Data Manager

Responsibilities:

• Aggregate, clean, normalize, and visualize data from Teradata, Excel spreadsheets and other sources.
• Querying large data sets using Custom SQL and conducting ad-hoc analysis.
• Data driven approach for competitive analysis (Software/ Hardware / Price points / ASPs) and Performed Business analysis / forecasting / quantitative sales and market analysis for a complex multi-billion-dollar market to aid critical decision making.
• Analyzed and Improved existing dashboards and reports by reengineering existing SQL queries & automated data quality checks.
• Track product success metrics and present at Quarterly Business Reviews to leadership by creating Dashboards on Table.
• Work on huge Bookings & Revenue Datasets for existingproducts by creating Reports, Analyzing & Forecasting the bookings to halp cross functional teams such as manufacturing, supply chain, engineering in planning & reducing the lead time for product delivery.
• Automated the flow of manually pulling the data by connecting Teradata to Tableau & creating Dashboards defining Product stories & trends using multiple KPIs.
• Product Manager:
• Define product strategy - Includes driving product technology requirement, maintainingproduct roadmaps, feature priorities and product positioning
• Write Product Requirement Documents and User Stories to define user flows for the next genproducts
• Develop collateral such as datasheets, spec sheets, FAQs, NDA decks, product migration documents, white papersetc. to articulate value propositions and competitive advantages for technical and non-technical audiences & worked with Technical Marketing engineers to drive successful proofs-of-concepts, early field trials, and engage in marketing activities at various trade shows.
• Work in a Waterfall, Agile/SCRUM and hybrid of Agile and Waterfall implementation environment.
• Defined detailed product requirements including business cases, high-level use cases, technical requirements, revenue impact, and ROI.

Confidential

Data Analyst

Responsibilities:

• Driving data analysis to identify and solve problems as they arose within testing and development of the app.
• Established new processes which assisted in and improved data accuracy and validation.
• Created and validated spreadsheets with up to tens of thousands of cells, verified thousands of pages of written records, and delivered accurate reports day to day.
• Confirmed to Good Documentation Practices across all records in adherence to FDA standards.
• Used Sequel Pro to query complex medical eligibility data and built complex functions.
• Used CFF tool for Configurations and Implementation. Created Readers to automate the eligibility data to process.
• Dealing with large sets of imperfect medical eligibility data to process it
• Developed in-depth understanding of underlying data, data structures, and business uses to ensure reports meet customer needs.
• Developed and produced dashboards, key performance indicators, and metrics to monitor and report on activities.
• Review data from multiple sources and maintain database.
• Research and resolve data load (ETL) issues from different data environments.
• Creating test users and SSO (Single Sign on) for the Quality Assurance(QA)
• Communicating with Direct Customers when Issue in the Data or User information.

Confidential

Jr. Data Analyst

Responsibilities:

• 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.
• Monitored and verified data accuracy within the ERP system and sales forecast tools.
• Analyzed transaction data to discover patterns and design price optimization strategy.
• Worked closely with ETL developers and halped 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.
• Was responsible for developing a custom reporting system for each client
• 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.
• Established and led monthly collaborative process between purchasing, production, sales and marketing with respect to sales forecasts and marketing promotions to ensure inventory was available for customers and product promotions/launches
• Committed, flexible, and has demonstrated an ability to maintain elevated levels of productivity with minimal supervision.

Confidential

Reporting Analyst

Responsibilities:

• 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 halp 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.
• Developed new ways to forecast client product needs and used dat information to create purchasing forecasts.
• 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.