ROSEANN BIANCA

*** ******** ***** ***-

***-**** (home)

W. Bay Shore, New York 11706 www.linked.com/in/roseannbianca 631-

***-**** (cell)

SUMMARY

Highly experienced Business Systems Analyst with a proven track record in transforming business

needs into successfully completed projects. Solid IT background provides exceptional ability to bridge

the gap between business requirements and technical solutions. Adept at full project delivery from

analysis, specification and design to development, testing, documentation, installation, training and

support. Skilled in documentation for both technical and business audiences. Strong aptitude for

adapting to new technologies and competencies. Proficient at handling many tasks at once and

adjusting to changing priorities. Trained as a Project Management Professional (PMP) as well as in

Six Sigma methodology.

BUSINESS & TECHNICAL SKILLS

BUSINESS SKILLS: Data analysis, financial modeling, process analysis and reengineering,

business analysis, database design and development, documentation, and

reporting.

PROGRAMMING MS Visual Basic, MS Access VBA, MS Office Automation, SQL, HTML,

Clipper,

LANGUAGES: COBOL, RMCOBOL, C. Also studied PL/1, FORTRAN and Basic Assembly

Language.

SOFTWARE Cognos 8, Oracle 9i, Crystal Reports, ReportBuilder, SQL Server Reporting

Services,

PACKAGES: MS Office Suite including MS Excel, MS Project and MS PowerPoint, ODBC,

Visio, Allison Checkwriter, Accelio (JetForm), Lotus Notes, MS Outlook, dBase

III/IV, Visual FoxPro 9.0, DataFlex, DataEase, Monarch, WordPerfect, ACCPAC

Accounting Software and Medical Manager among many others.

PROFESSIONAL EXPERIENCE

Broadridge Financial Solutions, Edgewood, NY. Lead Business Analyst.

12/2010-present

• Business Analyst – Create ad hoc financial models and dash boards for internal and external

clients as well as support period-end close functions. Integrate MS Excel and Access to pull and

manage data from multiple sources, including Cognos and Oracle.

• MS Access (VBA) Developer – Responsible for supporting, analyzing, enhancing,

documenting, and building new functionality for several internally-developed financial applications.

Broadridge Financial Solutions, Edgewood, NY. Consultant.

10/2009-12/2010

11/2007-1/2009

• MS Access (VBA) Developer / Business Analyst - Enhanced, corrected and supported several

internally-developed MS Access applications for the Finance Department during their conversion to

Oracle Financial. Responsibilities included analysis of these applications, recommendations for

expansion, data normalization, modification, and documentation to help facilitate future upgrades.

American Home Mortgage, Melville, NY. Business Systems Analyst, AVP.

4/2006-8/2007

• Bus

iness Systems Analysis - Analyzed and streamlined complicated and time-consuming tasks

related to investor trading. Worked directly with the traders as end-users, with the goal of

building much-needed efficiencies within the department. Interviewed process owners,

clarified business needs, documented requirements and created specifications to be used

during coding.

• Pro

ject Management - Responsible for managing projects from conception and design to

implementation and delivery, including training and writing user documentation.

• Dat

a Analysis - Utilized Crystal Reports, ReportBuilder and SSRS to extract data from American

Home Mortgage's loan warehouse, Unifi, to aid in analysis and reporting. Created SQL views

to facilitate data mining. Utilized MS Excel for data presentation.

Roseann Bianca 631-***-****

Page 2

• Acc

ess Developer - Was instrumental in designing and coding in-house applications to aid in data

pool analysis, forecasting, data scrubbing and automated loan pricing.

CA Computer Associates, Islandia, NY. Consultant.

2/2006-4/2006

•SAP Conversion Certification - Worked with conversion team to develop testing strategies

and write data comparison applications to aid in software and data conversion from CA’s

internally-developed applications to SAP CRM module.

JPMorgan Chase (Chase Auto Finance), Garden City, NY. Sr. Programmer / Analyst.

3/1990-12/2005

•Merger Integration Project - Technical lead for Allison Checkwriter deployment to Ft. Worth

offices, which required analyzing, defining and accommodating differences (gap analysis)

between heritage Bank One and heritage Chase reconciliation processes. This positioned the

business to begin disbursing automated checks before the newly-merged corporation had chosen

a system of record.

•Project Management - Coordinated and supported the implementation of Allison

Checkwriter, a third-party application, which integrates data from legacy systems to automate

check disbursement in numerous areas of Chase Auto Finance (CAF).

•Process Redesign - Analyzed and modified existing workflows in QUEST, CAF’s customer

service front end. This streamlined payment service and title release processes, resulting in

shorter phone time with customers, simpler manual processes, and fewer executive complaints.

•Process Analysis - Worked with the business to engineer new workflows and software

modifications designed to create functional efficiencies. Translated business needs into

detailed business requirements and technical specifications. Acted as liaison between IT and

business, through user acceptance.

•Technical Documentation - Developed and published new team documentation in many

areas and in many configurations, such as dataflow documents, flowcharts and process flows

as well as narratives which simplified troubleshooting and enhancement planning.

•MS Access (VBA) Development - Lead developer and technical analyst for Titles

Reengineering project, which saved the business substantial dollars due to the sheer number of

paper titles which need to be stored, maintained and released.

•MS Access (VBA) Development - Automated TRS picklists for early terminations and flat

cancels, which replaced an intensive manual process and created a significant efficiency for

the business.

•Internal Application Transition - Moved VinApp application from Chase Card Services to

Chase Auto Finance, which required upgrading the application to Visual Basic 6 with a MS

Access 2002 database and compiling with Visual Studio before modifying it for CAF use.

•Gap Remediation Project - Converted the Titles Reference System (TRS) to MS Access

2002 with an Oracle 9i database, which provided the business with the latest technology

available.

•Technical Support – Created QA environment for secure development and wrote

standardized turnover procedures for TRS.

•Community Service - Served as Chase Auto Finance Blood Drive Chairman for several

years, which involved planning, organizing and executing six on-site blood events per year.

EDUCATION

Adelphi University. Bachelor of Science in Business expected May, 2013.

SUNY Old Westbury. 97 credits earned toward degree in Computer and Information Science with a

concentration in Systems Analysis. Accounting minor.

Suffolk Community College. Dreamweaver CS4, Web Page Design, Photoshop.

JPMorgan Chase Training & Development. Included VB.net, JAVA, HTML, SQL, PowerBuilder,

Accelio (Jetform), Business Objects, Oracle, Easel Workbench, Harvard Graphics, and Easytrieve.

Corporate Training. SQL Server 2005, Project Management.

Contact this candidate