SUMMARY:

• 15+ years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies & Data Warehousing on Windows Platforms.
• Adept in Oracle, Oracle Tools and Utilities; SQL and PL/SQL.
• Used several tools like SQL*Plus, SQL*Loader, SQL Developer and Toad.
• Created database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database Links as well as Custom Packages tailored to business requirements.
• Experience in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader.
• Possess strong Documentation skill and knowledge sharing among team, conducted data modeling.
• Extensive experience in working for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify Logical entities.
• Worked on Oracle forms different version like 4.5/6i/ 10g.
• Experienced in Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Well versed in MS Office Suite such as Word, Excel, Access and PowerPoint.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Very good Analytical and Problem-Solving skills with strong communication and interpersonal skills.
• Highly-adaptable, flexible, team-player, pro-active and eager to learn and perform new tasks.

TECHNICAL SKILLS:

Operating System: Windows 95 to Window 7, Unix, Linux,AIX, DOS

Programming Languages: Oracle PL/SQL, C, C++, Pro C*, Python, Unix Shell Scripting.

Databases & Tools: Oracle Database 8i, 9i, 19g, 11g and 12cOracle SQL Developer, TOAD, Oracle Forms 4.5 6i, 9i, 10g, 11g and 11g. Oracle Reports 2.5, 6i, 10gSnowflake

Other Tools & Utilities: Putty, Hummingbird, FileZilla, WinSCP, Smart Term, UltraEdit, TextPad, Edit Plus, PVCS, SVN, Microsoft TFS, Visual Source Safe, Pycharm, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Coral Spring, FL

Software Engineer

Responsibilities:

• Migrating on premises oracle exadata tables into snowflake database.
• Written the python script to automize the Dimension tables load.
• Changing the existing python and Unix script to better performance and developing new enhancement.
• Finding the opportunity for existing system improvement to atomization using python scripts.
• Designing the snowflake pipes for continues loads for small tables
• Designing and implementing the data sharing to show Analytical data to Business user or Client.
• Creating cloning database in snowflake to support QA related activities.
• Creating the Oracle Database Objects like View, Procedure, functions and packages to complete customization .
• Working with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Supporting the existing system on call on weekly rotation bases.

Confidential, Monroeville, PA

Responsibilities:

• Attending the Requirement Meeting with Business Team related to SPARCS Application modules like Adjustment Transfer Processing
• Understanding the current business scenarios and requirement.
• Analyzing the requirement and SPARCS Application for checking the requirement functional and technical feasibility
• Designing the Current and Proposed Solution and proposing the solution to CVS.
• Providing an estimate and schedule for development phase for the project and help project manager to plan the schedules of subsequent phases.
• Developing the proposed solution using Oracle Forms and Oracle PL/SQL, Unix, Json Technology.
• Guiding the offshore development team for development and making them understanding the requirement.
• Tracking the Offshore development on daily basis to make sure project execution.
• Preparing the UI Document for Business User to understand new proposed solution.
• Deploying the new solution in the production and supporting the new solution in production as well.
• Create the system master forms to create the users, responsibilities, user rights, assigned the privileges, add the menus, add the reports and forms.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Worked with SQL loader and control files to load the data in different schema tables.
• Supporting QA Testing to make data in various business functional scenarios
• Supporting User Acceptance Testing in various environments
• Involved in production support by efficiently debugging the production issues.
• Developed tables and created indexes, constraints, triggers, synonyms, roles etc in different schemas.
• Making the use of feasibility of Customer Messaging and Bulk File Loading tool to reduce the Development phase and providing a new feature to business to reduce the business process steps.

Confidential, Jersy City, New jersy

Responsibilities:

• Analyze, design and build customized applications for assigned projects.
• Maintaining the client quality standards in the project artifacts.
• Developed process to select multiple files for different domain and load into the system which helped atomize the ETL process.
• Developed Technical Objects related to ETL process to work automatically and dynamically.
• Developed system to feed the file key column to process ETL job and look for processing type to run automatically.
• Creating the mapping document, understanding the business requirement.
• Attending meeting with business to understand the business
• Creating Technical DD for mapping document and design the ETL process
• Writing the code for ETL job and mappings.
• Creating the unit test cases and execution of mapping to verify.

Confidential, Charlotte, NC

Responsibilities:

• Worked on the requirement gathering and understanding by meeting with Business analyst.
• Preparing the technical understanding document.
• Developing the Forms/Reports as per the requirement
• Developed the query forms (based on database or non-database block).
• Developed the data entry complex forms (master details with tabs)
• Developed the master reports.
• Create Menus and add forms objects.
• Create the system master forms to create the users, responsibilities, user rights, assigned the privileges, add the menus, add the reports and forms.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in production support by efficiently debugging the production issues.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, roles etc in different schemas.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Coordination with the Release Management team to ensure the version control of the scripts execution in various environments from Development to Production.

Confidential, Burlington, MA

Responsibilities:

• Working on the requirement gathering and understanding by meeting with Business analyst.
• Preparing the technical understanding document.
• Writing pl/sql procedure/packages/functions to resolve the daily task related issue to make them atomized.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Created scripts to load the data into staging tables from another database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in production support by efficiently debugging the production issues.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Worked on Oracle Data dictionaries views to get information related to object
• Wrote Scripts for Creating the Database Objects to configure initial basic setup.
• Worked on Bulk Collection and Pl/sql table for getting optimal performance.
• Created Views, Dynamic SQLs, V-arrays

Confidential

Responsibilities:

• Worked in requirements and developed models according to the customer’s specifications and drafting detailed documentation for the same.
• Worked in PL/SQL to develop packages, stored procedures, functions and database triggers and views.
• Worked in Tuning SQL queries using Explain Plan improve performance of the queries.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from another database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with SQL loader and control files to load the data in different schema tables.
• Understanding the new features of oracle Database 10g and implemented the new suggestions for Improve Database performance.
• Worked on People soft SQR Code to create the Clients Reports.
• Worked on Oracle Data dictionaries views to get information related to objects.
• Took part into the Database Unit Testing for Report generation for Client.
• Worked on Unit Test case Preparation /Unit Test Results.
• Provided technical support to another team member to achieve tasks in time frame / another department teams as well.

Confidential

Responsibilities:

• Designed Time sheet/ payroll / store related table as per Client requirements.
• Developed Preliminary/Detailed level of Design Documents for requirements.
• Developed Time sheet/payroll related table for store mapping modules.
• Developed database Objects for payroll /timesheet /store Details Reporting like Procedure, Views, Cursors.
• Developed Oracle forms for Oracle Reporting purpose with dynamic settings
• Developed Timesheet Entering / Payroll Report generating forms.
• Developed Oracle Reports for Payroll/timesheet/store Details Reporting.
• Worked on Oracle Data dictionaries views to get information related to object
• Worked on SQL Loader to upload store related data received from Different stores.
• Extensively worked in Oracle Forms 6i /Reports 6i
• Worked in PL/SQL to develop packages, stored procedures, functions and database triggers and views.
• Created Database Links for Different Database.
• Worked on Transforming the data from once Schema to another schema tables to provide the access for reporting purpose
• Highly involved in preparing Unit Testing by preparing Unit Test case and execution.
• Created Unit test plan and Unit Test Results Documents.
• Worked on Production environment for execution of changes like scripts, new changed form, database Objects and UAT.