Create reports using MS SQL Server and Crystal Reports.

• Extract, collect, and analyze data and prepare clear and concise reports using Oracle SQL and MS Excel and Access.• Convert current legacy reports into HP Exstream application.• Quickly learn new systems and manage the applications. • Prioritize my work assignments and schedule to offer comprehensive support.

• Conduct myself in a professional manner when explaining to and answering customers' phone, email, and chat inquiries on the Affordable Care Act.• Enroll customers in a health insurance plan using CALHEERS and RightNow applications • Ability to quickly learn the business knowledge, shop policies and procedures.• Used MS Word, and Excel to improve my overall productivity.

• Conduct myself in a professional manner to meet customers' needs and desires. • Meet and generally exceed daily department sale's goals.• Create a team effort with my fellow Sales Associates. • Operate cash registers.

• Conducted myself in a professional manner to know and meet customers' needs and desires. • Conducted outside sales, prospect new clients, follow up with client calls, and retain clients. • Ability to quickly learn AIL products.

• Conducted outside sales, prospected new clients, followed up with client calls. • Educated families on financial concepts and provided financial planning.• Helped clients identify and planned for short- and long-term goals, such as funding for college and retirement.• Used MS Word, Excel, and Powerpoint to convey the appropriate messages to clients and prospects.

• Developed, installed, maintained, and enhanced an enterprise-wide application encompassing 13 states to assess and manage customer risk.• Provided Online CICS support and troubleshoot abends, including answering Service Reps’ inquiries and concerns.• Created, analyzed, and walkthrough the high-level designs, detail designs, and unit test plan documents throughout the projects’ life cycle.• Negotiated with client an effective resolution on accounts that fell out of treatment.• Used SAS, JCL, NDM/FTP, and QMF for Windows to analyze defects, to perform data recovery, and to test and maintain data integrity. • Designed an efficient DB2 table conversion when upgrading a vendor package.

• Maintained and enhanced a two-state application to assess and manage customer risk.• Developed Teradata interface and extract programs using Teradata SQL, Fileaid, and Syncsort. Concurrently developed the RCRMS database update program using COBOL/DB2 and followed through the SDLC. • Converted old COBOL programs into COBOL OS/390.• Used Fileaid, Syncsort, Expediter, and QMF (using DB2 SQL) to perform unit testing.

• Created and modified programs to make date fields Y2K compliant in COBOL/CICS or NOMAD.• Also, used utilities; such as Syncsort, Fileaid, and SmartTest. Converted old versions of COBOL programs to COBOL For MVS.• Mapped data from various Production applications to NOMAD databases.• Installed and updated vendor packages (like GEAC’s A/P and G/L) into the Production environment, while adhering to local protocols.• Provided both Batch and Online production support resolving users’ inquiries and concerns.

• Created and modified programs to monthly extract data, using Teradata SQL, from one data warehouse into another.• Mapped data from one data warehouse into another.• Created Teradata tables to expedite multiple-table queries.• Implemented into Production monthly data load jobs using JCL and Teradata SQL.• Provided Production Support on a monthly basis.

• Supported the RCRMS DB2 Production Batch System.• Researched, analyzed, and debugged Production abends and job delays.• Tailored PROCs and EXEC JCLs for Production readiness while adhering to local protocols.• Communicated and met with teammates, Operations, and the user community on the various changes affecting and abends occurring in Production.

• Developed systems solutions, and designed, coded, tested programs.• Produced management reports within time constraints using VM/NOMAD, REXX, Teradata SQL, Easytrieve, and JCL.