SUMMARY:

• 15+ yrs. of experience in large scale, mission critical OLTP and DW/ Big Data applications as a Database Developer, ETL Developer, Data Modeler, Database Administrator and Big Data Architect.
• Vast experience in Information Management, Data Warehousing, Data Integration, MDM, Big Data, Data Science, Analytics Technologies with both relational and NoSQL databases.
• Proven track record to drive rapid prototyping and design for new projects & ability to translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.
• 12+ yrs. of working experience with leading organizations
• 10+ yrs. of Business Objects, Informatica, Pentaho, Data Warehousing/ETL experience and web based application development experience using Oracle APEX.
• Vast experience in SDLC/Agile Methodologies, quick in learning and implementing new technologies, and excellent written and verbal communication skills.
• Excellent experience in practicing quality models CMMi, PCMM, and ISO 9000.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c, Teradata V2R4, MS Access, NoSQL/Cassandra

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, CQL

OS: UNIX, Windows

Oracle: SQL*Plus, DBMS Profiler, TKPROF, PL/SQL Developer, TOAD,SQL Developer, Oracle Designer, SQL Loader, Import/Export, Oracle Enterprise Manager (OEM), Oracle Universal Installer (OUI), Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA), Recovery Manager, Oracle APEX 3.0 Developer 2000(Forms, Reports 9i, 10g)

Oracle MDM Data Warehousing: Business Objects XI (DeskI, WebI, InfoView), Informatica IDE, Pentaho

ETL Quality: Mercury Quality Center, Clear Quest Data Modeling: Oracle Designer, ERWin, ER/Studio, MS Visio

TOAD Version Control: CVS, Visual Source Safe (VSS), SVN, GIT (Bitbucket/ SourceTree)

Project Management: MS Word, MS Excel (VB Macros, Charts, Graphs), MS PowerPoint,MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect / Sr. Database Developer

Responsibilities:

• Gather and Analyze business requirements
• Create the Conceptual, Logical, Physical Data Models and DB Designs for Confidential Enterprise Data Warehouse (EDW) using ERWin
• Implement/Code critical modules using Oracle/ PL/SQL, NoSQL/Cassandra, UNIX, Pentaho and ETL
• Setting up the road map, architectural vision, gaining business consensus, mentoring development resources, deliver solutions, training and documentation for Analytics/Dashboards.
• Create design documentation and test programs
• Provides leadership in establishing analytic environments required for structured, semi - structured and unstructured data.
• Design and Develop various dashboards/ reports using Oracle PL/SQL stored procedures, Materialized Views, Pentaho and UNIX scripts
• Performance Tuning of Oracle queries and PL/SQL stored procedures
• Load large volumes of data using SQL Loader, External Tables and Direct Load Methods
• Unit Testing of critical Oracle stored procedures, Materialized Views and UNIX scripts
• Version management of the code/documents using GIT and SVN
• As an Agile team member, follow the Agile Methodology, Attend daily team meetings, Estimate size of backlog items, Evaluate technical feasibility, Implement backlog items, Write and verify code which adheres to the acceptance criteria
• Create/Maintain best practices, code review guidelines, checklists and mentor team members

Confidential

Architect /Sr. ETL Developer

Responsibilities:

• Requirement Gathering and Analysis
• Create the Logical, Physical Data Models using ERWin
• Implement software solutions using Oracle, PL/SQL, UNIX and ETL, Informatica
• Formulate designs for program development and manage day-to-day on-site relationship
• Create documentation and test programs
• Design and Develop various reports using Oracle PL/SQL stored procedures and UNIX scripts
• Performance Tuning of Oracle queries and PL/SQL stored procedures
• Unit Testing of Oracle stored procedures and UNIX scripts
• Version management of the code/documents using VSS
• Tracking & Tuning slow scorecard jobs per their Priority using Oracle PL/SQL and Business Objects
• Triggering and Monitoring test runs using Business Objects Data Integrator
• Report the status of performance improvements to Management on a weekly basis
• Design and Develop ETL jobs using Business Objects Data Integrator
• Responsible for preparing Requirements document, Unit Test Results and Design documents
• Implement Master Data Management (MDM) and Data Governance rules engine
• As an Agile team member, follow the Agile Methodology, attend daily team meetings, Estimate size of backlog items, evaluate technical feasibility, Implement backlog items, Write and verify code which adheres to the acceptance criteria

Confidential

Sr. Database Developer

Responsibilities:

• Requirements collection and analysis for Data Management change requests
• Design and Develop stored procedures using Oracle PL/SQL
• Tracking scorecard jobs that are taking longer response times
• Tuning slow scorecard jobs per their Priority using Oracle PL/SQL and Business Objects
• Systems Integration
• Triggering and Monitoring test runs using Business Objects Data Integrator
• Report the status of performance improvements to Management on a weekly basis
• Design and Develop ETL jobs using Business Objects Data Integrator
• Unit Testing Oracle stored procedures and Business Objects ETL jobs
• Version management of the code/documents using VSS
• Responsible for preparing Requirements document, Unit Test Results and Design documents
• As an Agile team member, follow the Agile Methodology, Attend daily team meetings, Estimate size of backlog items, Evaluate technical feasibility, Implement backlog items, Write and verify code which adheres to the acceptance criteria

Confidential

Sr. Database/ETL Developer

Responsibilities:

• Responsible for end-to-end development (LLD, Development, Unit Testing, Maintenance Support) of a given BPM function based on the HLD using PL/SQL - Oracle 10g
• Extensive performance tuning using EXPLAIN PLANs, TKPROF, DBMS Profiler to meet the stringent SLAs
• Identify and modify the time consuming PL/SQL procedures to use bulk binding (BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches between PL/SQL and SQL engine
• Development of Materialized views, Creation of indexes, De-normalization and Partitioning of tables/indexes, Rebuilding indexes, Stats Collection as required to improve the query performance
• Simulation of EXPLAIN PLANs from one environment to another using SQL Profiles and Outlines
• Responsible for replication of transactional data (from BPM) to Repoprting server (BAM) using Oracle Streams
• Implementation of Event Logging for the BPM Stored Procedures
• Responsible for canned reports job scheduling through DBMS SSCHEDULER
• Responsible for preparing LLDs, Unit Test Plans
• Generation and monitoring AWR Reports in DEV, CIT, SIT and LT environments
• Code version control through TFS and Document version control through MS SharePoint
• Defect life cycle management through Quality Center
• Responsible for coordinating with DBAs on tuning requests and deployments

Confidential

Sr. Programmer

Responsibilities:

• Requirements collection from Accounting Team for additional features and reports development of PIN Management
• Logical Data Modeling
• Design, Develop and Unit Test PL/SQL procedures, functions, and packages for PM using Oracle 10g
• Identify and modify the time consuming PL/SQL procedures to use bulk binding (BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches between PL/SQL and SQL engine
• Debug PL/SQL routines using TOAD IDE visual checkpoints
• Develop complex SQL queries for generation of trend analysis reports
• Resolving vendor historical feed file issues and load into PIN Management
• Load failed vendor feed files using External Tables to identify data issues
• Vendor coordination for resolving feed issues
• Tuning PL/SQL procedures, functions and packages related to PM load process
• Tuning SQL queries using EXPLAIN PLAN, TKPROF
• User access creation and management, and Cloning the production db in dev and test environments for development and testing
• Automation of fixing historical feed files for known issues
• Development and Maintenance of documentation for critical PM load process
• Version management of the code/documents using Visual Source Safe

Confidential

Sr. PL/SQL Developer & Oracle DBA

Responsibilities:

• Data Modeling (conceptual, logical and physical), Oracle Physical DB creation for the integrated Case Mart, CURE web and CODS environments using Oracle 10g
• Provides technical and architectural guidance in adding or updating business logic implemented in the database.
• Design, Develop and Test PL/SQL procedures, functions, and packages for the NN Billing Process
• Design and implement Views to safeguard data, and Triggers to implement auditing and Replication
• Develop ETL (Extract, Transform and Load) routines using PL/SQL for data extraction, validation, cleansing, transformation and loading.
• Modify the time consuming PL/SQL procedures to use bulk binding (BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches
• Enable schema object auditing on critical tables as and when required, monitoring, and protecting the audit trail
• Tuning SQL queries (using EXPLAIN PLAN, TKPROF), PL/SQL Procedures, Functions and Packages (using DBMS PROFILER), and Generating/Monitoring STATSPACK Reports
• DBMS DEBUG for debugging PL/SQL routines and tracing the processing execution
• Daily database administration activities to ensure maximum data availability and optimal database performance of the production database
• Database migration/conversion from Windows to Linux using RMAN
• User access creation and management, and Cloning the production db in dev and test environments for development and testing
• Data loading using SQL*Loader, Direct-Load Inserts, and Database schema/tables’ migration using Import/Export
• Extensive design, development and support of BO XI universes and reports using BO Designer, DeskI/WebI, and InfoView
• Performance tuning of BO XI reports at the universe level using derived summary views, hints etc
• Create and maintain KNOVA universe metadata using BO macros
• UNIX shell scripting for file loading, file manipulation & job scheduling thru Crontab
• Code/Document version control management thru CVS
• Customer and stakeholder communication

Confidential

Sr. PL/SQL Developer & Oracle DBA

Responsibilities:

• Gather and analyze business requirements, and develop specifications
• Data modeling and Physical Database Objects creation using Oracle 10g
• Responsible for the ETL Strategy
• Design, development, and testing of PL/SQL routines for ETL, job automation and to populate reporting tables
• Implementing external procedures in PL/SQL to call JAVA classes
• Development of Views and Triggers to implement data security, auditing and Replication, journal table population
• Tuning PL/SQL procedures, functions and packages using DBMS profiler
• Statistics collection and analysis for tables and indexes
• Administer the existing software deployments and manage performance analysis of the environments
• Work with application developers to review and design new database structures and schemas as needed
• Table and index partitioning to improve performance and easy management of large CDRLive fact tables
• Responsible for Database Backup and Recovery using RMAN
• Recover tables or individual rows to a previous point in time using flashback queries.
• Table compression for large read-only tables to reduce disk space requirements
• Installation of Oracle on client machines using OUI, and Database Upgrade from 9i to 10g using DBUA
• Establish and maintain stand-by database using Oracle Data Guard
• Assisted in RAC Implementation (2-node) using Oracle 10g
• Complete the assigned CDRlive IWOS (Integrated Work Order System) requests before commit date.
• Call Detail Records (CDRs) analysis, and Load CDRlive summary data
• Follow Confidential WR quality processes throughout the IWOS life cycle
• Vendor (LGR Communications) communication regarding CDRlive issues
• Universe and Reports Design and Development using BO XI
• Maintenance support for existing Business Objects XI Reports and Universes.
• Source profiling and Source-Target mapping using Informatica IDE for the Finance Datamart
• Design and Development of web based regional Confidential BB sales summary forms and reports using APEX 3.0
• Create and manage roles, users, and user groups through APEX application administration
• Modifying Confidential BB sales summary APEX forms and reports per the work request
• Deploying Confidential BB sales summary APEX application in production environment
• UNIX shell programming for file manipulation, scheduling of UNIX cron jobs & troubleshooting
• Version Control using Visual Source Safe (VSS)