Bella Madonna Jadraque

• Responsible for designing the logical data models.
• Responsible for creating the physical data models.
• Provides the optimization strategy for the existing data models.
• Reviews the deliverables to ensure completeness and correctness against the business requirement.
• Ensures that the physical design meets the standards set by the Data Architecture team.
• Works with other Data Architects in developing the data solutions.
• Guides and provides inputs to the Solution Architects on the implementation of different BI solutions.
• Builds source system knowledge that can help determine the best source for a particular information
• Provides source to target mapping for reports, extractions, and other analytical requirements.
• Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Snowflake and Teradata SME
• 
  

• Gather and document client requirements and develop the application solution design
• Provide best practice guidance and mentoring to clients using the Teradata application.
• Capture ETL requirements.
• Design, develop, and test processes for validating and conditioning data prior to loading it into a data warehouse.
• Design, develop, and test processes for loading initial data into a data warehouse.
• Design the processes to meet service level agreements for data timeliness and frequency.
• Determine data growth trends and peak business periods.
• Create the physical data model with a data modeling tool like ERwin, PowerDesigner, etc.
• Modify the physical data model for efficient data access paths.
• Generate and execute DDL to create databases, tables, and views.
• Identify and create primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes.
• Create proofs of concept for innovative new solutions.

• Responsible in analyzing client business processes to propose optimal applications for unique requirements.
• Designed and developed forward-thinking systems that meet user needs and improve productivity.
• Created proofs of concept for innovative new solutions.
• Assessed business requirements to create focused solutions.
• Communicated and explained business requirements to team members to understand and implement functional demands.

• Responsible and monitored all the jobs in production and ensure data continuity.
• Responsible for creating CDW framework for fast and enhance creation of job.
• Included in Operations team for SIT runs.
• Responsible in enhancing and fixing all existing informatica jobs.

• Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse using Teradata.
• Loading development to target FSLDM table using Informatica Developer.
• Responsible in performing reconciliation between the old Data warehouse and new Data warehouse.

• Provide reports for all Safeway Employee in US and Canada
• Developed and Implement programs using Teradata.
• Part of Data Warehousing Team. Responsible for adhoc development and enhancements for existing systems using Teradata RDBMS from the onsite of Safeway Inc
• Developed and enhanced ETL Scripts using Teradata V2R5.1 BTEQ, Multiload, Fastexport and Fastload Utilities and Unix Korn shell.
• We used SQL Assistant for SQL operation and data retrieval.
• Performed SQL optimization using explain function, collect statistics and monitor SQL using Performance Monitor (PMON) utility.
• Performed unit, integration testing and apply DW script standards.
• Checked out/Checked in scripts using Changeman DS.
• Create turnover documents (process flow) for the support team after script/s are promoted to Production via Changeman DS. These are for newly created scripts.
• Create a Ctrl-M request (Schedule) for newly created scripts.

• Responsible in delivering multiple marketing projects. ·
• Responsible in developing and maintaining of major promo-related systems for marketing and customer care aimed at increasing activations / topups / usage and anti-churn programs.
• Responsible in enhance and maintaining they datamarts to ensure continuity of report and business requirements delivery.
• Responsible in delivering Audit and Admin delinquent and fraudulent Smart accounts.
• Responsible in 24/7 business support and technical support whenever, wherever the situation required.