EXPERIENCE SUMMARY:

• Having 13+ years of experience in Software industry and having hands on experience in software development using Oracle PL/SQL 9i, 10g, 11g, Informatica ETL, Unix Shell scripting, VB6,perl scripting, Python programming (Beginner).
• Willing to learn and adapt to new challenges.
• I am having expertise in Analysis, Design, Development and Unit testing with excellent problem solving capability for critical and undefined problems and Diagnostic
• Ability to go to the core of the problem.
• Capable of managing time effectively and work in different projects simultaneously and also having capacity to work in tight deadlines.
• Having experience to work in different SDLC models such as water fall model and agile model.
• Expertise in the effort estimation process using WBS.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Databases & Tools: Oracle (9i, 10g, 11g),TOAD,PUTTY,Visual Studio,Sql Developer,Sybase

Technologies: Unix Shell scripting, Perl Scripting,Informatica

Programming Languages: PL/SQL, SQL, Cold Fusion,VB6

Other Utilities: PVCS,TFS,SVN,BJS

Other technologies: SalesForce CRM (administration), Python

WORK EXPERIENCE:

Confidential

Technology: Oracle SQL,PL/SQL, Informatica ETL, Unix Shell scripting,VB6,Perl scripting,Cold fusion, Sybase

Production support

Responsibilities:

• Analyze, design, develop, implement, and enhance customized applications; modify existing applications to meet User s changing needs and train users in the application as necessary.
• Having expertise in Data Analysis, Data Modeling, Data Architecture, Data Warehousing.
• Proficient in Design and Development of process required to extract, Transform and Load data into the data warehouse using Informatica Power Center.
• Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimension tables, Physical and logical data modeling, OLAP and Report delivery methodologies.
• Handling all the P1 and P2 tickets and all types tickets which needs to be addressed immediately and resolving them with in the SLA time.
• Requirement gathering from the users owner based on the request raised on the Change point Jira portal
• Responsible for taking the Knowledge transfer and providing reverse Knowledge to the offshore team
• Attending the status calls with users on daily basis and get the requirements and any issues/concerns from the users.
• Daily monitoring of all production jobs
• Responsible for the delivery and oversight of a project titled Confidential AMS that Confidential currently performs for our client, Confidential .
• Guide the activities of Confidential Team. In performing duties, will use an array of languages such as SQL, PL/SQL, UNIX, Cold Fusion, VB, Informatica ETL and others depending on specific project requirements, in analyzing, designing, testing, and modifying application software for Enhanced functionality and Productivity on Windows operating systems.
• Develop new applications as necessary to fulfill the client s requirements.
• Use practical knowledge of various software languages, Tools, and platforms, and apply design specifications techniques under the supervision of an experienced team lead.
• Understand the database architecture and proposing solutions to the clients.
• Creating packages, stored procedures using Oracle, PL/SQL and also writing complex queries and performance tuning the queries.
• Maintain the existing frontend application developed in VB6 by working on latest enhancements and design.
• Creating UNIX shell scripting to call the backend objects and scheduling in TIDAL.
• Responsible for the delivery of the developed code at onsite and also ensures that the unit testing the functionality according to the requirements and ensure all the test scenarios are covered along with the test evidences and ensured to meet the deadlines.
• Helps in implementing the code to testing environments and supporting the QA team in testing the functionality.

Confidential

Technology:Oracle SQL,PL/SQL,Unix Shell scripting,VB6

Responsibilities:

• Responsible for the delivery and oversight of a project titled New editorial systems that Confidential currently performs for our client, Confidential .
• Analyze, design, develop, implement, and enhance customized applications; modify existing applications to meet User s changing needs; and train users in the application as necessary.
• Guide the activities of Confidential Team. In performing his duties, he will use an array of languages such as SQL, PL/SQL, UNIX, Cold Fusion, VB and others depending on specific project requirements, in analyzing, designing, testing, and modifying application software for Enhanced functionality and Productivity on Windows operating systems.
• Develop new applications as necessary to fulfill the client s requirements.
• Use his practical knowledge of various software languages, Tools, and platforms, and apply design specifications techniques under the supervision of an
• Experienced team lead.
• Understand the database architecture and proposing solutions to the clients.
• Creating packages, stored procedures using Oracle, PL/SQL and also writing complex queries and performance tuning the queries.
• Maintain the existing frontend application developed in VB6 by working on latest enhancements and design.
• Creating UNIX shell scripting to call the backend objects and scheduling in TIDAL.
• Responsible for the delivery of the developed code at onsite and also ensures that the unit testing the functionality according to the requirements and ensure all the test scenarios are covered along With the test evidences and ensured to meet the deadlines.
• Helps in implementing the code to testing environments and supporting the QA team in testing the functionality.

Confidential

Technology: Oracle SQL,PL/SQL,Unix Shell scripting

Responsibilities:

• Involved in offshore analysis, design, coding, code review, bug fixing and Preparation of Enhancement and Bug Fix Report (EBR) and Estimation and also involved in the deployment in various promotion groups such as Development, QA and Stage.
• Used Toad as a development tool to create/modify all the Backend objects and UNIX was used to create/modify the batch jobs.
• Used Oracle Warehouse Builder to create maps to load the data into tables automatically using external tables along with Quest Code Tester for oracle as an automation testing tool to evaluate the new objects.
• Responsible for the delivery of the developed code at onsite and Unit testing the functionality according to the requirements and ensures all the test scenarios are covered along with the test evidences and ensured to meet the deadlines.
• Helps in implementing the code to testing environments and supporting the QA team in testing the functionality.

Confidential

Technology: Oracle SQL,PL/SQL,Unix Shell scripting

Responsibilities:

• Involved in understanding the database architecture and proposing solutions to the clients and creating packages, stored procedures using Oracle, PL/SQL.
• Responsible for the delivery of the developed code at onsite and unit testing the functionality according to the requirements and ensure all the test scenarios are covered along with the test evidences and ensured to meet the deadlines.
• Helps in implementing the code to testing environments and supporting the QA team in testing the functionality.