SUMMARY

• Over 12 Plus years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the 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, have Financial Sector Experience
• Involved in all phases of the 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.
• Effectively 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 the 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 the 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 the 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 the Data with business rules and loading to staging and application instances) synchronizing the Test Environments with Production for real time data and more.
• Used Big data skills, aware of architecture, configured Apache Nifi and started processing data.
• Going through Microsoft Azure.
• UML Modeler

PROFESSIONAL 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 the 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 the various data points.
• Documenting the types and structure of the business data (logical modeling).
• Data cleansing and standardization i.e. duplicates, garbage sanitization.
• Prepared Process Flow and Data Flow diagrams
• Maintained Issue logs across the Domain Towers
• Prepared Visio charts
• Worked on Enterprise Governance processes
• Used Hadoop file processing
• Hive and Pig

Confidential - Cincinnati, OH

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 the existing data model
• Application Administration and implementation at various centers and maintenance/customization of the software.
• Working on plsql performance, I could improve the coding standards by using my past experience.
• Analyzing of Indexes.
• Defined new approaches.
• Involved in Interaction with the client for Database requirements.
• Understanding the Requirements and Analysis of the specifications provided by the clients
• Data Migration, involved extensively in data migration activities. (Extracting Data from different boundaries (Vendor systems), Transforming the Data with business rules and loading to staging and application instances) synchronizing the Test Environments with Production for real time data and more.

Confidential - Denver,CO

Sr. PL/SQL Developer/Data Modeler

Responsibilities:

• Involved with business for requirements gathering and understanding and working with team collaboratively.
• Involved in Interaction with the client for Database requirements.
• Understanding the Requirements and Analysis of the specifications provided by the 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 the Quality procedures related to the project.
• Product maintenance and Releases.
• Application Administration and implementation at various centers and maintenance/customization of the 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 the 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 the Data with business rules and loading to staging and application instances) synchronizing the Test Environments with Production for real time data and more.

Confidential

Database Developer/Data Modeler

Responsibilities:

• Supported, Testing and implementation of DW: Upstream Process.
• As a team member, was responsible for
• Understanding the Requirements and Analysis of the specifications provided by the clients
• Analyzing of Indexes
• Design and Development of Oracle Database
• Database management
• Testing - unit testing & integration testing
• Responsible for overseeing the Quality procedures related to the 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?

Confidential

Data Architect / Data Modeler

Responsibilities:

• Were completely handled Development, Testing and implementation of Fair Value Completeness Business Process.
• Understanding the Requirements and Analysis of the specifications provided by the clients
• Query Tuning With implementation-> Usage of Hints
• Monitoring the 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 the Quality procedures related to the 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..

Confidential

PL/SQL Developer

Responsibilities:

• Took over the responsibility of enhancing functionality of Tr@ction by adding new functionality as a Pl/Sql programmer and HTML tags, Java scripting.
• Understanding the Requirements and Analysis of the specifications provided by the clients
• Design and Development
• Database management
• Query Tuning With implementation if Usage Hints TKPROF
• Monitoring the 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 the Quality procedures related to the project.
• Product Releases.

Confidential 

Database Developer/DB

Responsibilities:

• Application Administration and maintenance/customization of the 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