Business Analyst / Programmer

CYNTHIA CASTILLA

**** ******** ** *** *** • Springdale, AR 72762 • Cell: 956-***-**** • Email: *******.********@*****.***

BUSINESS PROCESS IMPROVEMENT • APPLICATION DEVELOPER • LEADER

Business Analyst / Developer with a verifiable track record of executing complex IT projects and exceeding expectations. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reduce costs. Experience in implementation/maintenance of Product Data Management, Workflow Applications, and Walmart Retail Link Data Warehousing for a foodservice multinational corporation. Able to build strong, sustainable relationships with internal and external individuals. Consistently delivers the correct solution on time and within budget.

CORE KNOWLEDGE & SKILL AREAS

 Retail Link Sales Solutions

 Product Specification Workflow

 Project & Delivery Methodologies

 Business Intelligence

 Project Risk & Scope

 Budgeting & Planning

 Process Analysis & Redesign

 Relationship Building/Cultivation

 Project Management & Tracking

Proficiencies: HTML, C#, T-SQL, PL-SQL, XML, AJAX, ASP.NET, ADO.NET, VB.NET, JavaScript, CSS, ASP Classic, ADO Classic, UML

Exposure: SSIS, SSAS, SSRS, SSAS, Web Services, COBOL, C++, Pascal, Assembly Language, VBA, SAP MM

Database Systems: ACCESS, SQL Server, Oracle, working knowledge of relational database technology

Tools: SQL Server Management Studio, MS Access, TOAD, MS TFS, VSS, MS Visual Studio, MS VISIO, Microsoft Project, Quality Test Professional / HP Quality Center (TestDirector), SharePoint, BMC Remedy, ER Studio, Adobe Photoshop, MS Office

RELATED EXPERIENCE

TYSON FOODS INC., Springdale, Arkansas 2007- Present

Largest meat producer in the world, Forbes’ one of the 100 largest companies in the United States

Business Analyst/Computer Programmer, IS Sales & Marketing

Notable Projects include:

Product Data Management (PDM) - An ORACLE® Product Specification System that serves as a central knowledge repository for process and product history, and promotes integration and data exchange among all business users that interact with Tyson product specifications.

 Provided customer service and problem solving to R&D, Specs & Labeling, Marketing and other various departments

 Formulated and executed test plans for implementation

 Wrote Quality Test Professional (QTP) scripts to input mass data into a third-party system

Tyson.com - Global website for Tyson information.

 Developed and modified Tyson.com Consumer, FoodService, FreshMeats, and Project A+

Master Data Request System (MDRS) - A .Net Material Management workflow application that provides quality control of purchasing and ordering materials, and the standards involved in ordering, shipping and warehousing those parts.

 Planning, analysis, design, implementation and testing of various enhancements.

 Created functional and technical specifications

 Involved in investigating, reviewing and troubleshooting key areas of production supportability

 Performed structured modifications of existing software system through standardized change management processes

Tyson Retail Analytics (TRA) - A data warehouse and application solution utilizing Walmart Retail Link sales data to support decision making.

 Provided analysis and calculations to implement the interaction of cross-functional team data and Walmart sales forecasts for further Manugistics forecasting refinement

 Analyzed Walmart Retail Link data for ETL development of data warehouse facts and dimensions

 Worked with the Tyson Walmart sales team to analyze POS data alerts to be sent internally to the sales team and externally to the store-level brokers

 Designed various SSRS reports for the sales team

 Analyzed and documented business requirements / technical needs to enhance SSAS cube

 The first phase of the project increased top line sales by approximately $1,000,000 per month

EDUCATION

Bachelor of Business Administration in Computer Information Systems, 2007: UNIVERSITY OF TEXAS – PAN AMERICAN, Edinburg, TX

MEMBERSHIPS

ASSOCIATION OF INFORMATION TECHNOLOGY PROFESSIONALS (AITP) – NW Arkansas, 2007 – Present

President

ASSOCIATION OF INFORMATION TECHNOLOGY PROFESSIONALS (AITP) – UTPA Student Chapter, 2006-2007

President

LEAGUE OF UNITED LATIN AMERICAN CITIZENS (LULAC), 2008 – Present

Arkansas State Deputy Director of Youth

 Requested speaker on the television show El Latino to inform Arkansas residents about LULAC

MINGLING WITH MENTORS, 2008 – Present

Founder/Coordinator

 Awarded “Partner in Education” from Springdale School District/Chamber of Commerce

BIZNET

Speaker/Member

 Presented successful project insights to Tyson's business analyst organization

Contact this candidate