SUMMARY:

Experienced professional with expertise in designing and developing relational database applications. Strong technical programming and documentation skills necessary to develop resolutions to complex issues. Strong background in Database Administration, PL/SQL, interfaces, and the Oracle Developer toolset. Strong oral and written communication skills.

COMPUTER SKILLS:

• Oracle 7/8i/9i/10g/11g/12c, Oracle Federal Financials11i/R12 TortoisesSVN
• Designer 6i/9i/10g, Greenplum MySQL, Postgres SQL
• Control M Unix Shell Scripting, AIX
• Reports 2.5/6i/9i HP Quality Center.
• PL/SQL & SQL Clear Case, Clearquest
• HTML/CSS Oracle Business Intelligence EE 11g
• Microsoft office Suite
• Unix/Linux Oracle Data Warehouse Builder, Toad, SQL Developer, PGAmin111, PL/SQL Developer
• Informatica 9.1, Informatica, power Center9.5, 9.6, power Exchange Oracle ODI 11g

EXPERIENCE:

Confidential

Responsibilities:

• Design, develop, test run ETL daily and weekly jobs like using Informatica Power Center, Shell Scripts, postgres, and control m into a RRP data warehouse work with control M team regularly to analyze and resolve failed job issues
• Work with production System Admin regularly to analyze the daily job output report provide resolution if need be make changes/ update exiting mapping to reflect FS17 filling season by using ICD mapping document

Confidential, Columbia, MD

Responsibilities:

• Assigned to the Hospital Reporting group of CMS, perform Informatica ETL design, configuration and implementation
• Design, develop, test and run ETL processes using Informatica PowerCenter, Shell Scripts, and PL/SQL into a large data warehouse
• Defining the strategy for the data migration, planning and execution. driving ETL architecture and design discussions with the client and HR team
• Design ETL mappings, Informatica ETL custom functions enhancement of Informatica Mappings, Work - flows, and processes
• Analyzes problems in terms of detailed requirements. Designs detailed flow charts. Verifies program/business logic by preparing tests data for trial runs.
• Perform improvements to existing codes/programs.
• Work well with other data architects to develop databases and data models to develop and implement ETL solutions
• Troubleshoot problems and provide resolution of how to in corporate techniques for data auditing and quality.
• Responsible for documentation of jobs/programs, including
• Create and maintain ETL related documentation; ensure project documents are complete, current, and stored appropriately turnovers, flowcharts, technical diagrams, and implementation plans and code
• Design, develop and maintain data warehouse and Extract, Transform and Load (ETL) solutions to support ongoing developments with relational databases develop, maintenance, and enhancement of Informatica Mappings, design, create sessions and workflow to execute the mappings troubleshoot and resolve workflow errors review log files for possible errors resulting from workflow
• Gathering the functional and technical requirements for ETL work stream
• Respond to customers queries on Informatica ETL issues and provide resolution as needed. modify existing scripts to meet business logic
• Create new Informatica scripts, transition of PL/SQL ETL’s to new Informatica scripts,
• Develop Informatica Mappings and writing complex Oracle PL/SQL programs for the Data Warehouse
• Analyze transaction errors, troubleshoot issues in the software, develop bug-fixes, performance tuning
• Design, develop, test and run ETL processes using Informatica Power rCenter, Shell Scripts, and PL/SQL into a large data warehouse
• Performance tuning on new and existing processes.
• Creating store procedures, functions, and packages to display data in Oracle Business Intelligence Enterprise as desire by the clients.
• Coding, Modifying, testing and debugging programs according to the business requirements.
• Performing software testing to validate system functionality and performance.
• Ensuring the application meets appropriate performance and security measures.
• Supporting and providing quality client service in the development, production and integration of software applications and systems that enable clients to successfully meet the specified goals.
• Supporting the maintenance of existing software applications.
• Generate complex queries and reports.
• Test programs according to functional business requirements.
• Reviewing and analyzing technical and functional requirement specifications for integrated software application and systems.
• Verifying functionality of system solutions using current quality assurance guidelines for technical design specifications.
• Participate in design, development, acceptance testing, and implementation of software programs and/or computer equipment. Develop flow diagrams and/or pseudo-code. Test and debug programs according to detailed requirements.

Confidential, Crystal City, VA

Responsibilities:

• Wrote preliminary PL/SQL packages to perform testing feasibility of conversion approach options.
• Investigating, analyzing and selecting tools methods for improving the performance and software quality throughout the life cycle.
• Resolving critical issues affecting the configuration setup of the application.
• Performed system, functional and regression testing on seven DAI applications.
• Wrote technical documentation for data conversion from legacy mainframe and various systems to Federal Oracle E-Business R12 Project module.
• Writing technical design documentation (MD70s) using the AIM methodologies.
• Working with functional team to gather and clarify requirements.
• Involve in the planning, developing, scheduling and conducting systems acceptability test products..
• Worked closely with development and other team members to ensure 100% deliverable product.
• Works well with others, excellent problem solving skills.
• Experienced with project deadlines and schedules.
• Experienced with test procedures and specifications.

Confidential

Oracle Database Engr Sr Prof

Responsibilities:

• Using industry best practices and methodologies design, develop, and implement extract-transform-load (ETL) processes using Oracle Warehouse Builder.
• Develop annual load project using Oracle Warehouse Builder to load (PRISON/PRISONER, IMF, IRMF, and BMFENT) into the EFDS database for a particular tax period.
• Develop annual load project using Oracle Warehouse Builder to load (BMFRTF) into the BMF database for a particular tax period.
• Develop, update, and maintain OWB ETL scripts and other Loads related UNIX shell scripts
• Make significant changes to some shell scripts to reflect Production Release changes for the specific year.
• Develop data models to store data in a manner that supports Questionable Refund Program (QRP0112).
• Write Procedure, Function and Package to support Questionable Refund Program (QRP0110).
• Determine the relationships between data elements, tables and other Objects in the database.
• Determine the business rules that apply to each data element.
• Determine processes and procedures to examine input files and apply changes to existing codes as related to Production Release changes
• Provide support to SAT, AQT during transmittals testing.
• Analyze and fix item resulting from either AQT, SAT or Production.
• Modify and make changes to C program to reflect Production Release for the year.
• Assess and evaluate test data and make necessary change to the program for the year.

Confidential

Oracle Database Consultant

Responsibilities:

• Providing DBA support for the new Scholastic Aptitude Test online application.
• Tuned complex queries.
• These queries where originally timed in hours and I reduced the time to minutes or milliseconds.
• I used the latest tuning hints and SQL coding methods.
• Recommended Database Design enhancements for more efficient operation.
• The customer was very satisfied.
• Created database objects to support modification of some of the queries.
• Discover ambiguous use of sql operator in most of the statement.
• Validate the init.ora parameter file for appropriate setting.
• Help to schedule batch job to run periodically.

Confidential

Responsibilities:

• Writing Procedure/Packages to load data from various facilities to stage area, dimension tables, and fact table.
• Reviewing and assessing existing data processing methods and techniques
• Extracting data from legacy systems; transform and load data to the warehouse using Procedures/Packages.
• Migrate Oracle Discoverer 3.0 to Discoverer 9i
• Created SQL, PL/SQL and shell scripts to extract, transform and load data using SQL Loader.
• Review, conversion and integration of Access forms into oracle forms using Oracle 9iAS application forms and reports.
• Converted MS Access extract queries to oracle SQL queries.
• Creating and managing primary objects such as tables, views and indexes
• Performed quality analysis testing of all application modules.
• Performed application, database and SQL codes tuning.
• Performed applications’ performance tuning, SQL tuning, procedures, packages for optimal query executions.

Confidential

Principal Consultant

Responsibilities:

• Developing and maintaining the Metadata repository
• Designed Violations Data Warehouse repository for al system.
• Designed ETL methods and star schema for reporting.
• Developing data marts and data warehouses
• Created conversion tables to serve as temporary staging areas for data transformation and scrubbing before loading
• Revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage
• Ensure integrity and recoverability of database structures.
• Ensuring the recoverability of the database structure
• Working with managers and users to develop business requirements and to analyze/model current and proposed business process flows
• Performing database performance tuning and re-organizations
• Implement and maintain database structures
• Monitor and tune the database environment for improved application and system performance
• Tuning SQL statements and PL/SQL using Explain Plan, SQL Trace & TKPROF, and Hints.
• Design and scheduling the database maintenance plan.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical
• (Online & Offline) Backup.
• Creation of shell scripts to automate extraction, transfer, and encryption of extracted data between Best Buy and TWC on weekly basis.
• Application performance testing.
• Quality analysis testing of application, and Production support.
• Process documentation and preparation of manuals.
• Preparation of detail project assessment and costing documentation.
• Assisted in sourcing of resources and selection processes.
• Performed extraction and loading of data for database refreshes on a regular basis to support the development and QA units.
• Developed SQL and shell scripts to generate statistical report in identifying anomalies within the active subscriber services accounts.
• Carried out regular application and database performance tuning for the Reliance applications.

Confidential

Software Engineer

Responsibilities:

• Responsible for the development and maintenance of Screen Forms, Report, PL/SQL Procedures, Functions and Packages in the support of the WMS-EE product.
• Create PL/SQL procedures, functions and packages to support applications.
• Designed, developed, and create data warehouse using Oracle Warehouse Builder.
• Peforming GUI interface through Oracle Forms, and Oracle Reports.
• Updated data within the data warehouse on a weekly basis using job scheduling tools within the Oracle Enterprise Manager (OEM), as well as with customized scripts created using PL/SQL packages, and procedures.
• Mined and analyzed warehouse data using Oracle Discoverer, Oracle Reports, and Oracle Query Builder
• Developed patches using a combination of C language, SQL*PLUS, and PL/SQL coding to develop functions, triggers, procedures, scripts and packages to resolve reported bugs from clients, and upgrade of such resolutions into new releases.
• Created new tables for application enhancement, and load data into the tables using the SQL Loader.
• Responsible for report development pulling data from an information repository using crystal 8.5 to create and generate reports for end users
• Create modules based on established requirements using Oracle Forms 6i
• Undertook several tuning efforts to ensure a high performance in the database by either creating new index or droping existing ones as the case maybe.
• Enforce integrity constraints of database with primary key, unique, check, and constraints.

Confidential

Programmer Analyst

Responsibilities:

• Created and modified various applications, reports, pop-up windows, INOUT windows, function keys, error messages, and use of PL/TRIM SQL and C language in application customization.
• Used Oracle Designer 2000 on Oracle 7.3 database to generate table constraints and codes, entity relationship and module diagrams.
• Responsible for the development and maintenance of Screen Forms, Report, PL/SQL Procedures, Functions and Packages in the support of the SGI-NET product.
• Transferred data from old system to new using PL/SQL Procedures, Functions, and Packages.
• Write various kind of script to track goods from warehouse to their destination, ensure stolen tickets are not validated and to reconcile the total number of goods delivered to each retailer.
• Built and customize forms for database objects.
• Construct triggers, procedures, and functions to enhance operational functionally of applications.
• Develop client/server applications using Oracle Developer/2000, SQL, and PL/SQL.
• Peforming GUI interface through Oracle Forms, Oracle Reports and Oracle Graphics.
• Customize and generate report using Oracle Report and SQL*PLUS.
• Enforce integrity constraints of database with primary key, unique, check, and constraints.
• Created tables and views utilizing SQL.
• Performed DBA functions such as creating synonyms, tablespaces and indexes and established datafiles, control files, and redo log files.