SUMMARY:
- Enterprise System Implementation Data Mapping & Migration Public Speaking/Presentations
- Business Systems Analysis Test Plans/Coordination User Training
- Requirements Gathering Staff Supervision & Development Technical Documentation
- Proficient in Blackbaud Enterprise CRM, Ellucian Advance, SQL, InfoMaker, Access, Excel, Visio,
- MS SQL Server, MS Team Foundation Server, Sharepoint, MS Project
PROFESSIONAL EXPERIENCE:
Senior Business Analyst
Confidential, Woodland Hills, CA
Responsibilities:
- Gather and document requirements for data mapping from AS400 legacy system to InsPro system.
- Configure the InsPro system to process long - term care insurance applications and claims according to LifeCare’s requirements.
- Gather and analyze business requirements, and write BRD, for Joint Policy system modification.
- Code policy rating programs for client companies in the InsPro system.
Business Systems Analyst
Confidential, Woodland Hills, CA
Responsibilities:
- Conducted requirement gathering interviews, wrote business requirement documents, and created process flow diagrams in Visio for new features for company website, which processes international payments and currency trades for clients.
- Wrote test cases and conducted testing of business requirements for Quality Assurance.
- Participated in strategy sessions for developing straight-through processing of payment data.
- Prepared website copy for language translation for the company’s foreign websites.
Senior Systems Analyst
Confidential, Los Angeles, CA
Responsibilities:
- Lead Data Migration Analyst for major system conversion project to implement Blackbaud Enterprise CRM donor/fundraising system, replacing legacy system.
- Mapped donor financial and biographical data from in-house donor database to appropriate fields and tables in Blackbaud Enterprise CRM donor/fundraising system.
- Performed gap analysis and documented results and recommendations for portions of Blackbaud system.
- Created test plans, wrote SQL testing scripts, and documented data migration to Blackbaud Enterprise CRM and reported results to executive stakeholders.
- Acted as SME for data mapping and cleanup portion of the implementation in stakeholder meetings.
- Created data dictionary for in-house donor database.
- Analyzed data sources, gathered requirements, determined business and process rules, and coordinated data cleanup efforts in preparation for conversion to Blackbaud Enterprise CRM.
Programmer/Analyst
Confidential, Los Angeles, CA
Responsibilities:
- Lead Business Systems Analyst and Data Consultant to fundraising staff for post-conversion data integrity, online reports, and projects such as donor honor rolls, donor prospecting, data dictionary, and automated address updates.
- Gathered requirements, determined business and process rules, wrote technical specifications, and tested automated process for address/contact information updates for over one million donor records.
- Documented and categorized business and process rules for database underlying Business Rule website.
- Data Management Administrator for the Advance system. Determined coding policies, strategies, restrictions and business rules; managed Advance TMS coding. Responsible for data integrity.
- Created data dictionary that cross-referenced old location of donor data in mainframe system to new location in Advance.
- Supervised and trained two employees to code ad hoc reports in SQL.
Programmer/Analyst
Confidential, Los Angeles, CA
Responsibilities:
- Lead Data Migration Analyst for major system conversion project to implement Advance version 9 donor/fundraising system, replacing existing mainframe system.
- Gathered and documented technical specifications for migration of biographical, committee, degree, activity and alumni membership data on donors and prospects from mainframe system to Advance donor/fundraising system.
- Designed, wrote specifications, tested and documented Departmental Computing component of Advance.
- Wrote user manual for Departmental Computing and updated as necessary.
- Conducted training classes for users on Advance Departmental Computing, Advance club system, and Advance online reports.
Programmer/Analyst
Confidential, Woodland Hills, CA
Responsibilities:
- Analyzed data and coded Access programs to produce ad hoc reports on workers compensation insurance.
- Performed extracts of daily claims data for download to custom processing system
