SUMMARY:

• 10 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g, 11g& 12c, MS SQL 2005/2008in Production, Staging, Development environments.
• Experience inpharmacy, financial, insurance, healthand telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Created user interfaces with Oracle APEX interactive reports.
• Modified the CGIs to generatedynamic content on web pages andweb applications .
• Developed application using JDBC, Servlets, SQL injection, CCS, jquery, java script.
• Created and modified Oracle forms and reports with Oracle Report Builder.
• Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.
• Extensively used package like DBMS STATS, UTL FILE,DBMS SCHEDULER and UTL MAIL.
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (SmartFTP)
• Exposure & knowledge of designing logical&physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use Case Spec, ER - Diagram, Test Plan, Test Script & Test Cases.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skillsin dealing with customers.
• Experience in Facets & SOA Arch driven environment.

TECHNICAL SKILLS:

Operating System/Languages: LINUX, Sun Solaris 5.10/5.9/5.8, HP-UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP/2000/98SQL, PL/SQL, C, C++, UNIX Shell & PERL Scripting, Java Scripting, JAVA and .NET

Database/Database Tools: Oracle 12C/11g/10g/9i, Netezza 6.0, MS SQL Server 2008/2005, Oracle Enterprise Manager (OEM) 12C/11g, Sybase 15.0.2SQL*PLUS 9.2.0.3, Putty beta 0.63, TOAD 12.0, MobaXterm 3.2, SQL Developer 3.1, Erwin 8, VI Editor, Oracle Apex 4.2.3, Data Stage 8.1, Oracle Forms & Reports 10g & 11g

Data Utilities/Reporting Tools: SQL Loader, Export/Import, Data pump, Explain Plan, Oracle WrapMS SQL 2008/2005, Oracle Forms & Reports 9i/10g, MicroStrategy, SAS, APEX, Clickview, BI/BO

Other Tools & Web Application/Automation Job/Batch Scheduling Tools: HTML 5, XML 1.1, UML 2.3, Filezilla 0.9.40, SFTP 6,WinSCP 5.1, Java SE 7, CSS 3Control - M 7.0, Cybermation 2.0, Autosys 11.3, Cron Jobs

PM Tools: MS Project 2013, IBM RUP 7.5.1, Requisite Pro 7.1, HP Quality Center, Rally

Methodologies: SDLC & AGILE

Modeling Tools: MS Visio 2010, MS Office 2010

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Performance Tuning Expert

Responsibilities:

• Understanding the current requirement and existing environment in terms of data and architecture.
• Working as a Scrum Master in the Agile environment
• Suggested the Hadoop landscape and strategies to extract the data into HDP from SAP and Non SAP source systems like SQL Server, Custom Database, Vertica and Oracle
• Loading data and building the schemas in Hive
• Working on Hbase on Hadoop cluster
• Working on connectivity between analytical tools like Spotfire with Hadoop cluster through JDBC connectivity
• Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
• Involved in developing the roadmap for the Hadoop integration in the organizational landscape and fixing any open issues in order to stabilize both the environments before integration.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Working with Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Working on Talend ETL packages and integrated it with the Hadoop platform.
• Used advancedPLSQLconcepts inProcedure, Package & Functions to move the data effectively as required in various ETL processes.
• Tuned oracle processes build in PLSQL and drill down to the problem SQL and fixed them accordantly.
• Suggested the solutions to the performance issues using techniques like Explain Plan and analyzing AWR Reports in coordination to DBA.
• Responsible for the correct data modeling and successful transfer of data to data lake
• Used Vertica to build and working on validation tool for automated validation of source to target data.
• Worked on security aspect of Spotfire
• Working on performance and load balancing scenarios and issues
• Working on Data Governance using Falcon in HDP

Environment: Oracle 12c, SQL Server 2008 - SSIS, SSRS & SSAS, UNIX, HDP 2.X, Big Data, Hive, Hbase, Spotfire, DB Visualizer, Jquery, HTML 5, CSS, JScript, Bootstrap.

Confidential, Troy, MI

Lead Oracle PL/SQL Developer

Responsibilities:

• Technical assistance to user session to gather & implement requirements in agile environment.
• Provide technical decisions as lead for deliverables for key projects.
• Integrated and implemented enterprise MDM, business intelligence(BI) and DWH solutions.
• Involved in projects to pull the required sources from EPIC andClarity data to handle Confidential t info.
• Primarily worked in maintaining the data for backend table using SQL Queries, PL/SQL package, Function, Stored Procedure, and Cursors.
• Extracted data from Oracle, SQL Server and Clarity using Informatica to load it into a single data warehouse repository.
• Utilized features like Temporary Table, DB Links, M Views, External Tables, Bulk Collect/Bind, Partitions, Collection Methods, Pragma Autonomous Transaction and Dynamic SQL.
• PerformedSQL and PL/SQL tuningand Application tuning using EXPLAIN PLAN and assisted DBA with AWR Reports.
• Handled errors usingException Handlingand Java Script validationextensively for the ease of debugging and hence directing user to provide suitable data.
• Used Oracle HTP.P to deliver embedded HTML5, CSS3, Jquery and Java Script to present web content.
• GenerateUImockups from paper-and-pencil concepts to actual technical prototypes that convey the interaction model.
• Used bootstrap framework, CSS3, Jquery, Java Script and HTML5 for responsive website to enhance user experience for button and overall UI.
• Created ER diagrams and multidimensional data models, reports and diagrams.
• Applied data cleansing/masking techniques to ensure consistency amongst data sets.
• Created relational and dimensional model for multiple applications.
• Developed, managed and organized logical and physical data models using ER-Studio.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, TOAD 10.6, Erwin 8, ER-Studio, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, Jquery, HTML 5, CSS, Java Script, Bootstrap, Remedy, EPIC/Clarity.

Confidential, Grand Rapids, MI

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacted with client in Agileand supervised in preparation of the technical documentation.
• Implemented data quality(DQ) solution for enterprise MDM and BI projects.
• Responsible for testing batch jobs and Upgraded Sybase 12.5.3 to Sybase 15.0.2.
• Wrote scripts to massage data and feed to Sybase IQ/Oracle databases for alert generation and automated in batch cycle using Autosys.
• Generated SQL and PL/SQL scripts to populate datamart on top of the ware house.
• Wrote SP Transformation for oracle work flow in the ETL processes for ODI.
• Enhanced & created DB objects like tables, views, sequences, synonyms, indexes.
• Extensively worked on Nested Tables, Varrays and PL/SQL records.
• Created Cursors and Ref Cursors to process the required data.
• Used Bulk Collect and FOR ALL to DML multi-row from table.
• Created interactive reports with constraints inAPEXfor users to manipulate the actual tables in DB.
• Loaded data from various databases using SQL *LOADER utility.
• Created UNIX shell scripts and scheduled Cron jobs.
• Modified CGIs in Perl which flashes the processed data on Web.
• Defined CSS scripts with custom classes and use them in HTML page to deliver on web.
• Modified the APIs for JDBC connection scripts to pass the data set and invoke proc.
• Hands on experience in using Integrated Development Environments like Eclipse.
• Delivered Java Scripts to generate dynamic views thru HTML scripts.
• Testing and debugging the existing Procedures, Packages and Reports.
• Involved in Sprint planning for iterations in Agile environment.
• Created interactive reports in APEX to provide direct access to the tables in DB.
• Created Oracle Forms and Reports using repeating frame.
• Assisted in documentation for DevTech Approach, UseCase Spec, Effort Estimation and Design Doc.
• Created Oracle Forms and Reports, Stored Procs, Functions, and Packages as per the business need.
• Created automated and manual scripts for satisfying the testing purpose.
• Drill down the root cause of slow running processes & provided suitable performance technique.
• Used Oracle packages - DBMS STATS, UTL FILE,DBMS SCHEDULER and UTL MAIL.
• Wrote Dev Test Plan, Design Doc & Code Review Doc as part of project deliverable.
• Exposure toData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Worked and involved in projects implementing Facets andSOA Arch.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, MS Office Visio, TOAD 10.6, Putty Beta 0.63, Erwin 8, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, C++, Rally, Trizetto’s 4.7, WinSCP 5.1, Sybase 15.0.2, Sybase Central 4.1

Confidential, Collegeville, PA

Sr. Oracle PL/SQL & Vertica Developer

Responsibilities:

• Work with Vertica customers implementing scalability, high availability, migration and consolidation services on Vertica.
• Modified and created tables, synonyms, sequences, views, stored procedures and triggers.
• Ensured conformance to code standards and documentation requirements.
• Compiled Dev Test Plan, Design & Code Review Docs as part of the deliverable to the SDLC artifacts.
• Fixed performance issues and bugs with packages and stored procedures using DBMS PROFILER.
• Performed Unit Testingand ensured all the exceptions are handled according to the business logic.
• Developed complex join queries for Star Schema, Snow Flake Schema, Dimension and Fact table.
• Created B-tree, Bitmapindexes, Partitiontable for enhancing the performance.
• Used Hints and Generate Statistics command to enhance the performance.
• Created effective ETL work flows using PLSQL objects in ODI.
• Used HTML and CSS Scripts to show the tabular structure and web content.
• Scrutinize performance of long running scripts Using AWR reports, Explain Plan, SQL Trace, TKPROF.
• Wrote requirement for the CybermationBatch Scheduling Process.
• Used Datastage for simple to complex load to Master Data Management.
• Wrote Unit Test Cases and Unit Test Scripts for Validated data from SAS to Oracle.
• Created and modified complex Oracle Reports and Forms.
• Loaded flat file using SQL*LOADER into database.
• Used TOAD and Vertica for querying and debugging application.
• Created and modified the file mover Perl Scripts.
• Written Cursors and REF Cursors for transaction processing.
• Implemented database triggers based on the business rules and requirements.
• Assisted in Functional Requirement Specification&Use Case Diagrams to streamline business flow.
• Wrote PL/SQL Rappers for maintaining data & code security.
• Worked in Facets driven Environments.

Environment: UNIX, HP Vertica 7.1.0, Cybermation EST 5.1, Oracle 11g, SQL*Plus 9.2.0.0, Sun Solaris 5.8, Putty Beta 0.60, Oracle Forms and Reports 10g, HPQC, WinCVS 2.0, HTML, MS Visio 2005, Data Stage 8.1

Confidential, Wilmington, DE

Sr. Oracle PL/SQL Developer

Responsibilities:

• Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
• Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
• Leveraged enterprise MDM solutions to enhance the application features.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Used WinSCP for file transfer between different data base servers.
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Wrote complex Perl Scripts to handle pattern search for heavy data loads.
• Modify and made tables for the loading of data from different sources using SQL*loader.
• Used exception methods with pragma exception initto associate customized exception names.
• Used SP transformation and designed data flows for the Datastage Application.
• Handled XML Files for data loading purposes.
• Used UTL file package for automated ETL processes.
• Used APEXto develop end to end Web Application Development.
• MigratedIntegrated Plant System (IPS) fromSybase 11.0 to Sybase 11.5.1.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Involved in the designing of databases architecture and developed the ER Diagrams with ERWIN.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*PLUS 9.2.0.3, SQL Developer 3.1, Toad 10.6, E, HP-UX 11i v3,IBM AIX 5.2/5.3, IBM RUP 7.5.1, HPQC, WinCVS 2.0, WinSCP 4.1, APEX, Data Stage 8.1, Sybase 11.5.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing.
• Developed packages, stored procedures and functions to implement business logic.
• Created Indexes and sequences for faster retrieval of the visitor information.
• Data was loaded from flat files into database tables using SQL* loader.
• Used Crontab to run PL/SQL Scripts and stored procedures.
• Involved in performance tuning with EXPLAIN PLAN and Indexes.
• Worked with Bulk Collect & Bulk Bind to improve the retrieval of multi row.
• Implemented Join conditions, group by functions, correlated subqueries, nested subqueries.
• Created procedures and functions for validation of transaction records into interface tables.
• Worked with different FTP client for loading data from the Windows to Solaris.
• Involved in writing technical documentation, and writing test plan.

Environment: UNIX, Solaris 5.9, Oracle 9i, TOAD 10.4, PL/SQL, SQL*Plus 9.2.0.1, SQL Developer 2.9, Oracle Enterprise Manager, FileZilla 0.9.40, UML 2.1, BugZilla 4.0.0, MS Project 2010.