Jo Xin

***** ********* **.

Glen Allen, VA *****

804-***-**** acqehe@r.postjobfree.com

SUMMARY

Data Analyst and Business Intelligence Specialist with rich experiences in the financial and health services industries. Strengths include data analysis and reporting, data warehousing, relational database and data modeling, project and process management, technical writing, testing design, development and implementation, training development and facilitation.

SKILLS

DBMS: Oracle 11g, Teradata, Unica Campaign, MS Access, Unix, Mainframe, Data

Warehouse

Software/Languages: Visual Basic, SQL, BTEQ, PL/SQL, Toad, SAS EG, HTML, MS Excel, Word, Power

Point, Access, Visio, Project, Outlook, IBM Cognos Business Intelligence

Operating Systems: MS-DOS, Windows 3.1/95/7, Windows XP, Unix and MVS

Process/Reporting Tools: CTQ, SIPOC, Swimlane, RACI, Prioritization (XY) Matrix, FMEA, Control

Plan, Dashboard; Excel, Power Point, Rochade, Share point, Remedy, Clarity

PROFESSIONAL EXPERIENCE

Magellan Health Services, Richmond, Virginia - Business Intelligence Specialist / Data Analyst 2014

Worked with Business Intelligence Team on the eRebate report development and unit testing, with a particular focus on assisting the business users and operations team with verifying and validating BI reports; played a key role on the project coordination, data quality control and report implementation efforts.

Assisted developers with report design, development and testing, made big contributions to the quality of reports by identifying issues/defects at early stage and worked with team to resolve issues and fix defects before publishing them to the user testing and production environments

Performed unit testing and validated various reports for new and existing clients

Coordinated the effort on Invoice report enhancement and testing project among business users, IT Operations and Business Intelligence Team to ensure accuracy and on time delivery

Provided status reports on weekly basis to senior leadership, business customers, IT partners and testers

Developed Key Performance Indicators (KPIs) report and did business analysis for the “As of” Project

Worked as a liaison between business customers and BI team on eRebate projects

Trained new team members on eRebate reports, Cognos reporting tools, and integrated testing process

Capital One Financial Services, Richmond, Virginia 1998-2013

Principal Data Analyst 2007-2013

IT Data Warehouse, Enterprise Data Services, 2012-2013

Coordinated large projects and managed testing; acted as a liaison between business and IT teams.

Contributed to the development of new subject areas and the enhancement of existing subject areas in company’s robust data warehouse

Oversaw data warehousing projects from start to finish by focusing on project scope, driving the development of quality requirements, influencing data modeling design, performing in-depth analysis using SQL/SAS EG/Excel to ensure data quality, facilitating User Acceptance Testing, troubleshooting production problems and working with teams to identify and resolve issues

User Acceptance Testing Lead on IT builds and releases - served as a liaison and Subject Matter Expert between the business customers/End Users and IT technical team, approved business requirements and validation reports

Provided project status reports to the stakeholders, business customers and project team on a weekly basis

Well managed schedule conflicts and resource constraints, and led team to deliver high quality project work with speed and customer satisfactions

Successfully managed contractors with their work assignments and provided constant guidance and coaching on Teradata/SQL, SAS EG, Excel and processes to ensure accuracy and timelines

Created various professional PowerPoint presentations; presented to different levels of audiences

Created documentations such as Standard Operating Procedures, Job Aid, Metadata, End User communications and process maps for new and updated projects

Developed a high value training curriculum to cross train other IT roles on the Data Analyst role

Developed a highly comprehensive Data Warehouse User Acceptance Testing Process training curriculum that shortened the performers’ learning curve by 40%

Conducted training on various subject areas for diverse audiences across the enterprise (Capital One University Certified Trainer)

US Card Customer Campaign Management, 2010-2011

Developed operational procedures and process flows; improved campaign management processes and managed production deadlines

Partnered with IT to resolve issues and provided production support to end users on campaign management

Created and improved 10+ processes that contributed to 40-50% reduction in errors and rework

Developed various training on Processes and trained internal and external teams

Led the development and design of a new Campaign Scheduling Application tool that made the process more efficient and user friendly, resulting in a reduction of turnaround time from two weeks to two days

Developed a computer based training curriculum on campaign management process that was published on the Capital One University’s website and is currently being used by enterprise users

As the Primary Database Captain of the department, established a new database management process to ensure that users follow the data governance policy, resulting in 70%+ free space and $100,000+ saving per year. Provided quarterly database forecast (Teradata) and made recommendations to Senior leadership

Maintained SLA matrix and provided monthly SLA matrix report to the centralized control team

Risk Event Management, 2007-2010

Managed the Data Analyst Team and led the team to support impact analysis and customer recovery process.

Built the team and allocated resources to support 3 value chains on Customer Recoveries

Designed and built the Risk Event Data Tracking Database in Teradata/SQL to improve the data retrieval process and trained 100+ people across the company

Core Team member of the Risk Event Redesign Project, developed and facilitated new process training for 100+ people

Created the hiring process and technical manuals. Involved heavily in the hiring process and the on-boarding training, resulting in the learning curve reduction from 4-6 months to 1 month

Coached team on Performance Improvement Methodologies such as Lean, Agile, PDCA, etc.

Senior Data Analyst 2001-2007

Implemented business strategies and conducted data analysis/reporting to help with business decisions.

Led big and complex business critical marketing strategies by accurately implementing business strategy into execution and providing data analysis and reporting to the business

Successfully managed a fraud monitoring project that led to 50% cycle time reduction and 50% accuracy increase by proposing a new logic

Founded a Data Expert Team across the enterprise and trained 100+ people to serve as an expert in each line of business

Gathered the data requirements from users and coordinated the effort to build a one stop shopping data mart that is currently being used for marketing campaign and analysis purposes

Performed data analysis and proposed solutions to help business with issue identification, resolution and decisions

Developed various technical training programs, trained new hires and other roles on the job related skills

Data Analyst 1998-2001

Performed data analysis and campaign executions using SQL, Toad, PL/SQL, SAS, Unix and mainframe.

Converted business strategies into executable offers and sent the timely offers to customers

Worked closely with business and project team on customer segmentation, account management, data validations and issue resolutions

Analyzed marketing campaign offers and product distributions; recommended for improvements

EDUCATION AND TRAINING

Adult Learning Theory and Training, University of Phoenix

Distinguished scholar, Information Systems & Decision Sciences, Louisiana State University, Baton Rouge, LA

M.S. Chemistry, Louisiana State University, Baton Rouge, LA

Numerous training and development programs, conferences and seminars, e.g., TDWI Conference, MDM(Master Data Management) Summit, Teradata SQL Skills, Database and data modeling design, SAS Enterprise Guide, SAS Programming, Advanced Excel Techniques, Creating Effective Presentation using PowerPoint, Business Process management (Certified at Capital One), Change Management, Agile/Lean Methodologies, Business Intelligence Reporting

Contact this candidate