SUMMARY:

• I have been in the Technology Industry for over 10 years in a variety of positions that have given me an excellent background.
• My overall focus has been Data Management from how data flows from system to system to the overall integrity and quality of that data.
• I gained this focus through positions as a Data, Business, Power BI, and Business Intelligence Analyst, as well as Project Management experience. I feel I am most valuable to a team if used in one of these 4 areas.

TECHNICAL SKILLS:

Power BI Desktop: Used Desktop application to develop multiple dashboard reports, published to online service for project, instructed company IT people how to use, get setup, etc with Power BI Service.

Power BI: Used Power Query and Power Pivot to create PowerView reports. Used Q&A to enhance results

SQL Server 2008/05: Complex queries, very adept at data investigations through large db’s.

MS BI Stack (SSIS/SSRS/SSAS): Developed ETL Processes, created reports.

Excel: Pivot Tables, Reporting, Functions, V - Lookups, etc.

Quantrix: Managing data set, updates, forms

PROFESSIONAL EXPERIENCE:

Confidential

Technical Program Manager

Responsibilities:

• Utilizing Power BI Desktop and Power BI Online to design and develop multiple dashboard reports with a variety of visualizations and data sets to produce a complete picture of the clients reporting needs.
• Write and develop complex DAX formula’s and measure’s to get key metrics for reporting.
• Extensive Data Modeling and formatting of data to make the dataset more usable for reporting, created and edited relationships between the data tables, designed the dashboards and organized the visualizations for optimal reading and navigation.
• Published reports to Online PBI Desktop service for demo’s to clients, would have weekly meetings to do this to ensure client satisfaction with work done to date.
• Trained client IT group on how to use PBI Desktop and documented all steps used in developing reports and all coding/logic behind them.

Confidential

Business Intelligence/Logistics Analyst

Responsibilities:

• Utilized PowerBI and Excel to create Logistical Models for future World-wide product launches/releases for some of Microsoft’s top products using complex Excel sheets with multiple formulas, vlookups, etc.
• Used Quantrix to manage World-wide MS Sales data to update, retrieve, and position this data for team wide use
• Responsible for sending out weekly and monthly shipping forecasts for Ocean and Air freight as well as Phone data using multiple lanes and modes of transportation. Would put together these forecasts, verify integrity of the data, and troubleshoot/escalate issues regarding the data. Operate as the Main point of contact for a variety of teams utilizing these forecasts.
• Performed ad-hoc analysis using SQL and Excel DB’s to retrieve complex data and then present it to stakeholders in a clear and concise manner.

Confidential

Power BI Analyst

Responsibilities:

• As part of the ISRM team I monitor and record all Security hacks and breaches around the world and input that data into an Access SharePoint site. Would do extensive research of popular websites and blogs to obscure sites to retrieve necessary information about the security threats.
• Utilized the Access data to create various complex Power View reports. Would create these using complex calculations in Power Pivot and joining various tables using Power Query. Also utilized Q&A to ensure success in search results using synonyms, phrases, etc. Worked with Microsoft Power BI team to suggest future enhancements and key areas that the application is lacking.
• Managed SharePoint and Yammer sites to ensure content was delivered and in some cases drive discussion. Responsible for design changes to SharePoint forms and suggest modifications.

Confidential

Program Manager/SDET

Responsibilities:

• As part of the Live Config team, I would use Team Foundation Services to track and resolve issues regarding configuration issues with 1PP/3PP Xbox games. Would work with Internal SME’s/PM’s and External Publishers to get the right data entered in and validate its integrity.
• Using internal tool XDP to enter in the manual configurations like Game s, Rules, Artwork, Game Strings, etc. Would need to deal with a lot of ambiguity from the Partners to effectively understand what changes they wanted made and implement them. Had to deal with daily changes to systems and procedures while maintaining data integrity in an extremely High Profile environment as the config is for games to be played in the new Xbox One.

Confidential

Business Intelligence Analyst

Responsibilities:

• As part of the Xbox BI Team we gather all Point-of-Sale data for Xbox and the entire gaming industry and put it together in various Pivot table files for intelligent review by all Xbox PM/Marketers. I am responsible for the retrieval, import, processing, mapping, cleanup, quality, and posting of the POS data.
• I would accomplish this by running and sometimes modifying various ETL Packages in SSIS in the SQL Server Business Intelligence Development Studio, executing SQL Queries and Stored Procedures, and updating/refreshing the existing Pivot table Excel files to reflect the most current data.
• My duties would also require in-depth Data Mining on Game data by tracking it down from multiple internet sources varying from Industry leading sites to obscure foreign sellers. Constantly researching new attributes and data points to improve MS Marketers ability to predict the Gaming Industry trends.
• Helped migrate existing SQL Server DB to new data-storage system MDS (Master Data Services) and participated in discussions on data improvements, and improved user experience. Relentlessly worked to make the new MDS system a mirror image of the old system by re-mapping existing data and educating users on the benefits of the migration.

Confidential

Business Analyst

Responsibilities:

• Working in MS Product’s Data Governance group to effectively manage how product data is used by various organizations inside MS Product and also worked on the data migration project from a flat file storage system to an online database application (Rio).
• Created process to update content inside MS Product by developing process-flow diagrams, RACI’s, Visio docs, PPT presentations, etc. Gathered requirements for Rio, organized and drove PDM meetings to resolve ambiguities of gathered requirements, created functional specification, analyzed and identified term and business attributes, and also finalized the definitions during the PDM meetings.
• Documented schedule, milestone, rolling out plan, and maintenance and sustain plan of the tool.

Confidential

Business Analyst

Responsibilities:

• Working in Microsoft’s Global Marketing Platform group, specifically EMMA User Support to correctly analyze current problems in their Marketing database systems and provide solutions by effectively using SQL queries, data analysis, and testing skills.
• Manage and run weekly meetings dealing with User quality from all over the US and in certain times - worldwide. Organize, manage, and drive weekly meetings with worldwide team to assure the User QA and are compliant in business specs.
• Other skills utilized include setting up SQL jobs on various servers, and DTS data list to various servers for data analyst to use. Also responsible for updating team operational functional specifications and communicating these updated specs and server status with worldwide users.

Confidential

Project Manager/Database Analyst

Responsibilities:

• Performed as a Project Manager for the Release Service Management (RSM) group to complete a Security Project. Developed and maintained security policies to ensure compliance with business and corporate specs for external/internal access to Intellectual Property.
• Developed and implemented daily/monthly audits and queries using SQL in regards to security and access compliance. Reviewed Ad-Hoc queries and reports from analyst for security validation and procedure.
• Validate and grant system access to internal and external clients, and monitor high level activities in the system for analyst to follow up on issues. Also review on existing ASP and XML files for verifications and modification suggestion.

Confidential

Support Analyst

Responsibilities:

• Worked in the MSN Operations Team supporting production Search Dataflow system. Responsible for daily operation and maintenance of approximately 50 data feeds.
• Involved in troubleshooting job failures by performing both systems and data analysis using SQL Server, running of T-SQL queries. Communicated with Search Program Management to clarify customer needs and to relay status updates.
• Managed the knowledge base and converted it from Access to a SQL 2000 database.