Experience with managing teams of report writers and developers. Understand and articulate Business Requirements to developers. Meet BAs and businesses to understand requirements. Experience in debugging interfaces. Identifying bugs in existing reports/interfaces.
Strong in data analysis. Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), and Data Modeling like Dimensional Data Modeling, Start Schema Modeling, Snow-Flake Modeling, and FACT and Dimensions Tables. Design, and develop objects for ETL projects, gathering requirement specification documents, and presenting and identifying data sources.
Maintain and enhance custom changes in the application. Experience in Extraction, Transformation, and Loading of data from multiple sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files, and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems. Experience in Performance Tuning at all levels. Experience with Oracle SQL Plus, PL/SQL, and SQL Loader scripts for data conversions.