Salesforce IT ASD - CRM

• Elicited high level business requirements from internal/external business stakeholders • Documented high level business and system requirements, including business process, data flow, workflow and data modeling• Worked with various stakeholders to validated system and business requirements • Created high level user stories to support the AS-IS & TO-BE for the company’s asset portfolio management tool• Worked with a variety of different external & internal groups. This includes IT, Program Managers & other Stakeholders• Worked with an outside vendor as lead project coordinator on the creation and use of a BPA’s total economic value data models• Created and maintained BPA’s total economic value data model business flow and process documentation• Portfolio analytics manager and system admin for BPA’s portfolio management tool• Used Access, PowerPivot & SQL queries to performed data quality checks• UAT lead: identified bugs, identified root causes, troubleshooting, performance issues (metrics governance) & proposed next steps• Application support for BPA’s portfolio management application• Used MS Word and Excel to Script UAT requirements, Use Cases & Smoke Test Cases• Created and tracked CRM’s to add & maintained new users• Used MS Word to create user stories & business requirements for SSRS reports• Performed training sessions for up to 30 people• Created and updated large to small user manuals for TAPM and the total economic value data models• Used Visio to create & maintain data, business & workflow diagrams showing BPA’s tech landscape• Provided production support for BPA’s portfolio management tool• Performed system user audits from information being pulled in from Active Directory• Worked in a SDLC, Waterfall and Agile environment• Added, edited & prioritized documents in SharePoint• Presented my analysis to company executives through Excel, Access, Visio or PowerPoint• Created & tracked defects in Application Lifestyle Management

• Elicited high level business requirements from internal/external business stakeholders. Validated requirements• Documented high level business and system requirements, including business process, workflow and data modeling• Worked with a variety of different external & internal groups. This includes business intelligence, research & product engineering• Member of NWEA’s MAP production support team• Used Visio to create data, business & workflow diagrams for NWEA’s MAP tool• Presented my analysis to company executives through Excel, Access, Visio or PowerPoint• Created epics using MS Word and Target process. Created user stories based on business requirements. Created use cases based on business requirements• Tested and validated current and future web-based platforms• Tools Used: Scrum, Agile, SDLC Methodologies, MS Office Suite, MS Project, MS Outlook, Visio, SharePoint, Google Docs, Excel, Access, and PowerPoint

• Performed detailed business analysis on incoming/historical video on demand data. Provided quarterly & year end reports based on requirements analysis gathering• Presented business & operations analysis findings to the clients and/or Rentrak upper management• Used SQL, AWK, Access, Excel (VLOOKUP, Macros & Pivot Tables), charts and Word for requirements analysis gathering, ad-hoc analysis and presenting/reporting purposes. Elicited business requirements from internal/external business stakeholders• Provided production & application support to up to 15 video on demand cable operators (domestic & international)• Worked alongside business intelligence, third party vendors, research, IT & client service on a variety of projects• Identified, researched, implemented, and configured any changes by market & operator for all cable networks, broadcast stations & broadcast networks, domestic & international• Performed test criteria for user acceptance testing with resolution of system defects and system improvements. Assisted with developer unit testing• Coordinated projects across different departments• Liaison between IT, client service, the client, & Rentrak upper management. • Identified, researched, implemented, & configured any changes to the national subscriber counts for most to all cable networks. Worked with third party firms to update system-wide network and station availability on a daily basis. Analyzed and validated free, transactional and subscription on demand data on a monthly basis using Excel and Access.• Assured the daily arrival and processing of data feeds. Generated and forward daily status reports to corporate officers. Created and reconciled variance spreadsheets using Excel. Assisted IT department in making screen improvements and enhancements to company’s proprietary database• Coordinated on projects that lasted from 3 weeks to 2 years• Created and tracked projects with Jira and other content management systems

• Matched all incoming OnDemand title data on a daily/weekly basis. Reached 100% matching completion for all Providers. Supported the Content Manager with various research and maintenance projects

• Researched, performed business analysis and requirements gathering, projected upcoming box office grosses for several movie studio executives on a daily and weekly basis. Presented business analysis findings to company executives through Excel, Word or PowerPoint. Researched, analyzed, and collected international theatrical grosses for 27 foreign countries • Data entry of cast members, key words, and foreign language films. Verified accuracy of title information• Tools Used: MS Office Suite, Rentask, Excel, PowerPoint. Technical Environment: Windows

• (Dual role along with Technical Project Coordinator/Business Analyst in 2005). Gathered and provided detailed weekly box office analysis reports to Universal & Disney. Recorded minutes during monthly staff meetings• Presented business analysis findings to company executives through Excel or PowerPoint. Set-up travel schedules (domestic and international) and reconcile travel expense reports. Created purchase orders and check requests for satellite office• Set-up non-disclosure agreements for international and domestic consultants. Collected, reviewed, and forward timecards to corporate headquarters. Assembled box office data reports and analyzed budget variance reports • Tools Used: Rentask, Excel, PowerPoint. Technical Environment: Windows

• Analyzed and projected product placement within new DMA’s. Manage advertising placement from initial phone call to print for eight local newspapers throughout Southern California. Provided customer service by solving billing issues and other various inquiries.

• Provided around the clock technical and business analysis support for premier care customers: monitoring URLs, network connections, business plans, and firewall status. Elicited new business rules and applied them to new and existing clients. Worked along side cross functional teams• Elicited business requirements from internal/external business stakeholders. Created epics/use/user cases based on requirements gathered from the different stakeholders• Generated customer analysis reports and coordinate with one or more department managers to resolve connectivity, web hosting, application, and firewall issues based on detail analysis• Created new business plans based detail analysis. Created, tracked projects with Vantive and other content management systems. Developed and analyzed test criteria for diagnosing and resolving network issues• Analyzed daily T-1 backbone data for any issues and/or new ways to improve business flow. Elicited new business rules & applied them to new and existing clients. Worked along-side cross functional teams. Created and tracked projects with Vantive and other content management systems• Created epics/use/user cases based on requirements gathered from the different stakeholders. Elicited business requirements from internal/external business stakeholders• Tools Used: SDLC Methodologies, MS Office Suite, Vantive, Excel, PowerPoint. Technical Environment: HTML, TCP/IP, DNS, Windows, UNIX.