EXPERIENCE SUMMARY

• Oracle PL Sql Developer, UNIX Scripting, ETL and Data Modeler
• Over 12 Plus years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using teh Oracle Relational Database Management System (RDBMS and ORDBMS).
• Oracle Certified Associate (OCA).
• Having 5 Plus years of experience as Data modeler.
• Current Project developed Work flows using Informatica PowerCenter designer 10.1, created deployment groups. Performed end to end migration work.
• 5 Plus years of experience in Business Objects BO Tableau and OBIEE.
• Worked for Confidential, has Financial Sector Experience
• Involved in all phases of teh SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Also involved in agile methodology.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER, (exp, imp) and impdp expdp.
• Good Knowledge of Oracle Architecture.
• TEMPEffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views (Logs) and Transportable tablespaces.
• Strong experience in Data warehouse concepts, ETL Implementations.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for teh tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including working experience with teh Reporting tools such as Tableau, ODI, Informatica and Ab initio.
• Got opportunity to Create and support complete workflow for Batch processes using Shell Script for invoking SQL scripts and scheduled them using crontab and ESP( I can say this is core competence too). Worked with Java developers to prepare few engines for batch processing daily, weekly, monthly Quarterly.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Involved in mentoring teh entry level programmers and application developers.
• Good at performance tuning.
• Design and implement ODI Extract, Load and Transform (ELT) processes, programs and scripts. Design of data warehouse tables, including source to target mappings, configuration of ODI knowledge modules
• Data Migration, involved extensively in data migration activities. (Extracting Data from different boundaries (Vendor systems), Transforming teh Data with business rules and loading to staging and application instances) synchronizing teh Test Environments with Production for real time data and more.
• Used Big data skills, aware of architecture, configured Apache Nifi and started processing data.

PROESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Sr. PL/SQL Developer/Data Engineer

Responsibilities

• Involved with business for requirements gathering and understanding and working with team collaboratively.
• Coded process using PLSql, used dynamic views using parameterized user environment variables.
• Used ODI for ELT flows
• Designed and developed extensive Packages for modularized code for business.
• Mapping and tracing data from system to system in order to solve a given business or system problem.
• Verify teh current reporting data and trouble suite for right data analysis capabilities.
• Perform statistical analysis of business data.
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures.
• Analyzing and mining business data to identify patterns and correlations among teh various data points.
• Documenting teh types and structure of teh business data (logical modeling).
• Data cleansing and standardization i.e. duplicates, garbage sanitization.
• Prepared Process Flow and Data Flow diagrams
• Maintained Issue logs across teh Domain Towers
• Prepared Visio charts
• Worked on Enterprise Governance processes

Confidential, Cincinnati, OH

Capgemini-Sr. PL/SQL Developer/ Data Engineer

Responsibilities:

• Involved with business for requirements gathering and understanding and working with team collaboratively.
• Design and Development of Oracle Database
• Database management
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures.
• Designing BI Reports using Spotfire
• Developed Informatica work flows for Enterprise Data processing
• Product maintenance and Releases.
• Introduced table partitioning to teh existing data model
• Application Administration and implementation at various centers and maintenance/customization of teh software.
• Working on plsql performance, I could improve teh coding standards by using my past experience.
• Analyzing of Indexes.
• Defined new approaches.
• Involved in Interaction with teh client for Database requirements.
• Understanding teh Requirements and Analysis of teh specifications provided by teh clients
• Data Migration, involved extensively in data migration activities. (Extracting Data from different boundaries (Vendor systems), Transforming teh Data with business rules and loading to staging and application instances) synchronizing teh Test Environments with Production for real time data and more.

Confidential - Denver,co

Mphasis - Sr. PL/SQL Developer/Data Modeler

Responsibilities:

• Involved with business for requirements gathering and understanding and working with team collaboratively.
• Involved in Interaction with teh client for Database requirements.
• Understanding teh Requirements and Analysis of teh specifications provided by teh clients
• Design and Development
• Database management
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Collaborate with BI teams to create reporting data structures.
• Testing - unit testing & integration testing
• Responsible for overseeing teh Quality procedures related to teh project.
• Product maintenance and Releases.
• Application Administration and implementation at various centers and maintenance/customization of teh software.
• Used ODI for ELT flows.
• Using ODI Setting up, debugging and implementing end-to-end ETL jobs.
• Performed tuning of ODI ELT Mappings. Develop unit, system, and integration test plans
• Working on pl sql performance, I could improve teh coding standards by using my past experience.
• Analyzing of Indexes.
• Export, Import, Sqlldr, sql hints, TKprof, Shell scripting, DB2 and various Oracle builten packages.
• Defined new approaches.
• Setting Up Replication environment for Replication sites
• Creating Database Replication Objects and groups
• Data Migration, involved extensively in data migration activities. (Extracting Data from different boundaries (Vendor systems), Transforming teh Data with business rules and loading to staging and application instances) synchronizing teh Test Environments with Production for real time data and more.

Confidential

IBM Database Developer/Data Modeler

Responsibilities:

• Supported, Testing and implementation of DW: Upstream Process.
• As a team member, was responsible for
• Understanding teh Requirements and Analysis of teh specifications provided by teh clients
• Analyzing of Indexes
• Design and Development of Oracle Database
• Database management
• Testing - unit testing & integration testing
• Responsible for overseeing teh Quality procedures related to teh project.
• Product Releases.
• Exports, Imports and working with Global temporary and External Tables.
• DW: Upstream which is for supporting business process which is being handled manually?

Satyam computers Data Architect / Data Modeler

Confidential

Responsibilities

• Were completely handled Development, Testing and implementation of Fair Value Completeness Business Process.
• Understanding teh Requirements and Analysis of teh specifications provided by teh clients
• Query Tuning With implementation-> Usage of Hints
• Monitoring teh database health with STATSPACK Report and TKPROF
• Analyzing of Indexes
• PL/SQL extensively for producing Billing reports and reports for statutory
• Design and Development of Oracle Database
• Database management
• Testing - unit testing & integration testing
• Responsible for overseeing teh Quality procedures related to teh project.
• Product Releases.
• Exports, Imports and working with Global temporary and External Tables.
• Extensively worked on Built-in Packages like DBMS SMTP, DBMS XMLParser…etc..

Satyam Computers PL/SQL Developer

Confidential

Responsibilities

• Took over teh responsibility of enhancing functionality of Tr@ction by adding new functionality as a Pl/Sql programmer and HTML tags, Java scripting.
• Understanding teh Requirements and Analysis of teh specifications provided by teh clients
• Design and Development
• Database management
• Query Tuning With implementation if Usage Hints TKPROF
• Monitoring teh database health with STATSPACK Report and TKPROF
• Analyzing of Indexes
• PL/SQL extensively for producing Billing reports and reports for statutory
• Used Built-in Packages DBMS LOB, XMLDB, UTL FILE and on OS commands…etc..
• Testing - unit testing & integration testing
• Responsible for overseeing teh Quality procedures related to teh project.
• Product Releases.

Confidential

Feature Focus Infotech Database Developer/DB

Responsibilities

• Application Administration and maintenance/customization of teh software.
• Updating modules as necessary of requirements.
• Generating information according to requirements.
• Converting data formats as need by client.
• Validation Checks of these Data using tools.
• Analyzing of Indexes
• PL/SQL extensively for producing Billing reports and reports for statutory requirements
• Coding for database triggers and stored procedures. SQL Code optimization

Confidential

Phoenix IT Solutions Database Developer

Responsibilities:

• Involved in preparation of Data Base Design Document
• Convert teh BMS Data into teh Data Formats required by several parties
• Convert teh data provided by these agencies into teh BMS database
• Validation Checks of these Data from Remote Meter Reading Instruments
• Performance Tuning
• Query Tuning With implementation if Usage Hints TKPROF
• Monitoring teh database health with STATSPACK Report and TKPROF
• Analyzing of Indexes
• PL/SQL extensively for producing Billing reports and reports for statutory requirements
• Coding for database triggers and stored procedures. SQL Code optimization