Associate
pubic Investment Fund
Total des années d'expérience :10 years, 0 Mois
• Develop ETL/DWH processes to perform data integration according to audit specifications
• Map source system data to the target data warehouse according to audit control (Continuous control Audit).
• Develop and perform tests and validate all data flows and prepare all processes according to business requirements.
• Define and capture metadata and rules associated with ETL processes.
• Provide support and maintenance on ETL/DWH processes and documentation.
Develop, maintain and enhance data integration/import/transformation exisitng
solutions.
• Develop ETL/DWH processes to perform data integration according to business
specification.
• Map source system data to target data warehouse.
• Develop and perform tests and validate all data flows and prepare all processes
according to business requirements.
• Define and capture metadata and rules associated with ETL processes.
• Provide support and maintenance on ETL/DWH processes and documentation
• Analyze business requirements and design propose solution for business intelligence development model
• Lead development on business intelligence software
• Design and develop meta data modeling
• Develop database tables, views and store procedures to build database architecture
• Develop SQL to perform data analysis
• Understanding of business processes primarily finance, and supply chain management
• Development of reports, dashboard, and business scorecard for key functional areas
• Consulting customers on how to migrate legacy data using dspMigrate software
• Mapping data between new system and the legacy system
• Development and coding extraction scripts (for example in Structured Query Language )
• Knowledge about the construction industry and processes
• Maps source, staging and target data architectures to each other including rules and transformations
• Performs trial data migrations into staging
• Take ownership of design, development and testing of all data transformation, extraction and migration activities.
• Work with data owners to verify and obtain approval that any transformed data retains its accuracy
• Install and maintain business intelligence products in development and production environment
• Analyze business requirements and design propose solution for business intelligence development model
• Lead development on business intelligence software
• Develop database tables, views and store procedures to build database architecture
• Develop SQL to perform data analysis
• Write scripts for data transformation
• Performance tuning of production environment, for application and database servers, managing indexes and statistics of tables and views
• Understanding of business processes primarily finance, and supply chain management
• Development of reports, dashboard and business reports for key functional areas
Prime item master
Consulting customers on how to migrate legacy data using dspMigrate software
Mapping data between new system and the legacy system
Development and coding extraction scripts (for example in Structured Query Language )
Knowledge about the construction industry and processes
Maps source, staging and target data architectures to each other including rules and
transformations
Performs trial data migrations into staging
Take ownership of design, development and testing of all data transformation, extraction
and migration activities.
Working with the data architect ensure that all ongoing data transformation, deduplication,
extraction and load functions once ready for production deployment
Work with data owners to verify and obtain approval that any transformed data retains its
accuracy
Design reports the meet business needs.
Write SQL command
Works on one or more tasks/projects as a team member.
Analyzes information or data on current.
Understand a customer's business needs and translate needs into technical requirements.
Design the dashboards
Design the Reports
Producing dashboards and reports
- Design the dashboards according to business need
- Data preparation (sourcing, integration)
- Reporting, analytics, data exploration
providing first line support through taking users’ calls and ensuring that the users are served satisfactorily.
• Installing operating systems and other software.
• Troubleshooting hardware and software problems /faults.
• Replacing the hardware parts as required.
• Following predefine instructions for repair a fault.
• Creating new users' accounts, profiles, email and dealing with password issues.
• Responding for handling customer call and email.
• Working continuously on many tasks until completion or referral to third parties.
• Prioritizing and managing many open cases at one time.
• Ensure that customer is satisfy with the service provide.
• Maintaining a good working relationship with customers and other developer
• Working as middle man between the developer and customer.
• Making the daily and monthly performance report.
• Regression Model Analyze a business problem in the mail-order catalog business in order to predict how much money a company can expect to earn from sending out a catalog to new customers. • Data Wrangling Perform an analysis to recommend the city for Pawdacity’s newest store, based on predicted yearly sales which require to blend and format data and deal with outliers. After that use date to create linear regression model. • Classification Models Classify new customers on whether they can be approved for a loan or not for a list of creditworthy customers to your manager. • A/B Testing Analyze the A/B test and write up a recommendation to whether the Round Roasters chain should launch this new menu. • Time Series Forecasting and Segmentation and Clustering Provide analytical support to make decisions about store cluster and inventory planning. In addition, predict the cluster for each of the new store’s demographic data. Finally, predict accurately monthly sales forecast. • Investigate a Dataset Performing an investigation using python on data and get insight about it. • Practical Statistics (Analyze A/B Test Results) Use an A/B test to determine if company (an e-commerce website) should implement the new page design or continue to use old page and analyze. The goal is to help company to take decision based on data not base on personal judgment. • Data Visualization (Communicate Data Findings) Analyze data for flight by performing an exploratory data analysis in Python (bivariate , univariate and multivariate).
Project2: Investigate a Dataset Performing an investigation using python on data and get insight about it. Part 3: Practical Statistics (Analyze A/B Test Results) Use an A/B test to determine if company (an e-commerce website) should implement the new page design or continue to use old page and analyze. The goal is to help company to take decision based on data not base on personal judgment. Part 4: Data Wrangling (Wrangle and Analyze Data) Gather data from a variety of sources and in a variety of formats for weratedog tweeter account and then assess its quality and tidiness, then clean it. After that I visualize my data to get accurate analysis of data. Part 5: Data Visualization (Communicate Data Findings) Analyze data for flight by performing an exploratory data analysis in Python ( bivariate , univariate and multivariate).