Lori-Jo DePatie
* ******* ***** **********, ** **457
*******@*****.***
Summary:
Seasoned Business Analyst with over 20 years of experience in the business and information technology field. Highly motivated individual with excellent analytical, organization, communication and problem-solving skills. Proven ability to provide the communications link between the business and technology areas of the organization. Highly effective working both independently and as a team member
Skills Summary
Proficient in all phases of the System Development Life Cycle: gathering requirements, modeling use cases, analyzing data, developing technical specifications, producing test scripts, writing implementation plans, documenting processes for training manuals.
Proven experience in documenting and presenting the business case for technical projects.
Successfully implemented projects with teams located off-site as well as off-shore.
Extensive experience in business analysis, systems analysis and programming for major corporations. Able to develop strong partnerships with business and technical teams.
Strong background in data warehousing, data analysis and design, application development, user training and technical writing.
Proficient in Quality Assurance methodologies including CMMI.
Dependable, creative, hard-working professional with proven ability to explain technical concepts to business clients in non-technical language.
Professional Experience
Aetna, Inc. March 2014 – February 2016
Senior Business Analyst
Perform analysis and translate business needs to create high-quality Business Requirements and Technical Specifications documentation within specified time frames to solve most complex problems (multiple interfaces with other systems across multiple business units) considering all impacted components from an end-to-end perspective within the System Development Life Cycle methodology.
Work with numerous constituents to ensure data needs are met across systems business areas.
Perform informatics analysis to resolve complex business scenarios
Contribute to the Application Design and Information Design Model through effective interfacing with application and information architectural resources.
Supports the implementation of projects into production by performing production checkout tasks
Identifies and resolves system issues and defects and effectively communicates them to management and support areas.
Lead BA on Data Warehouse Service Requests covering numerous domains (medical claims, pharmacy, dental, membership, provider)
Mentor and coach junior BAs on all aspects of the BA role, processes and deliverables, as well as any relevant applications
Aetna, Inc. March 2005 – March 2014
Business Analyst
Provided analytical support for Enterprise Data Warehouse data structures and applications within a very large database complex.
Wrote business requirements as well as detailed technical specifications including detailed data mapping for claims and pharmacy and membership systems.
Acted as a liaison between the business areas and Health Informatics team (including architects, database administrators and developers).
Coordinated with developers in identifying problems and debugging programs to ensure business requirements were coded to specifications.
Participated in projects measured to achieve department CCMI Certifications for levels 1 - 3
Worked with the business to perform user acceptance testing for Data Warehouse analytical models and reporting application enhancements.
Delivered accurate artifacts in all phases of the System Development Life Cycle
Response Auto Insurance March 2004 – April 2005
Business Analyst
Implemented state required changes and system improvements, providing a competitive advantage.
Wrote business requirements outlining state regulatory changes
Researched potential system problems and responded to customers within a timely manner
Created and developed test cases for both positive and negative results.
Travelers Inc. December 2003 – April 2004
Business Analyst – Corporate IT Consultant
Analyzed business requirements and procedures to accurately translate business needs into systems and data specifications
Wrote business requirements as well as detailed technical specifications including detailed data mapping. Worked with the business to perform user acceptance testing for Data Warehouse, analytical models and reporting application enhancements.
Assisted programmers in identifying problems and debugging programs
Prioritized and managed outstanding defects ensuring accuracy and problem resolution.
CIGNA September 2002 – October 2003
Business Analyst – Corporate IT Consultant
Gathered business and technical requirements from multiple sources through JAD sessions and user interviews to accurately translate business needs into systems and data specifications
Document system enhancements and test both positive and negative conditions
Created, developed and ran test scripts and documented the test condition results
Verizon Insurance – October 1997 – April 2002
Senior Systems Analyst
Designed and implemented programs to automate federal 1099 reporting resulting in minimal manual processing
Reviewed and analyzed system and performance indicators to locate code problems with existing or enhanced code
Provided timely and accurate systems analysis to resolve cycle testing and migration problems.
Aetna, Inc. – August 1984 – August 1997
Senior Systems Analyst, Production Control Analyst
Served as team member on several Part B Medicare upgrade projects. .Duties included installing JCL, online and batch program changes, as well as running test cycles using both CA7/CA11 and ZEKE/ZEBB
Ran batch cycles in a timely manner. Responsibilities included recovering and restarting cycle issues ona daily basis. Worked closely with the programming area resolving cycle issues
Maintained all online systems consistently. Fixed and prevented job abends which allowed the user onlines to be up and running at their scheduled times.
Technical Experience
DB2 Data Warehouse and Databases, SQL Server, SQL
IBM Rational Tool Suite: Rational Req Pro, Clear Quest, Clear Case
IBM DB2 Data Control Center
Microsoft Office Suite: Word, Excel, Project, Access, Power Point and Visio
Mainframe/TSO/RUMBA;COBOL,JCL,CICS, Endevor, File-Aid, TSO,
BUSINESS JAD (Joint Application Design) Facilitation Training
TRAINING System Development Life Cycle Methodology
Specifying and Defining Client Requirements
EDUCATION: Computer Processing Institute – Business Computer Programming Certificate
Southern Ct. State University - Bachelor of Science Degree -