SUMMARY:

• Over 8+ years of experience in Application Development and Production Support using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Excellent working and conceptual knowledge of Oracle, PL/SQL, SQL, Tuning, Developer Forms 10g/9i, and Reports 10g/9i, C/C++, Java, JSP, Servlets, Java Script, XML, Cold Fusion, UNIX Shell Scripting and HTML.
• Experience in OLTP System Study and Analysis, E - R modeling.
• Good understanding of dimensional modeling concepts, start and snowflake schema.
• Adept in all phases of SDLC, from business requirements and technical definitions to development, testing, user acceptance testing (uat), production support.
• Good knowledge on Big Data tools like mapreduce, hdfs, pig, hive, other NoSQL databases (HBase, MangoDB), scoop, oozie, Kafka, flume, spark and zookeeper.
• Very extensive experience in collecting requirements from the business users, preparing the Business Requirement document, technical specification documents, design documents, mapping documents.
• Implemented Tableau visualizations and dashboard designs to facilitate in-depth analytics and decision making among business users.

TECHNICAL SKILLS:Operating Systems: UNIX, Sun Solaris, Linux, Windows

Databases: Oracle 10g/11g/12c, MS SQL Server 2005, Teradata, MS Access, Mango DB, PostgreSQL

Big Data Technologies: Pig, Hive, HBase, Sqoop, Flume, Spark

Front End Tools: Oracle Forms 10g, Staff Mentoring, Oracle Reporting 10g

Other Tools: SQL* Leader, TOAD, SQL Developer, Informatica 9.1, Visio 2000, ERWIN, Net Beans, Eclipse

Programming Languages: PL/SQL, Java, Python, C, C++, Java Script, JSP, HTML, Cold Fusion, Visual Basic 6.0

Scripting Languages: VBScript, JavaScript, HTML/DHTML, XML/XSLT, KSH, C Shell | Perl

Reporting Tools: Oracle Reports 10g, OBIEE, Tableau

Version Control: IBM Rational Clear Case, Subversion

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Sr. Oracle Developer

Responsibilities:

• Involved in designing process and architecture by creating FSD, walk through with business.
• Transformed and extended the capabilities of existing information management system to latest software levels and scalable hosting options, including the ability to use new analytics and visualization features to support business information needs.
• Collaborated closely with business users in designing and architecting processes by creating FSD, technical design documents executing walk-through with client, and partnering with quality assurance for production rollout.
• Developed shell scripts for automation of database tasks.
• Developed PL/SQL packages, stored procedures, and functions and materialized views to perform various data loading and manipulation tasks.
• Implemented table partitions of large tables.
• Created Global temporary tables for intermediate process of building the hierarchies.
• Developed various kinds of reports for both business and technical teams.
• Created AUTOSYS jobs for running the batch processes.
• Worked on optimization of data loading process by loading data though parallel process and tuning long running SQL’s.
• Worked on production support issues, analysis, and resolution.
• Leading offshore team with development and design efforts.
• Developed various mappings to load the data from staging to target tables.
• Implemented various transformations like joiner, filter, lookup and expression transformations.
• Performed unit testing and integration testing.

Environment: Oracle 10/11g, PL/SQL, SQL, SQL Developer, Informatica9.1.0, Perl, C Shell Scripting, UNIX.

Confidential, Pleasanton, CA

Sr. Database Developer

Responsibilities:

• Worked on requirements gathering and formulation of logical and physical design documents.
• Worked with various IT infrastructure teams for DEV, UAT and PROD environments setup.
• Worked on analysis and design of the tool Database.
• Developed PL/SQL packages, stored procedure, functions and scripts for data loading and manipulation.
• Led an offshore team for application development to handle Java development. Performed unit testing, integration testing.
• Involved in production staging and root cause analysis of production issues.

Environment: Oracle 11g, Pl/SQL, SQL, SQL Developer, Java 6, Struts 2, Web Sphere 7.0, Linux.

Confidential, San Francisco, CA

Sr. Oracle Developer

Responsibilities:

• Developed PL/SQL packages to perform staging, validation and loading of conversion data.
• Developed shell scripts to execute the conversion process.
• Created PL/SQL packages and shell scripts to perform volume testing.
• Developed game plans to execute the conversion process.
• Identifying the performance bottlenecks, query rewriting for better performance.
• Developed test plans and performed unit testing, integration testing.
• Involved in production staging, purging and root cause analysis of production issues.

Environment: Oracle 10/11g, PL/SQL, SQL, TOAD 9.2, Korn Shell, UNIX.

Confidential, King of Prussia, PA

Sr. Oracle Developer

Responsibilities:

• Worked on complete SDLC process for developing front-end and back end of database solutions.
• Developed stored procedures, functions, ref cursors to store, retrieve and manipulate data from database. Encapsulated the functionality into packages for an easy interface to the front end.
• Developed SQL loader scripts for data extraction from data feeds to oracle database.
• Created the install scripts for the deployment of the application.
• Designed various user interface screens using Oracle forms 10g in multiple windows on multiple layout styles.
• Developed PL/SQL libraries to share form-level procedures, functions, packages across different modules.
• Used WebUtil core features like Text IO, Host and File transfer to achieve client side integration while running Oracle Forms on the Web.
• Developed Reports using Reports 10g for reporting of standard, master/detail and matrix reports.
• Developed shell scripts to automate data loading.
• Developed a regression suite for unit, integration and functional testing.
• Involved in creation of technical, implementation and user guide documentation.
• Work directly with non-IT business analysts throughout the development cycle, and provide post-implementation support.

Environment: Oracle 10g/9i, Forms 10g, Reports 10g, PL/SQL, TOAD 8.6, Perl, Korn Shell, UNIX, and Windows 2000.

Confidential

Web Developer

Responsibilities:

• Designed and implemented an MS Access -based back-end and a web-based Cold Fusion front-end application.
• Involved in development of the user requirement documentation.
• Gathered business requirements for creating effective data models.
• Involved in modifying enhancement of the site using HTML, Java Script and Cold Fusion.
• Developed the CF Components used in the intranet application.

Environment: MS Access, Cold Fusion 6, Java Script, UNIX, Windows.