We provide IT Staff Augmentation Services!

Technical Lead Resume

NH

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

Hire Now