EXPERIENCE SUMMARY:

• Over 8+ years of progressive and diversified IT experience in RDBMS like Oracle, Big data analytics using Greenplum, all phases of software development life cycle, design and architecture of distributed, client - server systems.
• Over 8+ years of significant work experience with Oracle Architecture and PL/SQL programming
• Over 2+ years of experience with MPP ( Massive Paralleling Processing) systems like Greenplum
• Highly skilled in PL/SQL development and Postgresql development (Big data analytics) including requirements analysis, Database Design, Implementation of enhancements and maintenance of enterprise software applications
• Strong abilities in Data Analysis/Modeling, Views, Normalization, Stored Procedures using Oracle 11g/10g/9i/8.x
• Detailed depth knowledge in Oracle Architecture, Greenplum Architecture, Data dictionaries and DBMS Packages
• Very Good Knowledge about the Oracle tools like SQL*PLUS, TOAD, SQL DEVELOPER.
• Expertise in Query tuning, Performance tuning and troubleshooting the issues of complex software applications
• Expertise in creating Database elements: PL/SQL stored procedures, Postgresql Functions, Collections, Cursors, Packages, Constraints, Views, Triggers and Sequences
• Expertise in using Joins, Oracle cursor management and exception handling in Java and PL/SQL
• Ability to migrate the code from one database to the other such as Oracle to Greenplum
• Extensive experience with the ETL tool IBM InfoSphere DataStage
• Experience in UNIX Shell Scripting & scheduling jobs using CRONTAB.
• Experience in various data modeling tools like Erwin, Microsoft Visio, and ER-Studio.
• Tested deliverables for conformance with requirements and specifications, including Unit, Module, Integration System testing, Regression Testing and User Acceptance Testing.
• Well versed with both agile and water fall methodologies
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.

TECHNICAL SKILLS:

Programming languages: SQL, PL/SQL, Postgresql, Java/J2EE, COBOL

Relational Databases: Oracle 11g/10g/9i/8i, Greenplum, DB2 and SQL Server

Data Modeling tools: Erwin, Visio, SQ Diagrams

Software Tools: TOAD, SQL developer, Eclipse, Vmware player, PGADMIN III, putty, IBM ID DS 8-5 Dsigner, Secure CRT, Winscp,Visio and Beyond Compare

Scripting: JSP 2.1, Java Script, HTML, DHTML, CSS, Unix Shell Scripting.

Functional Areas: Project Life cycle development, Design and deploy complex BI solutions, Excellent skills in Report Design, Excellent client relationship management skills.

Operating Systems: Windows Server/Vista/XP/ 2000/2007/2008, ubuntu, unix/linux

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Oracle PL/SQL Developer

Responsibilities:

• Requirement gathering and analysis through client meetings
• Designing the table structure and creating the scripts for the same.
• Acted as module lead and assigned the work to team members and aggregated their work
• Development of PL/SQL standalone procedures, Packages, functions, views, triggers, cursors sequences and collections
• Responsible for trouble shooting the production issues
• Experience working with E-R diagrams and data flow diagrams.
• Unit testing the application thoroughly to check whether application is meeting all the requirements and providing test cases for the same
• Used various PL/SQL collections like VARRAYS, NESTED TABLES and ASSOSIATIVE ARRAYS
• Used bulk techniques like FOR ALL, BULK COLLECT to improve the performance.
• Used Oracle UTL SMTP packages to send out automated emails.
• Generating DB scripts to deliver the code to QA team and following up with the DBA team until the completion of delivery of code
• Created all types of cursors like Implicit cursors, explicit cursors and Ref cursors
• Preparing functional and technical documents for all the modules
• Maintaining the issues log for future
• Performance tuning the code using EXPLAIN PLAN, AUTO TRACE and TKPROF utilities

Environment: SQL Developer, PL/SQL, Oracle 11g, WinScp, Java/J2EE, Jason, Jquery, Ibatis, CWF-Common Web Framework, Erwin, Visio and IBM Rational Clear Case

Confidential, TX

Oracle PL/SQL Developer

Responsibilities:

• Involved in the Design and Documentation.
• Involved in Mathematical analysis and forecasting algorithms.
• Involved in Complex Costing calculations.
• Used regression functions to forecast the load.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Used Objects, types & built API’s on backend to interface with UI.
• Used collection / PL-SQL Objects to enhance the performance.
• Developed Korn Shell scripts & Pl/SQL Jobs to schedule and automate the jobs.
• Used Explain plan to figure out the cause for poor performing queries.
• Performed unit and integration testing of the applications created using Oracle Forms 10g and PL/SQL modules and used PVCS for version control in team development.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Provided production support: solving defects, code debugging.

Environment: Oracle 10g, Microsoft SQL server 2005, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6, AIX 7.1.

Confidential, Jersey City, NJ

Greenplum Developer

Responsibilities:

• Responsible for executing key initiatives, projects or project components
• Understanding and analyzing the Oracle pl/sql code logic and implementing the same in Greenplum postgresql
• Understanding and analyzing the flow of Data stage jobs and implementing the same in Greenplum postgresql
• Designed the table structure according to the relations between them
• Generated the scripts to create tables and table level constraints
• Design and development of various reports that are dynamic
• Monitoring and Implementaion of new changes that occurred in Oracle code regularly
• Maintaining all the versions of both PL/SQL and Postgresql code to analyze and optimize according to the requirements and flow of changes
• Unit testing and creating the test cases for all the modules
• Responsible to trouble shoot the production issues
• Performance tuning the code for optimal output by using EXPLAIN PLAN
• Providing permanent fixes to avoid broadcast motion that occurs in the code
• Creating shell scripts to run the code daily at particular reports as part of daily reports generation
• Created relevant big picture of all the reports that will be generated according to the flow in the system

Environment: PGADMIN III, Postgresql, Greenplum, Toad, PL/SQL, Oracle, IBM ID DS 8-5 Designer, Winscp, Unix.

Confidential

Oracle(PL/SQL) Developer

Responsibilities:

• Requirement gathering and analysis through client meetings
• Analysis and design of application
• Development of PL/SQL standalone procedures, Packages, functions, sequences and collections
• Responsible for trouble shooting the production issues
• Involved in understanding of new requirements by attending all the meetings
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Managing tables, indexes, constraints, views, sequences, synonyms and stored program units.
• Performance tuning the code for reducing the complexity and improving the performance
• Preparing functional and technical documents for all the modules
• Extensively used complex SQL queries (Sub-queries and correlated sub queries).
• Running the batch jobs regularly for monitoring the performance of system

Environment: SQL Developer, PL/SQL, Oracle, Java/J2EE, UNIX