Fiori Gebre

· Worked with the Business analysts and the DBA for gathering, business analysis, testing, metrics and project coordination

· Involved in logical modeling and physical modeling of application

· Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL

· Involved in creation of Conceptual Modeling covering all the business requirements

· Loaded the data into database tables using SQL

· Loader from flat files

· Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views, table joins and functions as per the business requirements

· Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases

· Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL

· Loader

· Used the standard Oracle package DBMS SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance

· Developed Procedures for efficient error handling process by capturing errors into user managed tables

· Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks

· Developed data conversion procedures in PL/SQL

· Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation

· Developed Shell scripts to automate the execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to the sender notifying the errors

· Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE, and DBMS SQLTUNE

· Developed UNIX Shell scripts to automate table creation, and execute procedures.

• Analyze operational activities to obtain a quantitative, rational basis for decision making and resource allocation
• Conceptually understand and convey to stakeholders and leadership complex topics related to data management, data governance, and data maturity.
• Work with subject matter experts (SME) across organizations to collect and update business and technical metadata.
• Reverse engineer data models and other design or build artifacts to extract relevant business and technical metadata and load into a metadata repository
• Develop source-to-target (STMs) that document data transformation at the interface level
• Create project plans to achieve performance-based objectives, enhancing implementation, systems and service
• Review submitted data to detect data quality problems and anomalies and help organization correct data: both current and historical
• Provide integral support in mission requirements determination, conceptualization, design, development, testing, verification and validation, documentation, and implementation of system applications
• Collect and analyze data and associated system artifacts for stakeholders to use in perfecting their business practices
• Perform analysis to determine how data might best be applied to profit the stakeholders
• Develop ETL routines to load and curate disparate data sets
• Produced monthly reports using advanced Excel spreadsheet functions.
• Utilized data visualization tools to effectively communicate business insights.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Improved decision-making processes with accurate data analysis and visualization techniques.

• Utilize advanced SQL skills to retrieve complex data sets from institutional databases.
• Employ Python, especially Pandas, to analyze, validate, and categorize large datasets comprising up to a million rows.
• Develop scripts to programmatically validate reporting results, identifying and flagging potential inconsistencies using statistical methods.
• Leverage strong Excel skills, including pivot tables, built-in functions, and charting, to manipulate and present data effectively.
• Utilize Tableau to design and implement visualized and interactive reporting dashboards, enhancing data visualization and accessibility.
• Abstract information requirements from real-world data requests, ensuring clarity and accuracy in data analysis and reporting.
• Utilize PowerPoint and Word to create comprehensive data reports, effectively communicating insights and findings to stakeholders.