SUMMARY

• Profile: Results driven skilled Software Architect with strong interpersonal, communication skills, and analytical skills. Quick learner having high learning acumen to adopt new tools and technologies. Ability to work under pressure and deliver consistent results that exceed expected results.
• 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 reference
• 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