Subrat Rout

1-301-***-****

ad4ci5@r.postjobfree.com

Professional Summary

●Sr. ETL Developer, Oracle PL/SQL Developer, Database Administrator, Data Modeler, Data Architect and Sr. Oracle Application Developer with more than 24 plus years of experience in Software Development in Complete Life Cycles of SDLC method, Agile and Scrum method for different Business Applications.

●Hands on PostgreSQL, ORACLE, MySQL, and MS SQL Server Database Administrator and Architect with 10+ years of full life cycle database administration and development experience in OLTP and Data Warehousing, on-premises and in-cloud environments.

●Experienced in database conversion from Oracle and SQL Server to PostgreSQL and MySQL.

●AWS Solutions Architect with experience in RDS and EC2 environments

●Expertize in database migration to AWS cloud infrastructure

●Experience on Cloud Databases and Data warehouses (Redshift/RDS).

●Special interest and experience in AWS cloud infrastructure database migrations, PostgreSQL and converting existing ORACLE and MS SQL Server databases to PostgreSQL, MySQL

●Certified Systems and Network administrator with cross-industry and cross-functional training and experience in large multi-platform environments (LINUX, SOLARIS, AIX, WINDOWS)

●Extensive experience in the areas of Data Management & Data Warehousing, Software Engineering, Financial and Mortgage Industry, Telecommunications, Manufacturing, Warehousing, Medicaid, Medicare and Government

●10+ years in Information Technology with Expertise in Data Architect and Data modelling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

●Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support Oracle database management.

●Involved in various projects related to Data Modelling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

●Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin/ER Studio, normalization, Star and Snow Flex Schema), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012, SSIS and SSRS 2012.

●Database creation and modeling, SQL Server Integration Services (SSIS) and Business Intelligence Development (BIDS), Stored Procedures, Triggers, Data Reporting

●Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

●Worked extensively on Erwin and ER/Studio, SPSS in several projects in both OLAP and OLTP applications.

●Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.

●Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

●Ten Years’ experience in Sr. Oracle Developer as SQL, PL/SQL Forms, Reports, Oracle Batch Processing, Oracle streams, DataStage7.5/8.5, COGNOS 8.1, Discoverer, Oracle 6.0/7.0/8.0/8i/9i/10g/11g and OPUS (Open Product Underwriting System)

●Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.

●Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers

●Good understanding of views, Synonyms, Indexes, Joins and Partitioning.

●Generate DLLs/DMLs from data model

●Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Data Stage and Data services.

●Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

●Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes and data relationships.

●Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types and corporate meta-data definitions.

●Exceptional communication and presentation skills and established track record of client interactions

●Main Domain Knowledge in BI Application, Medicaid, Medicare Information System, Automobile, Financial services, General Insurance, Health Insurance, HR, Payroll, Time sheet

●Three plus Years’ experience in Open Product Underwriting System (OPUS) Tool which support to configure the General Insurance Functionalities.

●Three years of Experience in UNIX, Shell Scripting

●Two and half years’ experience in ETL Data Stage Developer.

●Fifteen Months experience in COGNOS Developer.

●2 years of experience in Mainframe, COBOL, CICS, DB2, IMS

●Worked on AWS cloud environment, AWS RDS, AWS EC2, Nagios, Splunk, SQOOP, SPARKS, LAMDA, AWS DMS, AWS IAM, PostgreSQL, MySQL

Technical Summary

Data Modelling

Erwin r7.1/7.2, ER/Studio V8.0.1 and Oracle Designer

Operating Systems

MVS/ESA, UNIX, Windows 2000/XP/NT, Windows 7 and MS - DOS

DBMS

EC2, RDS, REDSHIFT, RDBMS, ORACLE 19c/18c/12c/11g/10g/9i/8i/8/7.3, PostgreSQL, MySQL SQL Server 2008, Oracle streams, IMS/DB (Hierarchal DB), DB2 (Relational DB), TOTAL (Networking DB)

Languages

SQL, PL/SQL, COBOL, FORTRAN, PASCAL, C, C++, JCL, UNIX, Shell, Python Programming

ETL Tool

Informatica 10.1, SSIS, Data Stage 8.0.1/7.5.3 and Data Services 4.0

Reporting Tool

COGNOS 8.1, Oracle Reports 6.0, 8i, 9i, 10g

Tools

Oracle Configurator Developer (11.5.8), Lotus Notes and Domino Editor 6.5.1, Erwin 3.5.2, Visio 2003

Domain

Automobile, Financial Services Practice, Health care, Insurance, Product Development and Utilities domain knowledge

Client Server Tools

Developer/2000(FORMS 3.0/4.5/5.0/6.0/6i/9i, 5/3.0/6.0/6i/9i), HTML, MS-FRONT PAGE, REPORTS 2.0/2. 5, Open Product Underwriting System (OPUS)

AWS CLOUD

EC2, S3, ELB, IAM, CloudWatch, CloudTrail, DMA, SCT

DBA Tools

TOAD, SQ Database Administrator L*Loader, Import & Export

Application Servers

Oracle 9iAS

Other Tools

GIT, SVN, Clear Case, Clear Quest, VSS, WINCVS, CHANGEMAN, XPEDITER and ADPAC

Web Tools

APEX 3.1.2, Java, HTML, Web Logic 6.x

Web Services

SOAP

Professional Experience

Biswas Information Technology Solution Inc. (Bits)

Remote Work

Senior ETL Developer

Project: Food and Drug Administration (FDA)

Jul 2021 to Present

The Center for Drug Evaluation and Research (CDER) performs an essential public health task by making sure that safe and effective drugs are available to improve the health of people in the United States.

Working as a Principal DBA for BITS on CEDR applications (CDP-Corporate Database Portal, CI-Clinical Investigator Site Selection, PVC-Pharmacovigilance Compliance Site Selection and IRB SST - Institutional Review Board Site Selection Tool). The project is comprised of multiple systems. I am on the development side and responsible for develop/maintenance / support on several Oracle databases which are hosted on AWS: EC2/RDS services.

●Working on Sr. Oracle PL/SQL Developer.

●Working on design all database models (Conceptual, Logical and Physical Model).

●Working on build Entity Relationship (ER) diagram in ER-Studio Designing Tool.

●Working on the overall database architecture.

●Worked on the Informatica Power Center tools – designer, workflow Manager and Workflow monitor

●Design and developed complex mapping by using lookup transformation, expression, sequence generator, update, aggregator, router, stored procedure to implement complex mappings while create mappings

●Developed mappings using Informatica to load the data from sources such as relational tables, flat files into target warehouse

●Developed mappings/transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter

●Involving in preparing material and training Business users implemented slowly changing dimensions (SCD, Both Type 1 and Type 2)

●Tuned the performance of mappings by following Informatica best practices and applied several methods to get best performance by decreasing the run time of workflows designer in workflow manager and monitored the results in using workflow monitor

●Developed workflows using task developer, worklet designer and workflow

●Working on developing Packages, Procedures, functions, views and all the database objects in AWS RDS Oracle.

●Participate in business requirement, Design and implementation meetings.

●Write all database code (Packages, Procedures, Functions, views and rest all database codes) in PL/SQL.

●Working on with Record, Object and Type and writing Analystics

●Work on performance issues in oracle.

●Migration of Oracle On prem database to Oracle RDS in AWS.

●Migration of Access Database to Oracle.

●Work on Data Migration Service (DMS) and Schema Conversion Tool (SCT) in AWS.

●Worked on SQL Server Database migration from SQL Server 2012 to SQL Server 2019

Science Applications International Corporation (SAIC)

Remote Work

Senior Oracle Pl/SQL Developer

Project: FMCSA-Department of Transportation(DOT)

Nov 2020 to Jun 2021

National Applications and Technology Solution Services (NATSS) provides a full service IT Cloud solution to host enterprise applications for the Federal Motor Carrier Safety Administration (FMCSA). The application portfolio supports Registration, Inspection, Compliance, Enforcement and Mission Support Systems. We provide enterprise infrastructure engineering, solutions architecture, software and systems development, test and evaluation, quality assurance, configuration and release management, data management, IT security, service desk, operations and maintenance and business process engineering services for the infrastructure as well as the applications within the FMCSA portfolio.

Working as a Principal DBA for SAIC on Department of Transportation’s, FMCSA contract. The project is comprised of multiple systems. I am on the operations side and responsible for maintenance / support on several Oracle databases which are hosted on AWS: EC2/RDS services, SQL server Databases as well as AWS Aurora PostgreSQL Databases. I have been involved in multiple roles as database specialist with my roles ranging from performance tuning specialist, DBA, troubleshooting complex production issues and making architectural recommendations as per the best practices.

●Provided database solution in AWS (Amazon Web Services) EC2 & RDS environments.

●Configured and built EC2 database servers for hosting oracle databases and monitoring software.

●Worked on Safety Measurement Service (SMS) Monthly Baseline Oracle databases from EC2 to RDS and from RDS to S3.

●Installed and configured OEM monitoring tools for host and database monitoring.

●Provided on-call 24x7-database support and troubleshooting for on-premises and in-cloud/AWS Oracle databases.

●Participate in business requirement, Design and implementation meetings.

●PL/SQL is used to extract data from sources systems and generate .csv files

●Enhance the code for performance issues from lower to higher environment.

●Support QA team for clarification or sometimes guide them to test the system.

●Develop the package, stored procedure or function for development activities.

●Analyze performance and monitor work with capacity planning.

Science Applications International Corporation (SAIC)

Alexandria, Virginia

Senior Oracle Pl/SQL Developer

Project: IT Stabilization-USPTO

Feb 2020 to Oct 2020

As IT Stabilization focuses on many of the enablers of IT Modernization, it provides a solid foundation that can enhance and expedite USPTO’s future and active IT Modernization efforts while reducing costs. The scope of the ASP includes USPTO’s most critical IT Automated Information Systems (AIS’s) as discovered during an independent assessment. These AIS’s have been selected because they exhibit many of the same issues with regards to legacy code, non-standardization, aging hardware, end-of-life products, and complex interdependencies. Additionally, they are interdependent as a group – essentially forming a critical ecosystem which may only be stabilized as a whole in order to succeed. This was evidenced by catastrophic outages of 2018 and 2015 when a single offline AIS has led to numerous other AIS failures.

●Analyze, Design, develop and implement of new requirements based of USPTO business requirement.

●Providing proposed solution architect from legacy system to cloud

●Responsible for New Development, enhancement and bug fixing from legacy Mainframe Version 2.4(V2R4) and Oracle11g date to Oracle18c/19c for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers

●Worked on database validation of all database objects (tables, views, packages, procedures etc.) between legacy databases to new database.

●Implement DevOps and CI/CD pipelines to automation the process

●Prepare Source to Target Mapping Documents with business transformation rules

●PL/SQL is used to extract data from sources systems and generate .csv files

●Support Production issues or any other lower environment issues in the loading process or Materialized View Refresh Process

●Working on Python script to schedule the batch processes.

●Involve daily development activities such as enhancement, bug fixing or improvement of the existing code

●Develop the package, stored procedure or function for development activities.

●Work on Performance of queries and code to optimize to meet the client’s Service Level Agreement (SLA).

●Work on CRON Jobs to schedule the Database code through shell scripts.

●Support QA team for documentation and clarification.

●Worked on Oracle Golden gate such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis

●Replicated tables using single extract/pump/replicate process, performed many to one replication

●Hands on experience in Data Import/Export and backup using fulfil Import/Export

●Monitor the performance of the system using OEM

●Expert in performance tuning of database, memory & I/O. used tools such as AWR, ADDM, STATSPACKING, HANG ANALIZE, SYSTEM STATE and analyzing queries using EXPLAIN PLAIN, SQL-TRACE, TKPROOF, OEM

●Handled all daily DBA activities and experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules

Karsun Solution LLC

Herndon, Virginia

Senior ETL Developer

Project: Procurement Information System for) Management (PRISM)

Feb 2018 to Nov 2019

FAA PRISM is procurement financial application. The OCI interface is the integration of FAA’s current procurement system, PRISM and Delphi. The OCI interface is a custom program, which provides the system with the ability to interface POs, BPA Calls, Contracts, DO/TO, Acceptance and Invoice information between PRISM and Delphi Purchasing. As of March’ 06 at FAA requisitions are created in PRISM and are not sent to PRISM via the OCI solution.

The scope of the interface revolves around the functionality of OCI and its ability to transmit information between PRISM and Delphi.

●Provided guidance and implemented PostgreSQL database solution in AWS (Amazon Web Services) EC2 & RDS environments.

●Configured and built EC2 CentOS database servers for hosting PostgreSQL databases and monitoring software.

●Converted Oracle databases to PostgreSQL and MySQL

●Installed and configured Nagios monitoring tools for host and database monitoring.

●Migrated PostgreSQL and MySQL databases from on-premises to AWS EC2 and RDS environments.

●Monitored and maintained EC2 & RDS databases using CloudControl

●Provided on-call 24x7 database support and troubleshooting for on-premises and in-cloud/AWS PostgreSQL, MySQL databases.

●Analyze, Design, develop and implement of new requirements based of FAA business requirement.

●Responsible for New Development, enhancement and bug fixing on Oracle12c for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers

●Designed and developed complex aggregate, join and lookup transformation rules (business riles) to generate consolidated(fact/dimension) data identified by dimensions using Informatica Power Center

●Converted existing PL/SQL packages to ETL mapping using Informatica Power Center

●Prepare Source to Target Mapping Documents with business transformation rules

●Participate in business requirement, Design and implementation meetings.

●PL/SQL is used to extract data from sources systems and generate .csv files

●Support Production issues or any other lower environment issues in the loading process or Materialized View Refresh Process

●Involve daily development activities such as enhancement, bug fixing or improvement of the existing code

●Support other downstream and upstream teams if any issues or clarification.

●Enhance the code for performance issues from lower to higher environment.

●Working on Python script to schedule the batch processes.

●Support QA team for clarification or sometimes guide them to test the system.

●Develop the package, stored procedure or function for development activities.

●Analyze performance and monitor work with capacity planning.

Environments & Tools: Informatica Power Center 10.1, Shell script, Workflow Manager, Oracle, PostgreSQL 9.5/9.6, MySQL 5.6/5.7, AWS, EC2 & RDS, OEM, Quest Tools (TOAD), LINUX, WINDOWS

College Board

Reston, Virginia

Senior ETL Developer

Projects: RDL and K12 Reporting

June 2017 to Dec 2017

K12 is the College board portal site to view and analyze all student SAT/PSAT, PSATNM/PSAT 10 and PSAT 8/9 subject tests score reports.

●Analyze performance and monitor work with capacity planning

●Analyze, Design, develop and implement of new requirements based of state rules of SAT/PSAT score.

●Support as ETL Developer during the analysis, planning, design, development, and implementation stages of projects using Informatica ETL tool.

●Designing and building multi-terabyte, full end-to-end Data Warehouse infrastructure from the ground up on Confidential Redshift for large scale data handling Millions of records Weekly Load.

●Worked on AWS Data Pipeline to configure data loads from S3 to into Redshift

●Prepare Source to Target Mapping Documents with business transformation rules

●Participate in business requirement, Design and implementation meetings.

●Informatica ETL tool is used to extract data from sources systems, loaded the data into the ORACLE database.

●Worked on Informatica Power Center Designer using expression, filter and sequence generator, Update Strategy, Joiner and Store Procedures transformation

●Support around 50 Materialized views which runs every weekend to provide the data to k12 portal after cube refresh.

●Support Production issues or any other lower environment issues in the ETL loading process or Materialized View Refresh Process

●Involve daily development activities such as enhancement, bug fixing or improvement of the existing code

●Support other downstream and upstream teams if any issues or clarification.

●Enhance the code for performance issues from lower to higher environment.

●Support QA team for clarification or sometimes guide them to test the system.

●Develop the package, stored procedure or function for development activities.

●Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.

●Created a shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.

●Coordinate with team members and administer all work packages.

●Implements conceptual designs, logical designs, physical designs, external data interface specifications, data loading plans, data maintenance plans, and security policies

●Worked on Database backup in AWS RDS in PostgreSQL

●Implement in AWS cloud with AWS REDSHIFT, RDS, EC2, PostgreSQL, LAMDA, SQOOP, SPARKS, OEM, Quest Tools (TOAD)

Client Network Incorporated (CNSI)

Rockville, Maryland

Senior Data Architect/Database Administrator

Project: MWMMIS (Michigan State)

September 2015 to May 2017

CSHCS strives to enable individuals with special health care needs to have improved health outcomes and an enhanced quality of life through the appropriate use of the CSHCS system of care.

●Managed, designed and implemented managed assets application projects utilizing Erwin and IBM Data Architect

●Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.

●Enforced naming standards and data dictionary for data models

●Developed data migration and data validation PL/SQL scripts from old system to new system

●Performed SQL Query performance analysis using Toad Client software for Oracle

●Developed some other PL/SQL packages for interface system

●Responsible for New Development, enhancement and bug fixing on Oracle10g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers

●Created DB2DB interface jobs with SOA (Service Oriented Architecture)

●Optimizing SQL statements using hints, Indexes, Explain Plan

●Used TKPROF, Hints for SQL tuning. To write UNIX shell script to run some CRON jobs

●Used Profiler in the code to generate the AWR report

●Worked with programmers and project managers to create data models for new features

●Created and optimized indexes and queries to ensure peak performance at all times

●Designed, developed, and maintained all person matching logic using any data available

●Designed, developed, and maintained a bulk processing backend which allowed clients to update live

GEICO

Chevy Chase, Maryland

Data Architect/Database Administrator

Project: IBU Claim Data Model

July 2014 to August 2015

●Worked on multiple projects with different business units including Insurance

●Gather the various reporting requirement from the business analysts

●Created and maintained the Data Model repository as per company standards

●Developed normalized Logical and Physical database models to design OLTP system for insurance applications

●Involve in Data Model to design the data base as business requirement

●Working on Data Model tool i.e. Guide Wire to prepare the scripts and compile in Perforce version control

●Working on SPSS Modeler for data mining and text analytics

●Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.

●Formulated procedures for integration of R programming plans with data sources and delivery systems

●Modeled distribution of data from historical experiment

●Working on performance tuning of SQL

●Create some optimized query as of business requirement in Claim environment

●Write the SQL code as of the different application team needs for data extraction

●Involve in New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, Objects, Types, Views

●Use the Import Guide wire tool for data patch from lower to higher environment

●Optimizing SQL statements using hints, Indexes, Explain Plan, TKPROF, SQL TRACE or AWR report for performance tuning

●Fine tune the SQL query by using Oracle Enterprise manager (Oracle Enterprise Manager) with help of DBA

●Creating or modifying the shell script for the batch job.

●Support the batch job which runs every day mid-night.

Environment: Oracle 11g, ERWIN r7.1, TOAD, UNIX.

Tetra Tech

Arlington, Virginia

Data Architect/Database Administrator

Project: Employment Information System (EIS) and Traffic Count Index Program (TCIP) for Federal Aviation Administration (FAA)

November 2013 to June 2014

FAA BI employee information system provides the FAA employee and contractor personnel information. Any employee can go and change their personnel data needs to be captured in Data ware house on daily job runs at mid-night. Traffic Count Index system captures the data for current Counts of system through XML files and loads the data on hourly and calculates the Traffic Count Index on hourly basis for all towers and tycoons. TCIP operates the towers and tycoons in the airport itself thought out the country. Working on multiple applications such as EIS (Employee information system), TCIP of business area.

●Involve the business requirement to understand the Data warehouse business process.

●Conducted one-on-one sessions with business users to gather data warehouse requirements

●Developed a Conceptual model using Erwin based on requirements analysis

●Design the dimensional modeling STAR and SNOW FLEX schema as of business requirement.

●Prepare the program spec

●Create Database Objects such as Tables, Views, Materialized views

●Optimizing SQL statements using hints, Indexes, Explain Plan

●Used TKPROF, Hints for SQL tuning

●Fine tune the SQL query by using Oracle Enterprise manager(OEM)

●ETL Tool Business Objects Data Services

Environment: ERWIN r7, Oracle 11g, TOAD, SQL and PL SQL and UNIX

Centuria

Herndon, Virginia

Data Modeler/ Data Architect

Project: National Resource Manager (NRM: For Forest Service: USDA) for Federal Government

July 2012 to October 2013

Natural resource management refers to the management of natural resources such as land, water, soil, plants and animals, with a focus on how management affects the quality of life for both present and future generations. Natural resource management deals with managing the way in which people and natural landscapes interact. It brings together land use planning, water management, biodiversity conservation, and the future sustainability of industries like agriculture, mining, tourism, fisheries and forestry. It recognizes that people and their livelihoods rely on the health and productivity of our landscapes, and their actions as stewards of the land play a critical role in maintaining this health and productivity. Responsible for couple of business area i.e. Range, Minerals, CPAIS applications.

●Involve the business requirement stage to understand the data warehouse business process.

●Prepare the design documents as of business requirement

●Performed GAP Analysis on data mappings, and data element transformations

●Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.

●Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.

●Extensive experience in using PL/SQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge, Global Temporary tables.

●Prepare the program spec

●Developed the code in Pl/SQL, forms and reports and Jasper reports.

●Working on ETL environment in CPAIS application using SQL Server.

●Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS. Used dynamic connection managers using SSIS expressions to load data from multiple databases into a single DB.

Environment: ER/Studio, SSIS, SQL Server 2008, Oracle 10g, TOAD.

Economic System

Falls Church, Virginia

Senior Oracle PI/ SQL ETL Developer / Data Architect

Project: Hiring Management System (HMS) for Federal Government

December 2010 to June 2012

The Hiring Management System (HMS) facilitates the applicant to apply the job in federal government. This system provides the position classification, recruitment request, case tracking, vacancy announcement, store certificates and on board the employees. This system helps the HR Manager and Hiring Managers to hire right people in right position. Right now, there are few agencies are using this system to hire people. There are certain oracle batch jobs scheduled in this project to update the status of applicant’s whether this person is qualified or not for the job applied for.

●Design the system by understanding the business requirements.

●Design the Process flow and ER diagram

●Prepare the program spec and Developed the PL/SQL Package

●Responsible for New Development, enhancement and bug fixing on Oracle11g for writing SQL and PL/SQL e.g. Packages, Procedure, Functions, DB Triggers., Objects, Types, Views

●Optimizing SQL statements using hints, Indexes, Explain Plan

●Used TKPROF, Hints for SQL tuning.

Environment: Oracle 10g, TOAD, ER/Studio.

Client Network Incorporated

Gaithersburg, Maryland

Senior Oracle PL/ SQL ETL Developer / Data Architect

Project: ETL Data Warehouse Medicaid System (WAMMIS – Washington State and SDMMIS – South Dakota State)

March 2008 to November 2010

ETL DATA WAREHOUSE MADECAID SYSTEM: The Washington MEDICAID system (WAMMIS) facilitates the claims processing of the all the members and produces the checks for the service providers for Washington State in Olympia. The ETL data warehouse system consists of three parts i.e. (I) Extraction, (ii) Transformation and (iii) Load. There are total around nine subsystems (Claims, client, common, pa, tpl, reference, drb and provider) data comes from OLTP system and extracted to flat files and reads those flat files by ETL jobs and got loaded to target tables. Process Flow: There are around four hundred and seventy tables are generated in the extraction process (By using PL/SQL Package) and ftp to target location and ELT jobs start reading those files and got loaded in target tables

Contact this candidate