Oracle sql,pl/sql,informatica 7.1,unix

RAMA DEEPTI .N

Contact: +91-879*******;Email: ******.********@*****.***

________________________________________

OBJECTIVE

To associate with an organization that provides mean opportunity to show my Techno-proficient skills, to improve my knowledge with the latest trends and to be a part of the team that works dynamically towards the growth of the organization.

________________________________________

PROFILE

Technically sophisticated & result driven IT Professional, with an experience of 3.2 years, spearheading with HCL TECHNOLOGIES as the Software Engineer.

Proven technical and analytical skills, with sound understanding and skill of creating new software & systems, designing, analysis, testing, database development while structuring customized hardware and networking solutions to meet customer’s specific needs.

Expertise in Analysis, Development, and Deployment of complex tiered Oracle10g applications.

Worked extensively on Oracle10g SQL, PL/SQL and well versed with RDBMS concepts.

Hands on expertise in Operating Systems, Languages, Scripts, Databases & Technologies and a professional experience in Software Development including the requirement analysis.

Exception analytical and troubleshooting skills. Superior communication skills, enriched with logical reasoning.

Ability to prioritize; take decisions and work in tandem with different departments ensuring on time solutions.

3 + years of work experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications mainly Oracle (SQL, PL/SQL) and Windows environments in industry verticals like Banking, Telecom and Healthcare.

3 + years of database experience using Oracle 10g/9i, SQL, PL/SQL, Stored Procedures, Functions, Constraints, Triggers, Views, Cursors, Packages, Exceptions.

Case Study on Data Extraction, Transformation, and Loading with RDBMS and Flat files.

________________________________________

TECHNICAL SKILLS

Operating Systems UNIX (Sun Solaris, Linux), Windows NT/2000Windows-98, 2K, XP

Languages Oracle10g SQL, PL/SQL, C

Databases Oracle10g,Tera Data

Tools & Utilities Toad, SQL Developer, PL/SQL Developer, Klock work, MVSPCalc

ETL Tool Informatica 8.1, Power Canter Designer , Work Flow Designer, Workflow Manager, Informatica Designer .

Reporting Tool IBM Cognos

________________________________________

EDUCATION

Degree Institute Major and Specialization Date Of Completion

Post graduation Sri Y.N. College (Narsapur) M.Sc (Electronics) 2003-2005

Graduation S.V.K.P & K.S.Raju Arts & Science College (Penugonda) B.Sc (Electronics and Computers)

2000-2003

Senior Secondary C.R.R Women’scollege(Eluru) Math Physics and chemistry 1998-2000

________________________________________PROFESSIONAL EXPERIENCE

HCL TECHONOLOGIES 2011 Jan – 2011 Sep

Software Engineer

Project Name MVSP

Role PL/SQL DEVELOPER

Organization

Client HCL Technologies

MERCK

Duration 2011 Jan – 2011 Sep

Team Size 8

Environment Languages : PL/SQL, SQL and Unix

Database : ORACLE 10G,Clear Quest

Tool- SQL Developer, Pl/SQL Developer

Description Merck & Co., Inc. was founded in 1891 and is headquartered in Whitehouse Station, New Jersey. Merck & Co., Inc. provides various health solutions through its prescription medicines, vaccines, biologic therapies, animal health, and consumer care products. This segment also offers human health vaccines, such as preventive pediatric, adolescent, and adult vaccines. It discovery and development of prescription medicines for diseases and conditions that impact millions of people. The company serves drug wholesalers and retailers, hospitals, government agencies, physicians, physician distributors, veterinarians, animal producers, and managed health care providers, as well as food chain and mass merchandiser outlets in the United States and Canada.

MVSP –Merck vaccines saving plan. In MVSP project calculate discounts based on order of vaccines. we calculated monthly ,quarterly and yearly orders and compared to the front end results.

Responsibilities

Extensively worked in oracle SQl, PL/SQL, Created database objects like tables, Views, Indexes, Synonyms, Sequences, Procedures, Packages, functions, cursors, exceptions Using Tools like Pl/SQL developer and Toad.

Responsible for the database release activities by creation data scripts and maintaining clear case process.

Test Cases / Data preparation, Execution and verification of the test results.

Developed Packages and customized functions and triggers based upon the business logics.

Prepared test plans for discounts per monthly wise.

Prepared quarterly results of vaccines

Compared results from front end to back end using MVSPcalc tool.

Involved in Unit testing and System testing of the individual

CASE STUDY MVSP

Organization

Client HCL Technologies

MERCK

Duration 2011 Jan – 2011 Sep

Team Size 8

Environment Languages : PL/SQL, SQL and Unix

Database : ORACLE 10G,Clear Quest

ETL Tool :Informatica 8.1,Informatica Power center, Workflow Manager, Repository Manager, Workflow Monitor.

Tool- SQL Developer, PL/SQL Developer.

Responsibilities Extensively used Informatica to load data from flat files, Oracle database.

Extensively involved in Data Extraction, Transformation and Loading (ETL) from

Source to Target systems using Informatica Power Center.

Developed mappings by extensively using Informatica Transformations like Filter,

Expression, Aggregator, Source Qualifier, Lookup, Joiner, Router and Update Strategy etc.

Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO_DATE, Decode, Substr, Instr and IIF function.

Used Update Strategy DD_INSERT, DD_UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.

Developed Re-Usable Transformations and Re-Usable Mapplets.

Developed Slowly Changing Dimensions Mapping for Type 1 SCD and Type 2 SCD.

Create and schedule Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules.

ACCEL FRONTLINE 2008 Feb – 2009 Mar

Software Engineer

Project Name Web Production Tool (Web-pro)

Role Software Engineer

Organization Alcatel-Lucent

Duration 2008 Nov – 2009 Mar

Team Size 8

Environment Languages : PL/SQL, C and Unix

Database : ORACLE 10G,Clear Quest

Tool- SQL Developer.

Description Web- pro a production tool which is developed to automate the release production in different versions. The tool is mainly used to open and close the production environments to the R&D engineers without manual work. This tool provided the errors and warning in the environment during the compilation of the environment. The tool makes uses of the clear quest to tract the Defect and the requests. It also makes uses of the LDAP data base to map the Engineer Email ID and send the status of the production.

Responsibilities Developing the web-pro tool to automate the opening and closing the environment

Tracking the Defect in the request log and mapping with the Clear Quest database

Programming the auto generated Email system to the managers and Engineers in case of environment requests

Work with the cross functionality teams to design tool in customer oriented manner

Coach the Engineers and management in using the tool

Documents the tools specifications and make it available in the repository

Automatically create the requested versions in the clear Quest

Project Name Alcatel OmniPCX Enterprise (PBX)

Role Software Engineer

Organization Alcatel-Lucent

Duration 2008 Feb– 2008 Dec

Team Size 10

Environment Languages : PL/SQL, C, C++ and Unix

Database : ORACLE 10G

Tool- SQL Developer.

Description The Alcatel OmniPCX Enterprise (OXE-PBX) is an integrated communications solution for medium-sized businesses and large corporations. It combines the best of the old (legacy TDM phone connectivity) with the new (a native IP platform and support for Session Initiation Protocol, or SIP) to provide an effective and complete communications solution for cost-conscious companies on the cutting edge.

One year of reporting (data migration and conversion) and tool development experience as external consultant in Alcatel-Lucent Technologies. Responsible include reporting (data migration and conversion) the code from the base version to extended versions, testing and assisting validation team in validating voice quality of the Latest Digital Phone products. Responsible for reducing the Bugs and improve the quality of the software.

Responsibilities Reduced the reporting backlog and improved the customer satisfaction

Improved the quality of the software by reduced the severity of the bugs

Providing the suggestions to the Engineers in fixing the Defects

Helping the management team by advising in creating and opening of the environments

Coaching the team members in the clear Quest and reporting (data migration and conversion) process

Used Clear Quest extensively for Defect-tracking and other issues as well as Deployment and Enhancement requests

Coordinated with the testers and developers in resolving the testing defect

Used Clockwork tool to tack the memory related issues to improve the quality the software.

Primes IT Solutions 2006 Oct – 2008 Jan

Technical Consultant

Project Name Medmal Insurance (Medical Insurance)

Client OIC, India

Role Team Member

Organization 3i-Infotech Ltd., India

Duration 10/2006 – 01/2008

Team Size 15

Environment Languages : Forms10g, Reports6i and PL/SQL

Database : ORACLE 10G

Tool- SQL Developer, PL/SQL Developer.

Description Presenting PREMIA - an integrated Insurance Management Solution specially preconfigured for the Medical Malpractice segment. PREMIA addresses Rating & Quoting, Policy Administration, Billing, Claims, Reinsurance, Financial Accounting and Reporting. The application includes a suite of Web portals that creates unlimited interaction opportunities by offering secure Web access to Hospitals and Physicians. Powered by Oracle, PREMIA caters to all functions in a policy life cycle and assimilates data in a single consistent data schema. The intuitive user interfaces further facilitates ease in data entry, retrieval of information and provides intelligent analysis and faster business decisions. PREMIA incorporates a 3-tier Architecture and provides for access anytime, anywhere. The application is rendered through a Web browser on the user's machine.

Responsibilities Understanding the Project and its business logic.

Designing and created the Database model.

Coding using SQL, PL/SQL.

Bug Fixing and Testing - unit testing.

________________________________________

CERTIFICATIONS

C &C++ Certification – NIIT

________________________________________

STRENGHTS

Good Communication and Presentation Skills

Responsible, Energetic, dedicated, and Self-Motivated with proactive approach to work.

Ability to conduct and Co-ordinate Group Activities

Strong Interpersonal Relationships

Good ability to grasp and master new technologies quickly and easily

Good troubleshooting skills; tenaciously committed to the thorough resolution of technical issues

Strong communication skills, excellent team player

Exploring new technologies and challenges

________________________________________

PERSONAL INFROMATION

Name : M. Rama Deepthi

Sex : Female

Status : Married

Language Known : English, Telugu, Hindi

Hobbies : Listening to music, playing chess.

Contact this candidate