SUMMARY:

• Over 8 years of IT experience in Analysis, Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments using Oracle Tools in client server environments.
• Involved in entire life cycle of implementation (SDLC) from business analysis to Production deployment, support and testing.
• Experience in working with different data models such as normalized model, de - normalized model, flat model, Enterprise data model and Dimensional data model.
• Advanced skills in Oracle 12C/11g/10g/9i database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers), standard built-in Oracle packages.
• Experience in building and modifying Data models in data modeling tools, such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Experience in designing and developing ETL Processes.
• Experience in Informatica Power Center design, development, monitoring and deployment.
• Working Knowledge and experience with BI publisher Reporting, SQL Reporting, Crystal Reports, Business Objects and other report writing tools utilizing oracle, SQL Server, Access, Excel, Flat files and other Data sources.
• Experience in using Oracle related tools like SQL * Loader, Toad, SQL Navigator, SQL Developer and Data Loader.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, object types and collections.
• Experience with Views, Materialized views, Cursors (Implicit and Explicit), Ref Cursors, and External tables, table partitioning, Index partitioning and nested loops.
• Extensive working knowledge on SQL Loader control programs, Oracle CDC, and PL/SQL validation scripts to transfer flat file data into oracle database tables.
• Expertise in maintenance of database objects such as tables, indexes, views, synonyms and extensively exposure in performing ETL.
• Strong technical expertise in UTL FILE, DBMS SQL, DBMS OUPUT, DBMS UTILITY, DBMS JOBS packages.
• Strong Experience in CDC and tools like Oracle Utility CDC, Golden Gate and IBM CDC.
• Experience in SQL or Database level tuning using Explain Plan, TKPROF, AWR.
• Extensively used Cursors, Ref Cursors, Dynamic SQL, Bulk Collect, Bulk Binding, Analytic Functions, Composite data types and Collections in writing the backend PL/SQL code.
• Experience in SSIS, SSRS, T-SQL and SQL using SQL server.
• Experience in creating Tables, Indexes, views, Stored procedures and SQL Control structures in DB2.
• Experience in Data Migration from Oracle to PostgreSQL by importing Oracle data as CSV files.
• Experience in Creating Views, Tables, Materialized views, functions and Triggers in PostgreSQL.
• Working knowledge on core Java, HTML and XML.
• Experience in writing UNIX shell scripts and experience in Informatica, Datastage ETL tools.
• Knowledge and experience in Backup, Recovery and restoring related activities.
• Experience in Oracle Database administration including backup up and Recovery.
• Experience in Oracle Installation, Setting up Database Server, and extensive Data Migration Experience.
• Excellent analytical skills, logical reasoning, interpersonal skills, problem solving skills and communication skills.
• Strong management, administrative and leadership skills to work in team.
• Experience in 24*7 Production Support and managing offshore team.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, Cassandra, MongoDB, MariaDB, DB2, Sybase, SQL Server, PostgreSQL

LANGUAGES: SQL, PL\SQL, PG/PSQL, PostGre SQL, Bash/Korn shell scripting, TSQL, JAVA, HTML, JSP

Database Tools: Enterprise Architect, Informatica, Erwin data modeling, Sybase power designer tool, Enterprise manager, SQL Navigator, Toad, SQL developer, SQL Server Management Studio, SQL*Plus, SQL*Loader, Golden Gate, IBM CDC

Operating System: Windows 7/10/NT /XP and UNIX and Red Hat Linux, Sun Solaris, UIX

PROFESSIONAL EXPERIENCE:

Confidential

Database Engineer/Architect

Responsibilities:

• Involved in designing and Modeling for different functional modules for the application using Enterprise Architect.
• Involved in Conceptual modeling and logical modeling using Enterprise Architect.
• Involved in elaboration phase for analyzing requirement and impact on database design.
• Modeled and generated scripts for OLTP Database for Pharmacy Renewal Application.
• Worked in 2 weeks construction sprint Agile Methodology.
• Designed, Modeled and Mapped ETL from IC+ to RxMS.
• Designed model in SOA and functional modules are separated to go with Micro services Architecture.
• Created and generated Rest-API’s and SOAP services for Application.
• Created Model using KDM tool and added query search patterns to generate DDL for Cassandra.
• Identified and distributed column keys in different Partitions to maximize the performance for Cassandra Database.
• Maintained and updated data dictionary for Cassandra.
• Created query search patterns according to the application needs.
• Written Batch statements to Update redundant data and query search pattern tables in Cassandra.
• Assisted Data lake team to Map to MDM from our Application data model.
• Worked on Data Migration importing Oracle data as CSV files and migrated into different databases.
• Involved in designing and implementing data dictionary for the Pharmacy Renewal application we are building.
• Created a Prod parallel environment using Data Guard to avoid deployment and debugging delays for the release.
• Modeled in KDM tool and generated DDL scripts for Cassandra Database.
• Successfully implemented POC for Patient and dispense Modules using Cassandra.
• Had Cassandra for developers and Architects from Cassandra Consultants.
• Involved in working with Cassandra consultants for POC on two domains to analyze active-active strategy.
• Worked on Data Security and Data Governance to identify PII, PHI data, data quality and metadata.
• Designed and developed Pricing module in SQL server database in Microsoft Azure.
• Developed Procedures in T-SQL’s for data transformations and data load from staging in to Pricing Database.
• Generating DDLs, DMLs, JPAs, Java constants from Enterprise architect using code generator.
• Creating Pull Requests for generated DDL’s and DML’s.
• Implemented a new design for History by using manage history set to true on the existing entity.
• Working with DevOps and Run Ops for database Build and deployment issues.
• Implemented initial load scripts on basic data for application to work while doing clean install.
• Involved in designing micro services architecture by dividing different domains into different buckets.
• Worked with Analytics team to integrate data into big data solutions for generating reports.
• Created TO’s, ETO’s and generated Services, XSD and Enterprise services in Enterprise Architect.
• Created services, APIs to integrate with legacy system.
• Handover to Scrum masters after model design before each sprint.
• Assist the integration team on mapping with designed new model for each Sprint.

Environment: Oracle12c, DataStax Cassandra, Enterprise Architect, Flyway, UNIX, Cassandra, SQL Server 2016, T-SQL, CQL, BitBucket, Bamboo, GitHub, JIRA, Confluence, SQL developer.

Confidential

Database Engineer

Responsibilities:

• Push the database deployment scripts to Production by analyzing the push timings and push scripts to find the impact.
• Involved in PLSQL development activity for Batch jobs.
• Deployed Services to the service based applications.
• Analyze push scripts in load Test environment to categorize pre-push, post push plausible scripts that can impact production push timings.
• We work in agile paced development and scrum for planning.
• Worked on Data Security and Data Governance and user roles architecture.
• Worked in 4 weeks Sprint Agile Methodology.
• Designed and developed ETL from .CSV, .DAT files as sources.
• Worked with Informatica Power Center Repository, designer, workflow builder and workflow monitoring for developing, debugging and deploying.
• Worked with Informatica Deployment groups to build and deploy Informatica workflows in command line.
• Created Mapplets in Informatica for reusable logic, code and logging.
• Created Worklets in Informatica for the group of workflows and added email feature if any failure occurs in the Worklets which made it easy for production Support.
• Created and Implemented Golden Gate Automated DDL scripts and Manual Scripts whenever there are DDL changes to the Main database.
• Implemented Data Guard for Production for select only privileges to the users.
• Imported and Exported data models into Sybase database for other environments.
• Tuning the SQL’s that were time taking one based on the Ignite report.
• Analyzing the code based on the Load Test Pre-Pushes.
• Work on database syncing from prod to Load Test environment to keep LT sync with PROD.
• Deployed Informatica pushes from the command line to QA, E2E, LT and PROD.
• Worked on data migration from Oracle to PostgreSQL.
• Created Tables, Views, Triggers, functions in PostgreSQL
• Worked on cloud environment with PostgreSQL for New applications.
• Integrated Rally for User Stories Data and Jira data into PostgreSQL DB for Monitoring Bugs and User Story Progress.
• Worked on performance tuning for the existing ETL processes based on Load test performance tests.
• Worked on Load Test Performance environment and QA environments for Database pushes and assist release management engineers if there are any Database push errors.
• Suggested different database script changes either to include better way or to improve push quality and the changes that are because either affecting the business process, applications and ETL.

Environment: Oracle 11g, PL/SQL, Informatica Power Center 9.6, 10Golden Gate, Data Guard, PostgreSQL 9.4, Rally, Sybase Database, Sybase Power designer, GitHub, SVN, Bamboo, BitBucket, Flyway, DBRM, JIRA, Confluence, Mac Terminal, UNIX, TOAD.

Confidential

Oracle Lead Developer

Responsibilities:

• Created, modified, maintained and deployed ETL processes build using Oracle CDC and PLSQL.
• On call Production support and supported on call for lower environments like UAT and SIT.
• Designed and developed error handling in existing ETL CDC process.
• Worked with Business Analyst for changing requirement on Mortgage Loans pooling and its subject areas, updated data model, extracted DDLs from the data model and did the development work .
• Worked in Agile environment for the development life cycle with continuous development and deployment methodology.
• Designed and developed new enhanced CDC ETL process that has drastically improved performance from hours to minutes to load big volume of data.
• Working on performance tuning for the existing ETL processes.
• Suggested and modeled different database model changes either to include new functionality or to improve data quality and the changes that are because either effecting the business process, applications and ETL
• Involved in supporting Front-end team for generating reports, Procedures and SQL queries.
• Involved in working with Production tickets and CDTS tickets.
• Created a New PostgreSQL database for LDAP active Directory.
• Created Tables, Views and Functions in PostgreSQL database for utilizing user information for the CMIE and SMS applications.
• Involved in design and devotement of new ETL processes and written DTD document for the new design.
• Created database link to refer to tables and views on another database.
• Handled complicated fixes in UNIX shell scripts to keep up the data sync and not affecting the current functionality.
• Automated data loading, extraction, report generation using UNIX shell scripting.
• Used CRON JOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Also provided 24/7 production support for the batch/production jobs.
• Created deployment document for different releases and maintained and updated versions in SVN.
• Involved in Production support and EACO call support.
• Involved in data model changes.
• Involved in Extracting data from various Data sources through different phases and placing the required data in the Target Database using PLSQL.
• Worked in designing and deployment of Parallel Environments in UAT and Production to do comparison on data between LEGACY and new channel.
• Worked in consolidating Mapping from new channel in to enterprise master mapping document.
• Identified, analyzed and Fixed the random and frequent production errors and made the current production CDC process to be 99% error free
• Written Data Fix scripts for tickets and new tables and supported user-pooling activity in Production.
• Written different SQL loader scripts to move data from one environment to another environment and to scrub the important data while copying data from production to lower environment.
• Involved in several important meetings for design reviews, data model reviews and code reviews.
• Written Validation queries for data compare between two databases source and target.
• Worked in on shore offshore model and lead the team to get the things done.

Environment: Oracle 11g, Oracle CDC, PostgreSQL 9.1,PL/SQL, Sybase Power designer 16.1, Command line editor, UNIX, TOAD.

Confidential

Database Lead developer

Responsibilities:

• Actively involved as a team member for gathering and analyzing the business requirements.
• Analyzed and reviewed the Business Requirements and System specification documents.
• Worked on maintaining the data model using Erwin Database Modeling tool
• Followed Waterfall for analysis and design phase and Agile for the development phase.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created multiple customized PL/SQL Packages for various business needs and modified existing packages to improve performance.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format.
• Extensively used mapping parameters, mapping variables and parameter files.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created database link to refer to tables and views on other databases.
• Added indexes to run queries faster on DB2 tables.
• Developed ETL using CSV files as sources and Oracle Database as Target.
• Created roles related to Seibel and oracle database and integrated them to LDAP users.
• Created and modified DB2 procedures for Application Support.
• Created new tables, triggers in DB2.
• Analyzed application SQLs and procedures for commits to avoid Dirty reads.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic, using TOAD.
• Written stored procedures and triggers in Transact-SQL in Microsoft SQL server Database for data conversion and data scrubbing.
• Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Manipulated PL/SQL tables and VARRAYs with BULK BINDS and BULK COLLECTS.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Developed PL/SQL programs to dump the data from staging tables to target tables.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Explain plan and SQL Trace.
• Using UNIX shell scripting created batch jobs to create Index and Analyze tables once the Imports are done.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Involved in writing Oracle PL/SQL packages, functions, procedures, Korn Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Provided support for the application database related issues.
• Involved in coding, debugging, and trouble-shooting.
• Optimized the databases with reorganizing and creating indexes on several tables for Query Analysis.
• Identified the defects in PL/SQL Scripts (cursors and nested loops) and optimized.
• Optimized the SQL 's of OLAP Applications
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Worked with AUTOSYS for Scheduling the Oracle scripts.
• Scheduled jobs in Autosys taking into account the ETL dependencies.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Worked on User-defined and the System defined exceptions to handle different types of errors like NO DATA FOUND, TOO MANY ROWS and PRAGMA EXCEPTION INIT.
• Supported the fact tables and dimension table with database objects for ware house system.
• Involved in Extracting data from various Data sources through different phases and placing the required data in the Test Database using SQL.
• Participate in development, testing and migration of oracle objects from development to testing and production environments.

Environment: Oracle 11g, Siebel 8.2.2 public sector, Microsoft SQL server, SQL, Oracle forms, Mainframes,DB2, DB2 Data Studio,DB2 Command line editor, SQL Enterprise Manager, Erwin Data Modeling tool, TOAD

Confidential

ETL Developer

Responsibilities:

• Involved in writing Technical Specification Document.
• Converted User Requirements into formal Functional specification and Interfacing with clients.
• Involved in creating logical and physical data modeling using Sybase power designer.
• Provided alternate views of a given model or portion of a model. Representation of high level vs detail views i.e. one display without attributes or identifiers and another with both. One view for the end user, one view for DBA, one view for management. One view in Physical modeling notation, one view in Entity Relationship notation (Physical Model only) using Sybase Power designer.
• Worked onTeradata Store proceduresand functions to confirm the data and load it on the table.
• Involved inAnalyzing / buildingTeradata EDWusingTeradata ETL utilitiesandInformatica.
• UsedSQL Assistantto queryingTeradata tables.
• UsedTeradata Data Moverto copy data and objects such as tables and statistics from one system to another.
• Involved in Designing data model for building Data Warehouse which includes staging area, ODS and OLAP structure flow.
• Worked with IBM CDC to add new tables and columns for Replication in Replicated database.
• Involved in Data Migration from Oracle 10g to 11g.
• Added indexes in the Source DB2 tables to pull data quickly from Informatica.
• Supported DB2 application on wring SQL queries and created views and procedures for Reports.
• Used MDM model for Oracle Data Store that pulls data from staging area from different sources and data mapping was done using META definition dictionaries.
• Involved in data analysis on source data and source Meta information to design and develop ETL.
• Followed mostly Agile Environment and sometimes Prototype model in SDLC.
• Involved in writing stored procedures, functions, triggers, and ad hoc queries for the applications using Microsoft SQL Server Database
• Involved in creating Test scripts for the generated final Reports.
• Planned version control of production source code using Rational Clear Case.
• Created CQ’s, assigned to developers, and myself using Rational Clear Quest.
• Created E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams using Power Designer.
• Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (Informatica and PLSQL Workflows), de-normalization for reporting purpose using Crystal Reports Developer, data security issues, development of ETL Process, development of ETL.
• Involved in Creating Data validation, Data cleansing, Data mapping Scripts and Monitoring Workflow errors and finding solutions for them.
• Developed interfaces using PL/SQL procedures and created packages to load data into targeted Oracle database.
• Developed several scripts to validate data in staging tables and developed Informatica Workflows to load the data from flat files into the staging tables, other database targets, flat files and XML.
• Involved in Migration of Workflows, Sessions, Mappings, and Mapplets from Informatica 8.1 to Informatica 9.5.
• Used Informatica GUI tool for building Oracle data warehouses and data marts.
• Used Informatica Primarily to build, deploy, and run ETL (Extract, Transform, and Load), relational and dimensional modeling, OLTP modeling, data quality, data auditing, and full lifecycle management of data and metadata.
• Used Informatica Mappings and Transformations to load data into the data mart.
• Involved in design using Star Schema (Facts, Dimensions and Aggregate tables), Mapping and loading data from source (flat) to target (Oracle) tables using Informatica.
• Used Informatica for Metadata reporting and Runtime reporting.
• Created Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes in SQL Server Database.
• Involved in design using Star Schema (Facts, Dimensions and Aggregate tables), Mapping and loading data from source (flat) to target (Oracle) tables using Informatica and PLSQL and SQL.
• Working knowledge with HTML, XHTML and JavaScript.
• Involved in writing Complex Queries, Store Procedures/Functions, Views, Triggers, Joins and Synonyms to maintain the Business Rules.
• Involved in validation including Source, category, and Code combination and checked for duplicates and nulls.
• Created staging tables necessary to store validated data prior to loading data into interface tables.

Environment: Oracle 11g, Informatica Power Center 8.1/9.5, IBM CDC, Teradata12.0/8.5,PL/SQL, SQL Enterprise Manager, DB2 Data Studio,DB2 Command line editor, Sybase Power Designer Data Modeling tool, TOAD,, JSP,CSS, .NET, DBMS JOB,UTL FILE, IBM Rational clear case, IBM Rational clear quest, DB2, SQL server 2012, Shell Scripting, SQL*Loader SQL developer, Business Objects

Confidential

Database Developer

Responsibilities:

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client.
• Manage software projects and develop enterprise solution
• Direct and integrate projects
• Work with team members to solve project related queries
• Worked mostly in Agile Environment and sometimes V- model in a SDLC.
• Involved in working with SOA tools, techniques, concepts, design patterns for data integration.
• Worked on Data Stage Tool for ETL.
• Designed and developed KAMS application using Entitlement modeling and role based access control of data and fields in the application.
• Integrated LDAP users with existing roles L0(external users),L1,L2,L3 and L4 roles.
• Designed, Partitioned, Developed and Maintained the database.
• Involved in data Migration from Oracle 10g to 11g.
• Worked to define the project implementation strategies.
• Developed and modeled OLTP data modeling, Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN.
• Comprehensive knowledge and experience, Cost Accounting, Manufacturing (INV, BOM, WIP, ASCP, PJM) (with EDI implementation), Oracle EBS Supply Chain, Functional OBM user.
• Supported Oracle EBS internal project team in mapping business process to Oracle modules like Purchasing, Inventory & Order Management.
• Involved in designing MDM model.
• Built Data mappings for ETL layer for MDM from EBS, external and internal sources using INFORMATICA, PL/SQL code, SQL*Loader and UNIX shell scripts.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Working with Java Front-End Developers on building and modifying applications.
• Worked on styles using CSS, HTML and HTML and JavaScript.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
• Worked on generating EDI for STA, ASN segments and few custom based invoices belonged to Invoice, Status and Entry and Generic EDI for most of the customers for the EMS application.
• Was responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL *Loader.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Involved in the required updates on the GUI front (JSP pages).
• Designed and completely implemented the front-end components using JSP, XML and HTML.
• Written backend processes to extract XML records using DBMS XMLGEN package and xml-parser to load into tables.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Involved in Database Performance Tuning using Oracle Hints, Bulk binds, explain plan, SQLTRACE, TKPROF, Partitioning and Indexes.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Supplied packages were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write files from and to database, DBMS SQL to write Dynamic SQL.
• Converted legacy data with over 2 million records, Performed application level SQL tuning.

Environment: Oracle 10g/11g, Oracle 11g,PL/SQL, DB2, Datastage, SQL Plus, Erwin 7.3,SQL Navigator, XML,DBMS XMLGEN, Shell Scripting, SQL*Loader, Shell Scripting, SQL Navigator, SQL developer, Reports 10g/6i, JSP,CSS, Java/Struts/Ajax Framework, DBMS JOB,UTL FILE,UNIX shell scripting