We provide IT Staff Augmentation Services!

Senior Software Analyst Resume

2.00/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • Over 12 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
  • Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
  • Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
  • Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Extensively worked in Client - Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
  • Very Good experience with UNIX Cron Jobs, shell scripting, Batch processing with highly complex data model.
  • Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as General Ledger, Account Payables, Account Receivables, Purchasing, Inventory and Order Management.
  • Implemented performance tuning techniques at application, database and system levels
  • Experience in data extraction from heterogeneous sources using Informatica Power center
  • Experience in UNIX shell programming.
  • Solid understanding of Relational (ROLAP) broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
  • Expert in coding complex and advanced PL/SQL programs using Oracle's Object-Oriented programming, collections, records, index-by tables, object types and methods.
  • Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub- queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
  • Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc.
  • Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
  • Experience in Query optimization&Performance tuning using Explain Plan, Performance Monitor.
  • Experience in developing user interface for database applications using the Oracle Apex.
  • Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
  • Experience in Oracle Apps 11i GL, AP, AR, OM modules.
  • Worked on Oracle development tools likeSQL Developer, Oracle Enterprise Manager, PL/ SQLDeveloper, and usedTOAD in many development projects.
  • Experience in using Informatica to populate the data into Teradata DWH.
  • Experience in SQL tuning using Hints, Materialized Views.
  • Expertise in understanding Fact Tables, Dimension Tables, Summary Tables

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/

Databases: Oracle 11g/10g/9i/6i, Teradata 12.0/13.x/14.10,DB2, SQL Server 2005/2000 Reports Oracle Forms 11g/10g/9i/6i, Oracle Reports 11g/10g/9i/6i

Programming Languages: C, SQL, PL/SQL, C++, Shell Scripting. Scheduling tools Control-M, Maestro,Autosys

Operating System: Windows 9x/NT/2000/XP, UNIX/LINUX

Others: Toad, Teradata SQL Assistant, View point, MS Word, MS Excel, MS PowerPoint, Outlook.

PROFESSIONAL EXPERIENCE

Senior Software Analyst

Confidential, Tampa, FL

Responsibilities:

  • Loading data from various sources and legacy systems to data warehouse using Teradata MLOAD,FASTEXPORT,BTEQ,FASTLOAD utilities.
  • Experience in using Teradata SQL Assistant, data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata.
  • Involved in requirements gathering and data gathering to support developers in handling the design specification.
  • Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
  • Extensive experience in writing and executing BTEQ scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
  • Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and FASTLOAD scripts.
  • Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
  • Created proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Write numerous BTEQ scripts to run complex queries on the teradata database.
  • Involved in getting the User Requirements, Data Modeling & Development of the system
  • Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
  • Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated in Performance Tuning using Explain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed UNIX Shell Script as required.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable

Oracle/Unix/Informatica Developer

Confidential - Charlotte, NC

Responsibilities:

  • Involved in getting the User Requirements, Data Modeling & Development of the system
  • Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
  • Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated in Performance Tuning using Explain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed UNIX Shell Script as required.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Developed UNIX Shell scriptsto automate table creation, execute procedures.
  • Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bind Variables while writing Dynamic SQL to improve performance
  • Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
  • Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, and LISTAGG& ROW NUMBER Functions for sorting data.
  • Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
  • Extensively worked on creating partition indexes for large tables.
  • Optimized code for the better functionality of several procedures, packages, functions and Triggers.
  • Successfully validated all shell scripts on new Linux environment.

Oracle PLSQL Developer

Confidential

Responsibilities:

  • Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
  • Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated in Performance Tuning using Explain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bind Variables while writing Dynamic SQL to improve performance.
  • Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
  • Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, and LISTAGG & ROW NUMBER Functions for sorting data.
  • Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
  • Extensively worked on creating partition indexes for large tables.
  • Optimized code for the better functionality of several procedures, packages, functions and Triggers.
  • Successfully validated all shell scripts on new Linux environment.

Oracle/Unix/Informatica Developer

Confidential

Responsibilities:

  • Managing client requests on Business as Usual and resolving the same in time
  • Analysis of business/technical specifications and Impact analysis.
  • Understand and analyze requirements, follow up with business analysts and subject matter expert team for any clarification, if required.
  • Creation and Review of test conditions based on requirements, and getting sign-off on test conditions from respective business analyst.
  • Designed the tables, indexes, triggers, stored procedures, functions and packages to implement the requirement.
  • Writing PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
  • Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated in Performance Tuning using Explain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bind Variables while writing Dynamic SQL to improve performance.
  • Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
  • Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, and LISTAGG &
  • ROW NUMBER Functions for sorting data.
  • Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
  • Extensively worked on creating partition indexes for large tables.
  • Optimized code for the better functionality of several procedures, packages, functions and Triggers.
  • Successfully validated all shell scripts on new Linux environment.

Oracle/Unix/Informatica Developer

Confidential

Responsibilities:

  • Managing client requests on Business as Usual and resolving the same in time
  • Analysis of business/technical specifications and Impact analysis.
  • Understand and analyze requirements, follow up with business analysts and subject matter expert team for any clarification, if required.
  • Creation and Review of test conditions based on requirements, and getting sign-off on test conditions from respective business analyst.
  • Designed the tables, indexes, triggers, stored procedures, functions and packages to implement the requirement.
  • Writing PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
  • Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
  • Created PL/SQL Packages for easier application design and improved Performance.
  • Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
  • Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
  • Participated in Performance Tuning using Explain Plan.
  • Tested, Installed, Documented and provided On Call Support for the Applications.
  • Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
  • Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
  • Extensively worked on creating partition indexes for large tables.
  • Optimized code for the better functionality of several procedures, packages, functions and Triggers.
  • Successfully validated all shell scripts on new Linux environment.

We'd love your feedback!