MAJY

Data Management

CPM Express • Full-time

Apr 2024 - Present • 2 yrs 3 mos

 Follow up on IT initiatives.  Analyzing and understanding the requirements.  Generating, collecting, and importing data from internal and external sources.  Processing raw data using ETL inside INFORMATICA POWER CENTER.  Strategic planning in order to comply related activities on time.  Developing mappings according with the business rules, sessions and workflows.  Creating and configuring the corresponding workflows to load the data to the DWH.  Working under Scrum Framework.  Good analytical skills in order to filter, to prioritize and to validate data from multiple sources.  Creating different reports and manuals (SOPs) of the different processes.  Providing reports according with each request required by user / customer.  Monitors workflows status.  Resolving issues inside ETLs processes.  Designing and implementing SQL queries for data verification.  Performing data validation (counts, schema, transformation rules).  Execute test cases to validate the ETL process.  Creating and designing reports using SQL Server Reporting Services (SSRS).  Propose initiatives in order to improve the processes, environment and manages.  Support and mentor to my team.  Elaborate documentation for certification in order to apply the changes in Production environment.  Interact with different areas: Business Analyst, QA, Customers.  Good communication and detail attention.  Learning continuous and adaptability skills.

Data Engineer

Freelancer.com • Full-time

Nov 2022 - Oct 2023 • 11 mos

 Formulating dashboards and reporting systems based on a business’s requirements.  Developing, testing, and maintaining dashboards and interfaces.  Translating data into business terms that users can understand.  Creating data visualizations, such as graphs and charts, for easy presentation.  Working with other members of the BI team and clients.  Writing and optimizing SQL queries and DAX to extract data and enhance performance.  Combine and transform data from different sources using Power Query.  Creating data models, defining relationships, and using ETL processes to clean and prepare data for reporting.  Gathering raw data from diverse sources such as relational databases, CRM, ERP and flat files.  Removing inconsistencies, missing values, and duplicates using transformations in Informatica Power Center.  Reformatting, filtering, aggregating, and joining data to fit business requirements.  Creating and updating mappings, sessions and workflows in IPC.  Assigning task to my team and mentoring them.  Designing and implementing SQL queries for data verification.  Performing data validation (counts, schema, transformation rules).  Log, track, and re-test defects.  Prepare and plan for testing by developing strategy, a test plan, and test cases for the process together Test Lead.  Execute test cases to validate the ETL process.

Technology Architecture

Infosys • Full-time

Aug 2021 - Oct 2022 • 1 yr 2 mos

 Formulating dashboards and reporting systems based on a business’s requirements.  Developing, testing, and maintaining dashboards and interfaces.  Translating data into business terms that users can understand.  Creating data visualizations, such as graphs and charts, for easy presentation.  Working with other members of the BI team and clients.  Writing and optimizing SQL queries and DAX to extract data and enhance performance.  Combine and transform data from different sources using Power Query.  Creating data models, defining relationships, and using ETL processes to clean and prepare data for reporting.  Experience with Scrum Framework.  Good Communication Skill.  Verifying that calculated measures and columns produce accurate results (Testing).  Checking for null values, inconsistencies, and data type integrity (Data Quality).  Comparing data displayed in Power BI visuals against SQL database queries or source files (Data Accuracy).  Confirming charts and tables render data correctly, including conditional formatting.  Verifying consistent fonts, colors, and layouts across all report pages.  Validating that reports move correctly from development, test and production.  Delegate activities to my three co-workers.