SUMMARY

• Over 8 years of experience wif analytical, Problem solving, Communication and interpersonal skills to manage and interact wif individual at all levels.
• Able to interact effectively wif other members of the team involved wif the system development life cycle and halped other developers in the team to their development tasks.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Core Java, UNIX Shell Scripting, Java Script

Reporting Tools & ETL: OBIEE 10g & 11g, BI publisher, Crystal report XI and Informatica 8.6/8.5.

Database: Oracle8i, 9i,10g &11g, SQL SERVER 2005

Operating Systems: Windows XP, Windows2000, Windows 95, Windows7, Unix.

Tools: used: SQL*Plus, TOAD8.1, TOAD9.7, PLSQL developer, Toad data modeler3, SQL Developer, SQL*Loader, Erwin, Putty, Oracle11g Enterprise Manager, Microsoft SQL Management Studio, Service Now, WINSCP.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Database SQL, PLSQL developer

Responsibilities:

• Conducted Functional Requirements review and walk through wif BI Architect, Designers, and Stakeholders.
• Analyzing the market risk applications wif regulatory standards and monitoring the market risk data by maintaining thresholds for each application.
• Coordinated wif the users for resolving production issues related to the application.
• Developed PL/SQL Packages, Procedures and Functions according to the Business Requirements and for loading data into database tables by using Oracle RDBMS 11g R2 platform.
• Created, documented and maintained logical and physical database models in compliance wif enterprise standards and maintained corporate metadata definitions for enterprise data stores wifin a metadata repository.
• Created Materialized Views and partitioning tables to improve the performance of the database.
• Developed UNIX shell scripts to perform a daily refresh of the test system and Production database on Market Risk applications.
• Provided tuning recommendations and future memory requirements to the Primary DBA team to make the changes in Database like reorganizing the tables, added enough spaces in database.
• Designed and customized data models and Normalizations for Data warehouse supporting data from multiple sources in real time
• Involved in building the ETL architecture and Source to Target mapping to load data into the data warehouse.
• Designed Tables, Constraints, Views, Indexes, Triggers and Cursors in TOAD tool as per the business requirements.
• Set up a new database instance wif Prod and Test Environment and provided database related support.
• Troubleshoot the existing database objects, Indexes, views, sequences, packages and triggers using explain plan for faster execution.
• Supported L1 and L2 teams in case of batch issues and production issues.
• Worked wif dynamic SQL and also cleared the existing tables as per requirements.
• Involved the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Assisted to juniors in creating the criteria for each business analysis project by using agile methodologies and resolving the issues on a priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, Informatica power Center, SQL Developer, TOAD, Service Now, Putty and Crystal Reports.

Confidential, Santa Clara, CA

Database SQL, PLSQL developer

Responsibilities:

• Interacted wif business representatives and business analysts for requirements analysis and to define business and functional specifications.
• Designed/developed/Modified tables, views, materialized view, Indexes and Partition Tables as per the business user requirements.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Implemented the Normalizations, standard naming conventions for the fact and dimension entities and attributes of logical data model.
• Created new Procedures, Functions, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements in TOAD platform.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data from external flat files.
• Created a Physical Data Model wif DDL wif dat best suitable format for the requirements of the Logical Data Model.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statements and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Used existing ETL standards to develop these mappings and Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
• Development of Client Specific customization’s using SQL and PLSQL and reports using Oracle BI.
• Designing the Oracle BI reports to generate the monthly invoice, SOA and Customers active and deactivate details based on SQL views and procedures.
• Implemented all module logic by using Triggers and Integrity Constraints.
• Assisted in outlining the project to the Target Company’s management team and developing a strong working relationship by following agile methodologies.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.

Environment: Oracle 11g, SQL, PLSQL, Informatica power Center, SQL*Loader, TOAD, Service Now, Putty and Crystal Reports.

Confidential

Oracle Database (PLSQL) Developer

Responsibilities:

• Primary responsibilities, including gathering business requirements and designing the functional and technical specifications.
• Studied the existing data migration procedure of CC&B and the migration setup to move the legacy data into the production and provided the gap analysis.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Participated in system analysis and data (Physical & Logical) modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, for all, Bulk collect and Dynamic SQL in TOAD.
• Developed Database Triggers for audit and validation purpose.
• Monitored and tuned systems and databases to optimum levels of performance and performed system upgrades in support of business processing requirements.
• Managed Table spaces, Database structure and storage allocation, Undo segments, etc., and used pipelined functions for faster data access.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys and primary keys in the physical model.
• Conducted SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query etc.,to speedup the execution time.
• Created a purge script to remove more TEMPthan one year old data.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Configured and administered the team's agile management tool wif the halp of the agile management team.
• Performed functional testing for the procedures and packages.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimension tables for reporting purposes.
• Involved in migrating a database from Oracle 9i to 10g database.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, SQL Developer, TOAD, Service Now, Putty and Crystal Reports.

Confidential

Oracle Database (PLSQL) Developer

Responsibilities:

• Involved in prioritizing the requirements, documenting the technical specifications and designed the DB structure for the application.
• Worked on gathering and analyzing the requirements and trained new users on new and existing business flows.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Developed a variety of Management reports for users, using Crystal Reports XI by fetching the data from the Oracle 10G database.
• Created parameterized reports and customized existing reports and developed various sub-reports, running totals per period and running the Reports from the Business Object Info View.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way and formatted the reports as per the user requirements.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases for the business requirements.
• Monitored the Data loading by using the SQL*loader, Imports & UTL files based on file formats.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production wif utilities like Explain Plan, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever it’s required.
• Created Oracle Database Users, Roles and managing Security and Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences and Materialized Views to organize the data as per front end application.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Involved in Unit testing and System testing and also coordinated wif the testing team to identify bugs and resolved issues in a timely manner.
• Responsible for the creating the change requests and prepared all required documents to move the code change to production.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, SQL Developer, TOAD, Service Now, Putty and Crystal Reports.

Confidential

Oracle Database (PLSQL) Developer

Responsibilities:

• Involved in Application development wif all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
• Involved and worked on the project feasibility study, planning, implementation, testing, deployment and closeout.
• Created physical Database Design, data structures, Data Modeling, Schema Design.
• Applied Database Tuning and Optimization, Normalization in the new database design
• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Developed Audit programs for data consistency check and validation.
• Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens
• Developed both inbound and outbound interfaces to load data into targeted database and extract data from the database to flat files
• Created database reports to get open enrollment and enrolled list reports
• Created database tables and developed the database triggers applicable to business rules.
• Developed the packages to delete stored session data from various tables
• Debugged various defects related to implementation of business logic
• Automated SQL*Loader to load the data from the flat files
• Used Materialized Views, Packages and Dynamic SQL for speed up the application performance
• Created programs to transform data from Legacy systems into Oracle database
• Monitored performance and changed performance requirements through the application of Database tuning and performance optimization techniques.
• Worked under tight schedules for successful development and implementing the project in a production environment.

Environment: Oracle 11g, SQL, PLSQL, Informatica power Center, SQL*Loader, SQL developer, TOAD, Service Now, Putty and Crystal Reports.