SUMMARY

• Data Analyst with over 15 years of experience of creating, modifying and maintaining reports that involves teh use of spreadsheets, pivot tables, charts, scorecards, dashboards, involving macros, formulas and other database tools.
• Proficient in working with large big data environments to individualized datasets in sales, marketing and financial areas.
• Experience and strong working knowledge modifying queries within SQL queries.
• Experience utilizing Microsoft database tools such as MSRA (MSSales), GSX, CRM, Mercury, Explore.MS, SQL Server, Powershell, PowerBI, Office365, etc.
• Strong analytical skills, I’m willing to take on varying challenges and find effective business solutions for an organization.
• Experience creating process diagrams such as flow charts, swim lanes, UML, static class models, sequence diagrams, state diagrams, and entity relationship diagrams.

PROFESSIONAL EXPERIENCE

Confidential - Redmond, WA

Data Analyst

Responsibilities:

• Show working knowledge to produce/edit reports within Power BI
• Experience working knowledge with Licensing and Services data in Microsoft
• Experience working knowledge with Pricing Strategy/Analysis
• Develop new insights and analyses that inform decisions and halp improve teh delivery of Services and Devices
• Show working knowledge using MS Excel programming functions
• Show working knowledge to modify queries within SQL queries
• Can learn quickly in a fast-paced working environment and implement skill sets on teh spot
• Experience working in highly dynamic environment

Confidential - Issaquah, WA

Data Analyst

Responsibilities:

• Show working knowledge to produce/edit reports within MSSales
• Experience working knowledge with Licensing and Services data in Microsoft
• Experience working knowledge with Pricing Strategy/Analysis
• Show working knowledge using MS Excel programming functions
• Show working knowledge to modify queries within SQL queries
• Can learn quickly in a fast-paced working environment and implement skill sets on teh spot
• Experience working in highly dynamic environment
• Test infrastructure for End to End test scenarios

Confidential - Redmond WA

Data Analyst

Responsibilities:

• Merged data from two CRM tools into one while verifying teh migration of data into teh new Dynamic CRM tool for data accuracy
• Performed data analysis to remove data that is duplicate or inaccurate
• Identified and merged duplicate records and ensuring that records are up to date while outdated records are deactivated as appropriate. This role also requires
• Provided a keen eye for detail and good documentation
• Responsible for harmonizing multiple data sources to become CFA’s “one version of teh truth”; basis of a new integrated database system.
• Participated in designing CFA’s centralized (and restricted) database that houses all teh critical data necessary needed for Advocacy Managers and Relationship Managers to performance their job roles on a global scale.
• Accountable for providing and analyzing ad-hoc business reports with MS Sponsor to enable data-driven business decisions.
• Gathered and organized global CFA feedback to validate data accuracy to prevent data contamination.
• Applications Used: SQL SSRS; Excel pivot tables; PowerPivot; Outlook; SharePoint; Word, OneNote

Confidential - Seattle, WA

Business Analyst

Responsibilities:

• Understands teh role of each system in teh big picture. Determines how changing business needs will impact each system.
• Provides consultative and technical support. Serves as a liaison between stakeholders, business experts, and application developers.
• Conducts technical and operational research. Interprets, evaluates, and interrelates research results for incorporation into strategic decision-making.
• Compares differences between existing systems and new systems. Provides recommendations regarding system evolution.
• Works cooperatively with stakeholders to elicit business processes and user requirements. Analyzes, defines, and documents business objectives, workflow procedures, and detailed functional specifications.
• Reviews and assesses development proposals including deliverables and timeframes.
• Crafts and implements new business processes. Analyzes current processes and identifies opportunities for improvement. Documents existing processes and business rules.
• Creates process diagrams such as flow charts, swim lanes, UML static class models, sequence diagrams, state diagrams, and entity relationship diagrams. Uses process maps to capture procedures, models, and operational processes.
• Ensures current and accurate system documentation.
• Provides system training, educational tools, and support materials.
• Produces ad-hoc reports to satisfy user requests, data sampling, project analysis, or testing verification.
• Applications Used: Business Objects; Crystal Reporting; SQL SSRS, Office 365, SharePoint

Confidential - Bellevue, WA

Reporting Financial Analyst

Responsibilities:

• Work alongside finance team members within OPEX, Channel Incentives and (LSP, NSI and MPN) Resellers to halp define and recommend KPI’s
• Monitor and provide reporting from key metrics obtained from MS Sales, Mercury and ORBIT databases while managing and creating reports on a weekly and monthly basis
• Develop new insights and analyses that inform decisions and halp improve teh delivery of Services and Devices
• Devise and run scenario-specific A/B tests to directly and indirectly drive KPI improvements and analyze group-specific data and proactively make recommendations to stakeholders
• Applications Used: MSSales; Mercury; Orbit; GMO OLAP Databases; SQL SSRS; Excel pivot tables; PowerPivot; Outlook; SharePoint; Word

Confidential - Redmond, WA

CSS Business Intelligence Support Engineer

Responsibilities:

• Represented Microsoft in customer communication via phone, email, or chat to assist customers in resolving complex technical issues involving various Microsoft products and services.
• Foster positive customer relationships and build customer loyalty in Microsoft, while effectively managing challenging situations.
• Serve as member of teh SQL support team breaking ground with a new support model. Combining teh skills sets from SQL Server, Windows and Networking on a single team, means teh customer receives a single point of ownership.
• Navigated teh technical and collaborative needs between various support groups on behalf of teh customer providing seamless, single point of ownership for SQL Server issues.
• Demonstrate strong interpersonal and communication skills, while working with diverse audiences including highly technical IT professionals, developers, architects, and executive management.
• Exhibited leadership through personal responsibility, accountability and teamwork.
• Acted as a technical focal point in cooperative relationships with other companies.
• Managed crisis situations that may involve technically challenging issues and diverse audiences.
• Owned and resolved technically complex mission critical or politically hot customer issues
• Responded to customer needs which may sometimes require outside of normal business hours or on-call rotation.
• Used trace analysis, debug skills, source code, and other proprietary tools, to analyze problems and develop solutions to meet customer needs; this may involve writing code.
• Maintained strong working knowledge of released products, take ownership for product improvement, and participate in pre-release activities and BETA programs.
• Lead triage meetings to share knowledge with other engineers and develop customer solutions efficiently.
• Applications Used: SQL SSRS, SSAS, SSIS; Excel pivot tables; PowerPivot; Power BI Technologies

Confidential - Redmond, WA

Tele-Sales Support and Marketing Analyst

Responsibilities:

• Created customize spread sheets and pivot table reports based upon information received from executives, managers, directors and sales teams using internal Microsoft database tools such as MSRA (MSSales cube), GSX/RIO, SQL Server and GMO BI tools.
• Responsible for supporting SMS&P Tele Sales WW Sales, Readiness and Marketing groups with various reporting needs
• Managed reports that contained large data sets involving high revenue, products and/or licensing information
• Managed MS client’s MS ad-hoc reporting request and timelines for customized or standard pivot table reports
• Tracked multiple revenue and products report updates using internal databases to maintain accurate reporting
• Used data mining techniques to asses a problem and to coordinate and execute solutions
• Responsible for becoming proficient in new or update reporting system tools or software; Provide positive, professional and courteous communication in written and verbal formats for all internal and external interactions
• Ability to work independently or in a team environment to research innovative solutions to challenging technical problems
• Back-up peers and ensure coverage during absences and periods of peak workload sessions; I'm a supportive and proactive team player—respecting and listening to teh opinions of others as well as freely and respectfully expressing ideas
• Applications Used: MSSales; GSX/RIO; SQL SSRS; GMO BI Tools; Excel pivot tables; PowerPivot; Outlook