SUMMARY:

• 6+ years of IT experience in software development with specialization in systems and requirement analysis, design, development, implementation, and Production support of Oracle based applications.
• Rich experience in Agile - Scrum and Waterfall based software product development
• Proficient in developing Multi-tier Architecture Distributed Applications.
• Extensive Hands on experience in creating Oracle PL/SQL objects such as Packages, Triggers, Procedures, Functions, Ref Cursors, Collections. Proficient in writing Complex SQL queries and performance tuning which includes Joins, Indexes, Explain plans, Hints, Materialized Views etc.
• Experience in working with Banking and Financial Domain, Media Domain, Shipping Domain and Retail domain.
• Working as a Technical Leader cum Coordinator with Synapse (A subsidiary of Time Inc.) also as an SME (Subject Matter Expert) and Sr. Lead Developer.
• Area of experience in the current assignment is analysis, development and design of highly mission critical projects, managing teams, enhancements, maintenance, bug fix and production support
• Expertise in Client/Server technology using Developer/2000 Forms 4.5/6i & Reports 2.5/6i as front-ends with ORACLE … as back-end.
• Technological forte is Oracle PL/SQL 11g, Oracle Forms 10g and UNIX Shell scripting, Pro*C, Oracle Apps SCM (Supply Chain Management, Manufacturing Module INVENTORY, BOM, and WIP).
• D2k applications which includes MES (Manufacturing Execution System), Artemis Application etc.
• Knowledge on the theoretical concepts of Java basics and theoretical knowledge of DBA activities.
• Worked as an onsite coordinator for offshore team, acting as a SPOC between end client and offshore team.
• Self-motivated and committed team player with excellent communication and interpersonal skills.
• Quick learner, versatile, adaptable and process-oriented, with a high customer orientation.
• Excellent Leadership, Technical, Communication, Analytical and Problem Solving skills and ability to get on well with people including cross-cultural backgrounds.
• Team player to accomplish business Engineering, Integration, Deployment and Maintenance of e-business systems.

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Design and developed EDI Manager Process to load files in real-time in VHOS system using SQL* LOADER, PL/SQL Package, UTL File. These files provide twelve month historical data that need data cleansing, wrote API's in PL/SQL to upload the data in staging tables, later processing and enhanced error logging and reporting system using DBMS MAIL and custom API's.
• Modified Amendment reporting process and created multi-threaded job process design, using DBMS SCHEDULER and Advance Queuing (AQ). This process is also tuned to perform optimal in 11g environment.
• Process Tuning of various Nightly jobs that we rarely analyzed for the use BULK collect and optimizing parameters and adjusting hint and index by reviewing the Trace files, after upgrade to 11g data base.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using Oracle tools like PL/SQL Developer, SQL* Plus, Toad
• Developed ability for users to re-forecast job for specific contract and/or customer and generate variance report by creating materialized view that run through nightly job. Other support work
• Review and Fix open Bugs as reported from Phase-1 of LCF trueup.
• Fix open ticket as created by users that includes code modification and issue analysis.
• Provide support to user with Ad hoc queries for day to day business requirement.
• Provided test support for System Integration Testing (SIT), Live and End to End testing to VHOS retails users.
• Troubleshoot performance issues and bugs within packages using traces file, explain plan and oracle database parameter tuning.

Environment: Windows 7, Oracle 11g, 9i, SQL, PLSQL, SQL loader, Toad, Visio, SQL Developer, UNIX

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Discussed and reviewed Business Requirement Documents with BA's.
• Designed data model as per requirement document and created DFDs.
• For bulk data updation analyzed data and created reports to show the impacts to users.
• Developed database objects ie tables, functions, procedures, packages, triggers etc to implement the functionality of the projects like added new section in application to capture new parameters and display them, created a page through which a excel file would be accepted which will be parsed and different fields will be stored in different tables after validation etc.
• Developed DAO layers in applications to access the db objects from Java.
• Developed Activity layers to call the methods of DAO layers.
• Provided support to frontend developers by coding some Beans and Manager classes.
• Performed unit testing of modules.
• Performed integration testing of modules.
• Performed database code review of peer.
• Created db deployment package by creating the shell scripts and sql files.
• Kept db scripts using SVN and checked/validated the changes made by other developers before deployment.
• Tested and deployed the package in Dev, Integration Testing, QA and UAT environment.
• Worked with Bas to receive sign off on UATs.
• Provided support to DBA's with db deployment on production environment.
• Worked with other downstream systems to co-ordinate changes and dependencies before and during deployments.
• Debugged and fixed issues in production.
• Worked on creating package to add partitions on a transaction table and scheduled it through dbms scheduler.
• Performed house-keeping activities of dev, ite, qa and uat environment database ie refresh of database, added new partitions to transaction tables, gathered stats, maintained dblinks, monitoring speed and performance of application, identified blocking sessions, managed user profiles -created users, changing passwords, providing grants etc.
• Worked on tuning and performance issues.
• Worked with DBA to provide support during upgradation of database from Oracle 10g to Oracle 11g.
• Worked on creating audit triggers to track all db changes.

Environment: Oracle 11g, Oracle Weblogic 11gR1, JDK 1.6.0, UNIX, Maven, Java, JSP, Struts, Eclipse Galileo, SVN, Embecardo DBArtisan 8.6.4, Toad, Putty, WinScp, FileZilla, Microsoft Visual Studio

Confidential, PA

Oracle PL/SQL Developer

Responsibilities:

• Work closely with business analysts, subject matter experts and development teams to gather requirements, design, develop, test, implement, and Data Warehouses and Data Marts with about 260 entities and 4000 attributes.
• Create and Develop data model using modeling Erwin, ERStudio tools for Credit Loss Mitigation division of FannieMae.
• Involved in developing and managing data models and associated metadata management for data lineage in the enterprise.
• Technical Lead for ETL, Modeling teams to bring data from 12 various sources (Mainframe, Oracle, Flat files and others) into comprehensive credit system, research and simulation system using Abinitio.
• Mapping and auditing data/information assets as they flow from upstream applications and interfaces to downstream reporting and analytical applications, to ensure optimal transparency, quality, consistency, and controlled redundancy across the organization.
• Responsible for designing data warehouse models, objects and developing and implementing data migration processes.
• Work with PMO, project managers and release managers to plan, provide LOE's and execute deliverables per schedule.
• Shared responsibilities with Enterprise Architects to design and develop road maps for strategic goals for credit division.
• Creating Database specific DDL's for application database and maintain versioning using Tortoise SVN
• Created Partitioned tables using various Oracle Partition methods, Materialized Views, Indexes for easy maintenance and better performance.
• Worked with ETL team to create bitmap indexes on low cardinality keys, create dedicated storage for staging and target tables to bring down load time to less than 40% of initial load time.
• Developed Oracle procedures, functions and packages to handle various business requirements, for exception handling, data cleansing/consistency.
• Developed and maintained documentation for Enterprise Privacy and Security work groups.

Environment: Tortoise SVN, ER-Studio, ERWin, Abinitio, MS Project, PMI Agile, Oracle 9i,10g,11g, SQLServer 2008,2008R2, SAS, Oracle Grid control, Solaris, HACMP, PL/SQL, AIX, SAP, DBArtisan, TOAD, SQL *Plus, RAC, GoldenGate.

Confidential, WI

Oracle PL/SQL Developer

Responsibilities:

• Involved in the Source Data Analysis, Datamdelling and migration of pricing, reval and fulfillment data to Analytical Layer.
• Created ETL design for loading dimensions (Type1, Type2 SCD) and Fact tables for Pricing Datamart.
• Designed the etl process to load reprice/deprice/exclusion/volume data for 6month reval from Fact table to summary tables to enhance the performance of Microstrategy report on Marketing Analytics.
• Created partitions for existing non partitioned Reval and Fulffilment high volume tables to improve the performance to retrieve monthly data
• Developed packages for loading dimension, fact table and marketing summary tables.
• Modified Cycle file to stage process to improve performance using segment based file splitter, piping file to SQLLoader to run in parallel with DIRECT path to load temp tables and Exchange partition.
• Created package/procedures to handle Most Profitable customers (MPC) as a part of ICE (Improving Customer Experience) project. and generated Aggregate report for MPC statistics using Analytical functions and Unix shell script.
• Modified Datastage job to send MPC data to Vendor in monthly, Semi Annual and Recon Process.
• Created packages to summarize the award and MDR data of Partner Compensation System in temp Prep table and Load this incremental data to Account Fact Monthly table using Exchange Partition.
• Used Collections, Autonomous Transaction, Bulk Collect, Bulk Bind and Ref Cursors to improve the performance. Used new features of Oracle 11G in developing packages.
• Tuned queries using indexes, optimization hints, Explain plan and tkprof and Used Materialized
• views & Partitioning to enhance performance
• Modified Customer and Event data loading jobs to optimize time in nightly Batch Job process.
• Created datastage parallel and Sequence jobs to migrate CallTech data from SQL Server to Oracle and process data for TCPA compliance.
• Designed and developed datastage sequence job to read the Fact table and generate Customer Portfolio report as per Compliance requirement.
• Designed and developed a multiple instance datastage sequence and parallel jobs to generate Access Control List data for different databases. Offshore coordination for development of ACL for all Apps.
• Designed and developed a multiple instance datastage sequence job, server and parallel subjobs to extract metadata of transaction files of Vendor system using SOAP Webservice call and send message to business as per requirement.
• Used DataStage stages like Sequential file, Hash file, Oracle Connector/OCI, ODBC, Datasets, Transformer, Aggregator, Sort, Join, Lookup, Remove Duplicates, Filter, Surrogate key Generator, Webservices Transformer, XML Parser etc
• Created requirement docs to schedule jobs and monitored jobs in Control-M
• Involved in documenting SDLC documents and release notes, Coordination of software releases and deployment in QA, and PROD environments.

Environment: Erwin 9.2, MS Visio2010, MS Project 2010, Win CVS, PL/SQL, Oracle 10G/11G, Toad 10/11, Datastage 8.1/8.5 XML, Webservices (SOAP), Solaris Unix, Linux,, Control-M, HP Quality center, CA Unicenter

Confidential, Irving, TX

Oracle PL/SQL Developer

Responsibilities:

• Lead the project on database upgrade from Oracle 9i database to Oracle 11gR2 database.
• Working extensively with DBA's to do database tuning. Worked on query tuning, data base parameter set up, memory management and over all load analysis. Debug and rectified open issues that were present in process design under 9i database before moving it to 11g.
• Assist in providing specialized operational analysis for data integrity and completeness between data warehouse and home grown applications using dedicated query design, data mapping and writing procedure that can be directly be feed to Informatica and cognos.
• Involved in development of ETL (Extraction, Transformation and loading) process using SQL* LOADER, PL/SQL Package, UTL File and Advance queuing. This day/ weekly/ monthly INDEX/FUND load process can load critical real time data with in-build issue reporting mechanism and error logging system.
• Developed and enhanced an advance message queuing system using Oracle Advanced Queuing (AQ). This allows you to store messages into queues for deferred retrieval and processing by the Oracle server. This process is designed to communicate between JAVA, UNIX from ORACLE. JAVA and PERL process are directly triggered by oracle code using this messaging system.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, and Packages. New mailing process is also a part of designed using UTIL MAIL.
• Develop and Modified Oracle process in PLSQL for data migration/conversion scripts. These procedures were used as feed for the OLAP reporting process design to facilitate the clients.
• Change DBMS JOBS used for job scheduling and parallel processing to DBMS SCHEDULER API with is more advance process.
• Work on performance improvement of the process design. Implement Data Management strategies which include validation of source data and the use of data in management reporting
• Post production support
• Work on day to day post production support as required by the Invesco Clients.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion
• Upgrade/customized batch jobs for the current version of the product. These batch job processes vary from preparing export file, data fixes, weekly boarding and custom process.
• Worked as Business Analysts, interacting directly with the business users and gathering requirements and writing Solution Documents for the Solution proposed.

Environment: Windows 7, Oracle 11g, 9i, SQL, PLSQL, SQL loader, Toad, Visio, SQL Developer, Perl, UNIX