Salesforce.com AdministratorSalesforce.com Business Analyst

Worked on projects supporting application and reporting enhancements, new interfaces, technical upgrades, data validation, and architecture consolidation for CARES – a highly customized business-critical BMC Remedy Action Request System based application used to track customer requests for technical support, parts, and field intervention services.• Analyzed business, data and system requirements for enhancement features, meeting with feature owners to define requirements and present findings, creating requirements documents and functional designs, reviewing technical designs and sprint plans with offshore development team, and planning and executing functional and regression testing. Analyzed and mapped processes (current state / future state).• Led integration efforts with Genesys call center application and IVR, as well as integration with Blue Planet SAP. Coordinated and conducted end-to-end testing of interfaces between source system, EAI and CARES, ensuring that the system interfaces functioned as expected.• Managed architecture consolidation project in UAT and production environments by planning and monitoring data loads, including identification and resolution of problem data, validation of tables, views, and indexes, table sizing estimates, coordination of database tuning, and determination of SQL execution performance, ensuring successful deployment.• Prepared and managed UAT for CARES projects by validating environment and status of code porting, daily status calls and meeting notes, issue and defect management, and coordination with IT and business teams. Created knowledge transfer session materials and delivered to business partners.• Executed and analyzed performance and stress testing for Remedy and customer web application. Validated production deployments, ColdFusion and Remedy upgrades, and UAT readiness by conducting regression, smoke and functional tests as needed.

• Managed highly respected Pivotal CRM team, consistently achieving project goals on time and on budget. Team was awarded company honors for project success, innovative development techniques, and for “Value-Add Project of the Year”.• Instituted agile development methodology to deliver new functionality every 4 – 6 weeks, enabling the application to keep pace with company priorities in a rapidly changing market. • Successfully managed projects including CRM enhancements, custom Blackberry application, data warehouse integration, business intelligence and sales reporting, and territory restructuring.• Assisted IT on achievement of ISO 9001:2000 certification through committee participation, team leadership, and internal and external audit involvement.

• Analyzed business and system requirements, designed and executed functional and integration system tests, reported results and generated defect records for Pivotal CRM. Escalated issues to developers and verified fixes.

I worked as an IT Consultant for nearly 10 years and gained excellent experience in a variety of industries, projects, and roles. Companies included BP Amoco, Joint Commission (JCACO), McDonald's, Hu-Friedy Manufacturing, and Wachovia Securities. Project roles include business analyst, data analyst, quality assurance analyst, and application developer.

As a consultant for Greenbrier & Russel, I worked on the following teams:Data Quality Team• Researched data quality issues in areas of human resources, broker, branch, security, and account data in large brokerage data warehouse to identify root cause, determine solutions, and manage resolution. Data analyzed included master, transactional, and metric data. • Provided analysis of data quality issues to application development teams for code remediation, assisted in development of project requirements, and aided with testing of programming modifications. • Profiled data for business process owners to identify trends, anomalies, and business process change.Prudential Merger / SouthTrust Merger Integration Team• Gathered and documented business requirements for historical data and integration needs for business and IT stakeholders and helped developed the historical data approach for the data warehouse for the mergers.• Worked with multiple data providers to identify, map and source required data.• Developed metadata documents to document table structure, source data, and transformation rules.• Created detailed data loading, transformation, and metric rules for use by ETL developers.• Validated data files, created and executed test plans to validate data loaded to data warehouse tables.• Interrogated the data warehouse loads after financial conversions in BETA to ensure data integrity.

• Led Human Resources Information System (HRIS) vendor and package evaluation, selection, and implementation. Compiled, formatted, and imported HR data from multiple sources.• Led employee data integration efforts between HRIS, ERP, and Shop Floor Control systems in SQL databases. Determined requirements for system interfaces, mapped data, created and executed test plans, and documented flow of data for users and administrators.• Gathered business requirements and developed Project Tracking application for use by senior management to effectively track corporate initiatives and associated projects, project progress, project budgets and ROI. Created user guide and training materials, and trained senior management users on the application.

Lotus Notes application development

Performed Lotus Notes / Domino full lifecycle application development, server installation and administration, user training, and user support. Also, created user and system documentation for Lotus Notes environments and database applications. Mentored Lotus Notes administrators and developers on best practices.

Lotus Notes application development

• Responsibilities included project leadership, supervision of network administrators, departmental budgeting, Lotus Notes administration and development, and user training. Reported directly to CFO.• Implemented Lotus Notes company-wide for Notes Mail and data collaboration. Gathered requirements, designed, and rolled out databases for sales and customer order analysis and executive dashboard..

• Responsibilities included Netware WAN administration; Fourth Shift ERP database administration; hardware and software installation, configuration, upgrades, and troubleshooting; help desk; and creation of system documentation. • Implemented and supported mission-critical ERP system. Installed and maintained software and hardware, created system procedures, ran daily batch processing, imported/exported data, and trained and supported users.