Designed and implemented SQL based tools, stored procedures and functions for daily data volume and aggregation status
Developed ETL procedures to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
Designed programs for data extraction and loading into Oracle database.
Created and managed database objects including tables, indexes and procedures.
Developed and tested programs using SQL, PL-SQL and SQL Loader for database applications.
Developed and generated standard and ad hoc reporting capabilities from new and existing data sources.
Developed and modified queries, programs, and stored procedures to support standard and ad hoc reporting.
Transformed business requirements into technical specifications, source-to-target mappings.
Analyzed data source to design simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in.
Integrated the data from multiple data sources into a single, consistent data store that is loaded into a server.
Created a trove of historical data that helps to retrieve and analyze to provide useful insight into the organization's operations.