PROFESSIONAL SUMMARY:

• 12 years’ experience in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• 10 years’ experience of using Table Functions, DML statements, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Dynamic SQL, Records, PL/SQL Tables, Oracle supplied packages, Ref Cursor, External Tables, Query Rewrite and Transportable tablespaces in Oracle PL/SQL
• 10 years of experience in requirements gathering, system analysis, design, development, unit testing, documentation and implementation
• 8 years of experience in application development using Oracle Forms and Oracle Reports
• Experience in RICEF development and support
• Experience in SQL performance tuning using cost - based optimization and knowledge of Query optimizer, Execution plans and Hints
• Designed data warehouse for various business process and successfully implemented BI solutions
• Experience in using SAP Powerdesigner for database modelling
• Developed strategy for ETL and ELT process
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Knowledgeable in application and BI solutions development using Oracle APEXSQL, PL/SQL, AWR, ADDM, TOAD, SQL*LOADER, Informatica PowerCenter 8.6.1/8.1, Oracle Data Integrator (ODI), OBIEE, OBIA, Oracle BI Publisher
• Developed SQL Server Integration Services (SSIS) packages for ETL process
• Created dimensions and cubes for data warehouse using SQL Server Analysis Service (SSAS)
• Created various BI reports, dashboard using SQL Server Reporting Services (SSRS), PIVOT Tables, SAP BO, QlikView, Tableau
• Knowledge of Database administration (Oracle and Microsoft SQL Server) including creating database, tablespaces and data files management, security and auditing, undo management, database performance, recovering database, backup, import/export, RMAN, log shipping, mirroring, replication etc
• Knowledge of Java, ASP .NET programming, R, Oracle E-Business Suite
• Extensively worked on inbound and outbound Interface & Conversion across all the modules of oracle applications including FIN (AP, AR, GL, FA), SCM(OM,INV,PO) and PA(Project Accounting)
• Extensive experience customizing Oracle E-Business Suite application modules, involving the development of RICE (Reports, Interfaces, Conversions, Extensions), Oracle Forms and Reports, XML Publisher (BI Publisher), Custom PLL and Forms Personalization.
• Well versed working with UNIX /Shell Scripting
• Experience in Agile development environment
• Involved in collaboration & team building skills and activities with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.

TECHNICAL SKILLS:

Software tools: Oracle Forms 6i/10g/11g, Oracle Reports 6i/10g/11g, Oracle JDeveloper SQL Developer, OBIEE, OBIA, DAC, Tivoli, Oracle XML Publisher, S-Designer, RMAN, Oracle Enterprise Manager, Oracle SOA, Crystal Reports, TOAD, SQL * Loader, Oracle APEX, SSRS, SSAS, SSIS, Informatica PowerCenter, ODI, Tableau, Crystal Reports, QlikView, JIRA, SVN, Erwin, Visual Studio 2010, NetBeans, Eclipse, Joomla

DBMS/RDBMS: Oracle 10g, Oracle 11g/12c, Oracle RAC, Oracle EXADATA, Microsoft SQL Server 2008/2012/2014, MongoDB,MySQL

Programming/Scripting Languages: Oracle PL/SQL, SQL*PLUS, T-SQL, Java, JSP, SERVLETSUNIX Shell scripting, PowerShell, HTML, CSS, XML, JavaScript, JQuery, C, C++

ERP: Oracle Applications (EBS) R12 12.2.4, R12 12.1.3 and Oracle Fusion Release 7.

Modules: FIN(AP,AR,GL,FA, iReceivables

Application Server/Web Server: IBM Websphere Application Server, Oracle Weblogic Application Server, Apache Web Server, IBM IHS Webserver

Operating Platforms: UNIX, Windows 2000 Server/Professional, Windows NT, Microsoft SQL Server 2005

Networking: CISCO

PROFESSIONAL EXPERIENCE:

Confidential, Mt Laurel, NJ

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Implement FSLDM in data warehouse development
• Finding data sources and create preliminary mapping, mapping and prototype SQL
• Work with ETL developer, data steward and business user to apply prototype SQL for data transformation
• Tune SQL, PL/SQL and database performance tasks
• Create work flow using Informatica Powercenter
• Create and modify existing data flow diagram
• Develop and update logical and physical data model using SAP PowerDesigner
• Create new tables, views as per requirement
• Create data marts, and troubleshoot ad hoc issues while implementing data warehouse
• Production support
• Prepare documentations for change managements
• Writing database objects such as functions, stored procedures, packages and triggers
• Perform operations like Data reconciliation, validation and error handling
• Write PL/SQL scripts to extract the data from the operational database into simple flat text files such as Excel using SQL*Loader, SQL Developer and PL/SQL
• Write complex SQL queries using analytical queries, statistical functions, model queries, regular expression and use built-in packages supplied in PL/SQL.
• Work in Agile environment

ENVIRONMENT: Oracle 12c, Hadoop, Teradata,I nformatica Powercenter, SAP PowerDesigner, Oracle PL/SQL, TOAD, SQL*PLUS, Oracle SQL Developer, Microsoft Visio, Putty, SVN, HP ALM

Confidential, Boston, MA

ORACLE PL/SQL DEVELOPER

Responsibilities:

• System analysis, physical data model design and logical data model design using ESP
• Create data elements, data marts, and troubleshoot ad hoc issues while implementing ESP to clients
• Analyse, design and unit test of solutions for ESP implementations. The development environment is agile and agile methodology is maintained by IBM Rational Team Concert (RTC). Creating associated tasks and story.
• Work with end to end System Testing and UAT teams to analyse, design, resolve opened defects
• Adhered to strict coding standards, performed code reviews and done POC
• Create mapping of feed with category (Database Tables) and troubleshoot data validations issues.
• Write complex SQL queries to create outbound extracts.
• Writing database objects such as functions, stored procedures, packages and triggers to meet the functional requirements using Oracle PL/SQL
• Creating different indexes such as normal, composite, reverse, BIT map, Clustered indexes, Indexed Organization table etc.
• Done performance tuning is at the Mapping level as well as the Database level to increase the data throughput
• Monitor Production data feeds and extract in daily basis and troubleshoot if any issues come arise. Provide 24/7 production and QA support
• Find out issues in AutoSys jobs and resolve the issues.
• Prepare documentations for change managements
• Writing database objects such as functions, stored procedures, packages and triggers
• Perform operations like Data reconciliation, validation and error handling
• Read UNIX server log to find out any issues related to data feeds and extract generation
• Work closely and interact directly with business, technology and product stakeholders to define and document business intelligence solution requirements
• Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HASH, NESTED LOOPs and Hints
• Write PL/SQL scripts to extract the data from the operational database into simple flat text files such as Excel using UTL FILE package and PL/SQL
• Write complex SQL queries using analytical queries (RANK, DENSE-RANK, ROW NUMBER), statistical functions, model queries, regular expression and use built-in packages supplied in PL/SQL.
• Work in Agile environment

ENVIRONMENT: Oracle 11g/12c, ESP, Oracle 11g PL/SQL, TOAD, SQL*PLUS, Oracle SQL Developer, Squirrel, Putty

Confidential, Atlanta, GA

ORACLE PL/SQL DEVELOPER

Responsibilities:

• System analysis, physical data model design and logical data model design using SAP PowerDesigner
• Actively involved in scoring and claiming session of product development
• Lead a team to design and develop application using Oracle PL/SQL, Oracle APEX, Oracle Forms, Oracle Reports, Crystal Reports, OBIEE, OBIA, ODI, DAC, BI Publisher
• Writing database objects such as functions, stored procedures, packages and triggers
• Created table, indexes, views, materialized views, snapshots, synonyms, database links, sequences
• Perform SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Write PL/SQL scripts to extract the data from the operational database into simple flat text files such as
• Write complex SQL queries using analytical queries (RANK, DENSE-RANK, NTILE, ROW NUMBER), statistical functions, model queries, regular expression and use built-in packages supplied in PL/SQL.
• Creating dashboards, reports and PIVOT tables using BI tools and EXCEL.
• Involved in table partition management
• Proactively utilizes OBIEE Reporting and SQL tools to identify data integrity issues and determines the appropriate approach to ensure customer and product data elements are updated correctly
• Multi-dimensional data modelling
• Worked on Informatica PowerCenter 8.6 tool - Source Analyzer, Data Warehousing designer, Mapping and Mapplet Designer and Transformation Designer.
• Perform performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Done the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in ORACLE
• Performed Unit testing and maintained test logs and test cases for all the mappings in Informatica
• Worked with filter transformations and flat files to identify source and target bottlenecks in Informatica
• Use Oracle Data Integrator to design ELT process.
• Prepare documentations for application developed
• Writing database objects such as functions, stored procedures, packages and triggers to meet the functional requirements using Oracle PL/SQL and T-SQL
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Investigated and fixed the bugs occurred in the production environment and providing the on-call support.
• Performs structure data audits on all company foundation system tables to identify inconsistencies or missing information and coordinates with other departments to ensure data retrieval or correction
• Work closely and interact directly with business, technology and product stakeholders to define and document business intelligence solution requirements

ENVIRONMENT: Oracle APEX, Oracle Forms 11g, Oracle Reports11g, Crystal Reports, Microsoft SQL Server Integration Services, Informatica PowerCenter, OBIEE, Oracle 11g/12c, Oracle PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, ODI, Oracle WebLogic Server

Confidential

LEAD DEVELOPER

RESPONSIBILITIES:

• Participate in entire Software Development Life Cycle (SDLC) including requirement Analysis/Definition, Design, Development, Testing, Implementation, Documentation and Support of software applications
• Lead in analysis and development of application and mentor junior programmers
• System analysis, physical data model design and logical data model design
• Setup the project standards for development and create work break down structure for the project
• Develop and implement strategy for change management, risk management for the project
• Prepare documentations for application developed
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages, triggers, functions using oracle PL/SQL and SQL.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE, EXPLAIN PLAN and DBMS SQLTUNE.
• Write PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Designing Business solutions using Oracle APEX, Oracle Forms, Oracle Reports, SSRS, SSAS, SSIS, Crystal Reports, Informatica, SQL, T-SQL, Qlikview, OBIEE, Oracle BI Publisher, Oracle PL/SQL
• Extension of Oracle E-Business suite including AP, AR, Purchasing, INVENTORY modules.
• Data warehouse design
• Design star schema, snowflake schema, cubes, and indexes
• Data mapping and design integration solutions
• Writing ad hoc queries to get different information scattered in various database and tables.
• Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation in Informatica Powercenter
• Perform performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Designing integration package using SSIS
• Create different jobs using MS SQL Server Management studio
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX
• Write scripts for SQL*Loader, use Export/Import utilities
• Performance tuning of database
• Developing reports using Crystal reports
• Universe design, Cube design and Reports creating using SAP BO
• T-SQL and PL/SQL back end programming

ENVIRONMENT: Oracle 11g, Oracle PL/SQL, TOAD, SQL*PLUS, Oracle Forms 10g/11g, Oracle Reports 10g/11g,SQL*LOADER, BI Publisher, SSIS, Informatica, Erwin, SAP Powerdesigner, OBIEE, OBIA, DAC, Tivoli, SSRS, SSAS, Windows Server 2012

Confidential

ANALYST PROGRAMMER

RESPONSIBILITIES:

• Lead a team to system analysis, design and development
• Prepare requirements and functional specifications
• Created detailed design documents based on functional requirements documents, developed use caes, test cases and user acceptance tests.
• Writing SQL queries, functions, stored procedures and triggers
• Work in a team in all the phases of SDLC
• Perform various unit tests to check validity of applications
• Create user Documentation and technical documentation
• Data extraction, data preparation and data loading from various sources to SQL Server database and Oracle 10g database for creating fast report
• Develop application using Oracle PL/SQL, Oracle Forms, Oracle Reports 6i, and Java.
• Create and maintain network
• Involve in the backup database, data migration, restoration and recovery
• Plan for Disaster recovery
• Performance tuning of the database and system
• Database installation, and upgrading
• Developed BI Publisher custom reports involving PO, INVENTORY and GL.
• Developed Reports for PO,AP,AR,GL modules of Oracle E-Business Suites
• Involved in database maintenance such as Export/import, tablespace management, data files management, indexes creation, table partition management

ENVIRONMENT: Oracle ApplicationsR12.1.3AP,AR,GL,PA,Fixed assets, Oracle Payments, Oracle 11g,PL/SQL, TOAD, SQL*PLUS, Oracle Forms 10g,Oracle Reports 10g, SQL*LOADER, Informatica, DTS, OAF,BI Enterprise Edition 11g

Confidential

ANALYST PROGRAMMER

RESPONSIBILITIES:

• Work as a team member in system requirement analysis for Core Banking System
• Developed a range of applications including Planning Information System, Share Management System, Loan Management System, Signature Verification Program and Staff Gratuity Program using SQL, Oracle PL/SQL, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Java, HTML, DTS and Crystal Reports
• Prepared requirements and functional specifications for Core Banking System
• Data migration from Oracle 8i to Oracle 10g
• Technical support for SWIFT
• Assist in the training of staff

ENVIRONMENT: Oracle Forms/Reports, Microsoft SQL Server, Oracle 8i/10g,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Export/Import

Confidential

ANALYST PROGRAMMER

RESPONSIBILITIES:

• Work as a team member of software development team to develop and implement commercial applications including an Insurance Management System and Hospital Management System.
• Create computer network and set up Client/Server architecture to install database in one middle range server and client software in different PCs.
• Provided on site customer support and trained clients as required

ENVIRONMENT: Oracle Forms/Reports, Microsoft SQL Server, Oracle 8i, Oracle PL/SQL, TOAD, SQL*PLUS, SQL*LOADER