SUMMARY:

• 8+years of strong experience in Information Technology as Oracle PL/SQL, MySQL, Oracle APEX forms and UNIX Shell Scripting Analyst with expertise in Analysis, Design and Development of Database and Web Service applications.
• Have in - depth knowledge of Data Warehouse concepts, design and Architecture based on a dimensional model that contain historical data including both detailed and summarized data, consolidate disparate data from multiple sources while retaining consistency & focus on a single subject, such as sales, inventory, or finance.
• Expert knowledge in Oracle Database and Oracle-RDBMS Concepts for forms and reporting solution for Operational Reporting System.
• Extensive work on all the phases of Database life cycle from Requirement Gathering, Analysis and Design to Project Support
• Worked on all types of Projects (Development, Migration & 24*7 Support).
• Designed and developed (OLAP & Non- OLAP) Database reporting solutions for Operational Reporting System.
• Expertise in Cognos, Oracle 9i/10g/11g/12c and PL/SQL Reporting and writing complex and scalable solutions using stored packages, procedures, functions, views and triggers.
• Expert knowledge and experience in Supply Chain Management.
• Expert in Database Concepts, PL/SQL and advanced Oracle concepts such as Performance Tuning, Query Optimization, Materialized Views, Parallel Option, andadvanced Oracle concepts, such as: Bulk Collections, Records, Varrays, Explain Plans, Indexing, HINTS and Partitioning.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Developed the UNIX scripts using KORN shell, Autosys jobs to automate jobs.
• Have expertise knowledge of various development methodologies like Waterfall, Agile, Scrum and SDLC methodologies. Experience in using Agile based tools JIRA.
• Developed using Oracle forms, Unix scripting, PL/SQL and TOAD.
• Experienced working as liaison between IT and Business Users and supporting the users. Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Extensively worked on all the phases of Database life cycle from Business and Functional Requirements Gathering, developing Use Cases, conducting Gap Analysis, preparing Training manuals and Design to Project Support. Experienced in working with Customer experience methodologies, user interface design, website design.
• Experience in developing UML use case diagrams, Work Flow Diagrams using tools like Rational Rose and MS Visio.
• Excellent Business writing skills in creating Business Requirement Document (BRD), Use Case Specifications, Functional Specifications, and System Requirements Specifications (SRS).
• Proficient in soliciting client Requirements through interviews, workshops, existing system documentation and JAD sessions.
• Develop new models, buying tools, and ad hoc reports to address current business problems, optimize sourcing and stocking decisions, or analyze network fulfillment logic.
• Analyze supply plans, identify opportunities to refine replenishment and inventory management strategies.
• Work with Supply Chain business partners to define, scope, and manage new project initiatives.
• Liaison with Data Warehouse and ERP as needed to set priorities, define requirements, vet solution design and test as required for reporting and analytics.
• Leverage SQL or similar skills to efficiently model data to meet business needs.
• Prepare monthly, weekly and ad-hoc reports for Supply Chain leveraging Cognos, Oracle Business Intelligence (OBIEE) and Tableau etc.
• Experienced in preparing test cases of the business process or application. Experienced in presenting trainings to the wider audience. Strong Oracle database experience. Excellent communication skills, Passion for analysis and reporting, Fast Learner; Dedicate, Hard worker and Good Team player.
• Have expertise knowledge in CMM and CMMI Quality measures. Dedicated team player with proven analytical, and communication skills. Demonstrated ability to learn Newer Technologies.

TECHNICAL SKILLS:

LANGUAGES: Oracle PL/SQL, UNIX Shell Scripting

DATABASES: Oracle 12c/11g/10g/9i

OPERATING SYSTEMS: UNIX, MAC OS X, Windows 2003, 2000, 95, 98, XP, Windows NT 4.0, MS DOS.

FRONT END TOOLS: ERWin,TOAD, SQL developer, MySQL4.1,5.X, SQL Server Management Studio

MODELLING TOOLS: MS Visio, Rational Rose, Enterprise Architect, OminiGraffle

APPLICATION SOFTWARE: MS-Office Suite, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, South Florida

Technical (Oracle PL/SQL) Campaign Analyst

Responsibilities:

• Gather requirements and implement changes in existing database design.
• Experienced working as liaison between IT and Business Users and supporting the users.
• Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Develop logical and physical data models that capture current state/future state data elements and data flows.
• Analyze functional specs and created technical specs documents for all the enhancements.
• Developed and refined management and development processes and standards. Managed and coached diverse team of developers, QA and BAs. Delivered multi-platform solutions for sales, promotions, meetings, and recognition teams.
• Create Platform independent schema structure so that the product data can be implemented in any database.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables and Object types.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Developed using Oracle forms, Unix scripting, PL/SQL and TOAD.
• Extract data using SQL via tools such as Oracle OBIEE, Toad, Access, Microstrategy, & Cognos.
• Conducted structured strategic analysis and problem solving (structuring issues and analyzing alternative solutions)
• Presented data and analyses in an organized, clear, and concise manner using PowerPoint.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
• Environment: Microsoft Office, Visio, Oracle PL/SQL, Oracle APEX, TOAD, Cognos v8, UNIX, SQL developer, Windows

Oracle and UNIX Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes and hints on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports. Assisted in defining the scope of the project, technical and business specifications
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning. Coding, Code Review, Technical assistance to team. Test developed program modules against prepared test cases. Ensuring quality and timeliness of product delivery. 24*7 Support of the Project.
• Environment: Oracle PL/SQL, TOAD, UNIX Shell Scripting, SQL developer, Windows

Oracle and UNIX Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions. Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.. Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases. Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements. Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team. Used TOAD, PL/SQL developer tools for faster application design and development.
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements. Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis. Responsible for Analyzing and Implementing the Change Requests. Involved in handling the changes in compiling scripts according to the database changes.
• Ensured data integrity with good process and detected errors and misuses of data.
• Administered MySQL database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization.
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1
• Environment: Cognos, Oracle PL/SQL, TOAD, MySQL,UNIX Shell Scripting, SQL developer, SQL Server 2005,Windows

Oracle and UNIX Developer

Responsibilities:

• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams. Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace. Involved in writing several Queries and Procedures. Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using TOAD Data Modeler. Defined both logical views and physical data structure using Toad Data Modeler.
• Filtered and Loaded data from different formats of data sources into Database Tables. Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database. Experience in Generating Reports. Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.
• Proficient in developing and maintaining of functions, procedures, triggers, indexes using MYSQL database programming language.
• Database designing, development using stored procedures, views, joins etc and performance enhancement activities.
• Creation of Database Objects: Tables, Store Procedure, Views, Triggers, Index, and Function in MySQL.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Created Triggers to enforce data and referential integrity in MySQL.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Environment: Oracle PL/SQL, TOAD, MySQL, UNIX Shell Scripting, MAC OSX, SQL Server 2000

Oracle and UNIX Developer

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
• Made enhancements and applied defect fixes. SADB functionalities: Distribution, Picking, Inventory Control and Invoice. These changes were developed using Oracle forms, Unix scripting, PL/SQL and TOAD.
• Created Technical Design documents for major enhancements and attended Technical Design Reviews.
• Created Summary Designs to address fix/enhancement code change to support Story's acceptance criteria.
• Codes and test software that meets the design specifications. Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Environment: Oracle PL/SQL, TOAD, UNIX Shell Scripting, SQL developer, MAC OSX, Windows