Livecareer-Resume
Jessica Claire
Montgomery Street, San Francisco, CA 94105
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Summary

• Oracle PL/SQL and Informatica developer offering 7.5 years of experience, leading and being a part of cross-functional development teams to take up critical projects and delivering on-time. Seamlessly manages workload to meet deadlines.

• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.

• Motivated team player and proficient working in a process centric environment like waterfall or Agile/Scrum development environment and as part of code review/ production deployment process.

• Worked in esteem organizations and brings in experience/processes intended to ensure good quality for deliverables.

Highlights

• Extensive experience in writing SQL queries, PL/SQL procedures, functions, packages,exception handlers, cursors, collections, PL/SQL tables, indexes,triggers, synonyms, views and database links in 11g, 10g, 9i, 8i and 7i.

• Expert in Performance Tuning Query optimization, Data optimization,job scheduling and using Dbms profiler,Explain Plan, SQL Tracing and TKPROF for high efficiency.

• Proficient in using SQL*Loader for loading data from flat files into Oracle tables.

• Involved in index organized tables, external tables, range partitioning of tables, use of global temporary tables.

• Motivitated to use latest features of oracle to increase code modularity, performance and portability - Virtual private databases, bulk collects, virtual columns, compound triggers, pivot/unpivot, model queries and regular expressions.

• Enhanced consciousness to improve code quality using automated unit testing using utplsql utility.

• Proficient in developing informatica complex mappings, mapplets, workflow, worklets, sessions, parameters and variables.

• Have knowledge in tools like Informatica Power Center 8.6 (Source Analyzer, Target, Mapping,Mapplet, Workflow Designer and Worflow Monitor),

•Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical, technical, problem solving and interpersonal skills.

* Involved in profiling, working as part of deployment group

Accomplishments

IT Certifications:

  • Oracle Certified Associate (OCA) - 9i.
  • Oracle PLSQL Certified Expert (OCP) - 11g.
  • Informatica PowerCenter Developer - Data integration - 9.
  • Workshop on scrum developer.
  • Banking Domain certification - D&B.
Experience
09/2011 to Current
Software Engineer Barracuda Networks Alpharetta, GA,

• Working in scrum agile framework as a full-time employee on H1b-visa(valid till 09/30/2014) in Heath Care domain.

• Responsible for gathering requirements on new project implementation in onshore-offshore model, preparing requirement doc and communicating with clients.• Taking initiative in new tools contributing to process improvement and doing POC (Proof of concept) on tools like ClearSQL and automated unit testing using utplsql utility.• Implementing file loads for enrollment data for clients like Highmark/Xerox, develop programs to process claims and support business for implementing various heath plans like HSA, FSA, DCFSA, HRA's.• Working in team and involved in code review/peer review/demos activities to improve code quality and performance.

04/2011 to 09/2011
Senior Software Engineer Ametek, Inc. Houston, TX,

• Rehired by the subsidiary of Acclaris,Inc,US (Acclaris Business Solutions Pvt Ltd, India) in recognition of contribution made to the growth of the organization.• Employed in the India office until H1b visa is processed.• Responsible for gathering requirements on new project implementation in onshore-offshore model, preparing requirement doc and communicating with clients.• Taking initiative in new tools contributing to process improvement and doing POC (Proof of concept) on tools like ClearSQL and automated unit testing using utplsql utility.• Implementing file loads for enrollment data for clients like Highmark/Xerox, develop programs to process claims and support business for implementing various heath plans like HSA, FSA, DCFSA, HRA's.• Working in team and involved in code review/peer review/demos activities to improve code quality.

09/2010 to 04/2011
Module Lead Data Robot Redwood City, CA,

Project 1: Schneider Electric, America - Banking & Financial Services.

• Responsible for production support activities of critical business applications such as Purchase, Finance, Sales and Marketing.• Responsible for monitoring, analysis, temporary and root cause fix of different jobs running in UNIX and supported by Sybase stored procedure and Informatica workflows/mappings/mapplets.• Responsible for meetings with client for status updates of production issues and progress.• Also involved in defect fixing and change control analysis.• Involved in development using Sybase and Informatica. • Skills and Tools: Sybase, Informatica – 7.1.1 and 8.1.2, UNIX, Putty, ControlM- Enterprise Manager.

Project B: Lloyds Bank - Imaging and Workflow Automation.

• Responsible for enhancing/ maintenance of database and only point of contact for Filenet/J2EE team.• Responsible for design and enhancement of data model.• Developed Procedures/Functions/Triggers/DDL scripts.• Also involved in defect fixing/analysis of root cause of defects during UAT phase.• Involved in code reviews and code designs. • Responsible for Knowledge Transfers and grooming of team members.• Skills and Tools: Oracle SQL/PLSQL-11g, Oracle Enterprise Manager, Informatica.

07/2008 to 08/2010
Senior Software Engineer Barracuda Networks Chelmsford, MA,

Project A: Crosby Benefit Systems, Fidelity –Platform Upgradation.

Duration: Nov-2009 to Sep-2010.

• Was deputed twice to Tampa, Florida U.S.A. (B1 Visa): Nov-2009 to Jan-2009 and July-2009 to Jan-2010 for Business Meetings.• Gathered requirements for upgrading platform for existing client Fidelity and new client Crosby.• Developed reports in PLSQL which would fetch data from different environments and generate a common report for client to view net claims reimbursed by different employer groups.• Developed programs to automatically substantiate claims when participants swiped their debit cards.• Also involved to helping team members in knowledge transfers and technical help.• Involved in code reviews and code designs. • Promoted to Sr. Software engineer from software engineer based on my performance.

Skills and Tools: Oracle SQL/PLSQL-11g, PL/SQL developer and WSFTP-Pro.


Project B: Bank of America Benefit Solutions –End to end Implementation.

Duration: Mar-2009 to Nov-2009.

Bank of America decided to change their vendor for claims processing for various Health plans like HSA, FSA, DEPFSA, HRA, DCRA etc to Acclaris.

• Was involved in Fileloads containing participant enrollment information in standard 834 format.• Completely developed deposit fileload’s which was to process participant deposit information (coming from vendors in various formats like CDHP, Excel etc according to complex business logic and load it in the database, enabling participants to view their account balance through portal (developed in Java).• Received my Manager’s appreciation for defect free program processing when demoed in onsite with client and my company IT- Vice president.• Was involved in post- production support and provided support to day to day problems, queries raised by client to Operations department.• Also responsible for working on new change request and bug fixes.

Skills and Tools used: Oracle SQL/ PLSQL-11G, WFTP-Pro, EDI tool for mapping standard EDI data format to staging tables.


Project C: AT&T Tuition Plan –End to End Implementation.

Duration: Aug-2008 to Feb-2009. (New Project Implementation & Support).

• Was involved in requirements gathering for implementing 12 tuition plans. Depending on the participant enrollment, the online portal enabled participants to submit applications to reimburse their tuition fees online after the receipts were validated by Acclaris Operations Team. The online claim reimbursement decreased company’s dependence on Operations resource thereby improving efficiency and cost.• Coding, unit-testing, database design, implementation of code design and approach.• Coordinating with QA team to ensure code quality prior to production release.• Single handedly provided production support activities. (Have complete end to end knowledge of Design, code impact changes and business requirements).• Presently involved in grooming new production support team which does data fix and immediate fixes based on SLA.• Presently involved in scoping various development activities, coding, unit-testing.• Technology and Tools Involved: Oracle-11g, PLSQL developer, Front-end application (developed by Java team).

11/2005 to 07/2008
Software Engineer Infosys Technologies Pvt. Ltd. City, STATE,

Client: Fidelity Investments.

Project A: STORE: Sybase to Oracle Re-Engineering- Benchmark.

Location: Fidelity Client Office, Bangalore India.

Duration: Nov-2007 to Aug-2008.

• As part of STORE (Sybase to Oracle Re-Engineering) initiative, Fixed Income (FIMT- Comprising of debt and bonds) decided to migrate all the Vendor data feed systems, which are more data centric and less dependent on applications, from Sybase to Oracle. This involved migrating all vendor feeds databases (presently six) to one schema and one database.

Responsibilities & Achievement-

• Got an appreciation mail from client commending my defect less code and for learning new technologies within very short span of time.• Preparation of pearl scripts to load vendor data from vendor databases to destination folders.• Developing mappings, mapplets, workflows and sessions in informatica for loading vendor data from Sybase to destination tables in oracle after validation and transformation.• Writing SQL queries, joins, PLSQL procedures, Functions, Triggers to extract data from multiple sources before inserting into target tables.• Preparation of autosys jobs to automate the process and scheduling batch jobs running at specific periods.• Coding and self testing of application in various environments, defect tracking and code reviews.• Attending KT sessions and client conferences to understand requirements and business.• Skills Used: SQL, PLSQL, UNIX, Informatica8.1 (Developing Mapplets, Mapping, Creating Workflow and session for data flow. Creating scripts.), Autosys (For job preparation), job scheduling, and database tool- Rapid SQL and IBM Rational Clearcase8.1 for version maintenance.

Project B: AI and Reporting

Duration: Feb2007 to Nov2007.

• Was a part of Production Development Team responsible for designing procedures, packages, triggers and other database object, which would interact with the database in order to retrieve participant’s assets, and holdings, which would then be passed on to the front end (Informatica) to be viewed by the end user. AI is the main module, which included creating customer accounts, and adding transaction details while Reporting, which is the sub module, included generating reports of investment details for each participant.

Responsibility-

• Single handedly managed the reporting module and working with the AI team in development. • Coding in SQL/PLSQL on TOAD tool along with rigorous self-testing as the code was deployed in various test environments before finally being deployed in production database. • Was also the backup Project Leader and have ensured that our deliverables meet the standards with frequent Code Reviews, Defect • • • Tracking and Effort Estimation being done.Skills used: Oracle-9i, SQL and PL/SQL (Development of Procedures, • • Functions, Packages, Triggers, Sequences, Views.), Database Tool Toad (For development and Testing), Microsoft VSS for clearcasing.

Project C: Actuarial Application Corporate Actions

Duration: May2006 to Jan2007.

• Was a part of the development team, involved in preparing requirement documents based on client needs, developing and testing Workbooks which are Excel applications supported by VB and fetching data from the database enabling a participant to view their retirement benefits (Defined Benefits) based on complex calculations as proposed by the clients of Fidelity (like- VNU, NCR, RHD).

Responsibilities-

• Preparation of requirement document according to client needs.• Coding, self-testing and running Regression Testing to prevent breaking of code.• Involved in Defect Prevention meetings and KT (Knowledge Transfer) sessions held regularly in order to maintain the Infosys quality standards before production delivery.• Skills used: MS- Excel, VB6.0, Regression Tool, SQL, PLSQL, Unix.

Education
Expected in 2005
Bachelors in Enginnering: Electronics and Communication Engineering
Sri Siddhartha Institute of Technology - Tumkur, Karnataka
GPA:

This is a four year degree course and achieved a First Class With Distinction with 73.2% across all semesters.

Expected in 2000
High School: Science
The Frank Anthony Public School - Kolkata, West Bengal
GPA:

Standard 12th with an overall - 76%.

Expected in 1998
Select One: Standard 10th
The Frank Anthony Public School - kolkata, West bengal
GPA:

With an overall - 70.2%.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

78Average

resume Strength

  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • Sri Siddhartha Institute of Technology
  • The Frank Anthony Public School
  • The Frank Anthony Public School

Job Titles Held:

  • Software Engineer
  • Senior Software Engineer
  • Module Lead
  • Senior Software Engineer
  • Software Engineer

Degrees

  • Bachelors in Enginnering
  • High School
  • Select One

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: