COBOL, JCL, DB2, Excel, SQL,excellent communication skills

Clara Amat Leon

** ******* **** * *** York, NY **002 ⃘917-460-6019⃘camatleon@hotmail.com

SUMMARY:

Strong administrative and organizational skills; detail oriented; excellent communication skills

Highly motivated self-started; works well in team environments or independently

Meet deadlines on projects and flexibility in work schedule

Having 4+ years of experience as SQL Developer

Senior Project at Lehman College; The Lehman Company: designed, developed, tested, and implemented an e-commerce application. This application was for employees using Oracle GlassFish Server 3.0.1, Net Beans platform, API and Workbench 5.4. Created and loaded database and designed the webpages

Having 5+ years of experience as Mainframe Programmer

Executed the mainframe jobs in batch mode through JCL

Collaborated in a team of two for a senior year project at University of San Marcos. Designed database schema for the Registration system for students and professors utilizing COBOL-IDMS, JCL and IDDL. Collaborated in design, development, test, and implementation. Designed several reports for students and professors

Developed complex Mainframe Programs to produce and validate the expected results

Strong skills in working with COBOL, JCL, SQL, and DB2

Extensive programming experience with COBOL, JCL, COBOL-DB2 in Batch and online Programs

Exceptional problem-solving skills for delivering useful and prudent solutions. A quick learner with an eye for detail and excellent analytical and quantitative skills

EDUCATION

LEHMAN COLLEGE- Bronx, NY 7/13

Masters of Science in Computer Science

LAGUARDIA COMMUNITY COLLEGE- Queens, NY 5/04

Associate in Science

UNIVERSIDAD NACIONAL MAYOR DE SAN MARCOS- Lima, Peru 12/04

Bachelor of Science in Computer Science

CAREER SERVICES TRAINING CENTER - New York City, NY 9/16-1/17

Microsoft Office Specialist

Microsoft Word (MOS Certified)

Microsoft Excel (MOS Certified)

Microsoft Outlook (MOS Certified)

Microsoft PowerPoint (MOS Certified)

SKILL SET:

Operating Systems: DOS/VSE, OS/VS, Windows 98, Vista, Windows 7, and Linux

Databases: MySQL, SQL, Oracle, RDBMS, IDMS, and DB2

Editor: Roscoe

Servers: Glassfish 4.7 and SQL

Programming languages: COBOL, COBOL-IDMS, COBOL-DB2, JCL, JPQL, XML5, Java, and CSS

PROFESIONAL EXPERIENCE

University Settlement - New York City, NY Feb/18 – Present

Case Manager

Assess client’s needs to request financial assistance to prevent eviction. Advocate client in court. Create and analyze report by retrieving information from database and filtering the data by household income and regions. Make sure that data is accurate and well documented.

Environment: SQL and Excel

International Planned Parenthood - New York City, NY Feb /17 – Aug/17

Development Intern

Created and analyzed Daily Gift report by retrieving information from database and filtering the data for the Development and Financial Department. Classified financial information, ensured it has been recorded accurately and inputted it into database. Created purchase orders; processed for staff and funders and travel requests and expense reports.

Working environment: SQL, Excel, and Navition

NYC Human Resources Administration - New York City, NY Feb /12 – Dec/12

Data Reporting Intern

Created and modified queries by retrieving information from database and filtering the information to create reports. Used data to analyzed program success rates, action plans and demographics. Identified trends and growth patterns that have high impact on business and funding decisions.

Environment: Oracle Database, SQL Server, and Excel

Henry Street Settlement, NY Mar/05 – Jun/09

Case Manager

Responsible for Business analysis and requirements gathering

Database recovery utilizing tools

Responsible in development as well as support work

Wrote queries to extract the data from database

Translating user requirements to technical design, application development, conducting design and code reviews

Managed a caseload for the homebound seniors; provided assessments and advocacy services

Provided Computer Literacy classes for co-workers and seniors

Environment: SQL server.

LaGuardia Community College, NY Mar /04 –Jan/05

Internship

Responsible for Business analysis and requirements gathering.

Responsible in development as well as support work

Developed modules to add new fields in existing database.

Wrote queries to extract the data from files

Design, implement and maintain Mainframe application within all phases of the Software Development Life Cycle (SDLC).

Translating user requirements to technical design, application development, conducting design and code reviews

Written some common programs that are useful across multiple sub-systems

Environment: COBOL- DB2, and JCL

Credit Bank, Lima Jan/98-Nov/01

Programmer Analyst

Developed and modified reports online and in batch mode for the Human Resources Department (HRD)

Designed and modified GUI through the software lifecycle

Created and updated, developed, tested, and implemented graphic user interfaces to provide and update employee information for HRD

Load database in batch mode and online

Translated customer requirements into formal requirements and established specific solutions

All the GUIs and reports were well documented

Performed validation on derived datasets/files and following the standard operating procedures during the validation process

Environment: COBOL, COBOL-ADS and JCL

Contact this candidate