SUMMARY

• 8+ Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g , 11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• 4+ years of experience in QlikView and Tableau.
• Strong Experience in front - end and back-end development using Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/9i, XML Publisher, Workflow Builder, SQL, PL/SQL, Oracle 11g/10g/9i/8i and Oracle Designer10g for Data modeling.
• Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite 10g and other front-end tools.
• Strong experience on Extraction, transformation and Loading (ETL) logic using PL/SQL.
• Strong knowledge on Oracle architecture and database design.
• Robust experience in RICEW modules and held positions where major responsibilities included coding, unit testing reports, interfaces, conversions & enhancement programs, workflows and performance tuning on the backend side and considerable experience in UNIX Scripting.
• Designed, developed, and maintain custom components required for Portal sites and Team Sites master pages, Apps, workflows, InfoPath forms, web parts, subsequent activities involved the creation of Views in SharePoint site, Security settings and Permission mappings.
• Strong experience using Unix Shell Scripting, Pro*C, HTML, Oracle 11g/10g/9i/8i, Windows 2000, Windows NT 4.0, Windows 98/95/3.1, MS DOS 6.22.
• Experienced in creating reports using SQL Server Reporting Services (SSRS) sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
• Experience in the Client-Server application development using Oracle 11g/10g/PL/SQL, SQL PLUS, TOAD and SQL Loader.
• Experienced in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Views, materialized views, Bulk collect, Analytic functions (e.g. ratio-to-report, rank etc.) Roles and privileges and others in Oracle 11g/10g /9i database.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions based on the client’s requirements.
• Developed reports using Oracle Discoverer (D2k) by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Expertise in C/C++, Pro*C using Pointer, Structures, Macros, Functions.
• Experience in developing OBIEE Repository at three layers ( Physical Layer, Business Model & Mapping Layer and Presentation layer ).
• Experience in Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005/2008.
• Maintained Three-Tier architecture across all QlikView dashboards.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance &Tuning of Database.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Hands on experience in database administration activities like installation, configuration, and backup & restores, Replication, MS clustering & VERITAS Clustering, database migration and upgradation; hands on experience in automation.
• Strong in Data Modeling including Analysis of requirements Document, Design of the Dataflow, ER Diagrams, Use Cases, Normalization and Demoralization of Tables.
• Good knowledge on Upgrading Oracle Forms & Reports.
• Capable of learning new technologies and processes, and successfully applying them to projects and operations
• Highly dedicated, dynamic, ability to meet deadlines within fast paced environments
• Self-Starter, Result Oriented, Responsible Team Member and Co-Operative Individual.

TECHNICAL QUALIFICATIONS

ERP Application Version: Oracle 11i, R12

Languages: SQL, PL/SQL, C, C++, Java, JavaScript, XML, HTML

Databases: Oracle 8i/9i/10g/11g,DB2, MS Access, My SQL, SQL Server 2014/ 2012/2008 R 2/2005/2000/7.0

Tools: PL/SQL Developer, TOAD, SQL*Loader, SQL*Net, SQL*PLUSData Loader, Erwin

Reporting Tools: XML/BI Publisher, OBIEE, QlikView (11.20 SR3, 11 SR1, 10 SR4), SAS, Tableau (9.x 8.x / 7.x ), SSIS, SSRS

GUI: Forms 6i/9i/10g/11g,Reports 6i/9i/10g/11g,OAF using JDeveloper 9i/10g/11g, Discoverer 9i/10g, Eclipse 3.2.2

Operating systems: UNIX, Windows 98/NT/2000/XP, SUN SOLARIS, LINUX.

Technologies: Oracle Real Application Cluster (RAC), Oracle Golden Gate, Data guard

Web Servers: Apache, Tomcat, OC4J, Oracle Application Server, Web Logic

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Oracle Developer

Responsibilities:

• Validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Modified and debugged stored procedures and triggers.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Support and install various software applications and Participate in the testing process through test review and analysis.
• Created UNIX Shell wrapper scripts for scheduling PL/SQL Stored procedures, Packages and ETL related objects.
• Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL* Loader and extensive use of External Tables.
• Created new C/C++, Pro*C Batch Programs with embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL.
• Used Oracle Discoverer for querying base tables and defining ad-hoc reports for users
• Involved in gathering the Requirement, validate and review data models, ETL interfaces, and also leading the team in coding, testing, performance tuning in developing INFORMATICA mappings and workflows.
• Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
• Performed white-box testing to test InfoPath forms and Web Parts.
• Collaborated with clients and end-users to develop a requirement gathering template which reduced the effort for that phase by 50% and ensured exact requirement capture.
• Customized the GL, Account Receivables, Account Payables, Procurement and Spend Analytics , Order Management, Inventory reports using OBIEE 11g.
• Configured and deployed the application on QlikView server and Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Handled Monthly Production Releases successfully coordinating with various down steam application teams
• Developed Automation Monitoring jobs such as - Reports Summary Statistics, Hourly Reports Execution status, Automatic Resubmission of the Failed Reports and Health Check Status using Shell/Perl 5.8.8 Scripts.
• Handle the Stability/Improvement project - Analyze the Oracle AWR/ADDM report and suggest for performance improvement for slow running reports or jobs, review the database table space with DBA and add space to the tablespace, Investigate Major job failure and come up with solution.
• Developed data access queries and uses OBIEE tools like Answers, builds dashboards and help in development of complex ad hoc queries and analyses
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Designed mappings to populate data from Loan system files to Loan data warehouse using Informatica PowerCenter and design reports on Cognos8.
• Wrote complex SQL queries including sub queries for faster data retrieval from multiple tables.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance &Tuning of Database.
• Involved in deployment of multiple data servers distributed across multiple data centers using MONGO DB.
• Provides highly technical expertise and guidance on evaluation and implementation, tuning and optimization and maintenance of web based reporting and business intelligence systems.
• Involved in interchanging of the data between user and servers using PYTHON.
• Developed test plans and performed Unit tests and involved in SIT with QA team.
• Working with other teams and Clients to gather the requirements.
• Performed unit test on the developed code to ensure that its bug free.

Environment: Oracle 10g/11g, MS SQL Server 2014/2012/2008 R2, PLSQL, Mongo DB, Cognos, Jquery, Javascript, Web applications, Linux, TOAD, UNIX Shell Script, Qlikview 11X/10, OBIEE-11.1.1.5, Tableau, python, Informatica,Windows.

Confidential, Southborough, MA

Oracle Pl/SQL Developer

Responsibilities:

• Developed SQL scripts to create temporary tables.
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Worked on Designing the Oracle Data Model for Wealth management of Wells Fargo External and Internal Clients Projects.
• Designed Design document for Migration of Oracle Database from 10g to 11g. Identified the new features in 11G and implemented them in our Data base architecture for better Partitioning( Space utilization and better Performance)
• Identified Daily Night cycle process scheduled which call PL/SQL, Procedures/ Packages / Triggers and Tuned them for Performance by use of various Oracle Performance Monitoring tools ( Explain Plan/ TKprof, V$ tables for identifying High load sql statements in code).
• Performance tuned 4hours Replication process to 20 min.
• Generated AWR reports to identify issues like Highload sql statements, Cursor Leak issues and resolved them.
• Worked on the Data Replication from Source systems to Target systems. Designed Datamodel and new Schemas to maintain daily transactional data.
• Identified high Volume tables which contain more than 40 million and partitioned them by range /hash based on the data.
• Involved in Upgrading OBIEE from 10g-11g
• Performed the analysis of the application regarding user experience (Front end), QlikView data model change, volume estimation, QVW size estimation, BI processing time saved after consolidation.
• Involved in Extraction, Transformation, Loading (ETL) processes using Informatica 7x, 8x, 9x.
• Improved the performance of databases by Table compression, Indexing data, and also by using shared servers.
• Analyzed Tables and Ran Gather Stats on table to keep the Stats updated so as to achieve Optimal Path in Explain Plan.
• Involved in upgrading software and hardware& managing storage, system monitoring and data migration using MONGO DB.
• Involved in Designing and implementation of low-latency, high-availability, and performant applications by using Python.
• Resolved Table Lock issues (Dead Lock issues) delaying Jobs while Data Loading.
• Created Night Cycle jobs using job Scheduler. ( Millions of Data loaded every day)
• Experience in developing Dynamic SQL and Ref cursors and Use of Immediate Execute to run the SQL statements build during Run time.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors in Oracle 11g.
• Performed Bulk Loading of Data using PL/SQL (Bulk Load Features from Staging Environment to individual Schemas for Loan Approval Process at regular Refresh Rates.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import data from legacy system.
• Involved in development of shell scripts to send invoices to customer through mailing.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• By using different application tuning techniques, performed tuning on customized application including reports and back end programs.
• Planned and implemented backup strategy of data in both archive and non-archive mode.
• Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities).
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Created various tabular, Matrix, Chart, Drill-down/Drill through, sub reports and linked reports using Reports 10g/11g.
• Involved in design and maintenance of databases for .net and Java applications.
• Analyzing the various project requirements and transferring the knowledge to offshore team.

Environment: Oracle Apps Release 12.1.3, RICEW, OBIEE, GL,AR, Discoverer, XML Publisher, Python, XML, UNIX Shell Script, SQL *Plus, SQL *Loader, Data Loader, PL/SQL, BOM, TOAD, SQL Developer, Interfaces, Forms 9i/10g/11g, Reports 9i/10g/11g.

Confidential, Philadelphia, PA

Oracle PL/SQL Developer

Responsibilities:

• Worked on complete Software development Lifecycle (SDLC, from gathering requirements to deployment).
• Created heavy stored procedures by using procedural parameters & worked with packages, blocks & exception handling, Oracle stored procedures, packages, Forms, and Reports.
• Involved writing complex SQL, Stored Procedures, Triggers and monitoring performance to ensure efficient data retrieval and generate forms and reports.
• Created database objects such as Stored Procedures, Functions, Packages, synonyms, Collections, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links and user-defined data types in Oracle according to the business requirement.
• Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
• Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
• Extensively used PL/SQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the client and the business team, when the external feeds to the client are received.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Created various ad hoc reports as of when required for the production analysis and bug fixing.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, I used these tools with EXPLAIN PLAN.
• Develop AP/AR/GL/PO reports using discoverer which include the following PO requisition reports, AR sales profit report with cost of goods, GL Summary Report.
• .Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Tracking the issues in the CC2012 and specifying the solution.

Environment: Oracle Database 11g/12C, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports 6i, Oracle Forms 6i, PL/SQL, UNIX, Perl, XML, JSP, Explain Plans, Oracle Applications 11i, GL, AR, AP, PO, Discoverer, HTML Shell scripts.

Confidential, MN

Oracle PL/SQL Developer

Responsibilities:

• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 11i, Developer 2000 and PL/SQL.
• Coordinated between management, users and technical teams for Requirement Gathering.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Imported data from numerous sources for companies acquired by client, into Oracle AR.
• Work closely with functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.
• Developed reports using Oracle Discoverer (D2k) by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
• Involved in generation of custom XML reports incorporating client’s emblems and other JPEG images for the fancy and quality facilitated reports.
• Upgraded of Custom Reports in payables. EMP ADD/BANK Exception report-(list the employees who are vendors and got incomplete address or bank details), Vendor information report (display vendor information), AP extract summary report (display sum of amount by vendor & account).
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Defined database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL (Extracting Transforming and Loading) Jobs.
• Used SQL *Loader to load the data.
• Generated UNIX shell scripts for automating daily load processes.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Used TOAD and SQL navigator extensively.

Environment: SQL Developer, UNIX, SQL, AOL, PL/SQL, XML, Forms 6i/10g, Discoverer (d2k), SQL*Loader, Reports 6i/10g, TOAD.

Confidential

SQL SERVER DEVELOPER/DBA

Responsibilities:

• Involved in installation and configuration of SQL server 2005/2008.
• Building SQL Server 2008 Production instances.
• Working in various environments like Test, staging and Production.
• Worked on SQL server clustered environment, worked on cluster failover and server reboots.
• Working with tickets routed to Data center queue.
• Working on deployment’s on production- SQL Scripts deployments, SSIS Deployments’, Software upgrade. Deploy CRFs (includes release review, code reviews)
• Testing production change on staging environment and approving for production change.
• Working with disk space issues, permissions, failed jobs, error logs, blocking issues etc.
• Monitored and worked on failed backup jobs and other DBA maintenance jobs.
• Worked on Transaction replication, like adding new articles, deleting existing articles etc.
• Monitoring replication (including blocking reports) and troubleshoot.
• Working on database backups, restores, recovery.
• Working on failed jobs, failed job reports and running error logs.
• Working with Team foundation server for project tracking, resource tracking and CRF tracking
• Involved in database migration, scripting SQL server Shell for future use.
• Worked on backing up database objects.
• CPU testing using performance Monitor, Task manager.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2005.
• Worked on SQL environmental database refresh.
• Used LiteSpeed for database backups and worked in troubleshooting LiteSpeed related issues.
• Worked with developers for the deployments done in production environment.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Involved in installation and configuration of SQL server 2008, applied patches and service packs to keep the database at current patch level.
• Working with sys-ops team for trouble shooting certain issues.
• Worked on Database Detach/Attach wizard.

Environment: Enterprise/Standard Edition SQL Server 2005/2008, SSRS,Windows 2000/2003/2008 Server, Team Foundation server, SSIS, replication.