Software Engineer Sql

Sheeba Mathews ***** Centre Park Cir, Apt ***

Email: ****************@*****.*** Herndon, VA.

Phone: +1-479-***-**** 20171

PROFESSIONAL SUMMARY:

● Software engineer with hands on experience in the design, analysis, development, testing, deployment, troubleshooting and maintenance of business applications for various clients in the retirements/benefits portfolio.

● Experience in creating/enhancing programs in Mainframe SAS, JCL and SQL to support and maintain business applications.

● Experience on analyzing large chunks of data (over 10 million) for setting up workbench based functional testing.

● Experience in all phases of the software development life cycle (SDLC) including version control and configuration management.

● Hands-on experience in programming languages like C, C++, C#, Java, ASP.NET

● Good understanding in the investments, retirement and benefits portfolio management.

● Worked on projects for key industry leaders like Conoco Philips, McDonald’s and American Red Cross at AON Hewitt.

● Mainframe experience in Development, Testing, Implementation and Production Support.

● Hands on experience in Designing and Developing Test plans, Test scenarios and Test cases.

● Operational analytical, programming and testing skills.

● Strong communication, Creativity, Assertiveness, Leadership and Team work. PROFESSIONAL EXPERIENCE:

Employer: AON Hewitt, Chennai, India.

Role: Batch Analyst(Programmer) May 2014 – Mar 2016 The job encompassed operating on massive datasets hosted on the Text Works Database (TBA) to help design and maintain batch jobs that ran on the Multiple Virtual Storage (MVS) Operating Systems. SAS based programs were employed to map the TBA data files to files that reside on client systems. Responsibilities:

• Developed SAS/SQL programs from scratch.

• Modified existing programs.

• Migrated the code to Production environments.

• Scheduled jobs in Control-M set to run on specified times.

• Developed batch jobs using SQL, SAS and JCL.

• Created configuration data for unit and integration testing.

• Carried out tasks related to scrambling the application to production environments.

• Developed configuration scripts to schedule watchdog jobs using Control-M.

• Created requests to setup Electronic File Transfers (EFT) between Hewitt and Client for transfer of conversion files.

Environment: IBM Mainframe, SQL, SAS, DB2, SQL, File-Aid, JCL, Control-M Role: Setup Configuration Specialist(Tester) Feb 2011-May 2014 The assignment focused on the configuration of user interfaces utilizing work bench to help drive the retirement benefits for a wide clientele.

Responsibilities:

• Participated in requirements hand off meetings and gathered requirement specifications.

• Studied requirement and compiled analysis document to carry out coding.

• Created test case mapping and detailed test plans for various test scenarios

• Carried out manual and automated testing of the work product.

• Reviewed the code base to ensure that the analysis is translated into code.

• Reviewed finalized test plans to support the need of reliable testing.

• Code deployment/Implementation assistance in production environment.

• Participated in post deployment defect analysis, resolution and support.

• Generated daily status reports for review by senior management. Environment: Hewitt workbench, SQL

TECHNICAL SKILLS:

Programming languages: SAS, Oracle PL/SQL, SQL, ESQL, C, C++, C#, Java Database Environments: Oracle RDBMS 10g, DB2, Microsoft SQL Server, TBA Tools: Development: SQL*Loader, SQL*Plus, Quest software Toad, Putty, HP UFT Source control and tracking: Visual Source Safe, Team forge, Remedy 7, HP Quality Center

Scripting: HTML, XML, VBScript, JavaScript

Operating Systems: Windows XP/7/10, HP-UX 11.0, AIX 4.3.3 and 5.2, Linux RH-9 Multimedia tools: Flash, Dreamweaver, CSS and Photoshop. EDUCATION:

MASTERS IN COMPUTER APPLICATION (MCA) April 2011

Ethiraj College for Women

Chennai, Tamil Nadu, India

(Affiliated to University of Madras, India)

BACHELORS IN COMMERCE (B.COM) April 2007

Women’s Christian College

Chennai, Tamil Nadu, India

(Affiliated to University of Madras, India)

Certifications:

• Microsoft Technology Specialist: Microsoft SQL Server 2005

• Graduate degree in National Institute of Information Technology (GNIIT) Search Keywords

Agile, Mainframes, SQL, SAS, Software engineering, Software development, SDLC, Quality Testing, Configuration, Workbench, Data setup, Unit testing, Integration testing, Design documents, Technical design, Requirement specifications, SQL*Plus, Quest Toad, Putty, VI Editor, Query man, Remedy 7, Team forge, Visual source safe, JCL, Linux, Unix shell scripting, C, C++, ASP.NET, DB2, File-aid, HP QTP, UFT, XML, HTML, MS Excel, MS Office.

Contact this candidate