We provide IT Staff Augmentation Services!

Software Engineer Resume Profile

SUMMARY

11 years in analysis, data modeling, design, development for Financial, Pharmaceutical and ERP Extensive experience interacting with system users and gathering business requirements and Logical and Physical Data modeling and ETL implementation for data centric systems.

SKILLS

  • PL/SQL ETL Expert in SQL, PL/SQL, Stored Procedures, Packages, Knowledge of ETL using Datastage like Join, Funnel, Remove Duplicates, Merge, CDC, Lookup, SCD type1,2,3 and assist onshore/offshore development team, assign tasks and code review.
  • Data Modeling Conceptual/Logical/Physical data modeling, Data Warehousing concepts including Star Schema e Schema, Data marts, conformed dimensions and facts, Surrogate keys, ODS, Warehouse database design and implementation Reverse engineer existing applications for enhancements, Generate dimensional model from relational data model.
  • Databases Oracle, SQL Server, MS-Access, Skills in writing complex SQL, Procedures, Functions, Triggers, Cursors in Oracle and SQL Server, Performance tuning techniques including partitioning and indexing strategies.
  • Reporting Crystal Reports, Data reports and OLAP.
  • UNIX Shell Scripts, get and put files from/to FTP servers, Scripts to execute Datastage command line, stored procedures SQL loader scripts.
  • Enterprise Scheduling
  • Tool AutoSys to create jobs dependencies and schedules. File watcher token files job orchestration
  • Primary Skills Data Architecture and Design, ER Modeling, Dimensional Modeling, ETL, Business Problem Analysis
  • Languages/Tools SQL, PL SQL, Transact SQL, ETL, Autosys, ERWIN, Datastage, Visio, Java, J2EE, ASP.NET, C , VB.net and UNIX Shell Scripts
  • Data Analysis Business Problem Analysis, Mapping document, Identify Data discrepancies, Create Data Flow Diagrams, Analyze Information flow between systems, Test Plans

EXPERIENCE

Confidential

Sr. Oracle Developer

Responsibilities:

  • Requirement analysis and Functional design.
  • Analyzed the existing application and re-designed the Relational database according to new requirement
  • Involved in migrating the application to new database framework.
  • Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
  • Writing complex procedures, functions using analytical functions, Pipelined functions.
  • High and detail level design activities including indexing, partitioning for optimal performance.
  • Query tuning, explain plan, AWR reports.
  • Unit Testing and data validation using JUnit test cases of applications.

Environment: Eclipse, Cloud based framework CDT 3.0 , Java 7, Oracle 11g, UNIX, TOAD, PL/SQL, Windows XP, SVN, ClearCase, ClearQuest, Fiddler, ER win, Wirshark.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Conduct requirements gathering with users and design sessions with business analysts, application architect
  • Created functional/technical specifications, testing scenarios, prepared test cases.
  • Explore data-oriented structures from high-level conceptual models to logical dimensional modeling.
  • Assist DBAs in physical implementation.
  • Data flow, Data dictionary and Mapping documents.
  • Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
  • Used various Indexing and partition techniques to improve the query performance.
  • Profiling and mapping sources into the target model.
  • Query tuning, explain plan, AWR reports.
  • Implemented SQL and PL/SQL stored procedures.
  • Developed UNIX scripts and PERL Scripts.
  • Created views, stored procedure, Packages.
  • Prepared test case and test results.
  • Reviewed the test cases and code developed by team members.

Environment: Datastage, Oracle 11g, UNIX, PL/SQL, Shell Script, PERL, TOAD, Windows XP, ER Win, Autosys, ClearCase, ClearQuest.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Involved in all phases of SDLC as active participant.
  • Hands on experience on Relational database design, STAR schema design, and ETL development.
  • Based on requirements estimations provided for new development and enhancements.
  • Developed excel reports using sql and PL/SQL stored procedures.
  • Performance tuning on existing SQL to improve application performance.
  • Created Materialized views for summary tables for better query performance.
  • Used various Indexing and partition techniques to improve the query performance.
  • Developed UNIX scripts.
  • Used Explain Plan and AWR reports to tune the complex queries and debug the queries to provide exact solution.
  • Participated actively to migrate database from other source system to ERP system.
  • Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
  • Performed code review and mentored junior developers.

Environment: Datastage, Oracle 10g, TOAD, UNIX, PL/SQL, Shell Script, Windows XP, Java, J2EE, VISIO, Autosys, ClearCase, ClearQuest.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Developed Customized screens by using screen configurator and XML.
  • Implemented Workflows with workflow configurator tools.
  • Implemented Scenario manager and AML.
  • Debug the application s with help of log files and suggested logged applications issues with suggestions.
  • Hands on experience for performance tuning on existing SQL / PL SQL to improve application performance.
  • Created tables, views, stored procedure, Indexes, Packages PL /SQL .
  • Used various Indexing techniques to improve the query performance.
  • Tuned the complex queries and debug the queries to provide exact solution.
  • Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS Native Dynamic SQL .
  • Used SQL Loader and UTL FILE to read and load data into report schema from different flat files.
  • Worked as Oracle Admin to execute DDL, DCL commands.
  • Prepared test case and test results.
  • Review the code and test cases within team members.

Environment: Norkom 5.8 Version, Oracle 10g, UNIX, PL/SQL, Shell Script, Windows XP, VISIO, TOAD, SQL Loader.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Hands on experience for performance tuning on existing SQL to improve application performance.
  • Strong experience to analyze the existing and proposed systems.
  • Based on requirements estimations provided for new development and enhancements.
  • Proactively came up with innovative methods to improve software quality, test coverage, efficient and regression coverage.
  • Exposure on reporting tool Crystal reports.
  • Exposed on UNIX scripts and environment.
  • Hands on experience to create views, stored procedure, Packages PL /SQL
  • Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
  • Participated actively to migrate database from other source system to ERP system.
  • Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
  • Prepared test case and test results.
  • Review the test cases and code developed by team members.

Environment: Oracle 10g, UNIX, PL/SQL, OEM, Shell Script, Windows XP, ERWIN, TOAD, SQL Loader.

Confidential

Sr. Software Engineer

Responsibilities:

  • Involved in all phases of SDLC as active participant.
  • Involved in project plan and Risk plan.
  • Based on requirements estimations provided for new development and enhancements.
  • Proactively came up with innovative methods to improve software quality, test coverage, efficient and regression coverage.
  • Exposure on reporting tool Crystal reports.
  • Developed excel reports using sql and PL/SQL stored procedures.
  • Used admin console to monitor queue s .
  • Used Eclipse, logging files for troubleshooting and debugging Java applications.
  • Exposure in running the java unit test cases of JUnit by configuring the JUnit testing environment to ensure the functional flow if the application throw any run time exceptions or application break.
  • Used Weblogic admin console to monitor queue s .
  • Experience in building small java module in Eclipse IDE.
  • Exposed on Unix scripts and environment.
  • Hands on experience to create views, stored procedure, Packages.
  • Interacted with business analyst and software developers for bug reviews and participated in QA meetings.

Environment: Oracle 9i, Windows NT, PL/SQL, SQL Loader, VISIO, TOAD, Java, Eclipse, Java Script, JDBC, Java Servlets, JIRA

Hire Now