DWH Architect, Analytics Consultant
Mantrac
Total years of experience :19 years, 3 Months
• Provide strategic and tactical guidance with respect to data warehousing best practices and attention to quality documentation within large and mid-market organizations.
• Manage both internal and external resources, timelines, and milestones across a vertical set of industries.
• Provide overall thought leadership to organizations with regards to creative data profiling and integration recommendations.
• Responsible for designing and implementing detailed data warehouse models and data mappings.
• Resolving any and all issues throughout the development lifecycle.
• Perform performance optimization and tuning on new and/or existing data warehouse implementations.
• Provide detailed documentation, end user training and knowledge-transfer services to customers.
• Support annually defined companywide strategic goals aimed at the continued expansion of the Ironside Group.
• Develop and maintain expertise in advanced and/or emerging data warehouse and analytical information technologies such as Hadoop, in-memory analytics, data warehouse appliances, and data warehouse virtualization.
• Continue professional and technical growth through corporate and personnel initiatives.
Main Objective:
• Migrate the traditional DWH (SSIS, SSAS, SSRS) to Cloud-Based Modern DWH using Snowflake, ADF, Power BI.
• Leading and managing production support of an enterprise data warehouse.
• Working closely with project teams to ensure delivered changes are in line with enterprise practices of data warehousing and industry standards.
• Partnering with the organization to streamline how solutions within the EDW can be enhanced to add business value.
• Partnering with the organization to develop and deliver business intelligence operational capability that delivers value driven reporting and insight in conjunction with strategic support unit.
• Remaining current on key technologies, business, and industry trends as it applies to the EDW environments.
• Establishing and enhancing communication channels for issue reporting and resolution.
• Presenting at steering group and similar group meetings around EDW performance, service levels and strategy development -both business intelligence and EDW.
• Work closely with people services for recruiting, selecting, training, assigning, scheduling, coaching EDW team members and creating clear expectations and objectives.
• Developing and maintaining system improvements by analyzing process workflow and monitoring system utilization in conjunction with the EDW technical team.
• Developing, tracking, and managing the annual operating budgets and more specifically the EDW operations budget as defined by the CIO.
• Identifying and driving process improvement opportunities and applicable monitoring reports for implementation by direct reports and staff.
• Defining, staffing, and supporting a team operating model for technical support services for production support.
• Collaborating with leadership to establish measurable individual and team objectives that are aligned with business and organizational goals.
• Partnering with direct reports to establish a career development plan that is aligned to achievement of performance and career goals.
• Ensuring all staff have the resources and skills needed to support all work initiatives.
• Executing change through frequent, communication to staff and clients about the change and the impact of the change (individual and business).
• Anticipating and analyzing trends in technology while assessing the emerging technologies impacts.
• Manage and customize all ETL processes as per customer requirements and analyze all processes for the same.
• Mage all data for transactional sources and prepare effective reports.
• Extending company’s data with third party sources of information when needed.
• Research and manage the development of statistical learning models for data analysis.
• Keep up to date with latest technology trends.
• Managing the implementation of the new statistical or other mathematical methodologies as needed for specific models or analysis.
Responsibilities:
•Accomplishes information technology staff results by communicating job expectations; planning, monitoring, and appraising job results; coaching, counseling, and disciplining employees; initiating, coordinating, and enforcing systems, policies, and procedures.
•Maintains staff by recruiting, selecting, orienting, and training employees; maintaining a safe and secure work environment; developing personal growth opportunities.
•Maintains organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies.
•Directs technological research by studying organization goals, strategies, practices, and user projects.
•Completes projects by coordinating resources and timetables with user departments and data center.
•Verifies application results by conducting system audits of technologies implemented.
•Preserves assets by implementing disaster recovery and back-up procedures and information security and control structures.
•Recommends information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.
•Accomplishes financial objectives by forecasting requirements; preparing an annual budget; scheduling expenditures; analyzing variances; initiating corrective action.
•Maintains quality service by establishing and enforcing organization standards.
•Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
•Contributes to team effort by accomplishing related results as needed.
Quality Assurance responsibilities:
• Uses engineering skills to improve processes
• Develops new processes
• Writes process procedures
• Ensures processes produce quality product
• Reduces process cycle time
• Reduces process costs
• Manages direct reports
Tools and languages used:
1. Microsoft BIDS 2005, 2008 and 2012.
2. Microsoft SQL server 2005, 2008 and 2012.
3. ProClarity analytical reports.
4. Dundas for OLAP.
5. Microsoft Share point 2007, 2010 and 2013.
6. Performance Point 2007, 2010 and 2013.
7. IBM DB2 basic knowledge
8. Board basic development (Budgeting and Planning tool).
9. Self-Service BI (Microsoft Power BI, Excel Services, Power Pivot and Power BI for Mobile).
Key achievements:
1- Automation of Budget Process:
Automating the budget process for the entire group using Board system. My responsibilities:
a- Analysing the budgeting and planning process with the finance team.
b- Creating the procedures to extract the financial data from the Data warehouse.
c- Track and manage programs to improve process automation health metrics such as alarms/operator.
d- Identify technical problems and the appropriate solutions.
e- Creating the needed reports for the finance team.
f- Providing necessary change and support documentation.
2 - Finance Department:
1- Finance Booklet data mart:
Booklet is a collection of reports that shows the company's financial statement that indicates how the revenue is transformed into the net income with various parameters such (Territory, segment, etc.).
2- Finance Operating statement and expenses statement.(P&L reports)
3- WSR (weekly sales report).
4- Finance KPIs.
5- ROI.
6- RGP (Realized GP).
7- Stock and Receivable Aging.
3 - Prime Product data mart:
Shows the weekly, monthly and yearly sales and COGS for the Prime Product of the company.
4 - Product Support data mart:
Shows the weekly, monthly and yearly sales and COGS for the Parts sales.
5 - Technician data mart:
6 - WIP (Work in Process) data mart:
7 - CSA (Customer Service Agreement) data mart:
8 - Marketing Department:
9 - Population data mart:
Shows the number of customers and their information’s per Product sales.
10 - Samsung Department (Based on Axapta ERP System):
My responsibilities included:
1- Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
2- Analyze & translate functional specifications & change requests into technical specifications.
3- Develop, test & implement ETLs.
4- Translate business needs into end user applications.
5- Migrating the date from old systems to the new ones with the new format (Oracle Business Suite).
Tools and languages used:
1- Microsoft BIDS 2005, 2008.
2- Microsoft SQL server 2005, 2008.
3- Oracle 10g (Toad).
4- IBM Cognos 10 (Framework manager).
Key achievements:
Client: Jeddah Municipality (KSA) - onsite support - Senior BI Developer.
1- Contribute in gathering technical requirements from different departments.
2- Design and develop flow diagrams, Data Warehouse, Data Marts, ETL Packages.
3- Migrating the date from old systems to the new ones.
4- Designing report models to help business users create their own reports.
5- Ensure that unit, load, and performance testing and tune package are done correctly to maximize performance.
6- Provide BI training sessions
7- Implementing data warehouse for the following Oracle systems:
1- CTS (Citizen Request Documents)
2- OS (Office Registration System).
3- Store Licences.
4- OMEGA (Oracle Financial System).
5- Monitoring System.
6- 940 (Call Centre System).
7- Attendance System.
8- Government Projects System.
9- MP (Governor Prizes System).
10- .Oracle HRMS.
1 - Designing data warehouses and data marts for all departments with various business concepts.
2 - Designing dashboards and reports for top management.
3 - Manage end to end delivery concerning data warehouse in business intelligence projects.
4 - Reduce risk in cost, budget and management.
5 - Improve data warehouse designs using ETL design standards.
6 - Manage Data warehouse and Business Intelligence for Top management.
7 - Avoid Projects, programs and area risk collapse.
8 - Improve data quality through implementing Data Rejection guidelines
9 - Improve Supplier Performance Analysis by shutting the logistics data gathering gaps.
10 -Supporting the BI users by teaching them how to use the various Dashboards and reports.
11- Provide day-to-day technical support to Business Intelligence seniors and developers, and other IT resources to solve problems, provide guidance and direction and develop new skills in others.
12 - Translating high-level business requirements into detailed functional specifications and managing requests for changes to the specifications
13 - Determining which business requirements should be automated and how they can be integrated with other business and technical processes.
14 - Executing cross-functional Business Intelligence and Enterprise projects by closely interacting with the Business Intelligence leaders, managers and consultants.
15 - Working directly with business owners and IT staff to identify, rationalize, and document reporting requirements.
16 - Translate reporting requirements into functional specifications which detail the approach taken to address and resolve business needs.
17 - Executing projects utilizing IT project management methodology, owning project lifecycle and coordinating business owner inputs (requirements, testing, and signoff).
18 - Obtaining and maintaining technical understanding of the application suites in addition to how the business uses this information and the data flows from system to system.
19 - Identifying critical data accuracy projects to drive analytics improvements to ensure consistent and accurate reporting across the business, and align projects to overall Business Intelligence vision.
20 - End User Support:
a) Translating customer needs into requirements
b) Managing changes to requirements.
c) Ensure that customer requests for information are addressed and follow up occurs.
d) Gain customer satisfaction.
e) Understanding business objectives of departments.
f) Evaluating and recommending application systems that can improve department’s environment.
1 - Developing:
1 - Windows application using Microsoft Visual Studio 2005.
2 - Web application using Microsoft Visual Studio 2005 (ASP.Net).
3 - Designing Databases using Microsoft SQL Server 2000, 2005.
2 - Teaching:
1- MCAD (Microsoft Certified Application Developer)
2- MCSD (Microsoft Certified Solution Developer)
3- MCDBA (Microsoft Certified Database Administrator)
4- System analysis
5- RDBMS (Relational Database Management System)
6- XML family.