SUMMARY:

• Around 12 years of proven experience in Information Technology industry.
• 10+ years of experience in the design, development and implementation of business/application software using Oracle databases 12c/11g/10g/9i.
• 4+ years of experience in InformaticaPowercenter ETL development using mapping, workflow, session and transformations.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures, Functions, Packages and synonyms.
• Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, Varrays, Records, Types, Dynamic SQL.
• Expertise in DataWare Housing concepts and design.
• Experience in writing Explicit Cursors and Handling Exceptionsin PL/SQL.
• Extensively involved in developing programs to import data from legacy system into oracle database using SQL*Loader.
• Experience in Query Optimization, Tuning using the Oracle tools like Oracle Hints and Explain Plan etc.
• Written Interface programs for importing data from feeder systems to Oracle using SQL*Loader, PL/SQL, UTL FILE packages.
• Expertise in UNIX/LINUX.
• Extensive experience in full life cycle of software development process including requirement gathering, design, coding, testing, debugging and maintenance.
• Worked on various process definition, standardization and process improvement initiatives that involved defining coding standards, change request management, configuration management, release management.
• Used Version Controlling tools such as PVCS, GIT.
• Exposure to Tableau, OBIEE 11g, Python.
• Experience in Agile and waterfall developments.
• Experience in Automatic deployment toolsJenkin, Udeploy for higher environments.
• Experience in data model creation.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, SQL Server 2000,MS - Access

GUI: VB, VB.NET,VBA with Excel

Oracle Tools: TOAD,SQL Developer, SQL*PLUS, SQL* LOADER, Forms and Reports 11g/10g.

Documentation: MS Office

Utilities: WinSCP, Putty

Languages: SQL, PL/SQL, Unix, Shell Scripting

Operating Sys: UNIX, Linux, Windows

Other Tools: HP Quality Center, IBM GSM tool, VSS, PVCS, GIT, STASH, Jenkin, Udeploy, CA Workload Automation, Autosys, Tivoli Scheduler and JIRA

Reporting Tools: Crystal Report, Tableau10

Web Technologies: HTML, XML,Jason, Java Script

Development Model: Agile, Waterfall

ETL Tool: Informatica Power Center 10.1.1/9.6.0/9.1.0

PROFESSIONAL EXPERIENCE:

Confidential, NH

Technical Lead

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Involved into writing/updating stored procedures for various admin systems using Oracle PL/SQL packages, functions, triggers, partitioning tables and cursors based on the change requests.
• Extensively used Toad/SQL Developer utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Coordinate with the front-end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Analyze SQL query using explain plan and do necessary changes on the query to fetch the data faster as part of tuning process.
• SQL Adhoc Query Creation.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the DWH oracle database.
• Used Informatica Power Center 10.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression and Lookup, Filter and Sequence generator and Stored Proceduretransformations.
• Developed complex mappings in Informatica to load the data from sources.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Develop autosys jobs to schedule workflows using CA workload Automation tool.
• Responsible for unit testing, and documentation of the interfaces.
• Worked Linux commands.
• Involved in Production deployment & Support.
• Worked in Agile development model.
• Creates star/snowflake schema data model for data warehouse environments based on business requirements.

Environment: s: Oracle 12c,TOAD, SQL Developer,Autosys, Jenkin, Udeploy, GIT, Stash, CA Workload Automation, Agile, Linux AIX and Informatica Powercenter 10.1.

Confidential, MO

Technical Lead

Responsibilities:

• Responsible for collecting requirements from the business users and developing technical specifications from it.
• Preparing and talking to business owners about enhancements and modification of problems.
• Constantly interacted with the team for discussions on approvals of the new design on dimensional/logical and physical database design.
• Involved into writing/updating stored procedures for various admin systems using Oracle PL/SQL packages, functions, triggers, Materialized views, partitioning tables and cursors based on the change requests.
• SQL query Creation/ Adhoc Report creation.
• Preparing Test Cases & Test Results.
• Involved in Production deployment & Support.
• Creation & debug of Shell Scripts.
• Experience in dealing with the XML files for the data transfer between the business systems.
• Extensively involved in ETL code using Informatica tool in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Created Sessions and Workflows using Workflow manager.
• Run workflows from Workflow monitor and jobs for testing.
• Involved in performance tuning and query optimization.
• Used various Transformations like Router, Joiner, Expression and Lookup, Stored Procedure.
• Scheduled the jobs using Tivoli scheduler for automatic execution at the specific timings.
• Worked in onsite and offshore model.

Environment: s:Oracle 11g,Informatica Power center 9.1/9.6, TOAD, SQL*PLUS, XML, Shell Scripting,SQL* Loader, VB.NET, Crystal Report, HP Quality Center, IBM GSM tool, JIRA and PVCS.

Confidential

Sr. Oracle PL/ SQL Developer

Responsibilities:

• Experience in dealing with the XML files for the data transfer between the business systems.
• Parsing XML files using XML type and store data to Oracle Database from Pega front end Application.
• Generated server-sidePL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in the creation of database objects like tables, views, stored procedures,functions, packages, DB triggers, Indexes and Collections.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• SQL query Creation / Adhoc report generation.
• Preparing Test Cases & Test Results.
• Involved in Production deployment & Support.
• Managing 7 member’s team and assigning task to them.
• Mentoring Junior’s.

Environment: s:Oracle 11g, TOAD, SQL*PLUS, XML, Shell Scripting, VB, JIRA, PVCS, IBM GSM Tool, HP Quality Center and Forms/Reports 11g.

Confidential

Oracle PL/ SQL Developer

Responsibilities:

• Coordinated in gathering Business requirements from client.
• Involved in preparing design document.
• Designed and implemented client-server application using Oracle Forms Builder.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Developed various new reports from scratch utilizing Oracle Reports Builder for day-to-day validations.
• Involved in creation of SQL statements creation.
• Developer PL/SQL procedures, Triggers, Functions, Views, Packages and materialized views.
• Preparing test cases & test results.
• Involved in performance tuning of SQL queries.
• Data Migration and Adhoc scripts development.
• Deployment from development to Test/ UAT/ Production box.
• VB,VB.NET application development.
• Crystal report development and call it from VB, VB.NET applications.

Environment: s:Oracle 10g & 11g, TOAD, ADO, PVCS, ODBC, SQL*PLUS, Shell Scripting,HP-Quality Centre, Forms/Reports 11g, VB6.0,IBM GSM Tool.

Confidential

Software Engineer

Responsibilities:

• Involved in preparing design document.
• Involved in creation of SQL statements, procedures, Triggers, Functions, Views.
• VB application development.
• Preparing test cases & test results.

Environment: s:SQL Server 2000, ADO, Crystal Reports, ODBC, VB 6.0, MS Access

Confidential

Programmer

Responsibilities:

• Preparing test cases & test results.
• Involved in creation of SQL statements, procedures, Triggers, Functions, Views.
• VB & Crystal report development.

Environment: s:SQL Server, ADO, Crystal Reports, ODBC, VB 6.0, MS Access

Confidential

Programmer

Responsibilities:

• Involved in creation of SQL statements, procedures, Triggers, Functions, Views.
• VB6.0&Crystal report development.
• Preparing test cases & test results.

Environment: SQL Server 2000, ADO, Crystal Reports, ODBC, VB 6.0, MS Access