SUMMARY:

• Over 11 years of experience in Category Management, Business Intelligence and Supply Chain technologies in Healthcare, Retail, and Entertainment Industry.
• Experienced professional in Business Intelligence and Data warehousing space with hands - on experience using tools such as Microstrategy®, Teradata, Informatica, Business Objects, Tableau
• Excellent track record of supporting Category Management functions and working with Category Management applications - JDA Space Planning, JDA Space Automation, JDA IKB
• Well versed in managing projects related to Business Intelligence, Merchandising, Supply chain, and Category Management verticals
• Hands-on work experience with Media & Entertainment and Retailing environments
• Excellent Organizational, Interpersonal, written and verbal communication skills

TECHNICAL SKILLS:

Business Intelligence & Data warehousing tools: Microstrategy, Business Objects, Teradata, Netezza, Rapid SQL assistant, Teradata SQL assistant, Informatica, Tableau

Project Management tools: MS Project, MS Visio, MS Excel, MS Powerpoint

Supply Chain Technologies: JDA Intactix Space Planning, JDA Intactix Space Automation, JDA Intactix Knowledge Base

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Manager, Application Managed Services

Responsibilities:

• Managed the development and support of Category Management (CatMan) applications which includes Microstrategy®, JDA Intactix applications, Informatica, and Teradata
• Managed the projects related to Promotion Planning, incorporating new Digital/Physical Retailer/Industry into existing data model, TV episodic data analysis, and Fixture data analysis
• Managed daily/weekly Vendor (Retailer & Industry) Data delivery and loading for CatMan data reporting
• Performed daily/weekly status reporting (s, risks, issues, action items, etc) for project stakeholders and Senior Management
• Interact professionally and effectively with Project stakeholders (Both IT and Business), Global Category Management teams, and IT divisions within the company, through verbal and written communications
• Involved in gathering, understanding and documentation of business requirements, analyzing and optimizing the business processes and converting user requirements into Business requirements for a Datawarehouse development project using Netezza as Database, Informatica as ETL tool, and Microstrategy to build visually appealing dashboards.
• Worked with and managed the functional and reporting team of 9 people to clarify user requirements for building visually enhanced and effective dashboard reporting
• Managed the development and support of Microstrategy Architecture, Microstrategy Objects (Attributes, Metrics, Filters, Prompts, Reports)and Web and Mobile Dashboards for a Datawarehouse development project for a major division in the company
• Managed the Microstrategy Administration activities including Licensing, Upgrades, security rules for data access, report/dashboard scheduling, and configuration of I-server, Web server, and Mobile server
• Responsible for day-to-day operational support to approximately 40 end users of Microstrategy and JDA applications
• Responsible for developing and maintaining analytical and operational reports using Microstrategy through Microstrategy Desktop and Web interface
• Responsible for managing the Global Planogram Process systems design to assist Category Management division by creating, loading, and maintaining the Retailer Planogram data on a weekly basis
• Responsible to execute Assortment Optimization process and provide space allocation recommendation for the Product-Planogram data supplied by Retailer accounts
• Resposible for constructing the Functional design specifications and end user documentations

Confidential, Burbank, CA

Senior Business Systems Analyst

Responsibilities:

• Lead the effort in design and development of fixture data analytical reporting using Microstrategy and a Global Planogram Process using JDA applications
• Lead the effort in setting-up the Space Planning systems including configuration (building product and planogram hierarchies), security (using object level and attribute level security settings in IKB to restrict user based on the retailer account visibility), libraries (create and maintain fixture, product, and performance libraries for each Retailer), and reports (create reports using IKB advance analysis functionality)
• Lead the design and development of Data Flow, to-and-fro, from Host System (Teradata) to IKB and IKB to Teradata
• Created and maintained JDA Space Automation scripts to automate some of the manual steps in planogramming process
• Recommended specific space management metrics including tables, charts, and print layouts to aid category management teams for appropriate analysis
• Created and maintained a manual for category planners to use JDA Space Planning/Prospace/Planogramming tool
• Acted as a liaison between Category Management Business team and MIS technical team and provided operational support for Microstrategy users through Microstrategy Desktop, Web, and Office interface
• Performed loading and maintaining Retailer Planogram data on a weekly basis and providing the space allocation recommendation by running assortment optimization process on the Retailer Product-Planogram data
• Actively participated in continual process improvement, team coordination, documentation, and communication to identify workflow efficiencies for Global Planogram process designed for Category Management team

Confidential, Brentwood, TN

Retail Business Systems Analyst

Responsibilities:

• Managed Space Management System(s) including, JDA Space Planning, JDA Space Automation, JDA Floor Planning, and JDA Intactix Knowledge Base
• Actively involved in the Upgrade of JDA Intactix suite to 2006.1 version
• Actively participated in special merchandising projects involving supply chain technologies like Business Objects and SAP
• Conducted periodic sessions with Store Planning/Space Planning staff to keep them current with all functionality within all applications that may streamline user productivity
• Assisted in creating planograms on a variety of fixture configurations to support store reset execution while identifying opportunities to improve productivity of merchandising space
• Analyzed plan-o-gram productivity by recommending specific space management metrics and provided recommendations to management that identify potential opportunities to improve productivity of space
• Participated in maintaining Merchandise Planning Criteria in assigned business areas with consideration for layout, space allocation, category adjacencies, item placement and customer experience
• Supported new store opening process including labels, product alignment, plan-o-grams, etc.
• Led efforts in clarifying client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders

Confidential

Project Leader

Responsibilities:

• Planned and implemented the FIRST grocery discount store based on market research and consumer ps
• Negotiated the best payment and delivery terms with various vendors and suppliers and made profitable purchasing decisions
• Organized store operations including buying, inventory management, and merchandising
• Carried out location analysis, customer profiling, and assortment planning
• Planned and executed retail strategies focused on reaching target markets, and building loyal customer base.
• Planned and implemented events and marketing activities for retail pharmacies which increased the customer retention by 16% and customer acquisition by 67% over previous quarter
• Developed new merchandising strategies, using display space effectively to maximize sales
• Conducted weekly customer data analyses using MS EXCEL and SQL
• Reviewed marketing activities performance through proper customer feedback system
• Communicated effectively with customers regarding feedback and suggestions
• Actively participated in the process of obtaining ISO 9001:2000 and served as an Internal Auditor
• Generated contents for websites
• Conceptualized and designed storyboards for multimedia projects
• Coordinated between clients and technical team to ensure the delivery of satisfactory service
• Performed requirements validation, and quality assurance