SUMMARY

• 12+ years of experience in Information Technology, performance tuning, software products, application unit testing & validation.
• Dynamic, competent and result - oriented professional with experience in Software Development.
• Adept in analysing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex Information Systems Management.
• Well versed with Oracle, C, and Linux Shell Scripting.
• Strong collaboration, team building, interpersonal, communication skills with proficiency Confidential grasping new technical concepts quickly & utilizing the same in a productive manner.
• Excellent technical and analytical skills with clear understanding of design goals of ER modelling forOLTP
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries.
• Develop Oracle PL/SQL objects like Packages, Views & Triggers.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Review Interface Design approach and coding standard.
• Develop Logical Data model for the Data mart participating in Data modelling related discussions with Client IT/Business teams.
• ETL Developer having around 9 years of experience in analysis, design, development, testing and implementation of Applications.
• 4 Years of experience in C with data structure and UNIX shell scripting.
• Hands on expertise experience in Oracle PL/SQL with Oracle 10/11g and 12c database.
• Expertise in Data Migration project development and implementation using Oracle PL/SQL.
• Extensively used ETL to transform and load data from Oracle database, XML files, flat files to Oracle.
• Technical expertise in developing programs to generate derived datasets from raw data imported from various sources.
• Possess expertise in Data management, data extraction, manipulation, validation, and analyzing huge volume of data.
• Experience in writing UNIX shell scripts.
• Work with project teams to resolve complex technical issues using solution deployment and roll out methods, best practices during build, deployment and support.
• Experience in Project Coordination, Client interaction, Requirements Analysis, Design & Development, effort estimation and project planning Implementation and post implementation support both Confidential onsite and offshore.

CORE COMPETENCIES

• SQL queries, Stored procedures, views and functions
• Development testing
• Participating in design coding & unit testing of Software Applications.
• Communication and Coordination
• Data Integration, Data Modelling
• Extract, Transform & Load (ETL)
• Data Transformation Services

TECHNICAL SKILLS

Languages: PL/SQL, C, PRO*C, C++, C#, Visual C++Data Base Oracle 8i/10g/11g/12c, SQL Server

Operating System: Windows 7, Linux

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Technology Lead

Environment: Oracle 9i, Windows 7, UNIX

Responsibilities:

• Prepare design document and deployment plan.
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries
• Developed PLSQL Objects (Views, Packages, function and Procedures) for data migration, Direct TV DB to Confidential & Confidential DB.
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.
• Responsible for contributing to overall project objectives and specific team deliverables

Confidential, Atlanta, GA

PL/SQL developer

Environment: Oracle 12c, Windows 7, UNIX, SQL developer

Responsibilities:

• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries
• Developed PLSQL Objects (Views, Packages, function and Procedures) for data migration, STEP7 to 8.
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.

Confidential, Marlborough, MA

PL/SQL developer

Environment: Oracle 11g, Windows 7, SQL Developer, Toad

Responsibilities:

• Resolved high priority as well as low priority ticket and worked on Remedy Ticketing tool.
• Production support of Manufacturing application like PRIMO, BM-RAM, GLS, MES, RMI and SAP and handing the tickets.
• Managed OLTP for BM-RAM and PRIMO application
• Responsible for contributing to overall project objectives and specific team deliverables
• This role includes all various resources necessary to execute the project plan.
• Disposes of issues and project scope change requests
• Assigned full or part time to participate in project team activities.
• Responsible for contributing to overall project objectives and specific team deliverables
• Manages specific project plan activities and contributes to project plan development in collaboration with project manager
• Coordinates documentation, testing, and training efforts related to project plan

Confidential, Thousand Oaks, CA

PL/SQL developer

Environment: Oracle 11g, Windows 7, UNIX, SQL Developer

Responsibilities:

• Design various documents DS, RD.
• Developed PLSQL Objects (Views, Packages, function and Procedures) for Upgradation.
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries.

Confidential, Thousand Oaks, CA

PL/SQL developer

Environment: Oracle 11g, Windows 7, UNIX, SQL developer

Responsibilities:

• Developed PLSQL Objects (Views, Packages, function and Procedures) for CCD.
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.
• Design various documents DS, RD.
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries

Confidential, Thousand Oaks, CA

PL/SQL developer

Environment: Oracle 11g, Windows 7, UNIX, SQL developer

Responsibilities:

• Developed PLSQL Objects (Views, Packages, function and Procedures) for SIMS SDO.
• Design Database structure for SIMS SDO.
• Test Scripts creation, analysis and update of documents in compliance with CSV (Computer System Validation).
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.
• Performed advance Performance tuning on Oracle PL/SQL procedures and SQL Queries.

Confidential

Environment: Oracle 10g, Windows 7, UNIX, Toad

Responsibilities:

• Participates day-to-day Production Support or more.
• Handling the high and low priority tickets in different application like Argus, Impact, Aspire and Trackwise for Production Support.
• Resolved high priority as well as low priority ticket and worked on Remedy Ticketing tool.
• Developed PLSQL Objects (Views, Packages, and Procedures) for Oracle Legacy System, IMAPCT and ARGUS.
• Created a workflow in TrackWise and having a working knowledge of Web Admin module and Team Access.
• Preparing Patient visit designs using EPSI and RAVE.
• Test Scripts creation, analysis and update of documents in compliance with CSV (Computer System Validation).
• Test Cycle Execution
• Enhance technical and application knowledge.
• Analyzing requirements and implementing enhancement as per client requirement.
• Prepare Knowledge Transition package for inducting trainees in the project.